Jsp and AS400

Discussion in 'Java' started by savita.raskar@gmail.com, Mar 17, 2007.

  1. Guest

    Hello All,

    I am fresher , working on jsp .I am getting the following
    error.I have searched on net, I have found the same problem posted but
    without solution.


    i have made a jsp page to access to as/400 db.
    ...but it don't work correctly.
    in the as/400 there is table f57202 under the library HTPL

    I have written down :
    connection =
    DriverManager.getConnection("jdbc:as400://","xxxx","xxx");


    PreparedStatement stat=conn.prepareStatement("select * from HTPL/
    f57202 where USERID=? and PASWRD=?");
    but i receive a error

    Errorjava.sql.SQLException: [SQL5016] Qualified object name F57202 not
    valid.

    when i change the code in:
    PreparedStatement stat=conn.prepareStatement("select * from
    HTPL.f57202 where USERID=? and PASWRD=?");

    i receive this error

    Descriptor index not valid.

    ... but when i make a query by the client as/400

    and wrote
    select * from htpl/f57202

    it work correctly


    i can't find the solution..

    Someone can me help?

    Thanks for your help
    Savita
    , Mar 17, 2007
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?RC5TYXJhdmFuYW4=?=

    DB_E_BADPROPERTYVALUE error when connecting to AS400 db2 udb

    =?Utf-8?B?RC5TYXJhdmFuYW4=?=, Jun 18, 2004, in forum: ASP .Net
    Replies:
    0
    Views:
    467
    =?Utf-8?B?RC5TYXJhdmFuYW4=?=
    Jun 18, 2004
  2. Manuel Arroba
    Replies:
    0
    Views:
    2,043
    Manuel Arroba
    Jun 28, 2004
  3. Cor Ligthert

    Re: AS400 And ADOx

    Cor Ligthert, Sep 14, 2004, in forum: ASP .Net
    Replies:
    0
    Views:
    587
    Cor Ligthert
    Sep 14, 2004
  4. Replies:
    0
    Views:
    4,314
  5. savita
    Replies:
    0
    Views:
    395
    savita
    Mar 24, 2007
Loading...

Share This Page