I am all the way down to the session(save) statement when this error occurs.

The insert SQL is somehow failing.

I have read posts related to reserve keywords but I cannot identify any particular column name I am using in error. I also checked the foreign key tables just in case. Here are the insert table columns for clarity and second-guessing (see output below):

I double-checked by copying the insert statement from the formatted hibernate output shown here (replacing the ?s with actual values) to my sql editor and it ran just fine:

Hibernate:
insert
into
Character
(CHARACTERCLASS, ETHNICPERSUASION, FIRSTNAME, LASTNAME, LEVEL, MIDDLENAME, RACE, SUFFIX, TITLE)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?)

I have seen other posts where this hibernate output was followed by specific bind output which is conspicuously missing here (maybe only shows in JNDI?).

Currently, I am running with JDBC to localhost MySQL. I do notice the JNDI factory is not named but that is only a warning and I am not using JNDI (yet). I wanted a raw success using just JDBC first.

I will note that sql editor and other db functions have no issue with my naming a table 'character' and the insert works just fine(in sql editor). There is no column named that.

Version Info:
Eclipse Helios 20100617-1415
MySQL 5.2.27
MySQL Connector(J) 5.1.13
Hibernate 3.5.6

Annotated java class:

@Entity(name="Character")
@Table(name="Character", uniqueConstraints = {
@UniqueConstraint(columnNames = "IDCHARACTER")})
public class Character {
private int characterId; //primary key
private Race race; // foreign key to race table
private CharacterClass characterClass; // foreign key to characterclass table
private String Title;
private String FirstName;
private String MiddleName;
private String LastName;
private String Suffix;
private Integer EthnicPersuasion;
private Integer Level;

@Id
@Column(name = "IDCHARACTER", unique = true, nullable = false)
@GeneratedValue(strategy = GenerationType.AUTO)
public int getIdCharacter() {
return characterId;
}
public void setIdCharacter(int characterId) {
this.characterId = characterId;
}

@ManyToOne(fetch = FetchType.LAZY, targetEntity = database_tables.Race.class)
@JoinColumn(name = "RACE", nullable = false)
public Race getRace() {
return this.race;
}
public void setRace(Race race) {
this.race = race;
}

@ManyToOne(fetch = FetchType.LAZY, targetEntity = database_tables.CharacterClass.class)
@JoinColumn(name = "CHARACTERCLASS", nullable = false)
public CharacterClass getCharacterClass() {
return this.characterClass;
}
public void setCharacterClass(CharacterClass characterClass) {
this.characterClass = characterClass;
}

@Column(name="TITLE", nullable=true, length=12)
public String getTitle() {
return Title;
}
public error setTitle(String title){
Title = title;
return error.NO_ERROR;
}

@Column(name="FIRSTNAME", nullable=true, length=45)
public String getFirstName() {
return FirstName;
}
public error setFirstName(String firstname){
FirstName = firstname;
return error.NO_ERROR;
}

@Column(name="MIDDLENAME", nullable=true, length=45)
public String getMiddleName() {
return MiddleName;
}
public error setMiddleName(String middlename){
MiddleName = middlename;
return error.NO_ERROR;
}

@Column(name="LASTNAME", nullable=false, length=45)
public String getLastName() {
return LastName;
}
public error setLastName(String lastname){
LastName = lastname;
return error.NO_ERROR;
}

@Column(name="SUFFIX", nullable=true, length=12)
public String getSuffix() {
return Suffix;
}
public error setSuffix(String suffix){
Suffix = suffix;
return error.NO_ERROR;
}

@Column(name="ETHNICPERSUASION", nullable=false)
public int getEthnicPersuasion(){
return EthnicPersuasion;
}
public error setEthnicPersuasion(int ethnicpersuasion){
EthnicPersuasion = ethnicpersuasion;
return error.NO_ERROR;
}

@Column(name="LEVEL", nullable=false)
public int getLevel() {
return Level;
}
public error setLevel(int level){
Level = level;
return error.NO_ERROR;
}
}

hibernate.cfg.xml:

version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory name="">
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/dnd4echaracter</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password">qwerty1</property>
<property name="hibernate.connection.pool_size">10</property>
<property name="current_session_context_class">thread</property>
<property name="hibernate.show_sql">true</property>
<property name="format_sql">true</property>

