Effects of creating Java Program using Oracle and SQL Database?

Asked By 0 points N/A Posted on -

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?

Answered By 0 points N/A #105430

Effects of creating Java Program using Oracle and SQL Database?



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

Related Questions