-->
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.  [ 3 posts ] 
Author Message
 Post subject: Hibernate 3.1 and SQLBase 8.5
PostPosted: Thu Feb 23, 2006 10:11 am 
Newbie

Joined: Thu Feb 23, 2006 9:52 am
Posts: 3
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.


Top
 Profile  
 
 Post subject:
PostPosted: Wed Mar 01, 2006 9:32 am 
Newbie

Joined: Thu Feb 23, 2006 9:52 am
Posts: 3
I think about to develop a dialect for SQLBase.

Is there some hints for develop a new dialect?


kind regards,


F.O.


Top
 Profile  
 
 Post subject: Re: Hibernate 3.1 and SQLBase 8.5
PostPosted: Mon Nov 22, 2010 5:39 am 
Newbie

Joined: Mon Nov 22, 2010 5:26 am
Posts: 9
Hi,

I'm looking at implementing NHibernate with SQLBase. Is there any code you can post that might help me out?

Thanks.

Mike.


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

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.