<!-- <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property> -->
<property name="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>
<mapping package="database_tables"/>
<mapping class="database_tables.Character"/>
<mapping class="database_tables.CharacterClass"/>
<mapping class="database_tables.Race"/>
<mapping class="database_tables.Size"/>
<mapping class="database_tables.Vision"/>
<mapping class="database_tables.CharacterOrigin"/>
</session-factory>
</hibernate-configuration>

Any help is greatly appreciated.

The trace for annoying completeness:

0 [main] INFO org.hibernate.cfg.annotations.Version - Hibernate Annotations 3.5.6-Final
46 [main] INFO org.hibernate.cfg.Environment - Hibernate 3.5.6-Final
62 [main] INFO org.hibernate.cfg.Environment - loaded properties from resource hibernate.properties: {hibernate.bytecode.use_reflection_optimizer=false}
62 [main] INFO org.hibernate.cfg.Environment - Bytecode provider name : javassist
78 [main] INFO org.hibernate.cfg.Environment - using JDK 1.4 java.sql.Timestamp handling
328 [main] INFO org.hibernate.annotations.common.Version - Hibernate Commons Annotations 3.2.0.Final
343 [main] INFO org.hibernate.cfg.Configuration - configuring from resource: /hibernate.cfg.xml
343 [main] INFO org.hibernate.cfg.Configuration - Configuration resource: /hibernate.cfg.xml
531 [main] INFO org.hibernate.cfg.AnnotationConfiguration - Mapping package database_tables
578 [main] WARN org.hibernate.cfg.AnnotationBinder - Package not found or wo package-info.java: database_tables
609 [main] INFO org.hibernate.cfg.Configuration - Configured SessionFactory:
656 [main] INFO org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.MySQLInnoDBDialect
750 [main] INFO org.hibernate.tool.hbm2ddl.SchemaValidator - Running schema validator
750 [main] INFO org.hibernate.tool.hbm2ddl.SchemaValidator - fetching database metadata
750 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - Using Hibernate built-in connection pool (not for production use!)
750 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - Hibernate connection pool size: 10
750 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - autocommit mode: false
781 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost:3306/dnd4echaracter
781 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - connection properties: {user=root, password=****}
1343 [main] INFO org.hibernate.cfg.AnnotationBinder - Binding entity from annotated class: database_tables.Character
1453 [main] INFO org.hibernate.cfg.annotations.EntityBinder - Bind entity database_tables.Character on table Character
1640 [main] INFO org.hibernate.cfg.AnnotationBinder - Binding entity from annotated class: database_tables.CharacterClass
1640 [main] INFO org.hibernate.cfg.annotations.EntityBinder - Bind entity database_tables.CharacterClass on table CharacterClass
1640 [main] INFO org.hibernate.cfg.AnnotationBinder - Binding entity from annotated class: database_tables.Race
1640 [main] INFO org.hibernate.cfg.annotations.EntityBinder - Bind entity database_tables.Race on table Race
1656 [main] INFO org.hibernate.cfg.AnnotationBinder - Binding entity from annotated class: database_tables.Size
1656 [main] INFO org.hibernate.cfg.annotations.EntityBinder - Bind entity database_tables.Size on table Size
1671 [main] INFO org.hibernate.cfg.AnnotationBinder - Binding entity from annotated class: database_tables.Vision
1671 [main] INFO org.hibernate.cfg.annotations.EntityBinder - Bind entity database_tables.Vision on table Vision
1671 [main] INFO org.hibernate.cfg.AnnotationBinder - Binding entity from annotated class: database_tables.CharacterOrigin
1671 [main] INFO org.hibernate.cfg.annotations.EntityBinder - Bind entity database_tables.CharacterOrigin on table CharacterOrigin
1734 [main] INFO org.hibernate.cfg.AnnotationConfiguration - Hibernate Validator not found: ignoring
1796 [main] INFO org.hibernate.tool.hbm2ddl.TableMetadata - table found: dnd4echaracter.character
1796 [main] INFO org.hibernate.tool.hbm2ddl.TableMetadata - columns: [title, level, middlename, idcharacter, lastname, firstname, characterclass, ethnicpersuasion, suffix, race]
1828 [main] INFO org.hibernate.tool.hbm2ddl.TableMetadata - table found: dnd4echaracter.characterclass
1828 [main] INFO org.hibernate.tool.hbm2ddl.TableMetadata - columns: [idcharacterclass, healingsurgesperday, hitsatfirst, bonusreflex, bonuswill, classname, bonusfortitude, origin, hitsperlevel]
1843 [main] INFO org.hibernate.tool.hbm2ddl.TableMetadata - table found: dnd4echaracter.characterorigin
1843 [main] INFO org.hibernate.tool.hbm2ddl.TableMetadata - columns: [description, idcharacterorigin, label]
1890 [main] INFO org.hibernate.tool.hbm2ddl.TableMetadata - table found: dnd4echaracter.race
1890 [main] INFO org.hibernate.tool.hbm2ddl.TableMetadata - columns: [racedescription, speed, idrace, vision, racename, weightlow, strength, heightlow, wisdom, origin, heighthigh, dexterity, size, charisma, weighthigh, constitution, intelligence]
1906 [main] INFO org.hibernate.tool.hbm2ddl.TableMetadata - table found: dnd4echaracter.size
1921 [main] INFO org.hibernate.tool.hbm2ddl.TableMetadata - columns: [squareshigh, squareslong, squareswide, idsize, size]
1937 [main] INFO org.hibernate.tool.hbm2ddl.TableMetadata - table found: dnd4echaracter.vision
1937 [main] INFO org.hibernate.tool.hbm2ddl.TableMetadata - columns: [visiontype, idvision]
1937 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - cleaning up connection pool: jdbc:mysql://localhost:3306/dnd4echaracter
8468 [AWT-EventQueue-0] INFO org.hibernate.cfg.Configuration - configuring from resource: /hibernate.cfg.xml
8468 [AWT-EventQueue-0] INFO org.hibernate.cfg.Configuration - Configuration resource: /hibernate.cfg.xml
Saving Kylin
Building SessionFactory
8500 [AWT-EventQueue-0] INFO org.hibernate.cfg.AnnotationConfiguration - Mapping package database_tables
8500 [AWT-EventQueue-0] WARN org.hibernate.cfg.AnnotationBinder - Package not found or wo package-info.java: database_tables
8500 [AWT-EventQueue-0] INFO org.hibernate.cfg.Configuration - Configured SessionFactory:
8515 [AWT-EventQueue-0] INFO org.hibernate.cfg.search.HibernateSearchEventListenerRegister - Unable to find org.hibernate.search.event.FullTextIndexEventListener on the classpath. Hibernate Search is not enabled.
8515 [AWT-EventQueue-0] INFO org.hibernate.cfg.AnnotationBinder - Binding entity from annotated class: database_tables.Character
8515 [AWT-EventQueue-0] INFO org.hibernate.cfg.annotations.EntityBinder - Bind entity database_tables.Character on table Character
8531 [AWT-EventQueue-0] INFO org.hibernate.cfg.AnnotationBinder - Binding entity from annotated class: database_tables.CharacterClass
8531 [AWT-EventQueue-0] INFO org.hibernate.cfg.annotations.EntityBinder - Bind entity database_tables.CharacterClass on table CharacterClass
8546 [AWT-EventQueue-0] INFO org.hibernate.cfg.AnnotationBinder - Binding entity from annotated class: database_tables.Race
8546 [AWT-EventQueue-0] INFO org.hibernate.cfg.annotations.EntityBinder - Bind entity database_tables.Race on table Race
8562 [AWT-EventQueue-0] INFO org.hibernate.cfg.AnnotationBinder - Binding entity from annotated class: database_tables.Size
8562 [AWT-EventQueue-0] INFO org.hibernate.cfg.annotations.EntityBinder - Bind entity database_tables.Size on table Size
8562 [AWT-EventQueue-0] INFO org.hibernate.cfg.AnnotationBinder - Binding entity from annotated class: database_tables.Vision
8562 [AWT-EventQueue-0] INFO org.hibernate.cfg.annotations.EntityBinder - Bind entity database_tables.Vision on table Vision
8562 [AWT-EventQueue-0] INFO org.hibernate.cfg.AnnotationBinder - Binding entity from annotated class: database_tables.CharacterOrigin
8562 [AWT-EventQueue-0] INFO org.hibernate.cfg.annotations.EntityBinder - Bind entity database_tables.CharacterOrigin on table CharacterOrigin
8578 [AWT-EventQueue-0] INFO org.hibernate.cfg.AnnotationConfiguration - Hibernate Validator not found: ignoring
8578 [AWT-EventQueue-0] INFO org.hibernate.connection.DriverManagerConnectionProvider - Using Hibernate built-in connection pool (not for production use!)
8578 [AWT-EventQueue-0] INFO org.hibernate.connection.DriverManagerConnectionProvider - Hibernate connection pool size: 10
8578 [AWT-EventQueue-0] INFO org.hibernate.connection.DriverManagerConnectionProvider - autocommit mode: false
8578 [AWT-EventQueue-0] INFO org.hibernate.connection.DriverManagerConnectionProvider - using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost:3306/dnd4echaracter
8578 [AWT-EventQueue-0] INFO org.hibernate.connection.DriverManagerConnectionProvider - connection properties: {user=root, password=****}
8640 [AWT-EventQueue-0] INFO org.hibernate.cfg.SettingsFactory - RDBMS: MySQL, version: 5.1.50-community
8640 [AWT-EventQueue-0] INFO org.hibernate.cfg.SettingsFactory - JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.1.13 ( Revision: ${bzr.revision-id} )
8718 [AWT-EventQueue-0] INFO org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.MySQLInnoDBDialect
8734 [AWT-EventQueue-0] INFO org.hibernate.engine.jdbc.JdbcSupportLoader - Disabling contextual LOB creation as JDBC driver reported JDBC version [3] less than 4
8734 [AWT-EventQueue-0] INFO org.hibernate.transaction.TransactionFactoryFactory - Using default transaction strategy (direct JDBC transactions)
8734 [AWT-EventQueue-0] INFO org.hibernate.transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
8734 [AWT-EventQueue-0] INFO org.hibernate.cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled
8734 [AWT-EventQueue-0] INFO org.hibernate.cfg.SettingsFactory - Automatic session close at end of transaction: disabled
8734 [AWT-EventQueue-0] INFO org.hibernate.cfg.SettingsFactory - JDBC batch size: 15
8734 [AWT-EventQueue-0] INFO org.hibernate.cfg.SettingsFactory - JDBC batch updates for versioned data: disabled
8734 [AWT-EventQueue-0] INFO org.hibernate.cfg.SettingsFactory - Scrollable result sets: enabled
8734 [AWT-EventQueue-0] INFO org.hibernate.cfg.SettingsFactory - JDBC3 getGeneratedKeys(): enabled
8734 [AWT-EventQueue-0] INFO org.hibernate.cfg.SettingsFactory - Connection release mode: auto
8734 [AWT-EventQueue-0] INFO org.hibernate.cfg.SettingsFactory - Maximum outer join fetch depth: 2
8750 [AWT-EventQueue-0] INFO org.hibernate.cfg.SettingsFactory - Default batch fetch size: 1
8750 [AWT-EventQueue-0] INFO org.hibernate.cfg.SettingsFactory - Generate SQL with comments: disabled
8750 [AWT-EventQueue-0] INFO org.hibernate.cfg.SettingsFactory - Order SQL updates by primary key: disabled
8750 [AWT-EventQueue-0] INFO org.hibernate.cfg.SettingsFactory - Order SQL inserts for batching: disabled
8750 [AWT-EventQueue-0] INFO org.hibernate.cfg.SettingsFactory - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
8750 [AWT-EventQueue-0] INFO org.hibernate.hql.ast.ASTQueryTranslatorFactory - Using ASTQueryTranslatorFactory
8750 [AWT-EventQueue-0] INFO org.hibernate.cfg.SettingsFactory - Query language substitutions: {}
8750 [AWT-EventQueue-0] INFO org.hibernate.cfg.SettingsFactory - JPA-QL strict compliance: disabled
8750 [AWT-EventQueue-0] INFO org.hibernate.cfg.SettingsFactory - Second-level cache: enabled
8750 [AWT-EventQueue-0] INFO org.hibernate.cfg.SettingsFactory - Query cache: disabled
8750 [AWT-EventQueue-0] INFO org.hibernate.cfg.SettingsFactory - Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory
8750 [AWT-EventQueue-0] INFO org.hibernate.cfg.SettingsFactory - Optimize cache for minimal puts: disabled
8750 [AWT-EventQueue-0] INFO org.hibernate.cfg.SettingsFactory - Structured second-level cache entries: disabled
8750 [AWT-EventQueue-0] INFO org.hibernate.cfg.SettingsFactory - Echoing all SQL to stdout
8765 [AWT-EventQueue-0] INFO org.hibernate.cfg.SettingsFactory - Statistics: disabled
8765 [AWT-EventQueue-0] INFO org.hibernate.cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled
8765 [AWT-EventQueue-0] INFO org.hibernate.cfg.SettingsFactory - Default entity-mode: pojo
8765 [AWT-EventQueue-0] INFO org.hibernate.cfg.SettingsFactory - Named query checking : enabled
8765 [AWT-EventQueue-0] INFO org.hibernate.cfg.SettingsFactory - Check Nullability in Core (should be disabled when Bean Validation is on): enabled
8875 [AWT-EventQueue-0] INFO org.hibernate.impl.SessionFactoryImpl - building session factory
9453 [AWT-EventQueue-0] INFO org.hibernate.impl.SessionFactoryObjectFactory - Factory name:
9453 [AWT-EventQueue-0] INFO org.hibernate.util.NamingHelper - JNDI InitialContext properties:{}
9468 [AWT-EventQueue-0] WARN org.hibernate.impl.SessionFactoryObjectFactory - Could not bind factory to JNDI
javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial
at javax.naming.spi.NamingManager.getInitialContext(Unknown Source)
at javax.naming.InitialContext.getDefaultInitCtx(Unknown Source)
at javax.naming.InitialContext.getURLOrDefaultInitCtx(Unknown Source)
at javax.naming.InitialContext.getNameParser(Unknown Source)
at org.hibernate.util.NamingHelper.bind(NamingHelper.java:75)
at org.hibernate.impl.SessionFactoryObjectFactory.addInstance(SessionFactoryObjectFactory.java:113)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:378)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1385)
at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:954)
at User_Interface.GUI$btnSaveAction.actionPerformed(GUI.java:287)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Inserting Record
Hibernate:
select
race0_.IDRACE as IDRACE8_0_,
race0_.CHARISMA as CHARISMA8_0_,
race0_.CONSTITUTION as CONSTITU3_8_0_,
race0_.DEXTERITY as DEXTERITY8_0_,
race0_.HEIGHTHIGH as HEIGHTHIGH8_0_,
race0_.HEIGHTLOW as HEIGHTLOW8_0_,
race0_.INTELLIGENCE as INTELLIG7_8_0_,
race0_.ORIGIN as ORIGIN8_0_,
race0_.RACEDESCRIPTION as RACEDESC8_8_0_,
race0_.RACENAME as RACENAME8_0_,
race0_.SIZE as SIZE8_0_,
race0_.STRENGTH as STRENGTH8_0_,
race0_.VISION as VISION8_0_,
race0_.WEIGHTHIGH as WEIGHTHIGH8_0_,
race0_.WEIGHTLOW as WEIGHTLOW8_0_,
race0_.WISDOM as WISDOM8_0_
from
Race race0_
where
race0_.IDRACE=?
Hibernate:
select
characterc0_.IDCHARACTERCLASS as IDCHARAC1_7_0_,
characterc0_.BONUSFORTITUDE as BONUSFOR2_7_0_,
characterc0_.BONUSREFLEX as BONUSREF3_7_0_,
characterc0_.BONUSWILL as BONUSWILL7_0_,
characterc0_.CLASSNAME as CLASSNAME7_0_,
characterc0_.HEALINGSURGESPERDAY as HEALINGS6_7_0_,
characterc0_.HITSATFIRST as HITSATFI7_7_0_,
characterc0_.HITSPERLEVEL as HITSPERL8_7_0_,
characterc0_.ORIGIN as ORIGIN7_0_
from
CharacterClass characterc0_
where
characterc0_.IDCHARACTERCLASS=?
IdCharacter = :0
CharacterClass = :Paladin
EthnicPersuasion = :1
Race = :Dragonborn
Title = :
FirstName = :Kylin
MiddleName = :
LastName = :Tarkin
Suffix = :
181390 [Finalizer] INFO org.hibernate.connection.DriverManagerConnectionProvider - cleaning up connection pool: jdbc:mysql://localhost:3306/dnd4echaracter
Hibernate:
insert
into
Character
(CHARACTERCLASS, ETHNICPERSUASION, FIRSTNAME, LASTNAME, LEVEL, MIDDLENAME, RACE, SUFFIX, TITLE)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?)
181484 [AWT-EventQueue-0] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 1064, SQLState: 42000
181484 [AWT-EventQueue-0] ERROR org.hibernate.util.JDBCExceptionReporter - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Character (CHARACTERCLASS, ETHNICPERSUASION, FIRSTNAME, LASTNAME, LEVEL, MIDDLEN' at line 1

I think it is not happy with Character as it may refer to MySQL data type.

Well I went through all the gyrations necessary to rename the table.

I expected that it wouldnt be so easy.

But ...

You were right.

It was just the table name.

Thanks a bunch! It's working!