-->
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.  [ 2 posts ] 
Author Message
 Post subject: Q: Using Hibernate with the jdbc:odbc bridge
PostPosted: Thu Jan 25, 2007 9:21 am 
Newbie

Joined: Mon Jan 01, 2007 9:43 pm
Posts: 11
Newbie question alert!

I'm currently trying to access an OpenRDA database using the jdbc:odbc bridge but have been receiving the following error. Can anyone suggest a way to resolve this issue?

Thanks in advance!
Adam

Hibernate version: 3.2.1

Full stack trace of any exception that occurs:
22:51:33,937 INFO Environment:500 - Hibernate 3.2.1
22:51:33,953 INFO Environment:533 - hibernate.properties not found
22:51:33,953 INFO Environment:667 - Bytecode provider name : cglib
22:51:33,968 INFO Environment:584 - using JDK 1.4 java.sql.Timestamp handling
22:51:34,046 INFO Configuration:1423 - configuring from resource: /hibernate.cfg.xml
22:51:34,046 INFO Configuration:1400 - Configuration resource: /hibernate.cfg.xml
22:51:34,437 INFO Configuration:553 - Reading mappings from resource : events/Event.hbm.xml
22:51:34,593 INFO HbmBinder:300 - Mapping class: events.Event -> Customers
22:51:34,625 INFO Configuration:1538 - Configured SessionFactory: null
22:51:34,718 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
22:51:34,718 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 1
22:51:34,718 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
22:51:34,718 INFO DriverManagerConnectionProvider:80 - using driver: sun.jdbc.odbc.JdbcOdbcDriver at URL: jdbc:odbc:Acme;HOST_EXE_PATH=C:\myob15\MYOB.exe;ACCESS_TYPE=READ_WRITE
22:51:34,734 INFO DriverManagerConnectionProvider:86 - connection properties: {user=Administrator, password=****}
CLI : [TID: 2A74]:[Thu Jan 25 22:51:34 2007] rdacstmt.c:99: *** rda_cliAllocStmt: connection is not opened
SQLD: [TID: 2A74]:[Thu Jan 25 22:51:35 2007] damdrv.c:4760: Driver:MYOB did not register the setInfo function. Option is being ignored
22:51:35,390 INFO SettingsFactory:81 - RDBMS: OpenRDA, version: 5.00.63.0
22:51:35,390 INFO SettingsFactory:82 - JDBC driver: JDBC-ODBC Bridge (odbcmyob), version: 2.0001 (5.7.0000)
Initial SessionFactory creation failed.org.hibernate.HibernateException: Hibernate Dialect must be explicitly set for database: OpenRDA
Exception in thread "main" java.lang.ExceptionInInitializerError
at util.HibernateUtil.<clinit>(HibernateUtil.java:17)
at events.EventManager.createAndStoreEvent(EventManager.java:22)
at events.EventManager.main(EventManager.java:14)
Caused by: org.hibernate.HibernateException: Hibernate Dialect must be explicitly set for database: OpenRDA
at org.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:62)
at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:39)
at org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:409)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:119)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2006)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1289)
at util.HibernateUtil.<clinit>(HibernateUtil.java:13)
... 2 more
CLI : [TID: 2A74]:[Thu Jan 25 22:51:35 2007] rdachenv.c:342: rda_cliFreeEnv() 1 connection handles still exist under this environment handle

Name and version of the database you are using:
RDBMS: OpenRDA, version: 5.00.63.0


Top
 Profile  
 
 Post subject:
PostPosted: Wed Jan 31, 2007 8:10 am 
Newbie

Joined: Mon Jan 01, 2007 9:43 pm
Posts: 11
Ok, I've generated my own dialect and things are working, almost.

:)

Adam


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 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.