Yesterday i was using oracle 9.1 with ojdbc 14 jdbc driver with following code for adding employee, it was working fine but now i am using oracle 10.1.0.2.0 with ojdbc14 but now it is giving following error
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor error
did you check if classes12.jar exists in the classpath or not?
Joined: Jun 28, 2011
Also is the SID is same for Oracle 9 and Oracle 10 database that you are connecting or they are different? This error might be generating due to oracle SID name mismatch and may not be a driver or ojdbc issue.
subject: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor