squirrel-sql-develop Mailing List for SQuirreL SQL Client (Page 42)

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
 

Hi Joseph,

Thanks for the patch. I'll take a look at it when I get back from
holidays in a couple of weeks.

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

----- Original Message -----
From: Joseph Boyd <jb...@ww...>
Date: Thursday, March 13, 2003 7:34 am
Subject: [Squirrel-sql-develop] [PATCH] Fix copy of data from columns
which have been re-arranged

> Squirrel 1.1 final has a bug, where if you re-arrange the columns 
> in 
> your result set (say, move the first column to the right, making 
> it the 
> second column), and then copy some of the data from the re-
> arranged 
> columns, the data copied is relative to the original column order, 
> not 
> the re-arranged column order.
> 
> The two attached patches fix this bug for the HTML and plain-text 
> copy 
> options. The patches are against these files from fw-src.jar :
> 
> net/sourceforge/squirrel_sql/fw/gui/action/TableCopyCommand.java
> net/sourceforge/squirrel_sql/fw/gui/action/TableCopyHtmlCommand.java
> 
> 
> 
> Please let me know if I'm not submitting patches correctly, or if 
> I've 
> somehow missed the point with the patches themselves.
> 
> 
> 
> Regards,
> 
> ...Joseph Boyd
> 
> Lead Application Developer
> accessIndiana..."linking hoosiers to government"
> http://www.IN.gov
> 10 West Market St., Suite 600
> Indianapolis, IN 46204
> 
> 
 

Squirrel 1.1 final has a bug, where if you re-arrange the columns in 
your result set (say, move the first column to the right, making it the 
second column), and then copy some of the data from the re-arranged 
columns, the data copied is relative to the original column order, not 
the re-arranged column order.

The two attached patches fix this bug for the HTML and plain-text copy 
options. The patches are against these files from fw-src.jar :

net/sourceforge/squirrel_sql/fw/gui/action/TableCopyCommand.java
net/sourceforge/squirrel_sql/fw/gui/action/TableCopyHtmlCommand.java



Please let me know if I'm not submitting patches correctly, or if I've 
somehow missed the point with the patches themselves.



Regards,

...Joseph Boyd

Lead Application Developer
accessIndiana..."linking hoosiers to government"
http://www.IN.gov
10 West Market St., Suite 600
Indianapolis, IN 46204

Thanks to Lynn Pye there is now a native installer for
OS X 10.2.x. This will not work with 10.1.x. This has
minor adjustments to use the Aqua LAF and with the
menu bar appropriately positioned.

To install download
osx-squirrel-sql-1.1final1-install.pkg.tar.gz from 
http://sourceforge.net/project/showfiles.php?group_id=28383&release_id=124587
and use StuffIt Expander or equivalent to open the
installer (doubleclicking on the .tar.gz file should do
this). Double click on the .pkg file and the installation
will begin. It is set up with appropriate defaults, so
you should only need to click through to complete
the install. It will be in a folder in /Applications.

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

Hi Marco,

Just send a msg to the developers mailing list when you've got
somethibng to show.

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

----- Original Message -----
From: Marco Ceccarelli <m.c...@tn...>
Date: Wednesday, February 19, 2003 5:52 am
Subject: [Squirrel-sql-develop] new plugin structReport

> i'm started a new plugin
> 
> name: structreport
> 
> when finished it can preview a report with
> the structure (like m$ acces) of entire database
> i use itext for report so it can be exported in html or pdf..
> 
> what i have to do when i want to send you the plugin?
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
> 
 

i'm started a new plugin

name: structreport

when finished it can preview a report with
the structure (like m$ acces) of entire database
i use itext for report so it can be exported in html or pdf..

what i have to do when i want to send you the plugin?

Just a quick note let you all know that its going to be the end of March
before I'm going to have any time to really do any work on SQuirreL.
Between my day job and being organized for my wedding there just aren't
enough hours in the day.

The patches that have been sent to me haven't been forgotten about,
they're just backed up in the queue and will be applied as soon as I get
the time.

