Using Solaris OS, with Oracle {7.3.4} Database.

JDBC-TEST fails testcase for jdbcTest.resultSet.GetCursor: Starting Module resultSet.GetCursor -

jdbcTest.resultSet.GetCursor: No resource file found for jdbcTest.resultSet.GetCursor

DriverManager.getConnection("jdbc:odbc:oracle")
    trying driver[className=sun.jdbc.odbc.JdbcOdbcDriver,sun.jdbc.odbc.JdbcOdbcDriver@389dd20c]
*Driver.connect (jdbc:odbc:oracle)
JDBC to ODBC Bridge: Checking security
No SecurityManager present, assuming trusted application/applet
Allocating Connection handle (SQLAllocConnect)
hDbc=4654400
Connecting (SQLDriverConnect), hDbc=4654400, szConnStrIn=DSN=oracle;UID=jdbctest;PWD=jdbctest
*Connection.getMetaData
*DatabaseMetaData.getDriverName
Get connection info string (SQLGetInfo), hDbc=4654400, fInfoType=6, len=300
qeor708.so
Driver name: JDBC-ODBC Bridge (qeor708.so)
*DatabaseMetaData.getDriverVersion
Get connection info string (SQLGetInfo), hDbc=4654400, fInfoType=7, len=300
02.11.0000
Driver version: 1.2001 (02.11.0000)
Caching SQL type information
*Connection.getMetaData
*DatabaseMetaData.getTypeInfo
Allocating Statement Handle (SQLAllocStmt), hDbc=4654400
hStmt=4664400
Get type info (SQLGetTypeInfo), hStmt=4664400, fSqlType=0
Number of result columns (SQLNumResultCols), hStmt=4664400
value=15
Get connection info string (SQLGetInfo), hDbc=4654400, fInfoType=10, len=300
02.10.0000
Setting pseudo columns, first=16, last=18
Fetching (SQLFetch), hStmt=4664400
Column attributes (SQLColAttributes), hStmt=4664400, icol=1, type=2
value (int)=12
Column attributes (SQLColAttributes), hStmt=4664400, icol=1, type=3
value (int)=128
Get string data (SQLGetData), hStmt=4664400, column=1, maxLen=129
LONG RAW
Get integer data (SQLGetData), hStmt=4664400, column=2
value=-4
Get integer data (SQLGetData), hStmt=4664400, column=3
value=2147483647
Fetching (SQLFetch), hStmt=4664400
Get string data (SQLGetData), hStmt=4664400, column=1, maxLen=129
RAW
Get integer data (SQLGetData), hStmt=4664400, column=2
value=-3
Get integer data (SQLGetData), hStmt=4664400, column=3
value=255
Fetching (SQLFetch), hStmt=4664400
Get string data (SQLGetData), hStmt=4664400, column=1, maxLen=129
LONG
Get integer data (SQLGetData), hStmt=4664400, column=2
value=-1
Get integer data (SQLGetData), hStmt=4664400, column=3
value=2147483647
Fetching (SQLFetch), hStmt=4664400
Get string data (SQLGetData), hStmt=4664400, column=1, maxLen=129
CHAR
Get integer data (SQLGetData), hStmt=4664400, column=2
value=1
Get integer data (SQLGetData), hStmt=4664400, column=3
value=255
Fetching (SQLFetch), hStmt=4664400
Get string data (SQLGetData), hStmt=4664400, column=1, maxLen=129
NUMBER
Get integer data (SQLGetData), hStmt=4664400, column=2
value=3
Get integer data (SQLGetData), hStmt=4664400, column=3
value=38
Fetching (SQLFetch), hStmt=4664400
Get string data (SQLGetData), hStmt=4664400, column=1, maxLen=129
NUMBER
Get integer data (SQLGetData), hStmt=4664400, column=2
value=8
Get integer data (SQLGetData), hStmt=4664400, column=3
value=15
Fetching (SQLFetch), hStmt=4664400
Get string data (SQLGetData), hStmt=4664400, column=1, maxLen=129
DATE
Get integer data (SQLGetData), hStmt=4664400, column=2
value=11
Get integer data (SQLGetData), hStmt=4664400, column=3
value=19
Fetching (SQLFetch), hStmt=4664400
Get string data (SQLGetData), hStmt=4664400, column=1, maxLen=129
VARCHAR2
Get integer data (SQLGetData), hStmt=4664400, column=2
value=2000
Fetching (SQLFetch), hStmt=4664400
End of result set (SQL_NO_DATA)
Free statement (SQLFreeStmt), hStmt=4664400, fOption=1
getConnection returning driver[className=sun.jdbc.odbc.JdbcOdbcDriver,sun.jdbc.odbc.JdbcOdbcDriver@389dd20c]
*Connection.getMetaData
*DatabaseMetaData.supportsSelectForUpdate
Get connection info (SQLGetInfo), hDbc=4654400, fInfoType=80
 int value=7
