Hi Robert,

Although you probably can't wait until May... Take notice of the free EGL Distance Learning classes listed on the EGL Cafà link Pete provided.

Will you be mixing System i database access with SQL Server database access in the same application? If so, set your primary database connection in the EGL Runtime Data Source (right-click project>Properties), web.xml, EGL Web Build Options (*.eglbld). In the application EAR Deployment Descriptor add the second JDBC provider, data source and properties. In my project the IBM i is the primary database and a secondary database for SQL Server is set using the "WebShere embedded ConnectJDBC driver for MS SQL Server". In an EGL Library part, a connection to the secondary database is established using SQLLib library connect and disconnect functions. This library function then used by the Service part to provide the web service capabilities.

I know this is very high level and doesn't give much to start you project. You might also post the same question on the EGL CafÃ.



message: 1
date: Mon, 22 Feb 2010 15:03:31 -0800
from: "Robert Engelhardt" <rengelhardt@xxxxxxxxxxxxx>
subject: [EGL-i] Wooo Hooo!

Finally! A resource that I can ask dumb questions about EGL and get smart

Here's my challenge:

Create a host of web services that not only access data on the i, but can
also access other DB's (SQL server) using some type of connection stream
(JDBC, ODBC, etc).

Here's my experience:

Senior level developer that has used another 4GL to create web services on
the i (aside from EGL). I have used Rational (RDi for RPG and CLP
programming and just [last week] downloaded and have started to use RBD -
with WAS 7.0 for Developers). I was lucky enough to get WAS 7.0 running on
my PC and start the server, but have no idea how to write in EGL. I have
completed a couple of the tutorials (Hello World jsp and Hello World
service) but NEED MORE!!

Here's what I'd like to get from this forum:

The knowledge of HOW to create web services that will connect to specific
DB's to respond to requestors with specific XML structures (defined by
specs) as the response.

Not too much to ask, eh?



Robert Engelhardt

IBM i Sr. Developer

P.O. Box 2198

Pahrump, NV 89041


Notice of Confidentiality
This e-mail and any attachments thereto are intended only for use by the addressee(s) named herein and may be proprietary and/or legally privileged. If you are not the intended recipient of this e-mail, you are hereby notified that any dissemination, distribution or copying of this email, and any attachments thereto, without the prior written permission of the sender is strictly prohibited. If you receive this email in error, please immediately telephone or email the sender and permanently delete the original copy and any copy of this mail, and any printout thereof.

The contents of an attachment to this email may contain software viruses that could damage your own computer system. While Madico has taken every reasonable precaution to minimize this risk, we cannot accept liability for any damage that you sustain as a result of software viruses. You should carry out your own virus checks before opening any attachment.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 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].