Hi Rainer:
I had already added the JDBC driver to my Netbeans project class path and that
worked for awhile then stopped. The previous problem is that it works
occasionally then stopped. Now it works and inserts one row then stops even if
restart Tomcat.
I will have to do some reading on launching Tomcat manually by shell/batch
scripts but I don't have much time as I have a deadline to meet which is my
major concern.
I don't really know much about Tomcat so do you have any suggestions on:
* should i start the web application from netbeans or from Tomcat?
* how would i test the web application from Tomcat alone?
* do you know how to prevent netbeans from launching Tomcat?
* which locations do I need to have the jar file in?
Sorry for asking so many questions but as I mentioned I don't really know much
about Tomcat and this is my first time using netbeans to create a web
application usually I do windows/desktop apps in Eclipse.
Cheers,
A Df
>________________________________
>From: Rainer Frey <rainer.f...@inxmail.de>
>To: Tomcat Users List <users@tomcat.apache.org>
>Sent: Tuesday, 26 July 2011, 7:04
>Subject: Re: Tomcat 6 not working with JDBC driver for MySQL
>
>
>On 25.07.2011, at 22:40, A Df wrote:
>
>> Dear All:
>>
>> I have read numerous posts and documentation and now I really need help.
>>
>>
>> I am using the following:
>>
>> Product Version: NetBeans IDE 7.0 (Build 201104080000)
>>
>> I performed the steps below as follows:
>>
>> I have added the MySQL Connector/J JDBC Driver to the $CATALINA_HOME/lib
>> directory
>> However, it gives the error:
>> org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver
>> OR
>> java.sql.SQLException: No suitable driver
>
>Are you launching Tomcat from within Netbeans? Then I'd suspect that Netbeans
>sets it
>up with its own configuration, and esp. with a project specific class path.
>Most instructions
>out there imply that you launch Tomcat with the supplied scripts or service
>utilities, and not with
>an IDE plugin.
>
>Try
>* launching Tomcat manually, by shell/batch scripts OR
>* add the JDBC driver also to your Netbeans project class path
>
>Rainer
>---------------------------------------------------------------------
>To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
>For additional commands, e-mail: users-h...@tomcat.apache.org
>
>
>
>
