ClassNotFoundException error when trying to connect to Oracle 9i

[bhogan <bh...@utility.vccs.edu>]

I'm having problems getting James to talk to an external Oracle 9i 
database.Does anyone have any suggestions?  Thanks!

My config.xml:
<data-source name="maildb"
                     class="org.apache.james.util.mordred.JdbcDataSource">
            <driver>oracle.jdbc.driver.OracleDriver</driver>
            <dburl>jdbc:oracle://123.123.123.23/PROTO9</dburl>
            <user>name</user>
            <password>blah</password>
            <max>2</max>
        </data-source>

Error from phoenix.log:

rethrown from
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
	at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:299)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:255)
	at 
org.apache.avalon.cornerstone.blocks.datasource.DefaultDataSourceSelector.init
ialize(DefaultDataSourceSelector.java:94)
	at 
org.apache.avalon.phoenix.components.application.LifecycleHelper.startup(Lifec
ycleHelper.java:199)

Please note I have a new e-mail address

Brendan L. Hogan, MCSE, MCT
Product Support Engineer
Virginia Community College Utility
Customer Support Center
bhogan@utility.vccs.edu
540-857-6475 
fax 540-857-6090


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

Re: ClassNotFoundException error when trying to connect to Oracle 9i

[Andrei Ivanov <my...@surfeu.fi>]

If your Oracle drivers are in zip this is *not* ok for Phoenix. They must be
in jar with valid manifest. I recommend you to unzip your Oracle drivers and
then jar them for example with ant. If you use excalibur packages for
database access make sure they are located in same directory as your jdbc
drivers. Simplest way is to just have them all under phoenix/lib directory.
Hope this helps,
Andrei

----- Original Message -----
From: "bhogan" <bh...@utility.vccs.edu>
To: <ja...@jakarta.apache.org>
Sent: Monday, June 17, 2002 11:02 PM
Subject: ClassNotFoundException error when trying to connect to Oracle 9i


> I'm having problems getting James to talk to an external Oracle 9i
> database.Does anyone have any suggestions?  Thanks!
>
> My config.xml:
> <data-source name="maildb"
>                      class="org.apache.james.util.mordred.JdbcDataSource">
>             <driver>oracle.jdbc.driver.OracleDriver</driver>
>             <dburl>jdbc:oracle://123.123.123.23/PROTO9</dburl>
>             <user>name</user>
>             <password>blah</password>
>             <max>2</max>
>         </data-source>
>
> Error from phoenix.log:
>
> rethrown from
> java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
> at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
> at java.security.AccessController.doPrivileged(Native Method)
> at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:299)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:255)
> at
>
org.apache.avalon.cornerstone.blocks.datasource.DefaultDataSourceSelector.in
it
> ialize(DefaultDataSourceSelector.java:94)
> at
>
org.apache.avalon.phoenix.components.application.LifecycleHelper.startup(Lif
ec
> ycleHelper.java:199)
>
> Please note I have a new e-mail address
>
> Brendan L. Hogan, MCSE, MCT
> Product Support Engineer
> Virginia Community College Utility
> Customer Support Center
> bhogan@utility.vccs.edu
> 540-857-6475
> fax 540-857-6090
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>



--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>