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 -Djava.util.logging.config.file=logging.properties ^
-cp openjpa-all-2.2.0.jar;"C:/Program Files/Java/sqljdbc_3.0/enu/sqljdbc4.jar" ^
-pkg au.gov.aad.fresh ^
-ConnectionDriverName com.microsoft.sqlserver.jdbc.SQLServerDriver ^
-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 data.
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.
Antarctic Fisheries Computing and Database Support Provider
Australian Antarctic Division
Phone: 03 62323571
Australian Antarctic Division - Commonwealth of
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 http://www.antarctica.gov.au/