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
DataBase Connection with a Resultset printer friendly version
next newest post | next oldest post
Author Messages
pesheek{@}yahoo.com
Unregistered
Edit or delete this message Reply w/Quote
Posted Wednesday, December 31, 1969 @ 23:59:59  

Hello,
On the DBGrid Example
"" http://quicktable.org/#dbgrid
It is even made more simple, if you have a jdbc resultset. With one statement, you can load the resultset into quicktable.

dBTable1.refresh(yourResultSet); ""

But dBTable1.refresh(yourResultSet) does not exists.

Can sone one have any suggestions how can I use my existing resultset with dbgrid. ??

Thanks

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

what do you mean by that refresh() method does not exists? Are you getting compile error or runtime error?

Are you using the following type of code?

DBTable dBTable1 = new DBTable();
dBTable1.refresh(yourResultSet);

Please refer to api at the following url
http://quicktable.org/doc/quick/dbtable/DBTable.html#refresh(java.sql.ResultSet)

Ben

pesheek{@}yahoo.com
Unregistered
Edit or delete this message Reply w/Quote
Posted Wednesday, December 31, 1969 @ 23:59:59  

Hi Ben,

I m using NetBeans 3.5, SDK 1.4.2 on Linux . I add the QuickTable as Java Bean.I have used it using GUI.

MY code is used as follows :
dBTable1 = new quick.dbtable.DBTable();

And the following code is working fine.

dBTable1.connectDatabase("org.postgresql.Driver","jdbc:postgresql://192.168.1.5:5432/salestax","user","passwd");
dBTable1.setSelectSql("select * from saleem");
dBTable1.refresh();

When I used an existing ResultSet, Compiling gives me the following error :
test_it.java [96:1] refresh() in quick.dbtable.DBTable cannot be applied to (java.sql.ResultSet)

Any Suggestion

Regards

Saleem

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

The only reason I can think of is, you have a very old version of QuickTable. Can you tell me the version of quicktable by calling getVersion() or by looking into readme.txt

Anyway, could you download the latest version of quicktable and tell me whether you still have this problem.

Ben

pesheek{@}yahoo.com
Unregistered
Edit or delete this message Reply w/Quote
Posted Wednesday, December 31, 1969 @ 23:59:59  

Hello Ben,
I m using the demo/free download version of quick table downloaded from url:
http://quicktable.org/download/quicktable2swing103.tar

I have tried the swing11 & swing103 both. And the result is same. And yes the method getVersion() also doesnot exists.The Readmen.txt file have "**QuickTable 2.0.1**"

Is their is another location to download the latest free download so I can check it for our requirements.

Regards

Saleem

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

You have a very old version. Please download the latest quicktable 2.0.5 swing 11 version (tar format or zip format) from the download area.
pesheek{@}yahoo.com
Unregistered
Edit or delete this message Reply w/Quote
Posted Wednesday, December 31, 1969 @ 23:59:59  

Hello Benjamin,
Previously I downloaded the tar versions of quicktable and both of them are ver 2.0.1. Today I downloaded the zip versions from the same page of your site and they are ver 2.0.4. You write me the latest is ver 2.0.5. From where I can download them ??

But my actual problem of using ResultSet is solved and now I can carry on my tests & check to pesuade my managment to purchase the product.

Regards

Saleem

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