Devart Forums

Posted: **Wed 26 Oct 2005 20:59**

I am currently testing:

mysql direct 3.5.3.0
mysql server 4.1.11
connection mode: compressed, direct
OS: win xp pro

I am getting the following exception if I have unsigned decimal or float columns in my tables:

*************************************************************

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.NotSupportedException: Not supported unsigned type.
at CoreLab.MySql.y.b(ac& A_0)
at CoreLab.MySql.d..ctor(String A_0, String A_1, String A_2, String A_3, String A_4, ac A_5, Boolean A_6, String A_7, Int32 A_8, Int32 A_9, Int32 A_10, Int32 A_11, Int32 A_12)
at CoreLab.MySql.b.a(a4 A_0, Int32 A_1)
at CoreLab.MySql.b.a(d[]& A_0, Int32& A_1)
at CoreLab.MySql.b.a(Byte[] A_0, Int32 A_1, Boolean A_2)
at CoreLab.MySql.x.e()
at CoreLab.MySql.MySqlCommand.a(CommandBehavior A_0, IDisposable A_1, Int32 A_2, Int32 A_3)
at CoreLab.Common.DbCommandBase.b(CommandBehavior A_0)
at CoreLab.Common.DbCommand.a(CommandBehavior A_0)

Thanks, Tim.

Posted: **Wed 26 Oct 2005 21:02**

sorry that should have read:

"I am getting the following exception if I have unsigned decimal or unsigned float columns in my tables"

Posted: **Thu 27 Oct 2005 06:17**

We have fixed this problem for the MySQLDirect .NET.

Look forward for the next build.

Posted: **Tue 28 Aug 2007 22:24**

I'm getting this error with MySQL 5.0.37.

Code: Select all

[NotSupportedException: Not supported unsigned type.]
   CoreLab.MySql.ab.b(d& A_0) +138
   CoreLab.MySql.e..ctor(String A_0, String A_1, String A_2, String A_3, String A_4, d A_5, String A_6, Int32 A_7, Int32 A_8, Int32 A_9, Int32 A_10, Int32 A_11) +141
   CoreLab.MySql.b.a(a8 A_0, Int32 A_1) +1145
   CoreLab.MySql.b.a(e[]& A_0, Int32& A_1) +468
   CoreLab.MySql.b.a(Byte[] A_0, Int32 A_1, Boolean A_2) +194
   CoreLab.MySql.v.d() +1261
   CoreLab.MySql.MySqlCommand.a(CommandBehavior A_0, IDisposable A_1, Int32 A_2, Int32 A_3) +2938
   CoreLab.Common.DbCommandBase.b(CommandBehavior A_0) +207
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +7
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +141
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
   System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770
   System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17
   System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149
   System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
   System.Web.UI.WebControls.GridView.DataBind() +4
   System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
   System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69
   System.Web.UI.Control.EnsureChildControls() +87
   System.Web.UI.Control.PreRenderRecursiveInternal() +41
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360

