You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by ro...@vodafone.com on 2004/11/24 11:42:58 UTC
Getting JDBC drivers to work
Hi All,
Sorry to ask this question here, but as a cocoon user I hope and expect that
many of you have experience on this issue.
I'm kinda desperate... I don't have enough experience with installing
drivers.. I looked at dozens of sites how to get JDBC-drivers to work.
First of all, which drivers should i use? The thick(OCI) or thin drivers.
I want to make a connection from my desktop(WINNT) to an oracle database
(8.1.7.4). What are the actual steps I need to undertake to get this thing
running....
And i see so many different connection string examples it drives me
crazy.... So please mention these for OCI/thin if you have got it working.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Getting JDBC drivers to work
Posted by Ugo Cei <ug...@apache.org>.
Il giorno 24/nov/04, alle 11:42, robby.pelssers@vodafone.com ha scritto:
> I'm kinda desperate... I don't have enough experience with installing
> drivers.. I looked at dozens of sites how to get JDBC-drivers to work.
> First of all, which drivers should i use? The thick(OCI) or thin
> drivers.
Thin drivers are fine, they are 100% Java, don't use native code and
don't require installation of the Oracle client. Only if you find some
shortcomings with them, you should think about switching to the OCI
driver.
>
> I want to make a connection from my desktop(WINNT) to an oracle
> database
> (8.1.7.4). What are the actual steps I need to undertake to get this
> thing
> running....
Put the driver's JAR (ojdbc14.jar typically, but it depends on the
version) in WEB-INF/lib.
>
> And i see so many different connection string examples it drives me
> crazy.... So please mention these for OCI/thin if you have got it
> working.
jdbc:oracle:thin:@<hostname>:<port>:<sid>
Substitute suitable values for <hostname>, <port> (usually 1521) and
<sid> (ask your DBA) and you should be set. The classname of the driver
is oracle.jdbc.driver.OracleDriver
Ugo
--
Ugo Cei - http://beblogging.com/
Re: Getting JDBC drivers to work
Posted by Dan Durkin <dd...@scilearn.com>.
check out the jdbc section on
http://wiki.apache.org/cocoon/HowTos
robby.pelssers@vodafone.com wrote:
> Hi All,
>
> Sorry to ask this question here, but as a cocoon user I hope and expect that
> many of you have experience on this issue.
>
> I'm kinda desperate... I don't have enough experience with installing
> drivers.. I looked at dozens of sites how to get JDBC-drivers to work.
> First of all, which drivers should i use? The thick(OCI) or thin drivers.
>
> I want to make a connection from my desktop(WINNT) to an oracle database
> (8.1.7.4). What are the actual steps I need to undertake to get this thing
> running....
>
> And i see so many different connection string examples it drives me
> crazy.... So please mention these for OCI/thin if you have got it working.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org