Thanks for the tips. I had hoped that changing from MSQL to 9i was going to be as easy as changing the JDBC driver. It would appear that's not going to be the case <sigh>.
Regards, Bruce -----Original Message----- From: daniele rizzi [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 17, 2002 9:35 AM To: James Users List Subject: R: How to make James work with Oracle database? -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Sorry I may only provide with data about James 1.2: in that case you had to create a table called "Message" with some fields, and then change the DbRepository entry in the config file. The Create Table script is not provided, but it's not hard to figure out what should be, cooking up the sqlServer/mySql examples. There are two caveats: - - first you cannot use CLOB but resort to LONG VARCHAR due to a bug in Sun jdbc - - then there are some massaging needed for the schema to run, due to some synergy between workingDogs' town and Oracle Jdbc Driver. Since you are using an upgraded version I'm not boring you with the details: the interesting point is that in v1.2 ( in 2 also?) the repository is screened by a java library, which creates a transparent relationship between the objects and the tables, that is james creates the object and this library produces the INSERT/UPDATE code needed. In *that* version there where at least two places to begin debugging: - - james itself fills a /log directory; - - and workingdogs' town creates a DBxxx.log file containing the details of the running connection. I cannot help more, I've tried once load & run the new james, but I've got no way to test IMAP so there is little reason to upgrade (I mean I'm not smart enough to judge if Imap works) bye, d.rizzi - -----Messaggio originale----- Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Inviato: gioved� 17 gennaio 2002 15.09 A: [EMAIL PROTECTED] Oggetto: RE: How to make James work with Oracle database? I'd be really interested in any James 2.0 / Oracle 9i information that you could share. Thanks, Bruce - -----Original Message----- From: daniele rizzi [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 17, 2002 2:57 AM To: James Users List Subject: R: How to make James work with Oracle database? - -----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 ([EMAIL PROTECTED]) - - -----Messaggio originale----- Da: John Wang [mailto:[EMAIL PROTECTED]] Inviato: gioved� 17 gennaio 2002 3.46 A: [EMAIL PROTECTED] 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: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> - -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -----BEGIN PGP SIGNATURE----- Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com> iQA/AwUBPEbhEHQ0FMcAcek4EQIy7gCbB+/qliuUWFtKctluI/1rZT2aqHgAoMF4 GoxTtvjmCLZgUxnCsKZ217E/ =1QsE -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
