Forum LAMS for Tech-Heads - General Forum: Re: Changes to how we use the FCKEditor in 2.0

By: Fiona Malikoff

[ Reply | Forward ]

Ken,

Try renaming the one in:

lams_tool_behaviourComposer\src\java\org\lamsfoundation\lams\tool\behaviourComposer

Everything in the build directory is wiped when you do build-jar, build-war, deploy-war, deploy-tool, etc. So your nicely renamed file in the build directory will have been deleted and the one from the src directory would have been copied to build and then deployed.

Fiona

Posted by Fiona Malikoff

By: Ken Kahn

[ Reply | Forward ]

Hi. Thanks.

Turns out I did rename both the src and build one (but good to know that the build one didn't help at all).

So I tried to rebuild all of LAMS and this time I got the "opposite error" (see below).

So I renamed the file back to what it was. And I was able to sucessfully launch JBOSS. But after I dragged out a BehaviourComposer tool instance while authoring, I double clicked on it and got the following error. Was this caused by RenameTool finding nb is some other context?

Best,

-ken

Sorry, there as been an error.
There is a problem processing this request. Close the browser window and try again. If the problem persists please contact your system administrator or the technical forums on http://lamscommunity.org/.

org.lamsfoundation.lams.tool.behaviourComposer.BehaviourComposerApplicationException: An exception has occured when trying to retrieve behaviourComposer content: Hibernate operation: could not execute query; bad SQL grammar [select behaviourc0_.uid as uid, behaviourc0_.content as content391_, behaviourc0_.creator_user_id as creator3_391_, behaviourc0_.date_created as date4_391_, behaviourc0_.date_updated as date5_391_, behaviourc0_.define_later as define6_391_, behaviourc0_.force_offline as force7_391_, behaviourc0_.content_in_use as content8_391_, behaviourc0_.behaviourComposer_content_id as behaviou9_391_, behaviourc0_.offline_instructions as offline10_391_, behaviourc0_.online_instructions as online11_391_, behaviourc0_.title as title391_ from tl_kkbc10_content behaviourc0_ where behaviourc0_.behaviourComposer_content_id=?]; nested exception is java.sql.SQLException: Unknown column 'behaviourc0_.uid' in 'field list'
Hide detail
org.lamsfoundation.lams.tool.behaviourComposer.BehaviourComposerApplicationException: An exception has occured when trying to retrieve behaviourComposer content: Hibernate operation: could not execute query; bad SQL grammar [select behaviourc0_.uid as uid, behaviourc0_.content as content391_, behaviourc0_.creator_user_id as creator3_391_, behaviourc0_.date_created as date4_391_, behaviourc0_.date_updated as date5_391_, behaviourc0_.define_later as define6_391_, behaviourc0_.force_offline as force7_391_, behaviourc0_.content_in_use as content8_391_, behaviourc0_.behaviourComposer_content_id as behaviou9_391_, behaviourc0_.offline_instructions as offline10_391_, behaviourc0_.online_instructions as online11_391_, behaviourc0_.title as title391_ from tl_kkbc10_content behaviourc0_ where behaviourc0_.behaviourComposer_content_id=?]; nested exception is java.sql.SQLException: Unknown column 'behaviourc0_.uid' in 'field list' at org.lamsfoundation.lams.tool.behaviourComposer.service.BehaviourComposerServicePOJO.retrieveBehaviourComposer(BehaviourComposerServicePOJO.java:120) 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:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176) at $Proxy108.retrieveBehaviourComposer(Unknown Source) at org.lamsfoundation.lams.tool.behaviourComposer.web.BehaviourComposerAuthoringAction.contentExists(BehaviourComposerAuthoringAction.java:220) at org.lamsfoundation.lams.tool.behaviourComposer.web.BehaviourComposerAuthoringAction.unspecified(BehaviourComposerAuthoringAction.java:142) at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:256) at org.apache.struts.actions.LookupDispatchAction.execute(LookupDispatchAction.java:160) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.lamsfoundation.lams.web.filter.LocaleFilter.doFilterInternal(LocaleFilter.java:130) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.lamsfoundation.lams.web.session.SystemSessionFilter.doFilter(SystemSessionFilter.java:64) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:392) at org.apache.catalina.valves.FastCommonAccessLogValve.invoke(FastCommonAccessLogValve.java:481) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112) at java.lang.Thread.run(Thread.java:595) Caused by: org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not execute query; bad SQL grammar [select behaviourc0_.uid as uid, behaviourc0_.content as content391_, behaviourc0_.creator_user_id as creator3_391_, behaviourc0_.date_created as date4_391_, behaviourc0_.date_updated as date5_391_, behaviourc0_.define_later as define6_391_, behaviourc0_.force_offline as force7_391_, behaviourc0_.content_in_use as content8_391_, behaviourc0_.behaviourComposer_content_id as behaviou9_391_, behaviourc0_.offline_instructions as offline10_391_, behaviourc0_.online_instructions as online11_391_, behaviourc0_.title as title391_ from tl_kkbc10_content behaviourc0_ where behaviourc0_.behaviourComposer_content_id=?]; nested exception is java.sql.SQLException: Unknown column 'behaviourc0_.uid' in 'field list' at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:224) at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:411) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:371) at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:844) at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:840) at org.lamsfoundation.lams.tool.behaviourComposer.dao.hibernate.BehaviourComposerContentDAO.findBehaviourComposerContentById(BehaviourComposerContentDAO.java:65) at org.lamsfoundation.lams.tool.behaviourComposer.service.BehaviourComposerServicePOJO.retrieveBehaviourComposer(BehaviourComposerServicePOJO.java:115) ... 55 more Caused by: java.sql.SQLException: Unknown column 'behaviourc0_.uid' in 'field list' at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2994) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:296) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:118) at org.hibernate.loader.Loader.getResultSet(Loader.java:1237) at org.hibernate.loader.Loader.doQuery(Loader.java:374) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:210) at org.hibernate.loader.Loader.doList(Loader.java:1561) at org.hibernate.loader.Loader.list(Loader.java:1544) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:830) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74) at org.springframework.orm.hibernate3.HibernateTemplate$31.doInHibernate(HibernateTemplate.java:853) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366) ... 59 more