*Connection.createStatement
Allocating Statement Handle (SQLAllocStmt), hDbc=4654400
hStmt=4664400
Registering Statement sun.jdbc.odbc.JdbcOdbcStatement@f9edd20f
jdbcTest.resultSet.GetCursor: Executing Sql:drop table ResultSetCursor

ResultSet.finalize sun.jdbc.odbc.JdbcOdbcResultSet@e57dd20f
*Connection.createStatement
Allocating Statement Handle (SQLAllocStmt), hDbc=4654400
hStmt=4695712
Registering Statement sun.jdbc.odbc.JdbcOdbcStatement@8a59d20f
*Statement.executeUpdate (drop table ResultSetCursor)
*Statement.execute (drop table ResultSetCursor)
Free statement (SQLFreeStmt), hStmt=4695712, fOption=0
Executing (SQLExecDirect), hStmt=4695712, szSqlStr=drop table ResultSetCursor
RETCODE = -1
ERROR - Generating SQLException...
SQLException: SQLState(S0002) vendor code(942)
java.sql.SQLException: [INTERSOLV][ODBC Oracle driver][Oracle]ORA-00942: table or view does not exist
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java, Compiled Code)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java, Compiled Code)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java, Compiled Code)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java, Compiled Code)
at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(JdbcOdbcStatement.java, Compiled Code)
at jdbcTest.harness.TestModule.trySQL(TestModule.java, Compiled Code)
at jdbcTest.resultSet.GetCursor.run(GetCursor.java, Compiled Code)
at java.lang.Thread.run(Thread.java, Compiled Code)
*Statement.executeUpdate (create table ResultSetCursor(val char(30)))
*Statement.execute (create table ResultSetCursor(val char(30)))
Free statement (SQLFreeStmt), hStmt=4664400, fOption=0
Executing (SQLExecDirect), hStmt=4664400, szSqlStr=create table ResultSetCursor(val char(30))
Number of result columns (SQLNumResultCols), hStmt=4664400
value=0
*Statement.getUpdateCount
Number of result columns (SQLNumResultCols), hStmt=4664400
value=0
Number of affected rows (SQLRowCount), hStmt=4664400
value=0
*Connection.setAutoCommit (false)
Setting connection option (SQLSetConnectOption), hDbc=4654400, fOption=102, vParam=0
*Statement.executeUpdate (insert into ResultSetCursor(val) values('aaa'))
*Statement.execute (insert into ResultSetCursor(val) values('aaa'))
Free statement (SQLFreeStmt), hStmt=4664400, fOption=0
Executing (SQLExecDirect), hStmt=4664400, szSqlStr=insert into ResultSetCursor(val) values('aaa')
Number of result columns (SQLNumResultCols), hStmt=4664400
value=0
*Statement.getUpdateCount
Number of result columns (SQLNumResultCols), hStmt=4664400
value=0
Number of affected rows (SQLRowCount), hStmt=4664400
value=1
*Statement.executeUpdate (insert into ResultSetCursor(val) values('bbb'))
*Statement.execute (insert into ResultSetCursor(val) values('bbb'))
Free statement (SQLFreeStmt), hStmt=4664400, fOption=0
Executing (SQLExecDirect), hStmt=4664400, szSqlStr=insert into ResultSetCursor(val) values('bbb')
Number of result columns (SQLNumResultCols), hStmt=4664400
value=0
*Statement.getUpdateCount
Number of result columns (SQLNumResultCols), hStmt=4664400
value=0
Number of affected rows (SQLRowCount), hStmt=4664400
value=1
*Statement.executeUpdate (insert into ResultSetCursor(val) values('ccc'))
*Statement.execute (insert into ResultSetCursor(val) values('ccc'))
Free statement (SQLFreeStmt), hStmt=4664400, fOption=0
Executing (SQLExecDirect), hStmt=4664400, szSqlStr=insert into ResultSetCursor(val) values('ccc')
Number of result columns (SQLNumResultCols), hStmt=4664400
value=0
*Statement.getUpdateCount
Number of result columns (SQLNumResultCols), hStmt=4664400
value=0
Number of affected rows (SQLRowCount), hStmt=4664400
value=1
*Statement.executeQuery (select * from ResultSetCursor for update of val)
*Statement.execute (select * from ResultSetCursor for update of val)
Free statement (SQLFreeStmt), hStmt=4664400, fOption=0
Setting concurrency for update
Setting statement option (SQLSetStmtOption), hStmt=4664400, fOption=7, vParam=2
RETCODE = 1
WARNING - Generating SQLWarning...
SQLWarning: reason([INTERSOLV][ODBC Oracle driver]Option value changed.) SQLstate(01S02) vendor code(0)
Executing (SQLExecDirect), hStmt=4664400, szSqlStr=select * from ResultSetCursor for update of val
Number of result columns (SQLNumResultCols), hStmt=4664400
value=1
Number of result columns (SQLNumResultCols), hStmt=4664400
value=1
jdbcTest.resultSet.GetCursor: Executing Object: sun.jdbc.odbc.JdbcOdbcResultSet Function: getCursor()

