[JBoss-user] [JCA/JBoss] - Re: Changinh connection state in CMP EJB
Thank's but finally I think that using, one datasource by user (a firm) and one jboss instance by firm is a best choice, and remove the overhead of the context swtiching. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3836673#3836673 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3836673 --- 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
[JBoss-user] [JCA/JBoss] - Changinh connection state in CMP EJB
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 sql code or validconnectionchecker 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
[JBoss-user] [JCA/JBoss] - Changing connection state in CMP EJB
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 witch profile the user is connected. I have wrottent 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 them to the CMP EJB so that it can save it's state with the good connection context. I prospect to use some arbitrary sql or org.jboss.resource.adapter.jdbc.vendor.DummyValidConnectionChecker Is it possible to call this procedure (and how) and give back the new changed connection to the CMP, if not what is the good solution to do that ? ps : I prefere don't use BMP. Thank's in advance. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3835842#3835842 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3835842 --- 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
