Strange oracle errors

Recently I faced some problems with the oracle db connection with java. I googled every site searching for an answer and what I got never helped me. I have a Java program that reads records from a file and pushes the file into DB. In order to connect DB, I used thick driver for connectivity.
Weird! Even though i specified the right URL "jdbc:oracle:oci:@tnsname", it started saying "Invalid Oracle URL Specified". As the task was marked high priority, without worrying about the error, I moved to thin driver. Strange! It says "Connection reset by peer. Socket write error".

Connection reset by peer

I started searching the Google, most of the answers was it is related to network. But I could not find any error with network. I checked the trace file in DB Service and found ORA-0600 Critical Error. Later I realized that thin client do transfer a files with size more than certain KB ( not sure about the threshold size). My file was of 30 KB.

Invalid Oracle URL Specified

So again I started trying my luck with Thick driver. Entire internet said include Oracle path into system library and so. But this was due to a wrong classes12.jar included in the system. Now program started running.

Closed Connection

This problem I faced because I forgot create a variable called ORACLE_HOME. When we use thick driver, it searches for ORACLE_HOME environment variable.

Now I rectified all the problems. Now I made a checklist for me.

• 
  If file transfer required, go for native implementation of connectivity - Thick driver.


• Make sure that ORACLE_HOME variable is defined.

Related Posts by Categories

Widget by Scrapur