|
Hi All,
If any of you faced similar problem and
found solution for this, please let me know.
I am using OBJ in OC4J env. I want container
to manage transaction and connection pools.
So I modified OJB.properties to use J2EE
factory and broker.
I use JNDI data source name instead of JDBC
driver.
Now when I use Query by criteria, it
retrieves the list of objects.
But when I do create, the insert operation
fails
Following is the stack trace.
Let me know if I need to do any more
configuration for the OJB to use connection pool
from container and why the connection is
getting closed.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
[org.apache.ojb.broker.accesslayer.JdbcAccess] DEBUG:
executeInsert : gov.nih.fw
training.beantier.discussionforum.Reply@2b105d [org.apache.ojb.broker.accesslayer.SqlGenerator] DEBUG: SQL: INSERT INTO REPLIES (DISCUSSION_ID,REPLY_ID,CREATION_DATE,SUBMITTED_BY,EMAIL,REPLY_CONTENT) VALUES ( ?, ?, ?, ?, ?, ? ) [org.apache.ojb.broker.accesslayer.SQLCachingStatementsForClass] ERROR: Error ge tting insert statement for class (gov.nih.fwtraining.beantier.discussionforum.Re ply) The connection was closed java.sql.SQLException: The connection was closed at com.evermind.sql.OrionCMTConnection.intercept(OrionCMTConnection.java :45) at com.evermind.sql.FilterConnection.prepareStatement(FilterConnection.j ava:268) at org.apache.ojb.broker.accesslayer.StatementsForClass.prepareStatement (Unknown Source) at org.apache.ojb.broker.accesslayer.SQLCachingStatementsForClass.getIns ertStmt(Unknown Source) at org.apache.ojb.broker.accesslayer.StatementManager.getInsertStatement (Unknown Source) at org.apache.ojb.broker.accesslayer.JdbcAccess.executeInsert(Unknown So urce) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store(Unknown So urce) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store(Unknown So urce) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store(Unknown So urce) at gov.nih.framework.persistenceservice.PersistenceServiceDefaultImpl.cr eate(PersistenceServiceDefaultImpl.java:34) at gov.nih.fwtraining.beantier.discussionforum.DiscussionEJB.reply(Discu ssionEJB.java:226) at Discussion_EntityBeanWrapper28.reply(Discussion_EntityBeanWrapper28.j ava:264) at gov.nih.fwtraining.beantier.discussionforum.DiscussionForumSessionEJB .replyToDiscussion(DiscussionForumSessionEJB.java:173) at DiscussionForumSession_StatelessSessionBeanWrapper26.replyToDiscussio n(DiscussionForumSession_StatelessSessionBeanWrapper26.java:332) at gov.nih.fwtraining.beantier.discussionforum.DiscussionForumServiceAda pter.replyToDiscussion(DiscussionForumServiceAdapter.java:31) at gov.nih.fwtraining.webtier.actions.discussionforum.ReplyFormAction.pe rform(ReplyFormAction.java:95) at gov.nih.framework.webtier.utils.EraActionRunnable.run(EraActionRunnab le.java:101) at java.lang.Thread.run(Unknown Source) [org.apache.ojb.broker.accesslayer.JdbcAccess] ERROR: PersistenceBrokerException during the execution of the insert: null null org.apache.ojb.broker.PersistenceBrokerSQLException at org.apache.ojb.broker.accesslayer.StatementManager.getInsertStatement (Unknown Source) at org.apache.ojb.broker.accesslayer.JdbcAccess.executeInsert(Unknown So urce) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store(Unknown So urce) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store(Unknown So urce) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store(Unknown So urce) at gov.nih.framework.persistenceservice.PersistenceServiceDefaultImpl.cr eate(PersistenceServiceDefaultImpl.java:34) at gov.nih.fwtraining.beantier.discussionforum.DiscussionEJB.reply(Discu ssionEJB.java:226) at Discussion_EntityBeanWrapper28.reply(Discussion_EntityBeanWrapper28.j ava:264) at gov.nih.fwtraining.beantier.discussionforum.DiscussionForumSessionEJB .replyToDiscussion(DiscussionForumSessionEJB.java:173) at DiscussionForumSession_StatelessSessionBeanWrapper26.replyToDiscussio n(DiscussionForumSession_StatelessSessionBeanWrapper26.java:332) at gov.nih.fwtraining.beantier.discussionforum.DiscussionForumServiceAda pter.replyToDiscussion(DiscussionForumServiceAdapter.java:31) at gov.nih.fwtraining.webtier.actions.discussionforum.ReplyFormAction.pe rform(ReplyFormAction.java:95) at gov.nih.framework.webtier.utils.EraActionRunnable.run(EraActionRunnab le.java:101) at java.lang.Thread.run(Unknown Source) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
thanks
Raghavan Peketi Senior Consultant Silicon Spirit Consulting Group, Inc.
|
-- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
