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
|