I have done a lot of search and also have tried whatever I could fine but the
issue could not be resoved. When I run the code I get the following error:
Error in java.lang.ClassCastException:
org.jboss.resource.adapter.jdbc.WrappedCallableStatement"
Here is a part of the code:
import oracle.jdbc.OracleCallableStatement;
import oracle.jdbc.OracleTypes;
import oracle.jdbc.pool.OracleDataSource;
import java.lang.*;
import java.util.*;
import java.io.*;
import java.sql.*;
............
........
.....
OracleCallableStatement cstmt = null;
String[] orgNames = null;
int maxTablLen = 250;
int eleMaxLen = 100;
try{
ConnPool conObj = new ConnPool();
con = conObj.getConnection();
cstmt = (OracleCallableStatement) con.prepareCall(" begin"+
"GETS_LMS_RECAP_DEFECTS_PKG.GETS_PL_SQL_TEST(?);"+
" end;");
cstmt.registerIndexTableOutParameter(1,maxTablLen,OracleTypes.VARCHAR,eleMaxLen);
cstmt.execute();
orgNames = (String [])cstmt.getObject(1);
System.out.println("Number of rows= "+orgNames.length);
for (int i=0; i<orgNames.length; i++){
System.out.print(orgNames);
System.out.println();
}
The exception is thrown prior to even executing "cstmt.execute();".
Please advise how to fix this error?
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4112720#4112720
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4112720
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
