please send non html mail :) please post your props files, and your repo that shows your connection properties.
I'm also very interested in how you deployed OJB inside of OC4J. Please explain. -----Original Message----- From: Peketi, Raghava (Contr) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 3:05 PM To: '[EMAIL PROTECTED]' Subject: OJB in OC4J environment - creating a persistent object gives 'Connection was closed' error 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]>