I'd like to take this opportunity to thank everybody who has contributed
to SQuirreL. I believe that its is turning into a very good ISQL tool, a
far better one that if I'd kept developing it alone. You just have to
look at the differences between 1.0 and 1.1 where most of the major
changes were not made by me.

Again thanks to everybody and please bear with me over the next month or so.

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

Hi Marco,

> I modify SQLScript plugin for work with other databases (the 
> escape char for 
> apostrophe \' doesn't work with some db) and i think to adds more 
> options 
> (for dates format ad for large script that goes outOfMemory!!) 

Johan Compagner wrote the SQL Scripts plugin so he would be the best
person to talk to about your changes to it. You can email him at   
joco01 at users.sourceforge.net.

> The most important thing for me is the visual query designer and 
> i've read 
> that you are going to implement in the 1.2 version? 

Its one of things that I'd like done for SQuirreL but I don't have any
plans to work on it at the moment - too much else to do. If you'd like
to build a plugin to do this please go right ahead. It would be a very
valuable contribution to SQuirreL.

> I can make a pdf report (with iText) for the structure of 
> databases? 

Also sounds like a good idea. Probably a better place to start than the
Visual Query Builder, if nothing else it should be a smaller easier
plugin to write.

The easiest way to start a plugin would probably be to get the source to
one of the existing ones and start from there. If you have any questions
etc. just post them to this list.

> Excuse my intrusion, bye. 

People offering to work on SQuirreL is certainly _not_ an intrusion.
Thanks for your offer.

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

----- Original Message -----
From: "Marco Ceccarelli - tnx.it" <m.c...@tn...>
Date: Sunday, February 16, 2003 10:24 am
Subject: [Squirrel-sql-develop] italian developer interested in contributing

> (my english is bad.. excuse me) 
> Hi, i download squirrel sql and plugins, i found it very useful 
> and 
> congratulation to all you. 
> I'm 3 years in developing simple database (mysql) java 
> applications and i 
> think i can have some free time to contribute in your project. 
> I have some years experience in visual basic nd m$ access and i 
> think access 
> have some useful things ... (and other very bad..) 
> I modify SQLScript plugin for work with other databases (the 
> escape char for 
> apostrophe \' doesn't work with some db) and i think to adds more 
> options 
> (for dates format ad for large script that goes outOfMemory!!) 
> 
> Can you tell me what can i do ? 
> 
> The most important thing for me is the visual query designer and 
> i've read 
> that you are going to implement in the 1.2 version? 
> 
> I can make a pdf report (with iText) for the structure of 
> databases? 
> 
> Excuse my intrusion, bye. 
> 
> Marco Ceccarelli 
> 
> 
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
> 
 

(my english is bad.. excuse me) 
Hi, i download squirrel sql and plugins, i found it very useful and 
congratulation to all you. 
I'm 3 years in developing simple database (mysql) java applications and i 
think i can have some free time to contribute in your project. 
I have some years experience in visual basic nd m$ access and i think access 
have some useful things ... (and other very bad..) 
I modify SQLScript plugin for work with other databases (the escape char for 
apostrophe \' doesn't work with some db) and i think to adds more options 
(for dates format ad for large script that goes outOfMemory!!) 
 
Can you tell me what can i do ? 
 
The most important thing for me is the visual query designer and i've read 
that you are going to implement in the 1.2 version? 
 
I can make a pdf report (with iText) for the structure of databases? 
 
Excuse my intrusion, bye. 
 
Marco Ceccarelli 
 
 
 

Hi all,

As you have no doubt noticed I haven't really done anything with
Squirrel since before Christmas. A combination of work and other things
have got in the way. Those of you who have emailed me about issues and
not got a response will be getting one over the next few days as I
slowly work my way through my inbox. I apologize for ignoring you, its
just that my life is slightly hectic at the moment.

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

Wadkar_S wrote:

> I made a small addition to the SQL Panel. This addition allows the user to
> import files from their local file system. It comes handy when current users
> have stored huge sql scripts in their local file system and want to directly
> trigger instead of having to open /copy/paste the contents of such sql
> scripts in the ISQL panel of Squirrel.

You can get the same functionality by installing the 'SQL Scripts' plug-in.


Maury...

--
Maury Hammel
Cronus Technologies Inc.

