Hi folks, would be happy to get a hint!
I'm using Tomcat 4.01 and Oracle 8.1.7 on Linux. (1) The following is running fine: - A test client connects to a servlet, the servlet is connecting via jdbc to the database. - Another client (application) connects directly -without the servlet- to the database using a class JDBCPacs. (2) Now I want to use the class JDBCPacs in my servlet, to create a common interface - but I get a FileNotFoundException after instanciating the class, at connect(). When I look at the Oracle trace I can see the following: (1) the correct sql statement (2) ALTER SESSION SET nls_date_format = 'DD.MM.YYYY' WHY??? In the servlet code I modified two lines: db = new DB(); db.connect(); into pc = new JDBCPacs(); pc.connect(); In JDBCPacs the same class DB is used. Therefor there is no visible diference!! So JDBCPacs is running without Tomcat, what could cause that obvios "alter session..." ?? I checked the environment variables for oracle, everything seams ok. Maybe someone has a good idea, I hope !!! Thx Sunny -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>