Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    1

    Post Unanswered: db2 websphere jdbc configuration problem

    i get the following error:
    com.ibm.db2.jcc.c.SqlException: Connection authorization failure occurred. Reason: userid revoked

    what am i doing:
    Using type 4 jdbc driver to connect websphere to db2.
    Configs:
    Name: DB2 Universal JDBC Driver Provider
    Classpath:
    ${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc.jar
    ${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cu.jar
    ${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cisuz.jar

    DataSource: jdbc/Session
    DatabaseName: sample or wasdb (i have both)
    servername: db2host1 (my machien name)
    port: 50000

    (also tried giving jdbc:db2://db2host1:50000/sample with options servername and port as blank, but that also gave me some error as:
    com.ibm.db2.jcc.c.SqlException: IO Exception opening socket to server null on port 446. The DB2 Server may be down
    )
    although my db2 instance is up n running at port 50000!

    j2c authentication:
    username: db2admin
    password: db2admin

    DB2 UDB 8.1 Version
    Websphere Application Server 5.0.2.3

  2. #2
    Join Date
    Mar 2004
    Location
    omaha, ne
    Posts
    1

    Re: db2 websphere jdbc configuration problem

    Originally posted by satyannair
    i get the following error:
    com.ibm.db2.jcc.c.SqlException: Connection authorization failure occurred. Reason: userid revoked

    what am i doing:
    Using type 4 jdbc driver to connect websphere to db2.
    Configs:
    Name: DB2 Universal JDBC Driver Provider
    Classpath:
    ${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc.jar
    ${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cu.jar
    ${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cisuz.jar

    DataSource: jdbc/Session
    DatabaseName: sample or wasdb (i have both)
    servername: db2host1 (my machien name)
    port: 50000

    (also tried giving jdbc:db2://db2host1:50000/sample with options servername and port as blank, but that also gave me some error as:
    com.ibm.db2.jcc.c.SqlException: IO Exception opening socket to server null on port 446. The DB2 Server may be down
    )
    although my db2 instance is up n running at port 50000!

    j2c authentication:
    username: db2admin
    password: db2admin

    DB2 UDB 8.1 Version
    Websphere Application Server 5.0.2.3

    satyannair

    This message is returned when your userid /password has been revoked on the host for too many attempts to log on with the wrong password. the userid needs to be reset on the host before you will be able to logon.

    Troy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •