Hello,

I am getting a strange error "cannot attach to password database" intermittently. The stack trace is listed below.

We are using firebird 2.1.3 with jaybird 2.1.6 driver. The application is a web app using hibernate, tomcat.

Has anyone experienced this before can you please help ? We have been using firebird for quite a while now and have never seen this error.

The firebird.log says
--------------------------------------------------------------
DELTA02 Tue Nov 03 18:31:09 2009
Database: C:\PROGRAM Files\FIREBIRD\SECURITY2.FDB
page 0, page type 1 lock conversion denied (215)
DELTA02 Tue Nov 03 18:31:09 2009
deadlock
DELTA02 Tue Nov 03 18:31:09 2009
page 0, page type 1 lock conversion denied
--------------------------------------------------------------


Stack trace:
-----------

Reason: cannot attach to password database; nested exception is org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544653. cannot attach to password database
Reason: cannot attach to password database
Caused by:
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [HY000]; error code [335544653]; GDS Exception. 335544653. cannot attach to password database
Reason: cannot attach to password database; nested exception is org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544653. cannot attach to password database
Reason: cannot attach to password database
Caused by:
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544653. cannot attach to password database
Reason: cannot attach to password database
at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:122)
at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:131)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771)

Thanks
JD