Ok turns out there is a problem with Manager application - it doesn't read folders 
properly when you deploy as a folder or WAR, but it reads XML fine when you deploy is 
XML.

Check it out:

http://issues.apache.org/bugzilla/show_bug.cgi?id=29895



-----Original Message-----
From: Lorenzo A. Jimenez Briceno [mailto:[EMAIL PROTECTED] 
Sent: Friday, July 02, 2004 3:25 PM
To: Tomcat Users List
Subject: RE: RE-PROBLEM: Problems moving <context> from server.xml to web.xml ...
Importance: High

Look at one of mine:

<?xml version="1.0" encoding="UTF-8"?>
<Context docBase="C:\Documents and Settings\lorenzosjb\Desktop\demos" path="/demos">
  <Resource auth="Container" name="jdbc/dinamica" type="javax.sql.DataSource"/>
  <ResourceParams name="jdbc/dinamica">
    <parameter>
      <name>factory</name>
      <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
    </parameter>
    <parameter>
      <name>url</name>
      <value>jdbc:mckoi://localhost/</value>
    </parameter>
    <parameter>
      <name>driverClassName</name>
      <value>com.mckoi.JDBCDriver</value>
    </parameter>
    <parameter>
      <name>username</name>
      <value>sa</value>
    </parameter>
    <parameter>
      <name>password</name>
      <value>admin</value>
    </parameter>
    <parameter>
      <name>maxActive</name>
      <value>100</value>
    </parameter>
    <parameter>
      <name>maxWait</name>
      <value>10000</value>
    </parameter>
    <parameter>
      <name>maxIdle</name>
      <value>30</value>
    </parameter>
    <parameter>
      <name>removeAbandoned</name>
      <value>true</value>
    </parameter>
    <parameter>
      <name>removeAbandonedTimeout</name>
      <value>300</value>
    </parameter>
    <parameter>
      <name>logAbandoned</name>
      <value>true</value>
    </parameter>
  </ResourceParams>
</Context>




























-----Mensaje original-----
De: Ivan Jouikov [mailto:[EMAIL PROTECTED]
Enviado el: Viernes, 02 de Julio de 2004 04:12 p.m.
Para: 'Tomcat Users List'
Asunto: RE-PROBLEM: Problems moving <context> from server.xml to web.xml
..


Ok, I put the following into my META-INF/context.xml:

<?xml version="1.0" encoding="UTF-8" ?> 

<Context path="/ablogic" debug="9" reloadable="true">

        <Resource name="jdbc/ablogic" auth="Container" type="javax.sql.DataSource"/>
        
    <ResourceParams name="jdbc/ablogic">
                <!-- Max pool connections -->
                <parameter><name>maxActive</name><value>5</value></parameter>
                <!-- Max idle connections -->
                <parameter><name>maxIdle</name><value>5</value></parameter>
                <!-- Username -->
                <parameter><name>username</name><value>ivan</value></parameter>
                <!-- Password -->
                <parameter><name>password</name><value>kittiesrcute</value></parameter>
                <!--DB Driver -->
                
<parameter><name>driverClassName</name><value>com.mysql.jdbc.Driver</value></parameter>
                <!--DB URL -->
            
<parameter><name>url</name><value>jdbc:mysql://192.168.0.1:3306/school?autoReconnect=true</value></parameter>
        </ResourceParams>
        
</Context>

When I deploy the application using tomcat manager, it seems to deploy it correctly, 
because path /ablogic is automatically assigned to it.  However, I still can't get a 
hold of my DB info:

Error message: Cannot create JDBC driver of class '' for connect URL 'null'

org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:750)

org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518)

org.ablogic.db.Manager.getConnection(Manager.java:41)

org.ablogic.db.Manager.testQuery(Manager.java:85)

org.apache.jsp.init._2_jsp._jspService(_2_jsp.java:78)

org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)

javax.servlet.http.HttpServlet.service(HttpServlet.java:810)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:298)

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:810)

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

com.jspbook.GZIPFilter.doFilter(GZIPFilter.java:37)

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

org.ablogic.web.CacheFilter.doFilter(CacheFilter.java:130)

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

