SQuirreL SQL Client

Hello Petr,

I am responsible for producing the release builds and have to confess guilt
for neglect in the MacOS X offering.  I don't have access to a machine with
this platform, so I've been relying on contributions from others who are
willing to start with the distributions we create, and put them into a format
that MacOS X users find more convenient.  I can place the distribution
you've created up on SF for you.  I'd also like to take a look at whatever
scripts you used, so I might be able to incorporate it into the release
builds. I'll be careful to attribute anything you send me to you so that your
contribution is recorded for future use.

Rob

On 10/28/06, Colin Bell <col@...> wrote:
> Hi Petr,
>
> I've cced the SQuirreL developers list so that the appropriate person
> will see this mail.
>
>
> On Sat, Oct 28, 2006 at 09:30:21AM -0700, Petr Srajer wrote:
> >
> > Message body follows:
> >
> >         Hello Colin.
> >
> >     I have created Squirrel 2.3 simple installation package for OS X. It contains:
> > -A little bit better icon
> > -Starting scripts
> > -ReadMe.rtf and License.rtf
> > -Description how to make OS X install package
> > -Squirrel-2.3.dmg file is big - cca 15MB.
> >
> > I found "mac" directory in src, but the content is old.  My questions are:
> >
> > 1) It is possible to put this install package to download section? If yes then
> > who can put it there?
> > 2) How can I put content of installation files (icons, scripts,...) into CVS ?
> >
> > Bye
> >   Petr.
> >
> > --
> > This message has been sent to you, a registered SourceForge.net user,
> > by another site user, through the SourceForge.net site.  This message
> > has been delivered to your SourceForge.net mail alias.  You may reply
> > to this message using the "Reply" feature of your email client, or
> > using the messaging facility of SourceForge.net at:
> > https://sourceforge.net/sendmessage.php?touser=651297
> >
>
> --
> Colin Bell
> http://www.baibell.org
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squirrel-sql-develop@...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>

And I'd be happy (I'm sure Petr would as well) to offer any suggestions as to incorporating a solid OS X [app bundle] target into the IzPack installer process (the OS X ant task doesn't include any additional plugins). For me, the main catch so far is that I haven't had the time to figure out how the IzPack stuff is configured, launched and built. Nor, regretably, have I even asked here for assistance in replicating the build process.

Perhaps those of us with an interest in improving the OS X product could collaborate on some goals for the next release.

-Charles
 charlesa@...

At 9:36 PM -0400 10/28/06, Robert Manning wrote:
>Hello Petr,
>
>I am responsible for producing the release builds and have to confess guilt
>for neglect in the MacOS X offering.  I don't have access to a machine with
>this platform, so I've been relying on contributions from others who are
>willing to start with the distributions we create, and put them into a format
>that MacOS X users find more convenient.  I can place the distribution
>you've created up on SF for you.  I'd also like to take a look at whatever
>scripts you used, so I might be able to incorporate it into the release
>builds. I'll be careful to attribute anything you send me to you so that your
>contribution is recorded for future use.
>
>Rob
>
>On 10/28/06, Colin Bell <col@...> wrote:
>> Hi Petr,
>>
>> I've cced the SQuirreL developers list so that the appropriate person
>> will see this mail.
>>
>>
>> On Sat, Oct 28, 2006 at 09:30:21AM -0700, Petr Srajer wrote:
>> >
>> > Message body follows:
>> >
>> >         Hello Colin.
>> >
>> >     I have created Squirrel 2.3 simple installation package for OS X. It contains:
>> > -A little bit better icon
>> > -Starting scripts
>> > -ReadMe.rtf and License.rtf
>> > -Description how to make OS X install package
>> > -Squirrel-2.3.dmg file is big - cca 15MB.
>> >
>> > I found "mac" directory in src, but the content is old.  My questions are:
>> >
>> > 1) It is possible to put this install package to download section? If yes then
>> > who can put it there?
>> > 2) How can I put content of installation files (icons, scripts,...) into CVS ?
>> >
>> > Bye
> > >   Petr.

