| Subject | Re: Configuring Tomcat JNDI and Firebird |
|---|---|
| Author | grndeveloper |
| Post date | 2006-10-18T09:53:44Z |
Hi Rick,
I write again the email...
From your answer I initially thought that it was and Ibatis problem,
because I got no error when starting tomcat, but I think that with
your test the problem still is the datasource configuration.
I have tested what you told me and these are the results.
I have one application with only these files:
- web.xml
- context.xml
- prova.jsp
The file prova.jsp is a copy of your example:
<<<<<<<<<<<<<<<<<
<%@ page import="javax.naming.Context"%>
<%@ page import="javax.naming.InitialContext"%>
<%@ page import="javax.sql.DataSource"%>
<%@ page import="java.io.IOException"%>
<%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.SQLException"%>
<%
DataSource ds=null;
Connection connRSFind=null;
String resp="";
try
{
Context ctx = new InitialContext();
if(ctx == null )
throw new Exception("Boom - No Context");
ds = (DataSource)ctx.lookup("java:comp/env/jdbc/link_to_sg2_bbdd");
try
{
connRSFind = ds.getConnection();
resp = "no error" ;
}
catch (SQLException e)
{
resp = "getting new data source connection failed! Error: "+e+"\n";
}
}
catch (Exception e)
{
resp = "Could Not get data source, error: "+e+"\n";
}
%>
<html xmlns="http://www.w3.org/1999/xhtml" lang="es" xml:lang="es">
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<head>
<link rel="stylesheet" type="text/css" href="<html:rewrite
forward="DisplayTableCSS"/>">
<title>Ficha</title>
</head>
<body>
<table width="100%" align="center">
<tr>
<td align="center">
<%=resp%>
</td>
</tr>
</table>
</body>
</html>
getting new data source connection failed! Error:
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC
driver of class '' for connect URL 'null'
Here are the tomcat logs:
catalina.out
<<<<<<<<<<<<<<<<<<
18/10/2006 10:55:59 org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
18/10/2006 10:55:59 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1017 ms
18/10/2006 10:55:59 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
18/10/2006 10:55:59 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.9
18/10/2006 10:55:59 org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
18/10/2006 10:56:01 org.displaytag.filter.ResponseOverrideFilter init
INFO: Filter initialized. Response buffering is enabled
18/10/2006 10:56:02 org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
18/10/2006 10:56:02 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
18/10/2006 10:56:02 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/57 config=null
18/10/2006 10:56:02 org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
18/10/2006 10:56:02 org.apache.catalina.startup.Catalina start
INFO: Server startup in 3469 ms
18/10/2006 10:57:35 org.displaytag.filter.ResponseOverrideFilter init
INFO: Filter initialized. Response buffering is enabled
<<<<<<<<<<<<<<<<<<<<<<<
18/10/2006 10:56:01 org.apache.catalina.core.ApplicationContext log
SEVERE: StandardWrapper.Throwable
java.lang.NullPointerException
at
org.apache.struts.action.ActionServlet.parseModuleConfigFile(ActionServlet.java:705)
at
org.apache.struts.action.ActionServlet.initModuleConfig(ActionServlet.java:670)
at org.apache.struts.action.ActionServlet.init(ActionServlet.java:329)
at javax.servlet.GenericServlet.init(GenericServlet.java:211)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1091)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:925)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3857)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4118)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
at
org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:589)
at
org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:536)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:471)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1102)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
at
org.apache.catalina.core.StandardService.start(StandardService.java:450)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:683)
at org.apache.catalina.startup.Catalina.start(Catalina.java:537)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)
18/10/2006 10:56:01 org.apache.catalina.core.StandardContext loadOnStartup
SEVERE: Servlet /prova threw load() exception
java.lang.NullPointerException
at
org.apache.struts.action.ActionServlet.parseModuleConfigFile(ActionServlet.java:705)
at
org.apache.struts.action.ActionServlet.initModuleConfig(ActionServlet.java:670)
at org.apache.struts.action.ActionServlet.init(ActionServlet.java:329)
at javax.servlet.GenericServlet.init(GenericServlet.java:211)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1091)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:925)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3857)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4118)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
at
org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:589)
at
org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:536)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:471)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1102)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
at
org.apache.catalina.core.StandardService.start(StandardService.java:450)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:683)
at org.apache.catalina.startup.Catalina.start(Catalina.java:537)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)
18/10/2006 10:56:02 org.apache.catalina.core.ApplicationContext log
INFO: org.apache.webapp.balancer.BalancerFilter: init(): ruleChain:
[org.apache.webapp.balancer.RuleChain:
[org.apache.webapp.balancer.rules.URLStringMatchRule: Target string:
News / Redirect URL: http://www.cnn.com],
[org.apache.webapp.balancer.rules.RequestParameterRule: Target param
name: paramName / Target param value: paramValue / Redirect URL:
http://www.yahoo.com],
[org.apache.webapp.balancer.rules.AcceptEverythingRule: Redirect URL:
http://jakarta.apache.org]]
18/10/2006 10:56:02 org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
18/10/2006 10:56:02 org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextInitialized()
18/10/2006 10:56:02 org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
18/10/2006 10:56:02 org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextInitialized()
18/10/2006 10:57:35 org.apache.catalina.core.ApplicationContext log
SEVERE: StandardWrapper.Throwable
java.lang.NullPointerException
at
org.apache.struts.action.ActionServlet.parseModuleConfigFile(ActionServlet.java:705)
at
org.apache.struts.action.ActionServlet.initModuleConfig(ActionServlet.java:670)
at org.apache.struts.action.ActionServlet.init(ActionServlet.java:329)
at javax.servlet.GenericServlet.init(GenericServlet.java:211)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1091)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:925)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3857)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4118)
at
org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1175)
at
org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:510)
at
org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:104)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
18/10/2006 10:57:35 org.apache.catalina.core.StandardContext loadOnStartup
SEVERE: Servlet /prova threw load() exception
java.lang.NullPointerException
at
org.apache.struts.action.ActionServlet.parseModuleConfigFile(ActionServlet.java:705)
at
org.apache.struts.action.ActionServlet.initModuleConfig(ActionServlet.java:670)
at org.apache.struts.action.ActionServlet.init(ActionServlet.java:329)
at javax.servlet.GenericServlet.init(GenericServlet.java:211)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1091)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:925)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3857)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4118)
at
org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1175)
at
org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:510)
at
org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:104)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
wrote:
I write again the email...
From your answer I initially thought that it was and Ibatis problem,
because I got no error when starting tomcat, but I think that with
your test the problem still is the datasource configuration.
I have tested what you told me and these are the results.
I have one application with only these files:
- web.xml
- context.xml
- prova.jsp
The file prova.jsp is a copy of your example:
<<<<<<<<<<<<<<<<<
<%@ page import="javax.naming.Context"%>
<%@ page import="javax.naming.InitialContext"%>
<%@ page import="javax.sql.DataSource"%>
<%@ page import="java.io.IOException"%>
<%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.SQLException"%>
<%
DataSource ds=null;
Connection connRSFind=null;
String resp="";
try
{
Context ctx = new InitialContext();
if(ctx == null )
throw new Exception("Boom - No Context");
ds = (DataSource)ctx.lookup("java:comp/env/jdbc/link_to_sg2_bbdd");
try
{
connRSFind = ds.getConnection();
resp = "no error" ;
}
catch (SQLException e)
{
resp = "getting new data source connection failed! Error: "+e+"\n";
}
}
catch (Exception e)
{
resp = "Could Not get data source, error: "+e+"\n";
}
%>
<html xmlns="http://www.w3.org/1999/xhtml" lang="es" xml:lang="es">
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<head>
<link rel="stylesheet" type="text/css" href="<html:rewrite
forward="DisplayTableCSS"/>">
<title>Ficha</title>
</head>
<body>
<table width="100%" align="center">
<tr>
<td align="center">
<%=resp%>
</td>
</tr>
</table>
</body>
</html>
>>>>>>>>>>>>>>>>>The message I get when I execute the application is:
getting new data source connection failed! Error:
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC
driver of class '' for connect URL 'null'
Here are the tomcat logs:
catalina.out
<<<<<<<<<<<<<<<<<<
18/10/2006 10:55:59 org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
18/10/2006 10:55:59 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1017 ms
18/10/2006 10:55:59 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
18/10/2006 10:55:59 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.9
18/10/2006 10:55:59 org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
18/10/2006 10:56:01 org.displaytag.filter.ResponseOverrideFilter init
INFO: Filter initialized. Response buffering is enabled
18/10/2006 10:56:02 org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
18/10/2006 10:56:02 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
18/10/2006 10:56:02 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/57 config=null
18/10/2006 10:56:02 org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
18/10/2006 10:56:02 org.apache.catalina.startup.Catalina start
INFO: Server startup in 3469 ms
18/10/2006 10:57:35 org.displaytag.filter.ResponseOverrideFilter init
INFO: Filter initialized. Response buffering is enabled
>>>>>>>>>>>>>>>>>>>>localhost.2006-10-18.log
<<<<<<<<<<<<<<<<<<<<<<<
18/10/2006 10:56:01 org.apache.catalina.core.ApplicationContext log
SEVERE: StandardWrapper.Throwable
java.lang.NullPointerException
at
org.apache.struts.action.ActionServlet.parseModuleConfigFile(ActionServlet.java:705)
at
org.apache.struts.action.ActionServlet.initModuleConfig(ActionServlet.java:670)
at org.apache.struts.action.ActionServlet.init(ActionServlet.java:329)
at javax.servlet.GenericServlet.init(GenericServlet.java:211)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1091)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:925)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3857)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4118)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
at
org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:589)
at
org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:536)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:471)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1102)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
at
org.apache.catalina.core.StandardService.start(StandardService.java:450)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:683)
at org.apache.catalina.startup.Catalina.start(Catalina.java:537)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)
18/10/2006 10:56:01 org.apache.catalina.core.StandardContext loadOnStartup
SEVERE: Servlet /prova threw load() exception
java.lang.NullPointerException
at
org.apache.struts.action.ActionServlet.parseModuleConfigFile(ActionServlet.java:705)
at
org.apache.struts.action.ActionServlet.initModuleConfig(ActionServlet.java:670)
at org.apache.struts.action.ActionServlet.init(ActionServlet.java:329)
at javax.servlet.GenericServlet.init(GenericServlet.java:211)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1091)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:925)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3857)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4118)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
at
org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:589)
at
org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:536)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:471)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1102)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
at
org.apache.catalina.core.StandardService.start(StandardService.java:450)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:683)
at org.apache.catalina.startup.Catalina.start(Catalina.java:537)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)
18/10/2006 10:56:02 org.apache.catalina.core.ApplicationContext log
INFO: org.apache.webapp.balancer.BalancerFilter: init(): ruleChain:
[org.apache.webapp.balancer.RuleChain:
[org.apache.webapp.balancer.rules.URLStringMatchRule: Target string:
News / Redirect URL: http://www.cnn.com],
[org.apache.webapp.balancer.rules.RequestParameterRule: Target param
name: paramName / Target param value: paramValue / Redirect URL:
http://www.yahoo.com],
[org.apache.webapp.balancer.rules.AcceptEverythingRule: Redirect URL:
http://jakarta.apache.org]]
18/10/2006 10:56:02 org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
18/10/2006 10:56:02 org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextInitialized()
18/10/2006 10:56:02 org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
18/10/2006 10:56:02 org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextInitialized()
18/10/2006 10:57:35 org.apache.catalina.core.ApplicationContext log
SEVERE: StandardWrapper.Throwable
java.lang.NullPointerException
at
org.apache.struts.action.ActionServlet.parseModuleConfigFile(ActionServlet.java:705)
at
org.apache.struts.action.ActionServlet.initModuleConfig(ActionServlet.java:670)
at org.apache.struts.action.ActionServlet.init(ActionServlet.java:329)
at javax.servlet.GenericServlet.init(GenericServlet.java:211)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1091)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:925)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3857)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4118)
at
org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1175)
at
org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:510)
at
org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:104)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
18/10/2006 10:57:35 org.apache.catalina.core.StandardContext loadOnStartup
SEVERE: Servlet /prova threw load() exception
java.lang.NullPointerException
at
org.apache.struts.action.ActionServlet.parseModuleConfigFile(ActionServlet.java:705)
at
org.apache.struts.action.ActionServlet.initModuleConfig(ActionServlet.java:670)
at org.apache.struts.action.ActionServlet.init(ActionServlet.java:329)
at javax.servlet.GenericServlet.init(GenericServlet.java:211)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1091)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:925)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3857)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4118)
at
org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1175)
at
org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:510)
at
org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:104)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>><--- In Firebird-Java@yahoogroups.com, "grndeveloper" <developer@...>
wrote:
>your
> Hi Rick,
>
> I replied your message yestarday, but it seems that didn't reach
> the mailing list.
>
> Do you Know how can I contact the responsible of this mailing list
> to see if something wrong has happened with the message. Otherwise I
> will have to write it again...
>
> Thanks.
>
> --- In Firebird-Java@yahoogroups.com, Rick Fincher <rnf@> wrote:
> >
> > Hi,
> >
> > You still need the resource-ref in WEBB.xml. The context stuff just
> > sets up the Tomcat server. The WEB.xml stuff sets up your web app to
> > connect to the data source from the Tomcat server's context.
> >
> > It looks as though Tomcat is unable to load the driver. This doesn't
> > make sense if you are able to create the data source from the Admin
> > Tool, because Tomcat has to load the driver then or it can't create
> the
> > data source to begin with.
> >
> > Is the exception being thrown in the Ibatis code or when the Tomcat
> starts?
> >
> > Try starting with a clean log file directory, starting Tomcat with
> > data source, but without running the app. Check to see if you get anfrom the
> > error in the log. If not, it would indicate a problem in Ibatis.
> >
> > Also try starting a simple web app that just gets a connection
> > Tomcat Data Source, no Ibatis or anything else, just get a connection.mistake.
> >
> > A JSP wth the following is an example:
> >
> > // Get a connection to the database from the dataSource.
> > DataSource ds=null;
> > Connection connRSFind=null;
> >
> > try
> > {
> > Context ctx = new InitialContext();
> >
> > if(ctx == null )
> > throw new Exception("Boom - No Context");
> >
> > ds = (DataSource)ctx.lookup("java:comp/env/jdbc/link_to_sg2_bbdd");
> >
> > try
> > {
> > connRSFind = ds.getConnection();
> > }
> > catch (SQLException e)
> > {
> > System.out.println("getting new data source connection failed!
> > Error: "+e+"\n");
> > }
> >
> > }
> > catch (Exception e)
> > {
> > System.out.println("Could Not get data source, error: "+e+"\n");
> > }
> >
> >
> > If that works, it would indicate a problem with the Ibatis setup.
> >
> > If you get erors with a smple connection, post the entire stack
> trace so
> > we can narrow down the problem.
> >
> > Rick
> >
> > grndeveloper wrote:
> >
> > > Hello Rick,
> > >
> > > I think I have implemented your solution, but I get the same
> > >me the
> > > I have created a Datasource from Tomcat Administration, and I have
> > > not modified it manually. Now it looks like:
> > >
> > > <Resource
> > > name="sg2_bbdd"
> > > type="javax.sql.DataSource"
> > > password="masterkey"
> > > driverClassName="org.firebirdsql.jdbc.FBDriver"
> > > maxIdle="2"
> > > maxWait="5000"
> > > validationQuery="select cast(1 as integer) from rdb$database"
> > > username="sysdba"
> > > url="jdbc:firebirdsql:192.168.2.2/3050:home/sg2/sg2JAVA.fdb"
> > > maxActive="5"/>
> > >
> > > I have created a new file /META-INF/context.xml which generates
> > > file /conf/Catalina/localhost/jaume1.xml , which looks like:file, but
> > >
> > > <Context docBase="jaume1" path="/jaume1" >
> > > <ResourceLink name="link_to_sg2_bbdd"
> > > global="sg2_bbdd" type="javax.sql.DataSource"/>
> > > </Context>
> > >
> > > Besides that I also have this portion of code in the web.xml
> > > I guess it's not necessary.should
> > >
> > > <resource-ref>
> > > <res-ref-name>jdbc/link_to_sg2_bbdd</res-ref-name>
> > > <res-type>javax.sql.DataSource</res-type>
> > > <res-auth>Container</res-auth>
> > > <res-sharing-scope>Shareable</res-sharing-scope>
> > > </resource-ref>
> > >
> > > Is there anything else, that I am missing?
> > >
> > > Thanks in advance.
> > >
> > > --- In Firebird-Java@yahoogroups.com
> > > <mailto:Firebird-Java%40yahoogroups.com>, Rick Fincher <rnf@> wrote:
> > > >
> > > > Hi,
> > > >
> > > > With Tomcat 5.5.x you should not be modifying the server.xml
> file. Go
> > > > into the tomcat administrator application and create your data
> sources
> > > > there. The administrator app has a link on the Tomcat splash page.
> > > >
> > > > In the <CATALINA_HOME>/conf/Catalina/localhost directory you
> > > seeadd or
> > > > an XML file with the name of your web app. If you do not, your
> context
> > > > is not set up properly.
> > > >
> > > > This file gets generated by Tomcat from your context.xml file
> that is
> > > > located in the META-INF folder of your web application.
> > > >
> > > > It should look something like this:
> > > >
> > > > <Context docBase="webAppName" path="/webAppName" >
> > > > <ResourceLink name="jdbc/yourDataSourceName"
> > > > global="jdbc/yourDataSourceName" type="javax.sql.DataSource"/>
> > > > </Context>
> > > >
> > > > There should be a resource link for each data source you want to
> use.
> > > >
> > > > By doing things this way, Tomcat can launch your web apps and
> > > > drop data sources without restarting Tomcat and disruptingeverybody
> > > > elses web apps.whatever
> > > >
> > > > Put your server.xml file back to the default and restart Tomcat.
> Then
> > > > go in the administrator to create your Data Sources. A good
> validation
> > > > query for Firebird is: SELECT CAST(1 AS INTEGER) FROM
> rdb$database. It
> > > > should always work.
> > > >
> > > > Check to be sure your context.xml file for your web app got
> created as
> > > > described above.
> > > >
> > > > Your username will have to be listed as an administrator in
> > > > login database scheme you are using (tomcat-users.xml, etc.) for2.1.0 with
> you to
> > > > have access to the administrator application.
> > > >
> > > > Hope this helps!
> > > >
> > > > Rick
> > > >
> > > > grndeveloper wrote:
> > > >
> > > > > We are on Tomcat version 5.5.9 and we are using Jaybird
> > > IBATIS.following
> > > > > We have IBATIS working in a simple DATASOURCE configuration,
> and now
> > > > > we are trying to configure our application to use JNDI and
> connection
> > > > > pooling.
> > > > >
> > > > >
> > > > > We have made this modifications in the following files:
> > > > >
> > > > > >>>>server.xml >>>>>>>>
> > > > > ...
> > > > > <GlobalNamingResources>
> > > > > ...
> > > > > <Resource name="sg2_bbdd" auth="Container"
> > > > > type="javax.sql.DataSource"/>
> > > > > <ResourceParams name="sg2_bbdd">
> > > > > <parameter>
> > > > > <name>validationQuery</name>
> > > > > <value>select x_idio.idio_codi from x_idio</value>
> > > > > </parameter>
> > > > > <parameter>
> > > > > <name>maxWait</name>
> > > > > <value>5000</value>
> > > > > </parameter>
> > > > > <parameter>
> > > > > <name>maxActive</name>
> > > > > <value>10</value>
> > > > > </parameter>
> > > > > <parameter>
> > > > > <name>username</name>
> > > > > <value>sysdba</value>
> > > > > </parameter>
> > > > > <parameter>
> > > > > <name>password</name>
> > > > > <value>masterkey</value>
> > > > > </parameter>
> > > > > <parameter>
> > > > > <parameter>
> > > > > <name>url</name>
> > > > >
> > > > >
> <value>jdbc:firebirdsql:192.168.2.2/3050:home/sg2/sg2JAVA.fdb</value>
> > > > > </parameter>
> > > > > <parameter>
> > > > > <name>driverClassName</name>
> > > > > <value>org.firebirdsql.jdbc.FBDriver</value>
> > > > > </parameter>
> > > > > <parameter>
> > > > > <name>maxIdle</name>
> > > > > <value>5</value>
> > > > > </parameter>
> > > > > </ResourceParams>
> > > > > </GlobalNamingResources>
> > > > > ...
> > > > > <Host
> > > > > appBase="webapps"
> > > > > name="localhost">
> > > > > <DefaultContext>
> > > > > <ResourceLink
> > > > > global="sg2_bbdd"
> > > > > name="jdbc/link_to_sg2_bbdd"
> > > > > type="javax.sql.DataSource"/>
> > > > > </DefaultContext>
> > > > > </Host>
> > > > >
> > > > >
> > > > > >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
> > > > >
> > > > > >>>web.xml >>>>>>>>
> > > > > .....
> > > > > <resource-ref>
> > > > > <res-ref-name>jdbc/link_to_sg2_bbdd</res-ref-name>
> > > > > <res-type>javax.sql.DataSource</res-type>
> > > > > <res-auth>Container</res-auth>
> > > > > <res-sharing-scope>Shareable</res-sharing-scope>
> > > > > </resource-ref>
> > > > > .....
> > > > > >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
> > > > >
> > > > > >>>>sql-map-config.xml (Ibatis configuration
> > > > > file)>>>>>>>>>>>>>>>>>>>>>>>>
> > > > >
> > > > > ....
> > > > > <transactionManager type="JDBC">
> > > > > <dataSource type="JNDI">
> > > > > <property value="java:comp/env/jdbc/link_to_sg2_bbdd"
> > > > > name="DataSource"/>
> > > > > </dataSource>
> > > > > </transactionManager>
> > > > > ....
> > > > > >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
> > > > >
> > > > > We also have put the jaybird-full-2.1.0.jar into the
> > > > > [CATALINA_HOME]/common/lib directory. In our application there
> is no
> > > > > reference to jaybird-full-2.1.0.jar
> > > > >
> > > > > With all this changes all we get from Tomcat logs is the
> > > > > error message:create JDBC
> > > > > org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
> > > > > driver of class '' for connect URL 'null'
> > > > > ...
> > > > > Caused by: java.sql.SQLException: No suitable driver"
> > > > > ...
> > > > >
> > > > > I think the problem we have has nothing to do with IBATIS, it
> is just
> > > > > we are doing something wrong with the driver or the tomcat
> > > configuration.
> > > > > Does anyone could give us some help?
> > > > >
> > > > > Thanks in advance.
> > > > >
> > > > > _
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>