Oracle8i with JDBC problem...
From: Robert J. McCready <rmccread_at_mitre.org>
Date: Wed, 23 Jun 1999 21:36:42 -0400
Message-ID: <37718BAA.45E99CAF_at_mitre.org>
Hello everyone,
Date: Wed, 23 Jun 1999 21:36:42 -0400
Message-ID: <37718BAA.45E99CAF_at_mitre.org>
Hello everyone,
I've got a perplexing problem with communicating with and Oracle8i database with Java. I have what I believe to be all the required .class files from Oracle. The file I downloaded was classes111.zip which is the same name as the .zip file for Oracle7, but that's besides the point. When I try to connect, I issue the following command...
String userName = "scott"; String password = "tiger"; String url = "jdbc:oracle:oci8:_at_tatooine:1521:test2";
//
// Where the computer name is 'tatooine', and the service name is
'test2'
//
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); conn = DriverManager.getConnection(url,userName,password);
I can connect, but my programs all crash after trying to get results back from SQL commands. Am I just doing something wrong? I used a different url to connect to an Oracle7 database and have no problems...
String url = "jdbc:oracle:thin:_at_dee:1521:mii";
But that didn't effect my programs when I changed it. Any ideas?
-- Robert J. McCready Knowledge Management Software Engineer Email: rmccread_at_mitre.org The MITRE Corporation Phone: (781)-271-2288 202 Burlington Rd MS:K308 Fax: (781)-271-2352 Bedford, MA 01730 Web Site: http://www.mitre.org/resources/centers/it/g062/kmsystems/Received on Thu Jun 24 1999 - 03:36:42 CEST