squirrel-sql

Java: "Could not find the main class. Program will exit"

I'm trying to run SQuirreL SQL. I've downloaded it and installed it, but when I try to run it I get this error message: Java Virtual Machine Launcher. Could not find the main class. Program will exit. I get the gist of this, but I have not idea how to fix it. Any help? more info: I'm on Windows XP pro. I have java 1....

Good database client (MS SQL Server) with auto-complete, small memory foot-print and free?

Hi, Any sugestions? Currently I'm using Squirell but it consumes quiet a bit of memory... I just use the sql client to run some queries and get the result but i absolutely need auto-complete of tables, columns, etc ...

Increasing Heap size for SQuirreL SQL on Max OS X

Hi, I'm running SQuirreL SQL (2.6.8) on Max OS X. I'm running out of heap space when trying to create a Table script. Can anyone tell me how to configure SQuirreL SQL to start up with a higher jvm heap size? I'm rather new to developing on Macs, so assume I'm ignorant. Thanks. ...

Issues Creating SQL Server triggers using SQuirreL SQL Client

Recently I have been working with a SQL Server database and I was trying to create some triggers for some tables using SQuirreL SQL Client and for some reason I was unable to get rid of the following pesky error message: "Error: 'CREATE TRIGGER' must be the first statement in a query batch. SQLState: S0001 ErrorCode: 111" The query I ...

generate sql script from tables

is it possible to generate sql scripts from for all tables ? i want to generate the sql script and import into another database server ...

Executing SQL Server stored procedure in sql squirrel

i'm in ubuntu 9.04 and using sql squirrel as my sql client. i connect to a remote SQL Server. There are some stored procedures in the db. I don't know how to execute them. No explicit gui. Earlier i was in windows and i could use management studio. I can right click on stored procedures and give Execute. You guys have any idea? Let me kn...

squirrel-sql : no sequence options.

I've installed Squirrle and connect to DB2. Yet in my install I don't get the tree node for "sequences". I get... ALIAS HIERARCHY TABLE INOPERATIVE VIEW MATERIALIZED QUERY NICKNAME SYSTEM TABLE TYPED TABLE TYPED VIEW VIEW PROCEDURE UDT I'm missing the next one called "SEQUENCE". I've uninstalled/reinstalled, but I still cant see ...

Does Squirrel SQL or Oracle have a way to alias table names in queries?

I'm using Squirrel SQL with Oracle. I often have to write quick queries for tables with longish names. It would be nice if I could give aliases to them and write queries like "select * from ft where n='blah'" instead of "select * from footablelongname where nameField='blah'". I wouldn't use that sort of thing in applications, but it wou...

create a mysql stored procedure in squirrel sql

Hi, I'm using squirrel sql 3.1 to create a store procedure on a mysql db. The sp works fine when I create it with other clients, but when i try with squirrel sql it gives me a bunch of errors. I tried to change the statement separator on the session properties but it says that property are not editable. You guys have any idea? Let me kn...

How to call a stored procedure using a ref cursor on oracle with squirrel

Hello, I'm trying to do the same request i'm using in Toad (the store proc signature is two varchar2 parameter and one REF CURSOR parameter) Here is what I do with Toad variable myCursor refcursor; EXEC myproc('param1','param2',:myCursor ); print myCursor; I don't know how to write this with Squirrel and I have to use Squirrel. th...