Re: [JBoss-dev] informix DS & lock mode...

[Jules Gosnell]

David Jencks wrote:
> 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.

Well, you can guess which version I'm on :-( - 3.0.x,

I'm happy to subclass it locally for the moment, and then pick up
whatever strategy, moves into core at a later date.

Let me know what you decide to do, then I can I either get in touch with
Larry, or pull it out of CVS.

Cheers,


Jules


>
> 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






-------------------------------------------------------
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