--------------------------------------------------
From: "Martin Gainty" <mgai...@hotmail.com>
Sent: Monday, June 21, 2010 1:16 PM
To: "Tomcat Users List" <users@tomcat.apache.org>
Subject: RE: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
JDBC driver of class '' for connect URL 'null' AGAIN!
if you took time to look at tomcat-users archive you would've come across
this post by david smith..the answer is just as good now as when
originally posted
On 6/19/2010 1:31 PM, yucca...@live.co.za wrote:
I have no choice left but to not let hibernate use my tomcat datasource.
This is not good. I have even moved host provider in hope that it was
previous fult tomcat install from dailyrazor (tomcat 6 does not hav
common/lib) and is meant to have tomcat/lib
I can say that my new container is correct and that I am 100% sure that
all mus jdbc configuration is correct in zml after having gone though it
at least 20 times and checked the wiki that was linked here earlier and
still have issues. Yes mysql jdbc bin is in tomcat/lib so that is not
cause of the error. /the error is very weird though as I have another
point that uses hibernate without error on the same database. It is not
possible for me to use hibernate to use tomcat datasource sadly. Many
thanks for all the help though.
<DS>
If you put the following into a jsp and call the jsp, does it work?
<%...@page import="java.sql.Connection"%>
<%...@page import="java.sql.DriverManager"%>
<%...@page import="java.sql.SQLException"%>
<%
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection("jdbc:mysql://localhost/test?" +
"user=monty&password=greatsqldb");
out.println( "The connection worked!!" ) ;
Did this and it works , I even made this page my welcome page at
thejarbar.org
%>
If that works then your jdbc driver is available and installed properly
(I trust there is only one copy of that jar in your entire tomcat
install ... right?).
I do not see or find another copy of the driver
Now check to see if there's an xml in tomcat/conf/Catalina/localhost
there isn't one
matching your webapp's deployed name. For instance if you access your
webapp as http://localhost:8088/mywebapp, there should be a mywebapp.xml
file there. Take a look at it for the <Resource ... /> or <ResourceLink
... /> (which ever you setup) and make sure they are correct. If this
file is not available, take a look at context.xml in your webapp's
META-INF folder (same process). If it's not there, then the <Context
... > element for your webapp is in server.xml and it should NOT be
there. It's bad practice and requires a full tomcat restart to make
I did not do this
changes.
Did this and it works , I even made this page my welcome page at
thejarbar.org
Lastly, case matters. Be sure everything is typed correctly including
whether it's upper or lower case.
Now take a look at the logs and post any relevant messages including
complete stacktraces of exceptions w/o edits except to protect usernames
and passwords.
I have checked this several times and see no syntax errors, further, if
there were url syntax errors (because they can only be url errors due to it
not being an accessdenied exception from mysql, it ould show on my test
environment as I use same database names and table names. In fact I would
say that because I am able to do that test page with success it proves my
driver is in place and can be found .
I do not see the mistake that you see
--David
</DS>
Martin Gainty
______________________________________________
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene
Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte
Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht
dient lediglich dem Austausch von Informationen und entfaltet keine
rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von
E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le
destinataire prévu, nous te demandons avec bonté que pour satisfaire
informez l'expéditeur. N'importe quelle diffusion non autorisée ou la
copie de ceci est interdite. Ce message sert à l'information seulement et
n'aura pas n'importe quel effet légalement obligatoire. Étant donné que
les email peuvent facilement être sujets à la manipulation, nous ne
pouvons accepter aucune responsabilité pour le contenu fourni.
From: yucca...@live.co.za
To: users@tomcat.apache.org
Subject: Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
create JDBC driver of class '' for connect URL 'null' AGAIN!
Date: Mon, 21 Jun 2010 10:49:41 +0200
Ok I thought I found my solution yesterday with eapps but turns out not
to
be. I am posting a possible fix in hope that this may help someone els
who
reads this thread one day.
apart from making sure that paths are correct, driver is inside
tomcat/lib
and that resource etc are defined correct, I hadnot ensured that tomcat
had
RW permission for the driver inside tomcat/lib upon doing so I was stuck
with same issue but hope this may solve someone elses issue.
--------------------------------------------------
From: "Mark Thomas" <ma...@apache.org>
Sent: Monday, June 21, 2010 8:57 AM
To: "Tomcat Users List" <users@tomcat.apache.org>
Subject: Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
create
JDBC driver of class '' for connect URL 'null' AGAIN!
> On 20/06/2010 21:49, akhlaqur Rahman wrote:
>> How do I unsubscribe from this list? I have tried following the
>> unsubscribe
>> link in the emails and it has not worked... Any tips would be
>> appreciated.
>
> Ask one of the list owners for help.
>
> I'll unsubscribe you in a sec.
>
> Mark
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
> For additional commands, e-mail: users-h...@tomcat.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
_________________________________________________________________
Hotmail is redefining busy with tools for the New Busy. Get more from your
inbox.
http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_2
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