Cursor name (SQLGetCursorName), hStmt=4664400
value=SQL_CUR00472CA0
jdbcTest.resultSet.GetCursor: Returned value = 'SQL_CUR00472CA0'

*Connection.createStatement
Allocating Statement Handle (SQLAllocStmt), hDbc=4654400
hStmt=4700256
Registering Statement sun.jdbc.odbc.JdbcOdbcStatement@f0f5d20f
Fetching (SQLFetch), hStmt=4664400
Column attributes (SQLColAttributes), hStmt=4664400, icol=1, type=2
value (int)=1
Column attributes (SQLColAttributes), hStmt=4664400, icol=1, type=3
value (int)=30
Get string data (SQLGetData), hStmt=4664400, column=1, maxLen=31
aaa
Fetching (SQLFetch), hStmt=4664400
Get string data (SQLGetData), hStmt=4664400, column=1, maxLen=31
bbb
*Statement.executeUpdate (update ResultSetCursor set val='ddd' where current of SQL_CUR00472CA0)
*Statement.execute (update ResultSetCursor set val='ddd' where current of SQL_CUR00472CA0)
Free statement (SQLFreeStmt), hStmt=4700256, fOption=0
Executing (SQLExecDirect), hStmt=4700256, szSqlStr=update ResultSetCursor set val='ddd' where current of SQL_CUR00472CA0
Number of result columns (SQLNumResultCols), hStmt=4700256
value=0
*Statement.getUpdateCount
Number of result columns (SQLNumResultCols), hStmt=4700256
value=0
Number of affected rows (SQLRowCount), hStmt=4700256
value=1
Fetching (SQLFetch), hStmt=4664400
Get string data (SQLGetData), hStmt=4664400, column=1, maxLen=31
ccc
Fetching (SQLFetch), hStmt=4664400
End of result set (SQL_NO_DATA)
*Connection.commit
Transaction (SQLTransact), hEnv=4641752, hDbc=4654400, fType=0
*Statement.executeQuery (select * from ResultSetCursor order by val)
*Statement.execute (select * from ResultSetCursor order by val)
Free statement (SQLFreeStmt), hStmt=4664400, fOption=0
Executing (SQLExecDirect), hStmt=4664400, szSqlStr=select * from ResultSetCursor order by val
Number of result columns (SQLNumResultCols), hStmt=4664400
value=1
Number of result columns (SQLNumResultCols), hStmt=4664400
value=1
Fetching (SQLFetch), hStmt=4664400
Column attributes (SQLColAttributes), hStmt=4664400, icol=1, type=2
value (int)=1
Column attributes (SQLColAttributes), hStmt=4664400, icol=1, type=3
value (int)=30
Get string data (SQLGetData), hStmt=4664400, column=1, maxLen=31
aaajdbcTest.resultSet.GetCursor: Assertion: PASSED Text:This must be the 'aaa' row
Fetching (SQLFetch), hStmt=4664400
Get string data (SQLGetData), hStmt=4664400, column=1, maxLen=31
ccc
jdbcTest.resultSet.GetCursor: Assertion: PASSED Text:This must be the 'ccc' row
ResultSet.finalize sun.jdbc.odbc.JdbcOdbcResultSet@ec79d20f
Free statement (SQLFreeStmt), hStmt=4664400, fOption=0
Fetching (SQLFetch), hStmt=4664400
RETCODE = -1
ERROR - Generating SQLException...
SQLException: SQLState(S1010) vendor code(0)
java.sql.SQLException: [INTERSOLV][ODBC Oracle driver]Function sequence error.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java, Compiled Code)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java, Compiled Code)
at sun.jdbc.odbc.JdbcOdbc.SQLFetch(JdbcOdbc.java, Compiled Code)
at sun.jdbc.odbc.JdbcOdbcResultSet.next(JdbcOdbcResultSet.java, Compiled Code)
at jdbcTest.resultSet.GetCursor.run(GetCursor.java, Compiled Code)
at java.lang.Thread.run(Thread.java, Compiled Code)

jdbcTest.resultSet.GetCursor: *** SQLException caught ***


jdbcTest.resultSet.GetCursor: Object: sun.jdbc.odbc.JdbcOdbcResultSet
jdbcTest.resultSet.GetCursor: SQLState: S1010

jdbcTest.resultSet.GetCursor: Message: [INTERSOLV][ODBC Oracle driver]Function sequence error.

jdbcTest.resultSet.GetCursor: Vendor: 0

java.sql.SQLException: [INTERSOLV][ODBC Oracle driver]Function sequence error.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java, Compiled Code)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java, Compiled Code)
at sun.jdbc.odbc.JdbcOdbc.SQLFetch(JdbcOdbc.java, Compiled Code)
at sun.jdbc.odbc.JdbcOdbcResultSet.next(JdbcOdbcResultSet.java, Compiled Code)
at jdbcTest.resultSet.GetCursor.run(GetCursor.java, Compiled Code)
at java.lang.Thread.run(Thread.java, Compiled Code)
jdbcTest.resultSet.GetCursor: TestCase: **** FAILED ****


No reproduciable on 1.2.2U. see comments.