You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@excalibur.apache.org by "Shash Chatterjee (JIRA)" <de...@excalibur.apache.org> on 2005/04/12 03:36:17 UTC

[jira] Created: (EXLBR-22) Datasource tests fail with HsqlDB-1.7.3.0

Datasource tests fail with HsqlDB-1.7.3.0
-----------------------------------------

         Key: EXLBR-22
         URL: http://issues.apache.org/jira/browse/EXLBR-22
     Project: Excalibur Components
        Type: Bug
  Components: Datasource  
 Environment: Windows-XP/SP-2
Cygwin
JDK-1.4.2_06

    Reporter: Shash Chatterjee


test:test:
    [junit] Running org.apache.avalon.excalibur.datasource.ids.test.TableIdGeneratorJdbcTestCase
INFO    2005-04-11 19:25:21.812 [TableIdGeneratorJdbcTestCase  ] (): <title>TableIdGenerator Tests</title>
        <para>
        This series of tests excersizes the TableIdGenerator provided by Excalibur.
        The configuration is specified in the file located in
        <parameter>jakarta-avalon-excalibur/src/scratchpad/org/apache/avalon/excalibur/datasource/ids/test/TableIdGeneratorJdbcTestC
ase.xtext</parameter>.
        </para>
Niclas
WARN    11132   [jdbc    ] (): Could not prepare test statement, connection recycled on basis of time.
java.sql.SQLException: Unexpected token:  in statement [SELECT 1]
        at org.hsqldb.jdbc.jdbcUtil.throwError(Unknown Source)
        at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
        at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
        at org.apache.avalon.excalibur.datasource.AbstractJdbcConnection.<init>(AbstractJdbcConnection.java:139)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
INFO    11132   [test.tes] (): testNonExistingTableName
ERROR   11132   [id-gen  ] (): Unable to allocate a block of Ids, no row with table_name='does-not-exist' exists in the ids table.
Niclas
INFO    11132   [test.tes] (): testSimpleRequestIdsSize1
Niclas
INFO    11132   [test.tes] (): testSimpleRequestIdsSize10
Niclas
INFO    11132   [test.tes] (): testSimpleRequestIdsSize100
Niclas
INFO    11132   [test.tes] (): testBigDecimalRequestIdsSize10
Niclas
INFO    11132   [test.tes] (): testMaxByteIds
ERROR   11132   [id-gen  ] (): Unable to provide an id.  The next id would be greater than the id data type allows.
Niclas
INFO    11132   [test.tes] (): testMaxShortIds
ERROR   11132   [id-gen  ] (): Unable to provide an id.  The next id would be greater than the id data type allows.
Niclas
INFO    11132   [test.tes] (): testMaxIntegerIds
ERROR   11132   [id-gen  ] (): Unable to provide an id.  The next id would be greater than the id data type allows.
$
INFO    11132   [test.tes] (): testMaxLongIds
ERROR   11132   [id-gen  ] (): No more Ids are available, the maximum long value has been reached.
WARN    11132   [cm      ] (): disposing of handler for unreleased component. role [org.apache.avalon.excalibur.datasource.DataSourc
eComponentSelector]
    [junit] Tests run: 9, Failures: 0, Errors: 0, Time elapsed: 1.078 sec
    [junit] Running org.apache.avalon.excalibur.datasource.ids.test.TableIdGeneratorMultithreadedJdbcTestCase
INFO    2005-04-11 19:25:22.968 [TableIdGeneratorMultithreadedJ] (): <title>TableIdGenerator Tests</title>
        <para>
        This series of tests excersizes the TableIdGenerator provided by Excalibur in a multithreaded context.
        The configuration is specified in the file located in
        <parameter>jakarta-avalon-excalibur/src/scratchpad/org/apache/avalon/excalibur/datasource/ids/test/TableIdGeneratorMultithre
adedJdbcTestCase.xtext</parameter>.
        </para>
WARN    11132   [jdbc    ] (): Could not return Connection
java.sql.SQLException: The database is already in use by another process: org.hsqldb.NIOLockFile@9fe164d[file =C:\Users\Shash\Java\L
ibraries\excalibur-trunk\components\datasource\test.lck.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception:
 The process cannot access the file because another process has locked a portion of the file : C:\Users\Shash\Java\Libraries\excalib
ur-trunk\components\datasource\test.lck.lck
        at org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
        at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
        at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
        at org.hsqldb.jdbcDriver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:182)
ERROR   2005-04-11 19:25:23.421 [test.tes] (): Unable to initialize database for test.
java.sql.SQLException: The database is already in use by another process: org.hsqldb.NIOLockFile@9fe164d[file =C:\Users\Shash\Java\L
ibraries\excalibur-trunk\components\datasource\test.lck.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception:
 The process cannot access the file because another process has locked a portion of the file : C:\Users\Shash\Java\Libraries\excalib
ur-trunk\components\datasource\test.lck.lck
        at org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
        at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
        at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
        at org.hsqldb.jdbcDriver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:182)
        at org.apache.avalon.excalibur.pool.InstrumentedResourceLimitingPool.newPoolable(InstrumentedResourceLimitingPool.java:655)
        at org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.newPoolable(ValidatedResourceLimitingPool.java:145)
        at org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcConnectionPool.newPoolable(ResourceLimitingJdbcConnectionPool.
java:91)
        at org.apache.avalon.excalibur.pool.InstrumentedResourceLimitingPool.get(InstrumentedResourceLimitingPool.java:371)
        at org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(ValidatedResourceLimitingPool.java:97)
        at org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.getConnection(ResourceLimitingJdbcDataSource.java:1
93)
        at org.apache.avalon.excalibur.datasource.ids.test.TableIdGeneratorMultithreadedJdbcTestCase.setUp(TableIdGeneratorMultithre
adedJdbcTestCase.java:78)
        at junit.framework.TestCase.runBare(TestCase.java:125)
        at junit.framework.TestResult$1.protect(TestResult.java:106)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.framework.TestResult.run(TestResult.java:109)
        at junit.framework.TestCase.run(TestCase.java:118)
        at org.apache.avalon.excalibur.testcase.ExcaliburTestCase.run(ExcaliburTestCase.java:413)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnitTestRunner.java:325)
        at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.executeInVM(JUnitTask.java:848)
        at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.execute(JUnitTask.java:556)
        at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.execute(JUnitTask.java:532)
        at org.apache.tools.ant.Task.perform(Task.java:341)
        at org.apache.commons.jelly.tags.ant.AntTag.doTag(AntTag.java:185)
        at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:279)
        at org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:135)
        at org.apache.commons.jelly.TagSupport.invokeBody(TagSupport.java:233)
        at org.apache.commons.jelly.tags.core.IfTag.doTag(IfTag.java:88)
        at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:279)
        at org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:135)
        at org.apache.maven.jelly.tags.werkz.MavenGoalTag.runBodyTag(MavenGoalTag.java:79)
        at org.apache.maven.jelly.tags.werkz.MavenGoalTag$MavenGoalAction.performAction(MavenGoalTag.java:110)
        at com.werken.werkz.Goal.fire(Goal.java:639)
        at com.werken.werkz.Goal.attain(Goal.java:575)
        at com.werken.werkz.Goal.attainPrecursors(Goal.java:488)
        at com.werken.werkz.Goal.attain(Goal.java:573)
        at com.werken.werkz.Goal.attainPrecursors(Goal.java:488)
        at com.werken.werkz.Goal.attain(Goal.java:573)
        at org.apache.maven.plugin.PluginManager.attainGoals(PluginManager.java:671)
        at org.apache.maven.MavenSession.attainGoals(MavenSession.java:263)
        at org.apache.maven.cli.App.doMain(App.java:488)
        at org.apache.maven.cli.App.main(App.java:1239)
        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 com.werken.forehead.Forehead.run(Forehead.java:551)
        at com.werken.forehead.Forehead.main(Forehead.java:581)