On 10/29/06, Charles Albrecht <charlesa@...> wrote:
> And I'd be happy (I'm sure Petr would as well) to offer any suggestions as to incorporating a solid OS X [app bundle] target into the IzPack installer process (the OS X ant task doesn't include any additional plugins). For me, the main catch so far is that I haven't had the time to figure out how the IzPack stuff is configured, launched and built. Nor, regretably, have I even asked here for assistance in replicating the build process.
>

IzPack uses an XML file (izpack-super.xml for current installer) to
build an install jar.
This file tells it exactly what files get installed and where (and
which ones are
mandatory - in our case "base") .  We include all of the plugins in
the install jar and
group them into "standard" which is our way of saying universal not
dependant on
your database and "optional" which includes everything else.  Although
this makes
the installer big (~15M), it eases the burden of downloading plugins
and dealing
with version compatibility.  We have release build scripts that take
the installer and
build the various platform-specific plain zip archives.  IzPack can
take an "auto-install"
XML file and feed that to the installer to eliminate the need to use a
GUI.  This way,
the plain zips are created with a script.  We currently produce 6 of
them - 3 for Win32
and 3 for UNIX.  The three are Base, Standard and Optional plain zips provide
only what there name indicates, with Optional being the whole enchilada.

For Win32 and UNIX, the file structure of SQuirreL once installed is
pretty much the
same - just different launch scripts.  I don't know if the same can be
said for MacOS X.
If it's just moving a few files around, we could probably have a new
script to produce
plain zips for MacOS X.  That's not very flexible for the user - they
must then choose
either base, standard or *all* optional plugins.  If we want to have
the installer be
able to recognize MacOS X and lay the files down differently that will
take a bit of
work - I believe - in the izpack-super.xml file.  Maybe even some
post-installation
work.  Not having a Mac I'm a little out of my element here, so those are just
guesses.  I guess I really need to know what the key parts of a MacOS X app
directory structure are.  I'll do some research and see what I find.

Rob

It's been me who has previously done mac customisations, but I'm a bit
busy at the moment at work. If you look in sql12/build/build.xml there
is a mac_dist target which produces a .app package for the mac with
appropriate plugins (in particular the macos plugin) and documentation
in the right place, and then wraps that as a compressed file for
distribution. Someone (Gerd ?) fixed (or intended to fix) the macos
package so it should build on any platform (using reflection to
determine if and use the mac-specific libraries where available) so
actually mac the mac distribution should be buildable on any platform -
I don't think that has been tested though. I didn't know how to produce
a .dmg and decided not to as I think that would restrict the build
process to running on a mac only.

Anyway with v2.3 I've build a local copy on my mac and it all worked
fine but I'm not going to get a chance to do anything about uploading
any time soon so if someone (Petr) has the time then thank-you...

Neville

-----Original Message-----
From: squirrel-sql-develop-bounces@...
[mailto:squirrel-sql-develop-bounces@...] On Behalf Of
Robert Manning
Sent: 29 October 2006 01:36
To: Petr Srajer
Cc: squirrel-sql-develop@...
Subject: Re: [Squirrel-sql-develop] Mac OS X install package

Hello Petr,

I am responsible for producing the release builds and have to confess
guilt for neglect in the MacOS X offering.  I don't have access to a
machine with this platform, so I've been relying on contributions from
others who are willing to start with the distributions we create, and
put them into a format that MacOS X users find more convenient.  I can
place the distribution you've created up on SF for you.  I'd also like
to take a look at whatever scripts you used, so I might be able to
incorporate it into the release builds. I'll be careful to attribute
anything you send me to you so that your contribution is recorded for
future use.

Rob

On 10/28/06, Colin Bell <col@...> wrote:
> Hi Petr,
>
> I've cced the SQuirreL developers list so that the appropriate person=20
> will see this mail.
>
>
> On Sat, Oct 28, 2006 at 09:30:21AM -0700, Petr Srajer wrote:
> >
> > Message body follows:
> >
> >         Hello Colin.
> >
> >     I have created Squirrel 2.3 simple installation package for OS
X. It contains:
> > -A little bit better icon
> > -Starting scripts
> > -ReadMe.rtf and License.rtf
> > -Description how to make OS X install package -Squirrel-2.3.dmg file

> > is big - cca 15MB.
> >
> > I found "mac" directory in src, but the content is old.  My
questions are:
> >
> > 1) It is possible to put this install package to download section?=20
> > If yes then who can put it there?
> > 2) How can I put content of installation files (icons, scripts,...)
into CVS ?
> >
> > Bye
> >   Petr.
> >
> > --
> > This message has been sent to you, a registered SourceForge.net=20
> > user, by another site user, through the SourceForge.net site.  This=20
> > message has been delivered to your SourceForge.net mail alias.  You=20
> > may reply to this message using the "Reply" feature of your email=20
> > client, or using the messaging facility of SourceForge.net at:
> > https://sourceforge.net/sendmessage.php?touser=3D651297
> >
>
> --
> Colin Bell
> http://www.baibell.org
>
> ----------------------------------------------------------------------
> --- Using Tomcat but need to do more? Need to support web services,=20
> security?
> Get stuff done quickly with pre-integrated technology to make your job

