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.
What's your application on JBoss? I mean, is a WAR file? Just to make sure that these JVM parameters are being passed properly and being picked up, i would write a simple jsp (or through some other class in the application) which would dump out the System properties. Something like this:
This would show all the parameters that were passed to the JVM. Check the console or server.log for this output. See if the parameter is getting passed.
Joined: Dec 15, 2007
Thank you very much for your idea.
We managed to fix this issue in DB side.
We just have to change the type of the column from DATE to TIMESTAMP, which resolved the issue.