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

[7400 byte] By [prashantjangamea] at [2007-11-27 7:29:12]
# 1

I modfied strut-config.xml like follows

and added commons-dbcp-1.2.2.jar and commons-pool-1.3.jar to my application class path But now I am getting different exception on server start up Do anybody know why this is takeing place?/

Initializing application data source org.apache.struts.action.DATA_SOURCE

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (No data found)

at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)

at org.apache.commons.dbcp.BasicDataSource.setLogWriter(BasicDataSource.java:959)

at org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.java:1087)

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)

Caused by: 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.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)

at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)

at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)

at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)

... 30 more

2007/06/13 13:58:22 org.apache.catalina.core.ApplicationContext log

prashantjangamea at 2007-7-12 19:09:20 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...