I FINALLY got some time to get back to playing with nukes. I'm running on Debian
linux with Postgresql. I installed yesterday's snapshot and had some minor issues
during install.
I'll let you know if I find any issues during actual testing. These were just
installation related.
Also, I found that for a few modules I had to run the setup.ddl files first
(adminmessages, poll). I had thought these were converted to be done via CMP, but
maybe I'm wrong about that.
Cheers,
gary.
Here's the first, I'm not sure about what actually was being done here, but the system
seems to operate so far:
------------------------------------------------------------------------
09:25:42,936 INFO [html] Start indexing
09:25:43,319 ERROR [DocumentIterator]
java.sql.SQLException: ERROR: Unable to identify an operator '=' for types 'boolean'
and 'integer'
You will have to retype this query using an explicit cast
at org.postgresql.core.QueryExecutor.execute(Unknown Source)
at org.postgresql.Connection.ExecSQL(Unknown Source)
at org.postgresql.jdbc2.Statement.execute(Unknown Source)
at org.postgresql.jdbc2.Statement.executeQuery(Unknown Source)
at org.postgresql.jdbc2.PreparedStatement.executeQuery(Unknown Source)
at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:304)
at
org.jboss.nukes.core.modules.index.DocumentIterator.(DocumentIterator.java:52)
at org.jboss.nukes.core.modules.html.HtmlModule$5.(HtmlModule.java:1391)
at org.jboss.nukes.core.modules.html.HtmlModule.documents(HtmlModule.java:1381)
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.mx.util.JMXInvocationHandler.invoke(JMXInvocationHandler.java:177)
at $Proxy61.documents(Unknown Source)
at org.jboss.nukes.core.modules.index.Index$IndexingTask.run(Index.java:643)
at org.jboss.nukes.core.modules.index.Index$WriterTask.run(Index.java:538)
at
EDU.oswego.cs.dl.util.concurrent.QueuedExecutor$RunLoop.run(QueuedExecutor.java:88)
at java.lang.Thread.run(Thread.java:534)
09:25:43,358 INFO [html] Indexing finished, time elapsed : 0.0 sec
---------------------------------------------------------------------
This next one was fixed by re-running the query and replacing a 0 with FALSE for the
'prune_enable' field with boolean type. I'm not sure where this code is, but it
should be an easy fix
----------------------------------------------------------------------
09:44:13,888 WARN [ForumEJB] Issuing sql INSERT INTO phpbb_forums (forum_id, cat_id,
forum_name, forum_desc, forum_status,
forum_order,forum_posts, forum_topics, forum_last_post_id, prune_next, prune_enable,
auth_view, auth_read,auth_post, auth_reply, auth_edit, auth_delete, auth_sticky,
auth_announce, auth_vote,auth_pollcreate, auth_attachments) VALUES (0,0,'My
forum','This is a sample forum',0,10,0,0,NULL,NULL,0,0,0,1,1,1,1,3,3,3,3,0); failed:
java.sql.SQLException: ERROR: column "prune_enable" is of type 'boolean' but
expression is of type 'integer'
You will need to rewrite or cast the expression
09:44:13,891 ERROR [EntityContainer] Starting failed
org.jboss.deployment.DeploymentException: Error while issuing sql in
post-table-create; - nested throwable: (java.sql.SQLException: ERROR: column
"prune_enable" is of type 'boolean' but expression is of type 'integer'
You will need to rewrite or cast the expression
)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.issuePostCreateSQL(JDBCStartCommand.java:392)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:110)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:484)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:388)
at
org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:152)
at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:342)
at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
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.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
at
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976)
at $Proxy14.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:394)
at sun.reflect.GeneratedMethodAccessor6.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)
----------------------------------------------------------
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3843644#3843644
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3843644
-------------------------------------------------------
This SF.Net email is sponsored by OSTG. Have you noticed the changes on
Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now,
one more big change to announce. We are now OSTG- Open Source Technology
Group. Come see the changes on the new OSTG site. www.ostg.com
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
