I'm trying to run the supplied example "eg" with Mckoi database.
Hibernate version:
3.0.5
Mapping documents:
Supplied "eg" example, with Mckoi set as:
## Mckoi SQL
hibernate.dialect org.hibernate.dialect.MckoiDialect
hibernate.connection.driver_class com.mckoi.JDBCDriver
#hibernate.connection.url jdbc:mckoi:///
hibernate.connection.url jdbc:mckoi:local://C:/hibtest/db.conf
hibernate.connection.username admin
hibernate.connection.password admin
Code between sessionFactory.openSession() and session.close():
As supplied in "eg" sample
Full stack trace of any exception that occurs:
Buildfile: build.xml
[taskdef] Could not load definitions from resource checkstyletask.properties. It could not be found.
[taskdef] Could not load definitions from resource clovertasks. It could not be found.
eg:
[echo] remember to place your JDBC driver in the lib directory
[java] 07:18:14,566 INFO Environment:464 - Hibernate 3.0.5
[java] 07:18:14,576 INFO Environment:482 - loaded properties from resource hibernate.properties: {hibernate.connection.driver_class=com.mckoi.JDBCDriver, hibernate.cglib.use_reflection_optimizer=true, hibernate.cache.provider_class=org.hibernate.cache.HashtableCacheProvider, hibernate.max_fetch_depth=1, hibernate.dialect=org.hibernate.dialect.MckoiDialect, 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=admin, hibernate.cache.region_prefix=hibernate.test, hibernate.connection.url=jdbc:mckoi:local://C:/hibtest/db.conf, hibernate.connection.password=****, hibernate.jdbc.batch_versioned_data=true, hibernate.connection.pool_size=1}
[java] 07:18:14,576 INFO Environment:509 - using java.io streams to persist binary types
[java] 07:18:14,576 INFO Environment:510 - using CGLIB reflection optimizer
[java] 07:18:14,586 INFO Environment:540 - using JDK 1.4 java.sql.Timestamp handling
[java] 07:18:14,656 INFO Configuration:464 - Mapping resource: org/hibernate/auction/AuctionItem.hbm.xml
[java] 07:18:15,057 INFO HbmBinder:260 - Mapping class: org.hibernate.auction.AuctionItem -> AuctionItem
[java] 07:18:15,147 INFO Configuration:464 - Mapping resource: org/hibernate/auction/Bid.hbm.xml
[java] 07:18:15,197 INFO HbmBinder:260 - Mapping class: org.hibernate.auction.Bid -> Bid
[java] 07:18:15,237 INFO HbmBinder:737 - Mapping subclass: org.hibernate.auction.BuyNow -> Bid
[java] 07:18:15,237 INFO Configuration:464 - Mapping resource: org/hibernate/auction/User.hbm.xml
[java] 07:18:15,287 INFO HbmBinder:260 - Mapping class: org.hibernate.auction.User -> AuctionUser
[java] 07:18:15,287 INFO Configuration:875 - processing extends queue
[java] 07:18:15,287 INFO Configuration:879 - processing collection mappings
[java] 07:18:15,287 INFO HbmBinder:2041 - Mapping collection: org.hibernate.auction.AuctionItem.bids -> Bid
[java] 07:18:15,287 INFO HbmBinder:2041 - Mapping collection: org.hibernate.auction.User.bids -> Bid
[java] 07:18:15,297 INFO HbmBinder:2041 - Mapping collection: org.hibernate.auction.User.auctions -> AuctionItem
[java] 07:18:15,297 INFO Configuration:888 - processing association property references
[java] 07:18:15,297 INFO Configuration:917 - processing foreign key constraints
[java] 07:18:15,448 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
[java] 07:18:15,448 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 1
[java] 07:18:15,448 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
[java] 07:18:15,458 INFO DriverManagerConnectionProvider:80 - using driver: com.mckoi.JDBCDriver at URL: jdbc:mckoi:local://C:/hibtest/db.conf
[java] 07:18:15,458 INFO DriverManagerConnectionProvider:86 - connection properties: {user=admin, password=****}
[java] 07:18:20,235 INFO SettingsFactory:77 - RDBMS: Mckoi SQL Database ( 1.0.3 ), version: 1.0.3
[java] 07:18:20,235 INFO SettingsFactory:78 - JDBC driver: Mckoi JDBC Driver, version: 1.0
[java] 07:18:20,245 INFO Dialect:92 - Using dialect: org.hibernate.dialect.MckoiDialect
[java] 07:18:20,255 INFO TransactionFactoryFactory:31 - Using default transaction strategy (direct JDBC transactions)
[java] 07:18:20,255 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
[java] 07:18:20,255 INFO SettingsFactory:125 - Automatic flush during beforeCompletion(): disabled
[java] 07:18:20,255 INFO SettingsFactory:129 - Automatic session close at end of transaction: disabled
[java] 07:18:20,255 INFO SettingsFactory:144 - Scrollable result sets: enabled
[java] 07:18:20,255 INFO SettingsFactory:152 - JDBC3 getGeneratedKeys(): disabled
[java] 07:18:20,265 INFO SettingsFactory:160 - Connection release mode: null
[java] 07:18:20,265 INFO SettingsFactory:184 - Maximum outer join fetch depth: 1
[java] 07:18:20,265 INFO SettingsFactory:187 - Default batch fetch size: 1
[java] 07:18:20,265 INFO SettingsFactory:191 - Generate SQL with comments: disabled
[java] 07:18:20,265 INFO SettingsFactory:195 - Order SQL updates by primary key: disabled
[java] 07:18:20,265 INFO SettingsFactory:334 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
[java] 07:18:20,265 INFO ASTQueryTranslatorFactory:21 - Using ASTQueryTranslatorFactory
[java] 07:18:20,265 INFO SettingsFactory:203 - Query language substitutions: {no='N', true=1, yes='Y', false=0}
[java] 07:18:20,265 INFO SettingsFactory:209 - Second-level cache: enabled
[java] 07:18:20,265 INFO SettingsFactory:213 - Query cache: disabled
[java] 07:18:20,265 INFO SettingsFactory:321 - Cache provider: org.hibernate.cache.HashtableCacheProvider
[java] 07:18:20,275 INFO SettingsFactory:228 - Optimize cache for minimal puts: disabled
[java] 07:18:20,275 INFO SettingsFactory:233 - Cache region prefix: hibernate.test
[java] 07:18:20,275 INFO SettingsFactory:237 - Structured second-level cache entries: disabled
[java] 07:18:20,275 INFO SettingsFactory:261 - Statistics: disabled
[java] 07:18:20,275 INFO SettingsFactory:265 - Deleted entity synthetic identifier rollback: disabled
[java] 07:18:20,275 INFO SettingsFactory:279 - Default entity-mode: pojo
[java] 07:18:20,325 INFO SessionFactoryImpl:152 - building session factory
[java] 07:18:20,686 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
[java] 07:18:20,696 INFO Dialect:92 - Using dialect: org.hibernate.dialect.MckoiDialect
[java] 07:18:20,696 INFO Configuration:875 - processing extends queue
[java] 07:18:20,696 INFO Configuration:879 - processing collection mappings
[java] 07:18:20,696 INFO Configuration:888 - processing association property references
[java] 07:18:20,696 INFO Configuration:917 - processing foreign key constraints
[java] 07:18:20,696 INFO Configuration:875 - processing extends queue
[java] 07:18:20,696 INFO Configuration:879 - processing collection mappings
[java] 07:18:20,696 INFO Configuration:888 - processing association property references
[java] 07:18:20,696 INFO Configuration:917 - processing foreign key constraints
[java] 07:18:20,696 INFO SchemaExport:113 - Running hbm2ddl schema export
[java] 07:18:20,696 INFO SchemaExport:129 - exporting generated schema to database
[java] 07:18:20,696 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
[java] 07:18:20,696 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 1
[java] 07:18:20,696 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
[java] 07:18:20,696 INFO DriverManagerConnectionProvider:80 - using driver: com.mckoi.JDBCDriver at URL: jdbc:mckoi:local://C:/hibtest/db.conf
[java] 07:18:20,706 INFO DriverManagerConnectionProvider:86 - connection properties: {user=admin, password=****}
[java] 07:18:20,716 DEBUG SchemaExport:143 - alter table AuctionItem drop constraint FK522A9BD61107FE9B
[java] 07:18:20,846 DEBUG SchemaExport:143 - alter table AuctionItem drop constraint FK522A9BD6F65B1FAF
[java] 07:18:20,886 DEBUG SchemaExport:143 - alter table Bid drop constraint FK104DDEE6E7E98
[java] 07:18:20,936 DEBUG SchemaExport:143 - alter table Bid drop constraint FK104DDF43A3910
[java] 07:18:20,966 DEBUG SchemaExport:143 - drop table AuctionItem
[java] 07:18:21,056 DEBUG SchemaExport:143 - drop table AuctionUser
[java] 07:18:21,116 DEBUG SchemaExport:143 - drop table Bid
[java] 07:18:21,337 DEBUG SchemaExport:143 - drop sequence hibernate_sequence
[java] 07:18:21,567 DEBUG SchemaExport:161 - create table AuctionItem (
[java] id bigint not null,
[java] seller bigint not null,
[java] description varchar(200) not null,
[java] ends timestamp,
[java] condition integer,
[java] successfulBid bigint,
[java] primary key (id),
[java] unique (seller, description)
[java] )
[java] 07:18:21,787 DEBUG SchemaExport:161 - create table AuctionUser (
[java] id bigint not null,
[java] userName varchar(10) not null,
[java] "password" varchar(15) not null,
[java] email varchar(255),
[java] firstName varchar(50) not null,
[java] "initial" char(1),
[java] lastName varchar(50) not null,
[java] primary key (id),
[java] unique (userName)
[java] )
[java] 07:18:21,928 DEBUG SchemaExport:161 - create table Bid (
[java] id bigint not null,
[java] isBuyNow char(1) not null,
[java] item bigint not null,
[java] amount float not null,
[java] "datetime" timestamp not null,
[java] bidder bigint not null,
[java] primary key (id),
[java] unique (item, amount)
[java] )
[java] 07:18:22,098 DEBUG SchemaExport:161 - alter table AuctionItem
[java] add constraint FK522A9BD61107FE9B
[java] foreign key (seller)
[java] references AuctionUser
[java] 07:18:22,248 DEBUG SchemaExport:161 - alter table AuctionItem
[java] add constraint FK522A9BD6F65B1FAF
[java] foreign key (successfulBid)
[java] references Bid
[java] 07:18:22,498 DEBUG SchemaExport:161 - alter table Bid
[java] add constraint FK104DDEE6E7E98
[java] foreign key (item)
[java] references AuctionItem
[java] 07:18:22,629 DEBUG SchemaExport:161 - alter table Bid
[java] add constraint FK104DDF43A3910
[java] foreign key (bidder)
[java] references AuctionUser
[java] 07:18:22,739 DEBUG SchemaExport:161 - create sequence hibernate_sequence
[java] 07:18:22,879 INFO SchemaExport:173 - schema export complete
[java] 07:18:22,879 INFO DriverManagerConnectionProvider:147 - cleaning up connection pool: jdbc:mckoi:local://C:/hibtest/db.conf
[java] 07:18:22,889 INFO SessionFactoryImpl:379 - Checking 0 named queries
[java] Setting up some test data
[java] 07:18:23,270 ERROR JDBCTransaction:104 - JDBC commit failed
[java] com.mckoi.database.jdbc.MSQLException: Concurrent Serializable Transaction Conflict(2): Table altered/dropped: AuctionUser
[java] at com.mckoi.database.jdbcserver.AbstractJDBCDatabaseInterface.handleExecuteThrowable(AbstractJDBCDatabaseInterface.java:278)
[java] at com.mckoi.database.jdbcserver.AbstractJDBCDatabaseInterface.execQuery(AbstractJDBCDatabaseInterface.java:479)
[java] at com.mckoi.database.jdbcserver.JDBCDatabaseInterface.execQuery(JDBCDatabaseInterface.java:251)
[java] at com.mckoi.database.jdbc.MConnection.executeQuery(MConnection.java:453)
[java] at com.mckoi.database.jdbc.MConnection.executeQueries(MConnection.java:436)
[java] at com.mckoi.database.jdbc.MStatement.executeQueries(MStatement.java:193)
[java] at com.mckoi.database.jdbc.MStatement.executeQuery(MStatement.java:167)
[java] at com.mckoi.database.jdbc.MStatement.executeQuery(MStatement.java:222)
[java] at com.mckoi.database.jdbc.MConnection.commit(MConnection.java:632)
[java] at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:119)
[java] at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:95)
[java] at org.hibernate.auction.Main.createTestAuctions(Main.java:348)
[java] at org.hibernate.auction.Main.main(Main.java:369)
[java] CAUSE:
[java] com.mckoi.database.TransactionException: Concurrent Serializable Transaction Conflict(2): Table altered/dropped: AuctionUser
[java] at com.mckoi.database.TableDataConglomerate.processCommit(TableDataConglomerate.java:2597)
[java] at com.mckoi.database.Transaction.closeAndCommit(Transaction.java:2068)
[java] at com.mckoi.database.DatabaseConnection.commit(DatabaseConnection.java:1502)
[java] at com.mckoi.database.interpret.CompleteTransaction.evaluate(CompleteTransaction.java:56)
[java] at com.mckoi.database.interpret.SQLQueryExecutor.execute(SQLQueryExecutor.java:147)
[java] at com.mckoi.database.jdbcserver.AbstractJDBCDatabaseInterface.execQuery(AbstractJDBCDatabaseInterface.java:461)
[java] at com.mckoi.database.jdbcserver.JDBCDatabaseInterface.execQuery(JDBCDatabaseInterface.java:251)
[java] at com.mckoi.database.jdbc.MConnection.executeQuery(MConnection.java:453)
[java] at com.mckoi.database.jdbc.MConnection.executeQueries(MConnection.java:436)
[java] at com.mckoi.database.jdbc.MStatement.executeQueries(MStatement.java:193)
[java] at com.mckoi.database.jdbc.MStatement.executeQuery(MStatement.java:167)
[java] at com.mckoi.database.jdbc.MStatement.executeQuery(MStatement.java:222)
[java] at com.mckoi.database.jdbc.MConnection.commit(MConnection.java:632)
[java] at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:119)
[java] at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:95)
[java] org.hibernate.TransactionException: JDBC commit failed
[java] at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:110)
[java] at org.hibernate.auction.Main.createTestAuctions(Main.java:348)
[java] at org.hibernate.auction.Main.main(Main.java:369)
[java] Caused by: com.mckoi.database.jdbc.MSQLException: Concurrent Serializable Transaction Conflict(2): Table altered/dropped: AuctionUser
[java] at com.mckoi.database.jdbcserver.AbstractJDBCDatabaseInterface.handleExecuteThrowable(AbstractJDBCDatabaseInterface.java:278)
[java] at com.mckoi.database.jdbcserver.AbstractJDBCDatabaseInterface.execQuery(AbstractJDBCDatabaseInterface.java:479)
[java] at com.mckoi.database.jdbcserver.JDBCDatabaseInterface.execQuery(JDBCDatabaseInterface.java:251)
[java] at com.mckoi.database.jdbc.MConnection.executeQuery(MConnection.java:453)
[java] at com.mckoi.database.jdbc.MConnection.executeQueries(MConnection.java:436)
[java] at com.mckoi.database.jdbc.MStatement.executeQueries(MStatement.java:193)
[java] at com.mckoi.database.jdbc.MStatement.executeQuery(MStatement.java:167)
[java] at com.mckoi.database.jdbc.MStatement.executeQuery(MStatement.java:222)
[java] at com.mckoi.database.jdbc.MConnection.commit(MConnection.java:632)
[java] at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:119)
[java] at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:95)
[java] ... 2 more
[java] at org.hibernate.auction.Main.createTestAuctions(Main.java:348)
[java] at org.hibernate.auction.Main.main(Main.java:369)
[java] Exception in thread "main"
Name and version of the database you are using:
Mckoi 1.0.3
The generated SQL (show_sql=true):
Debug level Hibernate log excerpt:
|