Hi, I've run James on 10g XE and it works fine using the thin drivers. I haven't tried OCI but I think that if you do as Marcello suggests and connect James in the same way you would any other JDBC/OCI connection it will work OK. Your difficulty will probably be with the oracle install and the TNS.NAMES rather than with James itself.
d. On 24/04/06, Marcello Marangio <[EMAIL PROTECTED]> wrote: > Yes it does. > We use it also in failovermode. > The simplest oci connection string should look like this: > > jdbc:oracle:oci:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myH > ost)(PORT=1521)))(CONNECT_DATA=(SID=mySID))) > > To make it work with oracle 10g server you must set up the system variables > PATH (win2k) or LD_LIBRARYPATH (unix) to point to the directory where you > installed the Oracle Instant Client, i.e. to the proper dll or .so files. > Hope it helps > Ciao > Marcello > > > -----Messaggio originale----- > > Da: 向井 善�t [mailto:[EMAIL PROTECTED] > > Inviato: lunedì 24 aprile 2006 3.56 > > A: James Users List > > Oggetto: About the JDBC client of JAMES-2.1.3 > > > > Hello all, > > > > Does the JDBC client of JAMES-2.1.3 support OCI? > > If it supports , please teach me setting way. > > > > and > > > > Does the JDBC client of JAMES-2.1.3 support ORCLE10g SERVER? > > I tried it , but it did not succeed. > > > > [PRESENT SETTING] > > as following .... > > -------------------------------------------------------------- > > -------------- > > <data-source name="maildb" > > class="org.apache.james.util.mordred.JdbcDataSource"> > > <driver>oracle.jdbc.OracleDriver</driver> > > <dburl>jdbc:oracle:oci:@TNS</dburl> > > <user>ID</user> > > <password>PASS</password> > > <max>20</max> > > </data-source> > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