WARN    11132   [jdbc    ] (): Could not return Connection
java.sql.SQLException: The database is already in use by another process: org.hsqldb.NIOLockFile@9fe164d[file =C:\Users\Shash\Java\L
ibraries\excalibur-trunk\components\datasource\test.lck.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception:
 The process cannot access the file because another process has locked a portion of the file : C:\Users\Shash\Java\Libraries\excalib
ur-trunk\components\datasource\test.lck.lck
        at org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
        at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
        at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
        at org.hsqldb.jdbcDriver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:182)
ERROR   2005-04-11 19:25:23.468 [test.tes] (): Unable to initialize database for test.
java.sql.SQLException: The database is already in use by another process: org.hsqldb.NIOLockFile@9fe164d[file =C:\Users\Shash\Java\L
ibraries\excalibur-trunk\components\datasource\test.lck.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception:
 The process cannot access the file because another process has locked a portion of the file : C:\Users\Shash\Java\Libraries\excalib
ur-trunk\components\datasource\test.lck.lck
        at org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
        at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
        at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
        at org.hsqldb.jdbcDriver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:182)
        at org.apache.avalon.excalibur.pool.InstrumentedResourceLimitingPool.newPoolable(InstrumentedResourceLimitingPool.java:655)
        at org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.newPoolable(ValidatedResourceLimitingPool.java:145)
        at org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcConnectionPool.newPoolable(ResourceLimitingJdbcConnectionPool.
java:91)
        at org.apache.avalon.excalibur.pool.InstrumentedResourceLimitingPool.get(InstrumentedResourceLimitingPool.java:371)
        at org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(ValidatedResourceLimitingPool.java:97)
        at org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.getConnection(ResourceLimitingJdbcDataSource.java:1
93)
        at org.apache.avalon.excalibur.datasource.ids.test.TableIdGeneratorMultithreadedJdbcTestCase.setUp(TableIdGeneratorMultithre
adedJdbcTestCase.java:78)
        at junit.framework.TestCase.runBare(TestCase.java:125)
        at junit.framework.TestResult$1.protect(TestResult.java:106)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.framework.TestResult.run(TestResult.java:109)
        at junit.framework.TestCase.run(TestCase.java:118)
        at org.apache.avalon.excalibur.testcase.ExcaliburTestCase.run(ExcaliburTestCase.java:413)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnitTestRunner.java:325)
        at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.executeInVM(JUnitTask.java:848)
        at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.execute(JUnitTask.java:556)
        at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.execute(JUnitTask.java:532)
        at org.apache.tools.ant.Task.perform(Task.java:341)
        at org.apache.commons.jelly.tags.ant.AntTag.doTag(AntTag.java:185)
        at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:279)
        at org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:135)
        at org.apache.commons.jelly.TagSupport.invokeBody(TagSupport.java:233)
        at org.apache.commons.jelly.tags.core.IfTag.doTag(IfTag.java:88)
        at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:279)
        at org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:135)
        at org.apache.maven.jelly.tags.werkz.MavenGoalTag.runBodyTag(MavenGoalTag.java:79)
        at org.apache.maven.jelly.tags.werkz.MavenGoalTag$MavenGoalAction.performAction(MavenGoalTag.java:110)
        at com.werken.werkz.Goal.fire(Goal.java:639)
        at com.werken.werkz.Goal.attain(Goal.java:575)
        at com.werken.werkz.Goal.attainPrecursors(Goal.java:488)
        at com.werken.werkz.Goal.attain(Goal.java:573)
        at com.werken.werkz.Goal.attainPrecursors(Goal.java:488)
        at com.werken.werkz.Goal.attain(Goal.java:573)
        at org.apache.maven.plugin.PluginManager.attainGoals(PluginManager.java:671)
        at org.apache.maven.MavenSession.attainGoals(MavenSession.java:263)
        at org.apache.maven.cli.App.doMain(App.java:488)
        at org.apache.maven.cli.App.main(App.java:1239)
        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 com.werken.forehead.Forehead.run(Forehead.java:551)
        at com.werken.forehead.Forehead.main(Forehead.java:581)
WARN    11132   [jdbc    ] (): Could not return Connection
java.sql.SQLException: The database is already in use by another process: org.hsqldb.NIOLockFile@9fe164d[file =C:\Users\Shash\Java\L
ibraries\excalibur-trunk\components\datasource\test.lck.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception:
 The process cannot access the file because another process has locked a portion of the file : C:\Users\Shash\Java\Libraries\excalib
ur-trunk\components\datasource\test.lck.lck
        at org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
        at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
        at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
        at org.hsqldb.jdbcDriver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:182)