JBOSS log (problem fixed since but odd that this time it wants the other name for the XML file):

14:01:25,341 INFO  [org.springframework.beans.factory.xml.XmlBeanDefinitionReader] Loading XML bean definitions from class path resource [org/lamsfoundation/lams/tool/behaviourComposer/applicationContext.xml]
14:01:25,356 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanDefinitionStoreException: IOException parsing XML document from class path resource [org/lamsfoundation/lams/tool/behaviourComposer/applicationContext.xml]; nested exception is java.io.FileNotFoundException: class path resource [org/lamsfoundation/lams/tool/behaviourComposer/applicationContext.xml] cannot be opened because it does not exist
java.io.FileNotFoundException: class path resource [org/lamsfoundation/lams/tool/behaviourComposer/applicationContext.xml] cannot be opened because it does not exist
    at org.springframework.core.io.ClassPathResource.getInputStream(ClassPathResource.java:137)
    at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:167)
    at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:148)
    at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:129)
    at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:145)
    at org.springframework.web.context.support.XmlWebApplicationContext.loadBeanDefinitions(XmlWebApplicationContext.java:126)
    at org.springframework.web.context.support.XmlWebApplicationContext.loadBeanDefinitions(XmlWebApplicationContext.java:94)
    at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:89)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:262)
    at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:139)
    at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:252)
    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:190)
    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3669)
    at org.apache.catalina.core.StandardContext.start(StandardContext.java:4104)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
    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:585)
    at org.apache.commons.modeler.BaseModelMBean.invoke(BaseModelMBean.java:503)
    at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:150)
    at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
    at org.apache.catalina.core.StandardContext.init(StandardContext.java:5005)
    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:585)
    at org.apache.commons.modeler.BaseModelMBean.invoke(BaseModelMBean.java:503)
    at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:150)
    at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
    at org.jboss.web.tomcat.tc5.TomcatDeployer.performDeployInternal(TomcatDeployer.java:274)
    at org.jboss.web.tomcat.tc5.TomcatDeployer.performDeploy(TomcatDeployer.java:91)
    at org.jboss.web.AbstractWebDeployer.start(AbstractWebDeployer.java:357)
    at org.jboss.web.WebModule.startModule(WebModule.java:68)
    at org.jboss.web.WebModule.startService(WebModule.java:46)
    at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:272)
    at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:222)
    at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
    at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
    at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
    at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
    at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
    at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:897)
    at $Proxy0.start(Unknown Source)
    at org.jboss.system.ServiceController.start(ServiceController.java:418)
    at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
    at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
    at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
    at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
    at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
    at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
    at $Proxy28.start(Unknown Source)
    at org.jboss.web.AbstractWebContainer.start(AbstractWebContainer.java:394)
    at org.jboss.deployment.MainDeployer.start(MainDeployer.java:964)
    at org.jboss.deployment.MainDeployer.start(MainDeployer.java:956)
    at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:775)
    at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:738)
    at sun.reflect.GeneratedMethodAccessor49.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
    at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
    at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:121)
    at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
    at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
    at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
    at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
    at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
    at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
    at $Proxy8.deploy(Unknown Source)
    at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:325)
    at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:501)
    at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:204)
    at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:277)
    at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:272)
    at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:222)
    at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
    at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
    at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
    at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
    at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
    at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:897)
    at $Proxy0.start(Unknown Source)
    at org.jboss.system.ServiceController.start(ServiceController.java:418)
    at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
    at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
    at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
    at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
    at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
    at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
    at $Proxy4.start(Unknown Source)
    at org.jboss.deployment.SARDeployer.start(SARDeployer.java:273)
    at org.jboss.deployment.MainDeployer.start(MainDeployer.java:964)
    at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:775)
    at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:738)
    at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:722)
    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:585)
    at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
    at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
    at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:121)
    at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
    at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
    at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
    at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
    at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
    at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
    at $Proxy5.deploy(Unknown Source)
    at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:434)
    at org.jboss.system.server.ServerImpl.start(ServerImpl.java:315)
    at org.jboss.Main.boot(Main.java:195)
    at org.jboss.Main$1.run(Main.java:463)
    at java.lang.Thread.run(Thread.java:595)

