PK84628: Error while using the Import/Load data wizard with HSQLDB and th e generic JDBC driver

Rational Application Developer for WebSphere Software, Version 7.0.0.9

APAR status

• Closed as program error.

Error description

• Using Rational Software Architect V7.0.0.7
  The import/load data function/wizard with HSQLDB and the generic
   JDBC driver fails with error output confirming the data loading
   is unsuccessful.
  This error is specific to the HSQLDB database only.
  Steps to reproduce:
  1 - Create a generic connection JDBC pointing to a HSQLDB databa
  se.
  2 - Create a simple table within DB.
  3 - Implement load data wizard from the applicable table via -?
  data -? load and point at data file.
  This will fails with an error ie:
  Loading ' PUBLIC'. ' TEST' .......
  java.sql.SQLException: Unexpected token: `in statement [insert i
  nto `PUBLIC `. `TEST `VALUEs ()]
  data loading failed'
  The exception will also be reflected in the .log file of the wor
  kspace ie;
  !MESSAGE Unexpected token: ` in statement [insert into `PUBLIC`.
  `TEST` values(?)]
  !STACK 0
  java.sql.SQLException: Unexpected token: ` in statement [insert
  into `PUBLIC`.`TEST` values(?)]
   at org.hsqldb.jdbc.Util.throwError(Unknown Source)
   at org.hsqldb.jdbc.jdbcPreparedStatement.?init?(Unknown Source)
   at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Sour
  ce)
   at org.eclipse.wst.rdb.internal.core.connection.ConnectionAdapt
  er.prepareStatement(Unknown Source)
   at org.eclipse.wst.rdb.data.internal.core.load.TableLoader.open
  (Unknown Source)
   at org.eclipse.wst.rdb.data.internal.core.load.LoadData.doLoad1
  (Unknown Source)
   at org.eclipse.wst.rdb.data.internal.core.load.LoadData.doLoad(
  Unknown Source)
   at org.eclipse.wst.rdb.data.internal.ui.load.LoadDataWizard$1.r
  un(Unknown Source)
   at org.eclipse.core.internal.jobs.Worker.run(Unknown Source)
  

Local fix

Problem summary

• There was an error while Loading data for a table in HSQLDB
  database from DataSourceExplorer. The database connection
  was created using Generic JDBC category in connection
  wizard.
  
  The insert query formed was like insert into
  'schema'.'table' values ();
  This failed as single quotes were encountered at wrong
  place.
  

Problem conclusion

• The code is fixed by using double quotes instead of single
  quotes for forming the SQL Query.
  Fix delivered in V7.0.0.9
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  RATL APP DEV WI

• Fixed component ID

  5724J1901

Applicable component levels

• R700 PSN

     UP