XWiki, MySQL and Sun Java System AppServer 7

Hi folks, I am trying to install xwiki 0.9.84 on SJSAS 7 ( Sun Java System Application Server 7), and MySQL 4.1.12 (linux, mandriva 2006) . Sorry, I cannot install tomcat here. Be sure, if this works I will write a howto and edit the install xwiki install page for SJSAS 7. 1) deployed .war file on /xwiki context root: fine 2) configured hibernate.cfg.xml to use jdbc/mysql datasource 2.1) mysql datasource: com.mysql.jdbc.jdbc2.optional.MysqlDataSource 2.2) url: jdbc:mysql://localhost:3306/xwiki?autoReconnect=true 2.3) well tested with a db ping application (did some queries) 2.4) hibernate.cfg.xml <property name="show_sql">false</property> <property name="use_outer_join">true</property> <property name="hibernate.connection.datasource">jdbc/xwiki</property> <property name="statement_cache.size">50</property> <property name="dialect">org.hibernate.dialect.MySQLDialect</property> Please, any ideas is welcome. server log says (sorry for the lenghty message): WARN service-j2ee-2 RequestUtils:createActionForm:177 - No FormBeanConfig found under 'view' WARN service-j2ee-2 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers Environment:<clinit>:501 - could not copy system properties, system properties will be ignored WARN service-j2ee-2 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers Configurator:configure:126 - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/opt/sunappserv/domains/domain1/wiki/applications/j2ee-modules/xwiki-0.9.840_1/WEB-INF/lib/ehcache-1.1.jar!/ehcache-failsafe.xml ERROR service-j2ee-2 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers XWikiHibernateStore:updateSchema:177 - Schema update for wiki xwiki DEBUG service-j2ee-2 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers XWikiHibernateStore:beginTransaction:306 - Trying to get session from pool DEBUG service-j2ee-2 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers XWikiHibernateStore:beginTransaction:308 - Taken session from pool org.hibernate.impl.SessionImpl(PersistentContext[entitiesByKey={}] ActionQueue[insertions=[] updates=[] deletions=[] collectionCreations=[] collectionRemovals=[] collectionUpdates=[]]) DEBUG service-j2ee-2 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers XWikiHibernateStore:beginTransaction:317 - Trying to open transaction DEBUG service-j2ee-2 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers XWikiHibernateStore:beginTransaction:319 - Opened transaction org.hibernate.transaction.JDBCTransaction@1fe500a DEBUG service-j2ee-2 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers XWikiHibernateStore:updateSchema:212 - Update Schema sql: create table xwikiattachment (XWA_ID bigint not null, XWA_DOC_ID bigint, XWA_FILENAME varchar(255) not null, XWA_SIZE integer, XWA_DATE datetime not null, XWA_AUTHOR varchar(255), XWA_VERSION varchar(255) not null, XWA_COMMENT varchar(255), primary key (XWA_ID)) ERROR service-j2ee-2 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers XWikiHibernateStore:updateSchema:219 - Failed updating schema: Table 'xwikiattachment' already exists DEBUG service-j2ee-2 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers XWikiHibernateStore:endTransaction:348 - Releasing hibernate transaction org.hibernate.transaction.JDBCTransaction@1fe500a DEBUG service-j2ee-2 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers XWikiHibernateStore:closeSession:365 - Releasing hibernate session org.hibernate.impl.SessionImpl(PersistentContext[entitiesByKey={}] ActionQueue[insertions=[] updates=[] deletions=[] collectionCreations=[] collectionRemovals=[] collectionUpdates=[]]) DEBUG service-j2ee-2 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers XWikiHibernateStore:beginTransaction:306 - Trying to get session from pool DEBUG service-j2ee-2 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers XWikiHibernateStore:beginTransaction:308 - Taken session from pool org.hibernate.impl.SessionImpl(PersistentContext[entitiesByKey={}] ActionQueue[insertions=[] updates=[] deletions=[] collectionCreations=[] collectionRemovals=[] collectionUpdates=[]]) DEBUG service-j2ee-2 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers XWikiHibernateStore:beginTransaction:317 - Trying to open transaction DEBUG service-j2ee-2 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers XWikiHibernateStore:beginTransaction:319 - Opened transaction org.hibernate.transaction.JDBCTransaction@1aa34dc DEBUG service-j2ee-2 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers XWikiHibernateStore:endTransaction:348 - Releasing hibernate transaction org.hibernate.transaction.JDBCTransaction@1aa34dc DEBUG service-j2ee-2 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers XWikiHibernateStore:closeSession:365 - Releasing hibernate session org.hibernate.impl.SessionImpl(PersistentContext[entitiesByKey={}] ActionQueue[insertions=[] updates=[] deletions=[] collectionCreations=[] collectionRemovals=[] collectionUpdates=[]]) DEBUG service-j2ee-2 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers XWikiHibernateStore:beginTransaction:306 - Trying to get session from pool DEBUG service-j2ee-2 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers XWikiHibernateStore:beginTransaction:308 - Taken session from pool org.hibernate.impl.SessionImpl(PersistentContext[entitiesByKey={}] ActionQueue[insertions=[] updates=[] deletions=[] collectionCreations=[] collectionRemovals=[] collectionUpdates=[]]) DEBUG service-j2ee-2 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers XWikiHibernateStore:beginTransaction:317 - Trying to open transaction DEBUG service-j2ee-2 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers XWikiHibernateStore:beginTransaction:319 - Opened transaction org.hibernate.transaction.JDBCTransaction@1d0eb0b WARN service-j2ee-2 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers JDBCExceptionReporter:logExceptions:71 - SQL Error: 0, SQLState: 08S01 ERROR service-j2ee-2 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers JDBCExceptionReporter:logExceptions:72 - Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.io.EOFException STACKTRACE: java.io.EOFException at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1903) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2349) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2860) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1120) at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:675) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1027) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:118) at org.hibernate.loader.Loader.getResultSet(Loader.java:1239) 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:1562) at org.hibernate.loader.Loader.list(Loader.java:1545) 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:840) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74) at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:603) at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiClassProperty(XWikiHibernateStore.java:1253) at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiClass(XWikiHibernateStore.java:1165) at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:517) at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:557) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:77) at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:556) at com.xpn.xwiki.XWiki.getPrefsClass(XWiki.java:1418) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:405) at com.xpn.xwiki.XWiki.<init>(XWiki.java:343) at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:134) at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:202) at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:117) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397) 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.access$000(ApplicationFilterChain.java:98) at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176) at java.security.AccessController.doPrivileged(Native Method) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:98) at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176) at java.security.AccessController.doPrivileged(Native Method) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:265) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:505) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:212) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:505) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:203) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:505) at com.iplanet.ias.web.connector.nsapi.NSAPIProcessor.process(NSAPIProcessor.java:158) at com.iplanet.ias.web.WebContainer.service(WebContainer.java:856) ** END NESTED EXCEPTION ** Last packet sent to the server was 31 ms ago. 11:47:42,630 ERROR service-j2ee-2 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers JDBCTransaction:begin:57 - JDBC begin failed java.sql.SQLException: No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error: ** BEGIN NESTED EXCEPTION ** com.mysql.jdbc.CommunicationsException MESSAGE: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.io.EOFException STACKTRACE: java.io.EOFException at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1903) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2349) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2860) 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:2972) at com.mysql.jdbc.Connection.rollbackNoChecks(Connection.java:4819) at com.mysql.jdbc.Connection.rollback(Connection.java:4716) at com.sun.enterprise.resource.JdbcXAConnection$JdbcConnection.getCurrentConnection(JdbcXAConnection.java:652) at com.sun.enterprise.resource.JdbcXAConnection$JdbcConnection.getAutoCommit(JdbcXAConnection.java:411) at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:49) at org.hibernate.transaction.JDBCTransactionFactory.beginTransaction(JDBCTransactionFactory.java:24) at org.hibernate.jdbc.JDBCContext.beginTransaction(JDBCContext.java:231) at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1073) at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiClassProperty(XWikiHibernateStore.java:1286) at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiClass(XWikiHibernateStore.java:1165) at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:517) at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:557) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:77) at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:556) at com.xpn.xwiki.XWiki.getPrefsClass(XWiki.java:1418) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:405) at com.xpn.xwiki.XWiki.<init>(XWiki.java:343) at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:134) at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:202) at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:117) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397) 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.access$000(ApplicationFilterChain.java:98) at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176) at java.security.AccessController.doPrivileged(Native Method) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:98) at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176) at java.security.AccessController.doPrivileged(Native Method) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:265) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:505) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:212) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:505) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:203) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:505) at com.iplanet.ias.web.connector.nsapi.NSAPIProcessor.process(NSAPIProcessor.java:158) at com.iplanet.ias.web.WebContainer.service(WebContainer.java:856) ** END NESTED EXCEPTION ** Last packet sent to the server was 3 ms ago. STACKTRACE: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.io.EOFException STACKTRACE: java.io.EOFException at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1903) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2349) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2860) 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:2972) at com.mysql.jdbc.Connection.rollbackNoChecks(Connection.java:4819) at com.mysql.jdbc.Connection.rollback(Connection.java:4716) at com.sun.enterprise.resource.JdbcXAConnection$JdbcConnection.getCurrentConnection(JdbcXAConnection.java:652) at com.sun.enterprise.resource.JdbcXAConnection$JdbcConnection.getAutoCommit(JdbcXAConnection.java:411) at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:49) at org.hibernate.transaction.JDBCTransactionFactory.beginTransaction(JDBCTransactionFactory.java:24) at org.hibernate.jdbc.JDBCContext.beginTransaction(JDBCContext.java:231) at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1073) at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiClassProperty(XWikiHibernateStore.java:1286) at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiClass(XWikiHibernateStore.java:1165) at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:517) at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:557) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:77) at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:556) at com.xpn.xwiki.XWiki.getPrefsClass(XWiki.java:1418) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:405) at com.xpn.xwiki.XWiki.<init>(XWiki.java:343) at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:134) at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:202) at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:117) Claudio Miranda ___________________________________________________________________ http://www.claudius.com.br/blog claudio|em|claudius.com.br Summa Technologies do Brasil