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

[Eric Weidner <es...@pumavision.net>]

Renaming to .jar should be fine.

A word of caution....

I recently tried to use James with 9i using the steps in the attachment. 
 Everything worked great except that attachments over about 100kB were 
getting truncated when going through the smtp processor.  In the past 
few days, I finally got around to trying out Oracle 8.1.7 and had the 
same truncation problem.  I know there are a few people on here that I 
think are using Oracle 8 successfully.

If anyone has any ideas, please let me know.  Just beware that you may 
have some issues.

I'll be going to use MySQL soon anyway, but the problem would be nice to 
solve.

Eric Weidner
Sr. Consultant
EJB Solutions, Inc.

Lach, Thierry wrote:

> I've always been able to rename the oracle jdbc drivers from .zip to 
> .jar and they work just fine.
>
> -----Original Message-----
> From: Andrei Ivanov [mailto:myfam@surfeu.fi]
> Sent: Monday, June 17, 2002 4:23 PM
> To: James Users List
> Subject: Re: ClassNotFoundException error when trying to connect to 
> Oracle 9i
>
>
> 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>
>
>------------------------------------------------------------------------
>
>--
>To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
>For additional commands, e-mail: <ma...@jakarta.apache.org>
>