SQuirreL SQL Client

This is the first release of a new, "SQL 
Bookmark" plugin for SQuirrel-SQL. This 
plugin allows you to manage commonly used 
SQL code for easy reuse. The plugin also 
provides a simple syntax for parameter 
replacement within the bookmarked SQL. As 
the SQL is reloaded, the user is prompted to 
enter values for any embedded parameters, 
after which the SQL is loaded into the edit 
buffer for execution. 

The plugin requires SQuirreL SQL Client 
1.1final1 and JDK 1.3+. 

To install you need to download the 
appropriate .zip or .tar.gz file and unpack it 
into the plugins directory within the SQuirreL 
SQL Client application making sure that you 
keep the directory structure. 

Downloads can be found at: 
http://sourceforge.net/project/showfiles.php?
group_id=28383&release_id=155627

--
Colin Bell
http://squirrel-sql.sf.net

Hi Joe,

SQLBookmark sounds interesting. Both the bookmark facility and the
parameterized queries are features that have been requested for SQSC. Do
you have a download link to your plugin so that I can have a look at it?

--
Colin Bell
http://squirrel-sql.sf.net

----- Original Message -----
From: Joe Mocker <mock-sf@...>
Date: Monday, April 14, 2003 2:21 am
Subject: [Squirrel-sql-develop] new squirrel sql plugin

> Hello,
> 
> I've been working on a plugin for Squirrel SQL that I would like
> to share. I've been calling SQLBookmark. As the name would 
> imply, it allows you to "bookmark" frequently use SQL statements
> and easily reload them into the SQL buffer.
> 
> Additionally, it provides a syntax for specifying parameters
> to be replaced at load time. 
> 
> Could someone send me a pointer to info on how to proceed on
> getting this plugin listed with the others on sourceforge ?
> 
> Thanks...
> 
>  --joe

Hello,

I've been working on a plugin for Squirrel SQL that I would like
to share. I've been calling SQLBookmark. As the name would 
imply, it allows you to "bookmark" frequently use SQL statements
and easily reload them into the SQL buffer.

Additionally, it provides a syntax for specifying parameters
to be replaced at load time. 

Could someone send me a pointer to info on how to proceed on
getting this plugin listed with the others on sourceforge ?

Thanks...

  --joe

Hello all,

First of all, i have to express my many thanks for your excellent job. The
SquirrelSQL client
is by far my favorite SQL client editor. I replaced all other tools i used
with your client.
I dont know if i can help so much as you helped me, but i will not miss any
opportunity to do so.

Last week i made something which could be usefull also for you. I created a
small interpreter which
parses something like SQLJ programs.
This interpreter reads a sequence of characters and separating the tokens in
two distinct language blocks.
The Java statements and SQL statements. The Java statements are passed to
BeasnSell for execution. The SQL
statemens are passed to JDBC also for execution.

I wrote this program, because i wanted to have parametirized SQL programs.
The result was not
only the parametirization, but the ability of writing a mix of Java and SQL
statements. I will give you
an example.

