[Mono-list] Re: Runtime Mono OracleDataAdapter bug?
Agus Surachman
agus.surachman@ppatk.go.id
Wed, 4 Aug 2004 08:33:25 +0700
This is a multi-part message in MIME format.
------=_NextPart_000_0187_01C479FD.B5B4AC60
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Dear Ximian,
I have a trouble also when selecting BLOB data type using ordinary =
Command:
OracleCommand cmd =3D db.GetTextCommand();
//cmd.CommandText =3D "SELECT * FROM UPLOADER";
cmd.CommandText =3D "SELECT TO_CHAR(UPLOAD_ID) AS UPLOAD_ID, " =
//Number data type
"TO_CHAR(RECEIVE_DATE) AS RECEIVE_DATE, " =
//Date data type
"PJK_CODE, "
"STATUS, "
"TO_CHAR(NO_OF_FILE) AS NO_OF_FILE, " =
//Number data type;
"ORIGIN_FILE, " =
//BLOB data type
"FILE_NAME, "
"TO_CHAR(ID_REP) AS ID_REP, " =
//Number data type
"FG_COPIED "
"FROM UPLOADER";
//Response.Write("executing query: " + cmd.CommandText + "<br>"); =
OracleDataAdapter da =3D new OracleDataAdapter(cmd); // =
=3D=3D> THERE IS NO RESPONSE WHEN MONO CLR EXECUTING... WHICH RUNNING =
WELL WITH .NET CLR!!!
And I still do not know how to handle this..
-Aguss
----- Original Message -----=20
From: Agus Surachman=20
To: Gonzalo Paniagua Javier ; Erik Dasque ; mono-list@lists.ximian.com =
Cc: it-support List Member=20
Sent: Tuesday, August 03, 2004 9:50 AM
Subject: Runtime Mono OracleDataAdapter bug?
Dear all,
Finally I found a bug (?) in Runtime (CLR) Mono for class =
OracleDataAdapter, and its solusion:
OracleDataAdapter ONLY ACCEPT CHARACTER DATA TYPE OF RETURNING QUERY =
COMMAND!!!.
Please find the file I attached below.
Please ximian, fix it to make it complied with .NET CLR!
Best regards,
-Agus Surachman
PPATK - Indonesia
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.732 / Virus Database: 486 - Release Date: 7/30/2004
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.732 / Virus Database: 486 - Release Date: 7/31/2004
------=_NextPart_000_0187_01C479FD.B5B4AC60
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Dear Ximian,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I have a trouble also when selecting =
BLOB data type=20
using ordinary Command:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DCourier size=3D2> OracleCommand =
cmd =3D=20
db.GetTextCommand();<BR> //cmd.CommandText =
=3D=20
"SELECT * FROM =
UPLOADER";<BR> cmd.CommandText=20
=3D "SELECT TO_CHAR(UPLOAD_ID) AS UPLOAD_ID,=20
" //Number data type</FONT></DIV>
<DIV><FONT face=3DCourier=20
size=3D2> &nbs=
p;  =
;"TO_CHAR(RECEIVE_DATE)=20
AS RECEIVE_DATE, " //Date data type</FONT></DIV>
<DIV><FONT face=3DCourier=20
size=3D2> &nbs=
p;  =
;"PJK_CODE,=20
"</FONT></DIV>
<DIV><FONT face=3DCourier=20
size=3D2> &nbs=
p;  =
;"STATUS,=20
"</FONT></DIV>
<DIV><FONT face=3DCourier=20
size=3D2> &nbs=
p;  =
;"TO_CHAR(NO_OF_FILE)=20
AS NO_OF_FILE, " //Number data=20
type;<BR> &nbs=
p;  =
;"ORIGIN_FILE,=20
" =
&=
nbsp; //BLOB=20
data type</FONT></DIV>
<DIV><FONT face=3DCourier=20
size=3D2> &nbs=
p;  =
;"FILE_NAME,=20
"</FONT></DIV>
<DIV><FONT face=3DCourier=20
size=3D2> &nbs=
p;  =
;"TO_CHAR(ID_REP)=20
AS ID_REP, " =20
//Number data type</FONT></DIV>
<DIV><FONT face=3DCourier=20
size=3D2> &nbs=
p;  =
;"FG_COPIED=20
"</FONT></DIV>
<DIV><FONT face=3DCourier=20
size=3D2> &nbs=
p;  =
;"FROM=20
UPLOADER";</FONT></DIV>
<DIV><FONT face=3DCourier></FONT> </DIV>
<DIV><FONT face=3DCourier=20
size=3D2> //Response.Write("executing query: " +=20
cmd.CommandText + "<br>"); </FONT></DIV>
<DIV><FONT face=3DCourier></FONT> </DIV>
<DIV><FONT face=3DCourier =
size=3D2> OracleDataAdapter da =3D=20
new=20
OracleDataAdapter(cmd); &n=
bsp; //=20
=3D=3D> THERE IS NO RESPONSE WHEN MONO CLR EXECUTING... WHICH RUNNING =
WELL WITH=20
.NET CLR!!!</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>And I still do not know how to handle=20
this..</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>-Aguss</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV=20
style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
<A title=3Dagus.surachman@ppatk.go.id=20
href=3D"mailto:agus.surachman@ppatk.go.id">Agus Surachman</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A =
title=3Dgonzalo@ximian.com=20
href=3D"mailto:gonzalo@ximian.com">Gonzalo Paniagua Javier</A> ; <A=20
title=3Dedasque@ximian.com href=3D"mailto:edasque@ximian.com">Erik =
Dasque</A> ; <A=20
title=3Dmono-list@lists.ximian.com=20
=
href=3D"mailto:mono-list@lists.ximian.com">mono-list@lists.ximian.com</A>=
</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Cc:</B> <A =
title=3Dit-support@ppatk.go.id=20
href=3D"mailto:it-support@ppatk.go.id">it-support List Member</A> =
</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Tuesday, August 03, 2004 =
9:50=20
AM</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> Runtime Mono =
OracleDataAdapter=20
bug?</DIV>
<DIV><BR></DIV>
<DIV><FONT face=3DArial size=3D2>Dear all,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Finally I found a bug (?) in Runtime=20
(CLR) Mono for class OracleDataAdapter, and its =
solusion:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>OracleDataAdapter ONLY ACCEPT =
CHARACTER DATA=20
TYPE OF RETURNING QUERY COMMAND!!!.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Please find the file I attached=20
below.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Please ximian, fix it to make it =
complied with=20
.NET CLR!</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Best regards,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>-Agus Surachman</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>PPATK - Indonesia</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV> </DIV><FONT face=3DArial size=3D2>
<DIV><BR>---<BR>Outgoing mail is certified Virus Free.<BR>Checked by =
AVG=20
anti-virus system (<A=20
=
href=3D"http://www.grisoft.com">http://www.grisoft.com</A>).<BR>Version: =
6.0.732=20
/ Virus Database: 486 - Release Date: 7/30/2004</DIV>
<DIV> </DIV>
<DIV><BR>---<BR>Outgoing mail is certified Virus Free.<BR>Checked by =
AVG=20
anti-virus system (<A=20
=
href=3D"http://www.grisoft.com">http://www.grisoft.com</A>).<BR>Version: =
6.0.732=20
/ Virus Database: 486 - Release Date:=20
7/31/2004</FONT></DIV></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0187_01C479FD.B5B4AC60--