Re: ARDGATE connecting to MS SQL

Its tough not being a Java guy.

I changed the properties to the following:

ard.driver.AXTRN01=net.sourceforge.jtds.jdbc.Driver
ard.properties.AXTRN01.additionalProps=AXTRN01
ard.url.AXTRN01=jdbc:jtds:sqlserver://DAXDEVDB02-SQL2

ard.properties.AXTRN01.selectMethod=direct

It still has the same issues.

The system has Java 5.0 installed: 5722JV1 options *BASE, 5, 6, 7, 8, 10
and 11.

I assume when it runs that it selects the Java 5.0 JVM but do not know how
to check for that.

I submit the following job:

SBMJOB CMD(CALL PGM(JVAGATE/STRJVAGATE)) JOB(JVAGATE) JOBQ(QUSRNOMAX)

I believe the Java is throwing the following error and the batch job fails
as a result but I do not know why.

java.lang.UnsupportedClassVersionError:
de/bender_dv/jvagate/communication/Receiver
at java.lang.Throwable.<init>(Throwable.java:195)

at java.lang.Error.<init>(Error.java:49)

at
java.lang.UnsupportedClassVersionError.<init>(UnsupportedClassVersionError.java:34)

at java.lang.ClassLoader.defineClass(ClassLoader.java:567)

at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:168)

at java.net.URLClassLoader.defineClass(URLClassLoader.java:313)

at java.net.URLClassLoader.access$300(URLClassLoader.java:86)

at java.net.URLClassLoader$ClassFinder.run(URLClassLoader.java:636)

at java.net.URLClassLoader.findClass(URLClassLoader.java:222)

at java.lang.ClassLoader.loadClass(ClassLoader.java:317)

at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274)

at java.lang.ClassLoader.loadClass(ClassLoader.java:263)

at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:330)


Darryl.


On Mon, Aug 22, 2016 at 11:26 AM, <dlclark@xxxxxxxxxxxxxxxx> wrote:

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 08/22/2016
11:03:34 AM:

<Dave>
Now, that said... I'll note that the MS driver quit working when
we applied PTFs to our system at some point. We have not identified the
problem.
</Dave>

... do you get any hints for the problem in the java log?

No, the request just times out.


Sincerely,

Dave Clark
--
int.ext: 91078
direct: (937) 531-6378
home: (937) 751-3300

Winsupply Group Services
3110 Kettering Boulevard
Dayton, Ohio 45439 USA
(937) 294-5331




************************************************************
*********************************
This email message and any attachments is for use only by the named
addressee(s) and may contain confidential, privileged and/or proprietary
information. If you have received this message in error, please
immediately notify the sender and delete and destroy the message and all
copies. All unauthorized direct or indirect use or disclosure of this
message is strictly prohibited. No right to confidentiality or privilege
is waived or lost by any error in transmission.
************************************************************
*********************************
--
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.