Re: mySQL connector error

2013-11-18 Thread Christopher Schultz
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 file and try to modify the properties of the search

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 connector

Re: mySQL connector error

2013-11-17 Thread ישראל מלאכי
. 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.jdbc.Driver). So I have try to create a symlink in Tomcats lib dir

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
=javax.sql.DataSource url=jdbc:mysql://localhost:3306/schema username=user testOnBorrow=true validationQuery=SELECT 1/ 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

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: Resource driverClassName=com.mysql.jdbc.Driver logAbandoned=false maxActive=35 maxIdle=2

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

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

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 copy

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

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 there

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 apache

Re: MySql Connector

2007-07-27 Thread Mohammed Zabin
Ok guys, here we are. I have define the new resource inside a Context tag inside a Host tag, as suggested by Tomcat documentation. I removed it and put it inside GlobalNamingResources tag like the following: 1. Configure naming Resource: inside GlobalNamingResources i put the following:

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

Re: MySql Connector

2007-07-26 Thread Pid
ClassNotFoundException? ObviousStatement Your JSP can't find one of the classes you refer to in the scriptlet. /ObviousStatement 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

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

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 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 =

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

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

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 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-25 Thread Mohammed Zabin
. 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: Resource name=jdbc/TestMySql auth=Container type

Re: MySql Connector

2007-07-25 Thread David Smith
, 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 and place

Re: MySql Connector

2007-07-25 Thread Mohammed Zabin
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

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

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

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

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 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-24 Thread Mohammed Zabin
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: Resource name=jdbc/TestMySql auth=Container type=javax.sql.DataSource

Re: MySql Connector

2007-07-24 Thread David Smith
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 CATALINA_HOME/lib directory, and i put the following: 1

Re: MySql Connector

2007-07-24 Thread Mohammed Zabin
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 downloaded MySql

Re: MySql Connector

2007-07-24 Thread David Smith
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: Resource name=jdbc/TestMySql auth=Container type=javax.sql.DataSource maxActive=100 maxIdle=30

Re: MySql Connector

2007-07-24 Thread Mohammed Zabin
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 CATALINA_HOME/lib

Re: MySql Connector

2007-07-23 Thread Pid
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 CATALINA_HOME/lib directory, and i put the following

Re: MySql Connector

2007-07-23 Thread David Smith
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: Resource name=jdbc/TestMySql auth=Container type=javax.sql.DataSource maxActive=100 maxIdle=30

Re: MySql Connector returning ?DataSource

2007-07-23 Thread Wade Chandler
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(/dbtest) and all the information for the datasource looks fine

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 and

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

Re: MySql Connector returning ?DataSource

2007-07-23 Thread Prem Padarath
- 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(/dbtest) and all the information for the datasource looks fine (as from the context.xml file

Re: MySql Connector returning ?DataSource

2007-07-23 Thread David Smith
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 Connector thread of messages. I can see the resource listed

Re: MySql Connector returning ?DataSource

2007-07-23 Thread Prem Padarath
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 Connector thread of messages. I can see the resource

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 interesting problems

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 also in the webapp's WEB-INF/lib directory

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 directory! Is it also

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 downloaded MySql

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 and place

Re: MySql Connector

2007-07-22 Thread Mohammed Zabin
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 CATALINA_HOME/lib directory, and i put the following

Re: MySql Connector

2007-07-22 Thread Pid
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: Resource name=jdbc/TestMySql auth=Container type=javax.sql.DataSource

Re: MySql Connector

2007-07-22 Thread Mohammed Zabin
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 CATALINA_HOME/lib directory