N/APosted on - 11/05/2011
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?
Effects of creating Java Program using Oracle and SQL Database?
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:
SQL permission class
Thank you. Hope it helps you