Effects of creating Java Program using Oracle and SQL Database?

Asked By aldrene 0 points N/A Posted 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?

• Status: Open
• Question Views: 1078
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Java

Answered By Dhiman Tanu 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

About Dhiman Tanu

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 11/06/2011
• Question Category: Java