No announcement yet.
  • Filter
  • Time
Clear All
new posts

  • socket creation error

    I am trying to experiment with SmartGWT enterprise edition modules. While trying to run the ds-hibernate and BuildInDs sample code I am getting the following error. The Hsqldb server is running fine as I can connect to it through a client application. Your help is greatly appreciated.


    DEBUG PoolableSQLConnectionFactory - [builtinApplication.supplyItem_fetch] DriverManager fetching connection for HSQLDB via jdbc url jdbc:hsqldb:hsql://localhost/isomorphic
    === 2009-07-06 12:19:31,223 [l0-2] WARN RequestContext - dsRequest.execute() failed:
    java.sql.SQLException: socket creation error
    at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
    at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
    at org.hsqldb.jdbcDriver.connect(Unknown Source)
    at java.sql.DriverManager.getConnection(
    Last edited by tullurir; 7th Jul 2009, 01:21.

  • #2
    Wherever the server is running, it's likely that that machine cannot resolve the name 'localhost'. Try specifying the IP instead if you don't know how to fix this.

    Another possibility is that the username or account that is running the server does not have the ability to use the network.


    • #3
      Thanks for the input.

      I tried hard coding the IP in the jdbc URL but got the same issue. However, the problem is gone when I changed the URL to create in-memory database by replacing 'hsql' to 'mem', thereby changing the jdbc URL from 'jdbc:hsqldb:hsql://localhost/isomorphic' to 'jdbc:hsqldb:mem://localhost/isomorphic'.

      Now I getting an exception that the table is not found.