Module BB: Can not insert into forum and post table
So... 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 :-)