Module BB: Can not insert into forum and post table
marndt Sep 21, 2004 6:23 AMSo... after adapting the mysql-bundle to oracle
i get the bb.ear deployed without any errors.
So far so good.
When trying to add a new topic the topic is
created fine (see log), but the initial post can not be
inserted. I can not even add a forum... adding
a category or a topic works fine. Log message follows:
2004-09-21 11:55:09,936 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCOracleCreateCommand.TopicEJB] Executing SQL: {call INSERT INTO PHPBB_TOPICS (topic_id, topic_time, topic_last_post_time, topic_replies, topic_status, topic_title, topic_type, topic_views, topic_vote, topic_first_post_id, topic_poster, topic_moved_id, topic_last_post_id, forum_id) VALUES (NUKES_SEQ.NEXTVAL, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) RETURNING topic_id INTO ? } 2004-09-21 11:55:10,249 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.UserEJB] Executing SQL: SELECT pn_answer, pn_user_avatar, pn_commentmax, pn_umode, pn_noscore, pn_enabled, pn_bio, pn_femail, pn_user_intrest, pn_user_lang, pn_last_visit, pn_user_from, pn_user_aim, pn_user_icq, pn_user_msnm, pn_user_yim, pn_name, pn_user_occ, pn_pass, pn_prev_last_visit, pn_question, pn_email, pn_user_regdate, pn_user_sig, pn_uorder, pn_theme, pn_timezone_offset, pn_thold, pn_url, pn_uname, pn_user_viewemail FROM NUKE_USERS WHERE (pn_uid=?) 2004-09-21 11:55:10,249 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCOracleCreateCommand.PostEJB] Executing SQL: {call INSERT INTO PHPBB_POSTS (post_id, post_edit_count, post_edit_time, post_subject, post_text, enable_bbcode, enable_html, enable_smilies, enable_sig, post_time, poster_ip, post_username, poster_id, forum_id, topic_id) VALUES (NUKES_SEQ.NEXTVAL, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) RETURNING post_id INTO ? } 2004-09-21 11:55:10,296 ERROR [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCOracleCreateCommand.PostEJB] Could not create entity java.sql.SQLException: Fehlender IN- oder OUT-Parameter auf Index:: 15 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162) at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1642) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2880) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:2976) at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4112) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:266) at org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCOracleCreateCommand.executeInsert(JDBCOracleCreateCommand.java:86) 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:554) 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:581) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [...]
The tables phpbb_forums and phpbb_categories were created by JBoss during deployment so there should be no column-mismatch...
Any idea? Information required? I will send the whole bundle, no problem :-)