From dev-return-20276-apmail-openjpa-dev-archive=openjpa.apache.org@openjpa.apache.org Thu Mar 8 10:36:49 2012 Return-Path: X-Original-To: apmail-openjpa-dev-archive@www.apache.org Delivered-To: apmail-openjpa-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 463119FB4 for ; Thu, 8 Mar 2012 10:36:49 +0000 (UTC) Received: (qmail 53723 invoked by uid 500); 8 Mar 2012 10:36:49 -0000 Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org Received: (qmail 53576 invoked by uid 500); 8 Mar 2012 10:36:48 -0000 Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@openjpa.apache.org Delivered-To: mailing list dev@openjpa.apache.org Received: (qmail 53567 invoked by uid 99); 8 Mar 2012 10:36:47 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 08 Mar 2012 10:36:47 +0000 X-ASF-Spam-Status: No, hits=-0.1 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of Steve.Cameron@aad.gov.au designates 147.66.131.20 as permitted sender) Received: from [147.66.131.20] (HELO mail1.aad.gov.au) (147.66.131.20) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 08 Mar 2012 10:36:40 +0000 Received: from its-exhts1.AAD.GOV.AU (Not Verified[147.66.8.7]) by mail1.aad.gov.au with MailMarshal (v6,7,2,8378) id ; Thu, 08 Mar 2012 21:45:23 +1100 Received: from EX2K7-CCR.AAD.GOV.AU ([147.66.8.4]) by its-exhts1.AAD.GOV.AU ([147.66.8.7]) with mapi; Thu, 8 Mar 2012 21:36:18 +1100 From: Steve Cameron To: "dev@openjpa.apache.org" Date: Thu, 8 Mar 2012 21:36:17 +1100 Subject: reverse mapping an SQL server database[SEC=UNCLASSIFIED] Thread-Topic: reverse mapping an SQL server database[SEC=UNCLASSIFIED] Thread-Index: Acz9F0nkqO9y2i8dSvKbUk4tXoCIfQ== Message-ID: <410C0E47580EB147811BB64E83936A3F3EE5210103@EX2K7-CCR.AAD.GOV.AU> Accept-Language: en-US, en-AU Content-Language: en-US X-MS-Has-Attach: yes X-MS-TNEF-Correlator: acceptlanguage: en-US, en-AU Content-Type: multipart/related; boundary="_004_410C0E47580EB147811BB64E83936A3F3EE5210103EX2K7CCRAADGO_"; type="multipart/alternative" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org --_004_410C0E47580EB147811BB64E83936A3F3EE5210103EX2K7CCRAADGO_ Content-Type: multipart/alternative; boundary="_000_410C0E47580EB147811BB64E83936A3F3EE5210103EX2K7CCRAADGO_" --_000_410C0E47580EB147811BB64E83936A3F3EE5210103EX2K7CCRAADGO_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi I am just starting out to try openJPA and have a problem trying to revers= e map an existing SQL Server database. The DB is one I just migrated from Access to SS if that makes any differe= nce. The batch script I am using is as follows: the batch file I am usings is as follows: java -Djava.util.logging.config.file=3Dlogging.properties ^ -cp openjpa-all-2.2.0.jar;"C:/Program Files/Java/sqljdbc_3.0/enu/sqljdbc4= .jar" ^ =20org.apache.openjpa.jdbc.meta.ReverseMappingTool ^ -pkg au.gov.aad.fresh ^ -ConnectionDriverName com.microsoft.sqlserver.jdbc.SQLServerDriver ^ -ConnectionURL jdbc:sqlserver://localhost\SQLEXPRESS;databaseName=3DFishl= og; ^ -ConnectionUserName sa ^ -ConnectionPassword password ^ -openjpa.Log "File=3Dc:/temp/openjpa.log, DefaultLevel=3DTRACE, Runtime=3D= TRACE, Tool=3DTRACE, Schema=3DTRACE" The result of this is that the ReverseMappingTool connects to the databas= e, 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 th= e database. The tool is gathering schema information; this process may t= ake some time. =20 Enable the org.apache.openjpa.jdbc.Schema logging category to see mes= sages about schema data. 3822 INFO [main] openjpa.jdbc.JDBC - Using dictionary class "org.apach= e.openj pa.jdbc.sql.SQLServerDictionary". Is there any way to diagnose what is going wrong, no logfile is being cre= ated. Stephen Cameron Antarctic Fisheries Computing and Database Support Provider Australian Antarctic Division Kingston, Tasmania [cid:image001.jpg@01CCFD71.AA95FD70] Phone: 03 62323571 _________________________________________________________________________= __ =20 Australian Antarctic Division - Commonwealth of Australia IMPORTANT: This transmission is intended for the addressee only. If you a= re not the intended recipient, you are notified that use or dissemination of this co= mmunication is strictly prohibited by Commonwealth law. If you have received this transm= ission in error, please notify the sender immediately by e-mail or by telephoning +61 3 62= 32 3209 and DELETE the message. =20 Visit our web site at http://www.antarctica.gov.au/ _________________________________________________________________________= __ --_000_410C0E47580EB147811BB64E83936A3F3EE5210103EX2K7CCRAADGO_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi

 

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

 

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

 

