• Post Reply Bookmark Topic Watch Topic
  • New Topic

JNDI and as400

 
Steve Jagels
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Posts: 21878
36
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I've tried both jdbc:com.ibm.as400 and jdbc:as400, and both give that same error message.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!