http://www.cronustech.com

Hi,

I made a small addition to the SQL Panel. This addition allows the user to
import files from their local file system. It comes handy when current users
have stored huge sql scripts in their local file system and want to directly
trigger instead of having to open /copy/paste the contents of such sql
scripts in the ISQL panel of Squirrel.

Below is the code. For sections I added  I have put them inside 
//start.sameer

....my code

//end.sameer

package net.sourceforge.squirrel_sql.fw.gui;
/*
 * Copyright (C) 2001 Colin Bell
 * co...@us...
 *
 * This library is free software; you can redistribute it and/or
 * modify it under the terms of the GNU Lesser General Public
 * License as published by the Free Software Foundation; either
 * version 2.1 of the License, or (at your option) any later version.
 *
 * This library is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 * Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public
 * License along with this library; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
 */
import java.awt.Component;
import java.awt.event.ActionEvent;
import java.awt.event.MouseEvent;

import javax.swing.text.BadLocationException;
import javax.swing.text.Document;
import javax.swing.text.JTextComponent;

import net.sourceforge.squirrel_sql.fw.gui.BasePopupMenu;
import net.sourceforge.squirrel_sql.fw.gui.action.BaseAction;

public class TextPopupMenu extends BasePopupMenu {
	private JTextComponent _comp;

	private CutAction _cut = new CutAction();
	private CopyAction _copy = new CopyAction();
	private PasteAction _paste = new PasteAction();
	private ClearAction _clear = new ClearAction();
	private SelectAllAction _select = new SelectAllAction();
//start.sameer
	private OpenAction _open = new OpenAction();
//end.sameer
	public TextPopupMenu() {
		super();
//start.sameer
		add(_open);		
//end.sameer

		add(_cut);
		add(_copy);
		add(_paste);
		addSeparator();
		add(_clear);
		addSeparator();
		add(_select);
	}

	public void setTextComponent(JTextComponent value) {
		_comp = value;
	}

	/**
	 * Show the menu.
	 */
	public void show(Component invoker, int x, int y) {
		updateActions();
		super.show(invoker, x, y);
	}

	public void show(MouseEvent evt) {
		updateActions();
		super.show(evt);
	}

	protected void updateActions() {
		final boolean isEditable = _comp != null &&
_comp.isEditable();
		_cut.setEnabled(isEditable);
		_paste.setEnabled(isEditable);
	}

	private class ClearAction extends BaseAction {
		ClearAction() {
			super("Clear");
		}

		public void actionPerformed(ActionEvent evt) {
			if (_comp != null) {
				try {
					Document doc = _comp.getDocument();
					doc.remove(0, doc.getLength());
				} catch (BadLocationException ignore) {
				}
			}
		}
	}

	private class CutAction extends BaseAction {
		CutAction() {
			super("Cut");
		}

		public void actionPerformed(ActionEvent evt) {
			if (_comp != null) {
				_comp.cut();
			}
		}
	}

	private class CopyAction extends BaseAction {
		CopyAction() {
			super("Copy");
		}

		public void actionPerformed(ActionEvent evt) {
			if (_comp != null) {
				_comp.copy();
			}
		}
	}

	private class PasteAction extends BaseAction {
		PasteAction() {
			super("Paste");
		}

		public void actionPerformed(ActionEvent evt) {
			if (_comp != null) {
				_comp.paste();
			}
		}
	}

	private class SelectAllAction extends BaseAction {
		SelectAllAction() {
			super("Select All");
		}

		public void actionPerformed(ActionEvent evt) {
			if (_comp != null) {
				_comp.selectAll();
			}
		}
	}
//start.sameer
	private class OpenAction extends BaseAction {
		OpenAction() {
			super("OpenSQLScript");
		}

