Hi,
When I am trying to retrieve the time stamp from the DB by using Select adapter service, it is retrieving only the date but not the time stamp. But in the DB it is having the time stamp. I have installed the jdbc_fix_10, reload the service then also it is showing only date but not the time stamp.
Hi,
I am using oracle DB, and I tried with for output field with java.util.date, java.sql.date and also java.lang.string. But I am getting only the date. When I tried in toad it is giving value with timestamp
We are using the JDBC Adapter to connect to an Oracle Database (9.2) where we are selecting a DATE field that includes both Date and Time information. The time information is always returned as 0.00.00 (eg. 10/3/2005 0:00:00 EDT). We tried implementing the setting described in SR-1-58258341 but this did not resolve the problem. webMethods Closure Summary
Install Jbdc Adapter 6.0.3 FP1
Fix4 resolves the issue. Fix7 supersedes Fix4. Apply either one.
Change the OtherProperties: driverType=<thin/oci>;connectionProperties={oracle.jdbc.V8Compatible=true}
Get the latest driver from oracle website (necessary).
Restart IS.
An Authorized Technical Contacts (ATC) for your company with software download privileges can usually download fixes from Advantage.
If your are one of those and can’t download the fixes, you should submit a Service Request asking for those fixes to be added to your download area. Support will also place fixes onto an FTP site or email them if they are small.
oracle.jdbc.V8Compatible=true is a java runtime setting, so you should be able to set this in the server.sh for the jvm to load this. Has anybody tried this with a new ojdbc14.jar?
equivalent would be:
-Doracle.jdbc.V8Compatible=true
This way you wouldn’t have to include it in every connection’s configuration that you require the behavior.