> -----Original Message-----
> From: elias yacoub [mailto:[EMAIL PROTECTED]]
> Thank you for your help. Actually I can connect using the
> SQL*Plus. I don�t
> Please tell me if you have any idea of any tests that I can do.
can you post your source that creates a connection?
You should also put the oci8 dll in your path:
http://www.cis.upenn.edu/~cis550/projects/JDBC_doc/jdbcoci4.htm:
-- >8 --
The Windows version contains two dynamically linked library files:
OCI733JDBC.DLL and OCI803JDBC.DLL. The first is for JDBC OCI7, the
second
for JDBC OCI8. The directory containing them must be in your PATH. If
you
used the Oracle Installer it moved the DLLs to the [ORACLE_HOME]\BIN
directory, which is already in your PATH.
.
For all Oracle JDBC drivers you must set your CLASSPATH to include the
zip
file containing the Java classes that implement the driver. One way to
do
this is to place [ORACLE HOME]/jdbc/classes111.zip or [ORACLE
HOME]/jdbc/classes102.zip into your CLASSPATH.
For Oracle JDBC OCI drivers you must also set your PATH (Windows) or
LD_LIBRARY_PATH (Solaris) to include the directory containing the
appropriate DLL or so library file.
-- 8< --
this example is from <http://www.orafaq.org/faqjdbc.htm#OCI>
-- 8< --
import java.sql.*;
class dbAccess {
public static void main (String args []) throws SQLException
{
try {
Class.forName ("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
Connection conn = DriverManager.getConnection
("jdbc:oracle:oci8:@qit-uq-cbiw_orcl", "scott", "tiger");
// or oci7 @TNSNames_Entry, userid, password
Statement stmt = conn.createStatement();
ResultSet rset = stmt.executeQuery("select BANNER from
SYS.V_$VERSION");
while (rset.next())
System.out.println (rset.getString(1)); // Print col 1
stmt.close();
}
}
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
