|
From: <am...@ya...> - 2004-08-11 14:52:07
|
Setup is:
SQuirreL SQL 1.2beta6
Oracle Plugin 0.13
Oracle JDBC thin driver 9.2.0.3.0
Oracle Database 9.2.0.4.0 (HP-UX)
J2SE 1.4.2_04
The first time a run Squirrel and connect to this database, click on a schema
(CRMCC, not the same as the username I log in with), open the list of tables, select
a table (AGENT), click on the Contents tab, I get the following errors:
java.sql.SQLException: Protocol violation
java.sql.SQLException: Bigger type length than Maximum
If I click on the top-level database connection and then back on the table name I
get:
java.sql.SQLException: Refcursor value is invalid
Close database connection, reconnect, go to the first table again, click Contents
tab:
java.sql.SQLException: Io exception: invalid arguments in call
java.sql.SQLException: Io exception: invalid arguments in call
If I then open up a connection to a database that has a similar schema but runs on a
Windows server (Oracle Database 9.2.0.1.0), close this connection, then reopen the
connection to the database on HP-UX I get no errors.
A trace leading up to the first exception is given at the end of this message. The
trace was generated using OracleLog (ojdbc14_g.jar with oracle.jdbc.Trace and
oracle.jdbc.LogFile Java system properties set). The full trace is available if
anyone is interested (2.2 MB uncompressed).
Any ideas?
-- Andrew
DRVR OPER BaseResultSet.clearWarnings()
DRVR OPER OracleConnection.getMetaData()
DRVR OPER OracleConnection.getIncludeSynonyms() returned false
DRVR OPER OracleConnection.getRemarksReporting()
DRVR OPER OracleConnection.getRemarksReporting()
DRVR OPER OracleConnection.getIncludeSynonyms() returned false
DRVR OPER OracleConnection.getIncludeSynonyms() returned false
DRVR OPER OracleConnection.getRemarksReporting()
DRVR OPER OracleConnection.getIncludeSynonyms() returned false
DRVR SQLS SQL: "SELECT NULL AS table_cat,
t.owner AS table_schem,
t.table_name AS table_name,
t.column_name AS column_name,
DECODE (t.data_type, 'CHAR', 1, 'VARCHAR2', 12, 'NUMBER', 3,
'LONG', -1, 'DATE', 93, 'RAW', -3, 'LONG RAW', -4, 1111)
AS data_type,
t.data_type AS type_name,
DECODE (t.data_precision, null, t.data_length, t.data_precision)
AS column_size,
0 AS buffer_length,
t.data_scale AS decimal_digits,
10 AS num_prec_radix,
DECODE (t.nullable, 'N', 0, 1) AS nullable,
NULL AS remarks,
t.data_default AS column_def,
0 AS sql_data_type,
0 AS sql_datetime_sub,
t.data_length AS char_octet_length,
t.column_id AS ordinal_position,
DECODE (t.nullable, 'N', 'NO', 'YES') AS is_nullable
FROM all_tab_columns t
WHERE t.owner LIKE ? ESCAPE '/'
AND t.table_name LIKE ? ESCAPE '/'
AND t.column_name LIKE ? ESCAPE '/'
ORDER BY table_schem, table_name, ordinal_position
"
DRVR OPER OracleConnection.getDefaultFixedString() returning false
DRVR OPER ResultSetUtil.needIdentifier(typeCode=1): return: false
DRVR SQLS Input SQL: "SELECT NULL AS table_cat,
t.owner AS table_schem,
t.table_name AS table_name,
t.column_name AS column_name,
DECODE (t.data_type, 'CHAR', 1, 'VARCHAR2', 12, 'NUMBER', 3,
'LONG', -1, 'DATE', 93, 'RAW', -3, 'LONG RAW', -4, 1111)
AS data_type,
t.data_type AS type_name,
DECODE (t.data_precision, null, t.data_length, t.data_precision)
AS column_size,
0 AS buffer_length,
t.data_scale AS decimal_digits,
10 AS num_prec_radix,
DECODE (t.nullable, 'N', 0, 1) AS nullable,
NULL AS remarks,
t.data_default AS column_def,
0 AS sql_data_type,
0 AS sql_datetime_sub,
t.data_length AS char_octet_length,
t.column_id AS ordinal_position,
DECODE (t.nullable, 'N', 'NO', 'YES') AS is_nullable
FROM all_tab_columns t
WHERE t.owner LIKE ? ESCAPE '/'
AND t.table_name LIKE ? ESCAPE '/'
AND t.column_name LIKE ? ESCAPE '/'
ORDER BY table_schem, table_name, ordinal_position
"
DRVR OPER OracleConnection.getIncludeSynonyms() returned false
DRVR OPER OraclePreparedStatement.setString(paramIndex=1, x=CRMCC)
DRVR OPER OraclePreparedStatement.setString(paramIndex=2, x=AGENT)
DRVR OPER OraclePreparedStatement.setString(paramIndex=3, x=%)
DRVR OPER OraclePreparedStatement.executeQuery()
DRVR OPER OraclePreparedStatement.executeUpdate()
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_NAME)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_TYPE)
DRVR OPER OracleResultSetImpl.getString(columnIndex=4)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_NAME)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_TYPE)
DRVR OPER OracleResultSetImpl.getString(columnIndex=4)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_NAME)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_TYPE)
DRVR OPER OracleResultSetImpl.getString(columnIndex=4)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_NAME)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_TYPE)
DRVR OPER OracleResultSetImpl.getString(columnIndex=4)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_NAME)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_TYPE)
DRVR OPER OracleResultSetImpl.getString(columnIndex=4)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_NAME)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_TYPE)
DRVR OPER OracleResultSetImpl.getString(columnIndex=4)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_NAME)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_TYPE)
DRVR OPER OracleResultSetImpl.getString(columnIndex=4)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_NAME)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_TYPE)
DRVR OPER OracleResultSetImpl.getString(columnIndex=4)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_NAME)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_TYPE)
DRVR OPER OracleResultSetImpl.getString(columnIndex=4)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_NAME)
DRVR OPER OracleResultSetImpl.getString(columnIndex=3)
DRVR OPER OracleResultSetImpl.findColumn(columnName=TABLE_TYPE)
DRVR OPER OracleResultSetImpl.getString(columnIndex=4)
DRVR OPER BaseResultSet.clearWarnings()
DRVR OPER OracleConnection.getAutoCommit() returned true
DRVR OPER OracleResultSetImpl.getInt(columnIndex=11)
DRVR WARN DBError.findMessage(errNum, obj): returned Bigger type length than Maximum
DRVR WARN DBError.throwSqlException(e): Unable to find ORA number from exception
DRVR WARN DBError.findMessage(errNum, obj): returned Io exception: Bigger type
length than Maximum
DRVR OPER BaseResultSet.clearWarnings()
DRVR WARN DBError.findMessage(errNum, obj): returned Protocol violation
DRVR OPER OracleResultSetImpl.close()
DRVR WARN DBError.findMessage(errNum, obj): returned Protocol violation
DRVR OPER OraclePreparedStatement.sendBatch()
DRVR WARN DBError.findMessage(errNum, obj): returned Protocol violation
DRVR WARN DBError.findMessage(errNum, obj): returned Protocol violation
___________________________________________________________ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com
|
