java.sql.SQLException: Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused: connect

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Synopsis: When running SchemaExport from a Java program SQL exceptions are not caught in application catch clause. This means I am unable to detect programmatically if there is a failure in SchemaExport. I invoke SchemaExport with the following code: try { Configuration l_Configuration = new Configuration(); l_Configuration.configure(); SchemaExport l_SchemaExport = new SchemaExport( l_Configuration ); l_SchemaExport.create( true, true ); } catch ( Exception ex ) { System.out.println( "catch received" ); } In this case the MySQL database has not been started. Even though there is an exception it is never caught in the application catch. Here is the SchemaExport log: Mar 24, 2004 12:49:45 PM net.sf.hibernate.cfg.Environment <clinit> INFO: Hibernate 2.1.2 Mar 24, 2004 12:49:45 PM net.sf.hibernate.cfg.Environment <clinit> INFO: hibernate.properties not found Mar 24, 2004 12:49:45 PM net.sf.hibernate.cfg.Environment <clinit> INFO: using CGLIB reflection optimizer Mar 24, 2004 12:49:45 PM net.sf.hibernate.cfg.Configuration configure INFO: configuring from resource: /hibernate.cfg.xml Mar 24, 2004 12:49:45 PM net.sf.hibernate.cfg.Configuration getConfigurationInputStream INFO: Configuration resource: /hibernate.cfg.xml Mar 24, 2004 12:49:45 PM net.sf.hibernate.cfg.Configuration addResource INFO: Mapping resource: HibernateMapping.xml Mar 24, 2004 12:49:45 PM net.sf.hibernate.cfg.Binder bindRootClass INFO: Mapping class: com.digitalwake.datamanager.Root -> Root Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Binder bindRootClass INFO: Mapping class: com.digitalwake.datamanager.Organization -> Organization Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Binder bindRootClass INFO: Mapping class: com.digitalwake.datamanager.Attribute -> Attribute Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Binder bindRootClass INFO: Mapping class: com.digitalwake.datamanager.DataType -> DataType Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Binder bindSubclass INFO: Mapping subclass: com.digitalwake.datamanager.TextType -> DataType Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Binder bindSubclass INFO: Mapping subclass: com.digitalwake.datamanager.URLType -> DataType Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Binder bindSubclass INFO: Mapping subclass: com.digitalwake.datamanager.NumericType -> DataType Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Binder bindSubclass INFO: Mapping subclass: com.digitalwake.datamanager.TimeType -> DataType Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Configuration doConfigure INFO: Configured SessionFactory: null Mar 24, 2004 12:49:46 PM net.sf.hibernate.dialect.Dialect <init> INFO: Using dialect: net.sf.hibernate.dialect.MySQLDialect Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Configuration secondPassCompile INFO: processing one-to-many association mappings Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Binder bindCollectionSecondPass INFO: Mapping collection: com.digitalwake.datamanager.Root.Organizations -> Organization Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Binder bindCollectionSecondPass INFO: Mapping collection: com.digitalwake.datamanager.Root.DataTypes -> DataType Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Binder bindCollectionSecondPass INFO: Mapping collection: com.digitalwake.datamanager.Organization.Attributes -> Attribute Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Configuration secondPassCompile INFO: processing one-to-one association property references Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Configuration secondPassCompile INFO: processing foreign key constraints Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Configuration secondPassCompile INFO: processing one-to-many association mappings Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Configuration secondPassCompile INFO: processing one-to-one association property references Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Configuration secondPassCompile INFO: processing foreign key constraints Mar 24, 2004 12:49:46 PM net.sf.hibernate.tool.hbm2ddl.SchemaExport execute INFO: Running hbm2ddl schema export Mar 24, 2004 12:49:46 PM net.sf.hibernate.tool.hbm2ddl.SchemaExport execute INFO: exporting generated schema to database Mar 24, 2004 12:49:46 PM net.sf.hibernate.connection.DriverManagerConnectionProvider configure INFO: Using Hibernate built-in connection pool (not for production use!) Mar 24, 2004 12:49:46 PM net.sf.hibernate.connection.DriverManagerConnectionProvider configure INFO: Hibernate connection pool size: 20 Mar 24, 2004 12:49:46 PM net.sf.hibernate.connection.DriverManagerConnectionProvider configure INFO: using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql:///DigitalWake Mar 24, 2004 12:49:46 PM net.sf.hibernate.connection.DriverManagerConnectionProvider configure INFO: connection properties: {} Mar 24, 2004 12:49:47 PM net.sf.hibernate.tool.hbm2ddl.SchemaExport execute SEVERE: schema export unsuccessful java.sql.SQLException: Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused: connect at com.mysql.jdbc.Connection.createNewIO(Connection.java:1690) at com.mysql.jdbc.Connection.<init>(Connection.java:427) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:395) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:140) at net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:95) at net.sf.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:119) at net.sf.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:84) at com.digitalwake.datamanager.test.createSchemaTest(test.java:48) at com.digitalwake.datamanager.test.main(test.java:37)
    via by Bruce Scott,
  • Synopsis: When running SchemaExport from a Java program SQL exceptions are not caught in application catch clause. This means I am unable to detect programmatically if there is a failure in SchemaExport. I invoke SchemaExport with the following code: try { Configuration l_Configuration = new Configuration(); l_Configuration.configure(); SchemaExport l_SchemaExport = new SchemaExport( l_Configuration ); l_SchemaExport.create( true, true ); } catch ( Exception ex ) { System.out.println( "catch received" ); } In this case the MySQL database has not been started. Even though there is an exception it is never caught in the application catch. Here is the SchemaExport log: Mar 24, 2004 12:49:45 PM net.sf.hibernate.cfg.Environment <clinit> INFO: Hibernate 2.1.2 Mar 24, 2004 12:49:45 PM net.sf.hibernate.cfg.Environment <clinit> INFO: hibernate.properties not found Mar 24, 2004 12:49:45 PM net.sf.hibernate.cfg.Environment <clinit> INFO: using CGLIB reflection optimizer Mar 24, 2004 12:49:45 PM net.sf.hibernate.cfg.Configuration configure INFO: configuring from resource: /hibernate.cfg.xml Mar 24, 2004 12:49:45 PM net.sf.hibernate.cfg.Configuration getConfigurationInputStream INFO: Configuration resource: /hibernate.cfg.xml Mar 24, 2004 12:49:45 PM net.sf.hibernate.cfg.Configuration addResource INFO: Mapping resource: HibernateMapping.xml Mar 24, 2004 12:49:45 PM net.sf.hibernate.cfg.Binder bindRootClass INFO: Mapping class: com.digitalwake.datamanager.Root -> Root Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Binder bindRootClass INFO: Mapping class: com.digitalwake.datamanager.Organization -> Organization Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Binder bindRootClass INFO: Mapping class: com.digitalwake.datamanager.Attribute -> Attribute Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Binder bindRootClass INFO: Mapping class: com.digitalwake.datamanager.DataType -> DataType Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Binder bindSubclass INFO: Mapping subclass: com.digitalwake.datamanager.TextType -> DataType Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Binder bindSubclass INFO: Mapping subclass: com.digitalwake.datamanager.URLType -> DataType Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Binder bindSubclass INFO: Mapping subclass: com.digitalwake.datamanager.NumericType -> DataType Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Binder bindSubclass INFO: Mapping subclass: com.digitalwake.datamanager.TimeType -> DataType Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Configuration doConfigure INFO: Configured SessionFactory: null Mar 24, 2004 12:49:46 PM net.sf.hibernate.dialect.Dialect <init> INFO: Using dialect: net.sf.hibernate.dialect.MySQLDialect Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Configuration secondPassCompile INFO: processing one-to-many association mappings Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Binder bindCollectionSecondPass INFO: Mapping collection: com.digitalwake.datamanager.Root.Organizations -> Organization Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Binder bindCollectionSecondPass INFO: Mapping collection: com.digitalwake.datamanager.Root.DataTypes -> DataType Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Binder bindCollectionSecondPass INFO: Mapping collection: com.digitalwake.datamanager.Organization.Attributes -> Attribute Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Configuration secondPassCompile INFO: processing one-to-one association property references Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Configuration secondPassCompile INFO: processing foreign key constraints Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Configuration secondPassCompile INFO: processing one-to-many association mappings Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Configuration secondPassCompile INFO: processing one-to-one association property references Mar 24, 2004 12:49:46 PM net.sf.hibernate.cfg.Configuration secondPassCompile INFO: processing foreign key constraints Mar 24, 2004 12:49:46 PM net.sf.hibernate.tool.hbm2ddl.SchemaExport execute INFO: Running hbm2ddl schema export Mar 24, 2004 12:49:46 PM net.sf.hibernate.tool.hbm2ddl.SchemaExport execute INFO: exporting generated schema to database Mar 24, 2004 12:49:46 PM net.sf.hibernate.connection.DriverManagerConnectionProvider configure INFO: Using Hibernate built-in connection pool (not for production use!) Mar 24, 2004 12:49:46 PM net.sf.hibernate.connection.DriverManagerConnectionProvider configure INFO: Hibernate connection pool size: 20 Mar 24, 2004 12:49:46 PM net.sf.hibernate.connection.DriverManagerConnectionProvider configure INFO: using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql:///DigitalWake Mar 24, 2004 12:49:46 PM net.sf.hibernate.connection.DriverManagerConnectionProvider configure INFO: connection properties: {} Mar 24, 2004 12:49:47 PM net.sf.hibernate.tool.hbm2ddl.SchemaExport execute SEVERE: schema export unsuccessful java.sql.SQLException: Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused: connect at com.mysql.jdbc.Connection.createNewIO(Connection.java:1690) at com.mysql.jdbc.Connection.<init>(Connection.java:427) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:395) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:140) at net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:95) at net.sf.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:119) at net.sf.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:84) at com.digitalwake.datamanager.test.createSchemaTest(test.java:48) at com.digitalwake.datamanager.test.main(test.java:37)
    via by Bruce Scott,
  • cant install mysql driver
    via by 807595,
  • JDBC:Connection Issue When Run program
    via Stack Overflow by hamel123
    ,
  • schema workbench
    via by Fanni Zoraya,
  • Access remote Db
    via Stack Overflow by SkyLark
    ,
  • Installation error
    via infoglue by nobody
    ,
  • Android studio JDBC MySQL
    via Stack Overflow by scarface
    ,
    • java.sql.SQLException: Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused: connect at com.mysql.jdbc.Connection.createNewIO(Connection.java:1690) at com.mysql.jdbc.Connection.<init>(Connection.java:427) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:395) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:140) at net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:95) at net.sf.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:119) at net.sf.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:84) at com.digitalwake.datamanager.test.createSchemaTest(test.java:48) at com.digitalwake.datamanager.test.main(test.java:37)

    Users with the same issue

    linxiaolong
    linxiaolong2 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    3 more bugmates