Hi,
We have upgrading to oracle 10g from oracle 8i.
I seems that Oracle 10g doesn't support the date/time format in 8i.
I searched in the internet and found that, I need to use oracle11g's
jdbc drivers(ojdbc5.jar) and set the
Doracle.jdbc.mapDateToTimestamp as false.
And also most of the other sites suggest to set the
Doracle.jdbc.V8Compatible as true.
Now the question is, how do I set these values and where do I set these values. As I am connecting with DB from JNDI, using the class
DataSourceUtils 's static method -(getDataSourceFromJndi(
String)), I think I need not have to include anything in
java code. Because,
XXX-ds.xml will pass the values to the class at the runtime and hence I tried using the tag
connection-property tag in the XXX-ds.xml, but this is not working.
I have also tried adding below lines in
run.sh, which is also not working.
JAVA_OPTS="$JAVA_OPTS -Doracle.jdbc.V8Compatible=true"
JAVA_OPTS="$JAVA_OPTS -Doracle.jdbc.mapDateToTimeStamp=false" PleaseSuggest me about how to set, V8Compatible=true/mapDateToTimeStamp=false. Our application is not standalone application, so I dont think, we can implement this from the java prompt.
I appreciate your help in advance.
Cheers