java.sql.SQLException: This function is not supported

hsqldb | sheldonish | 1 decade 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

    IDENTITY() and PreparedStatements

    hsqldb | 1 decade ago | sheldonish
    java.sql.SQLException: This function is not supported
  2. 0

    Solving an SQL Result Set Error with JDBC/Spring

    Stack Overflow | 5 years ago | harryo
    java.lang.RuntimeException: java.sql.SQLException: Statement does not generate a result set
  3. 0

    An error occurred while getting property "currentStatus" from an instance of class jetbrains.buildServer.serverSide.impl.XmlRpcClientBasedAgent

    YouTrack | 1 decade ago
    java.sql.SQLException: S1000 General error java.lang.NegativeArraySizeException in statement [SELECT TEST_NAME, STATUS, TEST_ID FROM test_info WHERE BUILD_ID = ? and STATUS >= ?]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Open the JDBC Custom sample report in the Advanced folder. Select the Data tab, then double-click the Param1 parameter. Click the Table data source folder, then click the red X to delete it. Click Yes to confirm. The following errors appear: org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: ListColumns at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:236) at org.pentaho.reporting.designer.core.editor.parameters.ParameterDialog$QuerySelectionHandler.contentsChanged(ParameterDialog.java:584) at javax.swing.AbstractListModel.fireContentsChanged(AbstractListModel.java:100) at org.pentaho.reporting.designer.core.editor.parameters.StaticTextComboBoxModel.setValues(StaticTextComboBoxModel.java:46) at org.pentaho.reporting.designer.core.editor.parameters.ParameterDialog$DataSetQueryUpdateHandler.valueChanged(ParameterDialog.java:404) at org.pentaho.reporting.designer.core.editor.parameters.ParameterDialog$DataSetQueryUpdateHandler.treeStructureChanged(ParameterDialog.java:386) at org.pentaho.reporting.designer.core.editor.parameters.DataFactoryTreeModel.fireTreeDataChanged(DataFactoryTreeModel.java:221) at org.pentaho.reporting.designer.core.editor.parameters.DataFactoryTreeModel.fireTreeDataChanged(DataFactoryTreeModel.java:211) at org.pentaho.reporting.designer.core.editor.parameters.DataFactoryTreeModel.remove(DataFactoryTreeModel.java:269) at org.pentaho.reporting.designer.core.editor.parameters.ParameterDialog$RemoveDataSourceAction.actionPerformed(ParameterDialog.java:480) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272) at java.awt.Component.processMouseEvent(Component.java:6263) at javax.swing.JComponent.processMouseEvent(JComponent.java:3267) at java.awt.Component.processEvent(Component.java:6028) at java.awt.Container.processEvent(Container.java:2041) at java.awt.Component.dispatchEventImpl(Component.java:4630) at java.awt.Container.dispatchEventImpl(Container.java:2099) at java.awt.Component.dispatchEvent(Component.java:4460) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168) at java.awt.Container.dispatchEventImpl(Container.java:2085) at java.awt.Window.dispatchEventImpl(Window.java:2478) at java.awt.Component.dispatchEvent(Component.java:4460) at java.awt.EventQueue.dispatchEvent(EventQueue.java:599) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178) at java.awt.Dialog$1.run(Dialog.java:1046) at java.awt.Dialog$3.run(Dialog.java:1098) at java.security.AccessController.doPrivileged(Native Method) at java.awt.Dialog.show(Dialog.java:1096) at java.awt.Component.show(Component.java:1563) at java.awt.Component.setVisible(Component.java:1515) at java.awt.Window.setVisible(Window.java:842) at java.awt.Dialog.setVisible(Dialog.java:986) at org.pentaho.reporting.designer.core.editor.parameters.ParameterDialog.performEditParameter(ParameterDialog.java:2009) at org.pentaho.reporting.designer.core.actions.report.EditParametersAction.performEditMasterReportParameters(EditParametersAction.java:267) at org.pentaho.reporting.designer.core.editor.structuretree.StructureTreePanel$ReportTreeContextMenuHandler.mouseClicked(StructureTreePanel.java:130) at java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:253) at java.awt.Component.processMouseEvent(Component.java:6266) at javax.swing.JComponent.processMouseEvent(JComponent.java:3267) at java.awt.Component.processEvent(Component.java:6028) at java.awt.Container.processEvent(Container.java:2041) at java.awt.Component.dispatchEventImpl(Component.java:4630) at java.awt.Container.dispatchEventImpl(Container.java:2099) at java.awt.Component.dispatchEvent(Component.java:4460) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4247) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168) at java.awt.Container.dispatchEventImpl(Container.java:2085) at java.awt.Window.dispatchEventImpl(Window.java:2478) at java.awt.Component.dispatchEvent(Component.java:4460) at java.awt.EventQueue.dispatchEvent(EventQueue.java:599) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161) at java.awt.EventDispatchThread.run(EventDispatchThread.java:122) ParentException: java.sql.SQLException: Statement does not generate a result set at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.checkIsRowCount(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.executeQuery(Unknown Source) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.parametrizeAndQuery(SimpleSQLReportDataFactory.java:376) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:232) at org.pentaho.reporting.designer.core.editor.parameters.ParameterDialog$QuerySelectionHandler.contentsChanged(ParameterDialog.java:584) at javax.swing.AbstractListModel.fireContentsChanged(AbstractListModel.java:100) at org.pentaho.reporting.designer.core.editor.parameters.StaticTextComboBoxModel.setValues(StaticTextComboBoxModel.java:46) at org.pentaho.reporting.designer.core.editor.parameters.ParameterDialog$DataSetQueryUpdateHandler.valueChanged(ParameterDialog.java:404) at org.pentaho.reporting.designer.core.editor.parameters.ParameterDialog$DataSetQueryUpdateHandler.treeStructureChanged(ParameterDialog.java:386) at org.pentaho.reporting.designer.core.editor.parameters.DataFactoryTreeModel.fireTreeDataChanged(DataFactoryTreeModel.java:221) at org.pentaho.reporting.designer.core.editor.parameters.DataFactoryTreeModel.fireTreeDataChanged(DataFactoryTreeModel.java:211) at org.pentaho.reporting.designer.core.editor.parameters.DataFactoryTreeModel.remove(DataFactoryTreeModel.java:269) at org.pentaho.reporting.designer.core.editor.parameters.ParameterDialog$RemoveDataSourceAction.actionPerformed(ParameterDialog.java:480) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272) at java.awt.Component.processMouseEvent(Component.java:6263) at javax.swing.JComponent.processMouseEvent(JComponent.java:3267) at java.awt.Component.processEvent(Component.java:6028) at java.awt.Container.processEvent(Container.java:2041) at java.awt.Component.dispatchEventImpl(Component.java:4630) at java.awt.Container.dispatchEventImpl(Container.java:2099) at java.awt.Component.dispatchEvent(Component.java:4460) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168) at java.awt.Container.dispatchEventImpl(Container.java:2085) at java.awt.Window.dispatchEventImpl(Window.java:2478) at java.awt.Component.dispatchEvent(Component.java:4460) at java.awt.EventQueue.dispatchEvent(EventQueue.java:599) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178) at java.awt.Dialog$1.run(Dialog.java:1046) at java.awt.Dialog$3.run(Dialog.java:1098) at java.security.AccessController.doPrivileged(Native Method) at java.awt.Dialog.show(Dialog.java:1096) at java.awt.Component.show(Component.java:1563) at java.awt.Component.setVisible(Component.java:1515) at java.awt.Window.setVisible(Window.java:842) at java.awt.Dialog.setVisible(Dialog.java:986) at org.pentaho.reporting.designer.core.editor.parameters.ParameterDialog.performEditParameter(ParameterDialog.java:2009) at org.pentaho.reporting.designer.core.actions.report.EditParametersAction.performEditMasterReportParameters(EditParametersAction.java:267) at org.pentaho.reporting.designer.core.editor.structuretree.StructureTreePanel$ReportTreeContextMenuHandler.mouseClicked(StructureTreePanel.java:130) at java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:253) at java.awt.Component.processMouseEvent(Component.java:6266) at javax.swing.JComponent.processMouseEvent(JComponent.java:3267) at java.awt.Component.processEvent(Component.java:6028) at java.awt.Container.processEvent(Container.java:2041) at java.awt.Component.dispatchEventImpl(Component.java:4630) at java.awt.Container.dispatchEventImpl(Container.java:2099) at java.awt.Component.dispatchEvent(Component.java:4460) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4247) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168) at java.awt.Container.dispatchEventImpl(Container.java:2085) at java.awt.Window.dispatchEventImpl(Window.java:2478) at java.awt.Component.dispatchEvent(Component.java:4460) at java.awt.EventQueue.dispatchEvent(EventQueue.java:599) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161) at java.awt.EventDispatchThread.run(EventDispatchThread.java:122) And: java.lang.IndexOutOfBoundsException at org.pentaho.reporting.designer.core.editor.parameters.DataFactoryTreeCellRenderer.getTreeCellRendererComponent(DataFactoryTreeCellRenderer.java:69) at javax.swing.plaf.basic.BasicTreeUI$NodeDimensionsHandler.getNodeDimensions(BasicTreeUI.java:2712) at javax.swing.tree.AbstractLayoutCache.getNodeDimensions(AbstractLayoutCache.java:475) at javax.swing.tree.VariableHeightLayoutCache$TreeStateNode.updatePreferredSize(VariableHeightLayoutCache.java:1342) at javax.swing.tree.VariableHeightLayoutCache$TreeStateNode.expand(VariableHeightLayoutCache.java:1469) at javax.swing.tree.VariableHeightLayoutCache$TreeStateNode.expand(VariableHeightLayoutCache.java:1270) at javax.swing.tree.VariableHeightLayoutCache.rebuild(VariableHeightLayoutCache.java:725) at javax.swing.tree.VariableHeightLayoutCache.treeStructureChanged(VariableHeightLayoutCache.java:626) at javax.swing.plaf.basic.BasicTreeUI$Handler.treeStructureChanged(BasicTreeUI.java:3824) at org.pentaho.reporting.designer.core.editor.parameters.DataFactoryTreeModel.fireTreeDataChanged(DataFactoryTreeModel.java:221) at org.pentaho.reporting.designer.core.editor.parameters.DataFactoryTreeModel.fireTreeDataChanged(DataFactoryTreeModel.java:211) at org.pentaho.reporting.designer.core.editor.parameters.DataFactoryTreeModel.remove(DataFactoryTreeModel.java:269) at org.pentaho.reporting.designer.core.editor.parameters.ParameterDialog$RemoveDataSourceAction.actionPerformed(ParameterDialog.java:480) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272) at java.awt.Component.processMouseEvent(Component.java:6263) at javax.swing.JComponent.processMouseEvent(JComponent.java:3267) at java.awt.Component.processEvent(Component.java:6028) at java.awt.Container.processEvent(Container.java:2041) at java.awt.Component.dispatchEventImpl(Component.java:4630) at java.awt.Container.dispatchEventImpl(Container.java:2099) at java.awt.Component.dispatchEvent(Component.java:4460) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168) at java.awt.Container.dispatchEventImpl(Container.java:2085) at java.awt.Window.dispatchEventImpl(Window.java:2478) at java.awt.Component.dispatchEvent(Component.java:4460) at java.awt.EventQueue.dispatchEvent(EventQueue.java:599) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178) at java.awt.Dialog$1.run(Dialog.java:1046) at java.awt.Dialog$3.run(Dialog.java:1098) at java.security.AccessController.doPrivileged(Native Method) at java.awt.Dialog.show(Dialog.java:1096) at java.awt.Component.show(Component.java:1563) at java.awt.Component.setVisible(Component.java:1515) at java.awt.Window.setVisible(Window.java:842) at java.awt.Dialog.setVisible(Dialog.java:986) at org.pentaho.reporting.designer.core.editor.parameters.ParameterDialog.performEditParameter(ParameterDialog.java:2009) at org.pentaho.reporting.designer.core.actions.report.EditParametersAction.performEditMasterReportParameters(EditParametersAction.java:267) at org.pentaho.reporting.designer.core.editor.structuretree.StructureTreePanel$ReportTreeContextMenuHandler.mouseClicked(StructureTreePanel.java:130) at java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:253) at java.awt.Component.processMouseEvent(Component.java:6266) at javax.swing.JComponent.processMouseEvent(JComponent.java:3267) at java.awt.Component.processEvent(Component.java:6028) at java.awt.Container.processEvent(Container.java:2041) at java.awt.Component.dispatchEventImpl(Component.java:4630) at java.awt.Container.dispatchEventImpl(Container.java:2099) at java.awt.Component.dispatchEvent(Component.java:4460) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4247) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168) at java.awt.Container.dispatchEventImpl(Container.java:2085) at java.awt.Window.dispatchEventImpl(Window.java:2478) at java.awt.Component.dispatchEvent(Component.java:4460) at java.awt.EventQueue.dispatchEvent(EventQueue.java:599) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161) at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)

    Pentaho BI Platform Tracking | 7 years ago | Jem Matzan
    java.sql.SQLException: Statement does not generate a result set
  6. 0

    Encrypt/decrypt problem

    Oracle Community | 1 decade ago | 843811
    java.sql.SQLException: Error calling function: net.sourceforge.lightcrypto.Hsqldb.PBEDecrypt : java.lang.NullPointerException in statement [select distinct "net.sourceforge.lightcrypto.Hsqldb.PBEDecrypt"(company.name, 'password') companyName, count(distinct cat.ID) categoriesCount, count(distinct company.countryID) countriesCount, count(company.ID) allCount from CompaniesTable company inner join CountriesTable country on company.countryID=country.ID inner join CategoriesTable cat on company.categoryID=cat.ID where lower(companyName) like '%a%' and cat.parentID is null]

    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

      This function is not supported

      at org.hsqldb.jdbc.jdbcUtil.sqlException()
    2. HSQLDB
      jdbcPreparedStatement.executeQuery
      1. org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
      2. org.hsqldb.jdbc.jdbcUtil.<clinit>(Unknown Source)
      3. org.hsqldb.jdbc.jdbcPreparedStatement.executeQuery(Unknown Source)
      3 frames