Hi,If I understand, you want to store a Java String[ ] as a text[ ] in the database.
You will need to write a special field externalization method. Take a look at OpenJPA http://openjpa.apache.org/docs/latest/manual/manual.html#ref_guide_pc_externUsing an externalization method allows you to take a String[ ] and convert it to a single String for storage in the text field in the column.
Can this be used to solve your issue? Craig On Feb 1, 2008, at 12:20 AM, dave. wrote:
Hi Craig,There is text[] data type -among other things- in postgres which can store an array of strings in the same row of table which can do the job of storingan array of strings just perfectly.Actually I think creating another table and all of those keys and etc create extra and unnecessary load on db server specially when the first table isbig and there are numerous items in that array. Thanks. -- View this message in context: http://www.nabble.com/How-to-store-a-string-array-as-a-string-array-using-jpa--tp15214168p15222162.html Sent from the OpenJPA Users mailing list archive at Nabble.com.
Craig Russell Architect, Sun Java Enterprise System http://java.sun.com/products/jdo 408 276-5638 mailto:[EMAIL PROTECTED] P.S. A good JDO? O, Gasp!
smime.p7s
Description: S/MIME cryptographic signature