org.ablogic.web.IPBlockFilter.doFilter(IPBlockFilter.java:135)

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

org.ablogic.web.TraceFilter.doFilter(TraceFilter.java:69)

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValvejava:214)

org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)

org.apache.catalina.core.StandardContextValve.invoke(StandardContextValvejava:152)

org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)

org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)

org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)

org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)

org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)

org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:793)

org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:702)

org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:571)

org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:644)

java.lang.Thread.run(Unknown Source)



-------- C A U S E ----------

Error message: No suitable driver

java.sql.DriverManager.getDriver(Unknown Source)

org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:743)

org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518)

org.ablogic.db.Manager.getConnection(Manager.java:41)

org.ablogic.db.Manager.testQuery(Manager.java:85)

org.apache.jsp.init._2_jsp._jspService(_2_jsp.java:78)

org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)

javax.servlet.http.HttpServlet.service(HttpServlet.java:810)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:298)

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:810)

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

com.jspbook.GZIPFilter.doFilter(GZIPFilter.java:37)

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

org.ablogic.web.CacheFilter.doFilter(CacheFilter.java:130)

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

org.ablogic.web.IPBlockFilter.doFilter(IPBlockFilter.java:135)

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

org.ablogic.web.TraceFilter.doFilter(TraceFilter.java:69)

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValvejava:214)

org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)

org.apache.catalina.core.StandardContextValve.invoke(StandardContextValvejava:152)

org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)

org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)

org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)

org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)

org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)

org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:793)

org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:702)

org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:571)

org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:644)

java.lang.Thread.run(Unknown Source)


Any thoughts?  BTW, I placed the following into my web.xml:

        <resource-ref>
                <description>DB Connection</description>
                <res-ref-name>jdbc/ablogic</res-ref-name>
                <res-type>javax.sql.DataSource</res-type>
                <res-auth>Container</res-auth>
        </resource-ref>

And again, it all works just fine if I move the stuff in context.xml into my 
server.xml...