ERROR   2005-04-11 19:25:23.515 [test.tes] (): Unable to initialize database for test.
java.sql.SQLException: The database is already in use by another process: org.hsqldb.NIOLockFile@9fe164d[file =C:\Users\Shash\Java\L
ibraries\excalibur-trunk\components\datasource\test.lck.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception:
 The process cannot access the file because another process has locked a portion of the file : C:\Users\Shash\Java\Libraries\excalib
ur-trunk\components\datasource\test.lck.lck
        at org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
        at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
        at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
        at org.hsqldb.jdbcDriver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:182)
        at org.apache.avalon.excalibur.pool.InstrumentedResourceLimitingPool.newPoolable(InstrumentedResourceLimitingPool.java:655)
        at org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.newPoolable(ValidatedResourceLimitingPool.java:145)
        at org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcConnectionPool.newPoolable(ResourceLimitingJdbcConnectionPool.
java:91)
        at org.apache.avalon.excalibur.pool.InstrumentedResourceLimitingPool.get(InstrumentedResourceLimitingPool.java:371)
        at org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(ValidatedResourceLimitingPool.java:97)
        at org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.getConnection(ResourceLimitingJdbcDataSource.java:1
93)
        at org.apache.avalon.excalibur.datasource.ids.test.TableIdGeneratorMultithreadedJdbcTestCase.setUp(TableIdGeneratorMultithre
adedJdbcTestCase.java:78)
        at junit.framework.TestCase.runBare(TestCase.java:125)
        at junit.framework.TestResult$1.protect(TestResult.java:106)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.framework.TestResult.run(TestResult.java:109)
        at junit.framework.TestCase.run(TestCase.java:118)
        at org.apache.avalon.excalibur.testcase.ExcaliburTestCase.run(ExcaliburTestCase.java:413)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnitTestRunner.java:325)
        at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.executeInVM(JUnitTask.java:848)
        at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.execute(JUnitTask.java:556)
        at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.execute(JUnitTask.java:532)
        at org.apache.tools.ant.Task.perform(Task.java:341)
        at org.apache.commons.jelly.tags.ant.AntTag.doTag(AntTag.java:185)
        at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:279)
        at org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:135)
        at org.apache.commons.jelly.TagSupport.invokeBody(TagSupport.java:233)
        at org.apache.commons.jelly.tags.core.IfTag.doTag(IfTag.java:88)
        at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:279)
        at org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:135)
        at org.apache.maven.jelly.tags.werkz.MavenGoalTag.runBodyTag(MavenGoalTag.java:79)
        at org.apache.maven.jelly.tags.werkz.MavenGoalTag$MavenGoalAction.performAction(MavenGoalTag.java:110)
        at com.werken.werkz.Goal.fire(Goal.java:639)
        at com.werken.werkz.Goal.attain(Goal.java:575)
        at com.werken.werkz.Goal.attainPrecursors(Goal.java:488)
        at com.werken.werkz.Goal.attain(Goal.java:573)
        at com.werken.werkz.Goal.attainPrecursors(Goal.java:488)
        at com.werken.werkz.Goal.attain(Goal.java:573)
        at org.apache.maven.plugin.PluginManager.attainGoals(PluginManager.java:671)
        at org.apache.maven.MavenSession.attainGoals(MavenSession.java:263)
        at org.apache.maven.cli.App.doMain(App.java:488)
        at org.apache.maven.cli.App.main(App.java:1239)
        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 com.werken.forehead.Forehead.run(Forehead.java:551)
        at com.werken.forehead.Forehead.main(Forehead.java:581)
WARN    11132   [jdbc    ] (): Could not return Connection
java.sql.SQLException: The database is already in use by another process: org.hsqldb.NIOLockFile@9fe164d[file =C:\Users\Shash\Java\L
ibraries\excalibur-trunk\components\datasource\test.lck.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception:
 The process cannot access the file because another process has locked a portion of the file : C:\Users\Shash\Java\Libraries\excalib
ur-trunk\components\datasource\test.lck.lck
        at org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
        at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
        at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
        at org.hsqldb.jdbcDriver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:182)
ERROR   2005-04-11 19:25:23.640 [test.tes] (): Unable to initialize database for test.
java.sql.SQLException: The database is already in use by another process: org.hsqldb.NIOLockFile@9fe164d[file =C:\Users\Shash\Java\L
ibraries\excalibur-trunk\components\datasource\test.lck.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception:
 The process cannot access the file because another process has locked a portion of the file : C:\Users\Shash\Java\Libraries\excalib
ur-trunk\components\datasource\test.lck.lck
        at org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
        at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
        at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
        at org.hsqldb.jdbcDriver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:182)
        at org.apache.avalon.excalibur.pool.InstrumentedResourceLimitingPool.newPoolable(InstrumentedResourceLimitingPool.java:655)
        at org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.newPoolable(ValidatedResourceLimitingPool.java:145)
        at org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcConnectionPool.newPoolable(ResourceLimitingJdbcConnectionPool.
java:91)
        at org.apache.avalon.excalibur.pool.InstrumentedResourceLimitingPool.get(InstrumentedResourceLimitingPool.java:371)
        at org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(ValidatedResourceLimitingPool.java:97)
        at org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.getConnection(ResourceLimitingJdbcDataSource.java:1
93)
        at org.apache.avalon.excalibur.datasource.ids.test.TableIdGeneratorMultithreadedJdbcTestCase.setUp(TableIdGeneratorMultithre
adedJdbcTestCase.java:78)
        at junit.framework.TestCase.runBare(TestCase.java:125)
        at junit.framework.TestResult$1.protect(TestResult.java:106)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.framework.TestResult.run(TestResult.java:109)
        at junit.framework.TestCase.run(TestCase.java:118)
        at org.apache.avalon.excalibur.testcase.ExcaliburTestCase.run(ExcaliburTestCase.java:413)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnitTestRunner.java:325)
        at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.executeInVM(JUnitTask.java:848)
        at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.execute(JUnitTask.java:556)
        at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.execute(JUnitTask.java:532)
        at org.apache.tools.ant.Task.perform(Task.java:341)
        at org.apache.commons.jelly.tags.ant.AntTag.doTag(AntTag.java:185)
        at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:279)
        at org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:135)
        at org.apache.commons.jelly.TagSupport.invokeBody(TagSupport.java:233)
        at org.apache.commons.jelly.tags.core.IfTag.doTag(IfTag.java:88)
        at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:279)
        at org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:135)
        at org.apache.maven.jelly.tags.werkz.MavenGoalTag.runBodyTag(MavenGoalTag.java:79)
        at org.apache.maven.jelly.tags.werkz.MavenGoalTag$MavenGoalAction.performAction(MavenGoalTag.java:110)
        at com.werken.werkz.Goal.fire(Goal.java:639)
        at com.werken.werkz.Goal.attain(Goal.java:575)
        at com.werken.werkz.Goal.attainPrecursors(Goal.java:488)
        at com.werken.werkz.Goal.attain(Goal.java:573)
        at com.werken.werkz.Goal.attainPrecursors(Goal.java:488)
        at com.werken.werkz.Goal.attain(Goal.java:573)
        at org.apache.maven.plugin.PluginManager.attainGoals(PluginManager.java:671)
        at org.apache.maven.MavenSession.attainGoals(MavenSession.java:263)
        at org.apache.maven.cli.App.doMain(App.java:488)
        at org.apache.maven.cli.App.main(App.java:1239)
        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 com.werken.forehead.Forehead.run(Forehead.java:551)
        at com.werken.forehead.Forehead.main(Forehead.java:581)
