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 :-)
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3848932#3848932
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3848932
-------------------------------------------------------
This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
Project Admins to receive an Apple iPod Mini FREE for your judgement on
who ports your project to Linux PPC the best. Sponsored by IBM.
Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
