Re: tomcat classloader
Pif - 34 wrote:
I've replaced " Class.forName("oracle.jdbc.driver.OracleDriver"); "
by oracle.jdbc.driver.OracleDriver oracleDriver = null;
and this works perfectly.
As pointed out upthread, this does not. Something else must "work", whatever
"work" means to you, Pif, but of course, you refuse to show us any code so we
really cannot tell.
So my Jar [sic] is well placed, [sic] this seems to be an
error with the ClassLoader of tomcat [sic] !? [sic]
Tchyaah, right!
Kevin McMurtrie wrote:
Are you compiling against one version of the driver but running with a
different? I could be wrong, but I think
'oracle.jdbc.driver.OracleDriver' is sometimes a private class. Try
'oracle.jdbc.OracleDriver'.
I believe that 'oracle.jdbc.driver.OracleDriver' is public in all the JARs
Oracle distributes, but that's moot anyway. Plus I could be wrong also.
Using the 'DriverManager' way to load the driver, you are supposed to use
'oracle.jdbc.OracleDriver' in preference to the other as you say. However,
that whole technique, according to Oracle, and to Sun even before Oracle
acquired it, is deprecated.
<http://download.oracle.com/docs/cd/E11882_01/appdev.112/e12137/getconn.htm#CACCCIIC>
"Note:
"The use of the DriverManager class to establish a connection to a database is
deprecated."
They tell you to use 'oracle.jdbc.pool.OracleDataSource' instead.
I go a tad further and suggest following Tomcat's instructions on how to set
up a data source.
However, "Pif - 34" has shown no interest in Arne's or my suggestions,
responding to our questions or providing an SSCCE, so I suppose I'm just
shouting in the wilderness.
Come to think of it, we haven't heard from "Pif" at all in over a week. I
hope they're all right!
--
Lew