Hi,
Yes I did both of them.
In mysql I created an user named marco..below is the commandline window
when
I did the mysql command
C:\mysql\bin>mysql --user marco --password
Enter password: ****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.1.1a-alpha-max-debug
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY
'boss' WITH
GRANT OPTION;
Query OK, 0 rows affected (0.03 sec)
In the common\lib I have put the file mm.mysql-2.0.14-bin.jar
I still cannot figure out why I am getting the exception like below,
That seems to say that there is no database running...
org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFact
ory, cause:
java.sql.SQLException: Communication failure during handshake. Is there
a server
running on localhost:3306?
at org.gjt.mm.mysql.MysqlIO.init(Unknown Source)
at org.gjt.mm.mysql.Connection.connectionInit(Unknown Source)
at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Unknown
Source)
at org.gjt.mm.mysql.Driver.connect(Unknown Source)
at
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(Driv
erConnectionFactory.java:82)
at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(Poolable
ConnectionFactory.java:300)
at
org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(Bas
icDataSource.java:838)
at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
rce.java:821)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource
.java:518)
at org.apache.jsp.testdb_jsp._jspService(testdb_jsp.java:64)
at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
.java:311)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
01)
at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:284)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:204)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:257)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:151)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:567)
at
org.apache.catalina.core.StandardContextValve.invokeInternal(Standard
ContextValve.java:245)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:199)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:151)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:509)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:149)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:567)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:184)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:151)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:164)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:149)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:567)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:156)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:151)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:567)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972)
at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:20
6)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:833)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ssConnection(Http11Protocol.java:732)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java
:619)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
ool.java:688)
at java.lang.Thread.run(Thread.java:536)
One thing I haven't mentioned: I haven't downloaded any of the
Files mentioned in the instruction
Jakarta-Commons DBCP 1.0
Jakarta-Commons Collections 2.0
Jakarta-Commons Pool 1.0
Because I saw them already in the common\lib directory, and I thought
that
They were the proper version.....
Regards
marco
-----Original Message-----
From: FRANCOIS Dufour [mailto:[EMAIL PROTECTED]
Sent: 03 March 2004 18:33
To: [EMAIL PROTECTED]
Subject: RE: problem in configuring a Datasource in Tomcat 5.0
did you dowloaded java conecter j from mysl and copied it under under
your
tomcat_home comon/lib
+alowed a user connection into mysql ?
[EMAIL PROTECTED]
administrateur http://entre-nous.qc.tc
>From: "Marco Mistroni" <[EMAIL PROTECTED]>
>Reply-To: "Tomcat Users List" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Subject: problem in configuring a Datasource in Tomcat 5.0
>Date: Wed, 3 Mar 2004 16:32:15 -0000
>
>
>Hi,
> i am still trying to configure a datasource with tomcat..
>I have a mysql instance running on my machine, (I can use without any
>problem mysql console and mysql gui client), but in tomcat I am still
>getting
>Following exception..
>
>org.apache.commons.dbcp.SQLNestedException: Cannot create
>PoolableConnectionFact
>ory, cause:
>java.sql.SQLException: Cannot connect to MySQL server on
localhost:3306.
>Is ther
>e a MySQL server running on the machine/port you are trying to connect
>to? (java
>.net.ConnectException)
> at org.gjt.mm.mysql.Connection.connectionInit(Unknown Source)
> at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Unknown
>Source)
> at org.gjt.mm.mysql.Driver.connect(Unknown Source)
> at
>org.apache.commons.dbcp.DriverConnectionFactory.createConnection(Driv
>erConnectionFactory.java:82)
> at
>org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(Poolable
>ConnectionFactory.java:300)
> at
>org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(Bas
>icDataSource.java:838)
> at
>org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
>rce.java:821)
> at
>org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource
>.java:518)
> at org.apache.jsp.testdb_jsp._jspService(testdb_jsp.java:64)
> at
>org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
> at
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
> at
>org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
>.java:311)
> at
>org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
>01)
> at
>org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
>
>I attach again my server.xml...
>
>Thanx in advance and regards
> Marco
>
>
>
>
>
>
>-----Original Message-----
>From: Marco Mistroni [mailto:[EMAIL PROTECTED]
>Sent: 03 March 2004 15:58
>To: 'Shapira, Yoav'
>Subject: RE: problem in configuring a Datasource in Tomcat 5.0
>
>Hi Yoav,
> Thanx, but it worked for half :-(
>
>Now I am getting this exception :
>org.apache.commons.dbcp.SQLNestedException: Cannot create
>PoolableConnectionFact
>ory, cause:
>java.sql.SQLException: Cannot connect to MySQL server on
localhost:3306.
>Is ther
>e a MySQL server running on the machine/port you are trying to connect
>to? (java
>.lang.NumberFormatException)
> at org.gjt.mm.mysql.Connection.connectionInit(Unknown Source)
>
>this would mean that there is no mysql server running at localhost..
>
>however, I have just started one instance, and here is mysql output..
>
>InnoDB: The first specified data file .\ibdata1 did not exist:
>InnoDB: a new database to be created!
>040303 13:43:50 InnoDB: Setting file .\ibdata1 size to 10 MB
>InnoDB: Database physically writes the file full: wait...
>040303 13:43:50 InnoDB: Log file .\ib_logfile0 did not exist: new to
be
>created
>
>InnoDB: Setting log file .\ib_logfile0 size to 5 MB
>InnoDB: Database physically writes the file full: wait...
>040303 13:43:51 InnoDB: Log file .\ib_logfile1 did not exist: new to
be
>created
>
>InnoDB: Setting log file .\ib_logfile1 size to 5 MB
>InnoDB: Database physically writes the file full: wait...
>InnoDB: Doublewrite buffer not found: creating new
>InnoDB: Doublewrite buffer created
>InnoDB: Creating foreign key constraint system tables
>InnoDB: Foreign key constraint system tables created
>040303 13:43:54 InnoDB: Started; log sequence number 0 0
>mysqld: ready for connections.
>Version: '4.1.1a-alpha-max-debug' socket: '' port: 3306
>
>Any suggestions?
>
>Thanx in advance and regards
> marco
>
>
>
>
>
>-----Original Message-----
>From: Shapira, Yoav [mailto:[EMAIL PROTECTED]
>Sent: 03 March 2004 14:12
>To: Tomcat Users List
>Subject: RE: problem in configuring a Datasource in Tomcat 5.0
>
>
>Hi,
>Try moving your TestDB datasource to your context declaration and out
of
>GlobalNamingResources.
>
>Yoav Shapira
>Millennium ChemInformatics
>
>-----Original Message-----
>From: Marco Mistroni [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, March 03, 2004 9:10 AM
>To: [EMAIL PROTECTED]
>Subject: problem in configuring a Datasource in Tomcat 5.0
>
>
>Hi all,
> I am trying to configure a Datasource with tomcat 5.0, and I
>keep on getting
>Following exception :
>
>org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver
of
>class '
>' for connect URL 'null', cause:
>java.sql.SQLException: No suitable driver
> at java.sql.DriverManager.getDriver(DriverManager.java:243)
> at
>org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
>rce.java:743)
> at
>org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource
>.java:518)
> at org.apache.jsp.testdb_jsp._jspService(testdb_jsp.java:64)
> at
>org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
> at
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
> at
>org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
>.java:311)
> at
>org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
>01)
> at
>org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
> at
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
> at
>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
>icationFilterChain.java:284)
> at
>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
>ilterChain.java:204)
> at
>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
>alve.java:257)
> at
>org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
>eContext.java:151)
> at
>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
>a:567)
> at
>org.apache.catalina.core.StandardContextValve.invokeInternal(Standard
>ContextValve.java:245)
> at
>org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
>alve.java:199)
> at
>org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
>eContext.java:151)
> at
>org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
>torBase.java:509)
> at
>org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
>eContext.java:149)
> at
>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
>a:567)
> at
>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
>ava:184)
> at
>org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
>eContext.java:151)
>
>
>
>I attach my server.xml, anyone can help?
>
>Thanx in advance and regards
> Marco
>
>
>
>
>This e-mail, including any attachments, is a confidential business
>communication, and may contain information that is confidential,
>proprietary and/or privileged. This e-mail is intended only for the
>individual(s) to whom it is addressed, and may not be saved, copied,
>printed, disclosed or used by anyone else. If you are not the(an)
>intended recipient, please immediately delete this e-mail from your
>computer system and notify the sender. Thank you.
>
><< server.xml >>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
_________________________________________________________________
MSN Messenger : discutez en direct avec vos amis !
http://messenger.fr.msn.ca/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