Posted by Ken Kahn

By: Fiona Malikoff

[ Reply | Forward ]

Ken,

Sorry for not replying earlier but I only just saw this post just before dinner. I think my spam filter was filtering out your postings and I hadn't noticed - I found one in my spam list today.

Anyway, reading this error I suspect either the table names or the the column names in the tool's tables don't match the column names in the *.hbm.xml file. The table at fault is probably your main table.

I've run rename tool and I'll try deploying it and seeing if I can reproduce the error.

Fiona

Posted by Fiona Malikoff

By: Fiona Malikoff

[ Reply | Forward ]

Can't reproduce the problem I'm afraid. I've run the rename with the configuration you gave and I did deploy-tool, ran JBOSS, logged in and opened up the authoring screen without a problem.

Can you attach a zip of your source files?

Fiona

Posted by Fiona Malikoff

By: Ken Kahn

[ Reply | Forward ]

Here is is.

Thanks.

-ken

Posted by Ken Kahn

By: Fiona Malikoff

[ Reply | Forward ]

I've got bad news for you Ken.

You are trying to work with tables based on the submit tool and code based on the noticeboard tool. Unfortunately, the column names across our tools aren't consistent enough to do that. So you have to pick one and stay with it for the data side.

The file db/sql/create_lams_tool_behaviourComposer.sql contains the tables for your tool. It defines tl_kkbc10_content as:

create table tl_kkbc10_content (
  content_id bigint not null,
  title varchar(64) not null,
  instruction text,
  define_later bit not null,
  run_offline bit not null,
  offline_instruction text,
  online_instruction text,
  content_in_use bit,
  lock_on_finished bit,
  primary key (content_id)
);

Now looking at BehaviourComposerContent.hbm.xml (which is the file that maps the tl_kkbc10_content table to a BehaviourComposerContent object, it expects the table to be something like

create table tl_kkbc10_content (
    uid bigint not null,
    content text,
    creator_user_id bigint,
    date_created date,
    date_updated date,
    define_later bit
    force_offline bit
    content_in_use bit
    behaviourComposer_content_id bigint not null,
    offline_instructions text,
    online_instructions text,
    title text,
    primary key (uid)
);


I say like as I've just quickly hacked that up manually - it may not be valid code. My sql syntax tends to not be brillant 9:49pm at night!

Trying to take your existing database and align it with the code manually would take some time. I think it would be better to either use the database tables created from the rename of the noticeboard tool, or you would have to go back to the submit codebase again.

Is it possible for you to use the tables that were generated from the copy of the noticeboard tool. Only the create_lams_tool_behaviourComposer.sql and drop_lams_tool_behaviourComposer.sql shuold need to be replaced - the rest of the sql scripts are updated to other tables rather than defining the tool's tables.

I've attached a version of the two files, taken from what the rename tool produced and updated so the default tool content has your title and text. I haven't tested the code since I updated the title and text but hopefully I haven't typed anything wrong.

I could run the rename tool over submit again and send you that with the jsp's fixed up for the submit text replacement problems in the jsp files. But that won't be till tomorrow - I can't see me getting it done tonight. And then you will have lost another day.

Fiona

Posted by Fiona Malikoff

By: Ken Kahn

[ Reply | Forward ]

Hi. Thanks.

It seems to be working fine now!

The reason I had the inconsistent create_lams_tool_behaviourComposer.sql file is that I had a problem with it a couple weeks ago and you sent me an edited version that fixed the problem. So I stuck with it without noticing that it was tied to the old version. Replacing it with the version you attached worked fine.

Now the real really begins!

-ken

Posted by Ken Kahn