java - How can I execute a stored procedure with JDBC / jTDS without using a transaction? -

-

we run website written in java uses jdbc jtds access sql server database.

our database contains complex stored procedure typically takes 10 minutes run. stored procedure works fine if execute directly (say sql server management studio) because not run in transaction. if execute using jtds locks entire website 10 minutes. happens because jtds runs in transaction, , website requests on hold waiting transaction finish.

for example, following locks website due transaction:

connection connection = drivermanager.getconnection("jdbc:jtds:sqlserver://example/example"); callablestatement callablestatement = connection.preparecall("exec dbo.proctest"); callablestatement.execute();

is there way can run stored procedure using jdbc / jtds without running in transaction?

please note calling on jtds connection not valid:

connection.settransactionisolation(connection.transaction_none);

that throws exception stating connection.transaction_none parameter not supported jtds.

edit: have asked question better: core problem not transaction itself, problem transaction causes database locks held 10 minutes. either need get rid of transaction, or need locks released during transaction.

calling connection#close() or connection#commit() should submit , end transaction. close db resources connection in finally block?


Comments

Post a Comment

Popular posts from this blog

c++ - How do I get a multi line tooltip in MFC -

-
right now, have tool tip pops when hover on edit box. problem tool tip contains multiple error messages , in 1 long line. need have each error message on own line. error messages contained in cstring new line seperating them. my existing code below. bool ontooltiptext(uint, nmhdr* pnmhdr, lresult* presult) { assert(pnmhdr->code == ttn_needtexta || pnmhdr->code == ttn_needtextw); // need handle both ansi , unicode versions of message tooltiptexta* pttta = (tooltiptexta*)pnmhdr; tooltiptextw* ptttw = (tooltiptextw*)pnmhdr; // tchar szfulltext[256]; cstring strtiptext=_t(""); uint nid = pnmhdr->idfrom; if (pnmhdr->code == ttn_needtexta && (pttta->uflags & ttf_idishwnd) || pnmhdr->code == ttn_needtextw && (ptttw->uflags & ttf_idishwnd)) { // idfrom hwnd of tool nid = ::getdlgctrlid((hwnd)nid); } //m_errprojaccel[ch] contains 1 or more error messages each...
Read more

asp.net - In javascript how to find the height and width -

-
i having .aspx , masterpage page. in masterpage loading aspx page . in aspx page design using generating table structure using code-behind server in javascript how find height , width . regards, kumar if you're looking table height , width, should it var tbl = document.getelementbyid('tbldemo'); alert(tbl.offsetwidth + '\n' + tbl.offsetheight);
Read more

c# - DataTable to EnumerableRowCollection -

-
i have datatable according client requirement can contain invalid date "00/00/1999",null,empty string.(typed datset) when collect them enumerables wish convert of invalid forms empty string. (i.e) enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || (how check date invalid date) ? string.empty : order.field<datetime>("orderdate") } how check whether date valid date or not? datetime.tryparse...like given current code: datetime date; enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || !datetime.tryparse(convert.tostring(order.field<datetime...
Read more