Thread: [Squirrel-sql-users] Object tree displays OK, but SQL commands won't exececute
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Denis G. <dgr...@we...> - 2003-04-13 16:29:18
|
Hi folks, I hope someone may be able to throw some light on the following odd behaviour. I have a postgres 7.3.2 installation on Solaris9 that I want to access from Windows PCs using the squirrel 1.1-final client. The windows version is Windows2000 Professional/SP3. The java version on the PCs is: "Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.0-C)" I am using a jdbc driver called 'pg73jdbc2ee.jar.zip' that I got from the Postgresql java website. The driver loads up OK and appears in the client as active. I can connect to the database without any problems. In the client GUI I can view everything under the 'Objects' tab such as table content, table columns, primary keys, views, etc. If I click on 'Content' for any given table I get an instant list of all the rows. However the SQL tab is not working. I can type in any simple select statement (select * from <tablename>;) for the same table for which I just viewed the content and nothing happens at all. No list, no new tab, nothing. I'm not a java expert, so I would appreciate any help on how to try and troubleshoot this. thanks Denis _________________________________________________________ | Denis Grannell, Kapuzinerstr. 45, 80469 Munich, Germany | | Tel: +49 89 2013672 Fax: +49 89 2022875 | |_________________________________________________________| |
From: Denis G. <dgr...@we...> - 2003-04-15 18:56:31
|
Hi Colin, I tried to post this reply yesterday but it didn't appear in the list, anyway... first of all, thanks for the response. > However having a blank line between the SQL statement and the > caret will cause this problem. I definitely have the cursor on the same line as the sql statement. > In 1.1 having the cursor on the next line will still execute The version I have is 1.1-final. This is what appears in the client window, maybe you can interpret what it says. cheers, Denis Grannell at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source) at java.awt.Component.processMouseEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEvent(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) _________________________________________________________ | Denis Grannell, Kapuzinerstr. 45, 80469 Munich, Germany | | Tel: +49 89 2013672 Fax: +49 89 2022875 | |_________________________________________________________| |