You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by Manjula Kutty <ma...@gmail.com> on 2008/01/01 00:23:34 UTC
Re: Failed to start database
This may be due to the fact that the database is not shutdown properly.
Please check if you have a db.lck file in your db directory. If it exists
please delete that file manually and try booting the database again.
Thanks
Manjula
On 12/31/07, tom_ <to...@web.de> wrote:
>
>
> Without having a crash or something like that before, when trying to
> reopen
> the database the error message is "Failed to start database". Is there a
> possibility to start the database again?
>
> The complete error trace is
> java.sql.SQLException: Failed to start database '/mydatabase', see the
> next
> exception for details.
> at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException
> (Unknown
> Source)
> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown
> Source)
> at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown
> Source)
> at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
> at org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown Source)
> at
> org.executequery.datasource.ConnectionDataSource.getConnection(
> ConnectionDataSource.java:290)
> at
> org.executequery.datasource.ConnectionDataSource.getConnection(
> ConnectionDataSource.java:267)
> at
> org.executequery.datasource.ConnectionPool.ensureCapacity(
> ConnectionPool.java:291)
> at
> org.executequery.datasource.ConnectionManager.createDataSource(
> ConnectionManager.java:90)
> at
> org.executequery.databasemediators.ConnectionBuilder.connect(
> ConnectionBuilder.java:133)
> at
> org.executequery.databasemediators.ConnectionBuilder.access$000(
> ConnectionBuilder.java:44)
> at
> org.executequery.databasemediators.ConnectionBuilder$1.construct(
> ConnectionBuilder.java:117)
> at org.underworldlabs.swing.util.SwingWorker$2.run(SwingWorker.java
> :138)
> at java.lang.Thread.run(Thread.java:619)
> Caused by: java.sql.SQLException: Failed to start database '/mydatabase',
> see the next exception for details.
> at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException
> (Unknown
> Source)
> at
>
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA
> (Unknown
> Source)
> ... 19 more
> Caused by: java.sql.SQLException: Java exception: ':
> java.lang.NullPointerException'.
> at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException
> (Unknown
> Source)
> at
>
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA
> (Unknown
> Source)
> at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException
> (Unknown
> Source)
> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source)
> ... 16 more
> Caused by: java.lang.NullPointerException
> at org.apache.derby.iapi.types.SQLChar.getCollationKey(Unknown
> Source)
> at
> org.apache.derby.iapi.types.WorkHorseForCollatorDatatypes.stringCompare
> (Unknown
> Source)
> at org.apache.derby.iapi.types.CollatorSQLVarchar.stringCompare
> (Unknown
> Source)
> at org.apache.derby.iapi.types.SQLChar.compare(Unknown Source)
> at
> org.apache.derby.impl.store.access.btree.ControlRow.compareIndexRowToKey
> (Unknown
> Source)
> at org.apache.derby.impl.store.access.btree.index.B2IUndo.findUndo
> (Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.LogicalPageOperation.findLogicalPage
> (Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.LogicalPageOperation.generateUndo
> (Unknown
> Source)
> at org.apache.derby.impl.store.raw.log.FileLogger.undo(Unknown
> Source)
> at org.apache.derby.impl.store.raw.xact.Xact.abort(Unknown Source)
> at
> org.apache.derby.impl.store.raw.xact.XactFactory.rollbackAllTransactions
> (Unknown
> Source)
> at org.apache.derby.impl.store.raw.log.LogToFile.recover(Unknown
> Source)
> at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown
> Source)
> at org.apache.derby.impl.services.monitor.TopService.bootModule
> (Unknown
> Source)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule
> (Unknown
> Source)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule
> (Unknown
> Source)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown
> Source)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown
> Source)
> at org.apache.derby.impl.services.monitor.TopService.bootModule
> (Unknown
> Source)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule
> (Unknown
> Source)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule
> (Unknown
> Source)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source)
> at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown
> Source)
> at org.apache.derby.impl.services.monitor.TopService.bootModule
> (Unknown
> Source)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService
> (Unknown
> Source)
> at
> org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService
> (Unknown
> Source)
> at
>
> org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService
> (Unknown
> Source)
> at
> org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService
> (Unknown
> Source)
> at
> org.apache.derby.iapi.services.monitor.Monitor.startPersistentService
> (Unknown
> Source)
> ... 16 more
>
>
> --
> View this message in context:
> http://www.nabble.com/Failed-to-start-database-tp14561205p14561205.html
> Sent from the Apache Derby Users mailing list archive at Nabble.com.
>
>
--
Thanks,
Manjula.
Re: sql query using LIKE
Posted by tom_ <to...@web.de>.
Nik-31, thank you for putting this in my question. You should open your own
thread. I still can't re-open the database.
tom_
Nik-31 wrote:
>
> sweet, that fixed my next problem.. now i just have to get set the JTable
> properly...
> On Wed, 02 Jan 2008 17:38:46 +0900, Oystein Grovlen
> <Oy...@sun.com> wrote:
>
>> Nik wrote:
>>> I'm getting an SQL excpetion using LIKE to match a String.
>>> String query = "SELECT *" + "
>>> FROM "+ tableName +
>>> "WHERE DAY_OF_WEEK LIKE \""+
>>> searchTerms+"\"";
>>> is there some other way I should be doing this?
>>
>> You need to use single quotes for the search term, not double quotes.
>>
>> --
>> Øystein
>>
>>
>
>
>
> --
> Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
>
>
--
View this message in context: http://www.nabble.com/Failed-to-start-database-tp14561205p14579703.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.
Re: sql query using LIKE
Posted by Nik <ni...@gmail.com>.
sweet, that fixed my next problem.. now i just have to get set the JTable
properly...
On Wed, 02 Jan 2008 17:38:46 +0900, Oystein Grovlen
<Oy...@sun.com> wrote:
> Nik wrote:
>> I'm getting an SQL excpetion using LIKE to match a String.
>> String query = "SELECT *" + "
>> FROM "+ tableName +
>> "WHERE DAY_OF_WEEK LIKE \""+
>> searchTerms+"\"";
>> is there some other way I should be doing this?
>
> You need to use single quotes for the search term, not double quotes.
>
> --
> Øystein
>
>
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
Re: sql query using LIKE
Posted by Oystein Grovlen <Oy...@Sun.COM>.
Nik wrote:
> I'm getting an SQL excpetion using LIKE to match a String.
> String query = "SELECT *" +
> " FROM "+ tableName +
> "WHERE DAY_OF_WEEK LIKE \""+
> searchTerms+"\"";
> is there some other way I should be doing this?
You need to use single quotes for the search term, not double quotes.
--
Øystein
sql query using LIKE
Posted by Nik <ni...@gmail.com>.
I'm getting an SQL excpetion using LIKE to match a String.
String query = "SELECT *" +
" FROM "+ tableName +
"WHERE DAY_OF_WEEK LIKE \""+
searchTerms+"\"";
is there some other way I should be doing this?
Nik
Re: Failed to start database
Posted by tom_ <to...@web.de>.
The database was created with the properties "territory=de_DE" and
"collation=TERRITORY_BASED". The connection string contains the same
properties.
--
View this message in context: http://www.nabble.com/Failed-to-start-database-tp14561205p14567032.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.
Re: Failed to start database
Posted by Suresh Thalamati <su...@gmail.com>.
I doubt it is related to db locking. Stacks has the following error
Caused by: java.lang.NullPointerException
at org.apache.derby.iapi.types.SQLChar.getCollationKey(Unknown Source)
at
on rollback of btree log records during recovery.
Problem may be related to collation information.
-suresh
On Dec 31, 2007 3:23 PM, Manjula Kutty <ma...@gmail.com> wrote:
> This may be due to the fact that the database is not shutdown properly.
> Please check if you have a db.lck file in your db directory. If it exists
> please delete that file manually and try booting the database again.
>
> Thanks
> Manjula
>
>
>
>
> On 12/31/07, tom_ <to...@web.de> wrote:
> >
> > Without having a crash or something like that before, when trying to
> reopen
> > the database the error message is "Failed to start database". Is there a
> > possibility to start the database again?
> >
> > The complete error trace is
> > java.sql.SQLException: Failed to start database '/mydatabase', see the
> next
> > exception for details.
> > at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException
> (Unknown
> > Source)
> > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown
> Source)
> > at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
> > at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase (Unknown
> Source)
> > at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown
> Source)
> > at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown
> Source)
> > at org.apache.derby.impl.jdbc.EmbedConnection40 .<init>(Unknown
> Source)
> > at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown
> Source)
> > at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
> > at org.apache.derby.jdbc.EmbeddedDriver.connect (Unknown Source)
> > at
> >
> org.executequery.datasource.ConnectionDataSource.getConnection(ConnectionDataSource.java:290)
> > at
> >
> org.executequery.datasource.ConnectionDataSource.getConnection(ConnectionDataSource.java
> :267)
> > at
> >
> org.executequery.datasource.ConnectionPool.ensureCapacity(ConnectionPool.java:291)
> > at
> >
> org.executequery.datasource.ConnectionManager.createDataSource(ConnectionManager.java:90)
> > at
> >
> org.executequery.databasemediators.ConnectionBuilder.connect(ConnectionBuilder.java:133)
> > at
> >
> org.executequery.databasemediators.ConnectionBuilder.access$000(ConnectionBuilder.java:44)
> > at
> > org.executequery.databasemediators.ConnectionBuilder$1.construct
> (ConnectionBuilder.java:117)
> > at
> org.underworldlabs.swing.util.SwingWorker$2.run(SwingWorker.java:138)
> > at java.lang.Thread.run(Thread.java:619)
> > Caused by: java.sql.SQLException: Failed to start database '/mydatabase',
> > see the next exception for details.
> > at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
> > Source)
> > at
> >
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA
> (Unknown
> > Source)
> > ... 19 more
> > Caused by: java.sql.SQLException: Java exception: ':
> > java.lang.NullPointerException'.
> > at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
> > Source)
> > at
> >
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
> > Source)
> > at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
> > Source)
> > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown
> Source)
> > at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source)
> > ... 16 more
> > Caused by: java.lang.NullPointerException
> > at org.apache.derby.iapi.types.SQLChar.getCollationKey(Unknown
> Source)
> > at
> >
> org.apache.derby.iapi.types.WorkHorseForCollatorDatatypes.stringCompare(Unknown
> > Source)
> > at org.apache.derby.iapi.types.CollatorSQLVarchar.stringCompare
> (Unknown
> > Source)
> > at org.apache.derby.iapi.types.SQLChar.compare(Unknown Source)
> > at
> >
> org.apache.derby.impl.store.access.btree.ControlRow.compareIndexRowToKey(Unknown
> > Source)
> > at org.apache.derby.impl.store.access.btree.index.B2IUndo.findUndo
> (Unknown
> > Source)
> > at
> >
> org.apache.derby.impl.store.raw.data.LogicalPageOperation.findLogicalPage(Unknown
> > Source)
> > at
> >
> org.apache.derby.impl.store.raw.data.LogicalPageOperation.generateUndo(Unknown
> > Source)
> > at org.apache.derby.impl.store.raw.log.FileLogger.undo(Unknown
> Source)
> > at org.apache.derby.impl.store.raw.xact.Xact.abort(Unknown Source)
> > at
> > org.apache.derby.impl.store.raw.xact.XactFactory.rollbackAllTransactions
> (Unknown
> > Source)
> > at org.apache.derby.impl.store.raw.log.LogToFile.recover(Unknown
> Source)
> > at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source)
> > at org.apache.derby.impl.services.monitor.BaseMonitor.boot (Unknown
> Source)
> > at
> org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown
> > Source)
> > at
> org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown
> > Source)
> > at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule
> (Unknown
> > Source)
> > at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown
> Source)
> > at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown
> Source)
> > at org.apache.derby.impl.services.monitor.TopService.bootModule
> (Unknown
> > Source)
> > at
> org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown
> > Source)
> > at
> org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown
> > Source)
> > at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source)
> > at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)
> > at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown
> Source)
> > at
> org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown
> > Source)
> > at
> org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown
> > Source)
> > at
> > org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService
> (Unknown
> > Source)
> > at
> >
> org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown
> > Source)
> > at
> > org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService
> (Unknown
> > Source)
> > at
> >
> org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown
> > Source)
> > ... 16 more
> >
> >
> > --
> > View this message in context:
> http://www.nabble.com/Failed-to-start-database-tp14561205p14561205.html
> > Sent from the Apache Derby Users mailing list archive at Nabble.com.
> >
> >
>
>
>
> --
> Thanks,
> Manjula.
Re: Failed to start database
Posted by Manjula Kutty <ma...@gmail.com>.
You are correct Suresh
-Manjula
On 12/31/07, tom_ <to...@web.de> wrote:
>
>
> I fear there is no db.lck file in the database directory
>
>
> Manjula Kutty wrote:
> >
> > This may be due to the fact that the database is not shutdown properly.
> > Please check if you have a db.lck file in your db directory. If it
> exists
> > please delete that file manually and try booting the database again.
> >
> > Thanks
> > Manjula
> >
> >
> > On 12/31/07, tom_ <to...@web.de> wrote:
> >>
> >>
> >> Without having a crash or something like that before, when trying to
> >> reopen
> >> the database the error message is "Failed to start database". Is there
> a
> >> possibility to start the database again?
> >>
> >> The complete error trace is
> >> java.sql.SQLException: Failed to start database '/mydatabase', see the
> >> next
> >> exception for details.
> >> at
> >> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException
> >> (Unknown
> >> Source)
> >> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown
> >> Source)
> >> at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown
> >> Source)
> >> at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase
> (Unknown
> >> Source)
> >> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown
> >> Source)
> >> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown
> >> Source)
> >> at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown
> >> Source)
> >> at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown
> >> Source)
> >> at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
> >> at org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown Source)
> >> at
> >> org.executequery.datasource.ConnectionDataSource.getConnection(
> >> ConnectionDataSource.java:290)
> >> at
> >> org.executequery.datasource.ConnectionDataSource.getConnection(
> >> ConnectionDataSource.java:267)
> >> at
> >> org.executequery.datasource.ConnectionPool.ensureCapacity(
> >> ConnectionPool.java:291)
> >> at
> >> org.executequery.datasource.ConnectionManager.createDataSource(
> >> ConnectionManager.java:90)
> >> at
> >> org.executequery.databasemediators.ConnectionBuilder.connect(
> >> ConnectionBuilder.java:133)
> >> at
> >> org.executequery.databasemediators.ConnectionBuilder.access$000(
> >> ConnectionBuilder.java:44)
> >> at
> >> org.executequery.databasemediators.ConnectionBuilder$1.construct(
> >> ConnectionBuilder.java:117)
> >> at
> >> org.underworldlabs.swing.util.SwingWorker$2.run(SwingWorker.java
> >> :138)
> >> at java.lang.Thread.run(Thread.java:619)
> >> Caused by: java.sql.SQLException: Failed to start database
> '/mydatabase',
> >> see the next exception for details.
> >> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException
> >> (Unknown
> >> Source)
> >> at
> >>
> >>
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA
> >> (Unknown
> >> Source)
> >> ... 19 more
> >> Caused by: java.sql.SQLException: Java exception: ':
> >> java.lang.NullPointerException'.
> >> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException
> >> (Unknown
> >> Source)
> >> at
> >>
> >>
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA
> >> (Unknown
> >> Source)
> >> at
> >> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException
> >> (Unknown
> >> Source)
> >> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown
> >> Source)
> >> at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source)
> >> ... 16 more
> >> Caused by: java.lang.NullPointerException
> >> at org.apache.derby.iapi.types.SQLChar.getCollationKey(Unknown
> >> Source)
> >> at
> >> org.apache.derby.iapi.types.WorkHorseForCollatorDatatypes.stringCompare
> >> (Unknown
> >> Source)
> >> at org.apache.derby.iapi.types.CollatorSQLVarchar.stringCompare
> >> (Unknown
> >> Source)
> >> at org.apache.derby.iapi.types.SQLChar.compare(Unknown Source)
> >> at
> >>
> org.apache.derby.impl.store.access.btree.ControlRow.compareIndexRowToKey
> >> (Unknown
> >> Source)
> >> at
> org.apache.derby.impl.store.access.btree.index.B2IUndo.findUndo
> >> (Unknown
> >> Source)
> >> at
> >>
> org.apache.derby.impl.store.raw.data.LogicalPageOperation.findLogicalPage
> >> (Unknown
> >> Source)
> >> at
> >> org.apache.derby.impl.store.raw.data.LogicalPageOperation.generateUndo
> >> (Unknown
> >> Source)
> >> at org.apache.derby.impl.store.raw.log.FileLogger.undo(Unknown
> >> Source)
> >> at org.apache.derby.impl.store.raw.xact.Xact.abort(Unknown
> Source)
> >> at
> >>
> org.apache.derby.impl.store.raw.xact.XactFactory.rollbackAllTransactions
> >> (Unknown
> >> Source)
> >> at org.apache.derby.impl.store.raw.log.LogToFile.recover(Unknown
> >> Source)
> >> at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source)
> >> at org.apache.derby.impl.services.monitor.BaseMonitor.boot
> (Unknown
> >> Source)
> >> at org.apache.derby.impl.services.monitor.TopService.bootModule
> >> (Unknown
> >> Source)
> >> at
> org.apache.derby.impl.services.monitor.BaseMonitor.startModule
> >> (Unknown
> >> Source)
> >> at
> >> org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule
> >> (Unknown
> >> Source)
> >> at
> >> org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown
> >> Source)
> >> at org.apache.derby.impl.services.monitor.BaseMonitor.boot
> (Unknown
> >> Source)
> >> at org.apache.derby.impl.services.monitor.TopService.bootModule
> >> (Unknown
> >> Source)
> >> at
> org.apache.derby.impl.services.monitor.BaseMonitor.startModule
> >> (Unknown
> >> Source)
> >> at
> >> org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule
> >> (Unknown
> >> Source)
> >> at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown
> >> Source)
> >> at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)
> >> at org.apache.derby.impl.services.monitor.BaseMonitor.boot
> (Unknown
> >> Source)
> >> at org.apache.derby.impl.services.monitor.TopService.bootModule
> >> (Unknown
> >> Source)
> >> at
> org.apache.derby.impl.services.monitor.BaseMonitor.bootService
> >> (Unknown
> >> Source)
> >> at
> >> org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService
> >> (Unknown
> >> Source)
> >> at
> >>
> >>
> org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService
> >> (Unknown
> >> Source)
> >> at
> >>
> org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService
> >> (Unknown
> >> Source)
> >> at
> >> org.apache.derby.iapi.services.monitor.Monitor.startPersistentService
> >> (Unknown
> >> Source)
> >> ... 16 more
> >>
> >>
> >> --
> >> View this message in context:
> >> http://www.nabble.com/Failed-to-start-database-tp14561205p14561205.html
> >> Sent from the Apache Derby Users mailing list archive at Nabble.com.
> >>
> >>
> >
> >
> > --
> > Thanks,
> > Manjula.
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/Failed-to-start-database-tp14561205p14563104.html
> Sent from the Apache Derby Users mailing list archive at Nabble.com.
>
>
--
Thanks,
Manjula.
Re: Failed to start database
Posted by tom_ <to...@web.de>.
I fear there is no db.lck file in the database directory
Manjula Kutty wrote:
>
> This may be due to the fact that the database is not shutdown properly.
> Please check if you have a db.lck file in your db directory. If it exists
> please delete that file manually and try booting the database again.
>
> Thanks
> Manjula
>
>
> On 12/31/07, tom_ <to...@web.de> wrote:
>>
>>
>> Without having a crash or something like that before, when trying to
>> reopen
>> the database the error message is "Failed to start database". Is there a
>> possibility to start the database again?
>>
>> The complete error trace is
>> java.sql.SQLException: Failed to start database '/mydatabase', see the
>> next
>> exception for details.
>> at
>> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException
>> (Unknown
>> Source)
>> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown
>> Source)
>> at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown
>> Source)
>> at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown
>> Source)
>> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown
>> Source)
>> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown
>> Source)
>> at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown
>> Source)
>> at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown
>> Source)
>> at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
>> at org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown Source)
>> at
>> org.executequery.datasource.ConnectionDataSource.getConnection(
>> ConnectionDataSource.java:290)
>> at
>> org.executequery.datasource.ConnectionDataSource.getConnection(
>> ConnectionDataSource.java:267)
>> at
>> org.executequery.datasource.ConnectionPool.ensureCapacity(
>> ConnectionPool.java:291)
>> at
>> org.executequery.datasource.ConnectionManager.createDataSource(
>> ConnectionManager.java:90)
>> at
>> org.executequery.databasemediators.ConnectionBuilder.connect(
>> ConnectionBuilder.java:133)
>> at
>> org.executequery.databasemediators.ConnectionBuilder.access$000(
>> ConnectionBuilder.java:44)
>> at
>> org.executequery.databasemediators.ConnectionBuilder$1.construct(
>> ConnectionBuilder.java:117)
>> at
>> org.underworldlabs.swing.util.SwingWorker$2.run(SwingWorker.java
>> :138)
>> at java.lang.Thread.run(Thread.java:619)
>> Caused by: java.sql.SQLException: Failed to start database '/mydatabase',
>> see the next exception for details.
>> at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException
>> (Unknown
>> Source)
>> at
>>
>> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA
>> (Unknown
>> Source)
>> ... 19 more
>> Caused by: java.sql.SQLException: Java exception: ':
>> java.lang.NullPointerException'.
>> at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException
>> (Unknown
>> Source)
>> at
>>
>> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA
>> (Unknown
>> Source)
>> at
>> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException
>> (Unknown
>> Source)
>> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown
>> Source)
>> at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source)
>> ... 16 more
>> Caused by: java.lang.NullPointerException
>> at org.apache.derby.iapi.types.SQLChar.getCollationKey(Unknown
>> Source)
>> at
>> org.apache.derby.iapi.types.WorkHorseForCollatorDatatypes.stringCompare
>> (Unknown
>> Source)
>> at org.apache.derby.iapi.types.CollatorSQLVarchar.stringCompare
>> (Unknown
>> Source)
>> at org.apache.derby.iapi.types.SQLChar.compare(Unknown Source)
>> at
>> org.apache.derby.impl.store.access.btree.ControlRow.compareIndexRowToKey
>> (Unknown
>> Source)
>> at org.apache.derby.impl.store.access.btree.index.B2IUndo.findUndo
>> (Unknown
>> Source)
>> at
>> org.apache.derby.impl.store.raw.data.LogicalPageOperation.findLogicalPage
>> (Unknown
>> Source)
>> at
>> org.apache.derby.impl.store.raw.data.LogicalPageOperation.generateUndo
>> (Unknown
>> Source)
>> at org.apache.derby.impl.store.raw.log.FileLogger.undo(Unknown
>> Source)
>> at org.apache.derby.impl.store.raw.xact.Xact.abort(Unknown Source)
>> at
>> org.apache.derby.impl.store.raw.xact.XactFactory.rollbackAllTransactions
>> (Unknown
>> Source)
>> at org.apache.derby.impl.store.raw.log.LogToFile.recover(Unknown
>> Source)
>> at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown
>> Source)
>> at org.apache.derby.impl.services.monitor.TopService.bootModule
>> (Unknown
>> Source)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule
>> (Unknown
>> Source)
>> at
>> org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule
>> (Unknown
>> Source)
>> at
>> org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown
>> Source)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown
>> Source)
>> at org.apache.derby.impl.services.monitor.TopService.bootModule
>> (Unknown
>> Source)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule
>> (Unknown
>> Source)
>> at
>> org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule
>> (Unknown
>> Source)
>> at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown
>> Source)
>> at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown
>> Source)
>> at org.apache.derby.impl.services.monitor.TopService.bootModule
>> (Unknown
>> Source)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService
>> (Unknown
>> Source)
>> at
>> org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService
>> (Unknown
>> Source)
>> at
>>
>> org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService
>> (Unknown
>> Source)
>> at
>> org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService
>> (Unknown
>> Source)
>> at
>> org.apache.derby.iapi.services.monitor.Monitor.startPersistentService
>> (Unknown
>> Source)
>> ... 16 more
>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Failed-to-start-database-tp14561205p14561205.html
>> Sent from the Apache Derby Users mailing list archive at Nabble.com.
>>
>>
>
>
> --
> Thanks,
> Manjula.
>
>
--
View this message in context: http://www.nabble.com/Failed-to-start-database-tp14561205p14563104.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.