tomcat-user@jakarta.apache.org
Sent: Friday, March 04, 2005 9:45 AM
Subject: Re: Tomcat 5.5.8 Postgresql 7.4.6 No
suitable driver exception
Sorry - wrong wget lines - I meant to provide this
statement:
wget
http://jdbc.postgresql.org/download/pg74.215.jdbc2.jar
I then untarred
Datasource How To
example for Postgresql to work.
Here is the URL for the example:
http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-datasource-examples-howto.html
After completing the listed steps the test.jsp error
page reports:
java.sql.SQLException: No suitable driver
Here are all my configuration
-howto.html
After completing the listed steps the test.jsp
error
page reports:
java.sql.SQLException: No suitable driver
Here are all my configuration steps, including the
files:
- On Fedora Core 3 - adduser postgres
- passwd postgres (set to postgres)
- chown postgres /var/lib/pqsql/data
-examples-howto.html
After completing the listed steps the test.jsp
error
page reports:
java.sql.SQLException: No suitable driver
Here are all my configuration steps, including
the
files:
- On Fedora Core 3 - adduser postgres
- passwd postgres (set to postgres)
- chown postgres
-examples-howto.html#Database%20Connection%20Pool%20(DBCP)%20Configurations
Doug
- Original Message -
From: Ole Ersoy [EMAIL PROTECTED]
To: Tomcat Users List tomcat-user@jakarta.apache.org
Sent: Friday, March 04, 2005 9:45 AM
Subject: Re: Tomcat 5.5.8 Postgresql 7.4.6 No suitable driver
:
java.sql.SQLException: No suitable driver
Here are all my configuration steps, including the
files:
- On Fedora Core 3 - adduser postgres
- passwd postgres (set to postgres)
- chown postgres /var/lib/pqsql/data
- /usr/bin/initdb -D /var/lib/pgsql/data
- /usr/bin/postmaster -D /var/lib/pgsql/data logfile
21
Hi,
I am using tomcat-5. I was trying out the connection pooling in it. I did things as per their documentation but ended up with this error.
javax.servlet.ServletException: Cannot create JDBC driver of class '' for connect URL 'null', cause: No suitable driver
Does anyone have any idea what
create JDBC driver of class '' for
connect URL 'null', cause: No suitable driver Does anyone have any idea
what and what this is. I am at loss why after finding the JDNI resource its
not able to pick up its parameters.
regards,
Isen
driver
of
class '' for connect URL 'null', cause: No suitable driver
Please show us the source that is causing this error...
On Monday 02 August 2004 02:44 pm, Isen,Ciji wrote:
Hi,
I am using tomcat-5. I was trying out the connection pooling in it. I
did
things as per their documentation but ended
Isen,Ciji wrote:
Hi,
I am using tomcat-5. I was trying out the connection pooling in it. I
did things as per their documentation but ended up with this error.
javax.servlet.ServletException: Cannot create JDBC driver of class ''
for connect URL 'null', cause: No suitable driver
Does anyone have any
.
javax.servlet.ServletException: Cannot create JDBC driver of class '' for
connect URL 'null', cause: No suitable driver Does anyone have any idea
what and what this is. I am at loss why after finding the JDNI resource its
not able to pick up its parameters.
regards,
Isen
-Original Message-
From: Robert Bateman [mailto:[EMAIL PROTECTED]
Sent: Monday, August 02, 2004 3:02 PM
To: Tomcat Users List
Subject: Re: javax.servlet.ServletException: Cannot create JDBC driver
of
class '' for connect URL 'null', cause: No suitable driver
Please show us the source
[mailto:[EMAIL PROTECTED]
Sent: Monday, August 02, 2004 3:49 PM
To: Tomcat Users List
Subject: Re: javax.servlet.ServletException: Cannot create JDBC driver
of
class '' for connect URL 'null', cause: No suitable driver
I wanted to tinker around hence i decide to just test using a jsp. The
jsp code
: Monday, August 02, 2004 3:49 PM
To: Tomcat Users List
Subject: Re: javax.servlet.ServletException: Cannot create JDBC driver
of
class '' for connect URL 'null', cause: No suitable driver
I wanted to tinker around hence i decide to just test using a jsp. The
jsp code is pasted below.
[EMAIL
Informatics
-Original Message-
From: Isen,Ciji [mailto:[EMAIL PROTECTED]
Sent: Monday, August 02, 2004 3:49 PM
To: Tomcat Users List
Subject: Re: javax.servlet.ServletException: Cannot create JDBC driver
of
class '' for connect URL 'null', cause: No suitable driver
I wanted to tinker around
: Thursday, July 01, 2004 7:59 PM
To: 'Tomcat Users List'
Cc: '[EMAIL PROTECTED]'
Subject: RE: Tomcat - MySQL = No suitable driver ERROR
Ok, the contents of {TOMCAT_HOME}/conf/Catalina/localhost/DBTest.xml is:
Context debug=5 displayName=DBtest docBase=DBTest path=/DBtest
reloadable=true workDir=work
= No suitable driver ERROR
yes patrick,
i guess that is what david and i want so your dbtest works. allthough the
posted contents of web.xml lack a doctype or schema definition (see hassans
post). now, have you tried this?
cheers, jan
This e-mail message, including any attachments, is for the sole use
problem. I am sure that someone will know...
Jan
-Original Message-
From: Briggs, Patrick [mailto:[EMAIL PROTECTED]
Sent: Friday, July 02, 2004 6:36 PM
To: 'Tomcat Users List'
Subject: RE: Tomcat - MySQL = No suitable driver ERROR
David had me do this following proceedure and that seemed
AM
To: Tomcat Users List
Subject: Re: Tomcat - MySQL = No suitable driver ERROR
Ok. I think I'm seeing your trouble. The stuff you have in
WEB-INF/DB-Test.xml should be in web.xml instead. In mine, the
resource-ref.../resource-ref stuff is at the end of the file just
before the closing /web
: Wednesday, June 30, 2004 6:56 PM
To: Tomcat Users List
Subject: Re: Tomcat - MySQL = No suitable driver ERROR
Ok. I think I'm seeing your trouble. The stuff you have in
WEB-INF/DB-Test.xml should be in web.xml instead. In mine, the
resource-ref.../resource-ref stuff is at the end of the file
Yeah, I just tried that and still no go. Still getting:
javax.servlet.ServletException: Unable to get connection, DataSource
invalid: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC
driver of class '' for connect URL 'null', cause: No suitable driver
-Original Message
, 2004 10:20 AM
To: 'Tomcat Users List'
Subject: RE: Tomcat - MySQL = No suitable driver ERROR
Yeah, I just tried that and still no go. Still getting:
javax.servlet.ServletException: Unable to get connection, DataSource
invalid: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC
: Tomcat - MySQL = No suitable driver ERROR
I have seen this one too many times. It usually has to do with the naming
lookup. I have had to keep playing with the form of the name until it
worked.
Robert S. Harper
801.265.8800 ex. 255
-Original Message-
From: Briggs, Patrick [mailto:[EMAIL
Users List
Subject: Re: Tomcat - MySQL = No suitable driver ERROR
Ok. I think I'm seeing your trouble. The stuff you have in
WEB-INF/DB-Test.xml should be in web.xml instead. In mine, the
resource-ref.../resource-ref stuff is at the end of the file just
before the closing /web-app tag
David Smith wrote:
I was recommending you take the resource-ref.../resource-ref stuff
you put in {TOMCAT_HOME}/webapps/DBTest/WEB-INF/DBTest.xml and put that
in {TOMCAT_HOME}/webapps/DBTest/WEB-INF/web.xml.
Yes, and in addition --
Here is what my web.xml looks like now:
?xml version=1.0
/resource-ref
/web-app
Is this what you wanted?
-Original Message-
From: David Smith [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 01, 2004 10:25 AM
To: Tomcat Users List
Subject: Re: Tomcat - MySQL = No suitable driver ERROR
Hold on a minute. I think we have a communication problem
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 30, 2004 12:01 AM
To: '[EMAIL PROTECTED]'
Subject: Tomcat - MySQL = No suitable driver ERROR
I'm trying to setup Tomcat 5.0.25 to talk to a MySQL database and I've had
no luck after several days of fighting with this thing. I'm following along
it where it needs changes for
URL and username/password.
Still getting the same error message :(
So now what could it be?
-Original Message-
From: Jan Behrens [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 30, 2004 1:58 AM
To: 'Tomcat Users List'
Subject: RE: Tomcat - MySQL = No suitable
Behrens [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 30, 2004 1:58 AM
To: 'Tomcat Users List'
Subject: RE: Tomcat - MySQL = No suitable driver ERROR
Hi Patrick,
the problem might be that in Tomcat 5.x the storage of the context related
configuration changed from server.xml to a sepparate file
12:19 PM
To: Tomcat Users List
Subject: Re: Tomcat - MySQL = No suitable driver ERROR
Wrong place for mysql jar file. It should be in
{TOMCAT_HOME}/common/lib right along side the DBCP jar file.
--David
Briggs, Patrick wrote:
If the webapps.xml file is supposed to be located in Catalina
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 30, 2004 12:19 PM
To: Tomcat Users List
Subject: Re: Tomcat - MySQL = No suitable driver ERROR
Wrong place for mysql jar file. It should be in
{TOMCAT_HOME}/common/lib right along side the DBCP jar file.
--David
Briggs, Patrick wrote
the ressource.
HTH, Jan
-Original Message-
From: Briggs, Patrick [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 30, 2004 9:47 PM
To: 'Tomcat Users List'
Subject: RE: Tomcat - MySQL = No suitable driver ERROR
Ok, I have it in the common/lib directory, but that didn't make a
difference. You'd think
'null', cause: No suitable driver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextI
mpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp
l.java:758)
org.apache.jsp.test_jsp._jspService(test_jsp.java:81
: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC
driver of class '' for connect URL 'null', cause: No suitable driver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextI
mpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp
l.java:758
PROTECTED]
Sent: Wednesday, June 30, 2004 9:47 PM
To: 'Tomcat Users List'
Subject: RE: Tomcat - MySQL = No suitable driver ERROR
Ok, I have it in the common/lib directory, but that didn't make a
difference. You'd think there would be a lot easier way to setup stuff like
this. Editing XML files
this up shouldn't
be this complicated.
The error message I keep getting all the time is:
javax.servlet.ServletException: Unable to get connection, DataSource
invalid: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC
driver of class '' for connect URL 'null', cause: No suitable driver
[EMAIL PROTECTED]
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
Subject: Tomcat - MySQL = No suitable driver ERROR
Date: Tue, 29 Jun 2004 15:00:59 -0700
I'm trying to setup Tomcat 5.0.25 to talk to a MySQL database and I've had
no luck after several days of fighting with this thing. I'm following
'
oracle.jdbc.driver.OracleDriver' for connect URL
'jdbc:oracle:[EMAIL PROTECTED]
:1521:[sid]', cause:
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(DriverManager.java:243)
at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
rce.java
Please double check and make sure your ojdbc.jar is in
$CATALINA_HOME/common/lib.
-Original Message-
From: MARU, SOHIL (SBCSI) [mailto:[EMAIL PROTECTED]
Sent: Friday, April 09, 2004 8:02 AM
To: [EMAIL PROTECTED]
Subject: No Suitable Driver Problem
Hey Doug,
I tried moving the username
-
From: Daniel Huang [mailto:[EMAIL PROTECTED]
Sent: Friday, April 09, 2004 11:22 AM
To: Tomcat Users List
Subject: RE: No Suitable Driver Problem
Please double check and make sure your ojdbc.jar is in
$CATALINA_HOME/common/lib.
-Original Message-
From: MARU, SOHIL (SBCSI) [mailto:[EMAIL
Never mind, even though I am using jdk1.4 and tomcat5.0, I had to
replace ojdbc14.jar with classes version to get it to work.
-Original Message-
From: MARU, SOHIL (SBCSI)
Sent: Friday, April 09, 2004 11:26 AM
To: 'Tomcat Users List'
Subject: RE: No Suitable Driver Problem
Hi Daniel
PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Friday, April 09, 2004 12:25 PM
Subject: RE: No Suitable Driver Problem
Hi Daniel,
I managed to solve this one, my database url was missing the schema
name, that was causing the problem. I changed it from
jdbc:oracle:[EMAIL PROTECTED
and let us know.
Doug
- Original Message -
From: Todd H. Siegel [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Saturday, March 27, 2004 6:39 PM
Subject: Re: No suitable driver
Doug,
I made those changes and I still have the same problem
you got it working.
Doug
- Original Message -
From: Todd H. Siegel [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Monday, March 29, 2004 8:12 PM
Subject: Re: No suitable driver
Success!
Thanks for your help Doug. I am going to submit this to the developer
list
]
Sent: Saturday, March 27, 2004 6:39 PM
Subject: Re: No suitable driver
Doug,
I made those changes and I still have the same problem.
org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver
of
class
: No suitable driver
Here's my config info:
From server.xml:
GlobalNamingResources
Resource name=jdbc/dbName
auth=Container
type=javax.sql.DataSource/
ResourceParams name=jdbc/dbName
parameter
namemaxActive/name
value100/value
it a try and let us know.
Doug
- Original Message -
From: Todd H. Siegel [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Saturday, March 27, 2004 6:39 PM
Subject: Re: No suitable driver
Doug,
I made those changes and I still have the same problem
URL 'jdbc:microsoft:sqlserver://*hostname*', cause: No suitable
driver
In the interest of keeping this brief I won't include all of the config,
but
I've tried putting the Resource ResourceParams definitions in the
Context element for the webapp in server.xml.
I've also put the Resource
Todd,
This:
Resource name=resourceName auth=Container
type=javax.sql.DataSource/
This:
ResourceParams name=resourceName
This:
ResourceLink name=jdbc/dbname
global=resourceName
type=javax.sql.DataSource /
This:
resource-ref
?
Are they corrupted?
Driver jar goes in common/lib.
Doug
- Original Message -
From: Todd H. Siegel [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 10:12 PM
Subject: No suitable driver
All,
I know that this issue has been posted many times, I have read many of
them
*', cause: No suitable driver
In the interest of keeping this brief I won't include all of the config, but
I've tried putting the Resource ResourceParams definitions in the
Context element for the webapp in server.xml.
I've also put the Resource ResourceParams definitions
Hello Dan,
I finally got it to work.
The problem is that for directories in webapps a Context is
automatically created, even if it is already declared in server.xml. The
automatically created Contexts do NOT contain the context specific
configuration of server.xml. The outcome is that a) a
Andreas,
Not sure if you got a response yet. Generally, when I have seen the
error above, it seemed to be coming from the web app saying that it
didn't get the parameters. I am fighting this same error. Strange
enough, though, I had it working as you have yours setup. Another thing
is that
of
people that could not solve the problem, maybe there is a bug in Tomcat5?
Regards,
Andreas
org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of
class '' for connect URL 'null', cause:
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver
Andreas Schildbach wrote:
I get this error using Tomcat 5.0.18 under Debian/Linux. Using the same
configuration under Windows XP, there is no problem. Using the same
application under Tomcat 4.1.27, there is no problem (either Linux or
Windows).
: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC
driver of class '' for connect URL 'null', cause: java.sql.SQLException: No
suitable driver
Andreas Schildbach wrote:
I get this error using Tomcat 5.0.18 under Debian/Linux. Using the same
configuration under Windows XP, there is no problem. Using the same
[EMAIL PROTECTED] wrote:
where did u put the jar?
thats what got me.
it needs to go in common\lib in your tomcat dir
Here is the content of common/lib
xxx:/opt/tomcat5# ls -la common/lib
total 3376
drwxr-xr-x2 tomcat5 nogroup 4096 Feb 11 17:07 .
drwxr-xr-x5 tomcat5 nogroup
) - AdminFactory.getTestData()
**1**
**2**
**3**
Caught while creating a connection in EPP
dB:=org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class ''
for connect URL 'null', cause: No suitable driver
2004-02-03 09:37:30,161 [http80-Processor4] ERROR (class
]
Subject: No Suitable Driver Error -- Still No Success
Importance: High
Hi ,
I am getting the following error in JDBC connection pooling.
Error log and other details are as follows:
Please help !!
Regards
Abhay
the resource after a hot redeploy. I'm still
working on it...
Jay
-Original Message-
From: Kumar Abhay-CAK203C [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 03, 2004 9:46 AM
To: [EMAIL PROTECTED]
Subject: No Suitable Driver Error -- Still No Success
Importance: High
Hi ,
I am getting
AM
To: 'Tomcat Users List'
Subject: RE: No Suitable Driver Error -- Still No Success
What does your web.xml look like? Read step 3 on this page:
http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples
-howto.html
-Original Message-
From: Kumar Abhay-CAK203C [mailto
: Kumar Abhay-CAK203C [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 03, 2004 10:11 AM
To: 'Tomcat Users List'
Subject: RE: No Suitable Driver Error -- Still No Success
Importance: High
This is my Web.xml
resource-ref
res-ref-namejdbc/estimation/res-ref-name
res
URL 'null', cause: No suitable driver
Hi Abhay,
here I had the same problem some time ago. I can't reproduce exactly
how we solved the problem, but we solved it ;-)
Here's a Context from my server.xml:
Context
path=/idp
className=org.apache.catalina.core.StandardContext
cachingAllowed
try changing to the newest 3.0.8 driver of mysql.
-Original Message-
From: Luong Phan [mailto:[EMAIL PROTECTED]
Sent: Friday, August 22, 2003 10:31 AM
To: [EMAIL PROTECTED]
Subject: Suitable Driver Error
Hi all,
In my web application, I use mysql supported by Redhat Linux 7.3 to
store
: No suitable driver at java.sql.DriverManager.getConnection(DriverManager.java 532)
...
What is suitable driver for my application? Please give me some words of advice!
Thanks a lot.
LuongPhan
-
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo
: Friday, August 22, 2003 3:31 AM
To: [EMAIL PROTECTED]
Subject: Suitable Driver Error
Hi all,
In my web application, I use mysql supported by Redhat Linux 7.3 to store
database, jakarta-tomcat-3.2.4, mysql-connector-java-3.0.6-stable-bin.jar,
and JSP.
Every time, I run the program:
import
Yes.
Then there is something wrong with JDBC URL you're using to connect. That message is
actually from DriverManager/DataSource code.
Nix.
:[EMAIL PROTECTED]
Sent: 3. juni 2003 14:51
To: Tomcat Users List
Subject: Re: Database connection No suitable driver?
Yes.
Then there is something wrong with JDBC URL you're using to connect. That
message is actually from DriverManager/DataSource code.
Nix
connection No suitable driver?
I found an example on www.sybase.com, searching for tomcat the first hit
was an example about jconnect for JDBC not using taglib and I got it working
properly.
So now I will try to find out why taglib is not working properly.
- Terje
-Original Message-
From
And crossContext=true that I also had set to false.
- Terje
-Original Message-
From: Terje Hopsø [mailto:[EMAIL PROTECTED]
Sent: 3. juni 2003 22:22
To: 'Tomcat Users List'
Subject: RE: Database connection No suitable driver? SOLVED
It seems that the problem was in context
Hello,
I have to ask you once again. I have tried to get a connection to my
Sybaseserver. I get no suitable driver when trying to connect. Do anyone
have a suggestion on what is wrong. Sybase driver file jconn2.jar is placed
under $CATALINA/common/lib.
It is a long mail but I hope anyone
We also put jdbc2_0-stdext.jar in the common/lib directy.
-Original Message-
From: Terje Hopsø [mailto:[EMAIL PROTECTED]
Sent: Monday, June 02, 2003 2:54 PM
To: 'Tomcat Users List'
Subject: Database connection No suitable driver?
Hello,
I have to ask you once again. I have tried
It is there.
Tomcat version is 4.1.24.
- Terje
-Original Message-
From: John Moore [mailto:[EMAIL PROTECTED]
Sent: 3. juni 2003 00:05
To: 'Tomcat Users List'
Subject: RE: Database connection No suitable driver?
We also put jdbc2_0-stdext.jar in the common/lib directy
Hopsø [mailto:[EMAIL PROTECTED]
Sent: Monday, June 02, 2003 3:12 PM
To: 'Tomcat Users List'
Subject: RE: Database connection No suitable driver?
It is there.
Tomcat version is 4.1.24.
- Terje
-Original Message-
From: John Moore [mailto:[EMAIL PROTECTED]
Sent: 3. juni 2003 00:05
Your config looks fine. Have you placed Sybase's JDBC driver into
${CATALINA_HOME}/common/lib/?
Nix.
Yes.
- Terje
-Original Message-
From: Nikola Milutinovic [mailto:[EMAIL PROTECTED]
Sent: 3. juni 2003 07:24
To: Tomcat Users List
Subject: Re: Database connection No suitable driver?
Your config looks fine. Have you placed Sybase's JDBC driver into
${CATALINA_HOME}/common/lib/?
Nix
I tried this now but I still get the same error.
- Terje
-Original Message-
From: John Moore [mailto:[EMAIL PROTECTED]
Sent: 3. juni 2003 00:41
To: 'Tomcat Users List'
Subject: RE: Database connection No suitable driver?
One other idea, we have the Resource and ResourceParams
Hello, Tomcat fans,
I am using Tomcat 4.0.4 and can't get a DataSource working
with DB2.
My attempts result in No suitable driver, as detailed below.
I have tried everything I've seen suggested for
this problem, as the following steps indicate.
Any help would be much appreciated.
Thank you
, 2002 5:14 PM
Subject: RE: DB2 DataSource: No suitable driver
Try renaming the .zip file to .jar and try again. Others have suggested
this for the Oracle drivers.
Roger Whitcomb
Computer Associates
Senior Software Engineer
Development
Phone: +1 408 965 8653
FAX: +1 408 965 8805
[EMAIL PROTECTED
: Vance Christiaanse [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 2:01 PM
To: [EMAIL PROTECTED]
Subject: DB2 DataSource: No suitable driver
Hello, Tomcat fans,
I am using Tomcat 4.0.4 and can't get a DataSource working
with DB2.
My attempts result in No suitable driver
DataSourceWrapper(jdbcDriverClassName, jdbcURL, dbUserName,
dbUserPassword);
No problem while compiling. But there is run time error: No suitable
driver.
I print the stack error in the end of the message.
There should be no problem in the classpath setting. I tried to find the
driver
: No suitable driver
Hi, I am suing Oreilly books wrapper class for connection pool. It works
fine in the servlet class while I created a datasource using
ds = new DataSourceWrapper(jdbcDriverClassName, jdbcURL, dbUserName,
dbUserPassword);
But it doesn't work in the javabean class using the same code:
ds
have you tried:
Class.forName(org.gjt.mm.mysql.Driver).newInstance();
Si
-Original Message-
From: The Kelley's [mailto:[EMAIL PROTECTED]]
Sent: 17 July 2002 17:17
To: Tomcat Users List
Subject: RE: No suitable driver
I had a problem somewhat simular to that.
Make sure you have
Users List
Subject: No suitable driver
Hi, I am suing Oreilly books wrapper class for connection pool. It works
fine in the servlet class while I created a datasource using
ds = new DataSourceWrapper(jdbcDriverClassName, jdbcURL, dbUserName,
dbUserPassword);
But it doesn't work
That's what it sounds like. For some reason your bean class can't see the
driver.
Tim
-Original Message-
From: Meichun Li [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 17, 2002 12:20 PM
To: Tomcat Users List; [EMAIL PROTECTED]
Subject: RE: No suitable driver
On Wed, 17 Jul 2002
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
, 2002 7:00 AM
To: [EMAIL PROTECTED]
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
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 28, 2002 8:05 PM
To: Tomcat Users List
Subject: RE: tomcat 4.0.3 and No suitable driver SQLException
Some of the parameter names seem to have changed. I suggest grabbing a
recent nightly build of Tomcat 4.1 and following the instructions here:
http
{
conn = ds.getConnection();
catch { blah blah
That getConnection() part throws a SQLException
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(DriverManager.java:243)
at
tyrex.jdbc.xa.EnabledDataSource.getConnection
Chen
-Original Message-
From: Chen, Dean (Zhun)
Sent: Tuesday, May 28, 2002 1:00 PM
To: 'Tomcat Users List'
Subject: tomcat 4.0.3 and No suitable driver SQLException
Hi,
I know this has been covered before, and I've searched the archives, but
none of the solutions posted seemed to work
]]
Gesendet: Dienstag, 28. Mai 2002 19:00
An: 'Tomcat Users List'
Betreff: tomcat 4.0.3 and No suitable driver SQLException
ResourceParams name=jdbc/setsDataSource
parameternamedriverClassName/name
valuecom.sybase.jdbc2.jdbc.SybDriver/value
Sorry for the spam,and for my english but after 3 days I have not solution:
Classes12.jar is in common/lib
When I use a datasource for oracle driver, it doesn't works-- No
suitable Driver . But if I use a classical connection like this:
String url=jdbc:oracle:thin:@**.**.**.***:1521:db8ir3
:
javax.servlet.ServletException: No suitable driver
The CODES :
%@ page language=java import=java.sql.* %
%
ResultSet myResultSet=null;
Class.forName(org.gjt.mm.mysql.Driver);
Connection
myConn=DriverManager.getConnection(jdbc:mysql:3306://localhost/bukujsp?user
=rootpassword=ganteng);
Statement stmt
Hi Isak,
the DriverManager has a method called availableDriver or so. Use this to
show, if your driver is registered.
If yes, your driver could be registered, but can not do his work with the
database. This is no problem of Tomcat.
If no, the driver.jar was not found by tomcat. Then try
getConnection(jdbc:mysql:3306://localhost/bukujsp?snip
Surely you mean:
getConnection(jdbc:mysql//localhost:3306/bukujsp?snip
They may be identical. Anyone?
J.
--
You're only jealous cos the little penguins are talking to me.
When I use a datasource I obtain this error.
But when i use same option directly in my servelt all is OK.
Have you seen this errors ???
regards
Remy
Java.sql.SQLException: No suitable driver at
java.sql.DriverManager.getDriver(DriverManager.java:249
]]
Sent: Tuesday, February 19, 2002 7:51 AM
To: Tomcat Users List
Subject: No suitable driver Datasource Problem
When I use a datasource I obtain this error.
But when i use same option directly in my servelt all is OK.
Have you seen this errors ???
regards
Remy
Java.sql.SQLException
: remy.menetrieux [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2002 7:51 AM
To: Tomcat Users List
Subject: No suitable driver Datasource Problem
When I use a datasource I obtain this error.
But when i use same option directly in my servelt all is OK.
Have you seen this errors ???
regards
/lib/mm.mysql-2.0.4-src.jar
This is the log that I have:
javax.servlet.ServletException: No suitable driver
at
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp
l.java:459)
at
jsp._0002fjsp_0002ftest_0002ejsptest_jsp_7._jspService(_0002fjsp_0002ftest_0
fine
I am trying to use MM.MySQL for JDBC connectivity to MySQL.
my CLASSPATH is /usr/local/src/jdk1.2.2/lib/mm.mysql-2.0.4-src.jar
This is the log that I have:
javax.servlet.ServletException: No suitable driver
at
org.apache.jasper.runtime.PageContextImpl.handlePageException
1 - 100 of 127 matches
Mail list logo
