× 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. MIDRANGE-L
  3. August 2016

Re: ARDGATE connecting to MS SQL

I have tried a bunch of different values with the same result.
I have browsed through documents in Google as well as the install document
but cannot find anything similar.

The problem appears to be the user id and password and I do not know how to
correct this.

Here is the log :

-------------------------------------------

2016-08-22 21:21:44,495 INFO [main]
de.bender_dv.jvagate.communication.Receiver: GlobalProps loaded
2016-08-22 21:21:44,615 INFO [main]
de.bender_dv.jvagate.communication.Receiver: connected to DTAQ DataQueue
(system: AS400 (system name: 'localhost' user ID:
'*CURRENT'):com.ibm.as400.access.AS400@e520e52 path:
/QSYS.LIB/JVAGATE.LIB/JAVAQ.DTAQ):com.ibm.as400.access.DataQueue@78307830
2016-08-22 21:21:45,841 INFO [main]
de.bender_dv.jvagate.communication.Receiver: getOrder
2016-08-22 21:23:48,087 INFO [main]
de.bender_dv.jvagate.communication.Receiver: getOrder
2016-08-22 21:23:48,087 INFO [pool-1-thread-1]
de.bender_dv.jvagate.communication.Sender: $$$$$ R649773 $$$$$
2016-08-22 21:23:48,087 INFO [pool-1-thread-1]
de.bender_dv.jvagate.communication.Sender: Event ARDPGM
2016-08-22 21:23:48,107 INFO [pool-1-thread-1]
de.bender_dv.jvagate.communication.Request: Event set to: ARDPGM
2016-08-22 21:23:48,108 DEBUG [pool-1-thread-1]
de.bender_dv.ardgate.application.ArdHandler: Request:
de.bender_dv.jvagate.communication.Request@60666066
2016-08-22 21:23:48,110 DEBUG [pool-1-thread-1]
de.bender_dv.ardgate.pords2pojo.ArdInFormat: interfaceLevel: 1
2016-08-22 21:23:48,126 DEBUG [pool-1-thread-1]
de.bender_dv.ardgate.pords2pojo.ArdInFormat: inFormatName: ARCN0100
2016-08-22 21:23:48,126 DEBUG [pool-1-thread-1]
de.bender_dv.ardgate.pords2pojo.ArdInFormat: lengthOfInFormat: 106
2016-08-22 21:23:48,127 INFO [pool-1-thread-1]
de.bender_dv.ardgate.application.ArdHandler: Format: ARCN0100 ArdGate
Version: 2014-09-17
2016-08-22 21:23:48,147 DEBUG [pool-1-thread-1]
de.bender_dv.ardgate.application.FormatHandlerFactory: Name: ARCN0100
2016-08-22 21:23:48,154 DEBUG [pool-1-thread-1]
de.bender_dv.ardgate.pords2pojo.GenericArFormat: outBufferSize: 16776559
2016-08-22 21:23:48,154 INFO [pool-1-thread-1]
de.bender_dv.ardgate.pords2pojo.GenericArFormat: ***** AXTRN01 :2
*****
2016-08-22 21:23:48,154 DEBUG [pool-1-thread-1]
de.bender_dv.ardgate.pords2pojo.ARCN0100Format: deviceName:
2016-08-22 21:23:48,154 DEBUG [pool-1-thread-1]
de.bender_dv.ardgate.pords2pojo.ARCN0100Format: modeName:
2016-08-22 21:23:48,154 DEBUG [pool-1-thread-1]
de.bender_dv.ardgate.pords2pojo.ARCN0100Format: remoteLoc: *ARDPGM
2016-08-22 21:23:48,155 DEBUG [pool-1-thread-1]
de.bender_dv.ardgate.pords2pojo.ARCN0100Format: localLoc:
2016-08-22 21:23:48,155 DEBUG [pool-1-thread-1]
de.bender_dv.ardgate.pords2pojo.ARCN0100Format: remoteNetId:
2016-08-22 21:23:48,155 DEBUG [pool-1-thread-1]
de.bender_dv.ardgate.pords2pojo.ARCN0100Format: tpnName:
2016-08-22 21:23:48,155 DEBUG [pool-1-thread-1]
de.bender_dv.ardgate.pords2pojo.ARCN0100Format: productId: QSQ05040
2016-08-22 21:23:48,156 DEBUG [pool-1-thread-1]
de.bender_dv.ardgate.pords2pojo.ARCN0100Format: userId: CCAXAX
2016-08-22 21:23:48,156 DEBUG [pool-1-thread-1]
de.bender_dv.ardgate.pords2pojo.ARCN0100Format: password: Ixxxxxx35
2016-08-22 21:23:48,156 DEBUG [pool-1-thread-1]
de.bender_dv.ardgate.pords2pojo.ARCN0100Format: Level: 1
2016-08-22 21:23:48,164 DEBUG [pool-1-thread-1]
de.bender_dv.ardgate.database.ArdConnection: url: jdbc:jtds:sqlserver://
10.77.76.40
2016-08-22 21:23:48,173 DEBUG [pool-1-thread-1]
de.bender_dv.ardgate.database.ArdConnection: driver:
net.sourceforge.jtds.jdbc.Driver
2016-08-22 21:23:48,325 ERROR [pool-1-thread-1]
de.bender_dv.ardgate.database.ArdConnection: failed!
java.sql.SQLException: Login failed for user 'CCAXAX'.
at
net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:603)
at
net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:345)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
at java.sql.DriverManager.getConnection(DriverManager.java:572)
at java.sql.DriverManager.getConnection(DriverManager.java:165)
at
de.bender_dv.ardgate.database.ArdConnection.connectDatabase(ArdConnection.java:166)
at
de.bender_dv.ardgate.database.ArdConnection.connect(ArdConnection.java:131)
at
de.bender_dv.ardgate.application.ARCN0100Handler.getOutFormat(ARCN0100Handler.java:62)
at
de.bender_dv.ardgate.application.ArdHandler.performWork(ArdHandler.java:45)
at de.bender_dv.jvagate.communication.Sender.run(Sender.java:109)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:693)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:719)
at java.lang.Thread.run(Thread.java:813)
2016-08-22 21:23:48,333 INFO [pool-1-thread-1]
de.bender_dv.ardgate.pords2pojo.SqlcaBean: SQLCode: -113
2016-08-22 21:23:48,333 INFO [pool-1-thread-1]
de.bender_dv.ardgate.pords2pojo.SqlcaBean: SQLState: 28000
2016-08-22 21:23:48,334 INFO [pool-1-thread-1]
de.bender_dv.ardgate.pords2pojo.SqlcaBean: Login failed for user 'CCAXAX'.
2016-08-22 21:23:48,334 DEBUG [pool-1-thread-1]
de.bender_dv.ardgate.pords2pojo.SqlcaBean: sqlErrd3 0
2016-08-22 21:23:48,334 ERROR [pool-1-thread-1]
de.bender_dv.ardgate.database.ArdConnection: CCAXAX not connected to
AXTRN01 jdbc:jtds:sqlserver://10.77.76.40
2016-08-22 21:23:48,335 ERROR [pool-1-thread-1]
de.bender_dv.ardgate.database.ArdConnection: SQLCode: 18456 SQLState: 28000
2016-08-22 21:23:48,335 ERROR [pool-1-thread-1]
de.bender_dv.ardgate.database.ArdConnection: Login failed for user 'CCAXAX'.
2016-08-22 21:23:48,335 ERROR [pool-1-thread-1]
de.bender_dv.ardgate.application.ARCN0100Handler: failed!
de.bender_dv.ardgate.database.ConnectException: Connect to database failed
at
de.bender_dv.ardgate.database.ArdConnection.connect(ArdConnection.java:149)
at
de.bender_dv.ardgate.application.ARCN0100Handler.getOutFormat(ARCN0100Handler.java:62)
at
de.bender_dv.ardgate.application.ArdHandler.performWork(ArdHandler.java:45)
at de.bender_dv.jvagate.communication.Sender.run(Sender.java:109)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:693)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:719)
at java.lang.Thread.run(Thread.java:813)
2016-08-22 21:23:48,340 INFO [pool-1-thread-1]
de.bender_dv.jvagate.communication.Sender: connected to DataQueue (system:
AS400 (system name: 'localhost' user ID:
'PGMR6'):com.ibm.as400.access.AS400@e520e52 path:
/QSYS.LIB/JVAGATE.LIB/R649773.DTAQ):com.ibm.as400.access.DataQueue@dbe0dbe
2016-08-22 21:23:48,517 INFO [main]
de.bender_dv.jvagate.communication.Receiver: getOrder
2016-08-22 21:23:48,518 INFO [pool-1-thread-1]
de.bender_dv.jvagate.communication.Sender: $$$$$ R649773 $$$$$
2016-08-22 21:23:48,518 INFO [pool-1-thread-1]
de.bender_dv.jvagate.communication.Sender: Event ARDPGM
2016-08-22 21:23:48,518 INFO [pool-1-thread-1]
de.bender_dv.jvagate.communication.Request: Event set to: ARDPGM
2016-08-22 21:23:48,518 DEBUG [pool-1-thread-1]
de.bender_dv.ardgate.application.ArdHandler: Request:
de.bender_dv.jvagate.communication.Request@1d201d2
2016-08-22 21:23:48,518 DEBUG [pool-1-thread-1]
de.bender_dv.ardgate.pords2pojo.ArdInFormat: interfaceLevel: 1
2016-08-22 21:23:48,518 DEBUG [pool-1-thread-1]
de.bender_dv.ardgate.pords2pojo.ArdInFormat: inFormatName: ARDI0100
2016-08-22 21:23:48,519 DEBUG [pool-1-thread-1]
de.bender_dv.ardgate.pords2pojo.ArdInFormat: lengthOfInFormat: 32
2016-08-22 21:23:48,519 INFO [pool-1-thread-1]
de.bender_dv.ardgate.application.ArdHandler: Format: ARDI0100 ArdGate
Version: 2014-09-17
2016-08-22 21:23:48,519 DEBUG [pool-1-thread-1]
de.bender_dv.ardgate.application.FormatHandlerFactory: Name: ARDI0100
2016-08-22 21:23:48,519 DEBUG [pool-1-thread-1]
de.bender_dv.ardgate.application.ARDI0100Handler: ARDI0100 [B@23fc23fc
2016-08-22 21:23:48,521 DEBUG [pool-1-thread-1]
de.bender_dv.ardgate.pords2pojo.GenericArFormat: outBufferSize: 16776639
2016-08-22 21:23:48,521 INFO [pool-1-thread-1]
de.bender_dv.ardgate.pords2pojo.GenericArFormat: ***** AXTRN01 :2
*****
2016-08-22 21:23:48,521 DEBUG [pool-1-thread-1]
de.bender_dv.ardgate.pords2pojo.ARDI0100Format: reserved:
2016-08-22 21:23:48,521 DEBUG [pool-1-thread-1]
de.bender_dv.ardgate.pords2pojo.ARDI0100Format: disconnectType: 4
2016-08-22 21:23:48,521 ERROR [pool-1-thread-1]
de.bender_dv.ardgate.application.ARDI0100Handler: failed!
java.lang.NullPointerException
at
de.bender_dv.ardgate.application.ARDI0100Handler.getOutFormat(ARDI0100Handler.java:65)
at
de.bender_dv.ardgate.application.ArdHandler.performWork(ArdHandler.java:45)
at de.bender_dv.jvagate.communication.Sender.run(Sender.java:109)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:693)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:719)
at java.lang.Thread.run(Thread.java:813)
2016-08-22 21:23:48,523 INFO [pool-1-thread-1]
de.bender_dv.ardgate.pords2pojo.SqlcaBean: SQLCode: -596
2016-08-22 21:23:48,523 INFO [pool-1-thread-1]
de.bender_dv.ardgate.pords2pojo.SqlcaBean: SQLState: 01002
2016-08-22 21:23:48,523 DEBUG [pool-1-thread-1]
de.bender_dv.ardgate.pords2pojo.SqlcaBean: sqlErrd3 0
2016-08-22 21:23:48,524 INFO [pool-1-thread-1]
de.bender_dv.jvagate.communication.Sender: connected to DataQueue (system:
AS400 (system name: 'localhost' user ID:
'PGMR6'):com.ibm.as400.access.AS400@e520e52 path:
/QSYS.LIB/JVAGATE.LIB/R649773.DTAQ):com.ibm.as400.access.DataQueue@59ce59ce


On Mon, Aug 22, 2016 at 3:32 PM, D*B <dieter.bender@xxxxxxxxxxxx> wrote:

... just follow the documentation and the provided examples!!!
user and password are provided with the SQL statement connect (TFM would
help too).
DB2 passes user uppercase (10 char max), if you enclose it in double
quotes it's passes binary (10 chars max).

D*B
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.





As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
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.