Helpful Information
 
 
Category: Firebird SQL Development
Connection problem Struts - Firebird

Hello,
Im not able to get a connection to firebird over Struts 1.1. The servlet engine is tomcat-4.1.27.
The sample shows the data souce configuration in the struts-config.xml. I use the newest jdbc firebirdsql-full.jar.

<data-sources>
<data-source>
<set-property property="autoCommit" value="true" />
<set-property property="description" value="Manager DB Connection" />
<set-property property="driverClass" value="org.firebirdsql.jdbc.FBDriver" />
<set-property property="maxCount" value="4" />
<set-property property="minCount" value="2" />
<set-property property="password" value="sysdba" />
<set-property property="url" value="jdbc:firebirdsql:localhost/3050:D:/Projekte/Manager.GDB" />
<set-property property="user" value="masterkey" />
</data-source>
</data-sources>


here is the error log:

2003-09-04 20:43:25 StandardManager[]: Seeding random number generator class java.security.SecureRandom
2003-09-04 20:43:25 StandardManager[]: Seeding of random number generator has been completed
2003-09-04 20:43:28 StandardWrapper[:action]: Marking servlet action as unavailable
2003-09-04 20:43:28 StandardContext[]: Servlet threw load() exception
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:256)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:935)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:823)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3421)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:3609)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:738)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:347)
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 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:324)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203)

Has anyone an idea????

thanks
Frank

<set-property property="password" value="sysdba" />
<set-property property="url" value="jdbc:firebirdsql:localhost/3050:/Projekte/Manager.GDB" />
<set-property property="user" value="masterkey" />

What i see wrong is that
password is sysdba
and user masterkey .
It should be like this
user :sysdba
password:masterkey

Try it and tell me the results...

You are sure that user=masterkey and password=sysdba?










privacy (GDPR)