L
laredotornado
Hi, I'm using WebLogic 9.2.2, running on Solaris 9 with Java 1.5. I
am getting the below exception (SQLException: Internal error) on this
line of code:
Object[] billSetValues = (Object[]) billSetArrayFromOut.getArray
(); // line 549
and I'm not sure what it means or how to resolve it. I have included
additional code around the above below too. Any ideas what my next
troubleshooting steps should be?
Thanks, - Dave
=========Surrounding code=================
NPSFeatureSQLData featSQL =
(NPSFeatureSQLData) featSQLs;
if (featSQL != null)
{
FeatureDef featureObj
= new FeatureDef();
featureObj.setAction
(featSQL.action);
featureObj.setApp_name
(featSQL.app_name);
featureObj.setFeature_name(featSQL.feature_name);
featureObj.setFeature_desc(featSQL.feature_desc);
featureObj.setUpdated_feature_name(featSQL.updated_feature_name);
featureObj.setLast_updated_by(featSQL.last_updated_by);
oracle.sql.ARRAY
billSetArrayFromOut = featSQL.billSets;
Object[] billSetValues
= (Object[]) billSetArrayFromOut
.getArray
();
=======End Surrounding code ================
ERROR 2008-12-29 15:51:14,071 -
[com.myco.nps.config.feature.dao.NPSFeatureManagementDAO::getFeatures]
- SQL Exception
java.sql.SQLException: Internal Error
at oracle.jdbc.driver.DatabaseError.throwSqlException
(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException
(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException
(DatabaseError.java:208)
at
oracle.jdbc.oracore.OracleTypeCOLLECTION.initCollElemTypeName
(OracleTypeCOLLECTION.java:1074)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.getAttributeType
(OracleTypeCOLLECTION.java:1107)
at oracle.jdbc.oracore.OracleNamedType.getFullName
(OracleNamedType.java:81)
at oracle.jdbc.oracore.OracleNamedType.getFullName
(OracleNamedType.java:68)
at oracle.sql.TypeDescriptor.initSQLName(TypeDescriptor.java:
237)
at oracle.sql.TypeDescriptor.getName(TypeDescriptor.java:198)
at oracle.sql.StructDescriptor.getClass(StructDescriptor.java:
1105)
at oracle.sql.STRUCT.toJdbc(STRUCT.java:574)
at oracle.jdbc.oracore.OracleTypeUPT.unpickle81UPT
(OracleTypeUPT.java:502)
at oracle.jdbc.oracore.OracleTypeUPT.unpickle81rec
(OracleTypeUPT.java:456)
at
oracle.jdbc.oracore.OracleTypeCOLLECTION.unpickle81ImgBodyElements
(OracleTypeCOLLECTION.java:1011)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.unpickle81ImgBody
(OracleTypeCOLLECTION.java:952)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.unpickle81
(OracleTypeCOLLECTION.java:764)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.unlinearizeInternal
(OracleTypeCOLLECTION.java:243)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.unlinearize
(OracleTypeCOLLECTION.java:217)
at oracle.sql.ArrayDescriptor.toJavaArray(ArrayDescriptor.java:
891)
at oracle.sql.ARRAY.getArray(ARRAY.java:315)
at
com.myco.nps.config.feature.dao.NPSFeatureManagementDAO.getFeatures
(NPSFeatureManagementDAO.java:549)
at
com.myco.nps.config.common.delegate.NPSConfigDelegate.getFeatures
(NPSConfigDelegate.java:280)
at
com.myco.nps.config.ejb.service.NPSConfigServiceEJB.getFeatures
(NPSConfigServiceEJB.java:495)
at
com.myco.nps.config.ejb.service.NPSConfigServiceEJB_8huew0_EOImpl.getFeatures
(NPSConfigServiceEJB_8huew0_EOImpl.java:1437)
at
com.myco.nps.config.ejb.service.NPSConfigServiceEJB_8huew0_EOImpl_WLSkel.invoke
(Unknown Source)
at weblogic.rmi.internal.BasicServerRef.invoke
(BasicServerRef.java:550)
at weblogic.rmi.cluster.ClusterableServerRef.invoke
(ClusterableServerRef.java:224)
at weblogic.rmi.internal.BasicServerRef$1.run
(BasicServerRef.java:440)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs
(AuthenticatedSubject.java:363)
at weblogic.security.service.SecurityManager.runAs
(SecurityManager.java:147)
at weblogic.rmi.internal.BasicServerRef.handleRequest
(BasicServerRef.java:436)
at weblogic.rmi.internal.BasicServerRef.access$300
(BasicServerRef.java:58)
at weblogic.rmi.internal.BasicServerRef$BasicExecuteRequest.run
(BasicServerRef.java:975)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:181)
am getting the below exception (SQLException: Internal error) on this
line of code:
Object[] billSetValues = (Object[]) billSetArrayFromOut.getArray
(); // line 549
and I'm not sure what it means or how to resolve it. I have included
additional code around the above below too. Any ideas what my next
troubleshooting steps should be?
Thanks, - Dave
=========Surrounding code=================
NPSFeatureSQLData featSQL =
(NPSFeatureSQLData) featSQLs;
if (featSQL != null)
{
FeatureDef featureObj
= new FeatureDef();
featureObj.setAction
(featSQL.action);
featureObj.setApp_name
(featSQL.app_name);
featureObj.setFeature_name(featSQL.feature_name);
featureObj.setFeature_desc(featSQL.feature_desc);
featureObj.setUpdated_feature_name(featSQL.updated_feature_name);
featureObj.setLast_updated_by(featSQL.last_updated_by);
oracle.sql.ARRAY
billSetArrayFromOut = featSQL.billSets;
Object[] billSetValues
= (Object[]) billSetArrayFromOut
.getArray
();
=======End Surrounding code ================
ERROR 2008-12-29 15:51:14,071 -
[com.myco.nps.config.feature.dao.NPSFeatureManagementDAO::getFeatures]
- SQL Exception
java.sql.SQLException: Internal Error
at oracle.jdbc.driver.DatabaseError.throwSqlException
(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException
(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException
(DatabaseError.java:208)
at
oracle.jdbc.oracore.OracleTypeCOLLECTION.initCollElemTypeName
(OracleTypeCOLLECTION.java:1074)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.getAttributeType
(OracleTypeCOLLECTION.java:1107)
at oracle.jdbc.oracore.OracleNamedType.getFullName
(OracleNamedType.java:81)
at oracle.jdbc.oracore.OracleNamedType.getFullName
(OracleNamedType.java:68)
at oracle.sql.TypeDescriptor.initSQLName(TypeDescriptor.java:
237)
at oracle.sql.TypeDescriptor.getName(TypeDescriptor.java:198)
at oracle.sql.StructDescriptor.getClass(StructDescriptor.java:
1105)
at oracle.sql.STRUCT.toJdbc(STRUCT.java:574)
at oracle.jdbc.oracore.OracleTypeUPT.unpickle81UPT
(OracleTypeUPT.java:502)
at oracle.jdbc.oracore.OracleTypeUPT.unpickle81rec
(OracleTypeUPT.java:456)
at
oracle.jdbc.oracore.OracleTypeCOLLECTION.unpickle81ImgBodyElements
(OracleTypeCOLLECTION.java:1011)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.unpickle81ImgBody
(OracleTypeCOLLECTION.java:952)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.unpickle81
(OracleTypeCOLLECTION.java:764)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.unlinearizeInternal
(OracleTypeCOLLECTION.java:243)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.unlinearize
(OracleTypeCOLLECTION.java:217)
at oracle.sql.ArrayDescriptor.toJavaArray(ArrayDescriptor.java:
891)
at oracle.sql.ARRAY.getArray(ARRAY.java:315)
at
com.myco.nps.config.feature.dao.NPSFeatureManagementDAO.getFeatures
(NPSFeatureManagementDAO.java:549)
at
com.myco.nps.config.common.delegate.NPSConfigDelegate.getFeatures
(NPSConfigDelegate.java:280)
at
com.myco.nps.config.ejb.service.NPSConfigServiceEJB.getFeatures
(NPSConfigServiceEJB.java:495)
at
com.myco.nps.config.ejb.service.NPSConfigServiceEJB_8huew0_EOImpl.getFeatures
(NPSConfigServiceEJB_8huew0_EOImpl.java:1437)
at
com.myco.nps.config.ejb.service.NPSConfigServiceEJB_8huew0_EOImpl_WLSkel.invoke
(Unknown Source)
at weblogic.rmi.internal.BasicServerRef.invoke
(BasicServerRef.java:550)
at weblogic.rmi.cluster.ClusterableServerRef.invoke
(ClusterableServerRef.java:224)
at weblogic.rmi.internal.BasicServerRef$1.run
(BasicServerRef.java:440)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs
(AuthenticatedSubject.java:363)
at weblogic.security.service.SecurityManager.runAs
(SecurityManager.java:147)
at weblogic.rmi.internal.BasicServerRef.handleRequest
(BasicServerRef.java:436)
at weblogic.rmi.internal.BasicServerRef.access$300
(BasicServerRef.java:58)
at weblogic.rmi.internal.BasicServerRef$BasicExecuteRequest.run
(BasicServerRef.java:975)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:181)