Hi, After I upgrade Oracle client, JAMES could connect DB with OCI. Thank you very much.
Danny Angus wrote: >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] >> >> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
