We are using the ojdbc14.jar driver to talk to a 10.1.0.4 version database. when calling GetObject () on a rowset, asking for a column that has database type Timestamp (9), I need CT to get a java. SQL. timestamp. instead, I get an oracle. SQL. timestamp, which cannot be casted to Java. SQL. timestamp.
Reading the Oracle forums and manuals, I get the impression that the default mapping shoshould be to the java. SQL. * types-if possible-and that mapping to Oracle. SQL. * types is optional.
Can anyone shed some light on this? What is the default mapping and how can it be influenced? Any help wowould be greatly appreciated.
Ava. util. properties prop = new java. util. properties ();
Prop. Put ("oracle. JDBC. v8compatible", "true"); // so GetObject returns timestamp!
Prop. Put ("user", "Scott ");
Prop. Put ("password", "Tiger ");
String url = "JDBC: oracle: thin: @ host: Port: Sid ";
Connection conn = drivermanager. getconnection (URL, Prop );