Hi, I use JBoss 3.2.x on Windows but connected on iSeries DB2 datasource. On our DB2 there are lots of tables proposed to the user, but it depends with wich profile the user is connected. I have writtent a SQL procedure that change the iSeries user context. In current state this procedure must be called on all getConnection().
So, I would like call this procedure from a CMP EJB to change the state of the connection and resend theme to the CMP EJB so that it can save it's state with the good connection context. I prospect to user <check-valid-connection-sql> sql code </check-valid-connection-sql> or <valid-connection-checker-class-name>validconnectionchecker</valid-connection-checker-class-name> But i don't know, how to use it. Is it possible, to call this procedure and send them parameters (and how) ? Thank's View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3836593#3836593 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3836593 ------------------------------------------------------- This SF.Net email is sponsored by: Oracle 10g Get certified on the hottest thing ever to hit the market... Oracle 10g. Take an Oracle 10g class now, and we'll give you the exam FREE. http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user