This week's giveaway is in the EJB and other Java EE Technologies forum. We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line! See this thread for details.
I'll be storing an array of strings. I know I can simply store a delimted string in a regular varchar field then use StringTokenizer. But storing an array sounded interesting. If coding the storage of array is a really big effort I will probably go the StringTokenizer way. I just wanted to give it one last chance before giving up. Thanks.
Oracle has support for collections. It's very much possible to store the array/collections. You have two options 1. Create new types in oracle and change your JDBC calls to use Oracle specific classes. This might be big effort based on your need. 2. Create new types in oracle and use stored procedure to do all DML and Select.