The batch script I am us= ing  is as follows:

 

the batch file I am usings is as follows:
java -Djava.util.logging.config.file=3Dlogging.properties ^
-cp= =20openjpa-all-2.2.0.jar;"C:/Program Files/Java/sqljdbc_3.0/enu/sqlj= dbc4.jar" ^
 org.apache.openjpa.jdbc.meta.ReverseMappingToo= l  ^
-pkg au.gov.aad.fresh  ^
-ConnectionDriverName com= .microsoft.sqlserver.jdbc.SQLServerDriver ^
-ConnectionURL jdbc:sqlse= rver://localhost\SQLEXPRESS;databaseName=3DFishlog; ^
-ConnectionUser= Name sa ^
-ConnectionPassword password  ^
-openjpa.Log "= ;File=3Dc:/temp/openjpa.log, DefaultLevel=3DTRACE, Runtime=3DTRACE, Tool=3D= TRACE, Schema=3DTRACE"

 = ;

The result of this is that the ReverseMap= pingTool connects to the database, gives the following messages and  = ;then just goes to sleep (apparently - I’ve waited for 20 minutes f= or something to happen!).

 <= /o:p>

967  INFO   [main] openjpa.T= ool - The reverse mapping tool will run on the database.  The tool i= s gathering schema information; this process may take some time.

  Enable the org.apache.openjpa.jdbc.Sche= ma logging category to see messages about schema data.

3822  INFO   [main] openjpa.jdbc.JDBC - U= sing dictionary class "org.apache.openj

pa.jdbc.sql.SQLServerDictionary".

 

Is there any way to dia= gnose what is going wrong, no logfile is being created.

 

Stephen Camer= on

Antarctic Fisheries Computing and D= atabase Support Provider

Australian An= tarctic Division

Kingston, Tasmania

 

=3D"EmailSig

Phone: 03 62323571<= o:p>

 

______________________________________________________________________= _____

    Australian Antarctic Division - Commonwealth of=20 Australia
IMPORTANT: This transmission is intended for the addressee o= nly. If=20 you are not the
intended recipient, you are notified that use or=20 dissemination of this communication is
strictly prohibited by Commonwe= alth=20 law. If you have received this transmission in error,
please notify th= e=20 sender immediately by e-mail or by telephoning +61 3 6232 3209 and
DEL= ETE the=20 message.
        Visit our web site= =20at http://www.antarctica.gov.au/<= BR>______________________________________________________________________= _____

--_000_410C0E47580EB147811BB64E83936A3F3EE5210103EX2K7CCRAADGO_-- --_004_410C0E47580EB147811BB64E83936A3F3EE5210103EX2K7CCRAADGO_--