We've developed a couple web applications that use JDBC and Domino to
provide extranet applications for customers. Order inquiry, stock level
inquiry, price inquiry, order entry, etc...
The Domino server runs on the same iSeries as the green screen application
and accesses the live DB2 physical and logical files. Performance has
been excellent, accessing order history data from a PF with 800K records
is typically 1 second or less. It definitely took an investment of time
to learn Java and apply it to Domino, but these applications have been
running for 2+ years with no hiccups. There are many sites that have
sample code, the IBM Java Toolbox for iSeries is where I started and after
some trial and error we got it working.
Glad to provide sample code to anyone...
Bob
JWGrant@xxxxxxxxxxxxxxx
Sent by: domino400-bounces+rlaing=gemko.com@xxxxxxxxxxxx
08/08/2007 11:41 AM
Please respond to
Lotus Domino on the iSeries / AS400 <domino400@xxxxxxxxxxxx>
To
Lotus Domino on the iSeries / AS400 <domino400@xxxxxxxxxxxx>
cc
Subject
Re: DB2 With Domino 8
I am a big fan on running domino on the iSeries. We used to run domino on
windows based servers and it was a big headache.
Unfortunately, with out direct native (iSeries db2 database access) the
product will be relegated to a mail and calendaring platform.
Early on, (several years ago) we developed a web-based application on the
iSeries using LSX and it was very clunky, hard to change and was not very
robust (inquiry only). We do still use LSX and ODBC for batch oriented
uploads of data to DB2. We quickly realized that domino development
(accessing iSeries DB2 applications) was not going to be platform for the
future web based development, (at least on the iSeries)
We were hoping to take a fresh look at it when ND8 provided native access.
Anybody have any insight to why the change in direction?
Jim
Jim W Grant
Sr. Vice-President, Chief Information Officer
Web: www.pdpgroupinc.com
Email: JWGrant@xxxxxxxxxxxxxxx
Office: (410)584-0339
Fax: (410)584-0339
Robert Laing <rlaing@xxxxxxxxx>
Sent by: domino400-bounces+jwgrant=pdpgroupinc.com@xxxxxxxxxxxx
08/08/2007 11:17 AM
Please respond to
Lotus Domino on the iSeries / AS400 <domino400@xxxxxxxxxxxx>
To
Lotus Domino on the iSeries / AS400 <domino400@xxxxxxxxxxxx>
cc
Fax to
Subject
Re: DB2 With Domino 8
I agree that LEI/DECS are not tools to build fully functional applications
around.
We have used JDBC to move data back/forth between Domino and iSeries DB2
and that works well.
Being able to store data directly in DB2 tables is where we should be
heading though. Unfortunate decision by IBM and the Domino blog mentions
that the IBM iSeries crowd bought into that decision -- it would be nice
to hear from the iSeries side to hear the reasons. If DB2 UDB on the
iSeries is drastically different that DB2 on other platforms I can
understand why DB2 implementation on the iSeries is delayed -- but at
least provide a statement of direction...
Bob
JWGrant@xxxxxxxxxxxxxxx
Sent by: domino400-bounces+rlaing=gemko.com@xxxxxxxxxxxx
08/08/2007 11:08 AM
Please respond to
Lotus Domino on the iSeries / AS400 <domino400@xxxxxxxxxxxx>
To
Lotus Domino on the iSeries / AS400 <domino400@xxxxxxxxxxxx>
cc
Subject
Re: DB2 With Domino 8
Also, just wanted to comment; I too am concerned that the iSeries platform
is
being shunned. "Other important database work???? Work arounds include
LEI/DEC?"
We tried using these so called tools and in my opion you can not build
solid
bullet proof applications with work-around tools.
Jim
Jim W Grant
Sr. Vice-President, Chief Information Officer
Web: www.pdpgroupinc.com
Email: JWGrant@xxxxxxxxxxxxxxx
Office: (410)584-0339
Fax: (410)584-0339
"Chris Whisonant" <chris.whisonant@xxxxxxxxx>
Sent by: domino400-bounces+jwgrant=pdpgroupinc.com@xxxxxxxxxxxx
08/07/2007 02:39 PM
Please respond to
Lotus Domino on the iSeries / AS400 <domino400@xxxxxxxxxxxx>
To
"Lotus Domino on the iSeries / AS400" <domino400@xxxxxxxxxxxx>
cc
Fax to
Subject
Re: DB2 With Domino 8
Bob, I'm not sure how I missed that one (since I have that in my RSS
reader...). I'm going to throw in my 2cents now.
Thanks - glad to have some official word.
Chris
On 8/7/07, Robert Laing <rlaing@xxxxxxxxx> wrote:
This blog:
http://www.dominoblog.com/dominoblog/dblog.nsf/dx/faq-on-db2-integration
states that "There are no current plans to provide this feature on
iSeries. We have other very important database work we have committed to
reduce NSF data storage and other database optimizations. These
improvements should help all of our customers, including those on
iSeries."
Many people who have commented on this statement on that blog are not
too
happy with this direction...
Bob
"Chris Whisonant" <chris.whisonant@xxxxxxxxx>
Sent by: domino400-bounces+rlaing=gemko.com@xxxxxxxxxxxx
08/07/2007 02:16 PM
Please respond to
Lotus Domino on the iSeries / AS400 <domino400@xxxxxxxxxxxx>
To
"Lotus Domino on the iSeries / AS400" <domino400@xxxxxxxxxxxx>
cc
Subject
Re: DB2 With Domino 8
I believe DB2 was always intended for applications (whether stated or
not).
You're probably right about 8.0.1.
Chris
On 8/7/07, gregg.eldred@xxxxxxxxxxx <gregg.eldred@xxxxxxxxxxx> wrote:
Chris:
"Are "we" still getting shunned?"
I thought that I heard, and I am probably wrong, that DB2 integration
won't be out until 8.0.1. And even then, it isn't for mail files, but
rather for applications.
I could be wrong, though.
Gregg
_______________________________________________
This is the Lotus Domino on the iSeries / AS400 (Domino400) mailing
list
To post a message email: Domino400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/domino400
or email: Domino400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/domino400.
_______________________________________________
This is the Lotus Domino on the iSeries / AS400 (Domino400) mailing list
To post a message email: Domino400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/domino400
or email: Domino400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/domino400.
_______________________________________________
This is the Lotus Domino on the iSeries / AS400 (Domino400) mailing list
To post a message email: Domino400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/domino400
or email: Domino400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/domino400.
midrange.com
