QuickTable | Thread - deadlock set a time out

QuickTable
Home \| API \| Tutorial \| Download \| Support \| Contact

QuickTable

User Cp | Register | Members | Search | Help

\|- QuickTable Discussion Forums > JDBC/Database Issues	Post New Topic Post A Reply
deadlock set a time out	printer friendly version next newest post \| next oldest post

Author	Messages
infow Unregistered	Posted Saturday, January 23, 2010 @ 07:46:40 Hi, when i'm open two qtable from the same Oracle Table, i have a deadlock when the two users is modifying data without a commit. Is it possible to set a time out on a execution on qtable ? Thanks in advance
Admin Board Owner Gender: Unspecified Location: Registered: Jul 2003 Status: Offline Posts: 9	Posted Saturday, January 23, 2010 @ 09:51:15 I think your jdbc drivers mught provide a timeout mechanism. That would be the best option. If not using database change listener, you can catch the changes and update database yourself within a thread. you can set a timeout in thread. another option is is setset autocommit false and call commit changes within a thread. I am not sure how well this will work.
infow Unregistered	Posted Tuesday, February 23, 2010 @ 09:42:05 Hi, the timeout is set to the statement. So , in my case, i had to include this line "pt.setQueryTimeout(5);" into the function update from DbTableModel Could you please include an option to do it in your standard program ? Thanks and have a nice day

Post New Topic Post A Reply

Jump to:

All times are GMT -5 Hours.

Welcome to QuickTable Forums, Guest!

Username	:
Password	:

In order to fully utilize the abilities of this board, you are required to register as a member. Registration is free, and allows you to do lots of things including turning on or off certain features of this board. Register now!