[Building Sakai] Urgent Help.. Edia scorm tool success on mysql, but has error on oracle (SQL Error: 17027)
swwangl at tsmc.com
swwangl at tsmc.com
Thu Aug 18 18:45:03 PDT 2011
Dear All
Anyone has the experience to solve the SQL Error 17027
I have traced the code, and the problem is at method DataManagerDaoImpl
.load error
public IDataManager load(long id) {
//return (IDataManager)getHibernateTemplate().load(SCODataManager.class,
id);
List r=null;
try{
r = getHibernateTemplate().find(
"from " + SCODataManager.class.getName()
+ " where id=? ",
new Object[]{ id }); //ERROR... But I have review the
SCODataManager.hbm.xml.. It seems no issue for oracle data type
}catch (Exception e){
System.out.println(e.toString());
e.printStackTrace();
}
e.printStackTrace() log is as followings ==>
2011-08-18 14:31:15,190 WARN http-8080-Processor20
org.hibernate.util.JDBCExceptionReporter - SQL Error: 17027, SQLState:
99999
2011-08-18 14:31:15,190 ERROR http-8080-Processor20
org.hibernate.util.JDBCExceptionReporter - Stream has already been closed
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation:
could not initialize a collection:
[org.adl.datamodels.ieee.SCORM_2004_DM.mElements#2229]; uncategorized
SQLException for SQL [select melements0_.DATAMODEL_ID as DATAMODEL1_5_,
melements0_.ELEMENT_ID as ELEMENT2_5_, melements0_.ELEMENT_BINDING as
ELEMENT3_5_, scorm_2004x1_.ELEMENT_ID as ELEMENT1_89_0_,
scorm_2004x1_.DESCRIPTION as DESCRIPT3_89_0_, scorm_2004x1_.PARENT as
PARENT89_0_, scorm_2004x1_.VALUE as VALUE89_0_,
scorm_2004x1_.IS_INITIALIZED as IS6_89_0_, scorm_2004x1_.TRUNC_SPM as
TRUNC7_89_0_, dmelementd2_.ELEM_DESC_ID as ELEM1_94_1_,
dmelementd2_.ED_BINDING as ED2_94_1_, dmelementd2_.IS_READABLE as
IS3_94_1_, dmelementd2_.IS_WRITABLE as IS4_94_1_,
dmelementd2_.INITIAL_VALUE as INITIAL5_94_1_, dmelementd2_.IS_UNIQUE as
IS6_94_1_, dmelementd2_.IS_WRITE_ONCE as IS7_94_1_, dmelementd2_.VALUE_SPM
as VALUE8_94_1_, dmelementd2_.SPM as SPM94_1_, dmelementd2_.OLD_SPM as
OLD10_94_1_, dmelementd2_.IS_MAXIMUM as IS11_94_1_,
dmelementd2_.IS_SHOW_CHILDREN as IS12_94_1_, dmelement3_.ELEMENT_ID as
ELEMENT1_89_2_, dmelement3_.DESCRIPTION as DESCRIPT3_89_2_,
dmelement3_.PARENT as PARENT89_2_, dmelement3_.VALUE as VALUE89_2_,
dmelement3_.IS_INITIALIZED as IS6_89_2_, dmelement3_.TRUNC_SPM as
TRUNC7_89_2_, dmelement3_.NAVIGATION_DM as NAVIGATION8_89_2_,
dmelement3_.BINDING as BINDING89_2_, dmelement3_.IS_RANDOMIZED as
IS10_89_2_, dmelement3_.DM_COUNT as DM11_89_2_, dmelement3_.CLASS_TYPE as
CLASS2_89_2_, scorm_2004x4_.DATAMODEL_ID as DATAMODEL1_97_3_,
scorm_2004x4_.NAV_REQUESTS as NAV4_97_3_, scorm_2004x4_.CURRENT_REQUEST as
CURRENT5_97_3_, scorm_2004x4_.BINDING as BINDING97_3_,
adlvalidre5_.VALID_REQUESTS_ID as VALID1_104_4_,
adlvalidre5_.IS_START_ENABLED as IS2_104_4_,
adlvalidre5_.IS_RESUME_ALL_ENABLED as IS3_104_4_,
adlvalidre5_.IS_CONTINUE_ENABLED as IS4_104_4_,
adlvalidre5_.IS_CONTINUE_EXIT_ENABLED as IS5_104_4_,
adlvalidre5_.IS_PREVIOUS_ENABLED as IS6_104_4_,
adlvalidre5_.IS_SUSPEND_VALID as IS7_104_4_ from SCORM_MAP_ELEMENTS_T
melements0_ left outer join SCORM_ELEMENT_T scorm_2004x1_ on
melements0_.ELEMENT_ID=scorm_2004x1_.ELEMENT_ID left outer join
SCORM_ELEMENT_DESC_T dmelementd2_ on
scorm_2004x1_.DESCRIPTION=dmelementd2_.ELEM_DESC_ID left outer join
SCORM_ELEMENT_T dmelement3_ on scorm_2004x1_.PARENT=dmelement3_.ELEMENT_ID
left outer join SCORM_DATAMODEL_T scorm_2004x4_ on
dmelement3_.NAVIGATION_DM=scorm_2004x4_.DATAMODEL_ID left outer join
SCORM_ADL_VALID_REQUESTS_T adlvalidre5_ on
scorm_2004x4_.NAV_REQUESTS=adlvalidre5_.VALID_REQUESTS_ID where
melements0_.DATAMODEL_ID=?]; SQL state [99999]; error code [17027]; Stream
has already been closed; nested exception is java.sql.SQLException: Stream
has already been closed
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation:
could not initialize a collection:
[org.adl.datamodels.ieee.SCORM_2004_DM.mElements#2229]; uncategorized
SQLException for SQL [select melements0_.DATAMODEL_ID as DATAMODEL1_5_,
melements0_.ELEMENT_ID as ELEMENT2_5_, melements0_.ELEMENT_BINDING as
ELEMENT3_5_, scorm_2004x1_.ELEMENT_ID as ELEMENT1_89_0_,
scorm_2004x1_.DESCRIPTION as DESCRIPT3_89_0_, scorm_2004x1_.PARENT as
PARENT89_0_, scorm_2004x1_.VALUE as VALUE89_0_,
scorm_2004x1_.IS_INITIALIZED as IS6_89_0_, scorm_2004x1_.TRUNC_SPM as
TRUNC7_89_0_, dmelementd2_.ELEM_DESC_ID as ELEM1_94_1_,
dmelementd2_.ED_BINDING as ED2_94_1_, dmelementd2_.IS_READABLE as
IS3_94_1_, dmelementd2_.IS_WRITABLE as IS4_94_1_,
dmelementd2_.INITIAL_VALUE as INITIAL5_94_1_, dmelementd2_.IS_UNIQUE as
IS6_94_1_, dmelementd2_.IS_WRITE_ONCE as IS7_94_1_, dmelementd2_.VALUE_SPM
as VALUE8_94_1_, dmelementd2_.SPM as SPM94_1_, dmelementd2_.OLD_SPM as
OLD10_94_1_, dmelementd2_.IS_MAXIMUM as IS11_94_1_,
dmelementd2_.IS_SHOW_CHILDREN as IS12_94_1_, dmelement3_.ELEMENT_ID as
ELEMENT1_89_2_, dmelement3_.DESCRIPTION as DESCRIPT3_89_2_,
dmelement3_.PARENT as PARENT89_2_, dmelement3_.VALUE as VALUE89_2_,
dmelement3_.IS_INITIALIZED as IS6_89_2_, dmelement3_.TRUNC_SPM as
TRUNC7_89_2_, dmelement3_.NAVIGATION_DM as NAVIGATION8_89_2_,
dmelement3_.BINDING as BINDING89_2_, dmelement3_.IS_RANDOMIZED as
IS10_89_2_, dmelement3_.DM_COUNT as DM11_89_2_, dmelement3_.CLASS_TYPE as
CLASS2_89_2_, scorm_2004x4_.DATAMODEL_ID as DATAMODEL1_97_3_,
scorm_2004x4_.NAV_REQUESTS as NAV4_97_3_, scorm_2004x4_.CURRENT_REQUEST as
CURRENT5_97_3_, scorm_2004x4_.BINDING as BINDING97_3_,
adlvalidre5_.VALID_REQUESTS_ID as VALID1_104_4_,
adlvalidre5_.IS_START_ENABLED as IS2_104_4_,
adlvalidre5_.IS_RESUME_ALL_ENABLED as IS3_104_4_,
adlvalidre5_.IS_CONTINUE_ENABLED as IS4_104_4_,
adlvalidre5_.IS_CONTINUE_EXIT_ENABLED as IS5_104_4_,
adlvalidre5_.IS_PREVIOUS_ENABLED as IS6_104_4_,
adlvalidre5_.IS_SUSPEND_VALID as IS7_104_4_ from SCORM_MAP_ELEMENTS_T
melements0_ left outer join SCORM_ELEMENT_T scorm_2004x1_ on
melements0_.ELEMENT_ID=scorm_2004x1_.ELEMENT_ID left outer join
SCORM_ELEMENT_DESC_T dmelementd2_ on
scorm_2004x1_.DESCRIPTION=dmelementd2_.ELEM_DESC_ID left outer join
SCORM_ELEMENT_T dmelement3_ on scorm_2004x1_.PARENT=dmelement3_.ELEMENT_ID
left outer join SCORM_DATAMODEL_T scorm_2004x4_ on
dmelement3_.NAVIGATION_DM=scorm_2004x4_.DATAMODEL_ID left outer join
SCORM_ADL_VALID_REQUESTS_T adlvalidre5_ on
scorm_2004x4_.NAV_REQUESTS=adlvalidre5_.VALID_REQUESTS_ID where
melements0_.DATAMODEL_ID=?]; SQL state [99999]; error code [17027]; Stream
has already been closed; nested exception is java.sql.SQLException: Stream
has already been closed
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate
(
AbstractFallbackSQLExceptionTranslator.java:83)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate
(
AbstractFallbackSQLExceptionTranslator.java:80)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate
(
AbstractFallbackSQLExceptionTranslator.java:80)
at
org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException
(
HibernateAccessor.java:424)
at
org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException
(
HibernateAccessor.java:410)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(
HibernateTemplate.java:424)
at
org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession
(
HibernateTemplate.java:374)
at org.springframework.orm.hibernate3.HibernateTemplate.find(
HibernateTemplate.java:921)
at org.sakaiproject.scorm.dao.hibernate.DataManagerDaoImpl.load(
DataManagerDaoImpl.java:57)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(
NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(
AopUtils.java:307)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint
(
ReflectiveMethodInvocation.java:182)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:149)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(
TransactionInterceptor.java:106)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(
JdkDynamicAopProxy.java:204)
at $Proxy52.load(Unknown Source)
at
org.sakaiproject.scorm.service.impl.ScormApplicationServiceImpl.initialize(
ScormApplicationServiceImpl.java:625)
at
org.sakaiproject.scorm.service.impl.ScormApplicationServiceImpl.initialize(
ScormApplicationServiceImpl.java:296)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(
NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.wicket.proxy.LazyInitProxyFactory$JdkHandler.invoke(
LazyInitProxyFactory.java:416)
at org.apache.wicket.proxy.$Proxy119.initialize(Unknown Source)
at org.sakaiproject.scorm.ui.player.behaviors.SCORM13API.Initialize(
SCORM13API.java:82)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(
NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.sakaiproject.scorm.ui.player.behaviors.SjaxCall.callMethod(
SjaxCall.java:192)
at org.sakaiproject.scorm.ui.player.components.SjaxContainer
$ScormSjaxCall.callMethod(SjaxContainer.java:191)
at org.sakaiproject.scorm.ui.player.components.SjaxContainer
$1.callMethod(SjaxContainer.java:96)
at org.sakaiproject.scorm.ui.player.behaviors.SjaxCall.onEvent(
SjaxCall.java:222)
at org.sakaiproject.scorm.ui.player.components.SjaxContainer
$ScormSjaxCall.onEvent(SjaxContainer.java:213)
at org.apache.wicket.ajax.AjaxEventBehavior.respond(
AjaxEventBehavior.java:163)
at org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(
AbstractDefaultAjaxBehavior.java:297)
at
org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.processEvents
(
BehaviorRequestTarget.java:104)
at
org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(
AbstractRequestCycleProcessor.java:91)
at org.apache.wicket.RequestCycle.processEventsAndRespond(
RequestCycle.java:1239)
at org.apache.wicket.RequestCycle.step(RequestCycle.java:1316)
at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1418)
at org.apache.wicket.RequestCycle.request(RequestCycle.java:532)
at org.apache.wicket.protocol.http.WicketFilter.doGet(
WicketFilter.java:356)
at org.apache.wicket.protocol.http.WicketServlet.doGet(
WicketServlet.java:124)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:188)
at org.sakaiproject.util.RequestFilter.doFilter(
RequestFilter.java:598)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:188)
at org.sakaiproject.scorm.ui.player.ScormSecurityFilter.doFilter(
ScormSecurityFilter.java:18)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(
ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(
ApplicationDispatcher.java:457)
at org.apache.catalina.core.ApplicationDispatcher.doForward(
ApplicationDispatcher.java:359)
at org.apache.catalina.core.ApplicationDispatcher.forward(
ApplicationDispatcher.java:311)
at org.sakaiproject.tool.impl.ActiveToolComponent
$MyActiveTool.forward(ActiveToolComponent.java:511)
at org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(
SkinnableCharonPortal.java:1453)
at org.sakaiproject.portal.charon.handlers.ToolHandler.doTool(
ToolHandler.java:204)
at org.sakaiproject.portal.charon.handlers.ToolHandler.doGet(
ToolHandler.java:96)
at org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(
SkinnableCharonPortal.java:877)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:188)
at org.sakaiproject.util.RequestFilter.doFilter(
RequestFilter.java:659)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(
StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(
StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(
StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(
ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(
StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(
CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(
Http11Processor.java:879)
at org.apache.coyote.http11.Http11BaseProtocol
$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: Stream has already been closed
at oracle.jdbc.driver.LongAccessor.getBytesInternal(
LongAccessor.java:156)
at oracle.jdbc.driver.LongAccessor.getBytes(LongAccessor.java:126)
at oracle.jdbc.driver.LongAccessor.getString(LongAccessor.java:201)
at oracle.jdbc.driver.T4CLongAccessor.getString(
T4CLongAccessor.java:427)
at oracle.jdbc.driver.OracleResultSetImpl.getString(
OracleResultSetImpl.java:1150)
at oracle.jdbc.driver.OracleResultSet.getString(
OracleResultSet.java:424)
at org.apache.commons.dbcp.DelegatingResultSet.getString(
DelegatingResultSet.java:225)
at org.hibernate.type.StringType.get(StringType.java:18)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:163)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:154)
at org.hibernate.type.AbstractType.hydrate(AbstractType.java:81)
at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(
AbstractEntityPersister.java:2091)
at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1380)
at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1308)
at org.hibernate.loader.Loader.getRow(Loader.java:1206)
at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:580)
at org.hibernate.loader.Loader.doQuery(Loader.java:701)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections
(Loader.java:236)
at org.hibernate.loader.Loader.loadCollection(Loader.java:1998)
at org.hibernate.loader.collection.CollectionLoader.initialize(
CollectionLoader.java:36)
at
org.hibernate.persister.collection.AbstractCollectionPersister.initialize(
AbstractCollectionPersister.java:565)
at
org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection
(
DefaultInitializeCollectionEventListener.java:63)
at org.hibernate.impl.SessionImpl.initializeCollection(
SessionImpl.java:1717)
at
org.hibernate.collection.AbstractPersistentCollection.forceInitialization(
AbstractPersistentCollection.java:454)
at
org.hibernate.engine.StatefulPersistenceContext.initializeNonLazyCollections
(
StatefulPersistenceContext.java:844)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections
(Loader.java:241)
at org.hibernate.loader.Loader.doList(Loader.java:2217)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2108)
at org.hibernate.loader.Loader.list(Loader.java:2103)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(
QueryTranslatorImpl.java:340)
at org.hibernate.engine.query.HQLQueryPlan.performList(
HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1122)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.springframework.orm.hibernate3.HibernateTemplate
$30.doInHibernate(HibernateTemplate.java:930)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(
HibernateTemplate.java:419)
... 80 more
Best Regards,
Joan
---------------------------------------------------------------------------
TSMC PROPERTY
This email communication (and any attachments) is proprietary information
for the sole use of its
intended recipient. Any unauthorized review, use or distribution by anyone
other than the intended
recipient is strictly prohibited. If you are not the intended recipient,
please notify the sender by
replying to this email, and then delete this email and any copies of it
immediately. Thank you.
---------------------------------------------------------------------------
More information about the sakai-dev
mailing list