openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Steve Cameron <>
Subject reverse mapping an SQL server database[SEC=UNCLASSIFIED]
Date Thu, 08 Mar 2012 10:36:17 GMT

I am just starting out to try openJPA and have a problem trying to reverse map an existing
SQL Server database.

The DB is one I just migrated from Access to SS if that makes any difference.

The batch script I am using  is as follows:

the batch file I am usings is as follows:

java ^
-cp openjpa-all-2.2.0.jar;"C:/Program Files/Java/sqljdbc_3.0/enu/sqljdbc4.jar" ^
 org.apache.openjpa.jdbc.meta.ReverseMappingTool  ^
-pkg  ^
-ConnectionDriverName ^
-ConnectionURL jdbc:sqlserver://localhost\SQLEXPRESS;databaseName=Fishlog; ^
-ConnectionUserName sa ^
-ConnectionPassword password  ^
-openjpa.Log "File=c:/temp/openjpa.log, DefaultLevel=TRACE, Runtime=TRACE, Tool=TRACE, Schema=TRACE"

The result of this is that the ReverseMappingTool connects to the database, gives the following
messages and  then just goes to sleep (apparently - I've waited for 20 minutes for something
to happen!).

967  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
3822  INFO   [main] openjpa.jdbc.JDBC - Using dictionary class "org.apache.openj

Is there any way to diagnose what is going wrong, no logfile is being created.

Stephen Cameron
Antarctic Fisheries Computing and Database Support Provider
Australian Antarctic Division
Kingston, Tasmania

Phone: 03 62323571


    Australian Antarctic Division - Commonwealth of Australia
IMPORTANT: This transmission is intended for the addressee only. If you are not the
intended recipient, you are notified that use or dissemination of this communication is
strictly prohibited by Commonwealth law. If you have received this transmission in error,
please notify the sender immediately by e-mail or by telephoning +61 3 6232 3209 and
DELETE the message.
        Visit our web site at

  • Unnamed multipart/related (inline, None, 0 bytes)
View raw message