Class XXX could not be loaded.

Sudha,

Thanks.... i have another question about resultSet.... Below is a piece of my code ...

callableStatement cs = conn.prepareCall(sql);

:

: // register ouput parameter and set input

:

:

bFound = cs.execute();

resultSet rs = cs.getResultSet();

while (rs.next()) {

aaa = rs.getString(1);

:

:// get the output

:

}

My problem is : i always get bFound = False, what wrong with the code ?

appreciate ur guide !! Thanks

shawshonga at 2007-7-8 >

This means your stored proc is failing.

Why don't you try something like this,

if(cs.executeUpdate()==0) {

System.out.println("Executed successfully !!!");

resultSet rs = cs.getResultSet();

while (rs.next()) {

aaa = rs.getString(1);

//...

}

} else {

System.out.println("Execution failed !!!");

}

Hope this helps.

Sudha

sudha_mpa at 2007-7-8 >

ok ... i have a precompile SQL statement with multiple output parameters and multiple rows retrieval... i use preparedStatement in my code ... as below :

//declare variables

private Connection conn;

private PreparedStatement ps;

private resultSet rs;

GetDrCrRsnPB_Call = "begin P_GetDrCrRsnPB.SP_GetDrCrRsnPB(?,?,?,?,?,?,?,?,?,?);end;"; // this is my precompile package

ps = conn.prepareStatement(GetDrCrRsnPB_Call);

//set the input

ps.setString(1, iprodgrp);

ps.setString(2, iadjprcs);

rs = ps.executeQuery();

while (rs.next()) {

// get the output

oDrCrIndc = rs.getString(1);

:

:

:

:

}

I got the following error .... "not all variables bound" ... how can i solve this problem ? how can i register output parameter using preparedStatement ?

Please help ...

shawshonga at 2007-7-8 >