java.sql.SQLException

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.

  • 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)
    via by Phillip Cole,
  • 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)
    via by Phillip Cole,
  • Using SSL with HSQLDB
    via hsqldb by rickwalsh
    ,
  • JDO - datanucleus - HSQL error
    via Stack Overflow by Aniruddha
    ,
  • Changing hibernate port and host is not working in admin console Oct 2, 2008 12:06:46 PM org.hibernate.connection.DriverManagerConnectionProvider configure INFO: using driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:hsql://localhost:9001/hibernate Oct 2, 2008 12:06:46 PM org.hibernate.connection.DriverManagerConnectionProvider configure INFO: connection properties: {user=hibuser, password=****} Oct 2, 2008 12:06:47 PM org.hibernate.cfg.SettingsFactory buildSettings WARNING: Could not obtain connection metadata 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(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110) at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84) at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2073) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1298) at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:859) at org.pentaho.pac.server.common.HibernateSessionFactory.addOrUpdateConfiguration(HibernateSessionFactory.java:64) at org.pentaho.pac.server.common.HibernateSessionFactory.addConfiguration(HibernateSessionFactory.java:53) at org.pentaho.pac.server.common.HibernateSessionFactory.addDefaultConfiguration(HibernateSessionFactory.java:43) at org.pentaho.pac.server.PacServiceImpl.initialze(PacServiceImpl.java:984) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:527) at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:164) at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:86) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:367) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:712) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:139) at org.mortbay.jetty.Server.handle(Server.java:285) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:502) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:835) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:638) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:202) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:378) at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:226) at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:450)
    via by Ramaiz Mansoor,
  • Installing using the hsqldb
    via xplanner by mcmoisei
    ,
  • After configure Pentaho 5.4 with a Postgres database repository, it runs fine. But if I disable HSQLDB in the web.xml file I get some error at startup process. <!-- [BEGIN HSQLDB DATABASES] --> <!-- <context-param> <param-name>hsqldb-databases</param-name> <param-value>sampledata@../../data/hsqldb/sampledata,hibernate@../../data/hsqldb/hibernate,quartz@../../data/hsqldb/quartz</param-value> </context-param> --> <!-- [END HSQLDB DATABASES] --> <!-- [BEGIN HSQLDB STARTER] --> <!-- <listener> <listener-class>org.pentaho.platform.web.http.context.HsqldbStartupListener</listener-class> --> </listener> <!-- [END HSQLDB STARTER] --> 14:46:03,315 ERROR [PentahoDataSourceResolver] PentahoXmlaServlet.ERROR_0002 - IDatasourceService.UNABLE_TO_INSTANTIATE_OBJECT org.pentaho.platform.api.data.DBDatasourceServiceException: java.sql.SQLException: socket creation error at org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledDatasourceHelper.setupPooledDataSource(PooledDatasourceHelper.java:290) at org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledOrJndiDatasourceService.resolveDatabaseConnection(PooledOrJndiDatasourceService.java:31) at org.pentaho.platform.engine.services.connection.datasource.dbcp.NonPooledOrJndiDatasourceService.retrieve(NonPooledOrJndiDatasourceService.java:51) at org.pentaho.platform.engine.services.connection.datasource.dbcp.BaseDatasourceService.getDataSource(BaseDatasourceService.java:69) at org.pentaho.platform.engine.services.connection.datasource.dbcp.DynamicallyPooledOrJndiDatasourceService.resolveDatabaseConnection(DynamicallyPooledOrJndiDatasourceService.java:37) at org.pentaho.platform.engine.services.connection.datasource.dbcp.NonPooledOrJndiDatasourceService.retrieve(NonPooledOrJndiDatasourceService.java:51) at org.pentaho.platform.engine.services.connection.datasource.dbcp.BaseDatasourceService.getDataSource(BaseDatasourceService.java:69) at org.pentaho.platform.web.servlet.PentahoDataSourceResolver.lookup(PentahoDataSourceResolver.java:43) at mondrian.rolap.RolapConnection.createDataSource(RolapConnection.java:429) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:135) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:91) at mondrian.olap.DriverManager.getConnection(DriverManager.java:113) at mondrian.olap.DriverManager.getConnection(DriverManager.java:69) at mondrian.olap4j.MondrianOlap4jConnection.<init>(MondrianOlap4jConnection.java:162) at mondrian.olap4j.FactoryJdbc4Plus$AbstractConnection.<init>(FactoryJdbc4Plus.java:323) at mondrian.olap4j.FactoryJdbc41Impl$MondrianOlap4jConnectionJdbc41.<init>(FactoryJdbc41Impl.java:118) at mondrian.olap4j.FactoryJdbc41Impl.newConnection(FactoryJdbc41Impl.java:32) at mondrian.olap4j.MondrianOlap4jDriver.connect(MondrianOlap4jDriver.java:134) at java.sql.DriverManager.getConnection(DriverManager.java:571) at java.sql.DriverManager.getConnection(DriverManager.java:187) at mondrian.server.FileRepository.getConnection(FileRepository.java:220) at mondrian.server.FileRepository.getConnection(FileRepository.java:182) at mondrian.server.MondrianServerImpl.getConnection(MondrianServerImpl.java:264) at org.pentaho.platform.plugin.action.olap.impl.OlapServiceImpl.getConnection(OlapServiceImpl.java:741) at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.flushCacheForCatalog(MondrianCatalogHelper.java:659) at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.addCatalog(MondrianCatalogHelper.java:650) at org.pentaho.platform.plugin.services.importer.MondrianImportHandler.importFile(MondrianImportHandler.java:106) at org.pentaho.platform.plugin.services.importer.PentahoPlatformImporter.importFile(PentahoPlatformImporter.java:115) at org.pentaho.platform.plugin.services.importer.SolutionImportHandler.importFile(SolutionImportHandler.java:155) at org.pentaho.platform.plugin.services.importer.PentahoPlatformImporter.importFile(PentahoPlatformImporter.java:115) at org.pentaho.platform.plugin.services.importer.ArchiveLoader.loadAll(ArchiveLoader.java:63) at org.pentaho.platform.plugin.action.defaultcontent.DefaultContentSystemListener$1.call(DefaultContentSystemListener.java:56) at org.pentaho.platform.plugin.action.defaultcontent.DefaultContentSystemListener$1.call(DefaultContentSystemListener.java:43) at org.pentaho.platform.engine.security.SecurityHelper.runAsSystem(SecurityHelper.java:396) at org.pentaho.platform.plugin.action.defaultcontent.DefaultContentSystemListener.startup(DefaultContentSystemListener.java:43) at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:421) at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:412) at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:391) at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:412) at org.pentaho.platform.engine.core.system.PentahoSystem.access$000(PentahoSystem.java:77) at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:343) at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:340) at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:391) at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:340) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:311) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:212) at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:135) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4210) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4709) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:802) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:583) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1079) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1002) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1068) at org.apache.catalina.core.StandardHost.start(StandardHost.java:822) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1060) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463) at org.apache.catalina.core.StandardService.start(StandardService.java:525) at org.apache.catalina.core.StandardServer.start(StandardServer.java:759) at org.apache.catalina.startup.Catalina.start(Catalina.java:595) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) Caused by: 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:571) at java.sql.DriverManager.getConnection(DriverManager.java:215) at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) at org.apache.commons.pool.impl.GenericObjectPool.addObject(GenericObjectPool.java:1679) at org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledDatasourceHelper.setupPooledDataSource(PooledDatasourceHelper.java:271) ... 70 more 14:46:03,716 ERROR [PentahoDataSourceResolver] PentahoXmlaServlet.ERROR_0002 - IDatasourceService.UNABLE_TO_INSTANTIATE_OBJECT org.pentaho.platform.api.data.DBDatasourceServiceException: java.sql.SQLException: socket creation error at org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledDatasourceHelper.setupPooledDataSource(PooledDatasourceHelper.java:290) at org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledOrJndiDatasourceService.resolveDatabaseConnection(PooledOrJndiDatasourceService.java:31) at org.pentaho.platform.engine.services.connection.datasource.dbcp.NonPooledOrJndiDatasourceService.retrieve(NonPooledOrJndiDatasourceService.java:51) at org.pentaho.platform.engine.services.connection.datasource.dbcp.BaseDatasourceService.getDataSource(BaseDatasourceService.java:69) at org.pentaho.platform.engine.services.connection.datasource.dbcp.DynamicallyPooledOrJndiDatasourceService.resolveDatabaseConnection(DynamicallyPooledOrJndiDatasourceService.java:37) at org.pentaho.platform.engine.services.connection.datasource.dbcp.NonPooledOrJndiDatasourceService.retrieve(NonPooledOrJndiDatasourceService.java:51) at org.pentaho.platform.engine.services.connection.datasource.dbcp.BaseDatasourceService.getDataSource(BaseDatasourceService.java:69) at org.pentaho.platform.web.servlet.PentahoDataSourceResolver.lookup(PentahoDataSourceResolver.java:43) at mondrian.rolap.RolapConnection.createDataSource(RolapConnection.java:429) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:135) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:91) at mondrian.olap.DriverManager.getConnection(DriverManager.java:113) at mondrian.olap.DriverManager.getConnection(DriverManager.java:69) at mondrian.olap4j.MondrianOlap4jConnection.<init>(MondrianOlap4jConnection.java:162) at mondrian.olap4j.FactoryJdbc4Plus$AbstractConnection.<init>(FactoryJdbc4Plus.java:323) at mondrian.olap4j.FactoryJdbc41Impl$MondrianOlap4jConnectionJdbc41.<init>(FactoryJdbc41Impl.java:118) at mondrian.olap4j.FactoryJdbc41Impl.newConnection(FactoryJdbc41Impl.java:32) at mondrian.olap4j.MondrianOlap4jDriver.connect(MondrianOlap4jDriver.java:134) at java.sql.DriverManager.getConnection(DriverManager.java:571) at java.sql.DriverManager.getConnection(DriverManager.java:187) at mondrian.server.FileRepository.getConnection(FileRepository.java:220) at mondrian.server.FileRepository.getConnection(FileRepository.java:182) at mondrian.server.MondrianServerImpl.getConnection(MondrianServerImpl.java:264) at org.pentaho.platform.plugin.action.olap.impl.OlapServiceImpl.getConnection(OlapServiceImpl.java:741) at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.flushCacheForCatalog(MondrianCatalogHelper.java:659) at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.addCatalog(MondrianCatalogHelper.java:650) at org.pentaho.platform.plugin.services.importer.MondrianImportHandler.importFile(MondrianImportHandler.java:106) at org.pentaho.platform.plugin.services.importer.PentahoPlatformImporter.importFile(PentahoPlatformImporter.java:115) at org.pentaho.platform.plugin.services.importer.SolutionImportHandler.importFile(SolutionImportHandler.java:155) at org.pentaho.platform.plugin.services.importer.PentahoPlatformImporter.importFile(PentahoPlatformImporter.java:115) at org.pentaho.platform.plugin.services.importer.ArchiveLoader.loadAll(ArchiveLoader.java:63) at org.pentaho.platform.plugin.action.defaultcontent.DefaultContentSystemListener$1.call(DefaultContentSystemListener.java:56) at org.pentaho.platform.plugin.action.defaultcontent.DefaultContentSystemListener$1.call(DefaultContentSystemListener.java:43) at org.pentaho.platform.engine.security.SecurityHelper.runAsSystem(SecurityHelper.java:396) at org.pentaho.platform.plugin.action.defaultcontent.DefaultContentSystemListener.startup(DefaultContentSystemListener.java:43) at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:421) at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:412) at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:391) at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:412) at org.pentaho.platform.engine.core.system.PentahoSystem.access$000(PentahoSystem.java:77) at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:343) at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:340) at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:391) at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:340) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:311) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:212) at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:135) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4210) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4709) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:802) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:583) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1079) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1002) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1068) at org.apache.catalina.core.StandardHost.start(StandardHost.java:822) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1060) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463) at org.apache.catalina.core.StandardService.start(StandardService.java:525) at org.apache.catalina.core.StandardServer.start(StandardServer.java:759) at org.apache.catalina.startup.Catalina.start(Catalina.java:595) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) Caused by: 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:571) at java.sql.DriverManager.getConnection(DriverManager.java:215) at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) at org.apache.commons.pool.impl.GenericObjectPool.addObject(GenericObjectPool.java:1679) at org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledDatasourceHelper.setupPooledDataSource(PooledDatasourceHelper.java:271) ... 70 more
    via by Kleyson Rios,
    • 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)

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    11 more bugmates