初用Hibernate3,高分求教故障原因

Question

出现如下异常：
输出结果：
22:14:28,187  INFO Environment:456 - Hibernate 3.0rc1
22:14:28,203  INFO Environment:474 - loaded properties from resource hibernate.properties: {hibernate.order_updates=true, hibernate.default_batch_fetch_size=8, hibernate.connection.driver_class=org.gjt.mm.mysql.Driver, hibernate.cglib.use_reflection_optimizer=true, hibernate.cache.provider_class=org.hibernate.cache.HashtableCacheProvider, hibernate.max_fetch_depth=1, hibernate.dialect=org.hibernate.dialect.MySQLDialect, hibernate.jdbc.use_streams_for_binary=true, hibernate.query.substitutions=true 1, false 0, yes 'Y', no 'N', hibernate.proxool.pool_alias=pool1, hibernate.connection.username=root, hibernate.cache.region_prefix=hibernate.test, hibernate.connection.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=GBK , hibernate.connection.password=****, hibernate.jdbc.batch_versioned_data=true, hibernate.connection.pool_size=1}
22:14:28,203  INFO Environment:501 - using java.io streams to persist binary types
22:14:28,203  INFO Environment:502 - using CGLIB reflection optimizer
22:14:28,203  INFO Environment:532 - using JDK 1.4 java.sql.Timestamp handling
22:14:28,203  INFO Configuration:1228 - configuring from resource: /hibernate.cfg.xml
22:14:28,203  INFO Configuration:1199 - Configuration resource: /hibernate.cfg.xml
22:14:28,546  INFO Configuration:439 - Mapping resource: Customer.hbm.xml
22:14:28,687  INFO HbmBinder:256 - Mapping class: Customer -> CUSTOMER
22:14:28,718  INFO Configuration:1340 - Configured SessionFactory: null
22:14:28,718  INFO Configuration:844 - processing extends queue
22:14:28,718  INFO Configuration:848 - processing collection mappings
22:14:28,718  INFO Configuration:857 - processing association property references
22:14:28,718  INFO Configuration:884 - processing foreign key constraints
22:14:28,796  INFO Dialect:89 - Using dialect: org.hibernate.dialect.MySQLInnoDBDialect
22:14:28,812  INFO SettingsFactory:87 - Maximum outer join fetch depth: 1
22:14:28,812  INFO SettingsFactory:90 - Default batch fetch size: 8
22:14:28,812  INFO SettingsFactory:94 - Generate SQL with comments: disabled
22:14:28,812  INFO SettingsFactory:98 - Order SQL updates by primary key: enabled
22:14:28,812  INFO SettingsFactory:273 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
22:14:28,812  INFO ASTQueryTranslatorFactory:21 - Using ASTQueryTranslatorFactory
22:14:28,812  INFO SettingsFactory:106 - Query language substitutions: {no='N', true=1, yes='Y', false=0}
22:14:28,812  INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
22:14:28,812  INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 1
22:14:28,812  INFO DriverManagerConnectionProvider:45 - autocommit mode: false
22:14:28,828  INFO DriverManagerConnectionProvider:80 - using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost:3306/test
22:14:28,828  INFO DriverManagerConnectionProvider:86 - connection properties: {user=root, password=****}
22:14:29,046  INFO SettingsFactory:148 - JDBC batch size: 15
22:14:29,046  INFO SettingsFactory:151 - JDBC batch updates for versioned data: enabled
22:14:29,046  INFO SettingsFactory:156 - Scrollable result sets: enabled
22:14:29,046  INFO SettingsFactory:164 - JDBC3 getGeneratedKeys(): enabled
22:14:29,062  INFO TransactionFactoryFactory:31 - Using default transaction strategy (direct JDBC transactions)
22:14:29,062  INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
22:14:29,062  INFO SettingsFactory:176 - Automatic flush during beforeCompletion(): disabled
22:14:29,062  INFO SettingsFactory:179 - Automatic session close at end of transaction: disabled
22:14:29,062  INFO SettingsFactory:260 - Cache provider: org.hibernate.cache.HashtableCacheProvider
22:14:29,062  INFO SettingsFactory:187 - Second-level cache: enabled
22:14:29,062  INFO SettingsFactory:192 - Optimize cache for minimal puts: disabled
22:14:29,062  INFO SettingsFactory:196 - Cache region prefix: hibernate.test
22:14:29,062  INFO SettingsFactory:199 - Structured second-level cache entries: enabled
22:14:29,062  INFO SettingsFactory:203 - Query cache: disabled
22:14:29,062  INFO SettingsFactory:210 - Echoing all SQL to stdout
22:14:29,062  INFO SettingsFactory:214 - Statistics: disabled
22:14:29,062  INFO SettingsFactory:218 - Deleted entity synthetic identifier rollback: disabled
22:14:29,078  INFO SettingsFactory:232 - Default entity-mode: pojo
22:14:29,218  INFO SessionFactoryImpl:140 - building session factory
22:14:29,500  INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
22:14:29,500  INFO SessionFactoryImpl:366 - Checking 0 named queries
Hibernate: insert into CUSTOMER (USERNAME, PASSWORD, CID) values (?, ?, ?)
Hibernate: insert into CUSTOMER (USERNAME, PASSWORD, CID) values (?, ?, ?)
Hibernate: insert into CUSTOMER (USERNAME, PASSWORD, CID) values (?, ?, ?)
Hibernate: insert into CUSTOMER (USERNAME, PASSWORD, CID) values (?, ?, ?)
Hibernate: insert into CUSTOMER (USERNAME, PASSWORD, CID) values (?, ?, ?)
Hibernate: insert into CUSTOMER (USERNAME, PASSWORD, CID) values (?, ?, ?)
Hibernate: insert into CUSTOMER (USERNAME, PASSWORD, CID) values (?, ?, ?)
Hibernate: insert into CUSTOMER (USERNAME, PASSWORD, CID) values (?, ?, ?)
Hibernate: insert into CUSTOMER (USERNAME, PASSWORD, CID) values (?, ?, ?)
Hibernate: insert into CUSTOMER (USERNAME, PASSWORD, CID) values (?, ?, ?)
Hibernate: insert into CUSTOMER (USERNAME, PASSWORD, CID) values (?, ?, ?)
Hibernate: insert into CUSTOMER (USERNAME, PASSWORD, CID) values (?, ?, ?)
Hibernate: insert into CUSTOMER (USERNAME, PASSWORD, CID) values (?, ?, ?)
Hibernate: insert into CUSTOMER (USERNAME, PASSWORD, CID) values (?, ?, ?)
Hibernate: insert into CUSTOMER (USERNAME, PASSWORD, CID) values (?, ?, ?)

