You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openjpa.apache.org by chung huynh <ch...@realcom.co.jp> on 2007/09/08 18:29:57 UTC
Error when run apache-openjpa-1.0.0\examples\reversemapping\build.xml
I download apache-openjpa-1.0.0 binary, then import examples to Eclipse
follow this site:
http://openjpa.apache.org/quick-start.html
And i see error when run
apache-openjpa-1.0.0\examples\reversemapping\build.xml
Please help me.
Huynh Van Chung
Buildfile: C:\dev\apache-openjpa-1.0.0\examples\reversemapping\build.xml
initialize-db:
[sql] Executing file: C:\dev\apache-
openjpa-1.0.0\examples\reversemapping\schema\dropdb.sql
[sql] 7 of 7 SQL statements executed successfully
[sql] Executing file: C:\dev\apache-
openjpa-1.0.0\examples\reversemapping\schema\ToursDB_schema.sql
[sql] Executing file: C:\dev\apache-
openjpa-1.0.0\examples\reversemapping\schema\loadCOUNTRIES.sql
[sql] Executing file: C:\dev\apache-
openjpa-1.0.0\examples\reversemapping\schema\loadCITIES.sql
[sql] Executing file: C:\dev\apache-
openjpa-1.0.0\examples\reversemapping\schema\loadAIRLINES.sql
[sql] Executing file: C:\dev\apache-
openjpa-1.0.0\examples\reversemapping\schema\loadFLIGHTS1.sql
[sql] Executing file: C:\dev\apache-
openjpa-1.0.0\examples\reversemapping\schema\loadFLIGHTS2.sql
[sql] Executing file: C:\dev\apache-
openjpa-1.0.0\examples\reversemapping\schema\loadFLIGHTAVAILABILITY1.sql
[sql] Executing file: C:\dev\apache-
openjpa-1.0.0\examples\reversemapping\schema\loadFLIGHTAVAILABILITY2.sql
[sql] 1282 of 1282 SQL statements executed successfully
reverse-map-schema:
[reversemappingtool] 391 none INFO [main] openjpa.Tool - The reverse
mapping tool will run on the database. The tool is gathering schema
information; this process may take some time. Enable the
org.apache.openjpa.jdbc.Schema logging category to see messages about schema
data.
[reversemappingtool] 1063 none INFO [main] openjpa.jdbc.JDBC - Using
dictionary class "org.apache.openjpa.jdbc.sql.DerbyDictionary".
[reversemappingtool] java.sql.SQLException: Failed to start database
'C:\dev\apache-openjpa-1.0.0\examples\reversemapping/reversemapping-database',
see the next exception for details.
[reversemappingtool] at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
[reversemappingtool] at
org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown
Source)
[reversemappingtool] at
org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown
Source)
[reversemappingtool] at
org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
[reversemappingtool] at
org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
[reversemappingtool] at
org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
[reversemappingtool] at
org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown
Source)
[reversemappingtool] at
org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown
Source)
[reversemappingtool] at
org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Unknown
Source)
[reversemappingtool] at org.apache.derby.jdbc.InternalDriver.connect(Unknown
Source)
[reversemappingtool] at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown
Source)
[reversemappingtool] at
org.apache.openjpa.jdbc.schema.SimpleDriverDataSource.getConnection(
SimpleDriverDataSource.java:73)
[reversemappingtool] at
org.apache.openjpa.jdbc.schema.SimpleDriverDataSource.getConnection(
SimpleDriverDataSource.java:52)
[reversemappingtool] at
org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(
DelegatingDataSource.java:106)
[reversemappingtool] at
org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(
DecoratingDataSource.java:87)
[reversemappingtool] at
org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchema(
SchemaGenerator.java:328)
[reversemappingtool] at
org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchemas(
SchemaGenerator.java:263)
[reversemappingtool] at
org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchemas(
SchemaGenerator.java:243)
[reversemappingtool] at org.apache.openjpa.jdbc.meta.ReverseMappingTool.run(
ReverseMappingTool.java:1970)
[reversemappingtool] at
org.apache.openjpa.jdbc.ant.ReverseMappingToolTask.executeOn(
ReverseMappingToolTask.java:287)
[reversemappingtool] at org.apache.openjpa.lib.ant.AbstractTask.execute(
AbstractTask.java:172)
[reversemappingtool] at org.apache.tools.ant.UnknownElement.execute(
UnknownElement.java:275)
[reversemappingtool] at org.apache.tools.ant.Task.perform(Task.java:364)
[reversemappingtool] at org.apache.tools.ant.Target.execute(Target.java:341)
[reversemappingtool] at org.apache.tools.ant.Target.performTasks(Target.java
:369)
[reversemappingtool] at org.apache.tools.ant.Project.executeSortedTargets(
Project.java:1216)
[reversemappingtool] at org.apache.tools.ant.Project.executeTarget(
Project.java:1185)
[reversemappingtool] at
org.apache.tools.ant.helper.DefaultExecutor.executeTargets(
DefaultExecutor.java:40)
[reversemappingtool] at
org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTargets
(EclipseDefaultExecutor.java:32)
[reversemappingtool] at org.apache.tools.ant.Project.executeTargets(
Project.java:1068)
[reversemappingtool] at
org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(
InternalAntRunner.java:423)
[reversemappingtool] at
org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(
InternalAntRunner.java:137)
BUILD FAILED
C:\dev\apache-openjpa-1.0.0\examples\reversemapping\build.xml:77:
java.sql.SQLException: Failed to start database 'C:\dev\apache-
openjpa-1.0.0\examples\reversemapping/reversemapping-database', see the next
exception for details.
Total time: 24 seconds
Re: Error when run
apache-openjpa-1.0.0\examples\reversemapping\build.xml
Posted by Bill Slack <ws...@shaw.ca>.
Thanks Mike,
I appreciate your assistance.
Bill
----- Original Message -----
From: Michael Dick
To: users@openjpa.apache.org
Sent: Wednesday, September 19, 2007 8:49 PM
Subject: Re: Error when run apache-openjpa-1.0.0\examples\reversemapping\build.xml
Hi Bill,
Another way to skip the initialize-db step is to run ant like this
ant -Dinitialize-db-skip=true [target]
ie to do nothing run
ant -Dinitialize-db-skip=true initialize-db
I've attached an updated build.xml too in case you'd prefer that.
Hope this helps,
-Mike
On 9/19/07, Bill Slack < wslack@shaw.ca> wrote:
I am having the same problems that you initially were experiencing running
the sample 'reversemapping'; however, your remedy isn't working for me.
I am not altogether familiar with Ant, so would it be too much trouble to
ask you to send me a copy of the build file so I can see exactly what you
changed?
Thanks,
Bill
----- Original Message -----
From: "Huynh Van Chung" < chung_huynh@realcom.co.jp>
To: <us...@openjpa.apache.org>
Sent: Thursday, September 13, 2007 6:18 PM
Subject: Re: Error when run
apache-openjpa-1.0.0\examples\reversemapping\build.xml
> Hi all,
>
> I have solved this problem. It is error when using derby database.
> I see in this site:
> http://db.apache.org/derby/papers/DerbyTut/embedded_intro.html
> "However, only one JVM may boot ("open") that database, so multiple
> applications running in /different/ JVMs cannot access the same database."
>
> So in reversemapping\build.xml task, reverse-map-schema task depend on
> initialize-db, and so we will fail to run reverse-map-shema when open
> derby database.
> I make the reverse-map-schema task not depend on initialize-db, and then
> run initialize-db, run reverse-map-schema, it work ok.
>
> Huynh Van Chung
>
> chung huynh さんは書きました:
>> I download apache-openjpa-1.0.0 binary, then import examples to Eclipse
>> follow this site:
>> http://openjpa.apache.org/quick-start.html
>>
>> And i see error when run
>> apache-openjpa-1.0.0\examples\reversemapping\build.xml
>> Please help me.
>>
>> Huynh Van Chung
>>
>> Buildfile: C:\dev\apache-openjpa-1.0.0\examples\reversemapping\build.xml
>> initialize-db:
>> [sql] Executing file: C:\dev\apache-
>> openjpa-1.0.0\examples\reversemapping\schema\dropdb.sql
>> [sql] 7 of 7 SQL statements executed successfully
>> [sql] Executing file:
>> C:\dev\apache-openjpa-1.0.0\examples\reversemapping\schema\ToursDB_schema.sql
>> [sql] Executing file:
>> C:\dev\apache-openjpa-1.0.0\examples\reversemapping\schema\loadCOUNTRIES.sql
>> [sql] Executing file:
>> C:\dev\apache-openjpa-1.0.0\examples\reversemapping\schema\loadCITIES.sql
>> [sql] Executing file: C:\dev\apache-
>> openjpa-1.0.0\examples\reversemapping\schema\loadAIRLINES.sql
>> [sql] Executing file:
>> C:\dev\apache-openjpa-1.0.0\examples\reversemapping\schema\loadFLIGHTS1.sql
>> [sql] Executing file:
>> C:\dev\apache-openjpa-1.0.0\examples\reversemapping\schema\loadFLIGHTS2.sql
>> [sql] Executing file:
>> C:\dev\apache-openjpa-1.0.0\examples\reversemapping\schema\loadFLIGHTAVAILABILITY1.sql
>> [sql] Executing file:
>> C:\dev\apache-openjpa-1.0.0\examples\reversemapping\schema\loadFLIGHTAVAILABILITY2.sql
>> [sql] 1282 of 1282 SQL statements executed successfully
>> reverse-map-schema:
>> [reversemappingtool] 391 none INFO [main] openjpa.Tool - The reverse
>> mapping tool will run on the database. The tool is gathering schema
>> information; this process may take some time. Enable the
>> org.apache.openjpa.jdbc.Schema logging category to see messages about
>> schema data.
>> [reversemappingtool] 1063 none INFO [main] openjpa.jdbc.JDBC - Using
>> dictionary class " org.apache.openjpa.jdbc.sql.DerbyDictionary ".
>> [reversemappingtool] java.sql.SQLException: Failed to start database
>> 'C:\dev\apache-openjpa-1.0.0\examples\reversemapping/reversemapping-database ',
>> see the next exception for details.
>> [reversemappingtool] at
>> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
>> Source)
>> [reversemappingtool] at
>> org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
>> [reversemappingtool] at
>> org.apache.derby.impl.jdbc.Util.newEmbedSQLException (Unknown Source)
>> [reversemappingtool] at
>> org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
>> [reversemappingtool] at
>> org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown
>> Source)
>> [reversemappingtool] at
>> org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
>> [reversemappingtool] at
>> org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
>> [reversemappingtool] at org.apache.derby.impl.jdbc.EmbedConnection30
>> .<init>(Unknown Source)
>> [reversemappingtool] at
>> org.apache.derby.jdbc.Driver30.getNewEmbedConnection (Unknown Source)
>> [reversemappingtool] at
>> org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
>> [reversemappingtool] at
>> org.apache.derby.jdbc.AutoloadedDriver.connect (Unknown Source)
>> [reversemappingtool] at
>> org.apache.openjpa.jdbc.schema.SimpleDriverDataSource.getConnection(SimpleDriverDataSource.java:73)
>> [reversemappingtool] at
>> org.apache.openjpa.jdbc.schema.SimpleDriverDataSource.getConnection
>> (SimpleDriverDataSource.java:52)
>> [reversemappingtool] at
>> org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:106)
>> [reversemappingtool] at
>> org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection
>> (DecoratingDataSource.java:87)
>> [reversemappingtool] at
>> org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchema (SchemaGenerator.java:328)
>> [reversemappingtool] at
>> org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchemas
>> (SchemaGenerator.java:263)
>> [reversemappingtool] at
>> org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchemas(SchemaGenerator.java:243)
>> [reversemappingtool] at
>> org.apache.openjpa.jdbc.meta.ReverseMappingTool.run
>> (ReverseMappingTool.java :1970)
>> [reversemappingtool] at
>> org.apache.openjpa.jdbc.ant.ReverseMappingToolTask.executeOn(ReverseMappingToolTask.java:287)
>> [reversemappingtool] at org.apache.openjpa.lib.ant.AbstractTask.execute
>> (AbstractTask.java:172)
>> [reversemappingtool] at
>> org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
>> [reversemappingtool] at org.apache.tools.ant.Task.perform (Task.java:364)
>> [reversemappingtool] at
>> org.apache.tools.ant.Target.execute(Target.java:341)
>> [reversemappingtool] at
>> org.apache.tools.ant.Target.performTasks(Target.java:369)
>> [reversemappingtool] at
>> org.apache.tools.ant.Project.executeSortedTargets(Project.java :1216)
>> [reversemappingtool] at
>> org.apache.tools.ant.Project.executeTarget(Project.java :1185)
>> [reversemappingtool] at
>> org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
>> [reversemappingtool] at
>> org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTargets (EclipseDefaultExecutor.java:32)
>> [reversemappingtool] at
>> org.apache.tools.ant.Project.executeTargets(Project.java:1068)
>> [reversemappingtool] at
>> org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run (InternalAntRunner.java:423)
>> [reversemappingtool] at
>> org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)
>>
>> BUILD FAILED
>> C:\dev\apache- openjpa-1.0.0\examples\reversemapping\build.xml:77:
>> java.sql.SQLException: Failed to start database
>> 'C:\dev\apache-openjpa-1.0.0\examples\reversemapping/reversemapping-database',
>> see the next exception for details.
>>
>> Total time: 24 seconds
>>
>
Re: Error when run apache-openjpa-1.0.0\examples\reversemapping\build.xml
Posted by Michael Dick <mi...@gmail.com>.
Hi Bill,
Another way to skip the initialize-db step is to run ant like this
ant -Dinitialize-db-skip=true [target]
ie to do nothing run
ant -Dinitialize-db-skip=true initialize-db
I've attached an updated build.xml too in case you'd prefer that.
Hope this helps,
-Mike
On 9/19/07, Bill Slack <ws...@shaw.ca> wrote:
>
> I am having the same problems that you initially were experiencing running
> the sample 'reversemapping'; however, your remedy isn't working for me.
> I am not altogether familiar with Ant, so would it be too much trouble to
> ask you to send me a copy of the build file so I can see exactly what you
> changed?
> Thanks,
> Bill
>
> ----- Original Message -----
> From: "Huynh Van Chung" < chung_huynh@realcom.co.jp>
> To: <us...@openjpa.apache.org>
> Sent: Thursday, September 13, 2007 6:18 PM
> Subject: Re: Error when run
> apache-openjpa-1.0.0\examples\reversemapping\build.xml
>
>
> > Hi all,
> >
> > I have solved this problem. It is error when using derby database.
> > I see in this site:
> > http://db.apache.org/derby/papers/DerbyTut/embedded_intro.html
> > "However, only one JVM may boot ("open") that database, so multiple
> > applications running in /different/ JVMs cannot access the same
> database."
> >
> > So in reversemapping\build.xml task, reverse-map-schema task depend on
> > initialize-db, and so we will fail to run reverse-map-shema when open
> > derby database.
> > I make the reverse-map-schema task not depend on initialize-db, and then
> > run initialize-db, run reverse-map-schema, it work ok.
> >
> > Huynh Van Chung
> >
> > chung huynh さんは書きました:
> >> I download apache-openjpa-1.0.0 binary, then import examples to Eclipse
> >> follow this site:
> >> http://openjpa.apache.org/quick-start.html
> >>
> >> And i see error when run
> >> apache-openjpa-1.0.0\examples\reversemapping\build.xml
> >> Please help me.
> >>
> >> Huynh Van Chung
> >>
> >> Buildfile: C:\dev\apache-
> openjpa-1.0.0\examples\reversemapping\build.xml
> >> initialize-db:
> >> [sql] Executing file: C:\dev\apache-
> >> openjpa-1.0.0\examples\reversemapping\schema\dropdb.sql
> >> [sql] 7 of 7 SQL statements executed successfully
> >> [sql] Executing file:
> >> C:\dev\apache-
> openjpa-1.0.0\examples\reversemapping\schema\ToursDB_schema.sql
> >> [sql] Executing file:
> >> C:\dev\apache-
> openjpa-1.0.0\examples\reversemapping\schema\loadCOUNTRIES.sql
> >> [sql] Executing file:
> >> C:\dev\apache-
> openjpa-1.0.0\examples\reversemapping\schema\loadCITIES.sql
> >> [sql] Executing file: C:\dev\apache-
> >> openjpa-1.0.0\examples\reversemapping\schema\loadAIRLINES.sql
> >> [sql] Executing file:
> >> C:\dev\apache-
> openjpa-1.0.0\examples\reversemapping\schema\loadFLIGHTS1.sql
> >> [sql] Executing file:
> >> C:\dev\apache-
> openjpa-1.0.0\examples\reversemapping\schema\loadFLIGHTS2.sql
> >> [sql] Executing file:
> >> C:\dev\apache-
> openjpa-1.0.0\examples\reversemapping\schema\loadFLIGHTAVAILABILITY1.sql
> >> [sql] Executing file:
> >> C:\dev\apache-
> openjpa-1.0.0\examples\reversemapping\schema\loadFLIGHTAVAILABILITY2.sql
> >> [sql] 1282 of 1282 SQL statements executed successfully
> >> reverse-map-schema:
> >> [reversemappingtool] 391 none INFO [main] openjpa.Tool - The reverse
> >> mapping tool will run on the database. The tool is gathering schema
> >> information; this process may take some time. Enable the
> >> org.apache.openjpa.jdbc.Schema logging category to see messages about
> >> schema data.
> >> [reversemappingtool] 1063 none INFO [main] openjpa.jdbc.JDBC - Using
> >> dictionary class " org.apache.openjpa.jdbc.sql.DerbyDictionary ".
> >> [reversemappingtool] java.sql.SQLException: Failed to start database
> >> 'C:\dev\apache-
> openjpa-1.0.0\examples\reversemapping/reversemapping-database ',
> >> see the next exception for details.
> >> [reversemappingtool] at
> >> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
> >> Source)
> >> [reversemappingtool] at
> >> org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
> >> [reversemappingtool] at
> >> org.apache.derby.impl.jdbc.Util.newEmbedSQLException (Unknown Source)
> >> [reversemappingtool] at
> >> org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
> >> [reversemappingtool] at
> >> org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown
> >> Source)
> >> [reversemappingtool] at
> >> org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
> >> [reversemappingtool] at
> >> org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
> >> [reversemappingtool] at org.apache.derby.impl.jdbc.EmbedConnection30
> >> .<init>(Unknown Source)
> >> [reversemappingtool] at
> >> org.apache.derby.jdbc.Driver30.getNewEmbedConnection (Unknown Source)
> >> [reversemappingtool] at
> >> org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
> >> [reversemappingtool] at
> >> org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
> >> [reversemappingtool] at
> >> org.apache.openjpa.jdbc.schema.SimpleDriverDataSource.getConnection(
> SimpleDriverDataSource.java:73)
> >> [reversemappingtool] at
> >> org.apache.openjpa.jdbc.schema.SimpleDriverDataSource.getConnection
> >> (SimpleDriverDataSource.java:52)
> >> [reversemappingtool] at
> >> org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(
> DelegatingDataSource.java:106)
> >> [reversemappingtool] at
> >> org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection
> >> (DecoratingDataSource.java:87)
> >> [reversemappingtool] at
> >> org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchema (
> SchemaGenerator.java:328)
> >> [reversemappingtool] at
> >> org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchemas
> >> (SchemaGenerator.java:263)
> >> [reversemappingtool] at
> >> org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchemas(
> SchemaGenerator.java:243)
> >> [reversemappingtool] at
> >> org.apache.openjpa.jdbc.meta.ReverseMappingTool.run
> >> (ReverseMappingTool.java :1970)
> >> [reversemappingtool] at
> >> org.apache.openjpa.jdbc.ant.ReverseMappingToolTask.executeOn(
> ReverseMappingToolTask.java:287)
> >> [reversemappingtool] at org.apache.openjpa.lib.ant.AbstractTask.execute
> >> (AbstractTask.java:172)
> >> [reversemappingtool] at
> >> org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
> >> [reversemappingtool] at org.apache.tools.ant.Task.perform (Task.java
> :364)
> >> [reversemappingtool] at
> >> org.apache.tools.ant.Target.execute(Target.java:341)
> >> [reversemappingtool] at
> >> org.apache.tools.ant.Target.performTasks(Target.java:369)
> >> [reversemappingtool] at
> >> org.apache.tools.ant.Project.executeSortedTargets(Project.java :1216)
> >> [reversemappingtool] at
> >> org.apache.tools.ant.Project.executeTarget(Project.java :1185)
> >> [reversemappingtool] at
> >> org.apache.tools.ant.helper.DefaultExecutor.executeTargets(
> DefaultExecutor.java:40)
> >> [reversemappingtool] at
> >>
> org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTargets(
> EclipseDefaultExecutor.java:32)
> >> [reversemappingtool] at
> >> org.apache.tools.ant.Project.executeTargets(Project.java:1068)
> >> [reversemappingtool] at
> >> org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run (
> InternalAntRunner.java:423)
> >> [reversemappingtool] at
> >> org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(
> InternalAntRunner.java:137)
> >>
> >> BUILD FAILED
> >> C:\dev\apache- openjpa-1.0.0\examples\reversemapping\build.xml:77:
> >> java.sql.SQLException: Failed to start database
> >> 'C:\dev\apache-
> openjpa-1.0.0\examples\reversemapping/reversemapping-database',
> >> see the next exception for details.
> >>
> >> Total time: 24 seconds
> >>
> >
>
>
Re: Error when run
apache-openjpa-1.0.0\examples\reversemapping\build.xml
Posted by Bill Slack <ws...@shaw.ca>.
I am having the same problems that you initially were experiencing running
the sample 'reversemapping'; however, your remedy isn't working for me.
I am not altogether familiar with Ant, so would it be too much trouble to
ask you to send me a copy of the build file so I can see exactly what you
changed?
Thanks,
Bill
----- Original Message -----
From: "Huynh Van Chung" <ch...@realcom.co.jp>
To: <us...@openjpa.apache.org>
Sent: Thursday, September 13, 2007 6:18 PM
Subject: Re: Error when run
apache-openjpa-1.0.0\examples\reversemapping\build.xml
> Hi all,
>
> I have solved this problem. It is error when using derby database.
> I see in this site:
> http://db.apache.org/derby/papers/DerbyTut/embedded_intro.html
> "However, only one JVM may boot ("open") that database, so multiple
> applications running in /different/ JVMs cannot access the same database."
>
> So in reversemapping\build.xml task, reverse-map-schema task depend on
> initialize-db, and so we will fail to run reverse-map-shema when open
> derby database.
> I make the reverse-map-schema task not depend on initialize-db, and then
> run initialize-db, run reverse-map-schema, it work ok.
>
> Huynh Van Chung
>
> chung huynh さんは書きました:
>> I download apache-openjpa-1.0.0 binary, then import examples to Eclipse
>> follow this site:
>> http://openjpa.apache.org/quick-start.html
>>
>> And i see error when run
>> apache-openjpa-1.0.0\examples\reversemapping\build.xml
>> Please help me.
>>
>> Huynh Van Chung
>>
>> Buildfile: C:\dev\apache-openjpa-1.0.0\examples\reversemapping\build.xml
>> initialize-db:
>> [sql] Executing file: C:\dev\apache-
>> openjpa-1.0.0\examples\reversemapping\schema\dropdb.sql
>> [sql] 7 of 7 SQL statements executed successfully
>> [sql] Executing file:
>> C:\dev\apache-openjpa-1.0.0\examples\reversemapping\schema\ToursDB_schema.sql
>> [sql] Executing file:
>> C:\dev\apache-openjpa-1.0.0\examples\reversemapping\schema\loadCOUNTRIES.sql
>> [sql] Executing file:
>> C:\dev\apache-openjpa-1.0.0\examples\reversemapping\schema\loadCITIES.sql
>> [sql] Executing file: C:\dev\apache-
>> openjpa-1.0.0\examples\reversemapping\schema\loadAIRLINES.sql
>> [sql] Executing file:
>> C:\dev\apache-openjpa-1.0.0\examples\reversemapping\schema\loadFLIGHTS1.sql
>> [sql] Executing file:
>> C:\dev\apache-openjpa-1.0.0\examples\reversemapping\schema\loadFLIGHTS2.sql
>> [sql] Executing file:
>> C:\dev\apache-openjpa-1.0.0\examples\reversemapping\schema\loadFLIGHTAVAILABILITY1.sql
>> [sql] Executing file:
>> C:\dev\apache-openjpa-1.0.0\examples\reversemapping\schema\loadFLIGHTAVAILABILITY2.sql
>> [sql] 1282 of 1282 SQL statements executed successfully
>> reverse-map-schema:
>> [reversemappingtool] 391 none INFO [main] openjpa.Tool - The reverse
>> mapping tool will run on the database. The tool is gathering schema
>> information; this process may take some time. Enable the
>> org.apache.openjpa.jdbc.Schema logging category to see messages about
>> schema data.
>> [reversemappingtool] 1063 none INFO [main] openjpa.jdbc.JDBC - Using
>> dictionary class "org.apache.openjpa.jdbc.sql.DerbyDictionary ".
>> [reversemappingtool] java.sql.SQLException: Failed to start database
>> 'C:\dev\apache-openjpa-1.0.0\examples\reversemapping/reversemapping-database',
>> see the next exception for details.
>> [reversemappingtool] at
>> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
>> Source)
>> [reversemappingtool] at
>> org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
>> [reversemappingtool] at
>> org.apache.derby.impl.jdbc.Util.newEmbedSQLException (Unknown Source)
>> [reversemappingtool] at
>> org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
>> [reversemappingtool] at
>> org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown
>> Source)
>> [reversemappingtool] at
>> org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
>> [reversemappingtool] at
>> org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
>> [reversemappingtool] at org.apache.derby.impl.jdbc.EmbedConnection30
>> .<init>(Unknown Source)
>> [reversemappingtool] at
>> org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Unknown Source)
>> [reversemappingtool] at
>> org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
>> [reversemappingtool] at
>> org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
>> [reversemappingtool] at
>> org.apache.openjpa.jdbc.schema.SimpleDriverDataSource.getConnection(SimpleDriverDataSource.java:73)
>> [reversemappingtool] at
>> org.apache.openjpa.jdbc.schema.SimpleDriverDataSource.getConnection
>> (SimpleDriverDataSource.java:52)
>> [reversemappingtool] at
>> org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:106)
>> [reversemappingtool] at
>> org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection
>> (DecoratingDataSource.java:87)
>> [reversemappingtool] at
>> org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchema(SchemaGenerator.java:328)
>> [reversemappingtool] at
>> org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchemas
>> (SchemaGenerator.java:263)
>> [reversemappingtool] at
>> org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchemas(SchemaGenerator.java:243)
>> [reversemappingtool] at
>> org.apache.openjpa.jdbc.meta.ReverseMappingTool.run
>> (ReverseMappingTool.java:1970)
>> [reversemappingtool] at
>> org.apache.openjpa.jdbc.ant.ReverseMappingToolTask.executeOn(ReverseMappingToolTask.java:287)
>> [reversemappingtool] at org.apache.openjpa.lib.ant.AbstractTask.execute
>> (AbstractTask.java:172)
>> [reversemappingtool] at
>> org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
>> [reversemappingtool] at org.apache.tools.ant.Task.perform(Task.java:364)
>> [reversemappingtool] at
>> org.apache.tools.ant.Target.execute(Target.java:341)
>> [reversemappingtool] at
>> org.apache.tools.ant.Target.performTasks(Target.java:369)
>> [reversemappingtool] at
>> org.apache.tools.ant.Project.executeSortedTargets(Project.java :1216)
>> [reversemappingtool] at
>> org.apache.tools.ant.Project.executeTarget(Project.java:1185)
>> [reversemappingtool] at
>> org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
>> [reversemappingtool] at
>> org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTargets(EclipseDefaultExecutor.java:32)
>> [reversemappingtool] at
>> org.apache.tools.ant.Project.executeTargets(Project.java:1068)
>> [reversemappingtool] at
>> org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423)
>> [reversemappingtool] at
>> org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)
>>
>> BUILD FAILED
>> C:\dev\apache-openjpa-1.0.0\examples\reversemapping\build.xml:77:
>> java.sql.SQLException: Failed to start database
>> 'C:\dev\apache-openjpa-1.0.0\examples\reversemapping/reversemapping-database',
>> see the next exception for details.
>>
>> Total time: 24 seconds
>>
>
Re: Error when run apache-openjpa-1.0.0\examples\reversemapping\build.xml
Posted by Huynh Van Chung <ch...@realcom.co.jp>.
Hi all,
I have solved this problem. It is error when using derby database.
I see in this site:
http://db.apache.org/derby/papers/DerbyTut/embedded_intro.html
"However, only one JVM may boot ("open") that database, so multiple
applications running in /different/ JVMs cannot access the same database."
So in reversemapping\build.xml task, reverse-map-schema task depend on
initialize-db, and so we will fail to run reverse-map-shema when open
derby database.
I make the reverse-map-schema task not depend on initialize-db, and then
run initialize-db, run reverse-map-schema, it work ok.
Huynh Van Chung
chung huynh さんは書きました:
> I download apache-openjpa-1.0.0 binary, then import examples to
> Eclipse follow this site:
> http://openjpa.apache.org/quick-start.html
>
> And i see error when run
> apache-openjpa-1.0.0\examples\reversemapping\build.xml
> Please help me.
>
> Huynh Van Chung
>
> Buildfile: C:\dev\apache-openjpa-1.0.0\examples\reversemapping\build.xml
> initialize-db:
> [sql] Executing file: C:\dev\apache-
> openjpa-1.0.0\examples\reversemapping\schema\dropdb.sql
> [sql] 7 of 7 SQL statements executed successfully
> [sql] Executing file:
> C:\dev\apache-openjpa-1.0.0\examples\reversemapping\schema\ToursDB_schema.sql
>
> [sql] Executing file:
> C:\dev\apache-openjpa-1.0.0\examples\reversemapping\schema\loadCOUNTRIES.sql
> [sql] Executing file:
> C:\dev\apache-openjpa-1.0.0\examples\reversemapping\schema\loadCITIES.sql
> [sql] Executing file: C:\dev\apache-
> openjpa-1.0.0\examples\reversemapping\schema\loadAIRLINES.sql
> [sql] Executing file:
> C:\dev\apache-openjpa-1.0.0\examples\reversemapping\schema\loadFLIGHTS1.sql
> [sql] Executing file:
> C:\dev\apache-openjpa-1.0.0\examples\reversemapping\schema\loadFLIGHTS2.sql
>
> [sql] Executing file:
> C:\dev\apache-openjpa-1.0.0\examples\reversemapping\schema\loadFLIGHTAVAILABILITY1.sql
> [sql] Executing file:
> C:\dev\apache-openjpa-1.0.0\examples\reversemapping\schema\loadFLIGHTAVAILABILITY2.sql
>
> [sql] 1282 of 1282 SQL statements executed successfully
> reverse-map-schema:
> [reversemappingtool] 391 none INFO [main] openjpa.Tool - The reverse
> mapping tool will run on the database. The tool is gathering schema
> information; this process may take some time. Enable the
> org.apache.openjpa.jdbc.Schema logging category to see messages about
> schema data.
> [reversemappingtool] 1063 none INFO [main] openjpa.jdbc.JDBC - Using
> dictionary class "org.apache.openjpa.jdbc.sql.DerbyDictionary ".
> [reversemappingtool] java.sql.SQLException: Failed to start database
> 'C:\dev\apache-openjpa-1.0.0\examples\reversemapping/reversemapping-database',
> see the next exception for details.
> [reversemappingtool] at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
> Source)
> [reversemappingtool] at
> org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
> [reversemappingtool] at
> org.apache.derby.impl.jdbc.Util.newEmbedSQLException (Unknown Source)
> [reversemappingtool] at
> org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
> [reversemappingtool] at
> org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
> [reversemappingtool] at
> org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
> [reversemappingtool] at
> org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
> [reversemappingtool] at org.apache.derby.impl.jdbc.EmbedConnection30
> .<init>(Unknown Source)
> [reversemappingtool] at
> org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Unknown Source)
> [reversemappingtool] at
> org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
> [reversemappingtool] at
> org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
> [reversemappingtool] at
> org.apache.openjpa.jdbc.schema.SimpleDriverDataSource.getConnection(SimpleDriverDataSource.java:73)
> [reversemappingtool] at
> org.apache.openjpa.jdbc.schema.SimpleDriverDataSource.getConnection
> (SimpleDriverDataSource.java:52)
> [reversemappingtool] at
> org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:106)
> [reversemappingtool] at
> org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection
> (DecoratingDataSource.java:87)
> [reversemappingtool] at
> org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchema(SchemaGenerator.java:328)
> [reversemappingtool] at
> org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchemas
> (SchemaGenerator.java:263)
> [reversemappingtool] at
> org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchemas(SchemaGenerator.java:243)
> [reversemappingtool] at
> org.apache.openjpa.jdbc.meta.ReverseMappingTool.run
> (ReverseMappingTool.java:1970)
> [reversemappingtool] at
> org.apache.openjpa.jdbc.ant.ReverseMappingToolTask.executeOn(ReverseMappingToolTask.java:287)
> [reversemappingtool] at
> org.apache.openjpa.lib.ant.AbstractTask.execute (AbstractTask.java:172)
> [reversemappingtool] at
> org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
> [reversemappingtool] at org.apache.tools.ant.Task.perform(Task.java:364)
> [reversemappingtool] at
> org.apache.tools.ant.Target.execute(Target.java:341)
> [reversemappingtool] at
> org.apache.tools.ant.Target.performTasks(Target.java:369)
> [reversemappingtool] at
> org.apache.tools.ant.Project.executeSortedTargets(Project.java :1216)
> [reversemappingtool] at
> org.apache.tools.ant.Project.executeTarget(Project.java:1185)
> [reversemappingtool] at
> org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
> [reversemappingtool] at
> org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTargets(EclipseDefaultExecutor.java:32)
> [reversemappingtool] at
> org.apache.tools.ant.Project.executeTargets(Project.java:1068)
> [reversemappingtool] at
> org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423)
> [reversemappingtool] at
> org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)
>
> BUILD FAILED
> C:\dev\apache-openjpa-1.0.0\examples\reversemapping\build.xml:77:
> java.sql.SQLException: Failed to start database
> 'C:\dev\apache-openjpa-1.0.0\examples\reversemapping/reversemapping-database',
> see the next exception for details.
>
> Total time: 24 seconds
>