oci « oracle « Java Database Q&A

1. Oracle thin driver vs. OCI driver. Pros and Cons? stackoverflow.com

When you develop a Java application that talks to oracle DBs, there are 2 options right? One is oracle thin driver, and the other is OCI driver that requires its own ...

2. Java oci db connection failover with Oracle 9 stackoverflow.com

We need the ability to failover from one database host to the other in the case that the one we’re currently connected to goes down. From what we’ve read, “Transparent Application ...

3. JDBC OCI Query Notification Sample stackoverflow.com

I am looking for a sample program using the OCI JDBC driver (Implementation-Version: 11.2.0.1.0) trying the query notification feature provided by Oracle 11gr2. Since the oracle link shows a ...

4. Getting Stale Connection using OracleDataSource with OCI driver stackoverflow.com

I am getting stale connection error when there is no requests to the database from my java application for couple of hours. Its a simple java application runned on Linux box ...

5. Oracle OCI Driver coderanch.com

6. Weblogic Connection Pool and Oracle OCI Drivers coderanch.com

7. oracle oci connection-entry point kpufhndl0 could not be located coderanch.com

8. Need help in OCI DB connection with Oracle 10g coderanch.com

Hi all, I was tring to create OCI DB connection for Oracle 10g, below is my code to get the connetion using the OCI, no problem while retrive the connection, but when the executeQuery called i got the following exception. Recetly i've download some sample application from net for this testing, so remaining all coding for DB is stands on Oracle ...

9. Cannot create JDBC driver of class 'oracle.jdbc.OracleDriver'for connect URL 'jdbc:oracle:oci:@mydbs coderanch.com

I'm trying to connect to an Oracle database (10g) via OCI in Tomcat 5.5. I've checked the configuration many times and all looks OK, but I keep getting an error. "Cannot create JDBC driver of class 'oracle.jdbc.OracleDriver'for connect URL 'jdbc:oracle:oci:@mydbserver' " I have the ojdbc14.jar file in the common/lib folder of tomcat, the web.xml has the resource reference and I have ...

10. Oracle Java OCI and Thin dbforums.com

people say oci drivers are platform dependent jdbc thin are independent..im a lil confused.. im new to java n was working on .net previosuly.... ive only downloaded this ojdbc14.jar and working for both OCI and thin...so where the platform dependent part comes in...?? is it the oracle client installation which is platform dependent? in any case my application will remain platform ...

11. [Oracle][ODBC][Ora]ORA-24801: illegal parameter value in OCI lob function forums.oracle.com

As suggested I may try switching to JDBC instead of JDBC-ODBC bridge driver , but I also tried doing this to get the sysdate -- //Date dt = new SimpleDateFormat("mm/dd/yyyy").parse("04/02/2008"); String date = DateFormat.getInstance().format(new Date()); .......... .......... stmt.setString(5,date); and now I am getting this error -- 5 6 7 8 9 10 [Oracle][ODBC][Ora]ORA-01843: not a valid month Hello1 Hello1 is coming ...