IV25172: SQLEXCEPTION WHEN CONNECTING TO A DATABASE USING JDBC-ODBC API

APAR status

• Closed as program error.

Error description

• Error Message: N/A
  .
  Stack Trace: The following stack and message will be printed on
  a 64 bit JRE on Windows.
  java.sql.SQLException: <OSB>Microsoft<CSB><OSB>ODBC Driver
  Manager<CSB> Invalid string or buffer length
  at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6969)
  at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7126)
  at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3919)
  at
  sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.
  java:5710)
  at
  sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java
  :366)
  at
  sun.jdbc.odbc.JdbcOdbcConnection.buildTypeInfo(JdbcOdbcConnectio
  n.java:1515)
  at
  sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.j
  ava:393)
  at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:186)
  at java.sql.DriverManager.getConnection(DriverManager.java:322)
  at java.sql.DriverManager.getConnection(DriverManager.java:358)
  at TestConnection.main(TestConnection.java:13)
  .
  The problem does not arise on Windows 32 bit.
  

Local fix

Problem summary

• The problem arises due to incorrect function definition in the
  header file required for JDBC-ODBC code. The SQLGetData
  definition did not comply to the 64 bit architecture as
  specified at
  http://msdn.microsoft.com/en-us/library/windows/desktop/ms716287
  %28v=vs.85%29.aspx.
  

Problem conclusion

• This defect will be fixed in:
  6.0.0 SR12
  6.0.1 SR4
  .
  SQLGetData function definition is corrected with appropriate
  data types as per the MSDN specification. This APAR is not
  applicable to Java 7 as JDBC-ODBC bridge is not supported from
  Java 7.
  

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

  JAVA CLASS LIBS

• Fixed component ID

  620700130

Applicable component levels

• R600 PSY

     UP