java.sql.SQLException: java.lang.NullPointerException

Pentaho BI Platform Tracking | Anthony Carter | 6 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    I created a connection in PSW with my standard mysql information. The same works from PRD. I was using the mysql-connector provided in the tomcat/lib folder of the BI-Server: mysql-connector-java-5.0.7.jar If I replace it with the one in the data-integration-server (mysql-connector-java-3.1.14-bin.jar), connection is fine. While the test works, clicking OK and using the JDBC Explorer and/or a new schema, no db schemas are returned. Error: 23:44:45,955 ERROR [JdbcMetaData] setAllTables java.sql.SQLException: java.lang.NullPointerException at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910) at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPrepared Statement.java:766) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:874) at com.mysql.jdbc.Statement.createResultSetUsingServerFetch(Statement.ja va:520) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1133) at com.mysql.jdbc.DatabaseMetaData.extractForeignKeyFromCreateTable(Data baseMetaData.java:1141) at com.mysql.jdbc.DatabaseMetaData$5.forEach(DatabaseMetaData.java:3231) at com.mysql.jdbc.DatabaseMetaData$IterateBlock.doForAll(DatabaseMetaDat a.java:76) at com.mysql.jdbc.DatabaseMetaData.getImportedKeys(DatabaseMetaData.java :3219) at mondrian.gui.JdbcMetaData.setAllTables(JdbcMetaData.java:291) at mondrian.gui.JdbcMetaData.setAllSchemas(JdbcMetaData.java:258) at mondrian.gui.JdbcMetaData.<init>(JdbcMetaData.java:67) at mondrian.gui.Workbench.getNewJdbcMetadata(Workbench.java:1975) at mondrian.gui.Workbench.newJDBCExplorerMenuItemActionPerformed(Workben ch.java:1153) at mondrian.gui.Workbench.access$300(Workbench.java:94) at mondrian.gui.Workbench$13.actionPerformed(Workbench.java:612) at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.setPressed(Unknown Source) at javax.swing.AbstractButton.doClick(Unknown Source) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source) at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source) at java.awt.Component.processMouseEvent(Unknown Source) at javax.swing.JComponent.processMouseEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source)

    Pentaho BI Platform Tracking | 6 years ago | Anthony Carter
    java.sql.SQLException: java.lang.NullPointerException
  2. 0

    I created a connection in PSW with my standard mysql information. The same works from PRD. I was using the mysql-connector provided in the tomcat/lib folder of the BI-Server: mysql-connector-java-5.0.7.jar If I replace it with the one in the data-integration-server (mysql-connector-java-3.1.14-bin.jar), connection is fine. While the test works, clicking OK and using the JDBC Explorer and/or a new schema, no db schemas are returned. Error: 23:44:45,955 ERROR [JdbcMetaData] setAllTables java.sql.SQLException: java.lang.NullPointerException at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910) at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPrepared Statement.java:766) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:874) at com.mysql.jdbc.Statement.createResultSetUsingServerFetch(Statement.ja va:520) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1133) at com.mysql.jdbc.DatabaseMetaData.extractForeignKeyFromCreateTable(Data baseMetaData.java:1141) at com.mysql.jdbc.DatabaseMetaData$5.forEach(DatabaseMetaData.java:3231) at com.mysql.jdbc.DatabaseMetaData$IterateBlock.doForAll(DatabaseMetaDat a.java:76) at com.mysql.jdbc.DatabaseMetaData.getImportedKeys(DatabaseMetaData.java :3219) at mondrian.gui.JdbcMetaData.setAllTables(JdbcMetaData.java:291) at mondrian.gui.JdbcMetaData.setAllSchemas(JdbcMetaData.java:258) at mondrian.gui.JdbcMetaData.<init>(JdbcMetaData.java:67) at mondrian.gui.Workbench.getNewJdbcMetadata(Workbench.java:1975) at mondrian.gui.Workbench.newJDBCExplorerMenuItemActionPerformed(Workben ch.java:1153) at mondrian.gui.Workbench.access$300(Workbench.java:94) at mondrian.gui.Workbench$13.actionPerformed(Workbench.java:612) at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.setPressed(Unknown Source) at javax.swing.AbstractButton.doClick(Unknown Source) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source) at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source) at java.awt.Component.processMouseEvent(Unknown Source) at javax.swing.JComponent.processMouseEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source)

    Pentaho BI Platform Tracking | 6 years ago | Anthony Carter
    java.sql.SQLException: java.lang.NullPointerException
  3. 0

    schema workbench (3.2.1.13885) error at connection at MySQL database (not at "Test")

    pentaho.com | 2 years ago
    java.sql.SQLException: java.lang.NullPointerException
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Hello, we encountered an error when using MySQL with the database-structure macro. We used only the dataSource parameter: {database-structure:dataSource=waveDS} Confluence-Version: 4.3.5 Stacktrace: {noformat} 2014-01-29 09:35:51,110 ERROR [TP-Processor6] [confluence.plugins.plantuml.AbstractDatabaseStructureMacroImpl] sqlException SQLException waveDS -- url: /confluence/display/~username/PlantUML+Database+Structure+Test | page: 15466510 | userName: username| referer: http://eudesgjra1wp/confluence/pages/createpage.action?spaceKey=~username&fromPageId=2293975 | action: viewpage java.sql.SQLException: Table not specified. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) at com.mysql.jdbc.DatabaseMetaData.getImportedKeys(DatabaseMetaData.java:3305) at org.apache.tomcat.dbcp.dbcp.DelegatingDatabaseMetaData.getImportedKeys(DelegatingDatabaseMetaData.java:314) at de.griffel.confluence.plugins.plantuml.AbstractDatabaseStructureMacroImpl.getForeignKeys(AbstractDatabaseStructureMacroImpl.java:393) at de.griffel.confluence.plugins.plantuml.AbstractDatabaseStructureMacroImpl.createDotForDatabaseStructure(AbstractDatabaseStructureMacroImpl.java:101) at de.griffel.confluence.plugins.plantuml.DatabaseStructureMacroV4$1.executePlantUmlMacro(DatabaseStructureMacroV4.java:81) at de.griffel.confluence.plugins.plantuml.AbstractDatabaseStructureMacroImpl.execute(AbstractDatabaseStructureMacroImpl.java:73) at de.griffel.confluence.plugins.plantuml.DatabaseStructureMacroV4.execute(DatabaseStructureMacroV4.java:77) at sun.reflect.GeneratedMethodAccessor920.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at com.atlassian.confluence.macro.xhtml.XhtmlMacroManager$ResourceAwareMacroInvocationHandler.invoke(XhtmlMacroManager.java:220) at $Proxy1372.execute(Unknown Source) at com.atlassian.confluence.content.render.xhtml.view.macro.ViewMacroMarshaller.marshal(ViewMacroMarshaller.java:88) at com.atlassian.confluence.content.render.xhtml.view.macro.ViewMacroMarshaller.marshal(ViewMacroMarshaller.java:24) at com.atlassian.confluence.content.render.xhtml.UnmarshalMarshalFragmentTransformer.transform(UnmarshalMarshalFragmentTransformer.java:27) at com.atlassian.confluence.content.render.xhtml.transformers.DefaultFragmentTransformer.transform(DefaultFragmentTransformer.java:106) at com.atlassian.confluence.content.render.xhtml.storage.StorageXhtmlTransformer.transform(StorageXhtmlTransformer.java:43) at com.atlassian.confluence.content.render.xhtml.TransformerChain.transform(TransformerChain.java:41) at com.atlassian.confluence.content.render.xhtml.PluggableTransformerChain.transform(PluggableTransformerChain.java:53) at com.atlassian.confluence.content.render.xhtml.DefaultRenderer.render(DefaultRenderer.java:80) at com.atlassian.confluence.content.render.xhtml.DefaultRenderer.render(DefaultRenderer.java:68) at com.atlassian.confluence.content.render.xhtml.DefaultRenderer.render(DefaultRenderer.java:58) at com.atlassian.confluence.content.render.xhtml.DeviceTypeAwareRenderer.render(DeviceTypeAwareRenderer.java:42) at com.atlassian.confluence.pages.actions.ViewPageAction.execute(ViewPageAction.java:245) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:64) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.xwork.interceptors.XsrfTokenInterceptor.intercept(XsrfTokenInterceptor.java:100) at com.atlassian.confluence.xwork.ConfluenceXsrfTokenInterceptor.intercept(ConfluenceXsrfTokenInterceptor.java:25) {noformat}

    JIRA | 3 years ago | David Franke
    java.sql.SQLException: Table not specified.

    Root Cause Analysis

    1. java.sql.SQLException

      java.lang.NullPointerException

      at com.mysql.jdbc.SQLError.createSQLException()
    2. MySQL jdbc
      DatabaseMetaData.getImportedKeys
      1. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
      2. com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:766)
      3. com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:874)
      4. com.mysql.jdbc.Statement.createResultSetUsingServerFetch(Statement.java:520)
      5. com.mysql.jdbc.Statement.executeQuery(Statement.java:1133)
      6. com.mysql.jdbc.DatabaseMetaData.extractForeignKeyFromCreateTable(DatabaseMetaData.java:1141)
      7. com.mysql.jdbc.DatabaseMetaData$5.forEach(DatabaseMetaData.java:3231)
      8. com.mysql.jdbc.DatabaseMetaData$IterateBlock.doForAll(DatabaseMetaData.java:76)
      9. com.mysql.jdbc.DatabaseMetaData.getImportedKeys(DatabaseMetaData.java:3219)
      9 frames
    3. mondrian.gui
      Workbench$13.actionPerformed
      1. mondrian.gui.JdbcMetaData.setAllTables(JdbcMetaData.java:291)
      2. mondrian.gui.JdbcMetaData.setAllSchemas(JdbcMetaData.java:258)
      3. mondrian.gui.JdbcMetaData.<init>(JdbcMetaData.java:67)
      4. mondrian.gui.Workbench.getNewJdbcMetadata(Workbench.java:1975)
      5. mondrian.gui.Workbench.newJDBCExplorerMenuItemActionPerformed(Workbench.java:1153)
      6. mondrian.gui.Workbench.access$300(Workbench.java:94)
      7. mondrian.gui.Workbench$13.actionPerformed(Workbench.java:612)
      7 frames
    4. Java RT
      EventDispatchThread.run
      1. javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
      2. javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
      3. javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
      4. javax.swing.DefaultButtonModel.setPressed(Unknown Source)
      5. javax.swing.AbstractButton.doClick(Unknown Source)
      6. javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
      7. javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(UnknownSource)
      8. java.awt.Component.processMouseEvent(Unknown Source)
      9. javax.swing.JComponent.processMouseEvent(Unknown Source)
      10. java.awt.Component.processEvent(Unknown Source)
      11. java.awt.Container.processEvent(Unknown Source)
      12. java.awt.Component.dispatchEventImpl(Unknown Source)
      13. java.awt.Container.dispatchEventImpl(Unknown Source)
      14. java.awt.Component.dispatchEvent(Unknown Source)
      15. java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
      16. java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
      17. java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
      18. java.awt.Container.dispatchEventImpl(Unknown Source)
      19. java.awt.Window.dispatchEventImpl(Unknown Source)
      20. java.awt.Component.dispatchEvent(Unknown Source)
      21. java.awt.EventQueue.dispatchEvent(Unknown Source)
      22. java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
      23. java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
      24. java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
      25. java.awt.EventDispatchThread.pumpEvents(Unknown Source)
      26. java.awt.EventDispatchThread.pumpEvents(Unknown Source)
      27. java.awt.EventDispatchThread.run(Unknown Source)
      27 frames