Hi Max,
Thanks a lot.We are all using the 'thin' driver, that is JDBC-TYPE-4
Driver.
We can also use JDBC-TYPE-2 Driver as follows:
dbalias="oci8:@<your lisener name>"
Note:Always check for jdbc-level="1.0" in your repository.xml file.
In JDBC-TYPE-2 Driver is better perfomance than Type-3 and Type-4 drivers.Disadvantage
is we can't access Remote Database and platform dependency.
Cheers,
Dhamu
[EMAIL PROTECTED] wrote:Hi,
there is also a so called thin jdbc driver for oracle. It has the following
dbalias:
dbalias="thin:@:
:
where : name or ip address of the database server
: port number acording to the oracle listener (usually
1521)
: the alias defined in tnsnames.ora which holds the
information
for the sid, protocol, etc. (i think you can use
your syntax, too)
We are using this driver at the moment (and oracle 8.1.6), because you only
need to copy one jar file to the client and that is the whole oracle client
installation.
Regards
Max
> -----Urspr�ngliche Nachricht-----
> Von: Dhamodharan P [mailto:dhamubooks@;yahoo.co.uk]
> Gesendet: Donnerstag, 7. November 2002 04:11
> An: OJB Users List
> Betreff: dbalias for oracle
>
>
>
> Dear all,
>
> Any one help me what are the 'dbalias' string
> available for oracle other than the following:
>
> dbalias="oci8:@(description=(address=(host=>
>host>)(protocol=tcp)(port=1521))(connect_data=(sid=)))"
>
> Thanks in advance
>
> Dhamu
>
>
>
>
>
>
> ---------------------------------
> Get a bigger mailbox -- choose a size that fits your needs.
>
--
To unsubscribe, e-mail:
For additional commands, e-mail:
---------------------------------
Get a bigger mailbox -- choose a size that fits your needs.
