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 2AEA591F2 for ; Thu, 8 Mar 2012 11:45:03 +0000 (UTC) Received: (qmail 39838 invoked by uid 500); 8 Mar 2012 11:45:03 -0000 Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org Received: (qmail 39802 invoked by uid 500); 8 Mar 2012 11:45:02 -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 39793 invoked by uid 99); 8 Mar 2012 11:45:02 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 08 Mar 2012 11:45:02 +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 (nike.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 11:44:50 +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 22:53:26 +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 22:44:21 +1100 From: Steve Cameron To: "dev@openjpa.apache.org" Date: Thu, 8 Mar 2012 22:44:20 +1100 Subject: more details on SQL Server reverse mapping problem[SEC=UNCLASSIFIED] Thread-Topic: more details on SQL Server reverse mapping problem[SEC=UNCLASSIFIED] Thread-Index: Acz9IMvEwai/q9/1TiKwgCKGhFG7VA== Message-ID: <410C0E47580EB147811BB64E83936A3F3EE5210106@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/mixed; boundary="_006_410C0E47580EB147811BB64E83936A3F3EE5210106EX2K7CCRAADGO_" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org --_006_410C0E47580EB147811BB64E83936A3F3EE5210106EX2K7CCRAADGO_ Content-Type: multipart/related; boundary="_005_410C0E47580EB147811BB64E83936A3F3EE5210106EX2K7CCRAADGO_"; type="multipart/alternative" --_005_410C0E47580EB147811BB64E83936A3F3EE5210106EX2K7CCRAADGO_ Content-Type: multipart/alternative; boundary="_000_410C0E47580EB147811BB64E83936A3F3EE5210106EX2K7CCRAADGO_" --_000_410C0E47580EB147811BB64E83936A3F3EE5210106EX2K7CCRAADGO_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I have written a little program as follows: import java.io.File; import org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl; import org.apache.openjpa.jdbc.meta.ReverseMappingTool; public class reverse { =20 private static ReverseMappingTool tool; =20 private static JDBCConfigurationImpl conf; =20 /** =20 * @param args =20 */ =20 public static void main(String[] args) { =20 // TODO Auto-generated method stub =20 conf =3D new JDBCConfigurationImpl(); =20 conf.setConnectionDriverName("com.microsoft.sqlserver.jdb= c.SQLServerDriver"); =20 conf.setConnectionURL("jdbc:sqlserver://localhost\\SQLEXP= RESS;databaseName=3DFishlog"); =20 conf.setConnectionUserName("sa"); =20 conf.setConnectionPassword("password"); =20 tool =3D new ReverseMappingTool(conf); =20 tool.setDirectory(new File("c:/temp/fishlog.xml")); =20 tool.setPackageName("au.gov.aad"); =20 try{ =20 tool.run(); =20 } =20 catch(Exception e){ =20 e.printStackTrace(); =20 } =20 } } In Eclipse I can see an untrapped ClassNotFoundException being thrown (no= t sure why at this stage). Refering to "org.apache.openjpa.jdbc.schema.SchemaGenerator" At ReverseMappingTool.getSchemaGroup() line 610 See attached screendump as well Stephen Cameron Antarctic Fisheries Computing and Database Support Provider Australian Antarctic Division Kingston, Tasmania [cid:image001.jpg@01CCFD7B.72D10F10] 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_410C0E47580EB147811BB64E83936A3F3EE5210106EX2K7CCRAADGO_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I have writt= en a little program as follows:

&= nbsp;

import java.io.File;

import org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl;

=

import org.apache.openjpa.jdbc.meta.ReverseMapping= Tool;

 

public class= re= verse {=

 &nbs= p;    

       private stat= ic ReverseMappingTool tool;

       private<= /span> static JDBCConfigurationImpl conf;

 

       /**

   &nbs= p;   * @param args

       */

=

     = ;  public static void main(String[] args) = {=

   =           // TODO Auto-generated method stub

          &nb= sp;  conf =3D new JDBCConfigurationImpl();<= span style=3D'font-size:10.0pt;font-family:Consolas'>

    &nb= sp;         conf.setConnectio= nDriverName("com.microsoft.sqlserver.jdbc.SQLServerDriver");<= /span>

   &nb= sp;          conf= .setCon= nectionURL("jdbc:sqlserver://localhost\\SQLEXPRESS;databaseName=3D= Fishlog");

&nbs= p;            conf.setConnectionUserName("sa");

       =       conf.setConnectionPassword(&quo= t;password");

&= nbsp;            <= /span>tool =3D new ReverseMappingTool(conf);

    &nbs= p;        tool.setDirectory(<= /span>new File("c:/temp/fishlog.xml"));

      &nbs= p;      tool.setPackageName("au.= gov.aad");

&nbs= p;            try{

 &nbs= p;            = ;      tool.run();

      &nbs= p;      }

         &nbs= p;   catch(Exception e){

          =           e.printStackTrace(= );

   = ;          }

      = ; }

 

=

}

 

In Eclipse I can see an untrapped ClassNotFoun= dException being thrown (not sure why at this stage).

 

Refering to = 220;org.apache.openjpa.jdbc.schema.SchemaGenerator”

<= p class=3DMsoNormal> 

At ReverseM= appingTool.getSchemaGroup() line 610

<= o:p> 

See attached screendump as well<= o:p>

 

 

Stephen Cameron<= /p>

Antarctic Fisheries Computing and Database Suppor= t Provider

Australian Antarctic Divisi= on

Kingston, Tasmania

&n= bsp;

3D"EmailSig=

Phone: 03 62323571=

 

______________________________________________________________________= _____

    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_410C0E47580EB147811BB64E83936A3F3EE5210106EX2K7CCRAADGO_-- --_005_410C0E47580EB147811BB64E83936A3F3EE5210106EX2K7CCRAADGO_ Content-Type: image/jpeg; name="image001.jpg" Content-Description: image001.jpg Content-Disposition: inline; filename="image001.jpg"; size=4846; creation-date="Thu, 08 Mar 2012 22:44:20 GMT"; modification-date="Thu, 08 Mar 2012 22:44:20 GMT" Content-ID: Content-Transfer-Encoding: base64 /9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAoHBwgHBgoICAgLCgoLDhgQDg0NDh0VFhEYIx8lJCIf IiEmKzcvJik0KSEiMEExNDk7Pj4+JS5ESUM8SDc9Pjv/2wBDAQoLCw4NDhwQEBw7KCIoOzs7Ozs7 Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozv/wAARCABzAJoDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD2aiiq GsazZ6JYtc3k8ceeI1c8yN2AABJP0BoAtXFxDawNPcTJDEgyzuwUD6k1xerfFnQrFmjsY5tRcd4x sT/vo9fwFYGrabrni6bz7ux1m5gzmKNfLtYUHsrksfqeaxtL8I6Vf61caZcXF/Y3sCE/YJlTzJiB nCSfd5HtQM6OT4leIJtEl1q10mwjs4phC3mTMz5PtxWfD8ZNVDf6RpVnIvfY7Kf1zWzd+FfCHh7T oHvdJvZ5J13GFpWfacDO4gheM4/lXI63ceEggNpopt5I2B8kTyb5eMgEEYC+p5Pp60gOi8H+N/CW mS3K+Rdaa95L5khlbzYwfYjkD8K9Ltbq3vbdbi1njnhcZV42DA/iK8kh8BX2p6fba7pktpe9W+xy weVC49E55X/ewTiuZ0vWtc8G6q6xeZbSK3760mB2N9V/qKAPoeisLwr4rsfFWn+fbny54+J7dj80 Z/qD2NbtMQUUUUAFFFFABRRRQAUUUUAFFFFAFDW9Wi0TSJ9QmRpBEABGvV2JAUD6kis7T9HS0lk1 7XpYpdQ2ktIx/dWif3I89AO7dTXOfFvXGsdPsdOiPzzzCeQf7MZBA/FsflWr4we21bR9OBaW5jvH DQ2ETbftjFcqGbsg+8x9qAMvxN8S7UaBJNoEkc0rXBtmaXgqNpO9V6kehrzu81z7dpWlzedL/a+n uUWcA7miHKEt3IPFdy2keHvC05uNY0walflQ8giiRLa3HZUDEAn8yeverl346ZNGs7rRvDWYL6Ro YGl2qNw6gov0OORnBoFoQWUN78Q9OsdXtryKxurcNb3eN53n/dDAEcggH171v+HbTw3Y6rdadazC 81eIbrma4+aZvxI4HsOBWZ4Suxpmr609+kNnE9tFePtjMajAZXO3JwcjnBPaoNY8Y6Pa6M+u+Hra P+0tRnNrFLJFtLFcZYj0GR19RQ1YE7q537xH7O0ULeSSpCsqj5D6gdK8y8cXFprljd6baWM2p6lo qJ51+FC4/v8ATr05H1x0o1S48QeGvHOkyXesyzQ6myLNED+7XkKygHjqcgjFSfC9CT4k0mY5fziG J6nO5Tn8qBnGW2pWvhbUNM1TQr+S6mMQN3E67V56p7j/AOsa920zULfVtNt9QtW3Q3CB1P8AQ+46 V8/W+iG40C4vIyEezvVgldzhQjjAJPsw5/3q9L+GNy9i174eluPPEAW4gcIVBVuGAz1AYdehzSGe gUUUUxBRRRQAUUUUAFFFFABRRRQB478TLS91bxVeG3QPFplijSksBtUknPPXrXVWF5b3WieEtYt9 gitZFt5QvSPfGYzn0+bb+dcz450hL/xxqHmvKv8Aocci7GChuCOeDxkVb0eWKwGnhLNG0/X9LSNw eI3u1U46dCQuCR3waBnaal4fsXWZoYIBcSEv59wPM8jP3mQE8Hk9O/WuY1PVvDcPg2LS7hLiytyw NjIkTEghjtk3EYJyCxx2b3qpeWOpQ+H73Vor6bU9OltYmt0LMZ2Qzb3jcjnGCwLDt9Kzby6a/wDD dnr17I160heMQwqIo7VVbeELbT/dAHAz607kWNPTDb694htrG+A23NjJBLCspZZApV1dWHLK2D+W DXJXtp9m8EvD9oimm0/VcsIiSI96EYz0JynatTwotpH8SdLbSi5t5I2JUklUYxkuqk9QM/nWxa6D b6XceIZfE0McOiX9wTAjufNkcOSpRV5z8xx36US1YQVoob48u4vEB8LR6ZKlxfzPvRUOcA7c5PbB HP0NXovBOpnxTe6npOtQrp+oNKtz5ZO5c5BUY4JDE85HSmaZZXmj2JfSvDw0yOBXlTUtTYTSJEeS PLXkMcdOw962NL8eWEjRRXkdtbpI4jE1rcrNH5h7NjBXJ6EjHqRSKI5/DlrpfgjVfDlvbTmOOzaY 3cgGJpME9u4Kj9K5rwdfl/F2hzM7mS5snhk3Z5AUMvbH8Pau71XWon0XXswTw/YYZEZ5Y9qudh5U 9xXn/g+2YeJvDaMsqyR28jOJFYDAjwMZ4x83agD16iiigAooooAKKKKACiiigAooooA86+JkE9jq mm61bRQuXVrRzMdqKSdyktxjo1R+FJ0uvC99ok1muqTWEvnwJDJ5ZkjY7g8THpg7scjsK7bxFo0W v6Hc6dIQpkXMb4+445U/ga8strzULS/+3mN31SydoL+2kmJa4U9Y417DA3DHfpwCaQG02naO2iRW ukeI59M1Wzmdrdb6XyZo95yYmHGVz3559ajRPGkdk1nfeGbC7guP+PyQSpGboZ4JZWABx3xzUPiD XUi0e3NvoMeuaXMMw3d67TvGe8b8bkIPbNYFje6Jq6+Q3h3YY8ful1hokyf7qv8A0phtqQ+Im1Wy 1mzmj+yadKo2WttYXIf7Pzjkg8E55Peuy8IW2mm6/tiG323Vopt7+1nYyPDNn/WqxJ+9zmuT1TQV tBDqCadaabBalXeL7b5kkw3Dp71ev9Tm8I/EM6pndaXwDzIB96M8MMeoIzVWtqzJS5tEeiDVU1K5 itXnjCzNLEoT7wdfmRuvQp2PeuH1/wAOWV3pq65DZqreWwuYFHlSb0PzFfRgQeowRWpqWi67rWof a4p7fTLQOXgltMu8ikcNk4AyMVq2eiad4YgudV1a+nuQIf3k12/mAqTyFHTJwOnWq29BXTfmc1qG q6hd+B1tG1CbUP7WkAgZox5i26cyMQoz2xj1zya0Ph7Zi68S6hqakNBawJbRFVZV3HBbCt904C5H qa5PU7mTWbxb5YpreeUrFpFranaYlBIC8cA5ILDggYPQ8eu+GdF/sHQ4bJn82c5kuJScmSVuWP5/ yrM26GtRRRQAUUUUAFFFFABRRRQAUUUUAFcj4z8IzarnVdGdbfVo4zHkgYmQj7pz0b0auuooA8P0 rVLrw3qEceifaI713EVzpdypIkI6sx/hPuPfoOvS3Piuz1WYwyxaVbXIJV7PV7f5Cw4OyZeCOO4r ste8K6X4hVXuomjuY/8AV3MJ2yJ+Pcexri9T8C+IbddsLWmsW42DbIBFLtVgxBz8pJxgmkMYPCul 6u6G48MTae+RtudLukuITz3UHgfhUnxB8I6hqBsZLJYXEW8O8kqxqinBGdx9q5yXw3dQqRN4X1O3 l8pgzWqkoZCcg/KcYHIx7+1JD4buZGcL4a1S7O7MZnUqoAckZ3HuuFP4mneysS4ptPsdRovim18N +H7XSri4Gs6jbsUhi0/MigHkKXxjOMjjPArntW1a61m+hm1hhMUcC10i2VipOSCPUupHOePpxWvp XgLxDI1yp+y6LZ3MqSeUp86SMqONvYHPOc122g+EdK8PlpreNp7yT/WXc53yN689vwoHoZHg3wc9 hctrusRx/wBpzg7Y1AxAD1zjq57tXZ0UUAFFFFABRRRQAUUUUAFFFFABRRRQBBPc+UyxpG0srgkI vp6k9hRBNJIWWW3aFl9SCD9CKimLW96LkozxtHsYqMlcHIOPTmoL+WS8sZVtY5SAVJJQjeM8gA4J 4pmbla5bu7sW1nJcKBIE7A9eamLKCASAT0Getc+8LPa3bQqdpiVdkds0Ssd3XBPJH0p15BKbq6Ey ktI37phbNI2McbWBAXH4UWI9o97f1qbEd0Hup4SAvklQCT97IzU5ZQcEgfjWE8UK392b20luNyIE cRFgx284x0PvUtpZu17bG8jLvFaD5m5Abd6+oosNTexr7lzjcMgZxmq5vo3id7dTMUk2MqkA9cE8 9qy2V5L5HFqI3Fz84EJzt5GS/QgjtSfZ0itruGO1KSfaVYbYsZTeCMHuKLA6j6G7vXONwz0xmlLA EAkDPSsO6sg8epz+QTMJQYm2nPCryv8A9anXcUf2i8N3ayzM6/uGVCwC7egP8Jzn0osP2j7GyWAX dnjGc1UttSjuRcNseJIOpkGMjGc4+lP0z/kFWv8A1xX+VVmt5Jn1WIAr5wCoSMA/Jigbb0aJYdTE joJYJIFlUvGz4wwHPbocc4og1ITSRK1vJEk4JhdsYfjPTtxzzVSTzNSEEKwyxGJG8wupUKShUDPf k9vSnRPJdGxg8iWNrdg0pZCAuFIwD3yT2oJUma2RnGRn0pC6gZLAAd81n6sWthFqEa7ngJUqP4lb jH54NU57OS1NqsgDxLEd5aEyjzCcklQe/rRYqU2naxullUZZgB6k0FlHVgO/WsPy2jtbaOSHzIyz sGlt2by+eF2An8M0WdoZZLJbmBiqRzDDqcD5xgH8OgosL2jvaxubhnbkZHalrFtYzHrB8uFnDO5d 5ISrR/8AAujA9hWzSLjLmM6+1y3sZ3ieGeQQoJJ3jUFYVOcFuc9j0zwKrWGsyf2XqGp6huiit5pg qsFG1EJGAQTk8d+9XrvR7C+nWe5g3uAAfmIDAHIDAHDDPY5pz6XZPbNbPAGheXzmQk4Z92/J/wCB c46UFGXofiQahBHHdCP7Wbl7ZxbsGQMFLg5z0Kj86ZceL7dbOSa1s7iZ0gScI21MqxGOp569sjtm tKfQtMuJGke1CsxUkxsUOVzg/KR2Yj6HFR/8I3pOwJ9kygg8hVMjEKmAMDnjoORzxQAyTxDBGly7 WtwBbSCNydijfgHAJbB4NU4PEhlvpCG32rDzIl2AMU8lX6kgA5bv+lajaJp7xeW0Bx5vnZEjBt+3 bnOc9OKj/wCEd0ny/L+xrs2bMbm6bQvr6KB+FAFQeLrAorrBcsm0tIyqpEQD7DuOfX0zxR4l8Rro RtwDCSW8ycSNgiEEBiozy3zD8jVxdA0xY5IxbZWVSr5diWBbcckn+9zViTTbKa4knmtkkklQRszj d8ozgc9Op6UAZl/4pgtBdCOzuZWt96q+FCO6x+ZtBz/d5zjsahvdV05JV+2w3cLzQGV41lGGwhYq QG64U9se9aaaDpiW4gFqDGGLbWZjyU8s9T/d4qNvDmlMQWtixCbOZXORtKc88naxGTzQJpPcjGvx +W6W+nXbmGLeyhVUR8EqDluMgdumRnFV7bxP5piElrMZriCKWK1jUF/mDE/MWwRhc9vzOK1G0mya 6W5MJEioEyHYBgAQAwBw3BPXNQf8I7pQiWMWzAIqqjCVwyhc4AbOR94jr0OKBlXWtWubO7soIJFt 1uI5HZntXnYFduBtQ5H3jz7VJc+JbSyluIJ4p2mtYfOlCRjlMDDDnucgDrkGrd3pFnfGFpllDQKV jaOZ4yAcZGVIJ6D8qqan4bs72yuI4kCXEylfOZmY8gAg85IwBx7UAVr3xBpolQ3cNzHPC5/0Zyqk YAbcRu2ngjHOfbNM1HxRgRPp6yGHzGD3DRZjOIncqOQc5A9OhGa0m8O6U8XltbE/OX3mV9+SMH5s 5xgAYzjAol8PaVPOZpLXLNnIEjBclShO0HGSpxnrQKxRPifyzI9zA1tBDciJpGUN5g8nzMgA5B/P t68TSeJ4YpVgfT74XL5It9i79u0tu+9jHynv1GKttoemvIzvaht5DMGYlSQhQHGcfdOKSDQtNtnW SO3O9SSHeRmblduMkk4wcY7UDG6br1pql08FssvyRq+9wFDAgEYGc9xzjFadUbTRrCxnWe3gKyLH 5SkyM21eOACeOg6elXqACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigD// 2Q== --_005_410C0E47580EB147811BB64E83936A3F3EE5210106EX2K7CCRAADGO_-- --_006_410C0E47580EB147811BB64E83936A3F3EE5210106EX2K7CCRAADGO_--