Table definitions are:
DROP TABLE IF EXISTS `incidentdb`.`tinjuryfollowupdetail`;
CREATE TABLE `incidentdb`.`tinjuryfollowupdetail` (
`InjuryFollowupDetailID` int(10) NOT NULL auto_increment,
`InjuryFollowupDetailExternalPKID` int(10) default NULL,
`InjuryFollowupDetailIncidentID` int(10) default NULL,
`InjuryFollowupDetailBasicInjuryTypeID` int(10) default NULL,
`InjuryFollowupDetailInjuryTypeID` int(10) default NULL,
`InjuryFollowupDetailSeverityID` int(10) default NULL,
`InjuryFollowupDetailKnifeSide` varchar(10) default NULL,
`InjuryFollowupDetailInfected` bit(1) NOT NULL default '\0',
`InjuryFollowupDetailCost` int(10) default NULL,
`InjuryFollowupDetailNotes` mediumtext,
`InjuryFollowupDetailMedicalProfessionalID` int(10) default NULL,
PRIMARY KEY (`InjuryFollowupDetailID`),
KEY `_tBasicInjuryTypetInjuryFollowupDetail` (`InjuryFollowupDetailBasicInjuryTypeID`),
KEY `_tInjurySeveritytInjuryFollowupDetail` (`InjuryFollowupDetailSeverityID`),
KEY `_tInjuryTypetInjuryFollowupDetail` (`InjuryFollowupDetailInjuryTypeID`),
KEY `IncidentFollowupDetailID` (`InjuryFollowupDetailID`),
KEY `IncidentFollowupDetailIncidentID` (`InjuryFollowupDetailIncidentID`),
KEY `IncidentFollowupDetailInjuryOtherID` (`InjuryFollowupDetailInjuryTypeID`),
KEY `InjuryFollowupDetailExternalPKID` (`InjuryFollowupDetailExternalPKID`),
KEY `InjuryFollowupDetailMedicalProfessionalID` (`InjuryFollowupDetailMedicalProfessionalID`),
KEY `InjuryTypeID` (`InjuryFollowupDetailBasicInjuryTypeID`),
KEY `tIncidenttInjuryFollowupDetail` (`InjuryFollowupDetailIncidentID`),
CONSTRAINT `FK_tinjuryfollowupdetail_BasicInjuryType` FOREIGN KEY (`InjuryFollowupDetailBasicInjuryTypeID`) REFERENCES `_tbasicinjurytype` (`BasicInjuryTypeID`),
CONSTRAINT `FK_tinjuryfollowupdetail_Incident` FOREIGN KEY (`InjuryFollowupDetailIncidentID`) REFERENCES `tincident` (`IncidentID`) ON DELETE CASCADE,
CONSTRAINT `FK_tinjuryfollowupdetail_InjuryType` FOREIGN KEY (`InjuryFollowupDetailInjuryTypeID`) REFERENCES `_tinjurytype` (`InjuryTypeID`),
CONSTRAINT `FK_tinjuryfollowupdetail_MedicalProfessional` FOREIGN KEY (`InjuryFollowupDetailMedicalProfessionalID`) REFERENCES `tuser` (`UserID`),
CONSTRAINT `FK_tinjuryfollowupdetail_Severity` FOREIGN KEY (`InjuryFollowupDetailSeverityID`) REFERENCES `_tinjuryseverity` (`InjurySeverityID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `incidentdb`.`_tinjuryseverity`;
CREATE TABLE `incidentdb`.`_tinjuryseverity` (
`InjurySeverityID` int(10) NOT NULL auto_increment,
`InjurySeverityDescription` varchar(50) default NULL,
`InjurySeverityOrder` int(10) default NULL,
PRIMARY KEY (`InjurySeverityID`),
KEY `CausativeFactorSeverityID` (`InjurySeverityID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `incidentdb`.`_tbasicinjurytype`;
CREATE TABLE `incidentdb`.`_tbasicinjurytype` (
`BasicInjuryTypeID` int(10) NOT NULL auto_increment,
`BasicInjuryTypeDescription` varchar(50) default NULL,
PRIMARY KEY (`BasicInjuryTypeID`),
KEY `BasicInjuryTypeID` (`BasicInjuryTypeID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

My SQL DataSource is as follows:

Code: Select all

	"
			ProviderName="" SelectCommand="SELECT tInjuryFollowupDetail.InjuryFollowupDetailID, tInjuryFollowupDetail.InjuryFollowupDetailIncidentID, tInjuryFollowupDetail.InjuryFollowupDetailBasicInjuryTypeID, tInjuryFollowupDetail.InjuryFollowupDetailInjuryTypeID,  tInjuryFollowupDetail.InjuryFollowupDetailSeverityID, tInjuryFollowupDetail.InjuryFollowupDetailKnifeSide,  tInjuryFollowupDetail.InjuryFollowupDetailInfected,  tInjuryFollowupDetail.InjuryFollowupDetailCost,   tInjuryFollowupDetail.InjuryFollowupDetailNotes,  _tBasicInjuryType.BasicInjuryTypeID,  _tBasicInjuryType.BasicInjuryTypeDescription,  _tInjurySeverity.InjurySeverityID,   _tInjurySeverity.InjurySeverityDescription  FROM _tBasicInjuryType INNER JOIN (_tInjurySeverity INNER JOIN tInjuryFollowupDetail ON _tInjurySeverity.InjurySeverityID = tInjuryFollowupDetail.InjuryFollowupDetailSeverityID) ON _tBasicInjuryType.BasicInjuryTypeID = tInjuryFollowupDetail.InjuryFollowupDetailBasicInjuryTypeID WHERE InjuryFollowupDetailIncidentID = ?">

Posted: **Thu 30 Aug 2007 09:04**

What is the version of MySQLDirect .NET you use?

Posted: **Fri 31 Aug 2007 04:58**

The version shown in the properties of CoreLab.MySql.dll is 3.55.20.0

Posted: **Mon 03 Sep 2007 09:41**

We will investigate this problem.
Look forward to hearing from me again.

Posted: **Tue 04 Sep 2007 07:30**

We have fixed this problem.
Look forward to the next build.

Devart Forums

System.NotSupportedException: Not supported unsigned type

System.NotSupportedException: Not supported unsigned type

MySQL.Net direct - Not supported unsigned type.

MySQL.Net direct - Not supported unsigned type