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.  [ 1 post ] 
Author Message
 Post subject: Connection problem in first setup
PostPosted: Thu Dec 02, 2004 11:14 pm 
Newbie

Joined: Thu Dec 02, 2004 10:44 pm
Posts: 1
Hi everyone. I'm new to Hibernate, so this might be obvious.

When I'm following the steps of "Get up and running quickly", I get stuck on the "build eg". I get a SQLException, saying:
Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused: connect
Please, see below for full description.

- I have tested the connection outside of hibernate, and it's working.
- I haven't set the classpath for the driver (I assume it's not necessary?).


Hibernate version: 2.1

Name and version of the database you are using: MySQL 4.0.15

DB config in hibernate.properties:

## MySQL

hibernate.dialect net.sf.hibernate.dialect.MySQLDialect
#hibernate.connection.driver_class org.gjt.mm.mysql.Driver
hibernate.connection.driver_class com.mysql.jdbc.Driver
hibernate.connection.url jdbc:mysql://localhost/
hibernate.connection.username monty
hibernate.connection.password montypass


Full stack trace of any exception that occurs:

C:\Daniel\software\hibernate\hibernate-2.1>set JDBC_DRIVER=C:\mysql\mysql-connec
tor-java-3.0.8-stable-bin.jar

C:\Daniel\software\hibernate\hibernate-2.1>java -cp "lib/ant-1.5.3.jar;lib/ant-o
ptional-1.5.3.jar;lib/junit-3.8.1.jar;lib/xerces-2.4.0.jar;C:\j2sdk1.4.1_03/lib/
tools.jar" org.apache.tools.ant.Main -Ddriver.jar=C:\mysql\mysql-connector-java-
3.0.8-stable-bin.jar eg
Buildfile: build.xml
[taskdef] Could not load definitions from resource clovertasks. It could not b
e found.

eg:
[echo] Remember to place your JDBC driver in the lib directory!
[echo] This target is not runable from a CVS export/checkout!
[java] 00:32:49,031 INFO Environment:478 - Hibernate 2.1.7
[java] 00:32:49,109 INFO Environment:512 - loaded properties from resource
hibernate.properties: {hibernate.connection.driver_class=com.mysql.jdbc.Driver,
hibernate.cglib.use_reflection_optimizer=true, hibernate.cache.provider_class=n
et.sf.hibernate.cache.EhCacheProvider, hibernate.cache.use_query_cache=true, hib
ernate.max_fetch_depth=1, hibernate.dialect=net.sf.hibernate.dialect.MySQLDialec
t, hibernate.jdbc.use_streams_for_binary=true, hibernate.jdbc.batch_size=0, hibe
rnate.query.substitutions=true 1, false 0, yes 'Y', no 'N', hibernate.proxool.po
ol_alias=pool1, hibernate.connection.username=monty, hibernate.cache.region_pref
ix=hibernate.test, hibernate.connection.url=jdbc:mysql://localhost/, hibernate.c
onnection.password=montypass, hibernate.jdbc.batch_versioned_data=true, hibernat
e.connection.pool_size=1}
[java] 00:32:49,125 INFO Environment:537 - using java.io streams to persist binary types
[java] 00:32:49,125 INFO Environment:538 - using CGLIB reflection optimizer
[java] 00:32:49,140 INFO Environment:567 - using JDK 1.4 java.sql.Timestamp handling
[java] 00:32:49,171 INFO Configuration:350 - Mapping resource: org/hibernate/auction/AuctionItem.hbm.xml
[java] 00:32:50,593 INFO Binder:230 - Mapping class: org.hibernate.auction.AuctionItem -> AuctionItem
[java] 00:32:50,984 INFO Configuration:350 - Mapping resource: org/hibernate/auction/Bid.hbm.xml
[java] 00:32:51,125 INFO Binder:230 - Mapping class: org.hibernate.auction.Bid -> Bid
[java] 00:32:51,265 INFO Binder:170 - Mapping subclass: org.hibernate.auction.BuyNow -> Bid
[java] 00:32:51,281 INFO Configuration:350 - Mapping resource: org/hibernate/auction/User.hbm.xml
[java] 00:32:51,453 INFO Binder:230 - Mapping class: org.hibernate.auction.User -> AuctionUser
[java] 00:32:51,890 INFO ReflectHelper:186 - reflection optimizer disabled
for: org.hibernate.auction.Name, IllegalArgumentException: Cannot find matching
method/constructor
[java] 00:32:51,890 INFO Configuration:632 - processing one-to-many association mappings
[java] 00:32:51,890 INFO Binder:1182 - Mapping collection: org.hibernate.auction.AuctionItem.bids -> Bid
[java] 00:32:51,890 INFO Binder:1182 - Mapping collection: org.hibernate.auction.User.bids -> Bid
[java] 00:32:51,906 INFO Binder:1182 - Mapping collection: org.hibernate.auction.User.auctions -> AuctionItem
[java] 00:32:51,906 INFO Configuration:641 - processing one-to-one association property references
[java] 00:32:51,906 INFO Configuration:666 - processing foreign key constraints
[java] 00:32:52,031 INFO Dialect:86 - Using dialect: net.sf.hibernate.dialect.MySQLDialect
[java] 00:32:52,046 INFO SettingsFactory:70 - Maximim outer join fetch depth: 1
[java] 00:32:52,062 INFO SettingsFactory:74 - Use outer join fetching: true
[java] 00:32:52,078 INFO DriverManagerConnectionProvider:42 - Using Hibernate built-in connection pool (not for production use!)
[java] 00:32:52,078 INFO DriverManagerConnectionProvider:43 - Hibernate connection pool size: 1
[java] 00:32:52,093 INFO DriverManagerConnectionProvider:77 - using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost/
[java] 00:32:52,093 INFO DriverManagerConnectionProvider:78 - connection properties: {user=monty, password=montypass}
[java] 00:32:52,109 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of process level read-writecache is not recommended)
[java] 00:32:53,390 WARN SettingsFactory:107 - Could not obtain connection
metadata
[java] java.sql.SQLException: Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1622)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:491)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)
[java] at java.sql.DriverManager.getConnection(DriverManager.java:512)
[java] at java.sql.DriverManager.getConnection(DriverManager.java:140)
[java] at net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:101)
[java] at net.sf.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
[java] at net.sf.hibernate.cfg.Configuration.buildSettings(Configuration.java:1160)
[java] at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:794)
[java] at org.hibernate.auction.Main.main(Main.java:363)
[java] 00:32:53,406 INFO SettingsFactory:114 - Use scrollable result sets:
false

