Java Mailing List Archive

http://www.junlu.com/

Home » Home (12/2007) » Tomcat Users »

RE: Please help, I have a headache .. servlet init troubles

Edson Alves Pereira

2004-01-19


 To solve your problem with JDBC Driver, you must put the JDBC driver
inside $TOMCAT_HOME/common/lib, try this first the other errors we will see
if happens again.

> ----------
> De:  Allistair Crossley[SMTP:Allistair.Crossley@(protected)]
> Responder:  Tomcat Users List
> Enviada:  segunda-feira, 19 de janeiro de 2004 12:56
> Para:  TOMCAT USER (E-mail)
> Assunto:  Please help, I have a headache .. servlet init troubles
>
> I am having the biggest headache ever with this. When I start Tomcat
>
> 1) Why is my controller servlet always initialised twice?? That is, as
> soon as all my logging has finished for one init, it all comes out again a
> second time!
>
> 2) In the init I get the following error when it tries to look at my JNDI
> datasource...
>
> 2004-01-19 15:35:28,764 INFO
> com.qas.newmedia.intranet.iq.IQActionServlet.init(Unknown Source) :
> dataSource: done
>
> 2004-01-19 15:35:28,764 ERROR
> com.qas.newmedia.intranet.iq.IQActionServlet.init(Unknown Source) : Init
> could not acquire connection from DataSource:
> org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of
> class '' for connect URL 'null', cause: null Cannot create JDBC driver of
> class '' for connect URL 'null'
>
> Yet shortly after it seems to have found my datasource perfectly ok
> because calls work...
>
> 2004-01-19 15:36:44,828 DEBUG
> com.qas.newmedia.intranet.iq.base.navigation.NavigationManager.init(Unknow
> n Source) : CONNECTIOINIT
> org.apache.commons.dbcp.PoolableConnection@(protected)
>
> My JNDI resouce is below (clearly a URL DOES exist).
>
> Thank you all! ADC
>
> -- snip --
>
>
>      <Resource name="jdbc/iqdb" auth="Container"
> type="javax.sql.DataSource"/>
>
>      <ResourceParams name="jdbc/iqdb">        
>        <parameter>        
>         <name>factory</name>        
>  
> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>        
>        </parameter>        
>        <parameter>        
>          <name>driverClassName</name>
>
>  
> <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>        
>        </parameter>        
>        <parameter>        
>            <name>url</name>        
>  
> <value>jdbc:microsoft:sqlserver://server:1433</value>        
>        </parameter>        
>        <parameter>        
>          <name>username</name>        
>          <value>sa</value>      
>          </parameter>        
>          <parameter>        
>          <name>password</name>        
>          <value>pass</value>        
>          </parameter>        
>          <parameter>        
>          <name>maxActive</name>        
>          <value>50</value>        
>          </parameter>        
>          <parameter>        
>          <name>maxIdle</name>        
>          <value>10</value>        
>          </parameter>        
>          <parameter>        
>          <name>maxWait</name>        
>          <value>10000</value>        
>          </parameter>
>                      <parameter>
>                       <name>validationQuery</name>
>                       <value>SELECT 1 + 1</value>
>                      </parameter>
>
> <parameter><name>logAbandoned</name><value>true</value></parameter>
>
> <parameter><name>removeAbandoned</name><value>true</value></parameter>
>
>
> <FONT SIZE=1 FACE="VERDANA,ARIAL" COLOR=BLUE>
> -------------------------------------------------------
> QAS Ltd.
> Developers of QuickAddress Software
> <a href="http://www.qas.com">www.qas.com</a>
> Registered in England: No 2582055
> Registered in Australia: No 082 851 474
> -------------------------------------------------------
> </FONT>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
> For additional commands, e-mail: tomcat-user-help@(protected)
>
©2008 junlu.com - Jax Systems, LLC, U.S.A.