[jboss-user] [EJB/JBoss] - Re: Problem with Entity Bean

[allanrj]

Im using ejb 2.0 on my application. Im using a session bean (façade) to access entity bean. I have follow entity: Session, to manage a user session.

Well, when i logon, jboss using the follow commands:
2008-03-31 10:00:05,269 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.Sessions] Executing SQL: SELECT COUNT(*) FROM SESSIONS WHERE sessionid=?
2008-03-31 10:00:05,285 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.Sessions] Executing SQL: INSERT INTO SESSIONS (sessionid, sessioninsertdate, sessionupdatedate, sessionipnumber, userid, sessionipforwarded, sessionclientbrowser, sessioncookieid, siteid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
2008-03-31 10:00:05,285 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityCommand.Sessions] Executing SQL: UPDATE SESSIONS SET sessioninsertdate=?, sessionupdatedate=?, sessionipnumber=?, userid=?, sessionclientbrowser=?, siteid=? WHERE sessionid=?

Then, I close browser and try logon again and jboss do:
2008-03-31 10:01:19,013 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.Sessions] Executing SQL: SELECT COUNT(*) FROM SESSIONS WHERE sessionid=?

And trow a exception:
javax.ejb.DuplicateKeyException: Entity with primary key br.com.gcm.ejb.cmp.SessionsKey at a78a01aa already exists

Well my doubt is:
Why object stay at memory after i close a browser ? Jboss dont manager this right ok ?


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4140115#4140115

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4140115