CODEWITHSUNDEEP
oracle-databasejdbc
Adeniran Opeyemi
Adeniran Opeyemi

Reputation: 261

java.lang.ClassCastException: oracle.sql.TIMESTAMP cannot be cast to java.sql.Timestamp

I am working on an application that streams ResultSet over a network. I ended up using a CachedRowSetImpl class. But when I connect to an Oracle DB, I get an error like this

java.lang.ClassCastException: oracle.sql.TIMESTAMP cannot be cast to java.sql.Timestamp

Please help.

The source code is as follows:

ResultSet res = response.getResultSet(); //resultset from the server
while (res.next()) {
    Agent agent = new Agent();
    agent.setName(res.getString(2));
    agent.setMobile(res.getString(1));
    agent.setBalance(res.getLong(4));
    agent.setLastUpdate(res.getDate(3)); //date from the result set
    agent.setAccountNumber(res.getString(5));
}

The error ...

java.lang.ClassCastException: oracle.sql.TIMESTAMP cannot be cast to java.sql.Timestamp java.lang.ClassCastException: oracle.sql.TIMESTAMP cannot be cast to java.sql.Timestamp at com.sun.rowset.CachedRowSetImpl.getDate(CachedRowSetImpl.java:2139)

Upvotes: 26

Views: 51230

Answers (7)

Amir Amiri
Amir Amiri

Reputation: 437

Add this this line to the JVM setting. It will work.

-Doracle.jdbc.J2EE13Compliant=true

Upvotes: 5

Vincent Malgrat
Vincent Malgrat

Reputation: 67722

This is because oracle.sql.TIMESTAMP is not derived from java.sql.TIMESTAMP:

java.lang.Object
  -> oracle.sql.Datum
     -> oracle.sql.TIMESTAMP

You can't cast the former into the later.

Instead use oracle.sql.TIMESTAMP.timestampValue():

public Timestamp timestampValue(Calendar cal) throws SQLException

Calls toTimestamp to convert internal Oracle Date and Calendar to a Java Timestamp.

Upvotes: 4

Sam ツ
Sam ツ

Reputation: 611

This can be solved by using the timestampValue() function present in the oracle.sql.TIMESTAMP class. This method will convert oracle.sql.TIMESTAMP into java.sql.Timestamp.

oracle.sql.TIMESTAMP ts = (oracle.sql.TIMESTAMP) res.getObject("last_update"); agent.setLastUpdate(ts.timestampValue());

Upvotes: 1

Bogdan Calmac
Bogdan Calmac

Reputation: 8283

The javadoc for ResultSet.getObject() mandates that the JDBC type should be mapped to a Java type as prescribed by the JDBC spec (TIMESTAMP -> java.sqlTimestmp):

This method will return the value of the given column as a Java object. The type of the Java object will be the default Java object type corresponding to the column's SQL type, following the mapping for built-in types specified in the JDBC specification.

As you have noticed, the Oracle driver is by default not compliant with the standard and uses oracle.sql.TIMESTAMP instead (which does not extend java.sql.Timestamp). The good news is that you can force JDBC compliance by setting the oracle.jdbc.J2EE13Compliant system property to true during vm startup:

java -Doracle.jdbc.J2EE13Compliant=true YourApplication

or programmatically

System.getProperties().setProperty("oracle.jdbc.J2EE13Compliant", "true")

Once you do this, getResult() will return instances of java.sql.Timestamp, as expected.

For more details see the relevant section from the Oracle JDBC Driver Documentation, which describes several ways of setting oracle.jdbc.J2EE13Compliant.

Upvotes: 37

Mark Rotteveel
Mark Rotteveel

Reputation: 108938

Most likely you used getTIMESTAMP() instead of getTimestamp(). The methods getTIMESTAMP() (and getDATE() are extension in OracleResultSet which return Oracle specific types.

If not then you are not using a JDBC driver, because the returntype of getDate() is java.sql.Date and of getTimestamp() is java.sql.Timestamp, so it can't be a totally different type as in your question.

Upvotes: 0

Adeniran Opeyemi
Adeniran Opeyemi

Reputation: 261

I found a way out. 

 oracle.sql.TIMESTAMP ts = (oracle.sql.TIMESTAMP) res.getObject("last_update");
 agent.setLastUpdate(new Date(ts.dateValue().getTime()));

Upvotes: 6

Abubakkar
Abubakkar

Reputation: 15644

I think the problem is your setLastUpdate is expecting an object of java.sql.Date type.

Now when you use agent.setLastUpdate(res.getDate(3));

The res.getDate(3) must be returning an object that your method doesn't expect so your there may be ClassCastException for that.

Try this code and see whether it solves your problem or not:

agent.setLastUpdate(new java.util.Date(res.getDate(3).getTime()));

Upvotes: 0

Related Questions