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! http://www.vasoftware.com _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
