Right now there's no standard way of executing any sql other than from your client.
it would be pretty easy to add the option of executing a specified sql statment when a managed connection is created. There's also been a lot of requests for "check connection before handing it out" sql statements. I guess this could be added to the wrapper also, to be executed whenever a connection handle is created or associated. Larry, I'd like to see your Informix wrapper to see if some of the things would have more general applicability in one of the jca wrappers. Which version are you working with, Jules? This is easier to do in 3.2 and 4: I'd rather not touch the 3.0 xa jca wrapper if possible. Thanks david jencks On 2002.12.13 13:51:48 -0500 Larry Sanderson wrote: > We use JBoss/Informix in production. We have searched and found no way > to have the SQL: "set lock mode to wait ?" execute automatically on a > given connection. We ended up wrapping Informix's driver to achieve > this, and to work around some XA bugs in their driver. (We currently > have 3 open tickets with IBM/Informix regarding their XA drivers). > > If you are interested, I could send you our wrapped drivers, though it > is not too difficult to do. > > -Larry > > Jules Gosnell wrote: > > David, > > > > It will probably come down to the fact that Dynamo, another piece of > > infrastructure used here, allows the configuration of an SQL statement > > which is used to initialise each connection created by a pool. This is > > used for Pool-wide configuration such as this locking mode and other > > proprietary optimisations. > > > > Since it has not been mentioned, I assume that there is no similar > > mechanism in JBoss ? > > > > Cheers, > > > > > > Jules > > > > > > > > David Jencks wrote: > > > >> On 2002.12.13 11:00:30 -0500 Jules Gosnell wrote: > >> > >>> David Jencks wrote: > >>> > >>>> On 2002.12.13 09:18:48 -0500 Jules Gosnell wrote: > >>>> > >>>>> Is it possible to set up the lock mode for an Informix DS ? > >>>>> > >>>>> I've grepped through the src etc looking for any signs of "set lock > > >>>>> mode" and others, but no joy... > >>>>> > >>>> Not as far as I know. What does it do? How do you normally set it? > Can > >>>> > >>> you > >>> > >>>> set it by supplying URL parameters? Is it an XADataSource attribute > > >>>> (in > >>>> which case I think you can set it by supplying the value in > >>>> XADataSourceProperties xa wrapper attribute)? > >>>> > >>> As far as I can make out it determines the behaviour of a query > >>> arriving and finding the resource it requires already locked. It can > >>> return with an error, or wait for a specified amount of time. > >>> > >>> We are investigating as to whether it can be a URL parameter. > >>> > >>> I don't know about the XADataSourceProperties, but if it was there it > > >>> would have showed up when I went through the code (3.0.5RC1). > >>> > >> > >> > >> Well, actually not. You supply essentially a property file > (name=value > >> pairs) and the adapter wrapper tries to set them by reflection. > >> > >> you haven't supplying any info on _any_ working way of setting this > >> parameter. Surely there is at least one:-) > >> > >> david > >> > >>> Thanks for the response. It looks like we will have to find another > >>> way of setting it up explicitly. > >>> > >>> Jules > >>> > >>> > >>> > >>>> thanks > >>>> david jencks > >>>> > >>>>> Cheers, > >>>>> > >>>>> > >>>>> Jules > >>>>> > >>>>> > >>>>> > >>>>> ________________________________________________________________________ > > >>>>> > >>>>> This email has been scanned for all viruses by the MessageLabs > SkyScan > >>>>> service. For more information on a proactive anti-virus service > >>>>> working > >>>>> around the clock, around the globe, visit > http://www.messagelabs.com > >>>>> ________________________________________________________________________ > > >>>>> > >>>>> > >>>>> > >>>>> ------------------------------------------------------- > >>>>> This sf.net email is sponsored by: > >>>>> With Great Power, Comes Great Responsibility Learn to use your > >>>>> power at OSDN's High Performance Computing Channel > >>>>> http://hpc.devchannel.org/ > >>>>> _______________________________________________ > >>>>> Jboss-development mailing list > >>>>> [EMAIL PROTECTED] > >>>>> https://lists.sourceforge.net/lists/listinfo/jboss-development > >>>>> > >>>>> > >>>> > >>>> ------------------------------------------------------- > >>>> This sf.net email is sponsored by: > >>>> With Great Power, Comes Great Responsibility Learn to use your power > > >>>> at OSDN's High Performance Computing Channel > >>>> http://hpc.devchannel.org/ > >>>> _______________________________________________ > >>>> Jboss-development mailing list > >>>> [EMAIL PROTECTED] > >>>> https://lists.sourceforge.net/lists/listinfo/jboss-development > >>>> > >>> > >>> > >>> > >>> ________________________________________________________________________ > >>> This email has been scanned for all viruses by the MessageLabs > SkyScan > >>> service. For more information on a proactive anti-virus service > working > >>> around the clock, around the globe, visit http://www.messagelabs.com > >>> ________________________________________________________________________ > >>> > >>> > >>> ------------------------------------------------------- > >>> This sf.net email is sponsored by: > >>> With Great Power, Comes Great Responsibility Learn to use your power > >>> at OSDN's High Performance Computing Channel > >>> http://hpc.devchannel.org/ > >>> _______________________________________________ > >>> Jboss-development mailing list > >>> [EMAIL PROTECTED] > >>> https://lists.sourceforge.net/lists/listinfo/jboss-development > >>> > >>> > >> > >> > >> ------------------------------------------------------- > >> This sf.net email is sponsored by: > >> With Great Power, Comes Great Responsibility Learn to use your power > >> at OSDN's High Performance Computing Channel > >> http://hpc.devchannel.org/ > >> _______________________________________________ > >> Jboss-development mailing list > >> [EMAIL PROTECTED] > >> https://lists.sourceforge.net/lists/listinfo/jboss-development > >> > > > > > > > > > > ________________________________________________________________________ > > This email has been scanned for all viruses by the MessageLabs SkyScan > > service. For more information on a proactive anti-virus service working > > around the clock, around the globe, visit http://www.messagelabs.com > > ________________________________________________________________________ > > > > > > ------------------------------------------------------- > > This sf.net email is sponsored by: > > With Great Power, Comes Great Responsibility Learn to use your power at > > > OSDN's High Performance Computing Channel > > http://hpc.devchannel.org/ > > _______________________________________________ > > Jboss-development mailing list > > [EMAIL PROTECTED] > > https://lists.sourceforge.net/lists/listinfo/jboss-development > > > > ------------------------------------------------------- > This sf.net email is sponsored by: > With Great Power, Comes Great Responsibility > Learn to use your power at OSDN's High Performance Computing Channel > http://hpc.devchannel.org/ > _______________________________________________ > Jboss-development mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-development > > ------------------------------------------------------- This sf.net email is sponsored by: With Great Power, Comes Great Responsibility Learn to use your power at OSDN's High Performance Computing Channel http://hpc.devchannel.org/ _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
