Re: WOLips Entity Modeler SQL Generation and WO 5.4

2009-07-08 Thread Miguel Angel Torres Avila
Thanks David, This is exactly what I was looking for. I will try it. Gracias. On Jul 7, 2009, at 6:00 PM, David Avendasora wrote: On Jul 7, 2009, at 6:17 PM, Miguel Angel Torres Avila wrote: Hi, Thanks for the hint about using Prototypes, it is really useful. That brought to my mine a

Re: WOLips Entity Modeler SQL Generation and WO 5.4

2009-07-08 Thread David Avendasora
On Jul 8, 2009, at 3:21 AM, Johann Werner wrote: Hi Dave, this addition to _Entity.java seems very useful. Perhaps it should be added to the standard templates? They would become more sort of "use them and don't care" so perhaps file a jira. Done. WOL-1035 the snippit of code from the

Re: WOLips Entity Modeler SQL Generation and WO 5.4

2009-07-08 Thread Johann Werner
Hi Dave, this addition to _Entity.java seems very useful. Perhaps it should be added to the standard templates? They would become more sort of "use them and don't care" so perhaps file a jira. jw Am 08.07.2009 um 01:00 schrieb David Avendasora: On Jul 7, 2009, at 6:17 PM, Miguel Angel

Re: WOLips Entity Modeler SQL Generation and WO 5.4

2009-07-07 Thread David Avendasora
On Jul 7, 2009, at 6:17 PM, Miguel Angel Torres Avila wrote: Hi, Thanks for the hint about using Prototypes, it is really useful. That brought to my mine a questing that is a little out of the topic. If you have an attribute prototyped as currencyAmount the precision is set to 38 and the s

Re: WOLips Entity Modeler SQL Generation and WO 5.4

2009-07-07 Thread Miguel Angel Torres Avila
Hi, Thanks for the hint about using Prototypes, it is really useful. That brought to my mine a questing that is a little out of the topic. If you have an attribute prototyped as currencyAmount the precision is set to 38 and the scale to 4. The Data Type suggested is java.math.BigDecimal. Ho

Re: WOLips Entity Modeler SQL Generation and WO 5.4

2009-07-07 Thread David Avendasora
On Jul 7, 2009, at 5:32 PM, Andrew Lindesay wrote: Hello David; I don't use Postgresql, but I believe that the prototype "id" is the one to use for PKs and FKs. I see that there only seems to be an external type of integer for Postgress and even a LongNumber prototype which has a java da

Re: WOLips Entity Modeler SQL Generation and WO 5.4

2009-07-07 Thread Andrew Lindesay
Hello David; I don't use Postgresql, but I believe that the prototype "id" is the one to use for PKs and FKs. I see that there only seems to be an external type of integer for Postgress and even a LongNumber prototype which has a java datatype of Long, is still an integer in Postgress. Ar

Re: WOLips Entity Modeler SQL Generation and WO 5.4

2009-07-07 Thread David Avendasora
On Jul 7, 2009, at 4:53 PM, Kieran Kelleher wrote: and if you want even more modern 'fanciness', you can turn on ERXModel as your eomodel class in Wonder, you can have custom prototypes of your own in other eomodel files and with the right naming convention (of the eomodel file) and u

Re: WOLips Entity Modeler SQL Generation and WO 5.4

2009-07-07 Thread David Avendasora
On Jul 7, 2009, at 3:09 PM, Scott M. Neal wrote: On Jun 30, 2009, at 5:43 PM, David Avendasora wrote: On Jun 30, 2009, at 8:29 PM, Scott M. Neal wrote: Well, if you're looking for excuses to "upgrade" things, maybe transition to using Prototypes. I'm sure the Postgress Prototypes in Wo

Re: WOLips Entity Modeler SQL Generation and WO 5.4

2009-07-07 Thread Kieran Kelleher
and if you want even more modern 'fanciness', you can turn on ERXModel as your eomodel class in Wonder, you can have custom prototypes of your own in other eomodel files and with the right naming convention (of the eomodel file) and using the same prototype attribute name, you "overrid

Re: WOLips Entity Modeler SQL Generation and WO 5.4

2009-07-07 Thread Johann Werner
Am 07.07.2009 um 21:09 schrieb Scott M. Neal: On Jun 30, 2009, at 5:43 PM, David Avendasora wrote: On Jun 30, 2009, at 8:29 PM, Scott M. Neal wrote: Well, if you're looking for excuses to "upgrade" things, maybe transition to using Prototypes. I'm sure the Postgress Prototypes in Wonde

Re: WOLips Entity Modeler SQL Generation and WO 5.4