WARN    2005-04-11 19:25:23.640 [cm      ] (): disposing of handler for unreleased component. role [org.apache.avalon.excalibur.data
source.DataSourceComponentSelector]
    [junit] Tests run: 4, Failures: 4, Errors: 0, Time elapsed: 0.765 sec
    [junit] [ERROR] TEST org.apache.avalon.excalibur.datasource.ids.test.TableIdGeneratorMultithreadedJdbcTestCase FAILED
    [junit] Running org.apache.avalon.excalibur.datasource.test.DataSourceJdbcTestCase
INFO    2005-04-11 19:25:23.812 [DataSourceJdbcTestCase        ] (): <title>DataSource Tests</title>
      <para>
        This series of tests exercise the JDBC DataSourceComponent provided by
        Excalibur.  The configuration is specified in the file located in
        <parameter>jakarta-avalon-excalibur/src/test/org/apache/avalon/excalibur/datasource/test/DataSourceJdbcTestCase.xtext</param
eter>.
        You may edit the test to customize the settings.
      </para>
WARN    11132   [test    ] (): Could not grow the pool properly, an exception was caught
java.sql.SQLException: The database is already in use by another process: org.hsqldb.NIOLockFile@9fe164d[file =C:\Users\Shash\Java\L
ibraries\excalibur-trunk\components\datasource\test.lck.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception:
 The process cannot access the file because another process has locked a portion of the file : C:\Users\Shash\Java\Libraries\excalib
ur-trunk\components\datasource\test.lck.lck
        at org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
        at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
        at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
        at org.hsqldb.jdbcDriver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:182)
FATAL_E 11132   [test    ] (): Excalibur could not create any connections.  Examine your settings to make sure they are correct.  Ma
ke sure you can connect with the same settings on your machine.
WARN    11132   [test    ] (): Could not return Connection
java.lang.IllegalStateException: You cannot get a Poolable before the pool is initialized
        at org.apache.avalon.excalibur.pool.DefaultPool.get(DefaultPool.java:116)
        at org.apache.avalon.excalibur.datasource.JdbcConnectionPool.get(JdbcConnectionPool.java:152)
        at org.apache.avalon.excalibur.datasource.JdbcDataSource.getConnection(JdbcDataSource.java:250)
        at org.apache.avalon.excalibur.datasource.test.DataSourceJdbcTestCase.testOverAllocation(DataSourceJdbcTestCase.java:65)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
INFO    11132   [test.tes] (): The test was successful
WARN    11132   [test    ] (): Could not return Connection
java.lang.IllegalStateException: There are no connections in the pool, check your settings.
        at org.apache.avalon.excalibur.datasource.JdbcConnectionPool.get(JdbcConnectionPool.java:140)
        at org.apache.avalon.excalibur.datasource.JdbcDataSource.getConnection(JdbcDataSource.java:250)
        at org.apache.avalon.excalibur.datasource.test.DataSourceJdbcTestCase$ConnectionThread.run(DataSourceJdbcTestCase.java:179)
        at java.lang.Thread.run(Thread.java:534)
INFO    11132   [test.tes] (): Failed to get Connection, test failed
org.apache.avalon.excalibur.datasource.NoAvailableConnectionException: There are no connections in the pool, check your settings.
        at org.apache.avalon.excalibur.datasource.JdbcDataSource.getConnection(JdbcDataSource.java:269)
        at org.apache.avalon.excalibur.datasource.test.DataSourceJdbcTestCase$ConnectionThread.run(DataSourceJdbcTestCase.java:179)
        at java.lang.Thread.run(Thread.java:534)
INFO    11132   [test.tes] (): The normal use test passed with 0 requests and 10 concurrent threads running
    [junit] Tests run: 2, Failures: 1, Errors: 0, Time elapsed: 0.562 sec
    [junit] [ERROR] TEST org.apache.avalon.excalibur.datasource.test.DataSourceJdbcTestCase FAILED

BUILD FAILED
File...... C:\Documents and Settings\SChatterjee\.maven\cache\maven-test-plugin-1.6.2\plugin.jelly
Element... fail
Line...... 181
Column.... 54
There were test failures.
Total time: 7 seconds
Finished at: Mon Apr 11 19:25:24 GMT-06:00 2005

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@excalibur.apache.org
For additional commands, e-mail: dev-help@excalibur.apache.org


[jira] Resolved: (EXLBR-22) Datasource tests fail with HsqlDB-1.7.3.0

