Oracle 9 TIMESTAMP ORA-03115 on SELECT

Hi

I am struggling to access rows in a table which contains a TIMESTAMP
column. I get "ORA-03115: unsupported network datatype or
representation" when executing a select statement. I am trying to
isolate the problem by testing against a very simple table and with a
simple test application.

Here's the table:

Name Null? Type
----------------------------------------- --------
----------------------------
NOW TIMESTAMP(0)

Here's the test application:

import java.text.SimpleDateFormat;
import java.util.*;
import java.io.*;
import java.sql.*;
import oracle.sql.TIMESTAMP;

public class OracleDateTime {

public static void main(String args[]) throws Exception {
System.out.println("OracleDateTime V1.06");
Connection conn = null;
try {
String driverClassname = "oracle.jdbc.driver.OracleDriver";
String jdbcURL = "jdbc:oracle:thin:@localhost:1521:GANDALF";
String username = "seleniumsms";
String password = "password";
Class.forName(driverClassname);
conn = DriverManager.getConnection(jdbcURL, username, password);
System.out.println("Got connection....");
} catch (Exception e) {
System.out.println(e);
e.printStackTrace();
}
String insert = "insert into test values(?)";
String select = "select * from test";
PreparedStatement psinsert = conn.prepareStatement(insert);
System.out.println("About to set timestamp in prepared statement");
psinsert.setTimestamp(1, new Timestamp(System.currentTimeMillis()));
System.out.println("Done");
PreparedStatement psselect = conn.prepareStatement(select);
psinsert.executeUpdate();
conn.commit();
System.out.println("Inserted record");
SimpleDateFormat df = new SimpleDateFormat("dd.MM.yyyy HH:mm:ss");
System.out.println("About to execute SELECT");
ResultSet rs = psselect.executeQuery();
System.out.println("Done");
while (rs.next()) {
System.out.println("About to get date/time");
java.sql.Date d = rs.getDate(1);
System.out.println("Done");
System.out.println("Timestamp is : "+df.format(d));
}
}

}

And here's the output:

OracleDateTime V1.06
Got connection....
About to set timestamp in prepared statement
Done
Inserted record
About to execute SELECT
Exception in thread "main" java.sql.SQLException: ORA-03115:
unsupported network datatype or represe
ntation

at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.v8Odscrarr.receive(v8Odscrarr.java:191)
at
oracle.jdbc.ttc7.TTC7Protocol.describe(TTC7Protocol.java:586)
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:647)
at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1674)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1870)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363
)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:314)

at OracleDateTime.main(OracleDateTime.java:38)


And running the same SELECT from SQL*PLUS yields:

NOW
---------------------------------------------------------------------------
29-DEC-05 09.27.00

So in summary:

I can insert a record containing a valid TIMESTAMP, complete with
hours, minutes and seconds. But as soon as I try to retrieve the record
I get the ORA-03115.

I'm using the thin JDBC driver.

Hope someone can help

Thanks

.

Relevant Pages

  • Re: ctime double double check
    ... Timestamp= 1144412677847; ... printf ("The Time is %s ", CTime); ... It might fit in to an unsigned long. ... There happens to be a very common system-specific representation, ...
    (comp.lang.c)
  • Re: ctime double double check
    ... Timestamp= 1144412677847; ... printf ("The Time is %s ", CTime); ... It might fit in to an unsigned long. ... There happens to be a very common system-specific representation, ...
    (comp.lang.c)
  • Re: user logging strategies
    ... but no timestamp or order they were executed in. ... so currently executing processes aren't ... unfortunately there is no way to fully protect unix other than stripping a system so that tools that can be used to circumvent controls do not exist, however this will not stop a determined user installing his own statically linked xterm to get around it. ...
    (comp.sys.sun.admin)
  • Re: user logging strategies
    ... and yes the entries are time stamped: ... but no timestamp or order they were executed in. ... Also, IIRC, accounting records are only ... so currently executing processes aren't ...
    (comp.sys.sun.admin)