2009-07-07 Thread Scott M. Neal
On Jun 30, 2009, at 5:43 PM, David Avendasora wrote: On Jun 30, 2009, at 8:29 PM, Scott M. Neal wrote: Well, if you're looking for excuses to "upgrade" things, maybe transition to using Prototypes. I'm sure the Postgress Prototypes in Wonder's ERPrototypes will all have the proper Externa

Re: WOLips Entity Modeler SQL Generation and WO 5.4

2009-06-30 Thread David Avendasora
On Jun 30, 2009, at 8:29 PM, Scott M. Neal wrote: On Jun 30, 2009, at 3:18 PM, Chuck Hill wrote: On Jun 30, 2009, at 9:16 AM, Scott M. Neal wrote: Caused by: java.lang.NullPointerException at com .webobjects .jdbcadaptor .JDBCExpression.columnTypeStringForAttribute(JDBCExpression.ja

Re: WOLips Entity Modeler SQL Generation and WO 5.4

2009-06-30 Thread Chuck Hill
On Jun 30, 2009, at 5:29 PM, Scott M. Neal wrote: On Jun 30, 2009, at 3:18 PM, Chuck Hill wrote: On Jun 30, 2009, at 9:16 AM, Scott M. Neal wrote: Caused by: java.lang.NullPointerException at com .webobjects .jdbcadaptor .JDBCExpression.columnTypeStringForAttribute(JDBCExpression.ja

Re: WOLips Entity Modeler SQL Generation and WO 5.4

2009-06-30 Thread Scott M. Neal
On Jun 30, 2009, at 3:18 PM, Chuck Hill wrote: On Jun 30, 2009, at 9:16 AM, Scott M. Neal wrote: Caused by: java.lang.NullPointerException at com .webobjects .jdbcadaptor .JDBCExpression.columnTypeStringForAttribute(JDBCExpression.java:160) Suggests that either you have a column with

Re: WOLips Entity Modeler SQL Generation and WO 5.4

2009-06-30 Thread Chuck Hill
On Jun 30, 2009, at 9:16 AM, Scott M. Neal wrote: According to this over-a-year-old posting, Entity Modeler's SQL Generation doesn't work with WebObjects 5.4: http://lists.apple.com/archives/webobjects-dev/2008/May/msg00882.html Is this still the case? I am getting the EXACT

Re: WOLips Entity Modeler SQL Generation and WO 5.4

2009-06-30 Thread Scott M. Neal
Hello Andrew, I had 3 warnings (no errors) in the EOModel, got rid of them, and same problem... Only 15 Entities so far, no stored procedures, and only using the default connection to the database (I've put in a "bad" password to verify that it isn't an authentication issue, as the a

Re: WOLips Entity Modeler SQL Generation and WO 5.4

2009-06-30 Thread Andrew Lindesay
Hello Scott; I am using PG quite a bit and don't have any issues with schema generation -- definitely 5.4.3 was required to resolve some issues. One thing to check is that the model is clean. At some point in time, old JDBC meta-data was in my models' indexes and this caused some proble

Re: WOLips Entity Modeler SQL Generation and WO 5.4

2009-06-30 Thread Scott M. Neal
Pascal, I upgraded to WO 5.4.3, and still the same problem... (but I needed to do that anyway, so thank you!) Responding to Mike Schrag's reply, Forgot to mention one minor (ahem) thing... I'm using PostgreSQL 8.3.7, not mysql or Open/Frontbase. Does the Post

Re: WOLips Entity Modeler SQL Generation and WO 5.4

2009-06-30 Thread Pascal Robert
Le 09-06-30 à 12:16, Scott M. Neal a écrit : According to this over-a-year-old posting, Entity Modeler's SQL Generation doesn't work with WebObjects 5.4: http://lists.apple.com/archives/webobjects-dev/2008/May/msg00882.html Is this still the case? I am getting the EXACT same

Re: WOLips Entity Modeler SQL Generation and WO 5.4

2009-06-30 Thread Mike Schrag
According to this over-a-year-old posting, Entity Modeler's SQL Generation doesn't work with WebObjects 5.4: EM SQL Generation works with WO 5.4, but only on plugins that are implemented properly ... The MySQL plugin probably doesn't properly implement the old 5.3 API's in 5.4. ms _

WOLips Entity Modeler SQL Generation and WO 5.4

2009-06-30 Thread Scott M. Neal
According to this over-a-year-old posting, Entity Modeler's SQL Generation doesn't work with WebObjects 5.4: http://lists.apple.com/archives/webobjects-dev/2008/May/msg00882.html Is this still the case? I am getting the EXACT same exception when attempting to use it... Eclipse