1 2 Previous Next 19 Replies Latest reply on Oct 30, 2003 4:25 PM by julien1

    BB issue

    superdave591

      Just installed a new nukes installation to test the bulletin board module. I wanted to get an idea of what customization and things I need to do to the BB before I start migrating my actual site to this BB. Anyway I started a seperate JBOSS using different ports, created a new mysql database setup my datasources and got the snapshot downloaded compiled, and installed. Nukes works fine, and the BB works but you cant read any posts. The following error is thrown to the jboss console whenver you try to display a post.



      15:17:53,126 ERROR [Page] Module bb raised a runtime exception when invoking operation viewtopic
      java.lang.NullPointerException
      at java.util.Calendar.setTime(Calendar.java:902)
      at java.text.SimpleDateFormat.format(SimpleDateFormat.java:782)
      at java.text.SimpleDateFormat.format(SimpleDateFormat.java:775)
      at java.text.DateFormat.format(DateFormat.java:314)
      at org.jboss.nukes.addons.modules.bb.theme.BBTheme.formatDate(BBTheme.java:317)
      at org.jboss.nukes.addons.modules.bb.BBModule._viewtopic(BBModule.java:2564)
      at org.jboss.nukes.addons.modules.bb.BBModule.viewtopic(BBModule.java:1956)
      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.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.interceptor.ObjectReferenceInterceptor.invoke(ObjectReferenceInterceptor.java:59)
      at org.jboss.mx.interceptor.MBeanAttributeInterceptor.invoke(MBeanAttributeInterceptor.java:43)
      at org.jboss.mx.interceptor.PersistenceInterceptor2.invoke(PersistenceInterceptor2.java:93)
      at org.jboss.nukes.mx.LifeCycleInterceptor.invoke(LifeCycleInterceptor.java:93)
      at org.jboss.mx.server.MBeanInvoker.invoke(MBeanInvoker.java:76)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
      at org.jboss.nukes.html.Page.process(Page.java:258)
      at org.jboss.nukes.core.modules.core.CoreModule.process(CoreModule.java:1188)
      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.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.interceptor.ObjectReferenceInterceptor.invoke(ObjectReferenceInterceptor.java:59)
      at org.jboss.mx.interceptor.MBeanAttributeInterceptor.invoke(MBeanAttributeInterceptor.java:43)
      at org.jboss.mx.interceptor.PersistenceInterceptor2.invoke(PersistenceInterceptor2.java:93)
      at org.jboss.nukes.mx.LifeCycleInterceptor.invoke(LifeCycleInterceptor.java:93)
      at org.jboss.mx.server.MBeanInvoker.invoke(MBeanInvoker.java:76)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
      at org.jboss.nukes.servlet.NukeServlet.handleRoot(NukeServlet.java:170)
      at org.jboss.nukes.servlet.NukeServlet.doGet(NukeServlet.java:143)
      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.jboss.nukes.servlet.TransactionFilter.doFilter(TransactionFilter.java:95)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      at org.jboss.nukes.servlet.FileUploadFilter.doFilter(FileUploadFilter.java:64)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      at org.jboss.nukes.servlet.CompressFilter.doFilter(CompressFilter.java:113)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      at org.jboss.nukes.servlet.DatabasePollerFilter.doFilter(DatabasePollerFilter.java:88)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
      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.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
      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.StandardContext.invoke(StandardContext.java:2417)
      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.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
      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:193)
      at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:309)
      at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:387)
      at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:673)
      at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:615)
      at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:786)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:666)
      at java.lang.Thread.run(Thread.java:534)



      Any Idea? Im going to keep playing around and see if I cant fix it, otherwise I will just pull a new snapshot tomorrow and see if things change.

      David

        • 1. Re: BB issue

          this is weird, that may come from a date field null in the database.

          julien

          • 2. Re: BB issue
            superdave591

            I just pulled from CVS. I dropped the database and recreated. Pulled in the setup.ddl for both nukes and bb module and I am in the process of deploying again.. I will update if CVS tree works any better.

            • 3. Re: BB issue
              superdave591

              Yup,
              CVS Checkout as of about 15 min ago does the same exact thing with a fresh database. I'll go take a crack at examining the databases and see if I cant figure out whats being looked and why its not what its expected to be.

              • 4. Re: BB issue

                one thing you can do is to trace the code when it is running (eclipse does it well). you can setup jboss in debug mode by modifying the run.bat, uncomment the debug line :

                set JAVA_OPTS=-classic -Xdebug -Xnoagent -Djava.compiler=NONE -Xrunjdwp:transport=dt_socket,address=8787,server=y,suspend=n %JAVA_OPTS%
                and change suspend=y -> suspend=n

                then start jboss (a little bit slower) then in the IDE you should be able to remote connect to jboss and set break points. Then when you access it you can look step by step in the run.

                I am using intellij IDEA and it is easy to do.

                • 5. Re: BB issue
                  superdave591

                  I will try that when I get some time in a IDE friendly environment. Right now I am working from remote over (slowish) link. So only real option is to do it the old fashioned way. If I have time later tonight I will look at running through eclipse. Can that be done to a remote Jboss instance? I have eclipse on my windows machine but typically I run all my web stuff on a Sparc that is remote. I can always put eclipse on the sparc to if you cant connect remotely.

                  • 6. Re: BB issue

                    yes it is possible, you give the machine IP you want to connect to

                    • 7. Re: BB issue
                      superdave591

                      I have dug up some more info. It appears to crash because the pn_user)regdate is null for admin. Which I believed was your suspicion.

                      mysql> select pn_user_regdate from nuke_users;
                      +---------------------+
                      | pn_user_regdate |
                      +---------------------+
                      | 0000-00-00 00:00:00 |
                      +---------------------+
                      1 row in set (0.01 sec)


                      My next thought was I will simply register a new user myself and all should be good, however it blew up making a new user as well.

                      16:38:16,315 ERROR [UserEJB] Could not create entity
                      java.sql.SQLException: General error, message from server: "Column 'pn_prev_last_visit' cannot be null"
                      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1825)
                      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1020)
                      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1109)
                      at com.mysql.jdbc.Connection.execSQL(Connection.java:2030)
                      at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1750)
                      at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1596)
                      at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:324)
                      at org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCMySQLCreateCommand.executeInsert(JDBCMySQLCreateCommand.java:66)
                      at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.performInsert(JDBCAbstractCreateCommand.java:287)
                      at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.execute(JDBCAbstractCreateCommand.java:138)
                      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:557)
                      at org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:208)
                      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:269)
                      at org.jboss.ejb.EntityContainer.createLocalHome(EntityContainer.java:584)
                      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.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1046)
                      at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
                      at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:197)
                      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:214)
                      at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
                      at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:89)
                      at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61)
                      at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28)
                      at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:88)
                      at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:267)
                      at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:98)
                      at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:92)
                      at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)
                      at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93)
                      at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:483)
                      at org.jboss.ejb.Container.invoke(Container.java:720)
                      at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:293)
                      at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110)
                      at $Proxy87.create(Unknown Source)
                      at org.jboss.nukes.core.modules.user.UserModule.finishnewuser(UserModule.java:335)
                      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.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
                      at org.jboss.mx.interceptor.ObjectReferenceInterceptor.invoke(ObjectReferenceInterceptor.java:59)
                      at org.jboss.mx.interceptor.MBeanAttributeInterceptor.invoke(MBeanAttributeInterceptor.java:43)
                      at org.jboss.mx.interceptor.PersistenceInterceptor2.invoke(PersistenceInterceptor2.java:93)
                      at org.jboss.nukes.mx.LifeCycleInterceptor.invoke(LifeCycleInterceptor.java:93)
                      at org.jboss.mx.server.MBeanInvoker.invoke(MBeanInvoker.java:76)
                      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
                      at org.jboss.nukes.html.Page.process(Page.java:258)
                      at org.jboss.nukes.core.modules.core.CoreModule.process(CoreModule.java:1188)
                      at sun.reflect.GeneratedMethodAccessor84.invoke(Unknown Source)
                      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                      at java.lang.reflect.Method.invoke(Method.java:324)
                      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
                      at org.jboss.mx.interceptor.ObjectReferenceInterceptor.invoke(ObjectReferenceInterceptor.java:59)
                      at org.jboss.mx.interceptor.MBeanAttributeInterceptor.invoke(MBeanAttributeInterceptor.java:43)
                      at org.jboss.mx.interceptor.PersistenceInterceptor2.invoke(PersistenceInterceptor2.java:93)
                      at org.jboss.nukes.mx.LifeCycleInterceptor.invoke(LifeCycleInterceptor.java:93)
                      at org.jboss.mx.server.MBeanInvoker.invoke(MBeanInvoker.java:76)
                      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
                      at org.jboss.nukes.servlet.NukeServlet.handleRoot(NukeServlet.java:170)
                      at org.jboss.nukes.servlet.NukeServlet.doGet(NukeServlet.java:143)
                      at org.jboss.nukes.servlet.NukeServlet.doPost(NukeServlet.java:120)
                      at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
                      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.jboss.nukes.servlet.TransactionFilter.doFilter(TransactionFilter.java:95)
                      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
                      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
                      at org.jboss.nukes.servlet.FileUploadFilter.doFilter(FileUploadFilter.java:64)
                      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
                      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
                      at org.jboss.nukes.servlet.CompressFilter.doFilter(CompressFilter.java:113)
                      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
                      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
                      at org.jboss.nukes.servlet.DatabasePollerFilter.doFilter(DatabasePollerFilter.java:88)
                      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
                      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.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
                      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
                      at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
                      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
                      at org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
                      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.StandardContext.invoke(StandardContext.java:2417)
                      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.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65)
                      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
                      at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
                      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:193)
                      at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:309)
                      at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:387)
                      at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:673)
                      at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:615)
                      at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:786)
                      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:666)
                      at java.lang.Thread.run(Thread.java:534)
                      16:38:16,586 ERROR [user] Cannot create user with userName=danderso
                      javax.ejb.CreateException: Could not create entity:java.sql.SQLException: General error, message from server: "Column 'pn_prev_last_visit' cannot be null"
                      at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.performInsert(JDBCAbstractCreateCommand.java:303)
                      at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.execute(JDBCAbstractCreateCommand.java:138)
                      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:557)
                      at org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:208)
                      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:269)
                      at org.jboss.ejb.EntityContainer.createLocalHome(EntityContainer.java:584)
                      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.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1046)
                      at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
                      at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:197)
                      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:214)
                      at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
                      at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:89)
                      at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61)
                      at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28)
                      at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:88)
                      at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:267)
                      at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:98)
                      at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:92)
                      at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)
                      at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93)
                      at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:483)
                      at org.jboss.ejb.Container.invoke(Container.java:720)
                      at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:293)
                      at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110)
                      at $Proxy87.create(Unknown Source)
                      at org.jboss.nukes.core.modules.user.UserModule.finishnewuser(UserModule.java:335)
                      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.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
                      at org.jboss.mx.interceptor.ObjectReferenceInterceptor.invoke(ObjectReferenceInterceptor.java:59)
                      at org.jboss.mx.interceptor.MBeanAttributeInterceptor.invoke(MBeanAttributeInterceptor.java:43)
                      at org.jboss.mx.interceptor.PersistenceInterceptor2.invoke(PersistenceInterceptor2.java:93)
                      at org.jboss.nukes.mx.LifeCycleInterceptor.invoke(LifeCycleInterceptor.java:93)
                      at org.jboss.mx.server.MBeanInvoker.invoke(MBeanInvoker.java:76)
                      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
                      at org.jboss.nukes.html.Page.process(Page.java:258)
                      at org.jboss.nukes.core.modules.core.CoreModule.process(CoreModule.java:1188)
                      at sun.reflect.GeneratedMethodAccessor84.invoke(Unknown Source)
                      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                      at java.lang.reflect.Method.invoke(Method.java:324)
                      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
                      at org.jboss.mx.interceptor.ObjectReferenceInterceptor.invoke(ObjectReferenceInterceptor.java:59)
                      at org.jboss.mx.interceptor.MBeanAttributeInterceptor.invoke(MBeanAttributeInterceptor.java:43)
                      at org.jboss.mx.interceptor.PersistenceInterceptor2.invoke(PersistenceInterceptor2.java:93)
                      at org.jboss.nukes.mx.LifeCycleInterceptor.invoke(LifeCycleInterceptor.java:93)
                      at org.jboss.mx.server.MBeanInvoker.invoke(MBeanInvoker.java:76)
                      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
                      at org.jboss.nukes.servlet.NukeServlet.handleRoot(NukeServlet.java:170)
                      at org.jboss.nukes.servlet.NukeServlet.doGet(NukeServlet.java:143)
                      at org.jboss.nukes.servlet.NukeServlet.doPost(NukeServlet.java:120)
                      at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
                      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.jboss.nukes.servlet.TransactionFilter.doFilter(TransactionFilter.java:95)
                      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
                      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
                      at org.jboss.nukes.servlet.FileUploadFilter.doFilter(FileUploadFilter.java:64)
                      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
                      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
                      at org.jboss.nukes.servlet.CompressFilter.doFilter(CompressFilter.java:113)
                      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
                      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
                      at org.jboss.nukes.servlet.DatabasePollerFilter.doFilter(DatabasePollerFilter.java:88)
                      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
                      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.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
                      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
                      at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
                      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
                      at org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
                      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.StandardContext.invoke(StandardContext.java:2417)
                      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.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65)
                      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
                      at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
                      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:193)
                      at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:309)
                      at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:387)
                      at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:673)
                      at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:615)
                      at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:786)
                      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:666)
                      at java.lang.Thread.run(Thread.java:534)


                      I will try out eclipse IDE stuff later tonight, or this weekend. Between school and work I have limited time for trying out new things, so I tend to stick to whatever gets results quick. But I will give the IDE things a try.

                      • 8. Re: BB issue

                        in that case, juste do for instance :
                        update nuke_users set pn_user_regdate='2003-10-10 00:00:00'
                        and see if it works

                        • 9. Re: BB issue

                          actually seing your stack trace, it comes from the last visit dates.
                          there are two fields :

                          pn_prev_last_visit_date and pn_last_visit_date.

                          just do a UPDATE nuke_users SET pn_last_visit_date='2003-10-10 00:00:00' for both of them.

                          julien

                          • 10. Re: BB issue
                            superdave591

                            Yep that works. I was looking up syntax while you responded. So bb is okay, just a bad database entry. However it looks like user registration is a bit non-functional though too. I havent dont any CMP work at all but I am going to take a look at it and see if I cant figure it out anyway.

                            Thanks for you help and patience working throught things with me.

                            • 11. Re: BB issue
                              superdave591

                              The last stack trace was from new user registration, and it doesnt appear to actually add it. Looks like mysql is whacking it on a not null contraint during user registration for those two fields.


                              • 12. Re: BB issue

                                maybe it's me that forgot to add a line in the UserEJB :

                                I added : setPreviousLastVisitDate(now);

                                under the line setLastVisitDate(now); in the org.jboss.nukes.core.ejb.UserEJB ejbCreate() method, see if it improve registration.

                                julien

                                • 13. Re: BB issue
                                  superdave591

                                  Still having a bit of trouble with registration.. Actually I noticed this during setup.ddl also, with the user login but didnt think much of it at the time...

                                  Here is the stack trace. I think it is another database related issue, but my SQL is pretty weak....(And I just got back from Wensday after school trip to the bar, so Its probably best that I dont start attempting to debug it too much.) I'll post the stack trace in case you got any ideas...


                                  at org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
                                  at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
                                  at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
                                  at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
                                  at org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
                                  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.StandardContext.invoke(StandardContext.java:2417)
                                  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.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65)
                                  at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
                                  at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
                                  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:193)
                                  at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:309)
                                  at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:387)
                                  at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:673)
                                  at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:615)
                                  at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:786)
                                  at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:666)
                                  at java.lang.Thread.run(Thread.java:534)

                                  • 14. Re: BB issue
                                    superdave591

                                    Well looks like my buffer got lost... I'll deal with it tomorrow.

                                    1 2 Previous Next