Re: Can't see table contents

Just tried and let it sit for about 7-8 minutes.  Still nothing in the contents or row count tabs.  After looking a bit deeper I see that the logs have the following stack trace:

 

40422 [Thread-4] ERROR net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab  -

java.sql.SQLException: Line 1: Incorrect syntax near '-'.

                at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)

                at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)

                at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)

                at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)

                at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)

                at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1258)

                at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.table.ContentsTab.createDataSet(ContentsTab.java:325)

                at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:123)

                at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)

                at java.lang.Thread.run(Unknown Source)

 

I don’t know where I can go to see/modify the sql that is used for the contents tab.  Any advice?  One more thing, my db name is pop-dev.  I hope that is not the “-“ it is referencing.

 

Thanks,

Dale

 

 

 

From: JPSabin@xxxxxxxxxxxxxxxxxxxxxx [mailto:JPSabin@xxxxxxxxxxxxxxxxxxxxxx]
Sent: Thursday, May 10, 2007 11:48 AM
To: Dale Bronk
Subject: Re: [Squirrel-sql-users] Can't see table contents

 

You know, when I first started using SQuirrel I was surprised about the amount of time it took for those tabs to populate.  I thought at first there was an issue with the driver.  This probably sounds strange, but have you tried to click on the tabs and leave them for 5 minutes or so?

JP Sabin
Database Mgr.
NMC
Phone: 402.891.7744
Fax: 402.891.7607
Cell: 402.616.5294
email: JPSabin@xxxxxxxxxxxxxxxxxxxxxx

"Dale Bronk" <dbronk@xxxxxxxxxxxxx>
Sent by: squirrel-sql-users-bounces@xxxxxxxxxxxxxxxxxxxxx

05/10/2007 10:43 AM

To	<squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx>
cc
Subject	[Squirrel-sql-users] Can't see table contents

 

Hello…
 
I just downloaded SQuirreL 2.5 and installed.  I can connect to my MS SQL database just fine using the sourceforge jTDS jdbc driver.  My problem is that when I select my table for the left pane and then select either contents or row count tabs I see nothing but a gray blank tab content.  It doesn’t even show a blank row.  If I jump over to the sql tab I can enter select, insert, update statements and they all process just fine and allow me to view the contents so I don’t believe it is anything to do with rights of the user.  Please advise.
 
Thanks,
Dale
 -------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users