-----Original Message-----
From: Lorenzo A. Jimenez Briceno [mailto:[EMAIL PROTECTED] 
Sent: Friday, July 02, 2004 7:01 AM
To: Tomcat Users List
Subject: RE: Problems moving <context> from server.xml to web.xml ...
Importance: High

Ivan:
 
If you are using TC5, you can move server.xml info not to web.xml but to context.xml 
in META-INF directory.
I have used it with Netbeans 3.6 where the software creates this dir and the file. So 
context.xml contains:
 
<?xml version="1.0" encoding="UTF-8" ?> 
<Context path="/demos" />
 
Change it properly:
 
<?xml version="1.0" encoding="UTF-8" ?> 
<Context path="/"ablogic>
    <ResourceParams name="jdbc/ablogic">
    <!-- Max pool connections -->
    <parameter><name>maxActive</name><value>5</value></parameter>
    <!-- Max idle connections -->
    <parameter><name>maxIdle</name><value>5</value></parameter>
    <!-- Username -->
    <parameter><name>username</name><value>ivan</value></parameter>
    <!-- Password -->
    <parameter><name>password</name><value>kittiesrcute</value></parameter>
    <!--DB Driver -->
    
<parameter><name>driverClassName</name><value>com.mysql.jdbc.Driver</value></parameter>
    <!--DB URL -->
    
<parameter><name>url</name><value>jdbc:mysql://192.168.0.1:3306/school?autoReconnect=true</value></parameter>
</ResourceParams>
</Context>

Try it,
Happy computing,
 
Lorenzo
 


 
 
 
 
 
 
-----Mensaje original-----
De: Ivan Jouikov [mailto:[EMAIL PROTECTED]
Enviado el: Viernes, 02 de Julio de 2004 02:33 a.m.
Para: 'Tomcat Users List'
Asunto: Problems moving <context> from server.xml to web.xml ...


I want to move <context> element from server.xml to web.xml, so I can add new 
applications without restarting the server.

Everything works fine, my DB and all, until I move this entry:
code: 

  _____  

  <Context path="/ablogic" docBase="C:\Documents and Settings\SysOp\My Documents\AB 
LOGIC\Eclipse Workspace\abLogic\web" debug="9" reloadable="true">
                
               <!-- Database -->
               <Resource name="jdbc/ablogic" auth="Container" 
type="javax.sql.DataSource"/>
               
               <ResourceParams name="jdbc/ablogic">
                       <!-- Max pool connections -->
                       <parameter><name>maxActive</name><value>5</value></parameter>
                       <!-- Max idle connections -->
                       <parameter><name>maxIdle</name><value>5</value></parameter>
                       <!-- Username -->
                       <parameter><name>username</name><value>ivan</value></parameter>
                       <!-- Password -->
                       
<parameter><name>password</name><value>kittiesrcute</value></parameter>
                       <!--DB Driver -->
                       
<parameter><name>driverClassName</name><value>com.mysql.jdbc.Driver</value></parameter>
                       <!--DB URL -->
                       
<parameter><name>url</name><value>jdbc:mysql://192.168.0.1:3306/school?autoReconnect=true</value></parameter>
               </ResourceParams>
 
        </Context> 

  _____  



As soon as I move this thing, and try to use my DB, I get the following error:

Error message: Cannot create JDBC driver of class '' for connect URL 'null'

My mysql connector is both in my /common/lib and my /WEB-INF/lib/, just to keep it 
safe. Also, to my web.xml I added these two entries:
code: 

  _____  

 <ResourceLink name="jdbc/ablogic" global="jdbc/ablogic"/>
        
        <resource-ref>
               <description>DB Connection</description>
               <res-ref-name>jdbc/ablogic</res-ref-name>
               <res-type>javax.sql.DataSource</res-type>
               <res-auth>Container</res-auth>
        </resource-ref> 

  _____  



I have no idea what the hell is wrong. Theoretically, I am not changing anything by 
simply copying <context> element, yet, it seems to stop working .

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.701 / Virus Database: 458 - Release Date: 07.06.2004




_____________________________ 
Lorenzo A. Jimenez Briceno
WebMaster
Banco Internacional de Costa Rica
( (506) 243-1077
1 (506) 243-1075
- [EMAIL PROTECTED]

BICSA ?Un mundo de servicios financieros a su alcance! 
http://www.bicsa.com
7/2/2004 8:01 AM
Este mensaje puede ser confidencial. Si usted no es la persona a quien se debio 
dirigir por favor notifiquenos de inmediato y borre el mensaje. BICSA no acepta 
responsabilidad legal por ningun dano causado por virus, errores u omisiones en el 
contenido de este mensaje. Todo uso o divulgacion no autorizado esta prohibido. 
Gracias. 

This message may be confidential. If you are not the intended recipient, please notify 
us immediately and delete this message. BICSA does not accept liability for any damage 
caused by virus, errors, or omissions in the contents of this message. Any 
unauthorized use or disclosure of its contents is prohibited. Thank you. 

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.701 / Virus Database: 458 - Release Date: 07.06.2004
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.701 / Virus Database: 458 - Release Date: 07.06.2004
 


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



_____________________________ 
Lorenzo A. Jimenez Briceno
WebMaster
Banco Internacional de Costa Rica
( (506) 243-1077
1 (506) 243-1075
- [EMAIL PROTECTED]

BICSA ?Un mundo de servicios financieros a su alcance! 
http://www.bicsa.com
7/2/2004 4:25 PM
Este mensaje puede ser confidencial. Si usted no es la persona a quien se debio 
dirigir por favor notifiquenos de inmediato y borre el mensaje. BICSA no acepta 
responsabilidad legal por ningun dano causado por virus, errores u omisiones en el 
contenido de este mensaje. Todo uso o divulgacion no autorizado esta prohibido. 
Gracias. 

This message may be confidential. If you are not the intended recipient, please notify 
us immediately and delete this message. BICSA does not accept liability for any damage 
caused by virus, errors, or omissions in the contents of this message. Any 
unauthorized use or disclosure of its contents is prohibited. Thank you. 

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.701 / Virus Database: 458 - Release Date: 07.06.2004
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.701 / Virus Database: 458 - Release Date: 07.06.2004
 


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to