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

Sat, 14 Dec 2002 04:18:33 -0800 

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






















					Reply via email to