Bug #13632 the MySQLCommandBuilder.deriveparameters has not been updated for MySQL 5
| Submitted: | 30 Sep 2005 5:01 | Modified: | 20 Nov 2005 4:44 |
|---|---|---|---|
| Reporter: | Michael Cashion | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | Connector / NET | Severity: | S3 (Non-critical) |
| Version: | 1.0.5 | OS: | Windows (Windows - .NET) |
| Assigned to: | Reggie Burnett | CPU Architecture: | Any |
[30 Sep 2005 5:01]
Michael Cashion
[30 Sep 2005 7:00]
Vasily Kishkin
Could you please provide any test case ?
[3 Oct 2005 11:39]
Michael Cashion
A VB Test function that uses this method
Private Shared Function DiscoverSpParameterSet(ByVal connection As MySqlConnection, _
ByVal spName As String, _
ByVal includeReturnValueParameter As Boolean, _
ByVal ParamArray parameterValues() As Object) As MySqlParameter()
Dim cmd As New MySqlCommand(spName, connection)
cmd.CommandType = CommandType.StoredProcedure
Dim discoveredParameters() As MySqlParameter
connection.Open()
MySqlCommandBuilder.DeriveParameters(cmd)
connection.Close()
If Not includeReturnValueParameter Then
cmd.Parameters.RemoveAt(0)
End If
discoveredParameters = New MySqlParameter(cmd.Parameters.Count - 1) {}
cmd.Parameters.CopyTo(discoveredParameters, 0)
' Init the parameters with a DBNull value
Dim discoveredParameter As MySqlParameter
For Each discoveredParameter In discoveredParameters
discoveredParameter.Value = DBNull.Value
Next
Return discoveredParameters
End Function ' DiscoverSpParameterSet
At the SqlCommandBuilder.DeriveParameters(cmd) line, an error message is generated stating the MySQL does not support stored procedures.
[11 Oct 2005 9:18]
Vasily Kishkin
I was able to reproduce the bug on 1.0.6. Test case is attached.
[11 Oct 2005 9:20]
Vasily Kishkin
Test case
Attachment: 13632.zip (application/force-download, text), 5.65 KiB.
[13 Oct 2005 20:43]
Reggie Burnett
Fixed in 1.0.7
[1 Nov 2005 20:39]
Paul DuBois
Reggie, can you suggest a sentence for the changelog describing what was done here? Thanks.
[2 Nov 2005 9:17]
Wagner Traut
When will this update be available for downloading?
[20 Nov 2005 4:44]
Paul DuBois
Note in 1.0.7 changelog.
[19 May 2006 8:54]
Gianluca Calabretta
Method MySQLCommandBuilder.DeriveParameters(...) doesn't work fine in release 1.0.7. It doesn't support: - stored procedures without parameters - stored procedures with 'char' type parameters
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.041 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.