Meaningless Drivel is fun!
The moose likes JDBC and Relational Databases and the fly likes java.sql.SQLException: Internal Error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "java.sql.SQLException: Internal Error" Watch "java.sql.SQLException: Internal Error" New topic

java.sql.SQLException: Internal Error

Mohammed Eesa

Joined: May 06, 2004
Posts: 17
hai all,
Iam using Oracle 9i.I am getting error When i access the Oracle Type through Java.

my Code is

con = connectionFactory.getConnection();
csmt = con.prepareCall("call PMS_PR_area_SIGN_CONTROL ( ?,?,?,?,?)");
csmt.setInt(1, groupId);
csmt.registerOutParameter(4,Types.ARRAY, "PMS_TY_TAB_SG_CNTRL");
oracle.sql.ARRAY.oracleARRAY = (oracle.sql.ARRAY.ARRAY)csmt.getArray(4);
rs = oracleARRAY.getResultSet();
while (
below line gives error
oracle.sql.STRUCT STRUCT struct=(oracle.sql.STRUCT.STRUCT)rs.getObject(2);//getting error at this line
Object[] resultObj = struct.getAttributes();

Stack Trace is
java.sql.SQLException: Internal Error
at oracle.jdbc.dbaccess.DBError.throwSqlException(
at oracle.jdbc.dbaccess.DBError.throwSqlException(
at oracle.jdbc.dbaccess.DBError.throwSqlException(
at oracle.jdbc.oracore.OracleTypeCOLLECTION.initCollElemTypeName(
at oracle.jdbc.oracore.OracleTypeCOLLECTION.getAttributeType(
at oracle.jdbc.oracore.OracleNamedType.getFullName(
at oracle.sql.TypeDescriptor.initSQLName(
at oracle.sql.TypeDescriptor.getName(
at oracle.sql.StructDescriptor.getClass(
at oracle.sql.STRUCT.toJdbc(
at oracle.jdbc.oracore.OracleTypeUPT.unpickle80rec(
at oracle.jdbc.oracore.OracleTypeCOLLECTION.unpickle80rec_elems(
at oracle.jdbc.oracore.OracleTypeCOLLECTION.unpickle80rec(
at oracle.jdbc.oracore.OracleTypeCOLLECTION.unpickle80(
at oracle.jdbc.oracore.OracleTypeCOLLECTION.unlinearize(
at oracle.sql.ArrayDescriptor.toJavaArray(
at oracle.sql.ARRAY.getArray(
at it.sella.pms.dao.TimeSheetReportDAO.getSignControlByGroup(

I am getting problem in Converting to STRUTS

Can any one help me.
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1138

There are examples of how to do this on Oracle's OTN Web site. Have you looked here:

and here:

Good Luck,
I agree. Here's the link:
subject: java.sql.SQLException: Internal Error
jQuery in Action, 3rd edition