[Coefficient-users] Re: Coefficient

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

The patch you sent me allow the loading to continue. I now only have one 
exception left and I get the first
configuration page in my browser.

Windows is not the problem because I installed a version on Solaris which 
had exactly the same issue.

Thanks.

ps : I will be on holiday next week but I will be happy to help you 
correcting this issue when I am back.

3455 [Thread-5] INFO hbm2ddl.DatabaseMetadata  - table not found: 
COEFFICIENT_PROJECT
11817 [Thread-5] WARN util.JDBCExceptionReporter  - SQL Error: 0, 
SQLState: 08003
11817 [Thread-5] ERROR util.JDBCExceptionReporter  - No operations allowed 
after connection closed.
11827 [Thread-5] WARN util.JDBCExceptionReporter  - SQL Error: 0, 
SQLState: 08003
11827 [Thread-5] ERROR util.JDBCExceptionReporter  - No operations allowed 
after connection closed.
net.sf.hibernate.exception.GenericJDBCException: Could not execute query
        at 
net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90)
        at 
net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:79)
        at 
net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:30)
        at 
net.sf.hibernate.impl.SessionImpl.convert(SessionImpl.java:4110)
        at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1556)
        at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1530)
        at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1522)
        at 
net.sf.hibernate.util.HibernateUtil.find(HibernateUtil.java:354)
        at za.org.coefficient.util.common.Roles.getAllRoles(Roles.java:49)
        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:324)
        at 
org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:252)
        at 
org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:198)
        at 
za.org.coefficient.invokers.base.BaseInvoker.invokeMethodOnService(BaseInvoker.java:138)
        at 
za.org.coefficient.util.ejb.DataLoaderUtil.createDefaultRolesIfNeeded(DataLoaderUtil.java:162)
        at 
za.org.coefficient.util.ejb.DataLoaderUtil.initializeDataIfNeeded(DataLoaderUtil.java:140)
        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:324)
        at 
net.sf.hibernate.util.HibernateUtil.invokeDataLoader(HibernateUtil.java:908)
        at 
net.sf.hibernate.util.HibernateUtil.<clinit>(HibernateUtil.java:103)
        at 
za.org.coefficient.modules.configuration.Configuration.getConfiguration(Configuration.java:138)
        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:324)
        at 
org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:252)
        at 
org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:198)
        at 
za.org.coefficient.invokers.base.BaseInvoker.invokeMethodOnModule(BaseInvoker.java:114)
        at 
za.org.coefficient.core.BaseConfigurationBackedConstants.init(BaseConfigurationBackedConstants.java:45)
        at za.org.coefficient.core.Constants.init(Constants.java:59)
        at za.org.coefficient.core.Constants.<clinit>(Constants.java:55)
        at 
za.org.coefficient.core.CoefficientWebContext.<init>(CoefficientWebContext.java:110)
        at 
za.org.coefficient.servlet.CoefficientServlet.execute(CoefficientServlet.java:151)
        at 
za.org.coefficient.servlet.CoefficientServlet.doGet(CoefficientServlet.java:118)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
        at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
        at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
        at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at 
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
        at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at 
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at 
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
        at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
        at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
        at 
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
        at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
        at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
        at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
        at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at 
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
        at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
        at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at 
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at 
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
        at 
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
        at 
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
        at 
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
        at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
        at java.lang.Thread.run(Thread.java:536)
Caused by: java.sql.SQLException: No operations allowed after connection 
closed.
        at com.mysql.jdbc.Connection.checkClosed(Connection.java:2647)
        at 
com.mysql.jdbc.Connection.prepareStatement(Connection.java:1300)
        at 
com.mysql.jdbc.Connection.prepareStatement(Connection.java:1281)
        at 
net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:260)
        at 
net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:235)
        at 
net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:66)
        at 
net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:783)
        at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269)
        at 
net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:137)
        at net.sf.hibernate.loader.Loader.doList(Loader.java:1062)
        at net.sf.hibernate.loader.Loader.list(Loader.java:1053)
        at 
net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
        at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1553)
        ... 64 more
12328 [Thread-5] INFO configuration.Configuration  - at: 
Configuration.java:147 | operation: save | on: 
za.org.coefficient.core.CoefficientConfigurati
on | toString: za.org.coefficient.core.CoefficientConfiguration@167acf2
12348 [Thread-5] INFO configuration.Configuration  - at: 
Configuration.java:154 | operation: update | on: 
za.org.coefficient.core.CoefficientConfigura
tion | object id: 1 | toString: 
za.org.coefficient.core.CoefficientConfiguration@167acf2
12909 [Finalizer] WARN impl.SessionImpl  - finalizing unclosed session 
with closed connection

Thomas Fogwill <tfo...@us...>
27/01/2005 23:27
Please respond to tfogwill

        To:     Sebastien Lemeunier/PH/Novartis@PH
        cc:     coefficient-users <coe...@li...>
        Subject:        Re: Coefficient
        Category: 

On Thu, 2005-01-27 at 16:51 +0100, sebastien wrote:
> It makes no difference. I still get the problem. 
> I also tried to upgrade the mysql-lib to same version than you without
> success. 

I'll be honest, I'm baffled! What's probably happening is that the
connection is still being closed when the hibernate session gets closed,
and that this is freaking out the dataloader.

I'd like to try something else: attached is a patched DataLoader class
file. This one checks whether the roles list is null before trying to
load the data. This prevents the NullPointerException, and hopefully
will allow the data loading process to continue. Please test it by
replacing the class file you currently have (i.e.
za.org.coefficient.util.ejb.DataLoader).

Although I'd still like to get to the bottom of the problem and find a
solution, I (for the meanwhile) attach a dump of my database (newly
created by coefficient). If the abovementioned patch still doesn't work,
the dump should allow you to get the system running, so that you can at
least look at it (while we try to figure out how to fix your problem).

> INFO: Jk running ID=0 time=0/30  config=C:\Program Files\Apache Group
> \Tomcat 4.1\bin\..\conf\jk2.properties 

I guess this means you're running Windows. Wonder whether there is
anything MySQL does differently on Windows, that could be causing the
problem?

I'm currently on study leave, but once I'm back at the office, I'll give
it a shot on Windows box, to see whether it also happens there.

Let me know how this goes.

Cheers
T

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
MailScanner thanks transtec Computers for their support.