Hi,
I want to test hibernate with SQLBase and I have downloaded hibernate 3.1.
I get following error by starting "build eg":
Code:
14:53:56,593 INFO Environment:479 - Hibernate 3.1.2
14:53:56,609 INFO Environment:494 - loaded properties from resource hibernate.properties: {hibernate.connection.driver_class=jdbc.gupta.sqlbase.SqlbaseDriver, hibernate.cglib.use_reflection_optimizer=true, hibernate.cache.provider_class=org.hibernate.cache.HashtableCacheProvider, hibernate.max_fetch_depth=1, hibernate.dialect=org.hibernate.dialect.HSQLDialect, hibernate.jdbc.use_streams_for_binary=true, hibernate.query.factory_class=org.hibernate.hql.classic.ClassicQueryTranslatorFactory, hibernate.format_sql=true, hibernate.query.substitutions=yes 'Y', no 'N', hibernate.proxool.pool_alias=pool1, hibernate.connection.username=SYSADM, hibernate.cache.region_prefix=hibernate.test, hibernate.connection.url=jdbc:sqlbase://localhost/fmaloc, hibernate.connection.password=****, hibernate.jdbc.batch_versioned_data=true, hibernate.connection.pool_size=1}
14:53:56,609 INFO Environment:524 - using java.io streams to persist binary types
14:53:56,624 INFO Environment:525 - using CGLIB reflection optimizer
14:53:56,624 INFO Environment:555 - using JDK 1.4 java.sql.Timestamp handling
14:53:56,718 INFO Configuration:497 - Reading mappings from resource: org/hibernate/auction/AuctionItem.hbm.xml
14:53:57,218 INFO HbmBinder:309 - Mapping class: org.hibernate.auction.AuctionItem -> AuctionItem
14:53:57,359 INFO Configuration:497 - Reading mappings from resource: org/hibernate/auction/Bid.hbm.xml
14:53:57,405 INFO HbmBinder:309 - Mapping class: org.hibernate.auction.Bid -> Bid
14:53:57,468 INFO HbmBinder:824 - Mapping subclass: org.hibernate.auction.BuyNow -> Bid
14:53:57,468 INFO Configuration:497 - Reading mappings from resource: org/hibernate/auction/User.hbm.xml
14:53:57,515 INFO HbmBinder:309 - Mapping class: org.hibernate.auction.User -> AuctionUser
14:53:57,515 INFO HbmBinder:2349 - Mapping collection: org.hibernate.auction.AuctionItem.bids -> Bid
14:53:57,530 INFO HbmBinder:2349 - Mapping collection: org.hibernate.auction.User.bids -> Bid
14:53:57,530 INFO HbmBinder:2349 - Mapping collection: org.hibernate.auction.User.auctions -> AuctionItem
14:53:57,718 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
14:53:57,718 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 1
14:53:57,718 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
14:53:57,734 INFO DriverManagerConnectionProvider:80 - using driver: jdbc.gupta.sqlbase.SqlbaseDriver at URL: jdbc:sqlbase://localhost/fmaloc
14:53:57,734 INFO DriverManagerConnectionProvider:86 - connection properties: {user=SYSADM, password=****}
14:53:57,890 INFO SettingsFactory:77 - RDBMS: SQLBase, version: 6.x.x or Higher
14:53:57,890 INFO SettingsFactory:78 - JDBC driver: JDBC Driver for SQLBase, version: 1.02
14:53:57,921 INFO Dialect:103 - Using dialect: org.hibernate.dialect.HSQLDialect
14:53:57,937 INFO TransactionFactoryFactory:31 - Using default transaction strategy (direct JDBC transactions)
14:53:57,937 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
14:53:57,937 INFO SettingsFactory:125 - Automatic flush during beforeCompletion(): disabled
14:53:57,937 INFO SettingsFactory:129 - Automatic session close at end of transaction: disabled
14:53:57,952 INFO SettingsFactory:144 - Scrollable result sets: enabled
14:53:57,952 INFO SettingsFactory:152 - JDBC3 getGeneratedKeys(): disabled
14:53:57,952 INFO SettingsFactory:160 - Connection release mode: auto
14:53:57,952 INFO SettingsFactory:184 - Maximum outer join fetch depth: 1
14:53:57,952 INFO SettingsFactory:187 - Default batch fetch size: 1
14:53:57,952 INFO SettingsFactory:191 - Generate SQL with comments: disabled
14:53:57,952 INFO SettingsFactory:195 - Order SQL updates by primary key: disabled
14:53:57,952 INFO SettingsFactory:338 - Query translator: org.hibernate.hql.classic.ClassicQueryTranslatorFactory
14:53:57,984 INFO SettingsFactory:203 - Query language substitutions: {no='N', yes='Y'}
14:53:57,984 INFO SettingsFactory:209 - Second-level cache: enabled
14:53:57,999 INFO SettingsFactory:213 - Query cache: disabled
14:53:57,999 INFO SettingsFactory:325 - Cache provider: org.hibernate.cache.HashtableCacheProvider
14:53:57,999 INFO SettingsFactory:228 - Optimize cache for minimal puts: disabled
14:53:57,999 INFO SettingsFactory:233 - Cache region prefix: hibernate.test
14:53:57,999 INFO SettingsFactory:237 - Structured second-level cache entries: disabled
14:53:57,999 INFO SettingsFactory:264 - Statistics: disabled
14:53:58,015 INFO SettingsFactory:268 - Deleted entity synthetic identifier rollback: disabled
14:53:58,015 INFO SettingsFactory:283 - Default entity-mode: pojo
14:53:58,046 INFO SessionFactoryImpl:153 - building session factory
14:53:58,452 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
14:53:58,468 INFO SchemaExport:155 - Running hbm2ddl schema export
14:53:58,468 DEBUG SchemaExport:173 - import file not found: /import.sql
14:53:58,468 INFO SchemaExport:182 - exporting generated schema to database
14:53:58,484 DEBUG SchemaExport:296 -
alter table AuctionItem
drop constraint FK522A9BD6F65B1FAF
14:53:58,499 DEBUG SchemaExport:285 - Unsuccessful: alter table AuctionItem drop constraint FK522A9BD6F65B1FAF
14:53:58,499 DEBUG SchemaExport:286 - 00901 PRS CNE Command not properly ended
14:53:58,499 DEBUG SchemaExport:296 -
alter table AuctionItem
drop constraint FK522A9BD61107FE9B
14:53:58,499 DEBUG SchemaExport:285 - Unsuccessful: alter table AuctionItem drop constraint FK522A9BD61107FE9B
14:53:58,499 DEBUG SchemaExport:286 - 00901 PRS CNE Command not properly ended
14:53:58,499 DEBUG SchemaExport:296 -
alter table Bid
drop constraint FK104DDF43A3910
14:53:58,515 DEBUG SchemaExport:285 - Unsuccessful: alter table Bid drop constraint FK104DDF43A3910
14:53:58,515 DEBUG SchemaExport:286 - 00901 PRS CNE Command not properly ended
14:53:58,515 DEBUG SchemaExport:296 -
alter table Bid
drop constraint FK104DDEE6E7E98
14:53:58,515 DEBUG SchemaExport:285 - Unsuccessful: alter table Bid drop constraint FK104DDEE6E7E98
14:53:58,515 DEBUG SchemaExport:286 - 00901 PRS CNE Command not properly ended
14:53:58,515 DEBUG SchemaExport:296 -
drop table AuctionItem if exists
14:53:58,515 DEBUG SchemaExport:285 - Unsuccessful: drop table AuctionItem if exists
14:53:58,515 DEBUG SchemaExport:286 - 00901 PRS CNE Command not properly ended
14:53:58,515 DEBUG SchemaExport:296 -
drop table AuctionUser if exists
14:53:58,515 DEBUG SchemaExport:285 - Unsuccessful: drop table AuctionUser if exists
14:53:58,515 DEBUG SchemaExport:286 - 00901 PRS CNE Command not properly ended
14:53:58,515 DEBUG SchemaExport:296 -
drop table Bid if exists
14:53:58,515 DEBUG SchemaExport:285 - Unsuccessful: drop table Bid if exists
14:53:58,530 DEBUG SchemaExport:286 - 00901 PRS CNE Command not properly ended
14:53:58,530 DEBUG SchemaExport:296 -
create table AuctionItem (
id bigint generated by default as identity (start with 1),
seller bigint not null,
shortDescription varchar(200) not null,
description varchar(1000),
ends timestamp,
"CONDITION" integer,
successfulBid bigint,
primary key (id),
unique (seller, shortDescription)
)
14:53:58,530 ERROR SchemaExport:271 - Unsuccessful: create table AuctionItem (id bigint generated by default as identity (start with 1), seller bigint not null, shortDescription varchar(200) not null, description varchar(1000), ends timestamp, "CONDITION" integer, successfulBid bigint, primary key (id), unique (seller, shortDescription))
14:53:58,530 ERROR SchemaExport:272 - 00952 PRS MDK Missing data type keyword
14:53:58,530 DEBUG SchemaExport:296 -
create table AuctionUser (
id bigint generated by default as identity (start with 1),
userName varchar(10) not null,
"password" varchar(15) not null,
email varchar(255),
firstName varchar(50) not null,
"initial" char(1),
lastName varchar(50) not null,
primary key (id),
unique (userName)
)
14:53:58,530 ERROR SchemaExport:271 - Unsuccessful: create table AuctionUser (id bigint generated by default as identity (start with 1), userName varchar(10) not null, "password" varchar(15) not null, email varchar(255), firstName varchar(50) not null, "initial" char(1), lastName varchar(50) not null, primary key (id), unique (userName))
14:53:58,530 ERROR SchemaExport:272 - 00952 PRS MDK Missing data type keyword
14:53:58,546 DEBUG SchemaExport:296 -
create table Bid (
id bigint generated by default as identity (start with 1),
isBuyNow char(1) not null,
item bigint not null,
amount float not null,
"datetime" timestamp not null,
bidder bigint not null,
primary key (id),
unique (item, amount)
)
14:53:58,546 ERROR SchemaExport:271 - Unsuccessful: create table Bid (id bigint generated by default as identity (start with 1), isBuyNow char(1) not null, item bigint not null, amount float not null, "datetime" timestamp not null, bidder bigint not null, primary key (id), unique (item, amount))
14:53:58,546 ERROR SchemaExport:272 - 00952 PRS MDK Missing data type keyword
14:53:58,546 DEBUG SchemaExport:296 -
alter table AuctionItem
add constraint FK522A9BD6F65B1FAF
foreign key (successfulBid)
references Bid
14:53:58,546 ERROR SchemaExport:271 - Unsuccessful: alter table AuctionItem add constraint FK522A9BD6F65B1FAF foreign key (successfulBid) references Bid
14:53:58,546 ERROR SchemaExport:272 - 00952 PRS MDK Missing data type keyword
14:53:58,546 DEBUG SchemaExport:296 -
alter table AuctionItem
add constraint FK522A9BD61107FE9B
foreign key (seller)
references AuctionUser
14:53:58,546 ERROR SchemaExport:271 - Unsuccessful: alter table AuctionItem add constraint FK522A9BD61107FE9B foreign key (seller) references AuctionUser
14:53:58,562 ERROR SchemaExport:272 - 00952 PRS MDK Missing data type keyword
14:53:58,562 DEBUG SchemaExport:296 -
alter table Bid
add constraint FK104DDF43A3910
foreign key (bidder)
references AuctionUser
14:53:58,562 ERROR SchemaExport:271 - Unsuccessful: alter table Bid add constraint FK104DDF43A3910 foreign key (bidder) references AuctionUser
14:53:58,562 ERROR SchemaExport:272 - 00952 PRS MDK Missing data type keyword
14:53:58,562 DEBUG SchemaExport:296 -
alter table Bid
add constraint FK104DDEE6E7E98
foreign key (item)
references AuctionItem
14:53:58,562 ERROR SchemaExport:271 - Unsuccessful: alter table Bid add constraint FK104DDEE6E7E98 foreign key (item) references AuctionItem
14:53:58,562 ERROR SchemaExport:272 - 00952 PRS MDK Missing data type keyword
14:53:58,562 INFO SchemaExport:202 - schema export complete
14:53:58,812 WARN JDBCExceptionReporter:71 - SQL Error: 0, SQLState: null
14:53:58,812 ERROR JDBCExceptionReporter:72 - 00601 DIC ITN Table has not been created
Does hibernate 3.1 work correctly with SQLBase?
kind regards,
F.O.