|
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.