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

2003-12-26 Thread Ricky Purnomo
Hello,

I am new to Struts, and am trying to deploy to Tomcat an application that
uses mySQL as database. However I am encountering the following errors:

2003-12-24 14:28:33 StandardWrapper[/necdcstruts1:action]: Marking servlet
action as unavailable
2003-12-24 14:28:33 StandardContext[/necdcstruts1]: Servlet /necdcstruts1
threw load() exception
javax.servlet.UnavailableException: Initializing application data source
org.apache.struts.action.DATA_SOURCE
 at
org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.j
ava:1091)
 at org.apache.struts.action.ActionServlet.init(ActionServlet.java:472)
 at javax.servlet.GenericServlet.init(GenericServlet.java:256)
 at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:93
5)
 at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:823)
 at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:
3422)
 at
org.apache.catalina.core.StandardContext.start(StandardContext.java:3623)
 at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:8
21)
 at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807)
 at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595)
 at
org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.j
ava:307)
 at org.apache.catalina.core.StandardHost.install(StandardHost.java:788)
 at
org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:559
)
 at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:401)
 at org.apache.catalina.startup.HostConfig.start(HostConfig.java:718)
 at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:358)
 at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSuppor
t.java:166)
 at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1196)
 at org.apache.catalina.core.StandardHost.start(StandardHost.java:754)
 at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188)
 at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:363)
 at org.apache.catalina.core.StandardService.start(StandardService.java:497)
 at org.apache.catalina.core.StandardServer.start(StandardServer.java:2190)
 at org.apache.catalina.startup.Catalina.start(Catalina.java:512)
 at org.apache.catalina.startup.Catalina.execute(Catalina.java:400)
 at org.apache.catalina.startup.Catalina.process(Catalina.java:180)
 at java.lang.reflect.Method.invoke(Native Method)
 at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203)

In addition to the standard jars I have put the following .jar's in
WEB-INF/lib :

commons-pool-1.1.jar
commons-dbcp-1.1.jar
mysql-connector-java-3.0.9-stable-bin.jar

but it doesn't seem to solve the problem. Please advise what else I can try
to identify and resolve the problem.

Thanks in advance,
Ricky Purnomo

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



javax.servlet.UnavailableException: Initializing application data source org.apache.struts.action.DATA_SOURCE

2002-05-13 Thread Anthony Martin

I'm attempting to use the new Firebird SQL Driver to access my Interbase
database.  I've been using InterClient, which is a Type III driver.
Firebird SQL Driver is Type IV, which is more desirable.

Here's information about the Firebird SQL Driver:
http://www.xlprueba.com.ar/marce/setup_fb_java.htm

I was hoping for a drop-in replacement for InterClient, but no such luck.
Here is my struts-config.xml DataSource node:

data-source key=DataSource.TEST0
set-property property=autoCommit value=false /
set-property property=description value=Demo DataBase /
set-property property=driverClass
value=org.firebirdsql.jdbc.FBDriverr /
set-property property=maxCount value=8 /
set-property property=minCount value=0 /
set-property property=url
value=jdbc:firebirdsql:localhost/3050:c:/progra~1/trams/database/demodata.g
db /
set-property property=user value=SYSDBA /
set-property property=password value=masterkey /
/data-source
data-source key=DataSource.TEST1
set-property property=autoCommit value=false /
set-property property=description value=Demo DataBase /
set-property property=driverClass
value=interbase.interclient.Driver /
set-property property=maxCount value=8 /
set-property property=minCount value=0 /
set-property property=url
value=jdbc:interbase://localhost/c:/progra~1/trams/database/demodata.gdb
/
set-property property=user value=SYSDBA /
set-property property=password value=masterkey /
/data-source

I can use TEST1 just fine.  But the startup phase yields the following stack
trace:

javax.servlet.UnavailableException: Initializing application data source
DataSource.TEST0
at
org.apache.struts.action.ActionServlet.initApplicationDataSources(ActionServ
let.java:850)
at
org.apache.struts.action.ActionServlet.init(ActionServlet.java:419)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
.
.
.

I've already tested the Firebird SQL Driver outside Struts.  They have a
demonstration on their web site, and it does indeed work by itself.  I just
can't embed it here.


Anthony

--
To unsubscribe, e-mail:   mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL PROTECTED]