[Building Sakai] melete 2.8.2 and sakai 2.8

Angel Nueda Lozano anueda at asic.upv.es
Tue May 17 05:56:10 PDT 2011 

Yes, this problem happens with Oracle. But, I tested on MySQL too with 
the same results.

This is the exception on MySQL with tomcat 5.5.33 and java 1.6.

Any idea?

java.lang.NullPointerException
     at 
com.mysql.jdbc.ConnectionImpl.versionMeetsMinimum(ConnectionImpl.java:5545)
     at 
com.mysql.jdbc.ConnectionImpl.serverSupportsConvertFn(ConnectionImpl.java:4961)
     at com.mysql.jdbc.ConnectionImpl.nativeSQL(ConnectionImpl.java:4003)
     at 
com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4234)
     at 
com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4190)
     at 
org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:248)
     at 
org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:302)
     at 
org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:548)
     at 
org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:471)
     at 
org.sakaiproject.util.BaseDbDualSingleStorage.loadResources(BaseDbDualSingleStorage.java:512)
     at 
org.sakaiproject.util.BaseDbDualSingleStorage.getResource(BaseDbDualSingleStorage.java:357)
     at 
org.sakaiproject.content.impl.DbContentService$DbStorage.getCollection(DbContentService.java:1266)
     at 
org.sakaiproject.content.impl.BaseContentService.findCollection(BaseContentService.java:2419)
     at 
org.sakaiproject.content.impl.BaseContentService$BasicGroupAwareEdit.getContainingCollection(BaseContentService.java:10140)
     at 
org.sakaiproject.content.impl.BaseContentService$BasicGroupAwareEdit.isAvailable(BaseContentService.java:10050)
     at 
org.sakaiproject.content.impl.BaseContentService.postAvailableEvent(BaseContentService.java:2801)
     at 
org.sakaiproject.content.impl.BaseContentService.commitResourceEdit(BaseContentService.java:5753)
     at 
org.sakaiproject.content.impl.BaseContentService.commitResource(BaseContentService.java:5542)
     at 
org.sakaiproject.content.impl.BaseContentService.addResource(BaseContentService.java:3244)
     at 
org.sakaiproject.content.impl.BaseContentService.addResource(BaseContentService.java:3188)
     at 
org.sakaiproject.content.impl.BaseContentService.addResource(BaseContentService.java:3520)
     at 
org.etudes.component.app.melete.MeleteCHServiceImpl.addResourceItem(MeleteCHServiceImpl.java:709)
     at 
org.etudes.component.app.melete.MeleteImportServiceImpl.processEmbedDatafromHTML(MeleteImportServiceImpl.java:1201)
     at 
org.etudes.component.app.melete.MeleteImportServiceImpl.createContentResource(MeleteImportServiceImpl.java:1233)
     at 
org.etudes.component.app.melete.MeleteImportServiceImpl.buildSection(MeleteImportServiceImpl.java:1039)
     at 
org.etudes.component.app.melete.MeleteImportServiceImpl.buildModule(MeleteImportServiceImpl.java:824)
     at 
org.etudes.component.app.melete.MeleteImportServiceImpl.parseAndBuildModules(MeleteImportServiceImpl.java:702)
     at 
org.etudes.tool.melete.ExportMeleteModules.importModules(ExportMeleteModules.java:550)
     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 
com.sun.faces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:126)
     at 
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:72)
     at javax.faces.component.UICommand.broadcast(UICommand.java:312)
     at 
javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:267)
     at 
javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:381)
     at 
com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:75)
     at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:200)
     at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:90)
     at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197)
     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.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:395)
     at 
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
     at org.sakaiproject.jsf.util.JsfTool.dispatch(JsfTool.java:221)
     at org.sakaiproject.jsf.util.JsfTool.doPost(JsfTool.java:256)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
     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.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:1436)
     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.handlers.ToolHandler.doPost(ToolHandler.java:73)
     at 
org.sakaiproject.portal.charon.SkinnableCharonPortal.doPost(SkinnableCharonPortal.java:1231)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
     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:662)

