craftleft.gif (3002 bytes)QuickTable
Home | API | Tutorial | Download | Support | Contact topblack.gif (108 bytes)


QuickTable User Cp  |  Register  |  Members  |  Search  |  Help
    |- QuickTable Discussion Forums > JDBC/Database Issues Post New Topic   Post A Reply
Using Quicktable with stored procedures printer friendly version
next newest post | next oldest post
Author Messages
thorsten.moeller{@}valleyroad.de
Unregistered
Edit or delete this message Reply w/Quote
Posted Wednesday, December 31, 1969 @ 23:59:59  

Hi,

ist it possible to use quicktable with stored procedures?

Normally you can use a "CallableStatement" in JDBC.

Thanks

Thorsten

admin{@}quicktable.org
Unregistered
Edit or delete this message Reply w/Quote
Posted Wednesday, December 31, 1969 @ 23:59:59  

Thorsten ,

There are two ways to use stored procedure

1) passing the stored procedure through selectSql

dBTable1.setSelectSql("get_Company_Info IBM, America");
dBTable1.refresh();

2) Execute the stored procedure yourself and pass the resultset to quickTable
ResultSet rs = yourCallableStatement.executeQuery();
dBTable1.refresh(rs);

QuickTable is the only java DBGrid which gives full support for stored procedure.

Ben

Post New Topic   Post A Reply Jump to:
Contact Us | QuickTable - A Java DBGrid | Privacy Policy All times are GMT -5 Hours.
Welcome to QuickTable Forums, Guest!  
Login
Username :
Password :
In order to fully utilize the abilities of this board, you are required to register as a member. Registration is free, and allows you to do lots of things including turning on or off certain features of this board. Register now!
Powered by CuteCast v2.0 BETA 2
Copyright © 2001-2003 ArtsCore Studios