Since ArrayList does not implement the Array interface, no ammount of casting is going to let you do this. In fact you are better off not using reflection. That way you get a compiler error instead of a runtime error. I think you have to use the database specific implementation class of Array.
Is this related to the original question? If not, it's ok to start a new thread (for the future)
1) What kind of object? A database row? A java object? Data in a java object? 2) You can use a connection pool provided by your server (like tomcat) or a third party implementation (like the one in jakarta commons)