[Mono-dev] Mono.Data.SqliteClient errors

[Joseph Hill]

Joe,

SqliteResultSet.cs is a file from the patch I submitted in January to
address this bug:

http://bugzilla.ximian.com/show_bug.cgi?id=77262

I committed the patch to your svn because it was needed to get one of your
data methods working in Sqlite.  I should have notified you that your
Mono.Data.SqliteClient was out of step with Mono's svn.

I did some additional work to update the patch this month, but it still
hasn't been committed into the main tree.  If you run into issues because
of this bug, let me know and I will update the patch for you.

Thanks,
Joseph

> I just noticed that SqliteResultSet.cs no longer exists in mono svn and my
> copy is from an old version that did have it. I removed it and everything
> compiled ok, so maybe its a non issue. I'll test the union part tomorrow,
> got to sleep now. I think the Unknown Parameter Type is still an issue.
>
>
> joe_audette [at] yahoo dotcom
> http://www.joeaudette.com
> http://www.mojoportal.com
>
> ----- Original Message ----
> From: Joe Audette <joe_audette at yahoo.com>
> To: Mono-devel-list at lists.ximian.com
> Sent: Monday, June 26, 2006 8:52:49 PM
> Subject: [Mono-dev] Mono.Data.SqliteClient errors
>
> Hi All,
>
> I'm getting errors in 2 situtations using Mono.Data.SqliteClient
>
> When I try to insert a byte[] into a LongBlob field using DBtype.Binary I
> get "Unkown Parameter Type"
>
> When I retrieve a datareader using  a select statement with a union I get
> this error:
>
>  Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about the error and where it originated in the code.
>
> Exception Details: System.NullReferenceException: Object reference not set
> to an instance of an object.
>
> Source Error:
>
> Line 84:
> Line 85:         public object this[string name] {
> Line 86:             get { object retVal = ((object[])
> rows[current_row])[(int) column_names[name]];
> Line 87:                 return retVal == null ? System.DBNull.Value :
> retVal; }
> Line 88:         }
>
>
> Source File: C:\__joe\mojo21\Mono.Data.SqliteClient\SqliteResultSet.cs
> Line: 86
>
> I can comment out either side of the union and it works but when I have
> the union I get this error every time.
>
> I should note that I am testing on Windows and using
> Mono.Data.SqliteClient compiled in VS 2005 and running under 2.0 .NET
>
> I got the Mono.Data.SqliteClient code from  mono svn r61924
>
> Thanks,
>
> Joe
>
>
>
> joe_audette [at] yahoo dotcom
> http://www.joeaudette.com
> http://www.mojoportal.com
>
>
>
> _______________________________________________
> Mono-devel-list mailing list
> Mono-devel-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-devel-list
>
>
>