		public void actionPerformed(ActionEvent evt) 
		{
		      javax.swing.text.Document sqlDocument =
_comp.getDocument();
		      
              try 
              {				                	
				sqlDocument.remove(0,
sqlDocument.getLength());
			  } 
			  catch (BadLocationException ignore) 
			  {
			  }
		      
		      java.awt.Component parent = _comp.getParent();
		      
		      while(!(parent instanceof  java.awt.Frame) &&
parent!=null)
		      {
		        parent = parent.getParent();		        
		      }  
		      if(parent!=null)
		      {		        
               // java.awt.FileDialog fileDialog = new
java.awt.FileDialog((java.awt.Frame)parent,"Open SQL File" );               
                //fileDialog.show();
                javax.swing.JFileChooser chooseSQLFile = new
javax.swing.JFileChooser();
                int returnVal = chooseSQLFile.showOpenDialog(parent);
 
//chooseSQLFile.setFileSelectionMode(javax.swing.JFileChooser.FILES_ONLY);
                 if(returnVal == javax.swing.JFileChooser.APPROVE_OPTION) 
                 {
                     java.io.File selectedFile =
chooseSQLFile.getSelectedFile();
                     try
                     {
                        if(selectedFile.isFile())
                        {  
                            java.io.BufferedReader buffReader = new
java.io.BufferedReader                        
                                                                (new
java.io.FileReader(selectedFile));
                            String input=buffReader.readLine();

                            StringBuffer sqlCommand = new StringBuffer("");

                            while (input != null) 
                            {
                                input=input+"\n";
                                sqlCommand.append(input);
                                input = buffReader.readLine();

                            }
 
sqlDocument.insertString(0,sqlCommand.toString(),null);

                            SelectAllAction selectAllAction = new
SelectAllAction();
                            selectAllAction.actionPerformed(new
ActionEvent(_comp,0,""));
                            
                        }    
                     }                  
                     catch(Exception e)
                     {
                     }   
                 }                
              }
              else
              {
                
              }  
		}
	}
//end.sameer

}

-----Original Message-----
From: squ...@li...
[mailto:squ...@li...] 
Sent: Saturday, December 07, 2002 3:16 PM
To: squ...@li...
Subject: Squirrel-sql-develop digest, Vol 1 #94 - 2 msgs


Send Squirrel-sql-develop mailing list submissions to
	squ...@li...

To subscribe or unsubscribe via the World Wide Web, visit
	https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
or, via email, send a message with subject or body 'help' to
	squ...@li...

You can reach the person managing the list at
	squ...@li...

When replying, please edit your Subject line so it is more specific than
"Re: Contents of Squirrel-sql-develop digest..."


Today's Topics:

   1. Re: Re: [Fwd: Re: CVS Hierarchy [Fwd: Re: help with eclipse?]] (Colin
Bell)
   2. Re: Hello All / Javadoc (Colin Bell)

--__--__--

Message: 1
From: Colin Bell <col...@bi...>
To: squirrel-sql-develop <squ...@li...>
Subject: Re: [Squirrel-sql-develop] Re: [Fwd: Re: CVS Hierarchy [Fwd: Re:
help with eclipse?]]
Date: Sat, 7 Dec 2002 09:45:05 +1100

On Thu, 5 Dec 2002 03:59, Johnathan James wrote:
> Glenn, et al..
>
> Thanks for the instructions!
>
> I agree its possible to make Eclipse recognize where to get the source 
> from, but this method involves setting IDE-wide properties [*1], which 
> means it effects every project that would be loaded afterwards.=20

You don't have to change the defaults, you could simply add a src directo=
ry to=20 the individual project.

>
> Maybe I'm missing something, though.. is there a reason that the code 
> i=
s
> not in CVS in package order (other than its always been done that 
> way)? Would it not be easier to have it that way already rather than 
> re-creating environments and so forth?

The thing to remember is that its really two projects. the fw source whic=
h=20 ends ups as fw.jar) is the beginnings of a framework that could be used
f= or=20 other projects, not just squirrel, and shouldn't "know" about any
of the=20 actual squirrel classes and the actual squirrel code which ends up
in=20 squirrel-sql.jar

The whole build process is going to be revamped very shortly based on wor=
k=20 Patrick Lacson has done. For an idea of what this is going to be like
you=  can=20 take a look at the module squirrel in CVS and look back through
Patricks=20 postings to the dev list.

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



--__--__--

