Bonjour Jean-Phillipe You can alter the default sort by manipulating SESSION NLS_SORT SESSION attribute ..for example connect [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> To: <users@tomcat.apache.org> Cc: "Jean-Philippe Boily" <[EMAIL PROTECTED]>; "Jean-Philippe Boily" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
