Ticket #61 (closed defect: fixed)

Opened 2 years ago

Last modified 2 years ago

Photovault crashes if user enters username/password for Derby

Reported by: harri Owned by: harri
Priority: blocker Milestone: 0.4.0
Component: common Version: 0.3.1
Keywords: Cc:
Test Case Result:

Description

Reported by jomcmanus@…

Exception message: 

     [java] 0    [main] ERROR org.apache.ojb.broker.accesslayer.StatementsForClassImpl  -
     [java] * Can't prepare statement:
     [java] * sql statement was 'SELECT A0.collection_id,A0.collection_name,A0.COLLECTION_DESC,A0.parent FROM photo_collections A0 WHERE A0.collection_id = ?'
     [java] * Exception message is [Schema 'HARRI' does not exist]
     [java] * Vendor error code [30000]
     [java] * SQL state code [42Y07]
     [java] * The root stack trace is -->
     [java] * ERROR 42Y07: Schema 'HARRI' does not exist
     [java]     at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
     [java]     at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getSchemaDescriptor(Unknown Source)
     [java]     at org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(Unknown Source)
     [java]     at org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(Unknown Source)
     [java]     at org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(Unknown Source)
     [java]     at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(Unknown Source)
     [java]     at org.apache.derby.impl.sql.compile.FromList.bindTables(Unknown Source)
     [java]     at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(Unknown Source)
     [java]     at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(Unknown Source)
     [java]     at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
     [java]     at org.apache.derby.impl.sql.compile.ReadCursorNode.bind(Unknown Source)
     [java]     at org.apache.derby.impl.sql.compile.CursorNode.bind(Unknown Source)
     [java]     at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
     [java]     at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
     [java]     at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
     [java]     at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
     [java]     at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
     [java]     at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
     [java]     at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source)
     [java]     at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
     [java]     at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
     [java]     at org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatement(Unknown Source)
     [java]     at org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getPreparedStmt(Unknown Source)
     [java]     at org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(Unknown Source)
     [java]     at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown Source)
     [java]     at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(Unknown Source)
     [java]     at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown Source)
     [java]     at org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknown Source)
     [java]     at org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unknown Source)
     [java]     at org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unknown Source)
     [java]     at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown Source)
     [java]     at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown Source)
     [java]     at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknown Source)
     [java]     at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(Unknown Source)
     [java]     at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(Unknown Source)
     [java]     at org.apache.ojb.odmg.oql.OQLQueryImpl.execute(Unknown Source)
     [java]     at org.photovault.folder.PhotoFolder.getRoot(PhotoFolder.java:444)
     [java]     at org.photovault.dbhelper.ODMG.initODMG(ODMG.java:149)
     [java]     at org.photovault.swingui.Photovault.login(Photovault.java:68)
     [java]     at org.photovault.swingui.Photovault.run(Photovault.java:130)
     [java]     at org.photovault.swingui.Photovault.main(Photovault.java:176)

     [java] **
     [java] 7    [main] ERROR org.apache.ojb.broker.accesslayer.JdbcAccessImpl  - PersistenceBrokerException during the execution of the query:
     [java] * Can't prepare statement:
     [java] * sql statement was 'SELECT A0.collection_id,A0.collection_name,A0.COLLECTION_DESC,A0.parent FROM photo_collections A0 WHERE A0.collection_id = ?'
     [java] * Exception message is [Schema 'HARRI' does not exist]
     [java] * Vendor error code [30000]
     [java] * SQL state code [42Y07]
     [java] org.apache.ojb.broker.PersistenceBrokerSQLException:
     [java] * Can't prepare statement:
     [java] * sql statement was 'SELECT A0.collection_id,A0.collection_name,A0.COLLECTION_DESC,A0.parent FROM photo_collections A0 WHERE A0.collection_id = ?'
     [java] * Exception message is [Schema 'HARRI' does not exist]
     [java] * Vendor error code [30000]
     [java] * SQL state code [42Y07]
     [java]     at org.apache.ojb.broker.util.ExceptionHelper.generateException(Unknown Source)
     [java]     at org.apache.ojb.broker.util.ExceptionHelper.generateException(Unknown Source)
     [java]     at org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getPreparedStmt(Unknown Source)
     [java]     at org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(Unknown Source)
     [java]     at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown Source)
     [java]     at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(Unknown Source)
     [java]     at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown Source)
     [java]     at org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknown Source)
     [java]     at org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unknown Source)
     [java]     at org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unknown Source)
     [java]     at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown Source)
     [java]     at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown Source)
     [java]     at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknown Source)
     [java]     at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(Unknown Source)
     [java]     at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(Unknown Source)
     [java]     at org.apache.ojb.odmg.oql.OQLQueryImpl.execute(Unknown Source)
     [java]     at org.photovault.folder.PhotoFolder.getRoot(PhotoFolder.java:444)
     [java]     at org.photovault.dbhelper.ODMG.initODMG(ODMG.java:149)
     [java]     at org.photovault.swingui.Photovault.login(Photovault.java:68)
     [java]     at org.photovault.swingui.Photovault.run(Photovault.java:130)
     [java]     at org.photovault.swingui.Photovault.main(Photovault.java:176)
     [java] Caused by: SQL Exception: Schema 'HARRI' does not exist
     [java]     at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
     [java]     at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
     [java]     at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
     [java]     at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
     [java]     at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
     [java]     at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
     [java]     at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
     [java]     at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
     [java]     at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source)
     [java]     at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
     [java]     at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
     [java]     at org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatement(Unknown Source)
     [java]     ... 19 more
     [java] 9    [main] ERROR org.photovault.folder.PhotoFolder  - Schema 'HARRI' does not exist
     [java] 9    [main] ERROR org.photovault.dbhelper.ODMG  - Could not open database connection
     [java] 9    [main] ERROR org.photovault.dbhelper.ODMG  - Could not open database connection
     [java] 10   [main] ERROR org.photovault.dbhelper.ODMG  - Unknown error while starting database:

     [java] org.photovault.common.PhotovaultException: Unknown error while starting database:

     [java]     at org.photovault.dbhelper.ODMG.initODMG(ODMG.java:159)
     [java]     at org.photovault.swingui.Photovault.login(Photovault.java:68)
     [java]     at org.photovault.swingui.Photovault.run(Photovault.java:130)
     [java]     at org.photovault.swingui.Photovault.main(Photovault.java:176)
     [java] Exception in thread "main" org.odmg.DatabaseClosedException: Database is not Open. Must have an open DB to call close.
     [java]     at org.apache.ojb.odmg.DatabaseImpl.close(Unknown Source)
     [java]     at org.photovault.dbhelper.ODMG.initODMG(ODMG.java:166)
     [java]     at org.photovault.swingui.Photovault.login(Photovault.java:68)
     [java]     at org.photovault.swingui.Photovault.run(Photovault.java:130)
     [java]     at org.photovault.swingui.Photovault.main(Photovault.java:176)

Change History

Changed 2 years ago by harri

Added warning about this to web pages.

Changed 2 years ago by harri

  • status changed from new to assigned

Catched the exception in r555

Changed 2 years ago by harri

Fixed UI in r556

Changed 2 years ago by harri

  • status changed from assigned to closed
  • resolution set to fixed

Merged to 0.3.x in r557

Changed 2 years ago by harri

  • milestone set to 0.3.future

Changed 2 years ago by harri

  • milestone changed from 0.3.future to 0.3.2

Changed 2 years ago by harri

  • milestone changed from 0.3.2 to 0.4.0

Milestone 0.3.2 deleted

Note: See TracTickets for help on using tickets.