java.sql.SQLException: socket creation error

hsqldb | rickwalsh | 10 years ago
  1. 0

    SUMMARY: Commenting out a piece of SQL that includes parameter e.g. ${PARAM} will cause reports to stop working. I expected the parameter to be ignored because it is commented out. Tested on Trunk snapshot as at 15-Oct-2009. TO REPRODUCE: 1. Open "samples\Operational Reports\Open Inventory.prpt" in PRD. 2. Check report runs OK 3. Edit the "default" data set and change the query to read as below. SELECT PRODUCTS.PRODUCTLINE, PRODUCTS.PRODUCTVENDOR, PRODUCTS.PRODUCTCODE, PRODUCTS.PRODUCTNAME, PRODUCTS.PRODUCTSCALE, PRODUCTS.PRODUCTDESCRIPTION, PRODUCTS.QUANTITYINSTOCK, PRODUCTS.BUYPRICE, PRODUCTS.MSRP FROM PRODUCTS /* COMMENTING OUT THIS RESTRICTION WHERE PRODUCTS.PRODUCTLINE IN (${line}) */ ORDER BY PRODUCTLINE ASC, PRODUCTVENDOR ASC, PRODUCTCODE ASC 4. Click the "Preview" button in the JDBC Data Source window. EXPECTED RESULT: Preview listing of all the fields for the full data set ACTUAL RESULT: The following error is received. The report doesn't work at all anymore. org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to open the connection: java.sql.SQLException: socket creation error at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.open(SimpleSQLReportDataFactory.java:402) at org.pentaho.reporting.ui.datasources.jdbc.ui.JdbcPreviewWorker.run(JdbcPreviewWorker.java:139) at java.lang.Thread.run(Thread.java:619) ParentException: 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(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at org.osjava.sj.loader.SJDataSource.getConnection(SJDataSource.java:97) at org.osjava.sj.loader.SJDataSource.getConnection(SJDataSource.java:77) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.JndiConnectionProvider.getConnection(JndiConnectionProvider.java:103) at org.pentaho.reporting.ui.datasources.jdbc.connection.JndiConnectionDefinition.createConnection(JndiConnectionDefinition.java:122) at org.pentaho.reporting.ui.datasources.jdbc.ui.JdbcPreviewWorker$PreviewConnectionProvider.getConnection(JdbcPreviewWorker.java:66) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.getConnection(SimpleSQLReportDataFactory.java:91) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.open(SimpleSQLReportDataFactory.java:397) at org.pentaho.reporting.ui.datasources.jdbc.ui.JdbcPreviewWorker.run(JdbcPreviewWorker.java:139) at java.lang.Thread.run(Thread.java:619)

    Pentaho BI Platform Tracking | 7 years ago | Phillip Cole
    java.sql.SQLException: socket creation error
  2. 0

    SUMMARY: Commenting out a piece of SQL that includes parameter e.g. ${PARAM} will cause reports to stop working. I expected the parameter to be ignored because it is commented out. Tested on Trunk snapshot as at 15-Oct-2009. TO REPRODUCE: 1. Open "samples\Operational Reports\Open Inventory.prpt" in PRD. 2. Check report runs OK 3. Edit the "default" data set and change the query to read as below. SELECT PRODUCTS.PRODUCTLINE, PRODUCTS.PRODUCTVENDOR, PRODUCTS.PRODUCTCODE, PRODUCTS.PRODUCTNAME, PRODUCTS.PRODUCTSCALE, PRODUCTS.PRODUCTDESCRIPTION, PRODUCTS.QUANTITYINSTOCK, PRODUCTS.BUYPRICE, PRODUCTS.MSRP FROM PRODUCTS /* COMMENTING OUT THIS RESTRICTION WHERE PRODUCTS.PRODUCTLINE IN (${line}) */ ORDER BY PRODUCTLINE ASC, PRODUCTVENDOR ASC, PRODUCTCODE ASC 4. Click the "Preview" button in the JDBC Data Source window. EXPECTED RESULT: Preview listing of all the fields for the full data set ACTUAL RESULT: The following error is received. The report doesn't work at all anymore. org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to open the connection: java.sql.SQLException: socket creation error at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.open(SimpleSQLReportDataFactory.java:402) at org.pentaho.reporting.ui.datasources.jdbc.ui.JdbcPreviewWorker.run(JdbcPreviewWorker.java:139) at java.lang.Thread.run(Thread.java:619) ParentException: 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(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at org.osjava.sj.loader.SJDataSource.getConnection(SJDataSource.java:97) at org.osjava.sj.loader.SJDataSource.getConnection(SJDataSource.java:77) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.JndiConnectionProvider.getConnection(JndiConnectionProvider.java:103) at org.pentaho.reporting.ui.datasources.jdbc.connection.JndiConnectionDefinition.createConnection(JndiConnectionDefinition.java:122) at org.pentaho.reporting.ui.datasources.jdbc.ui.JdbcPreviewWorker$PreviewConnectionProvider.getConnection(JdbcPreviewWorker.java:66) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.getConnection(SimpleSQLReportDataFactory.java:91) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.open(SimpleSQLReportDataFactory.java:397) at org.pentaho.reporting.ui.datasources.jdbc.ui.JdbcPreviewWorker.run(JdbcPreviewWorker.java:139) at java.lang.Thread.run(Thread.java:619)

    Pentaho BI Platform Tracking | 7 years ago | Phillip Cole
    java.sql.SQLException: socket creation error
  3. 0

    Using SSL with HSQLDB

    hsqldb | 10 years ago | rickwalsh
    java.sql.SQLException: socket creation error
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JDO - datanucleus - HSQL error

    Stack Overflow | 5 years ago | Aniruddha
    java.sql.SQLException: socket creation error

    5 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      socket creation error

      at org.hsqldb.jdbc.Util.sqlException()
    2. HSQLDB
      jdbcDriver.connect
      1. org.hsqldb.jdbc.Util.sqlException(Unknown Source)
      2. org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
      3. org.hsqldb.jdbcDriver.getConnection(Unknown Source)
      4. org.hsqldb.jdbcDriver.connect(Unknown Source)
      4 frames
    3. Java RT
      DriverManager.getConnection
      1. java.sql.DriverManager.getConnection(DriverManager.java:582)
      2. java.sql.DriverManager.getConnection(DriverManager.java:185)
      2 frames