> easier Download IBM WebSphere Application Server v.1.0.1 based on=20
> Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=
=3D1216
> 42 _______________________________________________
> Squirrel-sql-develop mailing list
> Squirrel-sql-develop@...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>

------------------------------------------------------------------------
-
Using Tomcat but need to do more? Need to support web services,
security?
Get stuff done quickly with pre-integrated technology to make your job
easier Download IBM WebSphere Application Server v.1.0.1 based on Apache
Geronimo
http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=3D1=
21642
_______________________________________________
Squirrel-sql-develop mailing list
Squirrel-sql-develop@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop


---------------------------------------------------------------------------=
-----
The information contained herein is confidential and is intended solely for=
 the
addressee. Access by any other party is unauthorised without the express=20
written permission of the sender. If you are not the intended recipient, pl=
ease=20
contact the sender either via the company switchboard on +44 (0)20 7623 800=
0, or
via e-mail return. If you have received this e-mail in error or wish to rea=
d our
e-mail disclaimer statement and monitoring policy, please refer to=20
http://www.dresdnerkleinwort.com/disc/email/ or contact the sender.=20
---------------------------------------------------------------------------=
-----

Rob built the current OS X build for 2.3 (SquirrelsQLMac-2.3final.tgz) using little more than the "mac_dist" ant task and a couple of sed scripts to fix the version information in the Info.plist. And, notably, not on a mac.