[java] 00:32:53,406 INFO SettingsFactory:117 - Use JDBC3 getGeneratedKeys(): false
[java] 00:32:53,406 INFO SettingsFactory:120 - Optimize cache for minimalputs: false
[java] 00:32:53,406 INFO SettingsFactory:129 - Query language substitutions: {no='N', true=1, yes='Y', false=0}
[java] 00:32:53,406 INFO SettingsFactory:140 - cache provider: net.sf.hibernate.cache.EhCacheProvider
[java] 00:32:53,484 INFO SettingsFactory:152 - query cache factory: net.sf.hibernate.cache.StandardQueryCacheFactory
[java] 00:32:53,515 INFO Configuration:1121 - instantiating and configuring caches
[java] 00:32:53,671 INFO SessionFactoryImpl:119 - building session factory
[java] 00:32:54,875 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
[java] 00:32:54,890 INFO Dialect:86 - Using dialect: net.sf.hibernate.dialect.MySQLDialect
[java] 00:32:54,890 INFO Configuration:632 - processing one-to-many association mappings
[java] 00:32:54,890 INFO Configuration:641 - processing one-to-one association property references
[java] 00:32:54,890 INFO Configuration:666 - processing foreign key constraints
[java] 00:32:54,890 INFO Configuration:632 - processing one-to-many association mappings
[java] 00:32:54,890 INFO Configuration:641 - processing one-to-one association property references
[java] 00:32:54,906 INFO Configuration:666 - processing foreign key constraints
[java] 00:32:54,937 INFO SchemaExport:98 - Running hbm2ddl schema export
[java] 00:32:54,937 INFO SchemaExport:117 - exporting generated schema todatabase
[java] 00:32:54,937 INFO DriverManagerConnectionProvider:42 - Using Hibernate built-in connection pool (not for production use!)
[java] 00:32:54,937 INFO DriverManagerConnectionProvider:43 - Hibernate connection pool size: 1
[java] 00:32:54,937 INFO DriverManagerConnectionProvider:77 - using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost/
[java] 00:32:54,937 INFO DriverManagerConnectionProvider:78 - connection properties: {user=monty, password=montypass}
[java] 00:32:55,265 ERROR SchemaExport:165 - schema export unsuccessful
[java] java.sql.SQLException: Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1622)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:491)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)
[java] at java.sql.DriverManager.getConnection(DriverManager.java:512)
[java] at java.sql.DriverManager.getConnection(DriverManager.java:140)
[java] at net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:101)
[java] at net.sf.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:119)
[java] at net.sf.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:84)
[java] at net.sf.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:198)
[java] at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:796)
[java] at org.hibernate.auction.Main.main(Main.java:363)
[java] 00:32:55,281 INFO UpdateTimestampsCache:35 - starting update timestamps cache at region: net.sf.hibernate.cache.UpdateTimestampsCache
[java] 00:32:55,421 INFO DriverManagerConnectionProvider:143 - cleaning up
connection pool: jdbc:mysql://localhost/
[java] 00:32:55,593 WARN EhCache:94 - Could not find configuration for net.sf.hibernate.cache.UpdateTimestampsCache. Configuring using the defaultCache settings.
[java] 00:32:55,656 INFO StandardQueryCache:41 - starting query cache at region: net.sf.hibernate.cache.StandardQueryCache
[java] 00:32:55,671 WARN EhCache:94 - Could not find configuration for net.sf.hibernate.cache.StandardQueryCache. Configuring using the defaultCache settings.
[java] Setting up some test data
[java] 00:32:56,031 WARN JDBCExceptionReporter:57 - SQL Error: 0, SQLState: 08S01
[java] 00:32:56,031 ERROR JDBCExceptionReporter:58 - Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused: connect
[java] net.sf.hibernate.exception.GenericJDBCException: Cannot open connection
[java] at net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90)
[java] at net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:79)
[java] at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:30)
[java] at net.sf.hibernate.impl.BatcherImpl.convert(BatcherImpl.java:325)
[java] at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:292)
[java] at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3361)
[java] at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3321)
[java] at net.sf.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:40)
[java] at net.sf.hibernate.transaction.JDBCTransactionFactory.beginTransaction(JDBCTransactionFactory.java:19)
[java] at net.sf.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:2251)
[java] at org.hibernate.auction.Main.createTestAuctions(Main.java:284)
[java] at org.hibernate.auction.Main.main(Main.java:365)
[java] Caused by: java.sql.SQLException: Unable to connect to any hosts due
to exception: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1622)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:491)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)
[java] at java.sql.DriverManager.getConnection(DriverManager.java:512)
[java] at java.sql.DriverManager.getConnection(DriverManager.java:140)
[java] at net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:101)
[java] at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:289)
[java] ... 7 more
[java] Exception in thread "main"


Any help is appreciated!

_________________
/Daniel


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

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.