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.

  • Cannot open database '|'
    via Stack Overflow by Lucia Belardinelli
    ,
  • Syntax Error Insert Into statement java
    via Stack Overflow by JUNGE
    ,
  • regarding jdbc updation
    via Stack Overflow by sai sagar
    ,
  • Java-Error when writing to Access DB
    via Stack Overflow by Shaw
    ,
  • Hi there, I am new to pentaho and is thinking of using pentaho as an ETL tool. I like this tool in many ways but I am stuck while performing a test. I have defined two data base connections in ODBC with SQL server 2008 in pentaho 5.0.1 stable. The first connection is for taking an input of data from a local sql server express instance using sql authentication(Feeding to the table input) and the Second connection is for taking an out after the transformation in a different instance of microsoft sql server installation in the same computer(feeding to table out). Both the connections are tested ok. But It fails while inserting rows into the output table. here is the error code in the log: 2014/02/21 13:55:43 - Spoon - Transformation opened. 2014/02/21 13:55:43 - Spoon - Launching transformation [t2]... 2014/02/21 13:55:43 - Spoon - Started the transformation execution. 2014/02/21 13:55:43 - t2 - Dispatching started for transformation [t2] 2014/02/21 13:55:43 - Table output.0 - Connected to database [output] (commit=3) 2014/02/21 13:55:43 - Table input.0 - Finished reading query, closing connection. 2014/02/21 13:55:43 - Table input.0 - Finished processing (I=6, O=0, R=0, W=6, U=0, E=0) 2014/02/21 13:55:43 - Table output.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Because of an error, this step can't continue: 2014/02/21 13:55:43 - Table output.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : org.pentaho.di.core.exception.KettleException: 2014/02/21 13:55:43 - Table output.0 - Error inserting row into table [output1] with values: [id1], [test1] 2014/02/21 13:55:43 - Table output.0 - 2014/02/21 13:55:43 - Table output.0 - Error inserting/updating row 2014/02/21 13:55:43 - Table output.0 - [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. 2014/02/21 13:55:43 - Table output.0 - 2014/02/21 13:55:43 - Table output.0 - 2014/02/21 13:55:43 - Table output.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:445) 2014/02/21 13:55:43 - Table output.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:128) 2014/02/21 13:55:43 - Table output.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60) 2014/02/21 13:55:43 - Table output.0 - at java.lang.Thread.run(Unknown Source) 2014/02/21 13:55:43 - Table output.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 2014/02/21 13:55:43 - Table output.0 - Error inserting/updating row 2014/02/21 13:55:43 - Table output.0 - [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. 2014/02/21 13:55:43 - Table output.0 - 2014/02/21 13:55:43 - Table output.0 - at org.pentaho.di.core.database.Database.insertRow(Database.java:1193) 2014/02/21 13:55:43 - Table output.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:284) 2014/02/21 13:55:43 - Table output.0 - ... 3 more 2014/02/21 13:55:43 - Table output.0 - Caused by: java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. 2014/02/21 13:55:43 - Table output.0 - at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) 2014/02/21 13:55:43 - Table output.0 - at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) 2014/02/21 13:55:43 - Table output.0 - at sun.jdbc.odbc.JdbcOdbc.SQLExecute(Unknown Source) 2014/02/21 13:55:43 - Table output.0 - at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(Unknown Source) 2014/02/21 13:55:43 - Table output.0 - at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeUpdate(Unknown Source) 2014/02/21 13:55:43 - Table output.0 - at org.pentaho.di.core.database.Database.insertRow(Database.java:1153) 2014/02/21 13:55:43 - Table output.0 - ... 4 more 2014/02/21 13:55:43 - Table output.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1) 2014/02/21 13:55:43 - t2 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Errors detected! 2014/02/21 13:55:43 - Spoon - The transformation has finished!! 2014/02/21 13:55:43 - t2 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Errors detected! 2014/02/21 13:55:43 - t2 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Errors detected! 2014/02/21 13:55:43 - t2 - t2 2014/02/21 13:55:43 - t2 - t2 Please help here and pls any one tell what I am doing wrong here? Thanks in advance.
    via by shams Islam,
    • java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.SQLExecute(Unknown Source) at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(Unknown Source) at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeUpdate(Unknown Source) at InputData.actionPerformed(InputData.java:159) 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.plaf.basic.BasicButtonListener.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.dispatchEventImpl(Unknown Source) at java.awt.EventQueue.access$200(Unknown Source) at java.awt.EventQueue$3.run(Unknown Source) at java.awt.EventQueue$3.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source) at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source) at java.awt.EventQueue$4.run(Unknown Source) at java.awt.EventQueue$4.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$1.doIntersectionPrivilege(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)

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor2 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    12 more bugmates