Re: Primary Keys

2012-11-01 Thread Aristedes Maniatis
On 2/11/12 6:35am, Garth Keesler wrote: Can the PK as specified in the DBEntity be different than the PK actually specified in the schema? I ask because I use DB-generated integer sequences as the primary keys which are never used in the software. The software uses an abbreviated form of the ve

Re: PG CITEXT Data Type

2012-11-01 Thread Garth Keesler
I ran a couple of tests where the column is CITEXT and is indexed. The actual value in the database is "TTI" and the row was found when the parameter was "TTI" but not "tti". Is there anything special I need to do in preparing the SelectQuery? Here is the (so far) complete Main pretty much str

Primary Keys

2012-11-01 Thread Garth Keesler
Can the PK as specified in the DBEntity be different than the PK actually specified in the schema? I ask because I use DB-generated integer sequences as the primary keys which are never used in the software. The software uses an abbreviated form of the vendor name that is forced to be unique wi

Re: Modeler Reverse Engineered Entities Don't Match

2012-11-01 Thread Garth Keesler
That explains it. This is my first experience with an ORM so I've a lot to learn but it appears that FK objects related to a particular object I select will also be available automagically much as in J2EE which I've played with a bit as well. Neat. No need to respond since I'll dig this out of