samplesNo = new Integer( args[0});
sampleDate = args[1];
for( int i = 0; i < samplesNo; i++)
{
    sample = Math.random();
    toolType = Math.round( Math.random() * 5.0);
    #sql[session] { insert into samples (sn, tool, ammount) values({:i},
{:toolType}, {:sample}) }
}
#sql[session]
{
    update tool set noise = (select avg( ammount) from samples where
tool.type = samples.tool;
    update tool set maxLevel = maxLevel - noise where noise > 0.0005;
}

Currently, user executes those scripts with a command in the following form.
ISQLJ CREATE_SAMPLES.SQL 100 "2003/04/10"

My next goal is to use the SquirrelSQL client to execute those scripts. I
started to look at plugins,
but in the plugins.html i found the method statementExecuting(String sql).
If i unerstood correct, the
SquirrelSQL parsing the selected text and giving back one by one the scanned
SQL statements.
In my case the selected text block will contain a mix of Java and SQL code.

Is it possible to hooked up before the scanning? Is it completely wrong my
way?

If you are interesting and want to help me, i will appreciated.



Thanks in advance


Stathis Alexopoulos

> Is there anything specifically new in 1.4.1 from 1.3.1 that you 
> are 
> hoping to incorporate directly, that can't be done how it is 
> currently 
> (i.e. checking for existence of 1.4.1 specific classes and only 
> then 
> loading appropriate classes via reflection)?

There are a couple of reasons I want to move to 1.4. Firstly there have
been a number of issues with 1.3, mainly Swing problems that go away
with 1.4. Having to test everything with 1.3 as well as 1.4 has been a
real pain, not to mention developing workarounds for bugs in 1.3.

Secondly there are new features in 1.4 that will be useful. regex, JSSE,
 new drag and drop architecture etc. Yes these can be accessed via
reflection but it means that any functionality that relies on them will
not be available when running on 1.3.

Eventually I will drop support for JDK 1.3. At the latest it will be
when Sun bring out their first release of java 1.5. However I would like
to do it before then.

> The JDK 1.4.1 update for Mac OS X is optional, and I'm actually 
> working 
> with a development group who is specifically avoiding the upgrade. 
> They 
> may not be alone in this regard.

All upgrades are optional but there comes a time when you have to apply
them or nothing will run. I can understand taking your time with the
upgrade, as regression testing etc would be required but avoiding it
puzzles me. Are there known problems with the upgrade that would make
people avoid it?

--
Colin Bell
http://squirrel-sql.sf.net

----- Original Message -----
From: Lynn Pye <lynn@...>
Date: Wednesday, April 2, 2003 12:10 pm
Subject: [Squirrel-sql-develop] Re: SQuirreL 1.1 and JDK 1.4

> The JDK 1.4.1 update for Mac OS X is optional, and I'm actually 
> working 
> with a development group who is specifically avoiding the upgrade. 
> They 
> may not be alone in this regard.
> 
> Is there anything specifically new in 1.4.1 from 1.3.1 that you 
> are 
> hoping to incorporate directly, that can't be done how it is 
> currently 
> (i.e. checking for existence of 1.4.1 specific classes and only 
> then 
> loading appropriate classes via reflection)?
> 
> Lynn
> 
> On Tuesday, April 1, 2003, at 03:38  PM, 
> squirrel-sql-develop-request@... wrote:
> 
> >
> > Message: 1
> > From: Colin Bell <colbelloz@...>
> > To: squirrel-sql-develop@...,
> > 	 squirrel-sql-users@...
> > Reply-To: colbelloz@...
> > Date: Tue, 01 Apr 2003 17:06:24 +1000
> > Subject: [Squirrel-sql-develop] SQuirreL 1.1 and JDK 1.4
> >
> > Now that Apple has finally released Java 1.4 for OS X, all the 
> > platforms
> > that SQuirreL runs on have Java 1.4. I'd like to make 1.4.0 the 
> minimum> version of Java required for the next release of SQuirreL.
> >
> > Are there any objections to this?
> >
> > --
> > Colin Bell
> > http://squirrel-sql.sf.net
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: ValueWeb: 
> Dedicated Hosting for just $79/mo with 500 GB of bandwidth! 
> No other company gives more support or power for your dedicated server
> http://click.atdmt.com/AFF/go/sdnxxaff00300020aff/direct/01/
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squirrel-sql-develop@...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>

The JDK 1.4.1 update for Mac OS X is optional, and I'm actually working 
with a development group who is specifically avoiding the upgrade. They 
may not be alone in this regard.

Is there anything specifically new in 1.4.1 from 1.3.1 that you are 
hoping to incorporate directly, that can't be done how it is currently 
(i.e. checking for existence of 1.4.1 specific classes and only then 
loading appropriate classes via reflection)?

Lynn

On Tuesday, April 1, 2003, at 03:38  PM, 
squirrel-sql-develop-request@... wrote:

>
> Message: 1
> From: Colin Bell <colbelloz@...>
> To: squirrel-sql-develop@...,
> 	 squirrel-sql-users@...
> Reply-To: colbelloz@...
> Date: Tue, 01 Apr 2003 17:06:24 +1000
> Subject: [Squirrel-sql-develop] SQuirreL 1.1 and JDK 1.4
>
> Now that Apple has finally released Java 1.4 for OS X, all the 
> platforms
> that SQuirreL runs on have Java 1.4. I'd like to make 1.4.0 the minimum
> version of Java required for the next release of SQuirreL.
>
> Are there any objections to this?
>
> --
> Colin Bell
> http://squirrel-sql.sf.net

Now that Apple has finally released Java 1.4 for OS X, all the platforms
that SQuirreL runs on have Java 1.4. I'd like to make 1.4.0 the minimum
version of Java required for the next release of SQuirreL.

Are there any objections to this?

--
Colin Bell
http://squirrel-sql.sf.net