tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Allistair Crossley" <Allistair.Cross...@QAS.com>
Subject RE: Please help, I have a headache .. servlet init troubles
Date Mon, 19 Jan 2004 16:35:19 GMT
Hi,

Yes I have the jdbc driver in common/lib - like I say ... it "does" connect but I do not know
why it gives this error!

I just removed trying to get the JNDI data source in my controller servlet init() and moved
it to the classes that need a connection. There are now no errors. Therefore it seems almost
that init() is too quick to try and get the JNDI resource before it has managed to load the
servlet.xml??

Do you know why my servlet initalises twice? That's my remaining issue..

Cheers, ADC

-----Original Message-----
From: Edson Alves Pereira [mailto:eapereira@panamericano.com.br]
Sent: 19 January 2004 17:22
To: 'Tomcat Users List'
Subject: RE: Please help, I have a headache .. servlet init troubles


	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@QAS.com]
> 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@1873eb2
> 
> 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@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> 

---------------------------------------------------------------------
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