• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
Bartenders:
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

JNDI and as400

 
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.
 
Marshal
Posts: 25812
69
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.
 
Bring me the box labeled "thinking cap" ... and then read this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    Bookmark Topic Watch Topic
  • New Topic