c# - Get exception details from batch statement -

-

i've got application connect mysql 5-server via odbc-driver. i'm using prepared/parameterized batch-statements move data around @ server. working great, until moment goes wrong...

insert blabla select blablabla; insert blabla select bliblibli; update blabla; // etc.

now if statement goes wrong, unhelpful exception:

system.data.odbc.odbcexception error [hy000] [mysql][odbc 3.51 driver][mysqld-5.0.26-pro-nt]unhandled error mysql_next_result()    @ system.data.odbc.odbcdatareader.nextresult(boolean disposing, boolean allresults)    @ system.data.odbc.odbcdatareader.nextresult()    @ system.data.odbc.odbcdatareader.firstresult()    @ system.data.odbc.odbccommand.executereaderobject(commandbehavior behavior, string method, boolean needreader, object[] methodarguments, sql_api odbcapimethod)    @ system.data.odbc.odbccommand.executereaderobject(commandbehavior behavior, string method, boolean needreader)    @ system.data.odbc.odbccommand.executenonquery()    @ myapp.myclass.mydata.whyareyoureadingthis()

the innerexceptions null.

am able extract further information problem? f.e. if i'm not using batch-statement, exact error message back, not if have batch-statement.

not sure if solve problem (more details in db exceptions), have considered using .net connector mysql (aka ado.net driver mysql) instead of odbc driver?

you can download connector here: http://www.mysql.com/products/connector/

update:
looked in msdn @ odbcexception class. seems has property called errors holds collection of odbcerror classes. instance of classes should have description of each of encountered errors. please let me know if helps.

update2:
seems year ago bug has been submitted mysql team related problem facing: http://bugs.mysql.com/bug.php?id=49466

the bug doesn't seem fixed there nothing can in .net application.

in bug description being said odbc connector specific problem. not 100% sure case. if ever switch .net connector please post message , let know if solved problem.


Comments

Post a Comment

Popular posts from this blog

android - Spacing between the stars of a rating bar? -

-
ho can set spacing beween stars? thats ratingbar: ratingbar = (ratingbar) inflater.inflate(r.layout.ratingbar, null); ratingbar.setlayoutparams(new layoutparams(layoutparams.wrap_content, layoutparams.wrap_content)); the layout: <?xml version="1.0" encoding="utf-8"?> <ratingbar xmlns:android="http://schemas.android.com/apk/res/android" style="@style/mystyle" android:layout_alignparentright="true" android:layout_height="19dp" android:layout_width="wrap_content" android:numstars="5"> </ratingbar> the style: <style name="mystyle" parent="@android:style/widget.ratingbar"> <item name="android:progressdrawable">@drawable/android_r2_ratingstar_yellow</item> <item name="android:indeterminatedrawable">@drawable/android_r2_ratingstar_grey</item> </style> thanks, cheers you have
Read more

aspxgridview - Devexpress grid - header filter does not work if column is initially hidden -

-
i'm using devexpress grid , i'm trying 'country' column display header filter properly: <dx:gridviewdatacolumn caption="country" fieldname="countryname" showincustomizationform="true" visible="false"> <settings allowheaderfilter="true"/> </dx:gridviewdatacolumn> if 'country' column set visible='true', header filter displayed should(it shows value option list). however, want 'country' column hidden, available in customization window(like in code above). in case, when column dragged outside customization window , grid , header filter clicked, javascript error encountered: element null element.addeventlistener(eventname, func, true); is known bug? there workarounds? set aspxgridview.settings.showheaderfilterbutton property true resolve problem. the following markup works fine me (i using dxperience 10.1.7): <asp:accessdatasource id="accessda
Read more

c# - How to execute a particular part of code asynchronously in a class -

-
i creating speech recognition engine that's going respond user commands.i have created button enable , disable speech recognition per user convenience.i have used dispose() of speech engine disable speech recoginition.here code private void button1_click(object sender, routedeventargs e) { engineon = !engineon; if (engineon) { speechengine = speech.createspeechengine(); //speech class creates , returns new speech engine. speechengine.audiolevelupdated += new eventhandler<audiolevelupdatedeventargs>(speechengine_audiolevelupdated); // use system's default microphone speechengine.setinputtodefaultaudiodevice(); speechengine.loadgrammar(new dictationgrammar()); // start listening speechengine.recognizeasync(recognizemode.multiple); } else { speechclass.myengine.dispose(); } } but disposal of speech obj
Read more