±Û¾´ÀÌ :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...");
...