How to use sql.Array

[Sarah Gaikwad]

Hi ,
I have an array of objects and want to convert it to sql.Array.

I tried looking on the net but to no avail. This site has always come to my rescue.

I have an array of Objects. How do I convert it to sql.Array.


Thanks a lot.
Sarah

[todd runstein]

Sarah,

I'm kind of curious what it is you're trying to do - I know you want to make a java.sql.Array, but why? What do you intend to do with it after that?

Because Array is an interface, you'll probably need to create your own instance:

public class MyArray implements Array{
....
}

Create a constructor for this class that accepts Object[], and you've got an Array. Of course, you'll need to implement all the methods defined in the Array interface.

I hope this helps (though I suspect this isn't the answer you were looking for).