Message: 2
From: Colin Bell <col...@bi...>
To: squ...@li...
Subject: Re: [Squirrel-sql-develop] Hello All / Javadoc
Date: Sat, 7 Dec 2002 08:41:05 +1100

On Wed, 27 Nov 2002 14:51, Johnathan James wrote:
> ------------------------------------
>
> <<< This should be added to the 'help' target:
>
>          <echo message=3D" javadoc: Compiles the javadoc from the app/ 
> =
and
> fw/ sources."/>
>          <echo message=3D""/>
>
> <<< This is the new javadoc target.
>
>      <!--
>      
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>      Build the JavaDoc
>      No parameters
>      
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>      -->
>
>      <target name=3D"javadoc">
>          <mkdir dir=3D"${basedir}/doc/javadoc"/>
>          <javadoc packagenames=3D"net.sourceforge.squirrel_sql.*"
>                   sourcepath=3D"${basedir}/app/src;${basedir}/fw/src"
>                   destdir=3D"${basedir}/doc/javadoc">
>          </javadoc>
>      </target>
>
>
>

Thanks Johnathan, this has been added to the build.xml
--=20
Colin Bell
http://squirrel-sql.sf.net




--__--__--

_______________________________________________
Squirrel-sql-develop mailing list Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop


End of Squirrel-sql-develop Digest

On Wed, 27 Nov 2002 14:51, Johnathan James wrote:
> ------------------------------------
>
> <<< This should be added to the 'help' target:
>
>          <echo message=3D" javadoc: Compiles the javadoc from the app/ =
and
> fw/ sources."/>
>          <echo message=3D""/>
>
> <<< This is the new javadoc target.
>
>      <!--
>      =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>      Build the JavaDoc
>      No parameters
>      =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>      -->
>
>      <target name=3D"javadoc">
>          <mkdir dir=3D"${basedir}/doc/javadoc"/>
>          <javadoc packagenames=3D"net.sourceforge.squirrel_sql.*"
>                   sourcepath=3D"${basedir}/app/src;${basedir}/fw/src"
>                   destdir=3D"${basedir}/doc/javadoc">
>          </javadoc>
>      </target>
>
>
>

Thanks Johnathan, this has been added to the build.xml
--=20
Colin Bell
http://squirrel-sql.sf.net

On Thu, 5 Dec 2002 03:59, Johnathan James wrote:
> Glenn, et al..
>
> Thanks for the instructions!
>
> I agree its possible to make Eclipse recognize where to get the source
> from, but this method involves setting IDE-wide properties [*1], which
> means it effects every project that would be loaded afterwards.=20

You don't have to change the defaults, you could simply add a src directo=
ry to=20
the individual project.

>
> Maybe I'm missing something, though.. is there a reason that the code i=
s
> not in CVS in package order (other than its always been done that way)?
> Would it not be easier to have it that way already rather than
> re-creating environments and so forth?

The thing to remember is that its really two projects. the fw source whic=
h=20
ends ups as fw.jar) is the beginnings of a framework that could be used f=
or=20
other projects, not just squirrel, and shouldn't "know" about any of the=20
actual squirrel classes and the actual squirrel code which ends up in=20
squirrel-sql.jar

The whole build process is going to be revamped very shortly based on wor=
k=20
Patrick Lacson has done. For an idea of what this is going to be like you=
 can=20
take a look at the module squirrel in CVS and look back through Patricks=20
postings to the dev list.

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

Glenn, et al..

Thanks for the instructions!

I agree its possible to make Eclipse recognize where to get the source 
from, but this method involves setting IDE-wide properties [*1], which 
means it effects every project that would be loaded afterwards. Also, 
there should be no need to create a separate project to set up the 
correct directory structure [*2]. If it was already that way in CVS, you 
could just pull, and point your IDE to the beginning 'net.sourceforge' 
directory, and you'd be off and running.

Maybe I'm missing something, though.. is there a reason that the code is 
not in CVS in package order (other than its always been done that way)? 
Would it not be easier to have it that way already rather than 
re-creating environments and so forth?

Johnathan

Glenn wrote:

