Re: SimpleORM Download Form
anthony berglas <[email protected]> Thu, 15 Dec 2011 09:52:15 +1000
| Newsgroups | gmane.comp.java.orm.simpleorm |
|---|---|
| Message-ID | <CA+_PZMfrfoJCR3WJE2xGX3ne2+9kddNmjpp3V2Peujr7NVnbkQ@mail.gmail.com> |
--20cf3079b88c1d7da104b41611a7 Content-Type: text/plain; charset=ISO-8859-1 Hello John, Improving the Generator would be appreciated. JDBC does data type conversions, so representing database shorts as SimpleOrm Ints should not matter if you are not generating DDL. And please post to the list rather than me directly, others may be able to help. Anthony On Wed, Dec 14, 2011 at 5:57 PM, John Arkley <[email protected]> wrote: > Thanks for taking the time to reply! > > I found, in the extras directory, the SimpleORMGenerate tool that does the > DDL to DataSet generation and i have already updated it to accept a > properties filepath from the command line, so i can automate running it > with Ant. > A Java tool that use System.getProperty() for input is rather bogus. > > However, as i have a DDL with DOMAINs, i am working to add logic > to handle columnOverride's so i can force the domain columns to specific > JDBC and Java types in the DataSet objects. > > Because i am considering converting an existing Schema, created > from DDL, via iBator to run under iBatis, starting over from the Java side > is not worth the work, or changing over my build and revision process. > > It was my first database design and i started from the SQL Table and > View DDL, not the Java or an abstract object model. > > I am not sure yet if DataSet handles all the JDBC datatypes i am using, > which include SMALLINT <- -> Short ( something in would not do today) > but too late now to remove, due to existing production installations. > I found that the SimpleORMGenerate tool doesn't appear to handle > them properly. > > I will fix the tool so it will, if i can verify that the DataSet will > support Short objects. > My Java code base requires getters and setters that accept and return > Shorts, > since iBator builds model POJO's with Shorts, one POJO per table record. > > kind regards, John > > > I found the extras folder has > > On Dec 13, 2011, at 10:33 PM, anthony berglas wrote: > > The normal usage of SimpleOrm is to generate the DDL from the Java. But > there have been some half hearted attempts go the other way. A few clever > db queries on the catalogs would also get you started. > > I would not normally bother with Table and View objects. The DataSet does > both. > > SimpleOrm has been integrated with EJBs, but not Spring AFAIK. But it > should be pretty easy. > > Let us know how you go. > > Anthony > > On Tue, Dec 13, 2011 at 4:29 PM, <[email protected]> wrote: > >> name: John Arkley >> >> goodpart: It appears from the white paper that is would be easier to use >> in my workflow tracking web application than iBator + iBatis, but i >> alwaysexamine the source code for coding quality before i adopt an >> opensource project. >> >> concerns: Using iBator, i can change the DDL of my schema and re-generate >> theSql-maps, and all the DAO and Model Objects with a iBator fromthe >> database Schema, so i don't have to code 140+ java and XML filesby hand. >> iBator will generate these files for a database Viewas well as each table, >> but is appears SimpleORM means i will haveto code the equivalent table >> objects and view objects (with get/set ) manually, as the rest of my code >> base uses the generated POJOs.The conversion will be a lot of work, but the >> iBator generatedSQL query building routines are messy and limited. >> >> organisation: 1 man developer/ISV >> >> city: CA >> >> orgdesc: My web app is built on the Spring framework and i have to >> determine if i can integrate it into cross-cutting AOP Spring >> Transactionmanagement design, which is applied by rule, via Spring >> servletfilter architecture. My app doesn't have any explicit trans-action >> method calls in my code, and i can only use SimpleORMif i can adapt it to >> the Spring transaction management and alsowith Spring JDBC Exception >> handlers, so i have to read the code. >> >> nrprogrammers: 1 >> >> howknown: a H2database.com Links page >> >> > > > -- > > Dr Anthony Berglas, [email protected] Mobile: +61 4 4838 8874 > Just because it is possible to push twigs along the ground with ones nose > does not necessarily mean that that is the best way to collect firewood. > > > -- Dr Anthony Berglas, [email protected] Mobile: +61 4 4838 8874 Just because it is possible to push twigs along the ground with ones nose does not necessarily mean that that is the best way to collect firewood. --20cf3079b88c1d7da104b41611a7 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable <head> <style type=3D"text/css"> <!-- /* start of attachment style */ .ygrp-photo-title{ clear: both; font-size: smaller; height: 15px; overflow: hidden; text-align: center; width: 75px; } div.ygrp-photo{ background-position: center; background-repeat: no-repeat; background-color: white; border: 1px solid black; height: 62px; width: 62px; } div.photo-title=20 a, div.photo-title a:active, div.photo-title a:hover, div.photo-title a:visited { text-decoration: none;=20 } div.attach-table div.attach-row { clear: both; } div.attach-table div.attach-row div { float: left; /* margin: 2px;*/ } p { clear: both; padding: 15px 0 3px 0; overflow: hidden; } div.ygrp-file { width: 30px; valign: middle; } div.attach-table div.attach-row div div a { text-decoration: none; } div.attach-table div.attach-row div div span { font-weight: normal; } div.ygrp-file-title { font-weight: bold; } /* end of attachment style */ --> </style> </head> <html> <head> <style type=3D"text/css"> <!-- #ygrp-mkp { border: 1px solid #d8d8d8; font-family: Arial; margin: 10px 0; padding: 0 10px; } #ygrp-mkp hr { border: 1px solid #d8d8d8; } #ygrp-mkp #hd { color: #628c2a; font-size: 85%; font-weight: 700; line-height: 122%; margin: 10px 0; } #ygrp-mkp #ads { margin-bottom: 10px; } #ygrp-mkp .ad { padding: 0 0; } #ygrp-mkp .ad p { margin: 0; } #ygrp-mkp .ad a { color: #0000ff; text-decoration: none; } --> </style> </head> <body> Hello John,<div><br></div><div>Improving the Generator would be appreciated= . =A0</div><div><br></div><div>JDBC does data type conversions, so represen= ting database shorts as SimpleOrm Ints should not matter if you are not gen= erating DDL.</div> <div><br></div><div>And please post to the list rather than me directly, ot= hers may be able to help.</div><div><br></div><div>Anthony<br><br><div clas= s=3D"gmail_quote">On Wed, Dec 14, 2011 at 5:57 PM, John Arkley <span dir=3D= "ltr"><<a href=3D"mailto:[email protected]">[email protected]</a>>= ;</span> wrote:<br> <blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p= x #ccc solid;padding-left:1ex"><div style=3D"word-wrap:break-word">Thanks f= or taking the time to reply!<div><br></div><div>I found, in the extras dire= ctory, the SimpleORMGenerate tool that does the</div> <div>DDL to DataSet generation and i have already updated it to accept a</d= iv><div>properties filepath from the command line, so i can automate runnin= g it with=A0Ant.</div><div>A Java tool that use System.getProperty() for in= put is rather bogus.</div> <div><br></div><div>However, as i have a DDL with DOMAINs, i am working to = add logic</div><div>to handle columnOverride's so i can force the domai= n columns to specific</div><div>JDBC and Java types in the DataSet objects.= </div> <div><br></div><div>Because i am considering converting an existing Schema,= created=A0</div><div>from DDL, via iBator to run under iBatis, starting ov= er from the=A0Java side=A0</div><div>is not worth the work, or changing ove= r my build and=A0revision process. =A0</div> <div><br></div><div>It was my first database design and i started from=A0th= e SQL Table and=A0</div><div>View DDL, not the Java or an abstract object m= odel.</div><div><br></div><div>I am not sure yet if DataSet handles all the= JDBC datatypes i am using,</div> <div>which include SMALLINT <- -> Short =A0( something in would not d= o today)</div><div>but too late now to remove, due to existing production i= nstallations.</div><div>I found that the SimpleORMGenerate tool doesn't= appear to handle them=A0properly. =A0=A0</div> <div><br></div><div>I will fix the tool so it will, if i can verify that th= e DataSet will support=A0Short objects. =A0=A0</div><div>My Java code base = requires getters and setters that accept and=A0return Shorts,</div><div>sin= ce iBator builds model POJO's with Shorts, one POJO per table record.</= div> <div><br></div><div>kind regards, John</div><div><br></div><div><div><br></= div><div>I found the extras folder has=A0<div><div></div><div class=3D"h5">= <br><div><div>On Dec 13, 2011, at 10:33 PM, anthony berglas wrote:</div><br= > <blockquote type=3D"cite">The normal usage of SimpleOrm is to generate the = DDL from the Java. =A0But there have been some half hearted attempts go the= other way. =A0A few clever db queries on the catalogs would also get you s= tarted.<div> <br></div><div> I would not normally bother with Table and View objects. =A0The DataSet doe= s both.</div><div><br></div><div>SimpleOrm has been integrated with EJBs, b= ut not Spring AFAIK. =A0But it should be pretty easy.</div><div><br></div> <div> Let us know how you go.</div><div><br></div><div>Anthony<br><div><br><div c= lass=3D"gmail_quote">On Tue, Dec 13, 2011 at 4:29 PM, <span dir=3D"ltr">&l= t;<a href=3D"mailto:[email protected]" target=3D"_blank">exappl088@gmail.= com</a>></span> wrote:<br> <blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p= x #ccc solid;padding-left:1ex">name: John Arkley<br> <br> goodpart: It appears from the white paper that is would be easier to use in= my workflow tracking web application than iBator + iBatis, but i alwaysexa= mine the source code for coding quality before i adopt an opensource projec= t.<br> <br> concerns: Using iBator, i can change the DDL of my schema and re-generate t= heSql-maps, and all the DAO and Model Objects with a iBator fromthe databas= e Schema, so i don't have to code 140+ java and XML filesby hand. =A0iB= ator will generate these files for a database Viewas well as each table, bu= t is appears SimpleORM means i will haveto code the equivalent table object= s and view objects (with get/set ) manually, as the rest of my code base us= es the generated POJOs.The conversion will be a lot of work, but the iBator= generatedSQL query building routines are messy and limited.<br> <br> organisation: 1 man developer/ISV<br> <br> city: CA<br> <br> orgdesc: My web app is built on the Spring framework and i have to determin= e if i can integrate it into cross-cutting AOP Spring Transactionmanagement= design, which is applied by rule, via Spring servletfilter architecture. = =A0My app doesn't have any explicit trans-action method calls in my cod= e, and i can only use SimpleORMif i can adapt it to the Spring transaction = management and alsowith Spring JDBC Exception handlers, so i have to read t= he code.<br> <br> nrprogrammers: 1<br> <br> howknown: a <a href=3D"http://H2database.com" target=3D"_blank">H2database.= com</a> Links page<br> <br> </blockquote></div><br><br clear=3D"all"><div><br></div>-- <br><div> <br></div><p>Dr Anthony Berglas, <a href=3D"mailto:[email protected]" tar= get=3D"_blank">[email protected]</a>=A0=A0=A0=A0=A0=A0 Mobile: <a href=3D= "tel:%2B61%204%204838%208874" value=3D"+61448388874" target=3D"_blank">+61 = 4 4838 8874</a><br> Just because it is possible to push twigs along the ground with ones nose<b= r> does not necessarily mean that that is the best way to collect firewood.</p= ><br> </div></div> </blockquote></div><br></div></div></div></div></div></blockquote></div><br= ><br clear=3D"all"><div><br></div>-- <br><p> </p><p>Dr Anthony Berglas, <a href=3D"mailto:[email protected]" target=3D= "_blank">[email protected]</a>=A0=A0=A0=A0=A0=A0 Mobile: +61 4 4838 8874<= br> Just because it is possible to push twigs along the ground with ones nose<b= r> does not necessarily mean that that is the best way to collect firewood.</p= ><br> </div> <!-- |**|begin egp html banner|**| --> <br> =20=20=20=20 =20=20=20=20 <br> <!-- |**|end egp html banner|**| --> <div width=3D"1" style=3D"color: white; clear: both;"/>__._,_.___</div> <!-- Start Recommendations --> <!-- End Recommendations --> <!-- |**|begin egp html banner|**| --> <img src=3D"http://geo.yahoo.com/serv?s=3D97476590/grpId=3D7360226/grpspI= d=3D1705006905/msgId=3D2042/stime=3D1323906780" width=3D"1" height=3D"1"> <= br> <!-- |**|end egp html banner|**| --> =20=20 <!-- |**|begin egp html banner|**| --> <br> <div style=3D"font-family: verdana; font-size: 77%; border-top: 1px s= olid #666; padding: 5px 0;" > Your email settings: Individual Email|Traditional <br> <a href=3D"http://groups.yahoo.com/group/SimpleORM/join;_ylc=3DX3oDMT= JmcnJxcjc4BF9TAzk3NDc2NTkwBGdycElkAzczNjAyMjYEZ3Jwc3BJZAMxNzA1MDA2OTA1BHNlY= wNmdHIEc2xrA3N0bmdzBHN0aW1lAzEzMjM5MDY3ODA-">Change settings via the Web</a= > (Yahoo! ID required) <br> Change settings via email: <a href=3D"mailto:SimpleORM-digest@yahoogr= oups.com?subject=3DEmail Delivery: Digest">Switch delivery to Daily Digest<= /a> | <a href =3D "mailto:[email protected]?subject=3D= Change Delivery Format: Fully Featured">Switch to Fully Featured</a> <br> <a href=3D"http://groups.yahoo.com/group/SimpleORM;_ylc=3DX3oDMT= JkdGNnZGxhBF9TAzk3NDc2NTkwBGdycElkAzczNjAyMjYEZ3Jwc3BJZAMxNzA1MDA2OTA1BHNlY= wNmdHIEc2xrA2hwZgRzdGltZQMxMzIzOTA2Nzgw"> Visit Your Group=20 </a> | <a href=3D"http://docs.yahoo.com/info/terms/"> Yahoo! Groups Terms of Use </a> | <a href=3D"mailto:[email protected]?subject=3DUns= ubscribe"> Unsubscribe=20 </a>=20 <br> </div> <br> <!-- |**|end egp html banner|**| --> <div style=3D"color: white; clear: both;"/>__,_._,___</div> </body> </html> --20cf3079b88c1d7da104b41611a7--