Re: [JBoss-user] Informix XA and JBOSS 3.0.4
I jumped through a lot of hoops to get Informix XA working on JBoss, including modifying the JBoss TransactionManager, and wrapping Informix's XA drivers. In the end, everything worked except for one recurring (and very annoying) problem: the database periodically extablished a lock on some data that it would not let go without a DB restart. None of the informix tools would release the lock. I whipped together some Java XA code that was able to fix some of the problems, but every now and then a DB restart was necessary. In the end, we ended up rolling back to the non-XA drivers. I have sent the wrapped drivers to several folks on this alias that asked about them. I think David Jenks and Jules Gosnell also asked about them at one point, but I never got them out. I have attached them here for the world to see/use/fix. It should go without saying: Use at your own risk. -Larry Instructions on use of attached informix.sar: You can use this as a replacement for your current db-service.xml. You will need to modify the META-INF/jboss-service.xml to suite your environment. Note: you can run this archive exploded - it makes it easier to modify the jboss-service.xml file. It has only two external references: Log4j and Informix's current drivers. If you would prefer to rip the thing apart, the only file you need is the IfxXADataSource.java - all the others are tests that expose the various bugs in the original XA driver, and a tool to help recover transactions stuck in the database. Good Luck! Corbin, James wrote: Has anyone been able to successfully get a connection to an Informix database through a configured XA driver? I appear to bind to the datasource okay as I do not get any errors at startup, but whenever I try to programmatically get a connection it fails. This is very annoying. Please advise. J.D. This electronic message transmission contains information from the Company that may be proprietary, confidential and/or privileged. The information is intended only for the use of the individual(s) or entity named above. If you are not the intended recipient, be aware that any disclosure, copying or distribution or use of the contents of this information is prohibited. If you have received this electronic transmission in error, please notify the sender immediately by replying to the address listed in the From: field. informix.sar Description: Binary data
RE: [JBoss-user] Informix XA and JBOSS 3.0.4
I gave up on the XA drivers and moved to the non-xa drivers. It appears that JBOSS tries to set the autocommit flag on a manage connection which generates an exception within JBOSS. Under JBOSS 3.0.4 I haven't found anyway to set the autocommit to false for the database at startup via the informix-service.xml (NON-XA). Any ideas Larry? J.D. -Original Message- From: Larry Sanderson To: [EMAIL PROTECTED] Sent: 2/8/2003 10:43 AM Subject: Re: [JBoss-user] Informix XA and JBOSS 3.0.4 I jumped through a lot of hoops to get Informix XA working on JBoss, including modifying the JBoss TransactionManager, and wrapping Informix's XA drivers. In the end, everything worked except for one recurring (and very annoying) problem: the database periodically extablished a lock on some data that it would not let go without a DB restart. None of the informix tools would release the lock. I whipped together some Java XA code that was able to fix some of the problems, but every now and then a DB restart was necessary. In the end, we ended up rolling back to the non-XA drivers. I have sent the wrapped drivers to several folks on this alias that asked about them. I think David Jenks and Jules Gosnell also asked about them at one point, but I never got them out. I have attached them here for the world to see/use/fix. It should go without saying: Use at your own risk. -Larry Instructions on use of attached informix.sar: You can use this as a replacement for your current db-service.xml. You will need to modify the META-INF/jboss-service.xml to suite your environment. Note: you can run this archive exploded - it makes it easier to modify the jboss-service.xml file. It has only two external references: Log4j and Informix's current drivers. If you would prefer to rip the thing apart, the only file you need is the IfxXADataSource.java - all the others are tests that expose the various bugs in the original XA driver, and a tool to help recover transactions stuck in the database. Good Luck! Corbin, James wrote: Has anyone been able to successfully get a connection to an Informix database through a configured XA driver? I appear to bind to the datasource okay as I do not get any errors at startup, but whenever I try to programmatically get a connection it fails. This is very annoying. Please advise. J.D. This electronic message transmission contains information from the Company that may be proprietary, confidential and/or privileged. The information is intended only for the use of the individual(s) or entity named above. If you are not the intended recipient, be aware that any disclosure, copying or distribution or use of the contents of this information is prohibited. If you have received this electronic transmission in error, please notify the sender immediately by replying to the address listed in the From: field. informix.sar This electronic message transmission contains information from the Company that may be proprietary, confidential and/or privileged. The information is intended only for the use of the individual(s) or entity named above. If you are not the intended recipient, be aware that any disclosure, copying or distribution or use of the contents of this information is prohibited. If you have received this electronic transmission in error, please notify the sender immediately by replying to the address listed in the From: field. --- This SF.NET email is sponsored by: SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! http://www.vasoftware.com ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
RE: [JBoss-user] Informix XA and JBOSS 3.0.4
I've been able to get the XA drivers up and working under version 2.21JC3 of the IBM/Informix JDBC drivers and with Larry's help. I had to write a custom authentication module in order to be able to use the ODBC authentication setup (to simplify installation) as opposed to the users.properties file, and I had to modify Larry's wrapper to fix some other Informix problems (I couldn't get the SQLH_TYPE and SQLH_FILE parameters to work). But it is logging in and accessing the database. I didn't know about Larry's DB-locks problem, though. Now I'm worried! :( -- Jim Brownfield [EMAIL PROTECTED] Radical System Solutions, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Corbin, James Sent: Saturday, February 08, 2003 3:57 PM To: 'Larry Sanderson '; '[EMAIL PROTECTED] ' Subject: RE: [JBoss-user] Informix XA and JBOSS 3.0.4 I gave up on the XA drivers and moved to the non-xa drivers. It appears that JBOSS tries to set the autocommit flag on a manage connection which generates an exception within JBOSS. Under JBOSS 3.0.4 I haven't found anyway to set the autocommit to false for the database at startup via the informix-service.xml (NON-XA). Any ideas Larry? J.D. -Original Message- From: Larry Sanderson To: [EMAIL PROTECTED] Sent: 2/8/2003 10:43 AM Subject: Re: [JBoss-user] Informix XA and JBOSS 3.0.4 I jumped through a lot of hoops to get Informix XA working on JBoss, including modifying the JBoss TransactionManager, and wrapping Informix's XA drivers. In the end, everything worked except for one recurring (and very annoying) problem: the database periodically extablished a lock on some data that it would not let go without a DB restart. None of the informix tools would release the lock. I whipped together some Java XA code that was able to fix some of the problems, but every now and then a DB restart was necessary. In the end, we ended up rolling back to the non-XA drivers. I have sent the wrapped drivers to several folks on this alias that asked about them. I think David Jenks and Jules Gosnell also asked about them at one point, but I never got them out. I have attached them here for the world to see/use/fix. It should go without saying: Use at your own risk. -Larry Instructions on use of attached informix.sar: You can use this as a replacement for your current db-service.xml. You will need to modify the META-INF/jboss-service.xml to suite your environment. Note: you can run this archive exploded - it makes it easier to modify the jboss-service.xml file. It has only two external references: Log4j and Informix's current drivers. If you would prefer to rip the thing apart, the only file you need is the IfxXADataSource.java - all the others are tests that expose the various bugs in the original XA driver, and a tool to help recover transactions stuck in the database. Good Luck! Corbin, James wrote: Has anyone been able to successfully get a connection to an Informix database through a configured XA driver? I appear to bind to the datasource okay as I do not get any errors at startup, but whenever I try to programmatically get a connection it fails. This is very annoying. Please advise. J.D. This electronic message transmission contains information from the Company that may be proprietary, confidential and/or privileged. The information is intended only for the use of the individual(s) or entity named above. If you are not the intended recipient, be aware that any disclosure, copying or distribution or use of the contents of this information is prohibited. If you have received this electronic transmission in error, please notify the sender immediately by replying to the address listed in the From: field. informix.sar This electronic message transmission contains information from the Company that may be proprietary, confidential and/or privileged. The information is intended only for the use of the individual(s) or entity named above. If you are not the intended recipient, be aware that any disclosure, copying or distribution or use of the contents of this information is prohibited. If you have received this electronic transmission in error, please notify the sender immediately by replying to the address listed in the From: field. --- This SF.NET email is sponsored by: SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! http://www.vasoftware.com ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user --- This SF.NET email is sponsored by: SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See
