Nhibernate transaction issue when moving to mysql from mssql -

-

i using nhibernate mssql (2008) , worked great. had web app bound session per request , wrapped every unit of work within transaction. transactions injected via aop , custom attribute, required attribute wrapped in transaction either ended commit or rollback.

again clarify working fine in mssql , using nhibernate profiler can see transactions occurring expected.

now have added support mysql (5.1) (as 1 environment uses mysql db), have setup tables innodb , table structures identical, bit baffled why following error:

row updated or deleted transaction (or unsaved-value mapping incorrect): [somerandomentity#1]could not synchronize database state session

checking on nhibernate profiler, beginning transaction, firing update call bombing out error, whereas should committing @ point.

if helps sql being fired in update (names changed):

update      some_table set some_column_1 = 1230697028 /* ?p0 */,      some_column_2 = '2011-07-21t10:58:59.00' /* ?p1 */  some_column_3 = 1 /* ?p2 */

it worth noting not using isolation level on transactions, wasnt sure 1 best setup , mssql didnt complain when didnt set it.

has seen issues before, show stopper @ moment :(

=== edit ===

incase helps here connection string:

<connectionstrings>     <add name="nhibernateconnection" connectionstring="server=localhost;database=xxxxx;uid=root;" providername="system.data.sqlclient"/>   </connectionstrings>

it seems problem down wonky column not inserting somewhere else, stopping update. although error not clear underlying problem was.


Comments

Post a Comment

Popular posts from this blog

jQuery Ajax Render Fragments OR Whole Page -

-
i'm in throes of building application wraps mess of legacy code. page working on, need substitute fragment divs constructed on back-end -- or else need replace entire page altogether. idea there dynamically controlled flow needs satisfied before can forward legacy product. substituting fragments works fine, seen in below my_body_content swap. trouble comes when i'm trying render not fragment, whole page, in "body" swap. @ point page goes blank. i want similar errors returned server. want nice rest 404 error messages displayed on screen, legacy-product 404s show in legacy-product 404 page. yes, requirements project weird. that's not problem can fix. here's jquery invocation, names changed protect guilty: $.ajax({ url: "places/things", type: "post", data: json.stringify(somebadassobject), datatype: "text", accepts: "text/html", contenttype: "application/json; charset=...
Read more

javascript - Iterate over array and calculate average values of array-parts -

-
i have array this: ["2011-06-16 16:37:20",23.2], ["2011-06-21 16:37:20",35.6], ["2011-06-26 16:37:20",41.8], ["2011-07-01 16:37:20",25], ["2011-07-06 16:37:20",22.8], ["2011-07-11 16:37:20",36.4], ["2011-07-16 16:37:20",34], ["2011-07-21 16:37:20",20] [...] format: [$date,count] now need add 3rd 4th value every array element, average of n counts before or after. example if n=3 the 3rd value should average of 3 count-values before , 4th value should average of 3 count-values after current array element. result that: ["2011-06-16 16:37:20",23.2, null, 34.13], ["2011-06-21 16:37:20",35.6, null, 29.86], ["2011-06-26 16:37:20",41.8, null, 28.06], ["2011-07-01 16:37:20",25, 33.53, 31.06], ["2011-07-06 16:37:20",22.8, 34.13, 30.13], ["2011-07-11 16:37:20",36.4, 29.86, null], ["2011-07-16 16:37:20",34, 28.06, null], ["2...
Read more

java - Simple Command Line calculator -

-
i have written code command-line calculator in java can't understand errors not allowing compile public class calculator{ public static void main(string[] args){ int numone = args[0]; int numtwo = args[1]; add(numone, numtwo) { result = numone + numtwo; system.out.println("{numone} + {numtwo} = {result}"); } subtract(numone, numtwo) { result = numone - numtwo; system.out.println("{numone} - {numtwo} = {result}"); } multiply(numone, numtwo) { result = numone * numtwo; system.out.println("{numone} * {numtwo} = {result}"); } divide(numone, numtwo) { result = numone / numtwo; system.out.println("{numone} / {numtwo} = {result}"); } } } the translation java of code is: public class calculator { public static void add(int numone, int numtwo) { int result = numone + numtwo; system.out.println(numone + " + " + numtwo + " = " + result); } public static void subtra...
Read more