We have a beta version of a conversion routine which can convert a
java.sql.ResultSet to our own TabularResults.ResultSet IDL implementation.
As a developer its very easy.....
java.sql.ResultSet rs = stmt.executeQuery(SQL);
TabularResults.ResultSet trs = TabularResults.ConvertSQL.getResultSet(rs);
rs.close();
return trs;
// on client side
java.sql.ResultSet rs =
TabularResults.ConvertSQL.getResultSet(bean.methodCall());
The advantages of this are
1) It is marshallable over RMI, IIOP or RMI/IIOP
2) Contains all the metadata of the originial result set
3) Is open source
If you'd like to test the beta before we release it to the community as open
source, please feel free to email me directly.
Dave Wolf
Internet Applications Division
Sybase
----- Original Message -----
From: "Sebouh" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 14, 2001 5:21 AM
Subject: sql recordset to tabular recordset
> Hi everyone
>
> What's the best way to send a recordset from EJB to JSP
>
> first, what is the best way to work with EJB,
> JSP - JavaBean - EJB
> or JSP - EJB
>
> second, what's the way to convert sql resultset to corba tabular resultset
>
> thank you.
>
> <Signature>
> <Name> Sebouh Hatsakordzian </Name>
> <Job Title> Software Engineer </Job Title>
> <Company> DC Soft SAL </Company>
> <Telephone> +961-1-385425 </Telephone>
> <Fax> +961-1-385428 </Fax>
> <Mailbox> 11-0337 </Mailbox>
> <City> Beirut </City>
> <Country> Lebanon </Country>
> <Email> mailto:[EMAIL PROTECTED] </Email>
> <URL> http://www.dcsoftintl.com </URL>
> </Signature>
>
>
===========================================================================
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff EJB-INTEREST". For general help, send email to
> [EMAIL PROTECTED] and include in the body of the message "help".
>
>
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
