Re: EGL-i Digest, Vol 3, Issue 1

Hi Daron and thanks for the reply...

I will not be mixing access to disparate DB's in the same app, however I don't want to rule out the possibility!

Here's what I need to do in the most simplest terms I can come up with:

I want to write web services (to be consumed) and host them on a WebSphere Application Server to access data from different databases. Each service is specific to it's operation (or purpose) and only accesses one database (although that DB will be SQLServer for some services, and DB2 for others) to retrieve it's data for the response.

I don't have any experience with EGL. I was hoping that EGL was what I needed to use to accomplish the above scenario, but am not sure.

I would be forever grateful if someone could send me a code snippet (in EGL) of a simple service running on WAS that responds with customer information (name, address, etc.), based on a parameter of custID passed in the request. I don't need another "HELLO WORLD"...as this doesn't hit a DB to get it's answer.

Thanks for the instructions in your last email! I believe this is information that points me in the direction that I need to go. I have been corresponding with Mike Virga (EGL Cafà Distance Learning) and he has given me some resources to work with RDB as well.

Thanks to All!

RE

-----Original Message-----
From: egl-i-bounces@xxxxxxxxxxxx [mailto:egl-i-bounces@xxxxxxxxxxxx] On Behalf Of Daron Whitehouse
Sent: Wednesday, February 24, 2010 5:26 AM
To: egl-i@xxxxxxxxxxxx
Subject: Re: [EGL-i] EGL-i Digest, Vol 3, Issue 1

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Ã.

Daron



----------------------------------------------------------------------

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
answers!



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?



HEP ME .HEP ME PLEASE!!!



Thanks!





Robert Engelhardt

IBM i Sr. Developer

P.O. Box 2198

Pahrump, NV 89041

(702)375-1912


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.