× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. JAVA400-L
  3. May 2004

Re: JAVA400-L Digest, Vol 2, Issue 175

Stefan,

The only connectivity option I have other than 5250 is WebSphere Development
Studio for iSeries and it gives me the same sort of errors.

I got a good tip that this might be related to the host server user index so
I'm working in that direction now.

Thanks,
Tony


----- Original Message ----- 
From: <java400-l-request@xxxxxxxxxxxx>
To: <java400-l@xxxxxxxxxxxx>
Sent: Friday, May 28, 2004 1:00 PM
Subject: JAVA400-L Digest, Vol 2, Issue 175


> Send JAVA400-L mailing list submissions to
> java400-l@xxxxxxxxxxxx
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://lists.midrange.com/mailman/listinfo/java400-l
> or, via email, send a message with subject or body 'help' to
> java400-l-request@xxxxxxxxxxxx
>
> You can reach the person managing the list at
> java400-l-owner@xxxxxxxxxxxx
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of JAVA400-L digest..."
>
>
> Today's Topics:
>
>    1. The application requester cannot establish the connection.
>       (Not able to pass connection to server job. Unknown or
>       unrecoverable error occured.) (Tony Richardson)
>    2. Re: The application requester cannot establish the
>       connection. (Not able to pass connection to server job. Unknown
>       or unrecoverable error occured.) (Stefan Tageson)
>
>
> ----------------------------------------------------------------------
>
> message: 1
> date: Thu, 27 May 2004 13:45:41 -0400
> from: "Tony Richardson" <trichardson@xxxxxxxxxx>
> subject: The application requester cannot establish the connection.
> (Not able to pass connection to server job. Unknown or unrecoverable
> error occured.)
>
> We just installed a new iSeries 810 at v5r2, and I'm having a terrible
time getting a database or signon(AS400 object) connection.
>
> We have several web applications that reside on a pc Linux server running
Tomcat that use the toolbox to connect to the iSeries. After we got the 810
up and running, I restarted the tomcat server and couldn't not connect. My
first thought was some of the required services were not running on the
iSeries. So, I did a STRHOSTSVR *ALL and STRTCPSVR *ALL and I still can't
connect through jdbc or the AS400 object.
>
> Out of frustration I assumed it was something with my applications so I
attempted to setup a db server in WDSC for iSeries and it will not connect
or allow me to signon through the remote system explorer.
>
> After all this I wrote a couple of simple test classes with a trace that
would try to pull data back through jdbc and rla. The trace is listed below.
>
> As a work around I setup a tomcat instance natively on the new iSeries,
and I can get a jdbc connection to the database; however, none of my
business classes that use the AS400 object can connect.
>
> Any ideas would be appreciated as I'm the only iSeries Java developer in
house.
>
>
> The trace output:
> Toolbox for Java - Open Source Software, JTOpen 4.3, codebase 5722-JC1
V5R3M0.1
> Thu May 27 10:42:31 EDT 2004  as400: Properties  (13799530) : access =
"all".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : block size =
"32".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : block
criteria = "2".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : date format
= "".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : date
separator = "".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : decimal
separator = "".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : errors =
"basic".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : extended
dynamic = "false".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : libraries =
"".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : naming =
"sql".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : package =
"".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : package add
= "true".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : package
cache = "false".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : package
clear = "false".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : package
error = "warning".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : package
library = "".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : password =
"".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : prefetch =
"true".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : prompt = "".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : remarks =
"system".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : sort =
"job".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : sort
language = "ENU".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : sort table =
"".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : sort weight
= "shared".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : time format
= "".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : time
separator = "".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : trace =
"false".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : transaction
isolation = "read uncommitted".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : translate
binary = "false".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : user =
"webappstst".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : package
criteria = "default".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : lob
threshold = "32768".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : secure =
"false".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : data
truncation = "true".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : proxy server
= "".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : secondary
URL = "".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : data
compression = "true".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : big decimal
= "true".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : thread used
= "true".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : cursor hold
= "true".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : lazy close =
"false".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : driver =
"toolbox".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : bidi string
type = "".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : key ring
name = "".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : key ring
password = "".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : full open =
"false".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : server trace
= "0x00".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : database
name = "".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : extended
metadata = "false".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : cursor
sensitivity = "asensitive".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : behavior
override = "0x00".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : package
ccsid = "13488".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : minimum
divide scale = "0".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : maximum
precision = "31".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : maximum
scale = "31".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : translate
hex = "character".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : toolbox
trace = "".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : qaqqinilib =
"".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : login
timeout = "".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : true
autocommit = "false".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : bidi
implicit reordering = "true".
> Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : bidi numeric
ordering = "false".
> Thu May 27 10:42:32 EDT 2004  as400: Driver AS/400 Toolbox for Java JDBC
Driver (10053659) : Using IBM Toolbox for Java JDBC driver implementation.
> Thu May 27 10:42:32 EDT 2004  Getting system property:
'com.ibm.as400.access.AS400.proxyServer'
> Thu May 27 10:42:32 EDT 2004  Value found in system properties:  'null'
> Thu May 27 10:42:32 EDT 2004  Value found in jt400.properties file: 'null'
> Thu May 27 10:42:32 EDT 2004  Value not found.
> Thu May 27 10:42:32 EDT 2004  Detected os.name: Windows XP
> Thu May 27 10:42:32 EDT 2004  Constructing AS400 object, system name:
'XXX.XXX.XX.XXX' user ID: 'webappstst'
> Thu May 27 10:42:32 EDT 2004  Getting system property:
'com.ibm.as400.access.AS400.proxyServer'
> Thu May 27 10:42:32 EDT 2004  Value found in system properties:  'null'
> Thu May 27 10:42:32 EDT 2004  Value found in jt400.properties file: 'null'
> Thu May 27 10:42:32 EDT 2004  Value not found.
> Thu May 27 10:42:32 EDT 2004  Connecting service:  4
> Thu May 27 10:42:32 EDT 2004  Setting up AS400 implementation object:
> Thu May 27 10:42:32 EDT 2004    Enable SSL connections: null
> Thu May 27 10:42:32 EDT 2004    Native optimizations allowed:  false
> Thu May 27 10:42:32 EDT 2004    Use threaded communications:  true
> Thu May 27 10:42:32 EDT 2004    User specified CCSID:  0
> Thu May 27 10:42:32 EDT 2004    Locale: en_US
> Thu May 27 10:42:32 EDT 2004    Socket properties:
com.ibm.as400.access.SocketProperties@1d80e6d
> Thu May 27 10:42:32 EDT 2004    DDM RDB: null
> Thu May 27 10:42:32 EDT 2004  User ID: 'WEBAPPSTST'
> Thu May 27 10:42:32 EDT 2004  Signing-on with prompting turned on.
> Thu May 27 10:42:32 EDT 2004  Validate security...
> Thu May 27 10:42:32 EDT 2004  Signing-on without prompting...
> Thu May 27 10:42:32 EDT 2004  Opening a socket to verify security...
> Thu May 27 10:42:32 EDT 2004  Connecting to port mapper...
> Thu May 27 10:42:32 EDT 2004  Sending port mapper request...
> Thu May 27 10:42:32 EDT 2004  Data stream sent...
> 61 73 2D 73 69 67 6E 6F 6E
> Thu May 27 10:42:32 EDT 2004  Receiving port mapper reply...
> Thu May 27 10:42:33 EDT 2004  Data stream data received...
> 2B 00 00 21 1C
> Thu May 27 10:42:33 EDT 2004  Adding entry to Service Port table: system
XXX.XXX.XX.XXX, service as-signon, port 8476
> Thu May 27 10:42:33 EDT 2004  Opening socket to server...
> Thu May 27 10:42:33 EDT 2004  Setting socket options...
> Thu May 27 10:42:33 EDT 2004  Socket properties:
> Thu May 27 10:42:33 EDT 2004      Remote address: /XXX.XXX.XX.XXX
> Thu May 27 10:42:33 EDT 2004      Remote port:  8476
> Thu May 27 10:42:33 EDT 2004      Local address: /XXX.XXX.XX.XXX
> Thu May 27 10:42:33 EDT 2004      Local port:  2030
> Thu May 27 10:42:33 EDT 2004      Keep alive:  false
> Thu May 27 10:42:33 EDT 2004      Receive buffer size:  8192
> Thu May 27 10:42:33 EDT 2004      Send buffer size:  8192
> Thu May 27 10:42:33 EDT 2004      So linger:  -1
> Thu May 27 10:42:33 EDT 2004      So timeout:  0
> Thu May 27 10:42:33 EDT 2004      TCP no delay:  false
> Thu May 27 10:42:33 EDT 2004  Starting an inet socket to as-signon
> Thu May 27 10:42:33 EDT 2004  Sending signon server exchange client/server
attributes request...
> Thu May 27 10:42:33 EDT 2004  Data stream sent...
> 00 00 00 34 00 00 E0 09 00 00 00 00 00 00 00 00
> 00 00 70 03 00 00 00 0A 11 01 00 00 00 01 00 00
> 00 08 11 02 00 02 00 00 00 0E 11 03 00 00 00 FC
> C6 E9 8B E0
> Thu May 27 10:42:33 EDT 2004  Receiving signon server exchange
client/server attributes reply...
> Thu May 27 10:42:33 EDT 2004  Data stream data received...
> 00 00 00 18 00 00 00 00 00 00 00 00 00 00 00 00
> 00 04 00 00
> Thu May 27 10:42:33 EDT 2004  Data stream data received...
> 00 04 00 08
> Thu May 27 10:42:33 EDT 2004  Signon server exchange client/server
attributes failed, return code:
> 00 04 00 08
> java.lang.Throwable
>  at com.ibm.as400.access.Trace.log(Trace.java:944)
>  at com.ibm.as400.access.Trace.log(Trace.java:869)
>  at
com.ibm.as400.access.AS400ImplRemote.signonConnect(AS400ImplRemote.java:1913
)
>  at com.ibm.as400.access.AS400ImplRemote.signon(AS400ImplRemote.java:1794)
>  at com.ibm.as400.access.AS400.sendSignonRequest(AS400.java:2603)
>  at com.ibm.as400.access.AS400.promptSignon(AS400.java:2049)
>  at com.ibm.as400.access.AS400.signon(AS400.java:3339)
>  at com.ibm.as400.access.AS400.connectService(AS400.java:805)
>  at
com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.j
ava:2672)
>  at
com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.java:
911)
>  at
com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDriver.ja
va:802)
>  at com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:355)
>  at java.sql.DriverManager.getConnection(DriverManager.java:512)
>  at java.sql.DriverManager.getConnection(DriverManager.java:171)
>  at TestDB.main(TestDB.java:39)
> Thu May 27 10:42:33 EDT 2004  Signon server exchange client/server
attributes failed:
> com.ibm.as400.access.ServerStartupException: Not able to pass connection
to server job.  Unknown or unrecoverable error occured.
>  at
com.ibm.as400.access.AS400ImplRemote.returnSecurityException(AS400ImplRemote
.java:1596)
>  at
com.ibm.as400.access.AS400ImplRemote.signonConnect(AS400ImplRemote.java:1914
)
>  at com.ibm.as400.access.AS400ImplRemote.signon(AS400ImplRemote.java:1794)
>  at com.ibm.as400.access.AS400.sendSignonRequest(AS400.java:2603)
>  at com.ibm.as400.access.AS400.promptSignon(AS400.java:2049)
>  at com.ibm.as400.access.AS400.signon(AS400.java:3339)
>  at com.ibm.as400.access.AS400.connectService(AS400.java:805)
>  at
com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.j
ava:2672)
>  at
com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.java:
911)
>  at
com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDriver.ja
va:802)
>  at com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:355)
>  at java.sql.DriverManager.getConnection(DriverManager.java:512)
>  at java.sql.DriverManager.getConnection(DriverManager.java:171)
>  at TestDB.main(TestDB.java:39)
> Thu May 27 10:42:33 EDT 2004  as400: Connection null (26440236) : Throwing
exception. Original exception: .com.ibm.as400.access.ServerStartupException:
Not able to pass connection to server job.  Unknown or unrecoverable error
occured.
>  at
com.ibm.as400.access.AS400ImplRemote.returnSecurityException(AS400ImplRemote
.java:1596)
>  at
com.ibm.as400.access.AS400ImplRemote.signonConnect(AS400ImplRemote.java:1914
)
>  at com.ibm.as400.access.AS400ImplRemote.signon(AS400ImplRemote.java:1794)
>  at com.ibm.as400.access.AS400.sendSignonRequest(AS400.java:2603)
>  at com.ibm.as400.access.AS400.promptSignon(AS400.java:2049)
>  at com.ibm.as400.access.AS400.signon(AS400.java:3339)
>  at com.ibm.as400.access.AS400.connectService(AS400.java:805)
>  at
com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.j
ava:2672)
>  at
com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.java:
911)
>  at
com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDriver.ja
va:802)
>  at com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:355)
>  at java.sql.DriverManager.getConnection(DriverManager.java:512)
>  at java.sql.DriverManager.getConnection(DriverManager.java:171)
>  at TestDB.main(TestDB.java:39)
>
> Thu May 27 10:42:33 EDT 2004  as400: Connection null (26440236) : Throwing
exception.  Actual exception: The application requester cannot establish the
connection. (Not able to pass connection to server job.  Unknown or
unrecoverable error occured.) sqlState: 08001 vendor
code -99999.java.sql.SQLException: The application requester cannot
establish the connection. (Not able to pass connection to server job.
Unknown or unrecoverable error occured.)
>  at com.ibm.as400.access.JDError.throwSQLException(JDError.java:521)
>  at
com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.j
ava:2680)
>  at
com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.java:
911)
>  at
com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDriver.ja
va:802)
>  at com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:355)
>  at java.sql.DriverManager.getConnection(DriverManager.java:512)
>  at java.sql.DriverManager.getConnection(DriverManager.java:171)
>  at TestDB.main(TestDB.java:39)
>
> dumping sqle
> java.sql.SQLException: The application requester cannot establish the
connection. (Not able to pass connection to server job.  Unknown or
unrecoverable error occured.)
>  at com.ibm.as400.access.JDError.throwSQLException(JDError.java:521)
>  at
com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.j
ava:2680)
>  at
com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.java:
911)
>  at
com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDriver.ja
va:802)
>  at com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:355)
>  at java.sql.DriverManager.getConnection(DriverManager.java:512)
>  at java.sql.DriverManager.getConnection(DriverManager.java:171) The error
was The application requester cannot establish the connection. (Not able to
pass connection to server job.  Unknown or unrecoverable error occured.)
>
>  at TestDB.main(TestDB.java:39)
>
> Thanks,
>
>
> Tony Richardson
> AS/400 Developer
> JAS Forwarding (USA), Inc.
> One Ravinia Drive, Suite 650
> Atlanta GA, 30346
> Tel: (770) 688-1260
> Fax: (770) 688-1229
> Web: www.jasusa.com
>
> ------------------------------
>
> message: 2
> date: Thu, 27 May 2004 20:10:07 +0200
> from: Stefan Tageson <Stefan.Tageson@xxxxxxxxxxx>
> subject: Re: The application requester cannot establish the
> connection. (Not able to pass connection to server job. Unknown or
> unrecoverable error occured.)
>
> Tony,
>
> What kind of connectivity DO you have?
> Can you connect using iSeries Navigator?
> Management Central?
>
> Stefan Tageson
> Intentia Consulting Sverige AB
> Propellergatan 1, SE-211 19 Malmö, Sweden
> Phone: +46 (0)40 691 35 00
> Cell: +46 (0)733 913 813
> Fax: +46 (0)40 691 3900
> E-mail: stefan.tageson@xxxxxxxxxxx
>
>
>
> ------------------------------
>
> _______________________________________________
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
digest list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>
>
>
> End of JAVA400-L Digest, Vol 2, Issue 175
> *****************************************
>

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.