List:MySQL and .NET« Previous MessageNext Message »
From:Reggie Burnett Date:February 22 2005 4:33pm
Subject:RE: Wierd problem
View as plain text  
Jorge

Can you post a another very simple example to the list showing the error? 

> -----Original Message-----
> From: Jorge Bastos [mailto:mysql.jorge@stripped] 
> Sent: Tuesday, February 22, 2005 10:13 AM
> To: dotnet@stripped
> Subject: Re: Wierd problem
> 
> It makes the same but only in the example where i get a 
> [NULL] value from the server
> 
> Jorge Bastos
> 
> 
> 
> ----- Original Message -----
> From: "Jorge Bastos" <mysql.jorge@stripped>
> To: <dotnet@stripped>
> Sent: Tuesday, February 22, 2005 4:09 PM
> Subject: Re: Wierd problem
> 
> 
> > It makes the same if i close the reader first
> >
> > Jorge Bastos
> >
> >
> > ----- Original Message ----- 
> > From: "Reggie Burnett" <reggie@stripped>
> > To: "'Jorge Bastos'" <mysql.jorge@stripped>; 
> <dotnet@stripped>
> > Sent: Tuesday, February 22, 2005 4:04 PM
> > Subject: RE: Wierd problem
> >
> >
> >> Jorge
> >>
> >> For one thing you are not closing your datareader.
> >>
> >> -reggie
> >>> -----Original Message-----
> >>> From: Jorge Bastos [mailto:mysql.jorge@stripped] Sent: Tuesday, 
> >>> February 22, 2005 6:38 AM
> >>> To: dotnet@stripped; Reggie Burnett
> >>> Subject: Wierd problem
> >>>
> >>> DecimalReggie,
> >>> I got a serius issue here, i'm gonna try to reproduce 
> some code to you 
> >>> take do the same and try, this is with driver 1.0.4
> >>>
> >>>
> >>> ########## example 1 ##########
> >>> dim mycon as new mysqlconnection("connection string") dim 
> sql as string 
> >>> = "select max(id) from tbl_name"
> >>> dim mycmd as new mysqlcommand(sql , mycon) dim myrd as 
> mysqldatareader 
> >>> myrd=mycmd.executereader
> >>>
> >>> if myrd.read
> >>>     msgbox "got some results"
> >>> else
> >>>     msgbox "has a null result"
> >>> end if
> >>>
> >>> mycon.close()
> >>> mycmd.dispose()
> >>> ########## example 1 ##########
> >>>
> >>> In the abobe example everything works fine because the 
> max function will 
> >>> return the last value of the column "id"
> >>>
> >>>
> >>> ########## example 2 ##########
> >>> dim mycon as new mysqlconnection("connection string")
> >>> dim sql as string = "select max(id) from tbl_name where 
> >>> id='laskdjflksdj'"   <------ this where statment is 
> impossible, mysql'll 
> >>> return a null value, ---> [NULL]
> >>> dim mycmd as new mysqlcommand(sql , mycon) dim myrd as 
> mysqldatareader 
> >>> myrd=mycmd.executereader
> >>>
> >>> if myrd.read
> >>>     msgbox "got some results"
> >>> else
> >>>     msgbox "has a null result"
> >>> end if
> >>>
> >>> mycon.close() <----------- like i'll have the value 
> [NULL] returned, i 
> >>> get an error here, at the end of the email i show the output
> >>> mycmd.dispose()
> >>> ########## example 2 ##########
> >>>
> >>> This was not happening with the previous drivers 
> versions, i already had 
> >>> to change a bit of code to handle the situation.
> >>> I'm almost sure that is something with the datareader 
> that doesn't like 
> >>> the value [NULL] that mysql returns, can you confirm the 
> driver bug and 
> >>> how can i resolve this?
> >>> For now i've resolved inserting an try /catch
> >>>
> >>> Jorge Bastos
> >>>
> >>>
> >>>
> >>>
> >>>
> >>> Output:
> >>> MySql.Data.MySqlClient.MySqlException: There is already an open 
> >>> DataReader associated with this Connection which must be 
> closed first.
> >>>    at MySql.Data.MySqlClient.MySqlCommand.CheckState()
> >>>    at 
> MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehav
> >>> ior behavior)
> >>>    at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
> >>>    at MySql.Data.MySqlClient.Driver.ShowWarnings(Int32 count)
> >>>    at MySql.Data.MySqlClient.NativeDriver.ReadEOF(Boolean 
> readPacket)
> >>>    at 
> MySql.Data.MySqlClient.NativeDriver.OpenDataRow(Int32 fieldCount, 
> >>> Boolean isBinary)
> >>>    at MySql.Data.MySqlClient.CommandResult.Consume()
> >>>    at MySql.Data.MySqlClient.MySqlDataReader.Close()
> >>>    at MySql.Data.MySqlClient.MySqlConnection.Close()
> >>>
> >>
> >
> > -- 
> > MySQL on .NET Mailing List
> > For list archives: http://lists.mysql.com/dotnet
> > To unsubscribe: 
> > http://lists.mysql.com/dotnet?unsub=1
> >
> > 
> 
> 
> -- 
> MySQL on .NET Mailing List
> For list archives: http://lists.mysql.com/dotnet
> To unsubscribe:    
> http://lists.mysql.com/dotnet?unsub=1
> 

Thread
Wierd problemJorge Bastos22 Feb
  • RE: Wierd problemReggie Burnett22 Feb
    • Re: Wierd problemJorge Bastos22 Feb
    • Re: Wierd problemJorge Bastos22 Feb
      • RE: Wierd problemReggie Burnett22 Feb
        • Re: Wierd problemJorge Bastos22 Feb
RE: Wierd problemKevin Turner22 Feb