El 17/05/11 14:29, Miguel Carro Pellicer escribió:
> I can import and export contents without problems, tested on MySQL 
> (App RHEL 6 and Windows 7).
>
> That problems happens with Oracle?
>
>
> El 17/05/2011 14:23, Angel Nueda Lozano escribió:
>> I think you mean I need configure melete.packagingDir, but I did before.
>>
>> When import small content package usually I had no problems. But, 
>> with others bigger, I had problems.
>>
>> 2011-05-17 14:21:28,976  WARN http-8080-Processor25 
>> org.hibernate.util.JDBCExceptionReporter - SQL Error: 17002, 
>> SQLState: 08006
>> 2011-05-17 14:21:28,977 ERROR http-8080-Processor25 
>> org.hibernate.util.JDBCExceptionReporter - Error de E/S: Socket closed
>> 2011-05-17 14:21:28,978 ERROR http-8080-Processor25 
>> org.etudes.component.app.melete.SectionDB - 
>> org.hibernate.exception.JDBCConnectionException: could not execute query
>> 2011-05-17 14:21:28,979  WARN http-8080-Processor25 
>> org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: null
>> 2011-05-17 14:21:28,979 ERROR http-8080-Processor25 
>> org.hibernate.util.JDBCExceptionReporter - Already closed.
>> 2011-05-17 14:21:28,979  WARN http-8080-Processor25 
>> org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: null
>> 2011-05-17 14:21:28,979 ERROR http-8080-Processor25 
>> org.hibernate.util.JDBCExceptionReporter - Already closed.
>> 2011-05-17 14:21:28,981 ERROR http-8080-Processor25 
>> org.etudes.tool.melete.ExportMeleteModules - 
>> org.etudes.tool.melete.ExportMeleteModules : 
>> org.etudes.api.app.melete.exception.MeleteException: add_section_fail
>> 2011-05-17 14:21:37,609 ERROR QuartzScheduler_QuartzSchedulerThread 
>> org.quartz.impl.jdbcjobstore.JobStoreTX - Failed to close Connection
>> java.sql.SQLException: Already closed.
>>     at 
>> org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:84)
>>     at 
>> org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:181)
>>     at 
>> org.quartz.impl.jdbcjobstore.JobStoreSupport.closeConnection(JobStoreSupport.java:3563)
>>     at 
>> org.quartz.impl.jdbcjobstore.JobStoreSupport.cleanupConnection(JobStoreSupport.java:3539)
>>     at 
>> org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3761)
>>     at 
>> org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2729)
>>     at 
>> org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:266)
>> 2011-05-17 14:21:37,610 ERROR QuartzScheduler_QuartzSchedulerThread 
>> org.quartz.core.QuartzSchedulerThread - quartzSchedulerThreadLoop: 
>> RuntimeException null
>> java.lang.reflect.UndeclaredThrowableException
>>     at $Proxy8.rollback(Unknown Source)
>>     at 
>> org.quartz.impl.jdbcjobstore.JobStoreSupport.rollbackConnection(JobStoreSupport.java:3588)
>>     at 
>> org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3751)
>>     at 
>> org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2729)
>>     at 
>> org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:266)
>>
>> El 17/05/11 14:05, Miguel Carro Pellicer escribió:
>>> Works perfect with Sakai 2.8.
>>>
>>> It has I18N problems but i contributed a patch.
>>>
>>> You need to configure some properties to make the importation work.
>>>
>>>
>>>
>>> El 17/05/2011 13:13, Angel Nueda Lozano escribió:
>>>> Has anyone tried melete 2.8.2, together with sakai 2.8?
>>>> We are going to migrate to sakai 2.8 now and we're not sure whether to
>>>> use melete 2.7.2, or spend the new melete 2.8.2.
>>>>
>>>> In the tests we are doing we have had some problems. When we import
>>>> content modules an exception is giving us of type java.sql.SQLException:
>>>> Already closed.
>>>>
>>>> Thanks,
>>>> Angel
>>>> _______________________________________________
>>>> sakai-dev mailing list
>>>> sakai-dev at collab.sakaiproject.org
>>>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>>>
>>>> TO UNSUBSCRIBE: send email tosakai-dev-unsubscribe at collab.sakaiproject.org  with a subject of "unsubscribe"
>>>>
>>>
>>> -- 
>>>
>>> cid:image001.jpg at 01C9F98A.71C74E60<http://www.samoo.es/>
>>>
>>> <http://www.samoo.es/>
>>>
>>> *Miguel Carro Pellicer*
>>>
>>> *Technical Manager - Director técnico*
>>>
>>> miguel.carro at samoo.es <mailto:miguel.carro at samoo.es>
>>>
>>> +34 - 96 393 69 15
>>>
>>> www.samoo.es <http://www.samoo.es>
>>>
>>> Este  correo  y  sus archivos asociados son privados y 
>>> confidenciales y va dirigido  exclusivamente  a su destinatario. Si 
>>> recibe este correo sin ser el  destinatario del mismo, le rogamos 
>>> proceda a su eliminación y lo ponga en  conocimiento del emisor. La 
>>> difusión por cualquier medio del contenido de  este  correo podría 
>>> ser sancionada conforme a lo previsto en las leyes españolas, Ley 
>>> Orgánica 15/1999 de Protección de Datos de Carácter Personal.  No  
>>> se autoriza la utilización con fines comerciales o para su 
>>> incorporación a ficheros automatizados de las direcciones del emisor 
>>> o del destinatario."
>>>
>>> This mail and its attached files are confidential and are only and 
>>> exclusively intended to their addressee. In case you may receive 
>>> this mail not being its addressee, we beg you to let us know the 
>>> error by reply and to proceed to destroy it. The circulation by any 
>>> mean of this mail could be penalised in accordance with the Spanish 
>>> legislation. Is not allowed the use of both, the transmitter and the 
>>> addressee's, address with a commercial aim, or in order to be 
>>> incorporated to automated data process or to any kind of files.
>>>
>>> P Antes de imprimir este correo electrónico piense bien si es 
>>> necesario hacerlo. El medioambiente es cosa de todos.
>>>
>
> -- 
>
> cid:image001.jpg at 01C9F98A.71C74E60<http://www.samoo.es/>
>
> <http://www.samoo.es/>
>
> *Miguel Carro Pellicer*
>
> *Technical Manager - Director técnico*
>
> miguel.carro at samoo.es <mailto:miguel.carro at samoo.es>
>
> +34 - 96 393 69 15
>
> www.samoo.es <http://www.samoo.es>
>
> Este  correo  y  sus archivos asociados son privados y confidenciales 
> y va dirigido  exclusivamente  a su destinatario. Si recibe este 
> correo sin ser el  destinatario del mismo, le rogamos proceda a su 
> eliminación y lo ponga en  conocimiento del emisor. La difusión por 
> cualquier medio del contenido de  este  correo podría ser sancionada 
> conforme a lo previsto en las leyes españolas, Ley Orgánica 15/1999 de 
> Protección de Datos de Carácter Personal.  No  se autoriza la 
> utilización con fines comerciales o para su incorporación a ficheros 
> automatizados de las direcciones del emisor o del destinatario."
>
> This mail and its attached files are confidential and are only and 
> exclusively intended to their addressee. In case you may receive this 
> mail not being its addressee, we beg you to let us know the error by 
> reply and to proceed to destroy it. The circulation by any mean of 
> this mail could be penalised in accordance with the Spanish 
> legislation. Is not allowed the use of both, the transmitter and the 
> addressee's, address with a commercial aim, or in order to be 
> incorporated to automated data process or to any kind of files.
>
> P Antes de imprimir este correo electrónico piense bien si es 
> necesario hacerlo. El medioambiente es cosa de todos.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110517/2ee74c49/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 3022 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110517/2ee74c49/attachment.jpe 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 3022 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110517/2ee74c49/attachment-0001.jpe

More information about the sakai-dev mailing list