If you specify the column names (and order) in your insert statement it
won't matter in which order Orion created the columns.


On Mon, May 14, 2001 at 03:41:03PM +0000, Erwin Teseling wrote:
> Hello everybody,
> I am having some problems regarding the order in which Orion creates the 
> database columns for compound keys for an entity bean when using CMP. 
> I have an entity bean that models a many-to-many relationship, which has 
> a compound key (subscriptionID & userID). Now when creating the database 
> tables Orion seems to be inconsistent on the order in which these two are 
> mapped on the database table. On one machine subscriptionID is mapped on 
> the first column and on another machine (or at another time) userID is 
> mapped on the first column (and subscriptionID on the second). 
> Now when I fill my database with a very simple SQL script sometimes my 
> data gets mixed up because it fills the wrong column with the wrong data. 
> Offcourse I can fixs this in the script, but is there a way to tell Orion 
> which field should mapp to which column in the columns to be created in 
> the database??
> Thanks!
> Regards,
> Erwin Teseling


Markus Holmberg         |       Give me Unix or give me a typewriter.
[EMAIL PROTECTED]      |       http://www.freebsd.org/

Reply via email to