Hi all,

i try to execute a stored procedure via jdbc on sybase.




My problem: result.next is never true. I tried the statement in asp code. There it worked fine. What am I doing wrong?

Regards,

Barnti

Hi all,

i found the anwser: Wrong login parameters! Here is the code for executing a stored procedure in sybase via jdbc:

...
Session session = null;

SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();

session = sessionFactory.openSession();

CallableStatement sproc_stmt;
try {
sproc_stmt = session.connection().prepareCall("{call ESDB.dbo.ta_generic_password_check (?,?)}");
sproc_stmt.setString(1, userName);
sproc_stmt.setString(2, hash);
sproc_stmt.setFetchSize(10);

SybCursorResultSet sproc_result = (SybCursorResultSet) sproc_stmt.executeQuery();

while(sproc_result.next()){
System.out.println(sproc_result.getString(1));
System.out.println(sproc_result.getString(2));
System.out.println(sproc_result.getString(3));
System.out.println(sproc_result.getString(4));
}
} catch (HibernateException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}



[code][/code]