RE: Server Jobs

David,

yes I did use JDBC for exactly that purpose, although only in the WebSphere
environment. That took care of the connection pooling, but I don't think
connection pooling is a problem as such; I think a I saw a few references to
"independent" connection pooling classes here in the group. JDBC server jobs
are not Java virtual machines: unless you explicitly spawn additional
threads from your CL command processors, they will always run only one
thread each.   Messaging is not a big problem either. That is, unless you'd
like to have a comprehensive CLP-message-handling class in Java. Use ILE
message percolation feature, intercept messages in the level 1 program of
the stored procedure and return them to the caller (I guess you could even
use a result set for that, but alas, I don't have an example ready).

Lo

-----Original Message-----
From: David Morris [mailto:David.Morris@plumcreek.com]
Sent: 2 ?????? 2002 ?. 16:58
To: java400-l@midrange.com
Subject: RE: Server Jobs


Lo,

JDBC is an interesting idea. I played
around with it some but I ran into some
problems. Have you used JDBC to run
commands? I tried the easy route and
found that I get a new job for each
call. I could build a server using
JDBC, but I am afraid might run into
the same multi-threaded limitation I
found with CommandCall where you can't
run certain commands in a multi-threaded
environment.

During my testing of JDBC to run
commands, I ran into several other
challenges. The first is getting the
messages back from JDBC. How would
you return diagnostic messages and
error messages? I would be interested
in pursuing this idea, but right now
I see an advantage due to built in
pooling, and a disadvange in message
support.

Thanks,

David Morris

>>> Lo.Raikov@MISYS.COM 04/01/02 17:56 PM >>>
Why not use JDBC? It's portable, it's consistent, one is free to use his
preferred connection pooling classes. This "specialized environment "
will
be maintained in the JDBC background job; just use a wrapper technology
to
invoke the CL commands you want on each call.

Lo
_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.