Re: tomcat windows / mysql linux

2005-06-09 Thread daniel steel
hi paul, yes, it has been configured the same way. all the machines are connected in a giga network. yes, its the log in that takes the most time and every time we log. our production server is older version of tomcat. when we tried to run production server on jdk 1.5.03, we have the same

tomcat windows / mysql linux

2005-06-08 Thread daniel steel
hi all, i have an interesting problem. our app server(tomcat 5.5) on windows 2003 communicates with mySQl database on linux box. our client application is very slow each time we log in. when we moved the database to windows box, the application is super fast. does anybody have thoughts on

RE: tomcat windows / mysql linux

2005-06-08 Thread Robert Harper
engineers get paid so well. Robert S. Harper Information Access Technology, Inc. -Original Message- From: daniel steel [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 08, 2005 10:36 AM To: tomcat-user@jakarta.apache.org Subject: tomcat windows / mysql linux hi all, i have

Re: tomcat windows / mysql linux

2005-06-08 Thread Paul
daniel steel wrote: hi all, i have an interesting problem. our app server(tomcat 5.5) on windows 2003 communicates with mySQl database on linux box. our client application is very slow each time we log in. when we moved the database to windows box, the application is super fast. does anybody

Re: tomcat+j2sdk+mysql-connecto+mysql

2003-09-03 Thread Sathyan
Hello Chris Williams, Thanks for your guides. Now its working well. Regards Sathi Try to isolate the problem. Check that you can get a Connection object by doing something like the following: String driver = ...; String url = ...; String userName = ...; String pw = ...; Connection

tomcat+j2sdk+mysql-connecto+mysql

2003-09-02 Thread Sathyan
in /usr/java/j2sdk1.4.2_01 i have installed tomcat, mysql connector and ipstat in /usr/local/src and copied com and org of mysql connector in the /usr/local/src/tomcat/shred/lib. I was to able to browse the example page but not the ipstat page. Is there any version porblem ...and how to oevrcome

Re: tomcat+j2sdk+mysql-connecto+mysql

2003-09-02 Thread Marco Tedone
Subject: tomcat+j2sdk+mysql-connecto+mysql Hello All, I am new to tomcat and java. I want to install ipstat-0.9.7 tool which is used for bandwidyh monitoring. I started intalling its requirements ...tomcat-4.1.27, j2sdk-1.4.2, mysql-connector-java-2.0.14, mysql-3.23.54 in Redhat-9 I

Re: tomcat+j2sdk+mysql-connecto+mysql

2003-09-02 Thread Sathyan
: tomcat+j2sdk+mysql-connecto+mysql Hello All, I am new to tomcat and java. I want to install ipstat-0.9.7 tool which is used for bandwidyh monitoring. I started intalling its requirements ...tomcat-4.1.27, j2sdk-1.4.2, mysql-connector-java-2.0.14, mysql-3.23.54 in Redhat-9 I

Re: tomcat+j2sdk+mysql-connecto+mysql

2003-09-02 Thread Christopher Williams
Try to isolate the problem. Check that you can get a Connection object by doing something like the following: String driver = ...; String url = ...; String userName = ...; String pw = ...; Connection conn = null; try { Class.forName(driver); conn = DriverManager.getConnection(url,

Re: HELP!! TOMCAT and MYSQL

2003-08-04 Thread Mauricio Nuñez
. Dialynas [EMAIL PROTECTED] To: engp0510 [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, August 03, 2003 6:07 PM Subject: Re: HELP!! TOMCAT and MYSQL Try: connectionURL=jdbc:mysql://localhost/authority?user=leesonpassword= At 04:32 ìì 03/08/03 +0800, engp0510 wrote

HELP!! TOMCAT and MYSQL

2003-08-03 Thread engp0510
Hi, I am using Tomcat 4.0 and MySQL 4.0.14 on WIn2K Professional. In Server.XML of Tomcat, I use: Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=org.gjt.mm.mysql.Driver connectionURL=jdbc:mysql://localhost/authority?user=leeson;password=

Re: HELP!! TOMCAT and MYSQL

2003-08-03 Thread engp0510
: Sunday, August 03, 2003 6:07 PM Subject: Re: HELP!! TOMCAT and MYSQL Try: connectionURL=jdbc:mysql://localhost/authority?user=leesonpassword= At 04:32 ìì 03/08/03 +0800, engp0510 wrote: Hi, I am using Tomcat 4.0 and MySQL 4.0.14 on WIn2K Professional. In Server.XML of Tomcat, I use

RE: HELP!! TOMCAT and MYSQL

2003-08-03 Thread Stuart MacPherson
Split the user and pass off of the URL, and into separate properties... stu -Original Message- From: engp0510 [mailto:[EMAIL PROTECTED] Sent: 03 August 2003 11:40 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; Emmanuel G. Dialynas Subject: Re: HELP!! TOMCAT and MYSQL Thanks very much! Y, I

Re: HELP!! TOMCAT and MYSQL

2003-08-03 Thread engp0510
PROTECTED]; [EMAIL PROTECTED]; 'Emmanuel G. Dialynas' [EMAIL PROTECTED] Sent: Sunday, August 03, 2003 7:12 PM Subject: RE: HELP!! TOMCAT and MYSQL Split the user and pass off of the URL, and into separate properties... stu -Original Message- From: engp0510 [mailto:[EMAIL PROTECTED] Sent: 03

RE: HELP!! TOMCAT and MYSQL

2003-08-03 Thread Zille Hassan
PROTECTED]; 'Emmanuel G. Dialynas' Subject: RE: HELP!! TOMCAT and MYSQL Split the user and pass off of the URL, and into separate properties... stu -Original Message- From: engp0510 [mailto:[EMAIL PROTECTED] Sent: 03 August 2003 11:40 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; Emmanuel G

Re: HELP!! TOMCAT and MYSQL

2003-08-03 Thread Emmanuel G. Dialynas
Try: connectionURL=jdbc:mysql://localhost/authority?user=leesonpassword= At 04:32 ìì 03/08/03 +0800, engp0510 wrote: Hi, I am using Tomcat 4.0 and MySQL 4.0.14 on WIn2K Professional. In Server.XML of Tomcat, I use: Realm className=org.apache.catalina.realm.JDBCRealm debug=99

Re: HELP!! TOMCAT and MYSQL

2003-08-03 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 engp0510 wrote: Thanks very much! Y, I have tried. But always throw org.xml.sax.SAXParseException said a ; is needed to end the quote of password. Any advice? Tomcat's config file is in XML. The 'XML way' to produce an ampersand () is to use the

Tomcat and MySQL

2003-07-31 Thread engp0510
Hi, I am using Tomcat 4.0 and MySQL 4.0.14 on WIn2K Professional. In Server.XML of Tomcat, I use: Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=org.gjt.mm.mysql.Driver connectionURL=jdbc:mysql://localhost/authority?user=leeson;password=

Re: Tomcat and MySQL

2003-07-31 Thread John Turner
Should be ?user=leesonpassword= Also you need to make sure that user leeson has access privileges to MySQL from localhost. http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#User_Account_Management John engp0510 wrote: Hi, I am using Tomcat 4.0

RE: Tomcat and MySQL

2003-07-31 Thread Scott Stewart
: Tomcat and MySQL Hi, I am using Tomcat 4.0 and MySQL 4.0.14 on WIn2K Professional. In Server.XML of Tomcat, I use: Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=org.gjt.mm.mysql.Driver connectionURL=jdbc:mysql://localhost/authority?user=leeson;password

Tomcat ( JSP)+ MySql .. driver ?

2003-02-07 Thread wabbadi
hi guys , can anyone help me plz ! .. how can i make my jsp files working on Tomcat work with MySql database .. i download the java-module offered from MySql site .. but i dont know where / how to work with it ! thanks in advance , Walid

RE: Tomcat ( JSP)+ MySql .. driver ?

2003-02-07 Thread Tam, Michael
this get you started. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 2:08 PM To: [EMAIL PROTECTED] Subject: Tomcat ( JSP)+ MySql .. driver ? hi guys , can anyone help me plz ! .. how can i make my jsp files working on Tomcat

Tomcat and mysql

2003-01-22 Thread Lihong Sun
Hello, I have installed a web application called xplanner. It is using mysql and it is integrated in tomcat for authentication. I got the following error when I startup the application. I susspect somehow tomcat doesn't work well with mysql database. I wonder if anyone has seen this problem

Re: Tomcat and mysql

2003-01-22 Thread Larry Meadors
Looking at the stack trace, I do not see anything related to mysql. What makes you think that is the source of the problem? Based on the org.apache.jsp.projects$jsp bit, I would look in the project.jsp file first... Larry [EMAIL PROTECTED] 01/22/03 15:47 PM Hello, I have installed a web

tomcat log4j mysql

2002-10-16 Thread B
I am trying to use log4j 1.2.5, mysql 3.0.23 adn tomcat 4.0.1. 1. I placed the mysql-connector-java-2.0.14-bin.jar in my webapps/app/WEB-INF/lib dir. 2. This is my log4j properties file. log4j.appender.R.layout=org.apache.log4j.PatternLayout log4j.appender.R=org.apache.log4j.jdbc.JDBCAppender

RE: tomcat log4j mysql

2002-10-16 Thread Nicholas Orr
]] Sent: Thursday, 17 October 2002 5:18 AM To: Tomcat Users List Subject: tomcat log4j mysql I am trying to use log4j 1.2.5, mysql 3.0.23 adn tomcat 4.0.1. 1. I placed the mysql-connector-java-2.0.14-bin.jar in my webapps/app/WEB-INF/lib dir. 2. This is my log4j properties file

Re: Tomcat 4.1.9 + MySQL + jdbc driver

2002-08-25 Thread Glenn Nielsen
I have also seen this with the following setup. Solaris 8 on Sun Sparc Java 1.3.1_04 Tomcat 4.1.8/Jasper 1 mm.mysql 2.0.14 Apache 1.3.26 with mod_jk and Ajp13 connector. DBCP In my case from reviewing all of the tomcat logs I found that the Communication link failure looks like a symptom of

Re: Mac OS X, Tomcat 4.0.4, MySql configuration denies access

2002-07-09 Thread Martin Jacobson
started hacking about. I enabled root in NetInfo, and made sure that my user (martin) was a member of a group that root was also in. Hence, I was able to su root. I created a login account for mysql, and installed mysql as per instructions. I created a mysql user 'tomcat' which can only perform

Re: Mac OS X, Tomcat 4.0.4, MySql configuration denies access

2002-07-09 Thread Jack Park
to get plugged into the web. Whatever user(s) you run mysql, tomcat, and whatever else as, make sure they are users that can't log on. Is there some hint that everything should be owned and run by one user? I don't think so. It may help you to keep track of things. It may not. I'm pretty sure I

Re: Mac OS X, Tomcat 4.0.4, MySql configuration denies access

2002-07-08 Thread Martin Jacobson
configuration of the database with permissions is not consistent with OS X needs (works fine on wintel and linux, however). Hi, I am successfully using mysql (3.23.46) Tomcat (4.1.4) with mm.mysql driver (2.0.14) on Mac OS X (10.1.5). My normal db connection is via JNDI/Datasource, but I also

Re: Mac OS X, Tomcat 4.0.4, MySql configuration denies access

2002-07-08 Thread Jack Park
with OS X needs (works fine on wintel and linux, however). Hi, I am successfully using mysql (3.23.46) Tomcat (4.1.4) with mm.mysql driver (2.0.14) on Mac OS X (10.1.5). My normal db connection is via JNDI/Datasource, but I also use JDBCRealm user authentication, which is a simpler

Re: Mac OS X, Tomcat 4.0.4, MySql configuration denies access

2002-07-08 Thread Joel Rees
Been wondering some things about this thread -- Jack, what UNIX user owns MySQL? Likewise, Tomcat? And what UNIX user are they each being run by? I continue to get the sql exception using the above software and mm.mysql 2.0.8 drivers. MySql is 3.23.51 downloaded from entropy.ch I have

Re: Mac OS X, Tomcat 4.0.4, MySql configuration denies access

2002-07-08 Thread Jack Park
:26 PM 7/9/2002 +0900, Joel Rees wrote: Been wondering some things about this thread -- Jack, what UNIX user owns MySQL? Likewise, Tomcat? And what UNIX user are they each being run by? I continue to get the sql exception using the above software and mm.mysql 2.0.8 drivers. MySql is 3.23.51

Re: Mac OS X, Tomcat 4.0.4, MySql configuration denies access

2002-07-08 Thread Joel Rees
run mysql, tomcat, and whatever else as, make sure they are users that can't log on. Is there some hint that everything should be owned and run by one user? I don't think so. It may help you to keep track of things. It may not. I'm pretty sure I had a separate tomcat and mysql user in my set-up

Mac OS X, Tomcat 4.0.4, MySql configuration denies access

2002-07-07 Thread Jack Park
I continue to get the sql exception using the above software and mm.mysql 2.0.8 drivers. MySql is 3.23.51 downloaded from entropy.ch I have granted permission to the program for both localhost (a guess) and localhost.localdomain (which I needed on wintel and linux). While roaming with google,

RE: Mac OS X, Tomcat 4.0.4, MySql configuration denies access

2002-07-07 Thread Steve Ahlstrom
PROTECTED] Subject: Mac OS X, Tomcat 4.0.4, MySql configuration denies access I continue to get the sql exception using the above software and mm.mysql 2.0.8 drivers. MySql is 3.23.51 downloaded from entropy.ch I have granted permission to the program for both localhost (a guess

RE: Mac OS X, Tomcat 4.0.4, MySql configuration denies access

2002-07-07 Thread Jack Park
Thank you! I just upgraded to 2.0.14 with no change in behavior. I suppose I am a bit confused, and perhaps a bit of detail on what I have done might help. I open mysql with DriverManager.getConnection(jdbc:mysql:///mydatabase,nexw,) where nexw is the username and there is no password. I

RE: Mac OS X, Tomcat 4.0.4, MySql configuration denies access

2002-07-07 Thread Steve Ahlstrom
: Sunday, July 07, 2002 8:09 PM To: Tomcat Users List Subject: RE: Mac OS X, Tomcat 4.0.4, MySql configuration denies access Thank you! I just upgraded to 2.0.14 with no change in behavior. I suppose I am a bit confused, and perhaps a bit of detail on what I have done might help. I open mysql

Tomcat 3.3.1 MySQL

2002-04-16 Thread Joseph E. Savard
I would like TOMCAT to server op the connections to MYSQL.. Can someone please send me the appropriate server.xml configuration and misc tidbits that can get me started!! Thank you, joseph

Re: Tomcat 4.0.2 - MySQL Connection Pooling

2002-02-25 Thread Ross Fujii
replace the entire tomcat directory and thus the proper JARs, you should get it working. Best regards, ---Ross From: Michael Donaghy [EMAIL PROTECTED] To: Ross Fujii [EMAIL PROTECTED] Subject: Re: Tomcat 4.0.2 - MySQL Connection Pooling Date: 25 Feb 2002 23:31:02 -0500 By any chance do you

Tomcat 4.0.2 - MySQL Connection Pooling

2002-02-22 Thread Ross Fujii
Hello, I'm trying to setup JNDI connection pooling in Tomcat 4.0.2 to a MySQL (v3.23.49) database. I'm also running an Apache 1.3.20 AJP13 connector (using mod_jk) if that makes a difference all on a RedHat Linux 7.2 server. The following is a snippet of the JNDI resource creation in

Re: Cannot connect Servlet/JSP running in Tomcat to MySQL Database

2001-12-06 Thread David Smith
running in Tomcat to a MySQL database. Here are the particulars: Tomcat Version: 4.0.1 MySQL Version: 3.23.45 MySQL JDBC Driver Version: mm.mysql-2.0.4-bin.jar Linux Version: Red Hat 7.1 running Kernel Version 2.4.2-2smp Here is some sample code

Cannot connect Servlet/JSP running in Tomcat to MySQL Database

2001-12-05 Thread Stine, Matt
Hi, I am unable to connect a servlet or jsp running in Tomcat to a MySQL database. Here are the particulars: Tomcat Version: 4.0.1 MySQL Version: 3.23.45 MySQL JDBC Driver Version: mm.mysql-2.0.4-bin.jar Linux Version: Red Hat 7.1 running Kernel Version 2.4.2-2smp Here

Re: Cannot connect Servlet/JSP running in Tomcat to MySQL Database

2001-12-05 Thread August Detlefsen
, could there be a MySQL filter that denies access to the DB from anything but PHP? -August --- Stine, Matt [EMAIL PROTECTED] wrote: Hi, I am unable to connect a servlet or jsp running in Tomcat to a MySQL database. Here are the particulars: Tomcat Version: 4.0.1 MySQL Version: 3.23.45

Re: Tomcat and MySQL

2001-05-10 Thread Gary Lawrence Murphy
Any recommendations for JDBC connection pool software? I'd seen Turbine mentioned in this context, but couldn't figure out how to extract just that functionality from it. Any other recommended packages for a simple but robust pool? -- Gary Lawrence Murphy [EMAIL PROTECTED] TeleDynamics

Re: Tomcat and MySQL

2001-05-10 Thread Jeff Kilbride
DbConnectionBroker available at www.javaexchange.com. I've also heard of Poolman, but have never used it myself. Thanks, --jeff - Original Message - From: Gary Lawrence Murphy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, May 10, 2001 1:24 PM Subject: Re: Tomcat and MySQL

Re: Tomcat and MySQL

2001-05-10 Thread c:h
the Sun press Core Servlets books also has some good sample code, if you wanted to write your own connection pool class. - Original Message - From: Gary Lawrence Murphy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, May 10, 2001 1:24 PM Subject: Re: Tomcat and MySQL

Re: Tomcat and MySQL

2001-05-10 Thread Bip Thelin
On Thu, 10 May 2001, Jeff Kilbride wrote: DbConnectionBroker available at www.javaexchange.com. I've also heard of Poolman, but have never used it myself. [...] Any recommendations for JDBC connection pool software? I'd seen Turbine mentioned in this context, but couldn't figure

Re: Tomcat and MySQL

2001-05-10 Thread Gary Lawrence Murphy
B == Bip Thelin [EMAIL PROTECTED] writes: B There is one under Jakarta Commons. B http://jakarta.apache.org/cvsweb/index.cgi/jakarta-commons/dbcp/ I'd tried DbConnectionBroker and was reasonably satisfied, but the jakarta-commons project looks very interesting Thanks. -- Gary

Tomcat and MySQL

2001-04-30 Thread Robert Wohlgemuth
Hi to all! I use Tomcat together with mysql to store my data. I wrote an servlet at school that uses an Oracle Database to store and retrieve data. It worked fine. So I wanted to use this servlet at home too. I changed the JDBC driver but now i get in the tomcat.log file an exception. The source

Re: Tomcat and MySQL

2001-04-30 Thread Benoit Jacquemont
Hi, Try to put your mysql-comp.jar and mysql-uncomp.jar in the war/WEB-INF/lib of your app. It should do the trick. Benoît Hi to all! I use Tomcat together with mysql to store my data. I wrote an servlet at school that uses an Oracle Database to store and retrieve data. It worked fine

Re: Tomcat and MySQL

2001-04-30 Thread Doug Fields
from there due to problems in tomcat. I use Tomcat 3.2.1. Doug At 04:54 AM 4/30/2001, Robert Wohlgemuth wrote: Hi to all! I use Tomcat together with mysql to store my data. I wrote an servlet at school that uses an Oracle Database to store and retrieve data. It worked fine. So I wanted to use

AW: Tomcat and MySQL

2001-04-30 Thread Robert Wohlgemuth
] Betreff: Re: Tomcat and MySQL I have MySQL working fine with the driver you mention below (version 2.0.4) by putting the library for it (the jar file) into the WEB-INF/lib directory, where it belongs. If it doesn't work for you there, you can try the $TOMCAT_HOME/lib directory. Some things (like JCE

Tomcat and mySQL

2001-02-28 Thread Herchel Wojciech
Hi! I'm using JDBCRealm authorisation. How can I force mySQL not to close the connection Tomcat opened upon startup (to database where users, roles, user_roles tables are stored)? i assume mySQL's variable wait_timeout is responsible for closing inactive connections. the default is 28800 secs,

RE: Tomcat and mySQL

2001-02-28 Thread Cato, Christopher
Add ;autoreconnect=true to the db connect string. -Original Message- From: Herchel Wojciech [mailto:[EMAIL PROTECTED]] Sent: den 28 februari 2001 17:32 To: 'Tomcat' Subject: Tomcat and mySQL Hi! I'm using JDBCRealm authorisation. How can I force mySQL not to close

ODP: Tomcat and mySQL

2001-02-28 Thread Herchel Wojciech
specified. how can i make it to use original connection user and passwd? vVolf -Oryginalna wiadomo- Od: Cato, Christopher [mailto:[EMAIL PROTECTED]] Wysano: 28 lutego 2001 17:56 Do: '[EMAIL PROTECTED]' Temat: RE: Tomcat and mySQL Add ;autoreconnect=true to the db connect string

ODP: Tomcat and mySQL

2001-02-28 Thread Herchel Wojciech
-Oryginalna wiadomo- Od: Cato, Christopher [mailto:[EMAIL PROTECTED]] Wysano: 28 lutego 2001 17:56 Do: '[EMAIL PROTECTED]' Temat: RE: Tomcat and mySQL Add ;autoreconnect=true to the db connect string. -Original Message- From: Herchel Wojciech [mailto:[EMAIL PROTECTED

Linux/Apache/Tomcat/JDBC/MySQL, was: RE: Tomcat and jdk

2000-12-14 Thread Dave Newton
jdk1.2 I'm currently using the IBM JDK 1.1.8 since both JDBC thingies I have don't work under Sun's JDK 1.2.2... Which leads to to YAQ: does anybody have JDBC for MySQL that works under JDK1.2 or greater? I don't have the time to do a JDBC right now! ;) Dave

Re: Linux/Apache/Tomcat/JDBC/MySQL, was: RE: Tomcat and jdk

2000-12-14 Thread Andrew Robson
Try http://www.mysql.com/downloads/api-jdbc.html to get mm MySql driver (type 4). I'm using jdk1.3 and seems to work OK (so far!) Andrew PS you probably shouldn't be posting to this list unless tomcat specific ;-) On Thu, 14 Dec 2000, you wrote: jdk1.2 I'm currently using the IBM JDK