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:[EMAIL PROTECTED] 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:[EMAIL 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 > [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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
