Hello Hubert,
Hmmm... I never did try filling a data set with a timestamp. Only selecting and inserting via a parameter.
Internally, OracleDateTime uses a System.DateTime. This should change. We should separate the various parts in OracleDateTime. I will look into System.DateTime to see how its implemented.
An Oracle TIMESTAMP can have a milliseconds precision of up to 9 digits while System.DateTime is 3 (if my memory serves me correctly). By default, a TIMESTAMP has a milliseconds precision of 6. In Mono's OracleClient, the milliseconds are (in theory) are trimmed down to fit in a System.DateTime using division. Maybe, we should be doing something different. Any suggestions?
Maybe we should be using an OracleDateTime internally instaed of System.DateTime in OciBindHandle, OciDefineHandle, and OracleDataReader.
What is the definition of your TIMESTAMPs? How does some of your TIMESTAMPs look like?
Daniel
Hubert FONGARNAND <[EMAIL PROTECTED]> wrote:
> I committed to svn trunk HEAD support for Oracle TIMESTAMP using an
> OciDateTime descriptor.
I've update my mono from svn and i run a little test :
cmd.Connection=new OracleConnection(cnx);
cmd.CommandText="SELECT datetime FROM essai";
OracleDataAdapter dta=new OracleDataAdapter(cmd);
DataSet ds = new DataSet();
dta.Fill(ds,"TABLE");
Console.WriteLine("OK");
foreach(DataRow row in ds.Tables["TABLE"].Rows)
{
Console.WriteLine(row["DATETIME"]);
}
I get :
*** glibc detected *** free(): invalid pointer: 0x082fe20c ***
Abandon
It fails when it does dta.Fill
When i do a mono --trace the last line i get is :
. . . . . . . . . . ENTER:
System.Data.OracleClient.Oci.OciDefineHandle:Dispose (bool)(this:0x5cf00
[System.Data.OracleClient.Oci.OciDefineHandle sqlserver.exe], 1, )
. . . . . . . . . . . ENTE R: (wrapper managed-to-native)
System.Runtime.InteropServices.Marshal:FreeHGlobal (intptr)(0x82ff9f4, )
Yahoo! for Good
Click here to donate to the Hurricane Katrina relief effort.
_______________________________________________ Mono-devel-list mailing list Mono-devel-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-devel-list
