Hi everyone,

I have some troubles with Hibernate 3.0.5 mapping Daffodil One$DB 4.0 although following this guide http://www.daffodildb.com/daffodildb-hibernate.html .

My errors are:
- no meta data connection
- no suitable driver

Hope you can help me with this issue, thx in advance...

Greetz..




Some hints:

I'm using this dialect file: http://www.daffodildb.com/DaffodilDBDialect.java

with these one$db properties for hibernate:
hibernate.dialect org.hibernate.dialect.DaffodilDBDialect

hibernate.connection.driver_class in.co.daffodil.db.jdbc.DaffodilDBDriver

hibernate.connection.url jdbc:daffodilDB://localhost:3456/eventuser;create=true

hibernate.connection.username DAFFODIL

hibernate.connection.password daffodil


Here is an abstract of my java application's message:
INFO - Hibernate 3.0.5
INFO - loaded properties from resource hibernate.properties: {hibernate.order_updates=true, hibernate.default_batch_fetch_size=8, hibernate.connection.driver_class=in.co.daffodil.db.jdbc.DaffodilDBDriver, hibernate.cglib.use_reflection_optimizer=true, hibernate.cache.provider_class=org.hibernate.cache.HashtableCacheProvider, hibernate.max_fetch_depth=1, hibernate.dialect=org.hibernate.dialect.DaffodilDBDialect, 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=DAFFODIL, hibernate.cache.region_prefix=hibernate.test, hibernate.connection.url=jdbc:daffodilDB://localhost:3456/eventuser;create=true, hibernate.connection.password=****, hibernate.jdbc.batch_versioned_data=true, hibernate.connection.pool_size=1}
INFO - using java.io streams to persist binary types
INFO - using CGLIB reflection optimizer
INFO - using JDK 1.4 java.sql.Timestamp handling
INFO - Mapping resource: de/gloegl/road2hibernate/Event.hbm.xml
INFO - Mapping class: de.gloegl.road2hibernate.Event -> EVENTS
INFO - Mapping collection: de.gloegl.road2hibernate.Event.participatingUsers -> participations
INFO - Mapping resource: de/gloegl/road2hibernate/User.hbm.xml
INFO - Mapping class: de.gloegl.road2hibernate.User -> USERS
INFO - Mapping collection: de.gloegl.road2hibernate.User.favouriteEvents -> favourite_events
INFO - Mapping collection: de.gloegl.road2hibernate.User.emails -> user_emails
INFO - Mapping collection: de.gloegl.road2hibernate.User.eventsJoined -> participations
INFO - processing extends queue
INFO - processing collection mappings
INFO - processing association property references
INFO - processing foreign key constraints
INFO - Using Hibernate built-in connection pool (not for production use!)
INFO - Hibernate connection pool size: 1
INFO - autocommit mode: false
INFO - using driver: in.co.daffodil.db.jdbc.DaffodilDBDriver at URL: jdbc:daffodilDB://localhost:3456/eventuser;create=true
INFO - connection properties: {user=DAFFODIL, password=****}
WARN - Could not obtain connection metadata
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:532)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:72)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1463)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1004)
at de.gloegl.road2hibernate.HibernateUtil.<clinit>(HibernateUtil.java:33)
at de.gloegl.road2hibernate.EventManager.storeEvent(EventManager.java:77)
at de.gloegl.road2hibernate.EventManager.main(EventManager.java:23)
INFO - Using dialect: org.hibernate.dialect.DaffodilDBDialect
INFO - Using default transaction strategy (direct JDBC transactions)
INFO - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
INFO - Automatic flush during beforeCompletion(): disabled
INFO - Automatic session close at end of transaction: disabled
INFO - Scrollable result sets: disabled
INFO - JDBC3 getGeneratedKeys(): disabled
INFO - Connection release mode: null
INFO - Maximum outer join fetch depth: 1
INFO - Default batch fetch size: 8
INFO - Generate SQL with comments: disabled
INFO - Order SQL updates by primary key: enabled
INFO - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
INFO - Using ASTQueryTranslatorFactory
INFO - Query language substitutions: {no='N', true=1, yes='Y', false=0}
INFO - Second-level cache: enabled
INFO - Query cache: disabled
INFO - Cache provider: org.hibernate.cache.HashtableCacheProvider
INFO - Optimize cache for minimal puts: disabled
INFO - Cache region prefix: hibernate.test
INFO - Structured second-level cache entries: disabled
INFO - Statistics: disabled
INFO - Deleted entity synthetic identifier rollback: disabled
INFO - Default entity-mode: pojo
INFO - building session factory
INFO - Not binding factory to JNDI, no JNDI name configured
INFO - Checking 0 named queries
WARN - SQL Error: 0, SQLState: 08001
ERROR - No suitable driver
java.lang.RuntimeException: org.hibernate.exception.JDBCConnectionException: Cannot open connection
at de.gloegl.road2hibernate.EventManager.storeEvent(EventManager.java:93)
at de.gloegl.road2hibernate.EventManager.main(EventManager.java:23)
Caused by: org.hibernate.exception.JDBCConnectionException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:66)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:301)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:110)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:137)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:49)
at org.hibernate.transaction.JDBCTransactionFactory.beginTransaction(JDBCTransactionFactory.java:24)
at org.hibernate.jdbc.JDBCContext.beginTransaction(JDBCContext.java:271)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1079)
at de.gloegl.road2hibernate.EventManager.storeEvent(EventManager.java:78)
... 1 more
Caused by: java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:532)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:298)
... 8 more
Exception in thread "main"

sounds like you forgot to put the jar containing in.co.daffodil.db.jdbc.DaffodilDBDriver into your classpath.

At first I thought of it too but I've got that afore said driver already in my classpath (DaffodilDB_Client.jar).

No Suitable Driver happens when the JDBC URL is wrong, try to double check that.