This week's giveaway is in the Spring forum.
We're giving away four copies of REST with Spring (video course) and have Eugen Paraschiv on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes classcast exception while creating array descriptor for oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Reply locked New topic

classcast exception while creating array descriptor for oracle

padmakar reddy kadem

Joined: Dec 24, 2007
Posts: 10
We are migrating from the weblogic server to websphere.I got the following exception for creating the ArrayDescriptor.
class com.orca.message.dao.MessageDAO - java.lang.ClassCastException: incompatible with oracle.jdbc.OracleConnection at oracle.sql.ArrayDescriptor.createDescriptor(
at oracle.sql.ArrayDescriptor.createDescriptor(
at com.orca.message.dao.MessageDAO.getAllMessages(
we used websphere connection pooling.
fowwoling is the code for getting the exception.

code looks like this
import oracle.sql.ArrayDescriptor;
//getting the connection from websphere connection pooling
ArrayDescriptor arrDesc = ArrayDescriptor.createDescriptor("SEL_MSG_STATUS", conn);
arrMsgCode = new ARRAY(arrDesc, conn, msgSearchVo.getArrMsgCode().toArray());

here it is unable to create the arraydescriptor
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63534

Please do not cross-post the same question in multiple forums. It wastes people's time when multiple redundant conversations take place. Please read this for more information.

[Asking smart questions] [About Bear] [Books by Bear]
It is sorta covered in the JavaRanch Style Guide.
subject: classcast exception while creating array descriptor for oracle
It's not a secret anymore!