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
0
votes
1 answer

JDBC com.ibm.as400.access.AS400JDBCDriver CallableStatement java.sql.SQLException

We have below code using JDBC ODBC bridge to connect to IBM iAccess but since JDK 8 upgrade the support for JDBC ODBC bridge is no longer there. DriverManager.registerDriver((Driver) Class.forName("sun.jdbc.odbc.JDBCODBCDriver").newInstance());…
user2101374
  • 61
  • 1
  • 8
0
votes
0 answers

C3P0, rawConnectionOperation() & java.lang.IllegalArgumentException

I am attempting to use a non-standard method, getServerJobIdentifier(), that is part of the IBM Java Tool Box (jt400.jar) and class com.ibm.as400.access.AS400JDBCConnection with C3P0 & rawConnectionOperation(). I am getting…
Kelly Beard
  • 684
  • 1
  • 8
  • 20
0
votes
0 answers

How to configure the libraries in datasource to connect AS400 with JT400 deployed in Websphere 8.5?

I configured a datasource in Websphere, using JT400.jar And I've specified custom properties: dataSourceName databaseName driver: toolbox libraries: ABC, CDE naming: system packageLibrary: QC Test connection message: When I executed the web…
Diana Ysabel
  • 106
  • 11
0
votes
1 answer

JT400 uses QUSER. Is there a way to change this?

I´m trying to call a RPG-program in a Java application, using the jt400 lib. The call itself is working but the problem is, that the RPG-program uses the userid from the program status data structure to resolve the email adress. Using the JT400 Lib,…
Bashdi
  • 57
  • 8
0
votes
2 answers

Any way to know which operating system the client is connected from?

I am calling STRPCCMD command and passing it some parameters. The command needs to work on linux and windows boxes. Any way to find out which machine the user is connected from in order to build a proper command? Currently I am issuing both and…
Ruslan
  • 1,919
  • 21
  • 42
0
votes
0 answers

Use of function TIMESTAMP_FORMAT in QSYS2 not valid. Data mapping error on member

I am very new in iseries/DB2. We use V7R3. We have table that is generated every day by RPG program as physical file. For accessing the table data from java we use jt400.jar jdbc driver. Most of the table queries work fine but some complex queries…
David Abragimov
  • 524
  • 2
  • 6
  • 24
0
votes
1 answer

jt400 Trunc my where condition as like clause

I'm using jt400-9.3.jar to connect DB2/AS400. My table BAND with this records: +-----|------------------+ | MAT | NAME | +-----|------------------+ |100 | Paul McCartney | |101 | John Lennon | |102 | Ringo Starr | |103 |…
Alisson Gomes
  • 1,029
  • 14
  • 30
0
votes
0 answers

Jdbc batch insert fails all statements after failed statement in Db2 i

I am inserting records in a table in Db2-400 (Db2 i) database using JDBC prepared statement batch. Table has primary key in it. When any statement in batch has duplicate key, then it throws BatchUpdateException (which is expected). But when there is…
Abhishek Tiwari
  • 332
  • 2
  • 16
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
4 answers

AS400 SQL Script on a parameter file returns

I'm integrating an application to the AS400 using Java/JT400 driver. I'm having an issue when I extract data from a parameter file - the data retrieved seems to be encoded. SELECT SUBSTR(F00001,1,20) FROM QS36F."FX.PARA" WHERE K00001 LIKE…
Hetti
  • 45
  • 1
  • 4
0
votes
1 answer

JT400 send a message to a queue (I.e. SNDMSG)

Is this the only option when using jt400 to send a message to a queue? sys = AS400("~") cmd = CommandCall(sys) cmd.run("SNDMSG 'My Message'") The MessageQueue api does not appear to have any sort of send or write method. CommandCall MessageQueue
Cody Ｇ
  • 8,368
  • 2
  • 35
  • 50
0
votes
1 answer

Unable to get classified dependency

In this maven repo I'd like to use the _jdk8 classification. But when I'm using the gradle dependecy declared like this: compile('net.sf.jt400:jt400:9.5:jdk8') It tries to get the file like…
Anders Metnik
  • 6,096
  • 7
  • 40
  • 79
0
votes
1 answer

Getting a specific Jar with gradle

I'm using this repository to get the driver for my database. And using this gradle config: compile('net.sf.jt400:jt400:9.5') I know I can add the specific jar file locally. but is there any way to get gradle to add the jt400-9.5-jt400_jdk8.jar…
Anders Metnik
  • 6,096
  • 7
  • 40
  • 79
0
votes
3 answers

Monitor and handle MSGW messages on a job on an IBM i-series (AS/400) from Java

Does anyone know how one can automatically reply to messages with status MSGW that block a job on an IBM i-series (AS/400)? I'm using the jt400/jtopen library to access a program on an AS/400 from Java. I'm using the com.ibm.as400.access.ProgramCall…
Confusion
  • 16,256
  • 8
  • 46
  • 71
0
votes
2 answers

how to make a springboot webservice for as400 db2 with gradle?

I am trying to make a springboot webservice for as400 db2 with gradle. I have a webservice for sql with grdle. What changes should I make to connect it to DB2400??
Puneet Dewan
  • 55
  • 2
  • 8
1 2 3
…
8 9