> -------- Original Message --------
> Subject: Re: CVS Hierarchy [Fwd: Re: help with eclipse?]
> Date: Tue, 03 Dec 2002 13:45:39 -0500
> From: gwg <gw...@co...>
> To: squirrel-sql-develop <squ...@li...>
> 
> Johnathan,
> 
> When I started using Eclipse on squirrel, I had the same trouble as you.
>   Colin is also using Eclipse, and he sent me the following
> instructions.  Once you get it set up, it is simple to do the cvs
> operations.  When I checkout a clean cvs copy, it takes me less than 5
> minutes to re-create my Eclipse environment in the fresh directory.
> 
> I'm posting this to the mail list in case other people have the same
> question and so that it is archived in a public place.
> 
> Hope this helps.
> 
> Glenn
> 
> [snip]
 >
> Colin Bell wrote:
> 
>  > Hi Glenn,
>  >
>  > In Window/Preferences Java/New Project I tell Eclipse to use src
>  > and bin for new projects. [*1]
>  >
>  > I create a separate project for each component [*2] so my directory
>  > structure is something like
>  >
>  > squirrel-sql/app
>  > squirrel-sql/fw
>  > squirrel-sql/plugins/jedit
>  > squirrel-sql/plugins/laf
>  >
>  > etc.
>  >
>  > For the framework project (all the code that ends up in fw.jar) I have
>  > my source in a subfolder
>  >
>  > squirrel-sql/fw/src
>  >
>  > I create the project so that squirrel-sql/fw is the base directory
>  > for it.
>  >
>  > So the source is something like
>  >
>  > squirrel-sql/fw/src/net/sourceforge/squirrel_sql/fw/sql
>  >
>  > etc.
>  >
>  > Then I create an app project and its folders
>  >
>  > squirrel-sql/app/src/net/sourceforge/squirrel_sql/client/sql
>  >
>  > In the app project I also add the fw project as one of the required
>  > projects in the java Build path in the project properties.
>  >
>  > And then I create another project for each plugin in a similar
>  > fashion.
>  >
>  > Grabbing the source from CVS should give you the correct directory
>  > structure, I think the trick is setting the Eclipse preferences to
>  > look for source in the src subdirectory.
>  >
>  > Johan does it in a different way. He just has (I think) one project
>  > with multiple source paths. The problem with doing it this way is its
>  > easy to have incorrect references in the source. I.E. none of the
>  > classes in the fw project should know about any of the classes in the
>  > app project, no class in the app project should know about classes in
>  > a particular plugin.
>  >
>  > fw classes are supposed to be a generic set of classes that could be
>  > used in any application.
>  >
>  > This is my .classpath file for the fw project:
>  >
>  > <?xml version="1.0" encoding="UTF-8"?>
>  > <classpath>
>  >     <classpathentry kind="src" path="src"/>
>  >     <classpathentry kind="var" path="JRE_LIB" rootpath="JRE_SRCROOT"
>  > sourcepath="JRE_SRC"/>
>  >     <classpathentry kind="lib" path="lib/log4j.jar"/>
>  >     <classpathentry kind="lib" path="lib/nanoxml-2.1.jar"/>
>  >     <classpathentry kind="output" path="bin"/>
>  > </classpath>
>  >
>  > Give me a yell if this doesn't help.
>  >
>  > --
>  > Colin Bell
>  > http://squirrel-sql.sf.net
>  >
>  > ----- Original Message -----
>  > From: Glenn <gw...@co...>
>  > Date: Friday, October 11, 2002 9:56 am
>  > Subject: help with eclipse?
>  >
>  >
>  >>Colin,
>  >>
>  >>From one of your messages I understood that you are using
>  >>eclipse. If I
>  >>misunderstood let me know, but if you are I'ld appreciate any tips
>  >>you
>  >>can give me.
>  >>
>  >>My main problem at the moment is importing the source in a clean
>  >>way.  I
>  >>have been able to get it to compile and start running, but it took
>  >>a lot
>  >>of tinkering and I can't see working that way on a permanent
>  >>basis.  I
>  >>cannot see how to just suck in the code an run.  The main problem
>  >>seems
>  >>to be that I cannot tell eclipse how to set up the package names
>  >>on
>  >>import, so it includes the full path for the file in the package
>  >>name,
>  >>and then complains when that doesn't match the package name
>  >>declared in
>  >>the file.  The other issue is how to tell it what to build and
>  >>what
>  >>environment to use during that build.
>  >>
>  >>Any pointers you can suggest would be great!  Thanks.
>  >>
>  >>Glenn
>  >>
>  >>
>  >>
>  >
>  >
>  >
>  >
>  >
> 
> 
> 
> 
> 

