You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Les Hughes <le...@rubus.com> on 2002/07/05 13:33:25 UTC
RE: tomcat 4.0.4, JNDI, Datasource.getConnection() -> No suitable
driver, [Oracle]
Hi,
Search the archives as there's a lot of info from recent discussions.
1) You have to rename classes12.zip to classes12.jar and place in
$CATALINA_HOME/common/lib
1a) You will have to remove javax.sql from this jar as well for some
versions of TC
2) Tyrex seems to have problems. There are some discussions about how to get
this working but DBCP seems to be a better bet.
3) A recent Howto discusses how to use the oci8 client instead of the thin
client - again check the tomcat-user archives.
We've recently written a Datasource HOWTO that should be in the latest
nightly build - grab a copy and have a read.
Hope this helps
Les
> -----Original Message-----
> From: Pedro Salazar [mailto:pedro-b-salazar@ptinovacao.pt]
> Sent: 05 July 2002 12:00
> To: tomcat-user@jakarta.apache.org
> Subject: tomcat 4.0.4, JNDI, Datasource.getConnection() -> No suitable
> driver, [Oracle]
>
>
> Greetings,
>
> I'm moving a webservice from tomcat 4.1.2 (WSDP 1.0) --> tomcat 4.0.4
> because I want to go to production environment and instead of
> using the
> tomcat bundled with WebServiceDevelopmentPack 1.0 (WSDP 1.0),
> I want to
> use a conventional/isolated tomcat. I choose the tomcat 4.0.4 (latest
> stable version).
>
> I added a default context in tomcat isolated service section on
> conf/server.xml with my jdbc resources, and I deploy my oracle driver
> package in common/lib/ directory (renamed as a jar file).
>
> PROBLEM:
> ----------
> I'm having problems using a connection manager from JNDI! I'm
> getting an exception "java.sql.SQLException: No suitable
> driver" when I
> try to get a connection from datasource:
>
> ds = (DataSource)initCtx.lookup("java:comp/env/jdbc/crumpetdb");
> ds.getConnection(); //EXCEPTION!!
>
>
> It appears that tomcat 4.0.4 uses tyrex connection manager
> (tyrex-0.9.7.0.jar). What is connection manager of tomcat 4.1.2 (WSDP
> 1.0)? I tried the tyrex's latest version (1.0), but still
> have the same
> problem. In tomcat 4.1.2 I didn't have this problem!
>
> Please, anyone figures what is my problem?
>
> PS. By the way, how to insert a zip file with classes to a
> tomcat's lib
> directory but without renaming it to a jar file? What should
> I change in
> catalina startup script?
>
> thanks,
> Pedro Salazar
>
>
>
>
>
> --
> To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>