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