hi,

Eclipse works fine in the current setup

I can do anything i want. The only thing i generated are the plugins jar files
that i store in the plugin dir so that the plugin manager does find the plugins

And all the plugins have there own src folder so that after that i can debug through
all the plugins.

I just checked in the latest .classpath and .project file i use (they where already there)
and it should go fine.




----- Original Message ----- 
From: "Johnathan James" <squ...@ha...>
To: "squirrel-sql-develop" <squ...@li...>
Sent: Tuesday, December 03, 2002 5:49 PM
Subject: [Squirrel-sql-develop] CVS Hierarchy


> Hey all..
> 
> In my projects I try to arrange the code so you can pull it from source 
> control and build. Quick and easy. Its not that way with SQuirreL 
> though, because even though the hierarchy is pretty well defined, the 
> code doesn't sit in the hierarchy correctly, so the IDE (Eclipse in this 
> case) thinks it has all kinds of errors. I've tried a bunch of ways to 
> fix it, but short of pulling the code from CVS and copying it to another 
> location, then importing the code into the project, I don't see how it 
> could be done. Anyway, wouldn't it be easier to have the hiearchy be 
> something like
> 
> SQL12\net\sourceforge\squirrel-sql\...
> 
> where '...' is 'client' or 'fw' or 'plugin', rather than
> 
> SQL12\app\src\net\sourceforge\suirrel-sql\...
> 
> The second (and current) method is redundant because it says what part 
> of the hierarchy this is more than once. Its also technically wrong, 
> because the Application class in says its in package 
> 'net.sourceforge.squirrel_sql.client' but its actually in 
> 'app.src.net.sourceforge.squirrel_sql.client'.
> 
> If its decided that something should be done, I can give more specific 
> ideas on where things should go.
> 
> Long story short I think there are some good reasons to change that 
> hierarchy now. It will only get harder once the project gets bigger.
> 
> Johnathan
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: Microsoft Visual Studio.NET 
> comprehensive development tool, built to increase your 
> productivity. Try a free online hosted session at:
> http://ads.sourceforge.net/cgi-bin/redirect.pl?micr0003en
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
> 

Hey all..

In my projects I try to arrange the code so you can pull it from source 
control and build. Quick and easy. Its not that way with SQuirreL 
though, because even though the hierarchy is pretty well defined, the 
code doesn't sit in the hierarchy correctly, so the IDE (Eclipse in this 
case) thinks it has all kinds of errors. I've tried a bunch of ways to 
fix it, but short of pulling the code from CVS and copying it to another 
location, then importing the code into the project, I don't see how it 
could be done. Anyway, wouldn't it be easier to have the hiearchy be 
something like

	SQL12\net\sourceforge\squirrel-sql\...

where '...' is 'client' or 'fw' or 'plugin', rather than

	SQL12\app\src\net\sourceforge\suirrel-sql\...

The second (and current) method is redundant because it says what part 
of the hierarchy this is more than once. Its also technically wrong, 
because the Application class in says its in package 
'net.sourceforge.squirrel_sql.client' but its actually in 
'app.src.net.sourceforge.squirrel_sql.client'.

If its decided that something should be done, I can give more specific 
ideas on where things should go.

Long story short I think there are some good reasons to change that 
hierarchy now. It will only get harder once the project gets bigger.

Johnathan

On Wed, 27 Nov 2002 16:13, Johnathan James wrote:
> Hi..
>
> I didn't see any messages on how patches should be submitted, so I'm
> just going to submit this one to the dev list.. Please let me know if
> things are done a different way on this project.. Thanks..
>
> Basically, the problem with this was that the code was asking to sort o=
n
> the model index of the column, rather than the physical index.
>
> Enjoy!
>
> Johnathan