Answer 1

22:14:29,625  WARN JDBCExceptionReporter:57 - SQL Error: 1210, SQLState: S1000
22:14:29,625 ERROR JDBCExceptionReporter:58 - General error message from server: "Incorrect arguments to mysql_stmt_execute"
org.hibernate.exception.GenericJDBCException: could not insert: [Customer]
at org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:92)
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:80)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1839)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2171)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:669)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:293)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
at Test.main(Test.java:31)
Caused by: java.sql.BatchUpdateException: General error message from server: "Incorrect arguments to mysql_stmt_execute"
at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:743)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:57)
at org.hibernate.jdbc.BatchingBatcher.addToBatch(BatchingBatcher.java:33)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1823)
... 11 more
22:14:29,640 ERROR AbstractFlushingEventListener:277 - Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: could not insert: [Customer]
at org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:92)
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:80)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1839)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2171)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:669)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:293)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
at Test.main(Test.java:31)
Caused by: java.sql.BatchUpdateException: General error message from server: "Incorrect arguments to mysql_stmt_execute"
at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:743)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:57)
at org.hibernate.jdbc.BatchingBatcher.addToBatch(BatchingBatcher.java:33)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1823)
... 11 more数据库内容：
mysql> desc customer;
+----------+-------------+------+-----+---------+-------+
| Field    | Type        | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| CID      | int(11)     |      | PRI | 0       |       |
| USERNAME | varchar(12) |      |     |         |       |
| PASSWORD | varchar(12) | YES  |     | NULL    |       |
+----------+-------------+------+-----+---------+-------+

Answer 2

我也遇到过这样的问题，你用jbuilder编译文件，然后就没问题，

Answer 3

我使用的是Eclipse，难道Eclipse不行吗？

Answer 4

后来改了一段代码进行测试
Transaction tx = session.beginTransaction();
     Cat princess = new Cat();
     princess.setName("Princess");
   princess.setSex('F');
   princess.setWeight(7.4f);
   System.out.println("ok1...................");
   session.save(princess);
  System.out.println("ok2...................");
  System.out.println(tx.toString());
 tx.commit();
 System.out.println("ok3...................");
 HibernateUtil.closeSession();
}catch(Exception e)
{
e.printStackTrace();
}
没有抛出异常但是没有运行完全，什么原因有人知道吗？
09:42:00,312  INFO SessionFactoryImpl:366 - Checking 0 named queries
ok1...................
ok2...................
org.hibernate.transaction.JDBCTransaction@114e777
Hibernate: insert into CAT (NAME, sex, weight, CAT_ID) values (?, ?, ?, ?)

Answer 5

我是按照hibernate官方网站hibernate3的文档里的第一个例子写的怎么就运行不了呢？有人遇到这种情况吗？