RE: SQL data access

["Mike Skvarenina" <mskvarenina@xxxxxxx>]

The database I need to connect to is a Microsoft SQL Server DB.  How is
performance using the JDBC method described below?  In one case we'd be
looking to enter a search term and perhaps return 500 rows to a browser
screen at once.  In RPG CGI I could simply read and write the rows to HTML
and probably have a web page loaded in seconds.  I'm concerned that using a
"connection" rather than a native file won't be so fast.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Thursday, October 19, 2006 4:17 PM
To: Midrange Systems Technical Discussion
Subject: Re: SQL data access

A common thing to do is to use JDBC calls to do it.  I think it was 
iSeries Experts Journal that published an article on it.  (Attempts to 
search their archive are resulting in a 500 Server Error.)

We contracted out a project to do a JDBC interface to MS SQL.  That's 
working ok.  We contracted it out to the person who wrote this book
http://store.midrange.com/details.php?ASIN=0976269201
(Those books from Rochester Initiative look a bit salty to me.)

One "package" we looked at was discarded after several attempts to get it 
working.

Rob Berendt