Strut with MS Access
Hi,
I am trying to connect MS Access using strut framework.
But when I deploy application and start the tomcat server I get followiing Exception. Do anybody know why this is takeing place?/
Here is my strut-config.xml
<data-sources>
<data-source>
<set-property property="driverClass" value="sun.jdbc.odbc.JdbcOdbcDriver" />
<set-property property="description" value="" />
<set-property property="url" value="Jdbc:Odbc:Driver={Microsoft Access Driver (*.mdb)};C:/Documents and Settings/Prashant/My Documents/ExpenceManagerDB.mdb" />
</data-source>
</data-sources>
Exception
2007/06/13 12:00:38 org.apache.struts.action.ActionServlet initModuleDataSources
抳柦揑: Initializing application data source org.apache.struts.action.DATA_SOURCE
java.sql.SQLException: No data found
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7138)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3073)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:323)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)
at org.apache.struts.legacy.GenericDataSource.createConnection(GenericDataSource.java:805)
at org.apache.struts.legacy.GenericDataSource.open(GenericDataSource.java:741)
at org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.java:1085)
at org.apache.struts.action.ActionServlet.init(ActionServlet.java:472)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1161)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:981)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4042)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4348)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
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:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
2007/06/13 12:00:38 org.apache.catalina.core.ApplicationContext log
忣曬: 僒乕僽儗僢僩 action 傪棙梡晄壜擻偵儅乕僋偟傑偡
2007/06/13 12:00:38 org.apache.catalina.core.StandardContext loadOnStartup
抳柦揑: 僒乕僽儗僢僩 /ExpenceManager 偑load()椺奜傪搳偘傑偟偨
javax.servlet.UnavailableException: Initializing application data source org.apache.struts.action.DATA_SOURCE
at org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.java:1091)
at org.apache.struts.action.ActionServlet.init(ActionServlet.java:472)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1161)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:981)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4042)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4348)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
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:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
2007/06/13 12:00:42 org.apache.struts.util.PropertyMessageResources <init>
忣曬: Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true
2007/06/13 12:00:42 org.apache.struts.util.PropertyMessageResources <init>
忣曬: Initializing, config='org.apache.struts.action.ActionResources', returnNull=true
2007/06/13 12:00:42 org.apache.struts.util.PropertyMessageResources <init>
忣曬: Initializing, config='com.yourcompany.struts.ApplicationResources', returnNull=true
2007/06/13 12:00:42 org.apache.coyote.http11.Http11Protocol start
忣曬: Coyote HTTP/1.1傪 http-8080 偱婲摦偟傑偡
2007/06/13 12:00:43 org.apache.jk.common.ChannelSocket init
忣曬: JK: ajp13 listening on /0.0.0.0:8009
2007/06/13 12:00:43 org.apache.jk.server.JkMain start
忣曬: Jk running ID=0 time=0/90 config=null
2007/06/13 12:00:43 org.apache.catalina.startup.Catalina start
忣曬: Server startup in 22283 ms

