RE: Where/what is a good reference to learn how to access JDBC fromRPGLE?

Rob,

This is an interesting article that uses a table UDF around the JDBC interface:
http://www.mcpressonline.com/mc?50@xxxxxxxxxxxxxxx@.6aea26b5

Here's one that uses data queues:
http://www.iseriesnetwork.com/artarchive/index.cfm?fuseaction=viewarticle&CO_ContentID=19189&channel=&subart=


HTH,


Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of rob@xxxxxxxxx
> Sent: Thursday, June 16, 2005 3:03 PM
> To: rpg400-l@xxxxxxxxxxxx
> Subject: Where/what is a good reference to learn how to access JDBC
> fromRPGLE?
> 
> 
> Will anyone please help answer the following faq:
> http://faq.midrange.com/data/cache/539.html
> Where/what is a good reference to learn how to access JDBC from RPGLE?
> I have a RPG developer that needs to access MS SQL Server 
> data.  Having 
> totally gagged on the price of IBM's suggested solution, and 
> not really 
> having a whole lot of luck with one third party solution, and 
> REALLY not 
> liking the idea of putting software on each SQL server we 
> want to access, 
> we decided to evaluate using RPGLE to call JDBC to get to the 
> data.  How 
> best to learn how to do this?  This developer supposedly took 
> a brief java 
> course.
> 
> Also any suggested reference materials?  Perhaps the following:
> 
> JDBC and Record Level Access with IBM AS/400 Toolbox for Java
> by Joe Pluta
> Book sounds pricy, but it's supposed to more of a course than 
> a book.  The 
> second url explains that better (but doesn't give the discount or the 
> kickback to this wonderful list).
> http://store.midrange.com/details.php?ASIN=0976269201
> http://www.lab400.com/product_detail.asp?prod_id=200
> 
> Java for RPG Programmers
> by Phil Coulthard, George Farr
> http://store.midrange.com/details.php?ASIN=1889671231
> 
> iSeries and AS/400 Java at Work (At Work series)
> by Don Denoncourt
> http://store.midrange.com/details.php?ASIN=1583470182
> 
> Java Application Strategies for iSeries and AS/400--Second Edition
> by Don Denoncourt
> http://store.midrange.com/details.php?ASIN=1583470255
> 
> Java and the AS/400, Second Edition: Practical Examples for 
> the iSeries & 
> AS/400
> by Daniel Darnell
> http://store.midrange.com/details.php?ASIN=1583040935
> 
> 
> 
> Rob Berendt
> -- 
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
> 
> -- 
> This is the RPG programming on the AS400 / iSeries (RPG400-L) 
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
> 
>