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
1
vote
2 answers

Give some examples of TCP Connection Status in JT400 - JAVA

I'm tried to get AS400 TCP Connection Status. but i'm failed :( can anyone help me to do this. i'm new to JT400 java development. please help me friends. i want to get IP address of a job i want to get TCP Connection Status using that (1) IP…
Dzshean
  • 314
  • 6
  • 23
1
vote
1 answer

How to get as400 (jt400) Sign on User List

I'm developing IBM AS400 Client Access Software. I'm trying to get Sign on User List. there are have more than 70 sign on Users, but my code give me only 6 User Details. Can anyone help me to do this Friends.. My Code : try { AS400 system =…
Dzshean
  • 314
  • 6
  • 23
1
vote
1 answer

Multiple members in a file with a blob

I would like to model a simple "name->blob" structure to be used from Java using jt400.jar (essentially to store large, unchanging files inside the database instead of in the IFS) which is easily done with a CREATE TABLE TRATEST/X (NAME VARCHAR (256…
Thorbjørn Ravn Andersen
  • 73,784
  • 33
  • 194
  • 347
1
vote
2 answers

Create a Spooled File from Java with a specified Job name on iSeries

Is there a way to specifiy the JOB name when creating a spooled file? So that my created s.f. doesn't have the default "QPRTJOB". My method that creates a spooled file with the default QPRTJOB job: public static SpooledFile createSpoolFile(…
davorp
  • 4,156
  • 3
  • 26
  • 34
1
vote
2 answers

Firing DB2/OS/400 Trigger from Java/JT400 SQL Statement

In my OS/400 v6.x system I created an AFTER INSERT trigger for a physical file (DB2 table) using the ADDPFTRG command which is fired correctly everytime I execute a WRITE command on an RPG IV program or make an INSERT statement from the STRSQL but…
Roberto Linares
  • 2,215
  • 3
  • 23
  • 35
0
votes
4 answers

Why am I getting a permission denied with JDBC and Netbeans?

We are three developers all working with Netbeans and Java. One developer can access the remote DB2 server just fine (using the same code). The other two (which includes me) can not. Here is the context.xml file:
cbmeeks
  • 11,248
  • 22
  • 85
  • 136
0
votes
0 answers

Maintain AS400ConnectionPool for multiple use

Java, Spring, jt400 [AS400] I have working WAR at server. At this moment, my endpoint opens connection to AS400, retrieve data and gives it as response. Yet, I would like to do some time optimization. I did a Bean declaration at @Configuration that…
Nevras
  • 11
  • 2
0
votes
2 answers

AS400 IBM Toolbox for Java doesn't have classes to read Journal in the latest version of Jar JTOpen 400

JTOpen - The IBM Toolbox for Java: In the JT400 jar version 20.0.0 JTOpenlite (com.ibm.jtopenlite.command.program.journal) package is deprecated which has the classes to read the Journal classes…
CodeKat
  • 1
  • 1
0
votes
0 answers

Using JT400, how do I download a PrintObjectTransformedInputStream pdf file to my desktop?

I am writing a program in Java using JT400. The program downloads certain spool files from AS400 to the client machine. The process is roughly thus: Connect Access specific user's spool files Loop through files until specific spool file…
Logan Price
  • 73
  • 7
0
votes
0 answers

Java - JT400 - Reference Existing Spool File

I am using JT400 to search our AS400 system for a specific pre-existing spool file based on the following parameters: Username File name Date created (ability to use date range as well) How would I go about this? If I create a new SpooledFile…
Logan Price
  • 73
  • 7
0
votes
1 answer

Java 8 Time API - DB2/400 / JT400

I'm currently upgrading an application that uses DB2/400 database, and I'm migrating to the new java time api (LocalDate, LocalTime, ...), using the latest version of jt400.jar. However, when executing statement setObject as…
areal
  • 157
  • 5
0
votes
0 answers

Connection to IBM DB2 in AS400 using JT400 throws Connection was dropped unexpectedly

I'm trying to connect to an IBM DB2 in AS400 using JT400 driver but it thows Connection was dropped unexpectedly exception. My application.properties : I even tryed it with the hardcode way : I just have a question, is this error is related to…
Alae Essaki
  • 68
  • 7
0
votes
1 answer

PreparedStatement Update with case

import java.sql.PreparedStatement; myQuery = "UPDATE File SET BCN = ?, BLN = ?, BID = ?, DATE2 = (CASE WHEN parmDate <> 0 AND DATE2 = 0 THEN parmDate ELSE…
Kay
  • 53
  • 6
0
votes
2 answers

use Quarkus and Hibernate with db2/400

I'm trying to use Quarkus Hibernate ORM with db2 on an IBM i running V7R3 On startup Quarkus seem to not find org.hibernate.dialect.DB2400V7R3Dialect class It is available as part of Hibernate I have jt400 as a dependency in my pom for the DB2/400…
Christopher Smith
  • 197
  • 1
  • 18
0
votes
2 answers

What is UPCRTD attribute in IBMi AS400?

Could anyone tell me what is does UPCRTD attribute mean in IBMi AS400 system? I guess this is a user profile creation date-time, but I didn't find any official documentation which simply says, that UPCRTD means user profile creation date time. Can…
Anand Dhage
  • 109
  • 17
1 2 3
…
8 9