java.sql.SQLException: java.lang.NullPointerException

Pentaho BI Platform Tracking | Anthony Carter | 5 years ago
  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 | 5 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 | 5 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.

    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

      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