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
0
votes
0 answers

Question about a JDBC Connection Pool overhead which hangs iBMI server

We use JTopen version 7.8 in production to run SQL queries on an iBMI server from a Tomcat server hosted on a LINUX virtual machine. We encountered on 3 occasions a failure that we cannot explain. Our JDBC connection pool is overloaded (120…
edubois
  • 1
0
votes
1 answer

KRBError: KDC cannot accommodate requested option - when Constrained Delegation is Enabled

Having got an SSO solution fully working using Spnego/Kerberos within a Windows Tomcat environment which allows my windows domain user to be used to make a connection to an IBMi via JTOpen which then uses EIM to map my Windows user to an IBM user to…
Merlin
  • 1
0
votes
1 answer

Upgrade of JTOpen throws an error (No suitable driver)

We are using Java applications with JDBC/JTOpen to AS400/IBM i DB2. Currently using JTOpen v.10.5 which works fine. Trying to upgrade to latest v.10.7 but it fails with: java.sql.SQLException: No suitable driver found for…
4integration
  • 193
  • 1
  • 3
  • 13
0
votes
0 answers

How to connect with SecureAS400 using SSL/SSH working example

I work with several IBM i systems. One of them needs me to set an SSH connection before opening an 5250 session. I use the command: ssh -i Keys_rsa L 50023:localhost:23 USER@HOST and after open a 5250 session pointing to IP 127.0.0.1 and it works...…
ALFelix
  • 9
  • 1
  • 4
0
votes
0 answers

IBM i command prompting in JTOpen not working with Java 9 and above

Having compiled my JTOpen application with java 16, I bumped into the following error in the JTOpen command prompter: Exception in thread "AWT-EventQueue-0" java.lang.IllegalAccessError: class com.ibm.as400.ui.framework.java.LookAndFeelManager (in…
Lenny
  • 1
  • 1
0
votes
1 answer

AS400/JDBC/SpringData: [SQL0204] SEQUENCES in SYSCAT type *FILE not found

I'm getting this exception on starting up a SpringBoot app com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL0204] SEQUENCES in SYSCAT type *FILE not found. The problem appears to arise at a call by Hibernate in public…
user4512668
  • 31
  • 5
0
votes
1 answer

java.util.date returns 502 from jtOpen ObjectDescription.RESTORE_DATE

I have the following in jython talking to an AS400: system = AS400(ip, USER, PWORD) obj = ObjectDescription(system, 'qsys','jbrdata', 'lib') d = obj.RESTORE_DATE The object that returns is a java.util.DATE/INT but unlike what i expected its only a…
user2213551
  • 26
  • 1
  • 6
0
votes
1 answer

How to read a PF in QTEMP file using Java API(JTOPEN)

There is a ProgramCall which when run writes a PF in the QTEMP file. I want to access that PF inside the QTEMP but it says CPF3012 FIle not found in QTEMP Library. Since each job has its own QTEMP. Is it possible to track down the PF created in the…
Alok
  • 929
  • 10
  • 26
0
votes
0 answers

How to use connectToPort api of AS400 class in jt400.jar api

I need to connect to as400 system on a specific port. I am using connectToPort method. But it is not connecting. With out using this api, If I just use the AS400 aS400 = new AS400(mHost); aS400.authenticate(user,pwd);// this is successful and…
user2664848
  • 1
  • 3
0
votes
1 answer

How to retrieve only AS400 Enabled Users using jt400 API

is there a possibility to retrieve only the Enabled Users -to add a filter- to the getUsers method of UserList of jt400? I did the following implementation but it does not have a good performance, so I am trying to find a better way and if there is…
Ioanna Katsanou
  • 484
  • 2
  • 7
  • 24
0
votes
1 answer

How to connect to this database where the url starts as "jdbc:as400//..."

I am working on a project where I have to fetch data from a database. I found from the db properties in eclipse, that the url is starting as "jdbc:as400//...". Is there any way other than using IBM.Data.DB2.iSeries. I am using visual studio 2012 to…
Dinesh M Naik
  • 3
  • 2
0
votes
2 answers

JTOpen UserSpace Read

When reading from an IBMi system using a UserSpace object from JTOpen does the data get converted from EBCDIC to ASCII or does it remain in EBCDIC, using the UserSpace.read() methods. If it does is there a way to tell it to not convert it or a…
bullimar
  • 61
  • 1
  • 5
0
votes
1 answer

Get WebFacing library list in Java

I have a com.ibm.as400.access.AS400 object for a WebFacing connection in my application. On the COBOL side, some libraries are added to the library list at the beginning of the program. How do I retrieve them in Java from my AS400 object?
Vulpo
  • 873
  • 1
  • 9
  • 25
0
votes
2 answers

JTOpen JobList filter multiple job names

I'm trying to modify current code such that a JobList.addJobSelectionCriteria using SELECTION_JOB_NAME can take wildcards - is this possible? Documentation for JobList.html#SELECTION_JOB_NAME indicates that the filter String can be "A generic name."…
lasnamuco
  • 3
  • 3
0
votes
1 answer

JT400 - Equivalent to DSPASPBRM in java

I try to read the size of an ASP with the java library JT400. The IBM i (AS400) command to do that is "DSPASPBRM" but I don't find how to do this obtain the same result with the java library. A solution is to call the command and print the result in…
YLombardi
  • 1,755
  • 5
  • 24
  • 45
1 2
3
4