aspose file tools
The moose likes Tomcat and the fly likes SQL Error suring server startup Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Products » Tomcat
Reply Bookmark "SQL Error suring server startup" Watch "SQL Error suring server startup" New topic
Author

SQL Error suring server startup

Ankur Sharma
Greenhorn

Joined: Nov 30, 2007
Posts: 21
posted private message
0
Quote
Hi,

I am using Eclipse, Java 5, Tomcat 5.5, MySQL and SQL Server 2005.

When I start the server I get this error in log file:

2007-12-04 11:40:59,155 INFO [OE-@HOSTNAME@] [/oe].log(647) | Loading Spring root WebApplicationContext
2007-12-04 11:41:01,452 INFO [OE-@HOSTNAME@] [/oe].log(647) | Initializing WebApplicationContext for Struts ActionServlet 'action', module ''
2007-12-04 11:41:02,249 ERROR [OE-@HOSTNAME@] [/oe].log(676) | action: null
org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1150)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:170)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:281)
at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:217)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
at $Proxy7.getPriorities(Unknown Source)
at org.benefitscheckup.oe.web.CachePlugin.init(CachePlugin.java:56)
at org.apache.struts.action.ActionServlet.initModulePlugIns(ActionServlet.java:869)
at org.apache.struts.action.ActionServlet.init(ActionServlet.java:336)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1139)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:966)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3956)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4230)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:448)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
Caused by: java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(Unknown Source)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1143)
... 29 more
2007-12-04 11:41:02,249 INFO [OE-@HOSTNAME@] [/oe].log(647) | Marking servlet action as unavailable
2007-12-04 11:41:02,249 ERROR [OE-@HOSTNAME@] [/oe].loadOnStartup(3958) | Servlet /oe threw load() exception
javax.servlet.UnavailableException
at org.apache.struts.action.ActionServlet.initModulePlugIns(ActionServlet.java:880)
at org.apache.struts.action.ActionServlet.init(ActionServlet.java:336)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1139)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:966)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3956)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4230)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:448)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)


I created another java class to test connection with database. The mysql is connecting fine but SQL Server is giving connection refuse error.

My sql server 2005 is running in Windows Authentication mode and as Local System,.

Please help.

Ankur
Joachim Rohde
Ranch Hand

Joined: Nov 27, 2006
Posts: 423

I like...
Netbeans IDE
posted private message
0
Quote
"Cannot create JDBC driver of class '' for connect URL 'null'"
Seems more like your configuration couldn't be loaded. Have you checked, that the configuration file can be found and loaded?
Ankur Sharma
Greenhorn

Joined: Nov 30, 2007
Posts: 21
posted private message
0
Quote
Yes actually I have all the jdbc drivers are in application build path as well as tomcat/commons/lib.
any idea? it's really weird error...
Joachim Rohde
Ranch Hand

Joined: Nov 27, 2006
Posts: 423

I like...
Netbeans IDE
posted private message
0
Quote
With 'configuration' I meant your definition of the datasource in your applicationcontext.xml (assuming you are using spring), something like:

If those values are correct and available to your application
jasson jasson
Greenhorn

Joined: Oct 20, 2007
Posts: 6
posted private message
0
Quote
i think you have some errors in your xml configuration,you may check the configuration in jdbc url
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 56227
    
  13

I like...
IntelliJ IDE jQuery Mac OSX
posted private message
0
Quote
"jasson jasson", having ignored three warnings to adjust your display name to JavaRanch standards, your account has been disabled. Should you wish to re-enable your account, you must contact me via email.

bear
JavaRanch sheriff

[Smart Questions] [JSP FAQ] [Books by Bear] [Bear's FrontMan] [About Bear]
Ankur Sharma
Greenhorn

Joined: Nov 30, 2007
Posts: 21
posted private message
0
Quote
Hi Joachem,

Thanks for your reply. Looks like your reply is bringing me closer to the solution.

Yes we are using Spring and iBatis.
Here is the sample entry from applicationContext-ibatis.xml:

<!-- Data Sources for database interactions: all JNDI currently -->
<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName">
<value>java:comp/env/jdbc/DBtest</value>
</property>
</bean>
Here is the entry in my server.xml:

<Resource auth="container" name="jdbc/DBtest" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/DBtest">
<parameter>
<name>driverClassName</name>
<value>com.mysql.jdbc.Driver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost/test</value>
</parameter>
<parameter>
<name>username</name>
<value>root</value>
</parameter>
<parameter>
<name>password</name>
<value>admin</value>
</parameter>
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>5</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>3</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
</ResourceParams>

Do you think if the entry in ibatis.xml has something wrong or mismatched?

Thanks,

Ankur
[ December 06, 2007: Message edited by: Ankur Sharma ]
Ankur Sharma
Greenhorn

Joined: Nov 30, 2007
Posts: 21
posted private message
0
Quote
I dont think its the problem with spring or iBATIS.

I created another project with just tomcat, eclipse, struts and mysql and i am getting the same error:

Server startup in 1515 ms
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1150)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at com.bcu.oe.action.TestAction.execute(TestAction.java:24)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: No suitable driver
at


Any idea?
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: SQL Error suring server startup
 
Similar Threads
Null Pointer Exception during Validation in Struts
Error in struts validator plug in
war on tomcat giving error
java.lang.ClassCastException: org.spring.....ContextLoaderPlugIn cannot be cast to ..action.PlugIn
strange error with respect to web.xml file