tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Carlos Bracho <carlos.bra...@gmail.com>
Subject Re: tomcat data source - mysql
Date Fri, 01 Oct 2004 14:30:02 GMT
Try jdbc:mysql://localhost:<port>/<database> (usually the port number
is 3306) in the url param value


On Fri, 1 Oct 2004 01:09:43 -0700, Eric Wulff <ewulff@gmail.com> wrote:
> Hi, I am not able to access a mysql server from a simple jsp example.
> I have googled the errors, checked mysql and tomcat docs and mailing
> list archives without success.  Finding a tremendous amount of info
> but nothing so far worked to solve my problem.  I created a data
> resource in my server.xml.  I have defined a resource reference in my
> web.xml.  I have tried shutting down my firewall.  I'm sure others
> have had similar problems and I'm hoping one of you can share your
> wisdom or point me in the right direction?
> 
> many thx
> Eric
> 
> More, hopefully enlightening, details below.
> 
> fedoa core 2
> tomcat 5
> j2sdk 1.4.2
> mysql 3.23.58 for linux redhat
> 
> -when mysql server is started I access it by simply typing 'mysql' at
> the command line
> 
> following is web.xml, JNDI db res entry from the server.xml, and 3
> error listings
> 
> -web.xml...
> <?xml version="1.0" encoding="ISO-8859-1"?>
> 
> <!DOCTYPE web-app
>    PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
>    "http://java.sun.com/dtd/web-app_2_3.dtd">
> 
> <web-app>
>    <servlet>
>        <servlet-name>Database Rates</servlet-name>
>        <servlet-class>DatabaseRates</servlet-class>
>    </servlet>
>    <servlet>
>        <servlet-name>DataSource Rates</servlet-name>
>        <servlet-class>DataSourceRates</servlet-class>
>    </servlet>
>    <servlet>
>        <servlet-name>Rates</servlet-name>
>        <jsp-file>/rates.jsp</jsp-file>
>    </servlet>
> 
>    <servlet-mapping>
>        <servlet-name>Database Rates</servlet-name>
>        <url-pattern>/database</url-pattern>
>    </servlet-mapping>
>    <servlet-mapping>
>        <servlet-name>DataSource Rates</servlet-name>
>        <url-pattern>/datasource</url-pattern>
>    </servlet-mapping>
>    <servlet-mapping>
>        <servlet-name>Rates</servlet-name>
>        <url-pattern>/rates</url-pattern>
>    </servlet-mapping>
> 
>        <resource-ref>
>          <res-ref-name>jdbc/conversion</res-ref-name>
>          <res-type>javax.sql.DataSource</res-type>
>          <res-auth>Container</res-auth>
>        </resource-ref>
> </web-app>
> 
> -server.xml JNDI db resource entry...
> I have set a password for root to match the example but that didn't work.
> 
>  <Context path="/database" docBase="database" debug="0" reloadable="true">
>    <ResourceParams name="jdbc/conversion">
>      <parameter>
>        <name>username</name>
>        <value>root</value>
>      </parameter>
>      <parameter>
>        <name>password</name>
>        <value>secret</value>
>      </parameter>
>      <parameter>
>        <name>driverClassName</name>
>        <!-- <value>org.gjt.mm.mysql.Driver</value> tried both -->
>        <value>com.mysql.jdbc.Driver</value>
>      </parameter>
>      <parameter>
>        <name>url</name>
>        <value>jdbc:mysql://localhost/test</value>
>      </parameter>
>    </ResourceParams>
>  </Context>
> 
> java.sql.SQLException: Data source rejected establishment of
> connection, message from server: "Host 'localhost.localdomain' is not
> allowed to connect to this MySQL server" SQL state: 08004
> Error code: 1130
> 
> 3 similar errors based on different db access strategies...
> org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver
> of class '' for connect URL 'null' SQL state: null
> Error code: 0
> 
> -error when using a datasource object...
> org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver
> of class '' for connect URL 'null'
> 
> -stack trace when using a DAO via a .jsp...
> org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780)
> org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
>        converters.ConversionDAO.<init>(ConversionDAO.java:23)
>        org.apache.jsp.rates_jsp._jspService(rates_jsp.java:46)
>        org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
>        javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>        org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
>        org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
>        org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
>        javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> 
> -I can create the test db table manually but can't via the java
> program provided in the tutorial.  This is the error I get when
> attempting to run that...
> java -classpath
> .:/usr/local/jakarta-tomcat-5.0.28/common/lib/mysql-connector-java-3.0.15-ga-bin.jar
> CreateDB
> Loaded driver: com.mysql.jdbc.Driver
> SQL Exception thrown: java.sql.SQLException: Data source rejected
> establishment of connection,  message from server: "Host
> 'localhost.localdomain' is not allowed to connect to this MySQL
> server"
> java.sql.SQLException: Data source rejected establishment of
> connection,  message from server: "Host 'localhost.localdomain' is not
> allowed to connect to this MySQL server"
>        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:649)
>        at com.mysql.jdbc.Connection.createNewIO(Connection.java:1782)
>        at com.mysql.jdbc.Connection.<init>(Connection.java:450)
>        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)
>        at java.sql.DriverManager.getConnection(DriverManager.java:512)
>        at java.sql.DriverManager.getConnection(DriverManager.java:193)
>        at CreateDB.main(CreateDB.java:17)
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> 
> 



-- 
------------------------------------------------------------------
 Carlos J, Bracho M.                                  
 "The significant problems we face cannot    
  be solved at the same level of thinking      
  we were at when we created them."          
  Albert Einstein                           
------------------------------------------------------------------
 e-mail:  carlos.bracho@gmail.com
 MSN:    cbrachomi@hotmail.com                      
------------------------------------------------------------------

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message