Thanks again Craig. I finally figured out how to solve my issue. The oracle implementation of sql Array requires an OracleConnection. However, the connection I got from the data source is a wrapper around the OracleConnection. Oracle jdbc didn't understand what type of Connection this wrapper is. So I have to explicitly use ((PoolableConnection) dataSource.getConnection()).getDelegate() and pass this underlying connection to oracle. Regards, Phillip Qin "This Guy Thinks He Knows Everything" Canadian Shareowner 121 Richmond Street W, 7th Floor Toronto, ON M5H 2K1 (416) 595-9600 ext 291
