0 Replies Latest reply on Sep 21, 2004 6:23 AM by Michael Arndt

    Module BB: Can not insert into forum and post table

    Michael Arndt Newbie

      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 :-)