JNDI and as400

[Steve Jagels]

I am trying to use jndi for an application that currently gets server info from a properties file. The application accesses both SQL Server and db2 on as400 (iSeries). The jndi works for SQL Server but not for the as400.

When I use:

<connection-url>jdbc:com.ibm.as400://ppcdev;date format=iso</connection-url>
<driver-class>com.ibm.as400.access.AS400JDBCDriver</driver-class>

I get as error message: apparently wrong driver class specified for URL.

These two parameters are exactly the same as what is in the properties file, which has been working for a long time.

Any ideas why this is happening? TIA.

[Paul Clapham]

My idea, which may or may not be relevant: when I create a JDBC URL to go with the Toolbox driver, it starts with "jdbc:as400:" only. At least as far as I recall; right now I have it in Websphere, which doesn't expose the URL.

[Steve Jagels]

I've tried both jdbc:com.ibm.as400 and jdbc:as400, and both give that same error message.