Part of the issue with database drivers is it seems some of the native stuff appears to not be fully baked. Although XMLSERVICE is pretty good and included with the OS these days.

Sounds like from what I read below is they plan to deprecate XMLSERVICE for something else. I have not researched db2sock or ILEusion to know if they are viable DB access alternatives or just another fun side project.

XMLSERVICE is not perfect but it works pretty well for many things, including .Net on i.

Tony Cairns has retired from IBM. Aaron Bartell has retired from IBMi. They seemed to be the primaries on the DB access stuff so future uncertain.

I'm not sure if there's anyone taking the multi-platform IBMi DB handling mantle. Sent a note to Kevin A and Jesse G the other day with no feedback.

I've been working with the ibmda400 stuff in PASE with .Net. The IBM.DB2.Data .Net DLL had to be hacked and there are still bits that don't work consistently such as stored procedure calling.

XMLSERVICE works well and I got DB2 Connect to database drivers to work for ODBC style access from PASE.

And in the IBM.DB2.Data.DLL hacked version, Calvin (the developer) references in the notes the fact that Tony and Aaron are out of the loop so ibmda400 future is uncertain.

We really need a standard AIX style ibmdb2 layer so .Net can simply use the DB2 driver without outside hacks. (I'm sure it's probably harder to do than I make it sound. Or maybe a cheap/included version of DB2 Connect on i)

Hey Kevin A / Jessie G might be time for a little town hall on open source database access and plans to make life consistent going forward across all the languages...........

I for one would welcome a roadmap.

Regards,
Richard Schoen
Director of Document Management
e. richard.schoen@xxxxxxxxxxxxxxx
p. 952.486.6802
w. helpsystems.com
----------------------------------------------------------------------

message: 1
date: Mon, 10 Dec 2018 13:52:13 +0000
from: Justin Taylor <JUSTIN@xxxxxxxxxxxxx>
subject: Re: [IBMiOSS] XMLSERVICE, RPGLE & Java error

I assumed it was something inherent in the Python -> RPG. I heard a PHP user report the same problem.


Kevin Adler (IBM) posted these updates last week on Ryver:
" The problem is that Java needs to be able to execute code from the heap (that's how JIT works), but since 7.1 the default for PASE applications is to start without stack and heap execution enabled. When you start Java normally, this is fine because they have their own launchers, but not if you've already started PASE in your job...

XMLSERVICE calls programs by starting PASE and using _PGMCALL from PASE to call them, which means that it starts PASE without heap exec enabled, which means that Java can't function properly. "

" For more info, see "4.4.1 PASE for i Stack Execution Disable Support" in the 7.1 Memo to Users "

" I think the fix will come when we move to db2sock/ILEusion instead of XMLSERVICE, since they call the program directly instead of calling in to PASE to call back to ILE... "






As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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

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

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.