Subject get UnavailableDatabaseFileException when accessing to multiuser database
Author Mimi
Hi All,

I have problem with connecting *.gdb with java. I've downloaded Firebird
Interclient 2.01 from www.ibphoenix.com. I used interclient.jar and
jdbc2_0-stdex.jar as class paths at the client side, and installed
interclient at the server side. Then I want to connect to database at the
server computer, so I connect using these code :

try {
Class.forName(IB_DRIVER);
} catch (ClassNotFoundException e) {
log.debug(Trace.getStackTrace(e));
}
return
DriverManager.getConnection("jdbc:interbase://server-neo/e:/data/data.gdb",
"SYSDBA", "masterkey");

It's okay when there were not other application which is accessing to
e:/data/data.gdb. But when there are other application which is accessing
to e:/data/data.gdb, I got UnavailableDatabaseFilexception :

Error while trying to open file
unknown Win32 error 32

See API reference for exception
interbase.interclient.UnavailableDatabaseFileException
at
interbase.interclient.RecvMessage.createSQLException(RecvMessage.java:638)
at
interbase.interclient.RecvMessage.makeSQLException(RecvMessage.java:593)
at interbase.interclient.RecvMessage.get_EXCEPTIONS(RecvMessage.java:554)
at
interbase.interclient.Connection.remote_ATTACH_DATABASE(Connection.java:391)
at interbase.interclient.Connection.connect(Connection.java:331)
at interbase.interclient.Connection.<init>(Connection.java:285)
at interbase.interclient.Driver.connect(Driver.java:204)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at logging.Connect.ConnectToInsectisida(Connect.java:41)
at model.problem.Problem.checkAndInsertInsectisida(Problem.java:250)
at servlet.problem.UpdateProblem.addOrEdit(UpdateProblem.java:98)
at servlet.problem.UpdateProblem.processRequest(UpdateProblem.java:42)
at servlet.tools.MyServlet.doGet(MyServlet.java:62)
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.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(Unknown Source)


I've tried to solve this problem by connect with another port, but I don't
know how...
If I use jdbc:interbase://server-neo:3051/e:/data/data.gdb, the server
didn't response until timeout. I use JRE v. 1.5.

Can anyone help me please? Thanks in advance.



Regards,

Mimi


=====================================
All New ACCURATE V.3
Everything you may expect from
an Accounting Software now comes true
=====================================