[Note, the weird capitalization in the name "SquirrelsQLMac-2.3final.tgz" was sloppy typing on my part when I sent him a script to make a distributable build. I probably should have gone with "squirrel-sql2.3final-macosx.tar.gz" or "squirrel-sql2.3final-macosx-base.tar.gz" so it looked like the rest of the release, and notably, like 2.0rc1. C'est la vie.]

Granted, we don't have the latest JavaApplicationStub in CVS (as Petr noted earlier) and I suppose that could lead to issues.

One of the things I've been wondering is whether we can leverage OS X-style "Contents/Plugins" and "Contents/Plugins (Disabled)" directories inside the app bundle (and get the classpaths to interpret correctly) so as to allow turning the plugins on and off via the Finder's Get Info window. But that might involve modifying the plugin loader mechanism. Especially if OS X expects ".plugin" bundles.

Questions, questions, questions, and little time to dig in and find the answers - even if they are relatively straightforward. >sigh<

-Charles
 charlesa@...



At 7:46 AM +0000 10/29/06, Rowe, Neville wrote:
>It's been me who has previously done mac customisations, but I'm a bit
>busy at the moment at work. If you look in sql12/build/build.xml there
>is a mac_dist target which produces a .app package for the mac with
>appropriate plugins (in particular the macos plugin) and documentation
>in the right place, and then wraps that as a compressed file for
>distribution. Someone (Gerd ?) fixed (or intended to fix) the macos
>package so it should build on any platform (using reflection to
>determine if and use the mac-specific libraries where available) so
>actually mac the mac distribution should be buildable on any platform -
>I don't think that has been tested though. I didn't know how to produce
>a .dmg and decided not to as I think that would restrict the build
>process to running on a mac only.
>
>Anyway with v2.3 I've build a local copy on my mac and it all worked
>fine but I'm not going to get a chance to do anything about uploading
>any time soon so if someone (Petr) has the time then thank-you...
>
>Neville
>
>-----Original Message-----
>From: squirrel-sql-develop-bounces@...
>[mailto:squirrel-sql-develop-bounces@...] On Behalf Of
>Robert Manning
>Sent: 29 October 2006 01:36
>To: Petr Srajer
>Cc: squirrel-sql-develop@...
>Subject: Re: [Squirrel-sql-develop] Mac OS X install package
>
>Hello Petr,
>
>I am responsible for producing the release builds and have to confess
>guilt for neglect in the MacOS X offering.  I don't have access to a
>machine with this platform, so I've been relying on contributions from
>others who are willing to start with the distributions we create, and
>put them into a format that MacOS X users find more convenient.  I can
>place the distribution you've created up on SF for you.  I'd also like
>to take a look at whatever scripts you used, so I might be able to
>incorporate it into the release builds. I'll be careful to attribute
>anything you send me to you so that your contribution is recorded for
>future use.
>
>Rob
>
>On 10/28/06, Colin Bell <col@...> wrote:
>> Hi Petr,
>>
>> I've cced the SQuirreL developers list so that the appropriate person
>> will see this mail.
>>
>>
>> On Sat, Oct 28, 2006 at 09:30:21AM -0700, Petr Srajer wrote:
>> >
>> > Message body follows:
>> >
>> >         Hello Colin.
>> >
>> >     I have created Squirrel 2.3 simple installation package for OS
>X. It contains:
>> > -A little bit better icon
>> > -Starting scripts
>> > -ReadMe.rtf and License.rtf
>> > -Description how to make OS X install package -Squirrel-2.3.dmg file
>
>> > is big - cca 15MB.
> > >
>> > I found "mac" directory in src, but the content is old.  My
>questions are:
>> >
>> > 1) It is possible to put this install package to download section?
>> > If yes then who can put it there?
>> > 2) How can I put content of installation files (icons, scripts,...)
>into CVS ?
>> >
>> > Bye
>> >   Petr.
>> >
>> > --
>> > This message has been sent to you, a registered SourceForge.net
>> > user, by another site user, through the SourceForge.net site.  This
>> > message has been delivered to your SourceForge.net mail alias.  You
>> > may reply to this message using the "Reply" feature of your email
>> > client, or using the messaging facility of SourceForge.net at:
>> > https://sourceforge.net/sendmessage.php?touser=651297
>> >
>>
>> --
>> Colin Bell
>> http://www.baibell.org
>>
>> ----------------------------------------------------------------------
>> --- Using Tomcat but need to do more? Need to support web services,
>> security?
>> Get stuff done quickly with pre-integrated technology to make your job
>
>> easier Download IBM WebSphere Application Server v.1.0.1 based on
>> Apache Geronimo
>> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=1216
>> 42 _______________________________________________
>> Squirrel-sql-develop mailing list
>> Squirrel-sql-develop@...
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>>
>
>------------------------------------------------------------------------
>-
>Using Tomcat but need to do more? Need to support web services,
>security?
>Get stuff done quickly with pre-integrated technology to make your job
>easier Download IBM WebSphere Application Server v.1.0.1 based on Apache
>Geronimo
>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
>_______________________________________________
>Squirrel-sql-develop mailing list
>Squirrel-sql-develop@...
>https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>
>
>--------------------------------------------------------------------------------
>The information contained herein is confidential and is intended solely for the
>addressee. Access by any other party is unauthorised without the express
>written permission of the sender. If you are not the intended recipient, please
>contact the sender either via the company switchboard on +44 (0)20 7623 8000, or
>via e-mail return. If you have received this e-mail in error or wish to read our
>e-mail disclaimer statement and monitoring policy, please refer to
>http://www.dresdnerkleinwort.com/disc/email/ or contact the sender.
>--------------------------------------------------------------------------------
>
>
>-------------------------------------------------------------------------
>Using Tomcat but need to do more? Need to support web services, security?
>Get stuff done quickly with pre-integrated technology to make your job easier
>Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
>_______________________________________________
>Squirrel-sql-develop mailing list
>Squirrel-sql-develop@...
>https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop

