The SQuirreL 100 rows problem (CodingClues)

Jun
23

The SQuirreL 100 rows problem

Recently I inserted about 200 rows into a MySQL table using Hibernate.

However, my application had an error because of missing data and I explored the database in order to find the problem.

In general, SQuirreL is a good tool to do this and I like using it, but this time it made me crazy.

I opened the corresponding table, but there were only 100 rows of data! So I assumed a bug in Hibernate or my application and searched for hours. But found nothing.

Finally I figured out that SQuirreL only displays the top 100 rows of each table in the Objects view. The other rows had always been there, but I was not able to see them.

To list all rows, you have to switch to the SQL view and enter a SELECT statement by hand. Before executing the statement, make sure that the checkbox for the row limit at the upper right corner is disabled.

In conclusion, let’s note:

By default, SQuirreL only displays 100 rows per table.

P.S.: I’m not sure wether there is a setting to change this behavior. Does anyone know?

Related:
“Shiny Table” Effect with Gimp

Are you interested in reading more from CodingClues?
Then subscribe to new postings via RSS or via E-Mail.

Viewing 4 Comments

Priti 01/15/2009 05:16 PM 2 points
Please login to rate.

Do you already have an account? Log in and claim this comment.

In the file C:\Documents and Settings\<user>\.squirrel-sql\prefs.xml Change the tag called <sqllimitrows> to 'false'

<sqllimitrows>false</sqllimitrows>

</sqllimitrows></user>

reply edit reblog flag

Frank 07/18/2008 08:27 AM 1 point
Please login to rate.

Do you already have an account? Log in and claim this comment.

Sure? For me, the solution posted by squirreldev worked.

reply edit reblog flag

http://www.just-works.de

rhassinger 07/18/2008 04:28 AM 3 points
Please login to rate.

Do you already have an account? Log in and claim this comment.

This solution, which appears to be the way to disable the rows, doesn't work. I've tried quitting squirrel and going back in, but the 100 rows limit still exists.

reply edit reblog flag

squirreldev 06/24/2008 09:39 PM 5 points
Please login to rate.

Do you already have an account? Log in and claim this comment.

You can change how many or rows are displayed for table contents by :

File -> New Session Properties -> Object Tree -> Contents - Limit Rows (100 is the default)

You can remove this truncating behavior altogether if you uncheck the box. After you click ok, any new session will have the setting applied.

Rob

reply edit reblog flag

http://squirrelsql.org

Trackbacks

(Trackback URL)

CodingClues