Stack Overflow
Stack Overflow

Questions tagged [jtopen]

jtopen is an open source version of the IBM Toolbox for Java (jt400) for using IBM i (previously iSeries and AS/400) system resources.

The jtopen software is an open source version (IBM Public License) of IBM's licensed software IBM Toolbox for Java. It is produced by the same team that produces the licensed software and generally gets updates and new features before the licensed software (PTF's).

More information can be found on the project's Sourceforge page.

50 questions
1
vote
2 answers

Returning arbitrary binary data from RPG program

Let's say I have this program interface d PgmText pi d outInfo 65535 d pgmName 10 const d pgmLibrary 10 const I'm calling it through JTOpen, which then reads the data…
LppEdd
  • 20,274
  • 11
  • 84
  • 139
1
vote
1 answer

IBM i RPG programs are referencing the wrong library after calling them using a JT400 connection pool

I have a Java application that calls CL programs, which then run several RPG programs on an IBM i system, using the JT400 library. At first, i opened a new connection each time, like this and closed it when done: new AS400(hostname, username,…
Carrier Pigeon Protocol
  • 1,285
  • 1
  • 5
  • 8
1
vote
0 answers

How to specify a local custom SSL truststore for JTOpen?

We have a java client (mule app) which is using JTOpen for connecting to the AS400 system. The connection is secured with SSL. The driver is using the JRE truststore (jssecacerts, cacerts) by default. We would like to specify a custom truststore…
spoonboy
  • 2,570
  • 5
  • 32
  • 56
1
vote
2 answers

AS400FileRecordDescription.retrieveRecordFormat error out on secured connection

The main purpose of the java program below is to use the AS400FileRecordDescription class from the jtopen (version 9.6) to retrieve the record format of a physical file on iseries. It does that by calling the retrieveRecordFormat() method in this…
HockChai Lim
  • 1,675
  • 2
  • 20
  • 30
1
vote
1 answer

Calling i-series program from Java yields invalid output

I'm using the jtopen/jt400 toolkit to call programs on an IBM i-series r5v4 (aka AS/400) from Java (actually: JRuby, but I've seen the same problem in pure Java). This works just fine for some programs, while for other programs, the output bytes…
Confusion
  • 16,256
  • 8
  • 46
  • 71
1
vote
3 answers

Why does Netbeans 8.1 database results not allow CrUD or "Show SQL" operations when using JTOpen on a DB2 database?

Anyone know why the Netbeans IDE's Database result explorer disables CrUD operations and "Show SQL 'CrUD' Operation" when using a JDBC connection via JTOpen 9.1 driver to a DB2 for i database with Netbeans 8.1? JTOpen is a open source JDBC driver to…
PHPDave
  • 904
  • 1
  • 7
  • 15
1
vote
5 answers

Get last changed date of AS400 DDS file in Java

Hello I'm working with Java connecting to an IBM AS400. I want to read the timestamp of the last change of a DDS file, e.g. the timestamp of the last SQL operation (INSERT INTO MyLib/MyDDS VALUES (...)). In the 5250 terminal, I can go to "work with…
KeKru
  • 444
  • 3
  • 13
1
vote
1 answer

JT400 Read File From IFS with user without password

our problem is the following: We have to connect to an ISeries with the JT400 and read a file in the IFS. One requirement is the job is running in the QBatch with a user without password. Our code is the following: //This wy we connect to the…
Juan
  • 229
  • 2
  • 6
  • 20
1
vote
0 answers

JT400 SpooledFile to TIFF zoom level

I am trying to convert AFPDS spooled files to TIFF images. No problem, unless the original spooled file spills outside the printable area. In the iSeries Navigator, I can zoom out and see the content that spilled over. I am desperately seeking a…
John Kuhns
  • 506
  • 4
  • 20
1
vote
1 answer

Need to get Object's creation date and time from AS400 in Java application

I am trying to get information about created date and time for a set of objects in AS400. I have created an outfile using DSPOBJD in AS400. Below is code snippet for getting information about one object. Now, after this i will have to open…
true_programmer
  • 43
  • 1
  • 9
1
vote
3 answers

Is it possible to return a list of objects from the AS400 using Java?

I'm trying to retrieve a list of Objects (no matter what type) from the AS400 based upon a Library name. I have tried to use WRKOBJ LibName/*all through a command call but the errors recieved back advise I am unable to use the command WRKOBJ in…
Nathan
  • 266
  • 4
  • 16
1
vote
1 answer

How to enable LIMIT for DB2 on AS400 via JDBC?

I'd like to use the LIMIT clause to do paging on DB2. The DB2 is hosted on AS400 and I'm accessing it via JDBC over JTOpen. In Paging through result sets using LIMIT and OFFSET or ROWNUM I learned that I can put DB2 into an MySql compatibility by…
BetaRide
  • 16,207
  • 29
  • 99
  • 177
1
vote
0 answers

DB2 AS/400 jtopen-7.1 DatabaseMetaData changes

I am connecting to DB2 AS 400 V6R1m0 using jt400 7.1 driver. In 7.1 driver IBM have made changes in Database metadata methods. One such change is allowing user to get table-names on the current schema using the ‘*USRLIBL’ keyword . The…
Muruga
  • 123
  • 2
  • 7
1
vote
2 answers

Calling Java from RPG, ClassNotFoundError for all user except me

I would highly appreciate your help with a ClassNotFoundError while calling a Java method from RPG. This happens when any other user, except me, tries to run my program. It literally seems a problem with CLASSPATH or access to jar files but I tried…
tewemit
  • 43
  • 4
1
vote
2 answers

using native jdbc driver on as400

I usually use AS400JDBCDriver to connect to AS400 and work with the DB and this works fine both inside and outside AS400. Now I've developed a class that will run on AS400 and access the DB, but the customer doesn't want to provide credential to…
user1805879
  • 61
  • 1
  • 7
1
2
3 4