If you are going to create the Java Program using the Oracle and the SQL Database, is there a possibility that the speed execution of the program is affected? If yes, please explain why?
If so, is there another way or method in creating the Java Program that will not affect the performance of the program?
Â
Hi aldrene,
The main problem i see with oracle.jdbc.V8Compatible=true is inability to write java.sql.timestamp (with milliseconds) value to TIMESTAMP column.
Java timestamp objects (being of type java.util.Date or java.util.Calendar) are still transformed by JDBC driver to ORACLE TIMESTAMP.
Please take a look at test case provided https://community.oracle.com/message/3613155
What i understand from http://www.oracle.com/technetwork/topics/index.html#08_01
is that in JDBC driver 11g DATE columns are again mapped to java.sql.Timestamp, but nothing is written about reverse mapping: from java.sql.Timestamp to DATE.
SQL is also a good option.the SQL and java is provide API package .which contain following drive manager:
Driver manager
SQL permission class
Driver interface
Â
Thank you. Hope it helps you
