Thanks in advance!

Hibernate version:3.2.1

Mapping documents:
14:52:09,781 INFO Configuration:553 - Reading mappings from resource : customers/WriteCustomer.hbm.xml
14:52:09,921 INFO HbmBinder:300 - Mapping class: customers.WriteCustomer -> Import_Customer_Cards

Code between sessionFactory.openSession() and session.close():
String _CardID = CoLastName;
Session session = HibernateUtil.getSessionFactory().getCurrentSession();

Transaction tx = session.beginTransaction();

WriteCustomer writeCustomer = new WriteCustomer();

writeCustomer.setCoLastName(CoLastName);
writeCustomer.setFirstName(FirstName);
writeCustomer.setCardID(_CardID);
writeCustomer.setId(_CardID);

session.save(writeCustomer);
session.flush();
tx.commit();
session.close();

Full stack trace of any exception that occurs:
Exception in thread "main" org.hibernate.TransactionException: JDBC commit failed
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:130)
at customers.CustomerManager.createAndStoreEvent(CustomerManager.java:41)
at customers.CustomerManager.main(CustomerManager.java:19)
Caused by: java.sql.SQLException: General error
at sun.jdbc.odbc.JdbcOdbc.throwGenericSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLTransact(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.commit(Unknown Source)
at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:139)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115)
... 2 more
14:52:20,000 ERROR JDBCTransaction:124 - JDBC commit failed
java.sql.SQLException: General error
at sun.jdbc.odbc.JdbcOdbc.throwGenericSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLTransact(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.commit(Unknown Source)
at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:139)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115)
at customers.CustomerManager.createAndStoreEvent(CustomerManager.java:41)
at customers.CustomerManager.main(CustomerManager.java:19)


Name and version of the database you are using:
14:52:17,515 INFO SettingsFactory:81 - RDBMS: OpenRDA, version: 5.50.20.0
14:52:17,656 INFO SettingsFactory:82 - JDBC driver: JDBC-ODBC Bridge (odbcmyob), version: 2.0001 (6.0.0013)
14:52:17,937 INFO Dialect:151 - Using dialect: org.hibernate.dialect.MYOBDialect

The generated SQL (show_sql=true):
Hibernate:
insert
into
Import_Customer_Cards
(CoLastName, CardID, FirstName, CardNumber)
values
(?, ?, ?, ?)

Hi adam_j_bradley,


GenericSQLException comes when Database colunm and corresponding property in HBM mismatch or Class Type mismatch .Plzz. Re check your mapping