글쓴이 :kang 2000년 2월 11일 17:57:34
os : linux
db : oracle 8.0.5
osdk : 1.1
jdk : 1.1.7
JDBC Driver : 8.1.6, 8.0.5(solaris용) 모두 해보았습니다.
---------------------------------
LD_LIBRARY_PATH는 $ORACLE_HOME/jdbc/lib 잡았고,
$ORACLE_HOME/jdbc/lib/classes111.zip을 $OSDK_HOME/lib/에 Copy했습니다.
thin으로 하면 연결됩니다.
그런데, oci는 왜 안되는거죠?
고수님들, 해결 좀 해주세요.
-- [ terminal 에서 env 한 내용 ] -------------------------------
USERNAME=root
...
LOGNAME=root
ORACLE_SID=ORCL
NLS_LANG=KOREAN_KOREA.KO16KSC5601
LD_LIBRARY_PATH=:/home/oracle/app/oracle/product/8.0.5/lib:/home/oracle/app/oracle/product/8.0.5/jdbc/lib
JSWDK_HOME=/usr/local/jswdk-1.0.1
JSERV_HOME=/usr/local/JavaWebServer2.0
CLASSPATH=.:/usr/local/jsdk2.0/lib/jsdk.jar:/usr/local/jdk1.1.7/lib/classes.zip:/usr/local/jdk1.2.2/lib/tools.jar:/usr/local/jswdk-1.0.1/lib/servlet.jar:/usr/local/osdk/lib/osdk.jar:/home/oracle/app/oracle/product/8.0.5/jdbc/lib/classes111.zip
JAVA2_HOME=/usr/local/jdk1.2.2
HOSTTYPE=i386
PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/home/oracle/app/oracle/product/8.0.5/bin:/home/oracle/app/oracle/product/8.0.5/bin:/home/oracle/app/oracle/product/8.0.5/ows/3.0/bin:/usr/local/jdk1.1.7/bin:/usr/local/jsdk2.0/bin:/usr/local/jdk1.2.2/bin:/usr/local/jswdk-1.0.1:/root/bin:./:/usr/local/jdk1.1.7/bin:/usr/local/jsdk2.0/bin:/usr/local/jdk1.2.2/bin:/usr/local/osdk/bin
....
JAVA_HOME=/usr/local/jdk1.1.7
ORACLE_HOME=/home/oracle/app/oracle/product/8.0.5
OSTYPE=Linux
OSDK_HOME=/usr/local/osdk
_=/usr/bin/env
-- [ java conn_DB 했을때 Err 메세지 ] -------------------------------
www:/usr/local/osdk/samples10/myjava> java conn_DB
Connecting Oracle...
liboci805jdbc.so: ELF file data encoding not little-endian (liboci805jdbc.so)
java.lang.UnsatisfiedLinkError: no oci805jdbc in shared library path
at java.lang.Runtime.loadLibrary(Runtime.java)
at java.lang.System.loadLibrary(System.java)
at oracle.jdbc.oci7.OCIDBAccess.logon(OCIDBAccess.java:186)
...
...
www:/usr/local/osdk/samples10/myjava>
-- [ Source File : conn_DB.java ] ----------------------------------
..
DriverManager.registerDriver( new oracle.jdbc.driver.OracleDriver());
System.out.println(" Connecting Oracle... ");
Connection conn =
/* 1. thin
DriverManager.getConnection("jdbc:oracle:thin:@www:1521:ORCL","sis001","sis001");
*/
/* 2. oci
*/
DriverManager.getConnection("jdbc:oracle:oci8:@ORCL","sis001","sis001");
System.out.println(" Login Success...");
...