[prev in list] [next in list] [prev in thread] [next in thread] 

List:       ms-java-com
Subject:    Re: Passing ADO Recordsets as IDataSource objects.
From:       InfoZoom Mail <eMail () INFOZOOM ! DE>
Date:       1999-02-26 7:27:35
[Download RAW message or body]


Thomas,
my knowledge with ADO is pretty good, but not with MTS and marshalling.
Anyway to me it seems that if working with Recordsets (not IDataSource), the
marshalled Recordset on the client-side still holds enough information about
its datasource to send the data back, when Recordset.UpdateBatch on the
client-side is called, without the need to use IDataSource/Recordset as a
parameter to a server-side update-method.
Stefan


-----Original Message-----
From: Thomas Jones [mailto:Thomas.Jones@MAPICS.COM]
Sent: Donnerstag, 25. Februar 1999 21:23
To: Java-COM@DISCUSS.MICROSOFT.COM
Subject: Re: Passing ADO Recordsets as IDataSource objects.


It seems to be passing the IDataSource back as a parameter to the update
method that causes the failure.  I have retrieved a disconnected record set
of 160,000 elements and iterated over them successfuly.  However, when I
attempt to send just 30 elements it fails.

--Thomas Jones
MAPICS, Inc.

b.t.w. I am running SP4 and MSJVM build 3167





InfoZoom Mail <eMail@INFOZOOM.DE> on 02/25/99 01:40:48 PM

Please respond to Java and COM <Java-COM@DISCUSS.MICROSOFT.COM>

To:   Java-COM@DISCUSS.MICROSOFT.COM
cc:    (bcc: Thomas Jones/ATLANTA/MAPICS)
Subject:  Re: Passing ADO Recordsets as IDataSource objects.




May be it is better to return a _Recordset instead of IDataSource. As far
as
I know, the _Recordset-interface has some built-in marshalling-support and
I
don't think this applies to IDataSource as well. (At least with the
ADOR.Recordset from VB this applies and I think there is no difference in
ADO 2.1 between ADOR and ADODB with Clientside cursors). (BTW If you are
using com.ms.wfc.data Recordset you can still return a _Recordset, by
casting the Datasource).
Well its just an idea...
Stefan


-----Original Message-----
From: Thomas Jones [mailto:Thomas.Jones@MAPICS.COM]
Sent: Donnerstag, 25. Februar 1999 17:55
To: Java-COM@DISCUSS.MICROSOFT.COM
Subject: Passing ADO Recordsets as IDataSource objects.


While attempting to run some performance tests on a possible system I ran
into an error when moving an IDataSource across machines.  The error is:

com.ms.com.ComFailException: (0x80004005) Unspecified error

The system consists of a simple Java component hosted in MTS.  The
component has two methods:
public IDataSource queryData( String selectionClause );
public IDataSource updateData( IDataSource retIds );

The table I am querying has 11 columns, all strings of varying size.

The test code executes queryData against the component (if null is used all
elements are returned), creates a com.ms.wfc.data.Recordset from the
returned IDataSource, adds N new elements to the Recordset and then calls
updateData on the component using the IDataSource returned from
getDataSource on the Recordset.



When the Java component is hosted in MTS on another box I can only push
across an IDataSource that contains less than 30 elements.  If the
component is hosted on the same machine as the client there are not errors,
I have pushed the dataset up to 10,000 rows.



Any help would be greatly appreciated.



--Thomas Jones

MAPICS, Inc.

----------------------------------------------------------------
Users Guide http://www.microsoft.com/workshop/essentials/mail.asp
contains important info including how to unsubscribe.  Save time, search
the archives at http://discuss.microsoft.com/archives/index.html

----------------------------------------------------------------
Users Guide http://www.microsoft.com/workshop/essentials/mail.asp
contains important info including how to unsubscribe.  Save time, search
the archives at http://discuss.microsoft.com/archives/index.html

----------------------------------------------------------------
Users Guide http://www.microsoft.com/workshop/essentials/mail.asp
contains important info including how to unsubscribe.  Save time, search
the archives at http://discuss.microsoft.com/archives/index.html

----------------------------------------------------------------
Users Guide http://www.microsoft.com/workshop/essentials/mail.asp
contains important info including how to unsubscribe.  Save time, search
the archives at http://discuss.microsoft.com/archives/index.html

[prev in list] [next in list] [prev in thread] [next in thread]