You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Jean-Philippe Boily <ji...@gmail.com> on 2006/02/16 19:16:04 UTC

OCI Driver and NLS_SORT

Hi,
   I am trying to use OCI Drivers with Tomcat. We have Tomcat 5.5, JDK
1.5 and classes12.jar for Oracle DB 8.1.7. Here is the error we have
when we try to connect. I found some places telling me it can only be
loaded once unless you turn on "Cache jars memory" setting...but I can
find how with command line on Linux. Here is the error I get :

java.lang.UnsatisfiedLinkError: Native Library
/path/to/oracle/logi/lib/libocijdbc8.so already loaded in another
classloader
	java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1716)
	java.lang.ClassLoader.loadLibrary(ClassLoader.java:1676)
	java.lang.Runtime.loadLibrary0(Runtime.java:822)
	java.lang.System.loadLibrary(System.java:992)
	oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java:232)
	oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:252)
	oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365)
	oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)
	java.sql.DriverManager.getConnection(DriverManager.java:525)
	java.sql.DriverManager.getConnection(DriverManager.java:171)
	gouv.mrn.dev.test.QueryServlet.service(QueryServlet.java:36)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)




Also, is there a way to configure NLS_SORT=FRENCH for Tomcat using
THIN drivers ? I tried to set it in startup.sh....but it doesn't seem
to work...anyone ?



Thanks !
Jean-Philippe Boily, Technical webmaster for Ministere des Ressources
Naturelles et de la Faune

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org

Re: OCI Driver and NLS_SORT

Posted by Martin Gainty <mg...@hotmail.com>.
Bonjour Jean-Phillipe

You can alter the default sort by manipulating SESSION NLS_SORT SESSION attribute ..for example
connect user@TNSNAME
alter session set nls_sort=FRENCH;
CREATE INDEX NLS_GENERIC ON TABLENAME
 ( NLSSORT(ColumnName,'NLS_SORT=FRENCH'));        Bon Chance!Martin-Etats Unis----- Original Message ----- 
From: "Jean-Philippe Boily" <ji...@gmail.com>
To: <us...@tomcat.apache.org>
Cc: "Jean-Philippe Boily" <ji...@gmail.com>; "Jean-Philippe Boily" <je...@mrnfp.gouv.qc.ca>
Sent: Thursday, February 16, 2006 1:16 PM
Subject: OCI Driver and NLS_SORT


Hi,
   I am trying to use OCI Drivers with Tomcat. We have Tomcat 5.5, JDK
1.5 and classes12.jar for Oracle DB 8.1.7. Here is the error we have
when we try to connect. I found some places telling me it can only be
loaded once unless you turn on "Cache jars memory" setting...but I can
find how with command line on Linux. Here is the error I get :

java.lang.UnsatisfiedLinkError: Native Library
/path/to/oracle/logi/lib/libocijdbc8.so already loaded in another
classloader
java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1716)
java.lang.ClassLoader.loadLibrary(ClassLoader.java:1676)
java.lang.Runtime.loadLibrary0(Runtime.java:822)
java.lang.System.loadLibrary(System.java:992)
oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java:232)
oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:252)
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365)
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)
java.sql.DriverManager.getConnection(DriverManager.java:525)
java.sql.DriverManager.getConnection(DriverManager.java:171)
gouv.mrn.dev.test.QueryServlet.service(QueryServlet.java:36)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)




Also, is there a way to configure NLS_SORT=FRENCH for Tomcat using
THIN drivers ? I tried to set it in startup.sh....but it doesn't seem
to work...anyone ?



Thanks !
Jean-Philippe Boily, Technical webmaster for Ministere des Ressources
Naturelles et de la Faune

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org