-->
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.  [ 6 posts ] 
Author Message
 Post subject: Connection problem under new HSQL?
PostPosted: Sat Jun 12, 2004 5:50 pm 
Newbie

Joined: Wed Jun 09, 2004 5:29 pm
Posts: 15
ok i've been following the turorial at http://www.warfrog.com/hibernatetutorial/ to the book!

But when i run the HibernateTutorial.java it comes up with this:

---------------------------------------------------------------------------
(cfg.Environment 462 ) Hibernate 2.1.4
(cfg.Environment 496 ) loaded properties from resource hibernate.properties: {hibernate.connection.driver_class=org.hsqldb.jdbcDriver, hibernate.cglib.use_reflection_optimizer=true, hibernate.cache.provider_class=net.sf.ehcache.hibernate.Provider, hibernate.cache.use_query_cache=true, hibernate.max_fetch_depth=1, hibernate.dialect=net.sf.hibernate.dialect.HSQLDialect, hibernate.jdbc.use_streams_for_binary=true, hibernate.jdbc.batch_size=0, hibernate.query.substitutions=true 1, false 0, yes 'Y', no 'N', hibernate.proxool.pool_alias=pool1, hibernate.connection.username=sa, hibernate.cache.region_prefix=hibernate.test, hibernate.connection.url=jdbc:hsqldb:hsql://localhost, hibernate.connection.password=, hibernate.connection.pool_size=1}
(cfg.Environment 521 ) using java.io streams to persist binary types
(cfg.Environment 522 ) using CGLIB reflection optimizer
(cfg.Configuration 347 ) Mapping resource: com/warfrog/hibernatetutorial/hibernate/Group.hbm.xml
(cfg.Binder 229 ) Mapping class: com.warfrog.hibernatetutorial.hibernate.Group -> GROUPS
(cfg.Configuration 347 ) Mapping resource: com/warfrog/hibernatetutorial/hibernate/User.hbm.xml
(cfg.Binder 229 ) Mapping class: com.warfrog.hibernatetutorial.hibernate.User -> USERS
(cfg.Configuration 613 ) processing one-to-many association mappings
(cfg.Binder 1168) Mapping collection: com.warfrog.hibernatetutorial.hibernate.Group.users -> USERS
(cfg.Configuration 622 ) processing one-to-one association property references
(cfg.Configuration 647 ) processing foreign key constraints
(dialect.Dialect 82 ) Using dialect: net.sf.hibernate.dialect.HSQLDialect
(cfg.SettingsFactory 58 ) Maximim outer join fetch depth: 1
(cfg.SettingsFactory 62 ) Use outer join fetching: false
(connection.DriverManagerConnectionProvider 42 ) Using Hibernate built-in connection pool (not for production use!)
(connection.DriverManagerConnectionProvider 43 ) Hibernate connection pool size: 1
(connection.DriverManagerConnectionProvider 77 ) using driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:hsql://localhost
(connection.DriverManagerConnectionProvider 78 ) connection properties: {user=sa, password=}
(transaction.TransactionManagerLookupFactory 33 ) No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended)
---------------------------------------------------------------------------

And nothing else, i have no idea what im doing wrong here... i can connect to the database if i user the DatabaseManager.

Setup files are:

hibernate.dialect net.sf.hibernate.dialect.HSQLDialect
hibernate.connection.driver_class org.hsqldb.jdbcDriver
hibernate.connection.username sa
hibernate.connection.password
hibernate.connection.url jdbc:hsqldb:hsql://localhost



any help appriciated!
/M


Top
 Profile  
 
 Post subject:
PostPosted: Mon Jun 14, 2004 6:26 am 
Newbie

Joined: Wed Jun 09, 2004 5:29 pm
Posts: 15
nobody knows why it wont connect?


Top
 Profile  
 
 Post subject:
PostPosted: Mon Jun 14, 2004 6:42 am 
Newbie

Joined: Wed Jun 09, 2004 5:29 pm
Posts: 15
maybe i should add that i got it to work under MySQL...


Top
 Profile  
 
 Post subject:
PostPosted: Mon Jun 14, 2004 12:35 pm 
Hibernate Team
Hibernate Team

Joined: Sun Sep 14, 2003 3:54 am
Posts: 7256
Location: Paris, France
more info is required, an exception, etc...

_________________
Emmanuel


Top
 Profile  
 
 Post subject:
PostPosted: Tue Jun 29, 2004 12:02 pm 
Newbie

Joined: Mon Jun 07, 2004 3:29 pm
Posts: 4
Hi,

I've got this same problem (but with HSQL). I start the hsql server in a shell, and then I run hibernate code and it doesn't connect. There are no exceptions. The connection url is set as it should:
hibernate.connection.url jdbc:hsqldb:hsql://localhost

(If I connect to the database with a 3th party jdbc client there isn't any problem)

Help? Anyone?
Thanks.


Top
 Profile  
 
 Post subject:
PostPosted: Wed Jun 30, 2004 6:17 am 
Newbie

Joined: Mon Jun 07, 2004 3:29 pm
Posts: 4
Ok,

Solved it! (No wander that emmanuel didn't have any feedback on this).
It was a problem in my classpath, I had two diferent hsql drivers in the classpath. I corrected the classpath, and everything started to work properly.

Maybe this is also your problem Breeze?


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