You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-user@james.apache.org by John Wang <hw...@reef.com> on 2002/01/17 03:46:29 UTC

How to make James work with Oracle database?

I am having problem with using oracle repository, I have created a db datasource as below:
        <data-source name="maildb"
                     class="org.apache.avalon.excalibur.datasource.JdbcDataSource">
         <driver>oracle.jdbc.driver.OracleDriver</driver>
         <dburl>jdbc:oracle:thin:@JWANG:1521:JWANG</dburl>
         <user>system</user>
         <password>manager</password>
        </data-source>


and then I set up the inbox repository,
      <inboxRepository>
        <repository destinationURL="db://maildb/inbox/"
                    type="MAIL">
        </repository>
      </inboxRepository>

and I have also setup the db repository for users and list, 

I have created the tables by myself, including inbox,users,lists tables,

I have also put classes12.jar (oracle jdbc driver) into the lib directory,

When I started the james, it hanged there, no error messages, no log coming out, the only message I saw is:

"Phoenix 3.1a1-dev"

What is going on? Can anyone help me?
Thanks very much!
John W

R: How to make James work with Oracle database?

Posted by daniele rizzi <da...@mail.largesys.it>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


I've spent boxing day setting up james 1.2 with Oracle 9i,
but finally it works. Would you state if you are using 1.2 or 2.*?

dany rizzi (drizzi@largesys.it)



- -----Messaggio originale-----
Da: John Wang [mailto:hwang@reef.com]
Inviato: giovedì 17 gennaio 2002 3.46
A: james-user@jakarta.apache.org
Oggetto: How to make James work with Oracle database?


I am having problem with using oracle repository, I have created a db
datasource as below:
        <data-source name="maildb"

class="org.apache.avalon.excalibur.datasource.JdbcDataSource">
         <driver>oracle.jdbc.driver.OracleDriver</driver>
         <dburl>jdbc:oracle:thin:@JWANG:1521:JWANG</dburl>
         <user>system</user>
         <password>manager</password>
        </data-source>


and then I set up the inbox repository,
      <inboxRepository>
        <repository destinationURL="db://maildb/inbox/"
                    type="MAIL">
        </repository>
      </inboxRepository>

and I have also setup the db repository for users and list,

I have created the tables by myself, including inbox,users,lists tables,

I have also put classes12.jar (oracle jdbc driver) into the lib directory,

When I started the james, it hanged there, no error messages, no log coming
out, the only message I saw is:

"Phoenix 3.1a1-dev"

What is going on? Can anyone help me?
Thanks very much!
John W



-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBPEaDpnQ0FMcAcek4EQI4rgCgxX/5qKC4eLDcHOENKGVOcR0u7moAoMmO
Xa5TBrGxHVlC2Cezqxp8qES6
=+z7x
-----END PGP SIGNATURE-----


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