At 8:04 AM -0400 10/29/06, Robert Manning wrote:
>
>On 10/29/06, Charles Albrecht <charlesa@...> wrote:
>>
>>And I'd be happy (I'm sure Petr would as well) to offer any
>>suggestions as to incorporating a solid OS X [app bundle] target
>>into the IzPack installer process (the OS X ant task doesn't include
>>any additional plugins). 
>
>IzPack uses an XML file (izpack-super.xml for current installer) to
>build an install jar. 

That's built from build/snapshot/izpack-super.xml.template, right? It looks like build/izpack-super.xml has been deleted.

>then choose either base, standard or *all* optional plugins. If we
>want to have the installer be able to recognize MacOS X and lay the
>files down differently that will take a bit of work - I believe -
>in the izpack-super.xml file. Maybe even some post-installation
>work. Not having a Mac I'm a little out of my element here, so
>those are just guesses. I guess I really need to know what the key
>parts of a MacOS X app directory structure are. I'll do some
>research and see what I find.

An OS X app build is essentially the mac/Contents directory inside of a directory with a ".app" suffix with the normal distribution files placed in a directory called Java inside Contents/Resources. Contents/MacOS/JavaApplicationStub needs to be executable. Beyond that, it should be fairly straightforward. Contents/Info.plist has two fields which should reflect the current version number. And the process that pulls that into the IzPack jar could update those before pulling it in. It seems that it already does this for Version.java.

I'll try to take some time this week to play around with the izpack-super template and see whether I can generate some functional OS X installers with it.

-Charles
 charlesa@...

I've generated an OS X build of 2.3 final for upload to the sf site. It's approximately 2.5 MB.

I can send it along for upload [1]. Where would be the best place?

(I'd also like to get a better understanding of the IzPack installer process so that an OS X app bundle can be one of the standard outputs of the installer, but that's a discussion for another time.)


-Charles Albrecht
 charlesa@...


[1] it would be the same as running a script like this at the root of the sql12 directory.

#!/bin/sh
# build.properties isn't maintained, so until the ant task knows 
# about Version.java, hard code the bundle's version strings, 
# CFBundleShortVersionString and CFBundleVersion

PLIST=./mac/Contents/Info.plist
VERS="2.3 Final"

sed -i -e "s|<string>1.2</string>|<string>${VERS}</string>|" ${PLIST}

sed -i -e "s|<string>????</string>|<string>SQrL</string>|" ${PLIST}

sed -i -e \
"s|<string>@SquirrelVersion@... SQL ${VERS}</string>|" ${PLIST}

pushd build
  ant mac_dist
popd

pushd ../squirrel-sql-dist/squirrel-sql
  mv SquirrelSQLMac.tar.gz SquirrelsQLMac-2.3final.tgz
popd

#__END__