Re: mySQL connector error

2013-11-18 Thread Christopher Schultz
-get and also I have installed the > libmysql-java package. On starting Tomcat it reports on a > stacktrace log, that the mySQL connector is not found > (java.lang.ClassNotFoundException: "com.mysql.jdbc.Driver"). So I > have try to create a symlink in Tomcats lib dir to the jar

Re: mySQL connector error

2013-11-17 Thread ישראל מלאכי
my Tomcat 7 on Ubuntu 12.04 with OpenJDK. > I have installed Tomcat with apt-get and also I have installed the > libmysql-java package. On starting Tomcat it reports on > a stacktrace log, that the mySQL connector is not found > (java.lang.ClassNotFoundException: "com.mysql.jdb

mySQL connector error

2013-11-17 Thread Philipp Kraus
Hello, I'm new with Tomcat, so I hope for some help. I try to run www.icescrum.org on my Tomcat 7 on Ubuntu 12.04 with OpenJDK. I have installed Tomcat with apt-get and also I have installed the libmysql-java package. On starting Tomcat it reports on a stacktrace log, that the mySQL conn

Re: Problems with connections pool in Tomcat 6.0.18 6.0.20 + MySQL 5.1 + mysql-connector 5.1.x

2011-01-27 Thread Filip Hanik - Dev Lists
Add in validationQuery and testOnBorrow as seen below On 01/27/2011 12:46 AM, Ramon Garcia Alarcon wrote: Hi all, I have a problem with: Tomcat 6.0.x + MySQL 5.1 + mysql-connector.5.1.x And I test with Ubuntu 10.04, Windows 2003 and Mac OSX 10.6.6 I configured the connection in tomcat

Problems with connections pool in Tomcat 6.0.18 6.0.20 + MySQL 5.1 + mysql-connector 5.1.x

2011-01-26 Thread Ramon Garcia Alarcon
Hi all, I have a problem with: Tomcat 6.0.x + MySQL 5.1 + mysql-connector.5.1.x And I test with Ubuntu 10.04, Windows 2003 and Mac OSX 10.6.6 I configured the connection in tomcat like this: In MySql I have good configured the wait_timeout and the interactive_timeout in 28800. The problem is

Re: Deploying mysql-connector-java-5.1.7-bin.jar in /WEB-INF/lib

2008-12-01 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Iñigo, Iñigo Mediavilla Saiz wrote: > org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC > driver class 'org.gjt.mm.mysql.Driver' Others have answered your original question. Note that Connector/J has used the com.mysql.jdbc.Driver cla

Re: Deploying mysql-connector-java-5.1.7-bin.jar in /WEB-INF/lib

2008-11-23 Thread Mark Thomas
Michael Ludwig wrote: > Mark Thomas schrieb am 23.11.2008 um 11:25:43 (+): >> Iñigo Mediavilla Saiz wrote: >>> [Tomcat 6] When I try to access to a Database through the connector >>> it fails if I leave it inside WEB-INF\lib, but everything works if I >>> copy the jar in the lib folder of the a

Re: Deploying mysql-connector-java-5.1.7-bin.jar in /WEB-INF/lib

2008-11-23 Thread Michael Ludwig
Mark Thomas schrieb am 23.11.2008 um 11:25:43 (+): > Iñigo Mediavilla Saiz wrote: > > [Tomcat 6] When I try to access to a Database through the connector > > it fails if I leave it inside WEB-INF\lib, but everything works if I > > copy the jar in the lib folder of the apache distribution. Is th

Re: Deploying mysql-connector-java-5.1.7-bin.jar in /WEB-INF/lib

2008-11-23 Thread Michael Ludwig
Iñigo Mediavilla Saiz schrieb am 23.11.2008 um 11:08:52 (+): > When I try to access to a Database through the connector it fails if I > leave it inside WEB-INF\lib, but everything works if I copy the jar in > the lib folder of the apache distribution. Putting the driver in WEB-INF/lib only all

Re: Deploying mysql-connector-java-5.1.7-bin.jar in /WEB-INF/lib

2008-11-23 Thread Mark Thomas
Iñigo Mediavilla Saiz wrote: > When > I try to access to a Database through the connector it fails if I leave > it inside WEB-INF\lib, but everything works if I copy the jar in the > lib folder of the apache distribution. Is there any other way to let a > web app access to a lib without having to c

Deploying mysql-connector-java-5.1.7-bin.jar in /WEB-INF/lib

2008-11-23 Thread Iñigo Mediavilla Saiz
When I try to access to a Database through the connector it fails if I leave it inside WEB-INF\lib, but everything works if I copy the jar in the lib folder of the apache distribution. Is there any other way to let a web app access to a lib without having to copy the jar in apache\lib? I'm using ap

Re: MySql Connector

2007-07-26 Thread Mohammed Zabin
Ok guys, here we are. I have define the new resource inside a tag inside a tag, as suggested by Tomcat documentation. I removed it and put it inside tag like the following: 1. Configure naming Resource: inside i put the following: 2. Inside web.xml: Oracle Datasource example

Re: MySql Connector

2007-07-26 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mohammed, Mohammed Zabin wrote: > If you looked at the exception you will find ClassNotFoundException at line > 66 in the generated servlet, and this occurs withing the try block, so, i > think it's a problem of Connector. You are seriously confused,

Re: MySql Connector

2007-07-26 Thread David Smith
directory? I would have thought you'd want it in the common/lib dir. -Original Message- From: Mohammed Zabin [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 25, 2007 12:52 AM To: Tomcat Users List Subject: Re: MySql Connector In cotrast, i have installed Oracle and worked very well

RE: MySql Connector

2007-07-26 Thread Propes, Barry L
did you also have the Oracle jar file in that lib directory? I would have thought you'd want it in the common/lib dir. -Original Message- From: Mohammed Zabin [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 25, 2007 12:52 AM To: Tomcat Users List Subject: Re: MySql Connector

Re: MySql Connector

2007-07-26 Thread Pid
David's right, ignore my previous. p David Smith wrote: No... the exception you posted is it couldn't find the mysql_jsp.class file generated by compiling the jsp file. Do you have another stack trace somewhere you haven't shown us? Quoting from the stack trace posted below: *root cause

Re: MySql Connector

2007-07-26 Thread David Smith
No... the exception you posted is it couldn't find the mysql_jsp.class file generated by compiling the jsp file. Do you have another stack trace somewhere you haven't shown us? Quoting from the stack trace posted below: *root cause* java.lang.ClassNotFoundException: org.apache.jsp.mySql_jsp

Re: MySql Connector

2007-07-26 Thread David Smith
Ok... I did ask for the *complete* jsp file. Please repost. --David Mohammed Zabin wrote: It's already wrapped man, i just copied the code snippet from within <%%> marker ;), and for System.out, or out.println, It's still the same problem. If you looked at the exception you will find ClassNot

Re: MySql Connector

2007-07-26 Thread Pid
ClassNotFoundException? Your JSP can't find one of the classes you refer to in the scriptlet. We can't tell which one, because we don't know what's at line 266 in the generated java file (you could look). Which of the classes you're using in the JSP haven't been imported at the top of the

Re: MySql Connector

2007-07-26 Thread David Smith
Oh and just one more thing -- use com.mysql.jdbc.Driver as org.gjt.mm.mysql.Driver is ancient. --David David Smith wrote: 1. This can't be the complete jsp code. If it is, you need to minimally wrap it in <%%> markers to indicate it's raw java code, not jsp/html. Additionally your S

Re: MySql Connector

2007-07-26 Thread Mohammed Zabin
It's already wrapped man, i just copied the code snippet from within <%%> marker ;), and for System.out, or out.println, It's still the same problem. If you looked at the exception you will find ClassNotFoundException at line 66 in the generated servlet, and this occurs withing the try block, so, i

Re: MySql Connector

2007-07-26 Thread David Smith
1. This can't be the complete jsp code. If it is, you need to minimally wrap it in <%%> markers to indicate it's raw java code, not jsp/html. Additionally your System.out.println() call would end up going to the JVM's standard output instead of the browser. 2. The listed exception is rea

Re: MySql Connector

2007-07-26 Thread Mohammed Zabin
This is my jsp code: try { Class.forName("org.gjt.mm.mysql.Driver"); String url = "jdbc:mysql://localhost:3306/exam"; Connection con = DriverManager.getConnection(url,"root", "exam"); Statement stmt = con.createStatement(); ResultSet rs = stmt.

Re: MySql Connector

2007-07-25 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mohammed, Mohammed Zabin wrote: > I did this, but i think that there is an option to enable logging, do u > know it? Logs should go to catalina.out, or to the console if you're using windows and startup.bat instead of a service. - -chris -BEGIN

Re: MySql Connector

2007-07-25 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mohammed, Mohammed Zabin wrote: > I have the following error: > > org.apache.jasper.JasperException: Unable to compile class for JSP: Uhh... you have a syntax error in your JSP code. Fix that, then we'll get back to configuration issues. You didn't

Re: MySql Connector

2007-07-25 Thread David Smith
Not sure ... you could take a look at http://tomcat.apache.org/tomcat-5.5-doc/logging.html. Tomcat's always provided a complete stack and cited the code in error for me without any changes in logging config. You could also post the complete jsp you are using for a test. See if the error sta

Re: MySql Connector

2007-07-25 Thread Mohammed Zabin
I did this, but i think that there is an option to enable logging, do u know it? On 7/25/07, David Smith <[EMAIL PROTECTED]> wrote: I'm starting to think there's something really funny (ie broken) with your tomcat install. Could you clean install another instance of tomcat (preferably download

Re: MySql Connector

2007-07-25 Thread David Smith
I'm starting to think there's something really funny (ie broken) with your tomcat install. Could you clean install another instance of tomcat (preferably downloaded from the tomcat website) and check the code there? --David Mohammed Zabin wrote: This is all the exception message, I looked ins

Re: MySql Connector

2007-07-25 Thread Mohammed Zabin
; >> > >> >> 1. Either place your Resource definition in server.xml as a >> > >> >> GlobalResource *OR* in your webapp's context.xml file. >> > >> >> >> > >> >> 2. If you have the Resource defined in the Globa

Re: MySql Connector

2007-07-25 Thread David Smith
but not in a pooled environment. > >> >> > >> >> 4. You should probably be attempting to use the path > >> >> java:comp/env/jdbc/TestMySQL (note the lack of a '/' before comp) > as > >> >> described in the JNDI howto on to

Re: MySql Connector

2007-07-25 Thread Mohammed Zabin
; before comp) > as > >> >> described in the JNDI howto on tomcat's website. I think I saw > you > >> >> using java:/comp/env/jdbc/TestMySQL in one of your posts. > >> >> > >> >> 5. Please post

Re: MySql Connector

2007-07-24 Thread Mohammed Zabin
>> >> Mohammed Zabin wrote: >> >> >> >> > Would you please be more specific? which file you mean? I have >> created >> >> > Oracel connection Pool as the stated way above, and it's worked >> fine, >> >&

Re: MySql Connector

2007-07-24 Thread David Smith
ote: >> > >> >> >> >> You only need one resource definition. >> >> You only need a resource link definition if your resource is a global >> >> one. >> >> >> >> Simplify your configuration and then post the error mes

Re: MySql Connector

2007-07-24 Thread Mohammed Zabin
ou only need one resource definition. >> >> You only need a resource link definition if your resource is a global >> >> one. >> >> >> >> Simplify your configuration and then post the error message from the >> >> logs so we can see Tomcat s

Re: MySql Connector

2007-07-24 Thread David Smith
says is wrong. >> >> p >> >> >> Mohammed Zabin wrote: >> > Hi All >> > >> > I have confiured oracle connection pool on my tomacat 6, and it worked >> > fine. >> > When i came to configure MySql, I repeated the same

Re: MySql Connector

2007-07-24 Thread Mohammed Zabin
connection pool on my tomacat 6, and it worked >> > fine. >> > When i came to configure MySql, I repeated the same steps for Oracle >> > databse, with considering the specfication of MySql database. But it's >> > didn't work. Any Help please about config

Re: MySql Connector returning ?DataSource

2007-07-23 Thread Prem Padarath
Chuck, Checked...it is only in the one place. Thx, Prem On 7/23/07, Caldarale, Charles R <[EMAIL PROTECTED]> wrote: > From: Prem Padarath [mailto:[EMAIL PROTECTED] > Subject: Re: MySql Connector returning ?DataSource > > I checked. The mysql jar file is in common\lib dire

Re: MySql Connector returning ?DataSource

2007-07-23 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Chuck, Caldarale, Charles R wrote: >> From: Prem Padarath [mailto:[EMAIL PROTECTED] >> Subject: Re: MySql Connector returning ?DataSource >> >> I checked. The mysql jar file is in common\lib directory! > > Is it al

RE: MySql Connector returning ?DataSource

2007-07-23 Thread Caldarale, Charles R
> From: Prem Padarath [mailto:[EMAIL PROTECTED] > Subject: Re: MySql Connector returning ?DataSource > > I checked. The mysql jar file is in common\lib directory! Is it also in the webapp's WEB-INF/lib directory? Having it in two places at once can cause all sorts of int

Re: MySql Connector returning ?DataSource

2007-07-23 Thread Prem Padarath
problem getting a DataSource object back from a JNDI >> > lookup. >> > (I am getting a >> > "org.apache.tomcat.dbcp.dbcp.BasicDataSource" object >> > returned and throwing an exception - code below) >> > >> > My problem is simila

Re: MySql Connector returning ?DataSource

2007-07-23 Thread David Smith
> 5.5.20 . I am having a > problem getting a DataSource object back from a JNDI > lookup. > (I am getting a > "org.apache.tomcat.dbcp.dbcp.BasicDataSource" object > returned and throwing an exception - code below) > > My problem is similar to the "Re: MySql Conne

Re: MySql Connector returning ?DataSource

2007-07-23 Thread Prem Padarath
object > returned and throwing an exception - code below) > > My problem is similar to the "Re: MySql Connector" > thread of messages. > > I can see the resource listed in the Tomcat > Administration Tool under Tomcat > Server --> Service --> Host --> Context

Re: MySql Connector returning ?DataSource

2007-07-23 Thread Prem Padarath
Hi Chris, o.a.t.d.d.BasicDataSource implements javax.sql.DataSource. What's the problem? The problem is that whatever is returned from the lookup call is causing an exception. I tested what is coming back and it is an o.a.t.d.d.B.D.S and it is putting it to a DataSource. The stack trace foll

Re: MySql Connector returning ?DataSource

2007-07-23 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Prem, Prem Padarath wrote: > I am trying to set up a database resource in Tomcat 5.5.20 . I am having a > problem getting a DataSource object back from a JNDI lookup. > (I am getting a "org.apache.tomcat.dbcp.dbcp.BasicDataSource" object > returned a

Re: MySql Connector returning ?DataSource

2007-07-23 Thread Wade Chandler
cDataSource" object > returned and throwing an exception - code below) > > My problem is similar to the "Re: MySql Connector" > thread of messages. > > I can see the resource listed in the Tomcat > Administration Tool under Tomcat > Server --> Service -->

MySql Connector returning ?DataSource

2007-07-23 Thread Prem Padarath
to the "Re: MySql Connector" thread of messages. I can see the resource listed in the Tomcat Administration Tool under Tomcat Server --> Service --> Host --> Context(/dbtest) and all the information for the datasource looks fine (as from the context.xml file below). My context.

Re: MySql Connector

2007-07-23 Thread David Smith
onsidering the specfication of MySql database. But it's > didn't work. Any Help please about configuring MySql, > I downloaded MySql connector from mysql website and place it in > CATALINA_HOME/lib directory, and i put the following: > > 1. in server.xml file: >

Re: MySql Connector

2007-07-23 Thread Pid
wrong. >> >> p >> >> >> Mohammed Zabin wrote: >> > Hi All >> > >> > I have confiured oracle connection pool on my tomacat 6, and it worked >> > fine. >> > When i came to configure MySql, I repeated the same steps for Oracle &

Re: MySql Connector

2007-07-22 Thread Mohammed Zabin
ogs so we can see Tomcat says is wrong. >> >> p >> >> >> Mohammed Zabin wrote: >> > Hi All >> > >> > I have confiured oracle connection pool on my tomacat 6, and it worked >> > fine. >> > When i came to configure MySql, I repeated

Re: MySql Connector

2007-07-22 Thread Pid
abse, with considering the specfication of MySql database. But it's > didn't work. Any Help please about configuring MySql, > I downloaded MySql connector from mysql website and place it in > CATALINA_HOME/lib directory, and i put the following: > > 1. in server.xml file: &

Re: MySql Connector

2007-07-22 Thread Mohammed Zabin
ked > fine. > When i came to configure MySql, I repeated the same steps for Oracle > databse, with considering the specfication of MySql database. But it's > didn't work. Any Help please about configuring MySql, > I downloaded MySql connector from mysql website and place it in

Re: MySql Connector

2007-07-22 Thread Pid
pool on my tomacat 6, and it worked fine. When i came to configure MySql, I repeated the same steps for Oracle databse, with considering the specfication of MySql database. But it's didn't work. Any Help please about configuring MySql, I downloaded MySql connector from mysql website an

MySql Connector

2007-07-22 Thread Mohammed Zabin
Hi All I have confiured oracle connection pool on my tomacat 6, and it worked fine. When i came to configure MySql, I repeated the same steps for Oracle databse, with considering the specfication of MySql database. But it's didn't work. Any Help please about configuring MySql, I downlo