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 向井　善則 <y....@internavi.ne.jp> on 2006/04/24 03:55:42 UTC

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: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org

Re: R: About the JDBC client of JAMES-2.1.3

Posted by 向井　善t <y....@internavi.ne.jp>.
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 <m....@tno.it> 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:y.mukai@internavi.ne.jp]
>>>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: server-user-unsubscribe@james.apache.org
>>>For additional commands, e-mail: server-user-help@james.apache.org
>>>      
>>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
>>For additional commands, e-mail: server-user-help@james.apache.org
>>    
>>

---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org

Re: R: About the JDBC client of JAMES-2.1.3

Posted by Danny Angus <da...@apache.org>.
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 <m....@tno.it> 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:y.mukai@internavi.ne.jp]
> > 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: server-user-unsubscribe@james.apache.org
> > For additional commands, e-mail: server-user-help@james.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> For additional commands, e-mail: server-user-help@james.apache.org
>
>

R: About the JDBC client of JAMES-2.1.3

Posted by Marcello Marangio <m....@tno.it>.
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:y.mukai@internavi.ne.jp] 
> 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: server-user-unsubscribe@james.apache.org
> For additional commands, e-mail: server-user-help@james.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org