Hi Johnathan,

Thanks, this has been applied.

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

I am very impressed with the SQL editor's code completion feature. Looks
nice and seems to work well. Wish we could get permission to use it in
Squirrel instead of having to develop our own...

I am not impressed with the way that tool displays metadata information.
Shows far less info than Squirrel does, and in an inconvenient format. I
really like Squirrel's tab interface.

Stephen

----- Original Message -----
From: "Johan Compagner" <jco...@j-...>
To: "squirrel-sql develop" <squ...@li...>
Sent: Wednesday, November 27, 2002 10:01 AM
Subject: [Squirrel-sql-develop] maybe some nice features we can use also in
squirrel?


> http://www.aquafold.com/index.html
>
> johan
>
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Get the new Palm Tungsten T
> handheld. Power & Color in a compact size!
> http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0002en
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop

Seems everybodys writing an ISQL tool these days... :-(

I'll take a look, I hadn't seen this one before.

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

----- Original Message -----
From: "Johan Compagner" <jco...@j-...>
Date: Thursday, November 28, 2002 2:01 am
Subject: [Squirrel-sql-develop] maybe some nice features we can use also
in squirrel?

> http://www.aquafold.com/index.html
> 
> johan
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: Get the new Palm Tungsten T 
> handheld. Power & Color in a compact size! 
> http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0002en
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
> 
 

http://www.aquafold.com/index.html

johan

Version 1.1final1 has just been released. This is a minor bug fix release=
=20
which addresses two issues:

- Fix for error when displaying
  catalogs/schemas when using
  jTDS 4 and above.
- Fix column privileges display
  for MySQL.

The homepage can be found at http://squirrel-sql.sourceforge.net/ and the
downloads are at
https://sourceforge.net/project/showfiles.php?group_id=3D28383&release_id=
=3D124587

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

On Wed, 27 Nov 2002 16:13, Johnathan James wrote:
> Hi..
>
> I didn't see any messages on how patches should be submitted, so I'm
> just going to submit this one to the dev list.. Please let me know if
> things are done a different way on this project.. Thanks..
>
> Basically, the problem with this was that the code was asking to sort o=
n
> the model index of the column, rather than the physical index.
>
> Enjoy!
>
> Johnathan

And thank you again!!!

I'll apply this to the 1.2 branch as well. I think submitting patches to =
the=20
dev list is the best way to do it, it gives everybody an opportunity to t=
ake=20
a look.

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

On Wed, 27 Nov 2002 14:51, Johnathan James wrote:
> Hey everyone..
>
> First I'd like to introduce myself.. My name is Johnathan James. I'm a
> developer in Denver, Colorado, USA. I would rather program in Java, and
> I'm a good Java coder if I do say so myself. :) I also have experience
> in C++, thats what I started programming in. I have a pretty good
> understanding of SQL, object oriented design, and all the other
> buzzwords.. I have a project of my own called Selftest. You can see it
> at http://sourceforge.net/projects/selftest. If you have any other
> questions, please feel free to ask.
>
> Anyway, while working on Selftest, I decided I need a GUI for the
> database portion that I'm working on, so thats how I stumbled upon
> Squirrel. I also wanted to do some work on a project that other people
> were actively contributing to. I was working on a bug in Squirrel and
> found that the Javadoc would be helpful, but there was no Ant script to
> build it. So I guess that will be my first contribution.
>
> The target builds the doc into the ${basedir}/doc/javadoc directory. It
> presents a lot of warnings because the source is not available for LOG4=
J
> and NANOXML, and various errors in the javadoc comments, but it builds
> without error, and gives some good javadoc..

Thanks, this has been one of the many things on my todo list so I'm very =
glad=20
you saved me the trouble. Now all I have to fix is fix the javaDoc in the=
=20
source. :-)

I'll add this to the 1.2 version of the code in the next day or 2.

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

Hi..

I didn't see any messages on how patches should be submitted, so I'm 
just going to submit this one to the dev list.. Please let me know if 
things are done a different way on this project.. Thanks..

Basically, the problem with this was that the code was asking to sort on 
the model index of the column, rather than the physical index.

Enjoy!

Johnathan