-
1. Re: V8Compatible: How to set it in JBoss?
jaikiran Jan 13, 2010 8:36 AM (in response to davidec)Which exact version of JBoss AS? And please post the exact changes you did the the run.bat and/or run.conf (which is only for *nix OS). As per the documentation you pointed to:
You can set this flag either as a connection property or a system property. You set the connection property by adding it to the java.util.Properties object passed to DriverManager.getConnection or to OracleDataSource.setConnectionProperties. You set the system property by including a -D option in your java command line.
So adding this -D option in the JAVA_OPTS section of the run.bat should ideally be enough.
Also, how do you start the server?
-
2. Re: V8Compatible: How to set it in JBoss?
davidec Jan 13, 2010 9:10 AM (in response to jaikiran)Hello!
Thanks for your quick reply.
I'm using JBoss 4.2.3
In run.bat I have a line like:
set JAVA_OPTS=%JAVA_OPTS% -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000 -Doracle.jdbc.V8Compatible=true
JAVA_OPTS is indeed correct (as displayed in the initial log), but the behaviour is not!
I start JBoss via Eclipse (I added -Doracle.jdbc.V8Compatible=true to the launch configuration), but the same happens when I start it from command prompt...
-
3. Re: V8Compatible: How to set it in JBoss?
jaikiran Jan 13, 2010 9:20 AM (in response to davidec)davidec wrote:
JAVA_OPTS is indeed correct (as displayed in the initial log), but the behaviour is not!
In that case, you will probably have to ask this on the oracle jdbc driver forum for their inputs. Are you sure the version of the driver you are using is the correct one and supports this property?
-
4. Re: V8Compatible: How to set it in JBoss?
davidec Jan 13, 2010 9:24 AM (in response to jaikiran)Pretty sure about the driver, or at least so Oracle says...
I've also asked Oracle forums and I'm waiting a reply, in the meantime I'm trying to use a custom mapping for the datasource, to use the old Oracle8 mappings... It seems useless, but I don't know what else to try...
Thanks again!
-
5. Re: V8Compatible: How to set it in JBoss?
jaikiran Jan 13, 2010 9:29 AM (in response to davidec)For the sake of completeness, please post your *-ds.xml file. Let's see if that has any issues.
-
6. Re: V8Compatible: How to set it in JBoss?
davidec Jan 13, 2010 9:40 AM (in response to jaikiran)I'd be happy to share my success...
but I haven't had any...
I'll let you know the replies from the other community...
-
7. Re: V8Compatible: How to set it in JBoss?
fjfdez Apr 27, 2010 6:19 AM (in response to davidec)Hello,
If you use "Jboss + Eclipse + Jboss-Seam + Jboss-Tools" and start your Jboss from Eclipse Server View, you need to add the argument into "Window/Preferences/Java/Installed JREs" and edit the entry you use, then, add argument -Doracle.jdbc.V8Compatible=true into "DefaultVM Arguments" field.
I use obdbc14.jar library with same configuration and working.
With that, all Date fields will use date/time format. If you want use only date format, you must add "@Temporal(TemporalType.DATE)" annotation to desired field.
Regards.
Francisco.