These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 
Author Message
 Post subject: Mckoi DB and Hibernate 3
PostPosted: Wed Jul 06, 2005 10:26 am 
Newbie

Joined: Wed Jul 06, 2005 10:09 am
Posts: 4
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:


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.