OraFAQ Forum: JDeveloper, Java & XML » Oracle Driver Error???

Home » Developer & Programmer » JDeveloper, Java & XML » Oracle Driver Error???

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Driver Error??? [message #91685]

Thu, 09 January 2003 12:15

Vinay Sahitya
Messages: 11
Registered: October 1999

Junior Member

Hello:

We are using 9.2 to develop a Java application

We have tables with Timestamp column type.

We have a Java(jdk 1.3) application that uses Oracle Thin Driver(classes12.jar) to connect to the DB. We retrieve the time stamp column in two modes:

1. directly in a batch process in the OS: Windows 2K and unix.
All is fine

2. by running the same procedure from JSP using a Netscape Browser.

The application throws the following exception at:

aoResultSet = aoStatement.getResultSet();

Error Code: 3115 SQL State: 63000
java.sql.SQLException: ORA-03115: unsupported network datatype or
representation

It works fine, if we do not select the 'Timestamp' column.

Here the preceding code:

Statement aoStatement = aoConnection.createStatement();

aoStatement.execute("select * from SomeTable");

Does any one know what the issue could be?

Thanks!

Report message to a moderator

Re: Oracle Driver Error??? [message #91690 is a reply to message #91685]

Fri, 10 January 2003 06:55

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

if beleive, it is becuase,
timestamp is different datatype.
you cannot treat it like date datatype.
this issue is reported many times before from Java users.
i have no idea about java and i dont do any a java but if u want i can send some examples related to this
also visit http://java.sun.com/products/jdk/1.2/docs/api/java/sql/Timestamp.html

Report message to a moderator

Re: Oracle Driver Error??? [message #91727 is a reply to message #91690]

Tue, 21 January 2003 14:26

Vinay Sahitya
Messages: 11
Registered: October 1999

Junior Member

Thanks! We browsed that site and it was certainly very informative.

Also, we were able to also find another solution to this situation. If you include the jar file first in the path, then it works.

Thanks!
Vinay

Report message to a moderator