Stack Overflow
Stack Overflow

Questions tagged [jt400]

JTOpen is the open source version of the IBM Toolbox for Java licensed program product, and contains the identical code. Both have been tested on a wide variety of platforms, including AIX, IBM i, Linux, Solaris, and Windows.

121 questions
19
votes
5 answers

SQL query of multi-member file on AS400

On AS400 in interactive SQL in a 5250 session, select * from myfile returns rows from one member only when myfile has more than one member. How can I get rows from a specific member? Important: in the end I'd like to do this over JDBC with jt400 so…
tmtest
  • 1,541
  • 3
  • 15
  • 14
9
votes
4 answers

JT400.jar Disable Login Screen

Can anyone help me out? I have small utility application that uses the Jt400-6.7.jar to connect to an AS400 server. Please see the following code private Connection buildConnection(String url, String userName, String password) throws…
Jefrey Valencia
  • 713
  • 3
  • 13
  • 30
7
votes
2 answers

Getting number of rows inserted on IBM DB2 V6R1 (AS400) through JBDC

We migrated recently to newer V6R1 version of DB2 on AS400, we are using Spring framework (v. 2.5.6.) to communicate with the database. We are calling Spring's NamedParameterJdbcTemplate.update() method to insert new rows, this method should return…
ante.sabo
  • 3,141
  • 6
  • 28
  • 36
5
votes
3 answers

AS400.validateSignon() does not reset the failed signon attempts to 0

When I use com.ibm.as400.access.AS400.validateSignon() to authenticate a user's credentials and they pass the validation, and have successfully connected, it does not reset the "failed signon attempts" to 0. When entering an incorrect password the…
Rudi Strydom
  • 334
  • 3
  • 12
4
votes
3 answers

JT400 - Replying to MSGW Job

Is it possible to reply to a MSGW job in AS400 from JT400? I've got the Job element and I can know if it's in MSGW status by Job.MESSAGE_REPLY_WAITING Ex: normally I use "C" via WRKACTJOB
LppEdd
  • 20,274
  • 11
  • 84
  • 139
4
votes
2 answers

Establish connection to db2 using the jt400.jar

I have tried using the db2jcc.jar and I successfully establish connection to db2 but now I am trying to use the jt400.jar I have tried to use the driver com.ibm.db2.jdbc.app.DB2Driver but I keep getting the class not found exception. I tried using…
aeycee
  • 167
  • 2
  • 2
  • 14
4
votes
1 answer

AS/400 Command call - JT400 (Java)

01) I was trying to get IBM/AS400 Serial no using command call method. code is working coz it's nothing given any error or exception. i thing there is something missing. help me to correct it. 02) is there is any way to get AS/400 serial no using…
sheanD
  • 191
  • 5
  • 19
3
votes
0 answers

JDBC AS/400 FETCH FIRST [x] ROWS ONLY not used to discriminate preparedStatement caching

I am using a connection pool to connect to an AS/400. I am trying to fetch a dynamic number of orders with a prepared statement. When I use a statement parameter to define the maximum number of orders to fetch, there seems to be some kind of caching…
Ian Giguère
  • 31
  • 2
3
votes
0 answers

Tomcat memory leak warning - AS400 job threads not getting closed on shutdown/redeploy

I have a spring application running on a Tomcat 8.0 server the following error when either Stopping the server or Redeploying the app on the server. INFO: Closing Spring root WebApplicationContext Jul 25, 2016 10:18:40 AM…
Michael Watson
  • 308
  • 2
  • 11
3
votes
1 answer

Verify connection via AS400

My method must trying to connect to some other DB server. When I run my application on Linux Server - there was all OK. When I run it on Windows OS - I have java.net.SocketTimeoutException: Read timed out private boolean pingServer(String host) { …
Khrystyna Makar
  • 312
  • 4
  • 15
3
votes
1 answer

How to retrieve a specific JobList from the AS400 ?

I'm trying to retrieve a list of active processes that match my criteria. I've already got a working implementation that uses JobList that uses an as400 object: // New as400 object as400Environment = new…
Nathan
  • 266
  • 4
  • 16
3
votes
1 answer

ProgramCallDocument connecting to AS400 from Groovy Hangs

This question is specifically related to the JT400 class ProgramCallDocument, with it's method callProgram(String ProgramName) I've tried wapping the call in a try/catch - but it's not throwing an exception, the debugger goes into the callProgram…
Jason Lowenthal
  • 790
  • 1
  • 5
  • 16
3
votes
2 answers

IFS file copy using JT400 in code

I have this piece of code that would copy files from IFS to a local drive. And I would like to ask some suggestions on how to make it better. public void CopyFile(AS400 system, String source, String destination){ File destFile = new…
aEtherv0id
  • 31
  • 1
  • 2
2
votes
3 answers

JT400 - JDBC connection refused from IBMi machine but working from Windows machine

JT400 - The JDBC connection is working fine when connecting to a IBMi machine from windows machine. DriverManager.registerDriver(new com.ibm.as400.access.AS400JDBCDriver()); String sysname = "xxx.xxx.xx.xxx"; String xref = "IBMISQLLIB"; String url =…
Kishore_2021
  • 645
  • 12
  • 38
2
votes
1 answer

JT400 - Work with Media Information (WRKMEDIBRM)

Does anyone know how to work with AS400 media ( Tapes ) in JT400 Java. I need to get the tape details via a Java program. ( WRKMEDIBRM ) Thanks Buddhika
Buddhika
  • 577
  • 2
  • 6
  • 20
1
2 3
…
8 9