Posted by "Shash Chatterjee (JIRA)" <de...@excalibur.apache.org>.
     [ http://issues.apache.org/jira/browse/EXLBR-22?page=all ]
     
Shash Chatterjee resolved EXLBR-22:
-----------------------------------

    Resolution: Fixed

Author: antonio
Date: Sat Jul 30 20:04:42 2005
New Revision: 226604

URL: http://svn.apache.org/viewcvs?rev=226604&view=rev
Log:
Fix EXLBR-22 Datasource tests fails with HsqlDB 1.7.3 - http://issues.apache.org/jira/browse/EXLBR-22

Modified:
    excalibur/trunk/components/datasource/project.xml
    excalibur/trunk/components/datasource/src/test/org/apache/avalon/excalibur/datasource/ids/test/TableIdGeneratorJdbcTestCase.xtest
    excalibur/trunk/components/datasource/src/test/org/apache/avalon/excalibur/datasource/ids/test/TableIdGeneratorMultithreadedJdbcTestCase.xtest
    excalibur/trunk/components/datasource/src/test/org/apache/avalon/excalibur/datasource/test/DataSourceJdbcTestCase.xtest



> Datasource tests fail with HsqlDB-1.7.3.0
> -----------------------------------------
>
>          Key: EXLBR-22
>          URL: http://issues.apache.org/jira/browse/EXLBR-22
>      Project: Excalibur Components
>         Type: Bug
>   Components: Datasource
>  Environment: Windows-XP/SP-2
> Cygwin
> JDK-1.4.2_06
>     Reporter: Shash Chatterjee

>
> test:test:
>     [junit] Running org.apache.avalon.excalibur.datasource.ids.test.TableIdGeneratorJdbcTestCase
> INFO    2005-04-11 19:25:21.812 [TableIdGeneratorJdbcTestCase  ] (): <title>TableIdGenerator Tests</title>
>         <para>
>         This series of tests excersizes the TableIdGenerator provided by Excalibur.
>         The configuration is specified in the file located in
>         <parameter>jakarta-avalon-excalibur/src/scratchpad/org/apache/avalon/excalibur/datasource/ids/test/TableIdGeneratorJdbcTestC
> ase.xtext</parameter>.
>         </para>
> Niclas
> WARN    11132   [jdbc    ] (): Could not prepare test statement, connection recycled on basis of time.
> java.sql.SQLException: Unexpected token:  in statement [SELECT 1]
>         at org.hsqldb.jdbc.jdbcUtil.throwError(Unknown Source)
>         at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
>         at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
>         at org.apache.avalon.excalibur.datasource.AbstractJdbcConnection.<init>(AbstractJdbcConnection.java:139)
>         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>         at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
>         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
> INFO    11132   [test.tes] (): testNonExistingTableName
> ERROR   11132   [id-gen  ] (): Unable to allocate a block of Ids, no row with table_name='does-not-exist' exists in the ids table.
> Niclas
> INFO    11132   [test.tes] (): testSimpleRequestIdsSize1
> Niclas
> INFO    11132   [test.tes] (): testSimpleRequestIdsSize10
> Niclas
> INFO    11132   [test.tes] (): testSimpleRequestIdsSize100
> Niclas
> INFO    11132   [test.tes] (): testBigDecimalRequestIdsSize10
> Niclas
> INFO    11132   [test.tes] (): testMaxByteIds
> ERROR   11132   [id-gen  ] (): Unable to provide an id.  The next id would be greater than the id data type allows.
> Niclas
> INFO    11132   [test.tes] (): testMaxShortIds
> ERROR   11132   [id-gen  ] (): Unable to provide an id.  The next id would be greater than the id data type allows.
> Niclas
> INFO    11132   [test.tes] (): testMaxIntegerIds
> ERROR   11132   [id-gen  ] (): Unable to provide an id.  The next id would be greater than the id data type allows.
> $
> INFO    11132   [test.tes] (): testMaxLongIds
> ERROR   11132   [id-gen  ] (): No more Ids are available, the maximum long value has been reached.
> WARN    11132   [cm      ] (): disposing of handler for unreleased component. role [org.apache.avalon.excalibur.datasource.DataSourc
> eComponentSelector]
>     [junit] Tests run: 9, Failures: 0, Errors: 0, Time elapsed: 1.078 sec
>     [junit] Running org.apache.avalon.excalibur.datasource.ids.test.TableIdGeneratorMultithreadedJdbcTestCase
> INFO    2005-04-11 19:25:22.968 [TableIdGeneratorMultithreadedJ] (): <title>TableIdGenerator Tests</title>
>         <para>
>         This series of tests excersizes the TableIdGenerator provided by Excalibur in a multithreaded context.
>         The configuration is specified in the file located in
>         <parameter>jakarta-avalon-excalibur/src/scratchpad/org/apache/avalon/excalibur/datasource/ids/test/TableIdGeneratorMultithre
> adedJdbcTestCase.xtext</parameter>.
>         </para>
> WARN    11132   [jdbc    ] (): Could not return Connection
> java.sql.SQLException: The database is already in use by another process: org.hsqldb.NIOLockFile@9fe164d[file =C:\Users\Shash\Java\L
> ibraries\excalibur-trunk\components\datasource\test.lck.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception:
>  The process cannot access the file because another process has locked a portion of the file : C:\Users\Shash\Java\Libraries\excalib
> ur-trunk\components\datasource\test.lck.lck
>         at org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
>         at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
>         at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
>         at org.hsqldb.jdbcDriver.connect(Unknown Source)
>         at java.sql.DriverManager.getConnection(DriverManager.java:512)
>         at java.sql.DriverManager.getConnection(DriverManager.java:171)
>         at org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:182)
> ERROR   2005-04-11 19:25:23.421 [test.tes] (): Unable to initialize database for test.
> java.sql.SQLException: The database is already in use by another process: org.hsqldb.NIOLockFile@9fe164d[file =C:\Users\Shash\Java\L
> ibraries\excalibur-trunk\components\datasource\test.lck.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception:
>  The process cannot access the file because another process has locked a portion of the file : C:\Users\Shash\Java\Libraries\excalib
> ur-trunk\components\datasource\test.lck.lck
>         at org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
>         at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
>         at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
>         at org.hsqldb.jdbcDriver.connect(Unknown Source)
>         at java.sql.DriverManager.getConnection(DriverManager.java:512)
>         at java.sql.DriverManager.getConnection(DriverManager.java:171)
>         at org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:182)
>         at org.apache.avalon.excalibur.pool.InstrumentedResourceLimitingPool.newPoolable(InstrumentedResourceLimitingPool.java:655)
>         at org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.newPoolable(ValidatedResourceLimitingPool.java:145)
>         at org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcConnectionPool.newPoolable(ResourceLimitingJdbcConnectionPool.
> java:91)
>         at org.apache.avalon.excalibur.pool.InstrumentedResourceLimitingPool.get(InstrumentedResourceLimitingPool.java:371)
>         at org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(ValidatedResourceLimitingPool.java:97)
>         at org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.getConnection(ResourceLimitingJdbcDataSource.java:1
> 93)
>         at org.apache.avalon.excalibur.datasource.ids.test.TableIdGeneratorMultithreadedJdbcTestCase.setUp(TableIdGeneratorMultithre
> adedJdbcTestCase.java:78)
>         at junit.framework.TestCase.runBare(TestCase.java:125)
>         at junit.framework.TestResult$1.protect(TestResult.java:106)
>         at junit.framework.TestResult.runProtected(TestResult.java:124)
>         at junit.framework.TestResult.run(TestResult.java:109)
>         at junit.framework.TestCase.run(TestCase.java:118)
>         at org.apache.avalon.excalibur.testcase.ExcaliburTestCase.run(ExcaliburTestCase.java:413)
>         at junit.framework.TestSuite.runTest(TestSuite.java:208)
>         at junit.framework.TestSuite.run(TestSuite.java:203)
>         at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnitTestRunner.java:325)
>         at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.executeInVM(JUnitTask.java:848)
>         at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.execute(JUnitTask.java:556)
>         at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.execute(JUnitTask.java:532)
>         at org.apache.tools.ant.Task.perform(Task.java:341)
>         at org.apache.commons.jelly.tags.ant.AntTag.doTag(AntTag.java:185)
>         at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:279)
>         at org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:135)
>         at org.apache.commons.jelly.TagSupport.invokeBody(TagSupport.java:233)
>         at org.apache.commons.jelly.tags.core.IfTag.doTag(IfTag.java:88)
>         at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:279)
>         at org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:135)
>         at org.apache.maven.jelly.tags.werkz.MavenGoalTag.runBodyTag(MavenGoalTag.java:79)
>         at org.apache.maven.jelly.tags.werkz.MavenGoalTag$MavenGoalAction.performAction(MavenGoalTag.java:110)
>         at com.werken.werkz.Goal.fire(Goal.java:639)
>         at com.werken.werkz.Goal.attain(Goal.java:575)
>         at com.werken.werkz.Goal.attainPrecursors(Goal.java:488)
>         at com.werken.werkz.Goal.attain(Goal.java:573)
>         at com.werken.werkz.Goal.attainPrecursors(Goal.java:488)
>         at com.werken.werkz.Goal.attain(Goal.java:573)
>         at org.apache.maven.plugin.PluginManager.attainGoals(PluginManager.java:671)
>         at org.apache.maven.MavenSession.attainGoals(MavenSession.java:263)
>         at org.apache.maven.cli.App.doMain(App.java:488)
>         at org.apache.maven.cli.App.main(App.java:1239)
>         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 com.werken.forehead.Forehead.run(Forehead.java:551)
>         at com.werken.forehead.Forehead.main(Forehead.java:581)
> WARN    11132   [jdbc    ] (): Could not return Connection
> java.sql.SQLException: The database is already in use by another process: org.hsqldb.NIOLockFile@9fe164d[file =C:\Users\Shash\Java\L
> ibraries\excalibur-trunk\components\datasource\test.lck.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception:
>  The process cannot access the file because another process has locked a portion of the file : C:\Users\Shash\Java\Libraries\excalib
> ur-trunk\components\datasource\test.lck.lck
>         at org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
>         at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
>         at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
>         at org.hsqldb.jdbcDriver.connect(Unknown Source)
>         at java.sql.DriverManager.getConnection(DriverManager.java:512)
>         at java.sql.DriverManager.getConnection(DriverManager.java:171)
>         at org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:182)
> ERROR   2005-04-11 19:25:23.468 [test.tes] (): Unable to initialize database for test.
> java.sql.SQLException: The database is already in use by another process: org.hsqldb.NIOLockFile@9fe164d[file =C:\Users\Shash\Java\L
> ibraries\excalibur-trunk\components\datasource\test.lck.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception:
>  The process cannot access the file because another process has locked a portion of the file : C:\Users\Shash\Java\Libraries\excalib
> ur-trunk\components\datasource\test.lck.lck
>         at org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
>         at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
>         at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
>         at org.hsqldb.jdbcDriver.connect(Unknown Source)
>         at java.sql.DriverManager.getConnection(DriverManager.java:512)
>         at java.sql.DriverManager.getConnection(DriverManager.java:171)
>         at org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:182)
>         at org.apache.avalon.excalibur.pool.InstrumentedResourceLimitingPool.newPoolable(InstrumentedResourceLimitingPool.java:655)
>         at org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.newPoolable(ValidatedResourceLimitingPool.java:145)
>         at org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcConnectionPool.newPoolable(ResourceLimitingJdbcConnectionPool.
> java:91)
>         at org.apache.avalon.excalibur.pool.InstrumentedResourceLimitingPool.get(InstrumentedResourceLimitingPool.java:371)
>         at org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(ValidatedResourceLimitingPool.java:97)
>         at org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.getConnection(ResourceLimitingJdbcDataSource.java:1
> 93)
>         at org.apache.avalon.excalibur.datasource.ids.test.TableIdGeneratorMultithreadedJdbcTestCase.setUp(TableIdGeneratorMultithre
> adedJdbcTestCase.java:78)
>         at junit.framework.TestCase.runBare(TestCase.java:125)
>         at junit.framework.TestResult$1.protect(TestResult.java:106)
>         at junit.framework.TestResult.runProtected(TestResult.java:124)
>         at junit.framework.TestResult.run(TestResult.java:109)
>         at junit.framework.TestCase.run(TestCase.java:118)
>         at org.apache.avalon.excalibur.testcase.ExcaliburTestCase.run(ExcaliburTestCase.java:413)
>         at junit.framework.TestSuite.runTest(TestSuite.java:208)
>         at junit.framework.TestSuite.run(TestSuite.java:203)
>         at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnitTestRunner.java:325)
>         at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.executeInVM(JUnitTask.java:848)
>         at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.execute(JUnitTask.java:556)
>         at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.execute(JUnitTask.java:532)
>         at org.apache.tools.ant.Task.perform(Task.java:341)
>         at org.apache.commons.jelly.tags.ant.AntTag.doTag(AntTag.java:185)
>         at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:279)
>         at org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:135)
>         at org.apache.commons.jelly.TagSupport.invokeBody(TagSupport.java:233)
>         at org.apache.commons.jelly.tags.core.IfTag.doTag(IfTag.java:88)
>         at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:279)
>         at org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:135)
>         at org.apache.maven.jelly.tags.werkz.MavenGoalTag.runBodyTag(MavenGoalTag.java:79)
>         at org.apache.maven.jelly.tags.werkz.MavenGoalTag$MavenGoalAction.performAction(MavenGoalTag.java:110)
>         at com.werken.werkz.Goal.fire(Goal.java:639)
>         at com.werken.werkz.Goal.attain(Goal.java:575)
>         at com.werken.werkz.Goal.attainPrecursors(Goal.java:488)
>         at com.werken.werkz.Goal.attain(Goal.java:573)
>         at com.werken.werkz.Goal.attainPrecursors(Goal.java:488)
>         at com.werken.werkz.Goal.attain(Goal.java:573)
>         at org.apache.maven.plugin.PluginManager.attainGoals(PluginManager.java:671)
>         at org.apache.maven.MavenSession.attainGoals(MavenSession.java:263)
>         at org.apache.maven.cli.App.doMain(App.java:488)
>         at org.apache.maven.cli.App.main(App.java:1239)
>         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 com.werken.forehead.Forehead.run(Forehead.java:551)
>         at com.werken.forehead.Forehead.main(Forehead.java:581)
> WARN    11132   [jdbc    ] (): Could not return Connection
> java.sql.SQLException: The database is already in use by another process: org.hsqldb.NIOLockFile@9fe164d[file =C:\Users\Shash\Java\L
> ibraries\excalibur-trunk\components\datasource\test.lck.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception:
>  The process cannot access the file because another process has locked a portion of the file : C:\Users\Shash\Java\Libraries\excalib
> ur-trunk\components\datasource\test.lck.lck
>         at org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
>         at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
>         at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
>         at org.hsqldb.jdbcDriver.connect(Unknown Source)
>         at java.sql.DriverManager.getConnection(DriverManager.java:512)
>         at java.sql.DriverManager.getConnection(DriverManager.java:171)
>         at org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:182)
> ERROR   2005-04-11 19:25:23.515 [test.tes] (): Unable to initialize database for test.
> java.sql.SQLException: The database is already in use by another process: org.hsqldb.NIOLockFile@9fe164d[file =C:\Users\Shash\Java\L
> ibraries\excalibur-trunk\components\datasource\test.lck.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception:
>  The process cannot access the file because another process has locked a portion of the file : C:\Users\Shash\Java\Libraries\excalib
> ur-trunk\components\datasource\test.lck.lck
>         at org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
>         at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
>         at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
>         at org.hsqldb.jdbcDriver.connect(Unknown Source)
>         at java.sql.DriverManager.getConnection(DriverManager.java:512)
>         at java.sql.DriverManager.getConnection(DriverManager.java:171)
>         at org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:182)
>         at org.apache.avalon.excalibur.pool.InstrumentedResourceLimitingPool.newPoolable(InstrumentedResourceLimitingPool.java:655)
>         at org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.newPoolable(ValidatedResourceLimitingPool.java:145)
>         at org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcConnectionPool.newPoolable(ResourceLimitingJdbcConnectionPool.
> java:91)
>         at org.apache.avalon.excalibur.pool.InstrumentedResourceLimitingPool.get(InstrumentedResourceLimitingPool.java:371)
>         at org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(ValidatedResourceLimitingPool.java:97)
>         at org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.getConnection(ResourceLimitingJdbcDataSource.java:1
> 93)
>         at org.apache.avalon.excalibur.datasource.ids.test.TableIdGeneratorMultithreadedJdbcTestCase.setUp(TableIdGeneratorMultithre
> adedJdbcTestCase.java:78)
>         at junit.framework.TestCase.runBare(TestCase.java:125)
>         at junit.framework.TestResult$1.protect(TestResult.java:106)
>         at junit.framework.TestResult.runProtected(TestResult.java:124)
>         at junit.framework.TestResult.run(TestResult.java:109)
>         at junit.framework.TestCase.run(TestCase.java:118)
>         at org.apache.avalon.excalibur.testcase.ExcaliburTestCase.run(ExcaliburTestCase.java:413)
>         at junit.framework.TestSuite.runTest(TestSuite.java:208)
>         at junit.framework.TestSuite.run(TestSuite.java:203)
>         at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnitTestRunner.java:325)
>         at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.executeInVM(JUnitTask.java:848)
>         at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.execute(JUnitTask.java:556)
>         at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.execute(JUnitTask.java:532)
>         at org.apache.tools.ant.Task.perform(Task.java:341)
>         at org.apache.commons.jelly.tags.ant.AntTag.doTag(AntTag.java:185)
>         at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:279)
>         at org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:135)
>         at org.apache.commons.jelly.TagSupport.invokeBody(TagSupport.java:233)
>         at org.apache.commons.jelly.tags.core.IfTag.doTag(IfTag.java:88)
>         at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:279)
>         at org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:135)
>         at org.apache.maven.jelly.tags.werkz.MavenGoalTag.runBodyTag(MavenGoalTag.java:79)
>         at org.apache.maven.jelly.tags.werkz.MavenGoalTag$MavenGoalAction.performAction(MavenGoalTag.java:110)
>         at com.werken.werkz.Goal.fire(Goal.java:639)
>         at com.werken.werkz.Goal.attain(Goal.java:575)
>         at com.werken.werkz.Goal.attainPrecursors(Goal.java:488)
>         at com.werken.werkz.Goal.attain(Goal.java:573)
>         at com.werken.werkz.Goal.attainPrecursors(Goal.java:488)
>         at com.werken.werkz.Goal.attain(Goal.java:573)
>         at org.apache.maven.plugin.PluginManager.attainGoals(PluginManager.java:671)
>         at org.apache.maven.MavenSession.attainGoals(MavenSession.java:263)
>         at org.apache.maven.cli.App.doMain(App.java:488)
>         at org.apache.maven.cli.App.main(App.java:1239)
>         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 com.werken.forehead.Forehead.run(Forehead.java:551)
>         at com.werken.forehead.Forehead.main(Forehead.java:581)
> WARN    11132   [jdbc    ] (): Could not return Connection
> java.sql.SQLException: The database is already in use by another process: org.hsqldb.NIOLockFile@9fe164d[file =C:\Users\Shash\Java\L
> ibraries\excalibur-trunk\components\datasource\test.lck.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception:
>  The process cannot access the file because another process has locked a portion of the file : C:\Users\Shash\Java\Libraries\excalib
> ur-trunk\components\datasource\test.lck.lck
>         at org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
>         at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
>         at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
>         at org.hsqldb.jdbcDriver.connect(Unknown Source)
>         at java.sql.DriverManager.getConnection(DriverManager.java:512)
>         at java.sql.DriverManager.getConnection(DriverManager.java:171)
>         at org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:182)
> ERROR   2005-04-11 19:25:23.640 [test.tes] (): Unable to initialize database for test.
> java.sql.SQLException: The database is already in use by another process: org.hsqldb.NIOLockFile@9fe164d[file =C:\Users\Shash\Java\L
> ibraries\excalibur-trunk\components\datasource\test.lck.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception:
>  The process cannot access the file because another process has locked a portion of the file : C:\Users\Shash\Java\Libraries\excalib
> ur-trunk\components\datasource\test.lck.lck
>         at org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
>         at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
>         at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
>         at org.hsqldb.jdbcDriver.connect(Unknown Source)
>         at java.sql.DriverManager.getConnection(DriverManager.java:512)
>         at java.sql.DriverManager.getConnection(DriverManager.java:171)
>         at org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:182)
>         at org.apache.avalon.excalibur.pool.InstrumentedResourceLimitingPool.newPoolable(InstrumentedResourceLimitingPool.java:655)
>         at org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.newPoolable(ValidatedResourceLimitingPool.java:145)
>         at org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcConnectionPool.newPoolable(ResourceLimitingJdbcConnectionPool.
> java:91)
>         at org.apache.avalon.excalibur.pool.InstrumentedResourceLimitingPool.get(InstrumentedResourceLimitingPool.java:371)
>         at org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(ValidatedResourceLimitingPool.java:97)
>         at org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.getConnection(ResourceLimitingJdbcDataSource.java:1
> 93)
>         at org.apache.avalon.excalibur.datasource.ids.test.TableIdGeneratorMultithreadedJdbcTestCase.setUp(TableIdGeneratorMultithre
> adedJdbcTestCase.java:78)
>         at junit.framework.TestCase.runBare(TestCase.java:125)
>         at junit.framework.TestResult$1.protect(TestResult.java:106)
>         at junit.framework.TestResult.runProtected(TestResult.java:124)
>         at junit.framework.TestResult.run(TestResult.java:109)
>         at junit.framework.TestCase.run(TestCase.java:118)
>         at org.apache.avalon.excalibur.testcase.ExcaliburTestCase.run(ExcaliburTestCase.java:413)
>         at junit.framework.TestSuite.runTest(TestSuite.java:208)
>         at junit.framework.TestSuite.run(TestSuite.java:203)
>         at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnitTestRunner.java:325)
>         at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.executeInVM(JUnitTask.java:848)
>         at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.execute(JUnitTask.java:556)
>         at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.execute(JUnitTask.java:532)
>         at org.apache.tools.ant.Task.perform(Task.java:341)
>         at org.apache.commons.jelly.tags.ant.AntTag.doTag(AntTag.java:185)
>         at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:279)
>         at org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:135)
>         at org.apache.commons.jelly.TagSupport.invokeBody(TagSupport.java:233)
>         at org.apache.commons.jelly.tags.core.IfTag.doTag(IfTag.java:88)
>         at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:279)
>         at org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:135)
>         at org.apache.maven.jelly.tags.werkz.MavenGoalTag.runBodyTag(MavenGoalTag.java:79)
>         at org.apache.maven.jelly.tags.werkz.MavenGoalTag$MavenGoalAction.performAction(MavenGoalTag.java:110)
>         at com.werken.werkz.Goal.fire(Goal.java:639)
>         at com.werken.werkz.Goal.attain(Goal.java:575)
>         at com.werken.werkz.Goal.attainPrecursors(Goal.java:488)
>         at com.werken.werkz.Goal.attain(Goal.java:573)
>         at com.werken.werkz.Goal.attainPrecursors(Goal.java:488)
>         at com.werken.werkz.Goal.attain(Goal.java:573)
>         at org.apache.maven.plugin.PluginManager.attainGoals(PluginManager.java:671)
>         at org.apache.maven.MavenSession.attainGoals(MavenSession.java:263)
>         at org.apache.maven.cli.App.doMain(App.java:488)
>         at org.apache.maven.cli.App.main(App.java:1239)
>         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 com.werken.forehead.Forehead.run(Forehead.java:551)
>         at com.werken.forehead.Forehead.main(Forehead.java:581)
> WARN    2005-04-11 19:25:23.640 [cm      ] (): disposing of handler for unreleased component. role [org.apache.avalon.excalibur.data
> source.DataSourceComponentSelector]
>     [junit] Tests run: 4, Failures: 4, Errors: 0, Time elapsed: 0.765 sec
>     [junit] [ERROR] TEST org.apache.avalon.excalibur.datasource.ids.test.TableIdGeneratorMultithreadedJdbcTestCase FAILED
>     [junit] Running org.apache.avalon.excalibur.datasource.test.DataSourceJdbcTestCase
> INFO    2005-04-11 19:25:23.812 [DataSourceJdbcTestCase        ] (): <title>DataSource Tests</title>
>       <para>
>         This series of tests exercise the JDBC DataSourceComponent provided by
>         Excalibur.  The configuration is specified in the file located in
>         <parameter>jakarta-avalon-excalibur/src/test/org/apache/avalon/excalibur/datasource/test/DataSourceJdbcTestCase.xtext</param
> eter>.
>         You may edit the test to customize the settings.
>       </para>
> WARN    11132   [test    ] (): Could not grow the pool properly, an exception was caught
> java.sql.SQLException: The database is already in use by another process: org.hsqldb.NIOLockFile@9fe164d[file =C:\Users\Shash\Java\L
> ibraries\excalibur-trunk\components\datasource\test.lck.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception:
>  The process cannot access the file because another process has locked a portion of the file : C:\Users\Shash\Java\Libraries\excalib
> ur-trunk\components\datasource\test.lck.lck
>         at org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
>         at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
>         at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
>         at org.hsqldb.jdbcDriver.connect(Unknown Source)
>         at java.sql.DriverManager.getConnection(DriverManager.java:512)
>         at java.sql.DriverManager.getConnection(DriverManager.java:171)
>         at org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:182)
> FATAL_E 11132   [test    ] (): Excalibur could not create any connections.  Examine your settings to make sure they are correct.  Ma
> ke sure you can connect with the same settings on your machine.
> WARN    11132   [test    ] (): Could not return Connection
> java.lang.IllegalStateException: You cannot get a Poolable before the pool is initialized
>         at org.apache.avalon.excalibur.pool.DefaultPool.get(DefaultPool.java:116)
>         at org.apache.avalon.excalibur.datasource.JdbcConnectionPool.get(JdbcConnectionPool.java:152)
>         at org.apache.avalon.excalibur.datasource.JdbcDataSource.getConnection(JdbcDataSource.java:250)
>         at org.apache.avalon.excalibur.datasource.test.DataSourceJdbcTestCase.testOverAllocation(DataSourceJdbcTestCase.java:65)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> INFO    11132   [test.tes] (): The test was successful
> WARN    11132   [test    ] (): Could not return Connection
> java.lang.IllegalStateException: There are no connections in the pool, check your settings.
>         at org.apache.avalon.excalibur.datasource.JdbcConnectionPool.get(JdbcConnectionPool.java:140)
>         at org.apache.avalon.excalibur.datasource.JdbcDataSource.getConnection(JdbcDataSource.java:250)
>         at org.apache.avalon.excalibur.datasource.test.DataSourceJdbcTestCase$ConnectionThread.run(DataSourceJdbcTestCase.java:179)
>         at java.lang.Thread.run(Thread.java:534)
> INFO    11132   [test.tes] (): Failed to get Connection, test failed
> org.apache.avalon.excalibur.datasource.NoAvailableConnectionException: There are no connections in the pool, check your settings.
>         at org.apache.avalon.excalibur.datasource.JdbcDataSource.getConnection(JdbcDataSource.java:269)
>         at org.apache.avalon.excalibur.datasource.test.DataSourceJdbcTestCase$ConnectionThread.run(DataSourceJdbcTestCase.java:179)
>         at java.lang.Thread.run(Thread.java:534)
> INFO    11132   [test.tes] (): The normal use test passed with 0 requests and 10 concurrent threads running
>     [junit] Tests run: 2, Failures: 1, Errors: 0, Time elapsed: 0.562 sec
>     [junit] [ERROR] TEST org.apache.avalon.excalibur.datasource.test.DataSourceJdbcTestCase FAILED
> BUILD FAILED
> File...... C:\Documents and Settings\SChatterjee\.maven\cache\maven-test-plugin-1.6.2\plugin.jelly
> Element... fail
> Line...... 181
> Column.... 54
> There were test failures.
> Total time: 7 seconds
> Finished at: Mon Apr 11 19:25:24 GMT-06:00 2005

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@excalibur.apache.org
For additional commands, e-mail: dev-help@excalibur.apache.org