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(Unknown Source) : 
CONNECTIOINIT [EMAIL 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to