Caro M�rio,
O server.xml est� aparentemente correto. O que eu tentaria para
encontrar o problema de conex�o seria:
1- Tentar conectar com o JDBC usando uma aplica��o de teste n�o web.
Fa�a uma classe qualquer que se conecte e mostre na tela o resultado de um
result set (algo simples mesmo usando System.out.println()).Se funcionar
voc� j� saber� que n�o tem problemas com o driver de JDBC nem com o banco de
dados. Al�m disso saber� que o seu CLASSPATH est� legal. Se n�o funcionar,
ent�o de cara verifique se o JAR do JDBC faz parte do seu CLASSPATH.
2- Se o item 1 funcionar legal ent�o eu sugiro que voc� verifique se no
seu ../commom/lib existem os arquivos:commons_collections.jar,
commons_pool.jar e commons_dbcp.jar. Sen�o estiverem ent�o baixe do site do
JAKARTA as vers�es correspondentes. As vers�es est�o na documenta��o do
Tomcat na parte de configura��o de pool de conex�es. Sem estes arquivos o
pool de conex�es n�o funciona.
3- Mantendo-se o erro envie para a lista os logs gerados e tamb�m a
tela com o erro. Assim teremos mais informa��es para poder identificar com
precis�o o que est� ocorrendo.
Um abra�o e boa sorte!!!
Alexandro Strack
----- Original Message -----
From: "M�rio Coelho" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 30, 2003 4:15 PM
Subject: [enterprise-list] Problemas no tomcat...
> Boa tarde a todos "javeiros"
> Estou usando jakarta-tomcat-4.1.24 e o JDBC do
> mysqlmysql-connector-java-3.0.8-stable.jar
> "com.mysql.Driver" (o server.xml esta anexado).
> Mas quando vou acessar a jsp com conex�o ao banco de
> dados tem o erro de class not found oque pode ser?
> Olha que eu fiz...
> Copiei o Driver mysql-connector-java-3.0.8-stable.jar
> para ../commom/lib
> Editei o server.xml (detalhes no arquivo em anexo...)
>
> bem quem tiver alguma dica eu agrade�o.
>
> Abra�o.
>
> M�rio Coelho.
>
> __________________________________
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
----------------------------------------------------------------------------
----
> <?xml version='1.0' encoding='utf-8'?>
> <Server className="org.apache.catalina.core.StandardServer" debug="0"
port="8005" shutdown="SHUTDOWN">
> <Listener className="org.apache.catalina.mbeans.ServerLifecycleListener"
debug="0" jsr77Names="false"/>
> <Listener
className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"
debug="0"/>
> <GlobalNamingResources>
> <Environment name="simpleValue" override="true"
type="java.lang.Integer" value="30"/>
> <Resource auth="Container" description="User database that can be
updated and saved" name="UserDatabase" scope="Shareable"
type="org.apache.catalina.UserDatabase"/>
> <ResourceParams name="UserDatabase">
> <parameter>
> <name>factory</name>
> <value>org.apache.catalina.users.MemoryUserDatabaseFactory</value>
> </parameter>
> <parameter>
> <name>pathname</name>
> <value>conf/tomcat-users.xml</value>
> </parameter>
> </ResourceParams>
> </GlobalNamingResources>
> <Service className="org.apache.catalina.core.StandardService" debug="0"
name="Tomcat-Standalone">
> <Connector className="org.apache.coyote.tomcat4.CoyoteConnector"
acceptCount="100" bufferSize="2048" compression="off" connectionLinger="-1"
connectionTimeout="20000" debug="0" disableUploadTimeout="true"
enableLookups="true" maxKeepAliveRequests="100" maxProcessors="75"
minProcessors="5" port="80"
protocolHandlerClassName="org.apache.coyote.http11.Http11Protocol"
proxyPort="0" redirectPort="8443" scheme="http" secure="false"
tcpNoDelay="true" useURIValidationHack="false">
> <Factory
className="org.apache.catalina.net.DefaultServerSocketFactory"/>
> </Connector>
> <Connector className="org.apache.coyote.tomcat4.CoyoteConnector"
acceptCount="10" bufferSize="2048" compression="off" connectionLinger="-1"
connectionTimeout="0" debug="0" disableUploadTimeout="false"
enableLookups="true" maxKeepAliveRequests="100" maxProcessors="75"
minProcessors="5" port="8009"
protocolHandlerClassName="org.apache.jk.server.JkCoyoteHandler"
proxyPort="0" redirectPort="8443" scheme="http" secure="false"
tcpNoDelay="true" useURIValidationHack="false">
> <Factory
className="org.apache.catalina.net.DefaultServerSocketFactory"/>
> </Connector>
> <Engine className="org.apache.catalina.core.StandardEngine" debug="0"
defaultHost="localhost"
mapperClass="org.apache.catalina.core.StandardEngineMapper"
name="Standalone">
> <Host className="org.apache.catalina.core.StandardHost"
appBase="webapps" autoDeploy="true"
configClass="org.apache.catalina.startup.ContextConfig"
contextClass="org.apache.catalina.core.StandardContext" debug="0"
deployXML="true"
errorReportValveClass="org.apache.catalina.valves.ErrorReportValve"
liveDeploy="true" mapperClass="org.apache.catalina.core.StandardHostMapper"
name="localhost" unpackWARs="true">
> <Context className="org.apache.catalina.core.StandardContext"
cachingAllowed="true"
charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true"
crossContext="false" debug="0" displayName="Tomcat Administration
Application" docBase="../server/webapps/admin"
mapperClass="org.apache.catalina.core.StandardContextMapper" path="/admin"
privileged="true" reloadable="false" swallowOutput="false" useNaming="true"
wrapperClass="org.apache.catalina.core.StandardWrapper">
> <Logger className="org.apache.catalina.logger.FileLogger"
debug="0" directory="logs" prefix="localhost_admin_log." suffix=".txt"
timestamp="true" verbosity="1"/>
> </Context>
> <!--
> Inicio do teste de banco de dados...
> -->
> <Context path="/DBTest" docBase="DBTest"
> debug="5" reloadable="true" crossContext="true">
> <Logger className="org.apache.catalina.logger.FileLogger"
> prefix="localhost_DBTest_log." suffix=".txt"
> timestamp="true"/>
> <Resource name="jdbc/TestDB"
> auth="Container"
> type="javax.sql.DataSource"/>
> <ResourceParams name="jdbc/TestDB">
> <parameter>
> <name>factory</name>
> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
> </parameter>
> <!-- Maximum number of dB connections in pool. Make sure you
> configure your mysqld max_connections large enough to handle
> all of your db connections. Set to 0 for no limit.
> -->
> <parameter>
> <name>maxActive</name>
> <value>10</value>
> </parameter>
> <!-- Maximum number of idle dB connections to retain in pool.
> Set to 0 for no limit.
> -->
> <parameter>
> <name>maxIdle</name>
> <value>10</value>
> </parameter>
> <!-- Maximum time to wait for a dB connection to become available
> in ms, in this example 10 seconds. An Exception is thrown if
> this timeout is exceeded. Set to -1 to wait indefinitely.
> -->
> <parameter>
> <name>maxWait</name>
> <value>10000</value>
> </parameter>
> <!-- MySQL dB username and password for dB connections -->
> <parameter>
> <name>username</name>
> <value>javauser</value>
> </parameter>
> <parameter>
> <name>password</name>
> <value>javadude</value>
> </parameter>
> <!-- Class name for com.mysql.jdbc.Driver -->
> <parameter>
> <name>driverClassName</name>
> <value>com.mysql.jdbc.Driver</value>
> </parameter>
> <!-- The JDBC connection url for connecting to your MySQL dB.
> The autoReconnect=true argument to the url makes sure that the
> mm.mysql JDBC Driver will automatically reconnect if mysqld
closed the
> connection. mysqld by default closes idle connections after 8
hours.
> -->
> <parameter>
> <name>url</name>
> <value>jdbc:mysql://localhost/javatest</value>
> </parameter>
> </ResourceParams>
> </Context>
> <Context className="org.apache.catalina.core.StandardContext"
cachingAllowed="true"
charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true"
crossContext="false" debug="0" displayName="Webdav Content Management"
docBase="/usr/java/jakarta-tomcat-4.1.24/webapps/webdav"
mapperClass="org.apache.catalina.core.StandardContextMapper" path="/webdav"
privileged="false" reloadable="false" swallowOutput="false" useNaming="true"
wrapperClass="org.apache.catalina.core.StandardWrapper">
> </Context>
> <Context className="org.apache.catalina.core.StandardContext"
cachingAllowed="true"
charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true"
crossContext="false" debug="0" displayName="Web appliacation by AW"
docBase="/usr/java/jakarta-tomcat-4.1.24/webapps/web"
mapperClass="org.apache.catalina.core.StandardContextMapper" path="/web"
privileged="true" reloadable="false" swallowOutput="false" useNaming="true"
wrapperClass="org.apache.catalina.core.StandardWrapper">
> <Logger className="org.apache.catalina.logger.FileLogger" debug="0"
directory="logs" prefix="localhost_web_log." suffix=".txt" timestamp="true"
verbosity="1"/>
> <JDBCRealm
> debug="99" driverName="org.gjt.mm.mysql.Driver"
> connectionURL="jdbc:mysql://localhost/app01?user=root;password="
> userTable="users"
> userNameCol="user_name"
> userCredCol="user_pass"
> userRoleTable="user_roles" roleNameCol="role_name" />
> </Context>
> <!-- <Context className="org.apache.catalina.core.StandardContext"
cachingAllowed="true"
charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true"
crossContext="true" debug="0" displayName="Tomcat Examples"
docBase="examples"
mapperClass="org.apache.catalina.core.StandardContextMapper"
path="/examples" privileged="false" reloadable="true" swallowOutput="false"
useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper">
> <Logger className="org.apache.catalina.logger.FileLogger"
debug="0" directory="logs" prefix="localhost_examples_log." suffix=".txt"
timestamp="true" verbosity="1"/>
> <Parameter name="context.param.name" override="false"
value="context.param.value"/>
> <Ejb home="com.wombat.empl.EmployeeRecordHome"
name="ejb/EmplRecord" remote="com.wombat.empl.EmployeeRecord"
type="Entity"/>
> <Ejb description="Example EJB Reference"
home="com.mycompany.mypackage.AccountHome" name="ejb/Account"
remote="com.mycompany.mypackage.Account" type="Entity"/>
> <Environment name="foo/name4" override="true"
type="java.lang.Integer" value="10"/>
> <Environment name="maxExemptions" override="true"
type="java.lang.Integer" value="15"/>
> <Environment name="minExemptions" override="true"
type="java.lang.Integer" value="1"/>
> <Environment name="foo/bar/name2" override="true"
type="java.lang.Boolean" value="true"/>
> <Environment name="name3" override="true"
type="java.lang.Integer" value="1"/>
> <Environment name="foo/name1" override="true"
type="java.lang.String" value="value1"/>
> <LocalEjb description="Example Local EJB Reference"
home="com.mycompany.mypackage.ProcessOrderHome"
local="com.mycompany.mypackage.ProcessOrder" name="ejb/ProcessOrder"
type="Session"/>
> <Resource auth="SERVLET" name="jdbc/EmployeeAppDb"
scope="Shareable" type="javax.sql.DataSource"/>
> <Resource auth="Container" name="mail/Session" scope="Shareable"
type="javax.mail.Session"/>
> <ResourceParams name="jdbc/EmployeeAppDb">
> <parameter>
> <name>url</name>
> <value>jdbc:HypersonicSQL:database</value>
> </parameter>
> <parameter>
> <name>password</name>
> <value></value>
> </parameter>
> <parameter>
> <name>driverClassName</name>
> <value>org.hsql.jdbcDriver</value>
> </parameter>
> <parameter>
> <name>username</name>
> <value>sa</value>
> </parameter>
> </ResourceParams>
> <ResourceParams name="mail/Session">
> <parameter>
> <name>mail.smtp.host</name>
> <value>localhost</value>
> </parameter>
> </ResourceParams>
> <ResourceLink global="simpleValue" name="linkToGlobalResource"
type="java.lang.Integer"/>
> </Context>
> -->
> <Context className="org.apache.catalina.core.StandardContext"
cachingAllowed="true"
charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true"
crossContext="false" debug="0" displayName="Tomcat Documentation"
docBase="/usr/java/jakarta-tomcat-4.1.24/webapps/tomcat-docs"
mapperClass="org.apache.catalina.core.StandardContextMapper"
path="/tomcat-docs" privileged="false" reloadable="false"
swallowOutput="false" useNaming="true"
wrapperClass="org.apache.catalina.core.StandardWrapper">
> </Context>
> <Context className="org.apache.catalina.core.StandardContext"
cachingAllowed="true"
charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true"
crossContext="false" debug="0" displayName="Welcome to Tomcat"
docBase="/usr/java/jakarta-tomcat-4.1.24/webapps/ROOT"
mapperClass="org.apache.catalina.core.StandardContextMapper" path=""
privileged="false" reloadable="false" swallowOutput="false" useNaming="true"
wrapperClass="org.apache.catalina.core.StandardWrapper">
> </Context>
> <Context className="org.apache.catalina.core.StandardContext"
cachingAllowed="true"
charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true"
crossContext="false" debug="0" displayName="Tomcat Manager Application"
docBase="../server/webapps/manager"
mapperClass="org.apache.catalina.core.StandardContextMapper" path="/manager"
privileged="true" reloadable="false" swallowOutput="false" useNaming="true"
wrapperClass="org.apache.catalina.core.StandardWrapper">
> <ResourceLink global="UserDatabase" name="users"
type="org.apache.catalina.UserDatabase"/>
> </Context>
> <Logger className="org.apache.catalina.logger.FileLogger"
debug="0" directory="logs" prefix="localhost_log." suffix=".txt"
timestamp="true" verbosity="1"/>
> </Host>
> <Logger className="org.apache.catalina.logger.FileLogger" debug="0"
directory="logs" prefix="catalina_log." suffix=".txt" timestamp="true"
verbosity="1"/>
> <Realm className="org.apache.catalina.realm.UserDatabaseRealm"
debug="0" resourceName="UserDatabase" validate="true"/>
> </Engine>
> </Service>
> </Server>
>
>
----------------------------------------------------------------------------
----
---------------------------------------------------------------------
Para cancelar a subscri��o, envie mensagem para:
[EMAIL PROTECTED]
Para comandos adicionais, envie mensagem para:
[EMAIL PROTECTED]
---------------------------------------------------------------------
Para cancelar a subscri��o, envie mensagem para: [EMAIL PROTECTED]
Para comandos adicionais, envie mensagem para: [EMAIL PROTECTED]
