Nookala, Karthikeyan is saying that the "array" variable is null -- and that's why you are getting a "NullPointerException".
However, I think you do not properly understand how JDBC works. "Array" is not used in the way you are using it in your code (unless there's something I'm missing).
Maybe you should try the JDBC trail in the Java Tutorial
Good Luck, Avi. [ August 12, 2005: Message edited by: Avi Abrami ]
Joined: Mar 19, 2004
I am trying to learn about the interface java.sql.Array. The method getResultSet(long index, int count) is the one I am trying to use in my code. It says "Retrieves a result set holding the elements of the subarray that starts at index index and contains up to count successive elements." As this is an Interface I know I cannot use new operator to initialize this. That is why I want to see if I can get a code snippet. Sorry for not able to express myself properly before.