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

> It looks to me like a bug at line 163 ResultSetDataSet:
>
> rdr = new ResultSetReader(rs, null);
>
> instead should be:
>
> rdr = new ResultSetReader(rs, dialectType);
>

Yep, that worked! I'll send you a patch file containing the plugin
extension and the bug fix.
______________________________________________________

Cedros Gesellschaft fuer Datenverarbeitung mbH
Siegburger Strasse 35 . D-53757 Sankt Augustin
Telefon +49 (0)22 41-88 34-0 . Telefax +49 (0)22 41-88 34 11
Geschaeftsfuehrung: Armin Dreiling, Markus Michels USt-ID DE123113291;
Registergericht: Amtsgericht Siegburg, HR B 3526
______________________________________________________

Diese E-Mail kann vertrauliche und/oder rechtlich geschuetzte
Informationen enthalten und ist nur fuer die Person bestimmt, an die
adressiert wurde. Sollten Sie diese Nachricht irrtuemlich erhalten
haben, untersagen wir, diese zu verteilen, zu veroeffentlichen,
auszudrucken oder zu speichern. Bitte benachrichtigen Sie den
Absender ueber den irrtuemlichen Erhalt und loeschen Sie diese E-Mail
von jedem Computer.

This e-mail may contain confidential and/or legally protected
information and is only intended for the person it is addressed to.
If you have received this message in error, it is prohibited to copy,
disclose, publish, print or save it. You should notify the sender and
delete this message from all computers.

2008/2/28  <Lar...@ce...>:
> > In your DB2XmlTypeDataTypeComponent,  what is returned for getDialect ?
>
>  DialectType.DB2
>

It looks to me like a bug at line 163 ResultSetDataSet:

rdr = new ResultSetReader(rs, null);

instead should be:

rdr = new ResultSetReader(rs, dialectType);

This prevents the call to
CellComponentFactory.readResultWithPluginRegisteredDataType from
passing in the dialect type (it is null) .  Since the dialect type is
null, the default IDataTypeComponent is used.  Somehow when I was
refactoring to support pluggable type handlers,  I made the API change
that was needed, but I apparently neglected to hookup the new
argument. Can you try the change above and let us know if it helps?

Rob

> In your DB2XmlTypeDataTypeComponent,  what is returned for getDialect ?

DialectType.DB2


______________________________________________________

Cedros Gesellschaft fuer Datenverarbeitung mbH
Siegburger Strasse 35 . D-53757 Sankt Augustin
Telefon +49 (0)22 41-88 34-0 . Telefax +49 (0)22 41-88 34 11
Geschaeftsfuehrung: Armin Dreiling, Markus Michels USt-ID DE123113291;
Registergericht: Amtsgericht Siegburg, HR B 3526
______________________________________________________

Diese E-Mail kann vertrauliche und/oder rechtlich geschuetzte
Informationen enthalten und ist nur fuer die Person bestimmt, an die
adressiert wurde. Sollten Sie diese Nachricht irrtuemlich erhalten
haben, untersagen wir, diese zu verteilen, zu veroeffentlichen,
auszudrucken oder zu speichern. Bitte benachrichtigen Sie den
Absender ueber den irrtuemlichen Erhalt und loeschen Sie diese E-Mail
von jedem Computer.

This e-mail may contain confidential and/or legally protected
information and is only intended for the person it is addressed to.
If you have received this message in error, it is prohibited to copy,
disclose, publish, print or save it. You should notify the sender and
delete this message from all computers.

On Thu, Feb 28, 2008 at 7:27 AM,  <Lar...@ce...> wrote:
> Thanks for your assistance. No I am in need for some further help. :-)
>
>  I used the mentioned OracleXmlTypeDataTypeComponent as a template along
>  with the factory and registered it in DB2Plugin#initialize()
>
>         CellComponentFactory.registerDataTypeFactory(
>             new DB2XmlTypeDataTypeComponentFactory() , Types.OTHER, "XML");
>
>  Type and type name are from DB2 manual and are displayed that way in the
>  ResulSetMetaData when running a query in Squirrel.
>
>  Now, when executing a query I  still receive "<Other>" in the value field.
>  Debugging showed me, that ColumnDefintions are correctly created, my custom
>  data type is registered (e.g. component factory's construct is called). But
>  when loading data, my DB2XmlTypeDataTypeComponent#readResultSet method
>  never gets called.
>
>  Further debugging showed me, that SQLExecutorTask#processResultSet() leads
>  to ResultSetDataSet#setResultSet(ResultSet, String, int[], boolean,
>  boolean, DialectType), where the ResultSet is read by a ResultSetReader
>  (ResultSetDataSet line 170) ignoring the column defitinions (method param "
>  useColumnDefs" is false in this call hierarchy).
>
>  Am I missing something here?

In your DB2XmlTypeDataTypeComponent,  what is returned for getDialect ?

Rob

Thanks for your assistance. No I am in need for some further help. :-)

I used the mentioned OracleXmlTypeDataTypeComponent as a template along
with the factory and registered it in DB2Plugin#initialize()

        CellComponentFactory.registerDataTypeFactory(
            new DB2XmlTypeDataTypeComponentFactory() , Types.OTHER, "XML");

Type and type name are from DB2 manual and are displayed that way in the
ResulSetMetaData when running a query in Squirrel.

Now, when executing a query I  still receive "<Other>" in the value field.
Debugging showed me, that ColumnDefintions are correctly created, my custom
data type is registered (e.g. component factory's construct is called). But
when loading data, my DB2XmlTypeDataTypeComponent#readResultSet method
never gets called.

Further debugging showed me, that SQLExecutorTask#processResultSet() leads
to ResultSetDataSet#setResultSet(ResultSet, String, int[], boolean,
boolean, DialectType), where the ResultSet is read by a ResultSetReader
(ResultSetDataSet line 170) ignoring the column defitinions (method param "
useColumnDefs" is false in this call hierarchy).

Am I missing something here?
______________________________________________________

Cedros Gesellschaft fuer Datenverarbeitung mbH
Siegburger Strasse 35 . D-53757 Sankt Augustin
Telefon +49 (0)22 41-88 34-0 . Telefax +49 (0)22 41-88 34 11
Geschaeftsfuehrung: Armin Dreiling, Markus Michels USt-ID DE123113291;
Registergericht: Amtsgericht Siegburg, HR B 3526
______________________________________________________

Diese E-Mail kann vertrauliche und/oder rechtlich geschuetzte
Informationen enthalten und ist nur fuer die Person bestimmt, an die
adressiert wurde. Sollten Sie diese Nachricht irrtuemlich erhalten
haben, untersagen wir, diese zu verteilen, zu veroeffentlichen,
auszudrucken oder zu speichern. Bitte benachrichtigen Sie den
Absender ueber den irrtuemlichen Erhalt und loeschen Sie diese E-Mail
von jedem Computer.

This e-mail may contain confidential and/or legally protected
information and is only intended for the person it is addressed to.
If you have received this message in error, it is prohibited to copy,
disclose, publish, print or save it. You should notify the sender and
delete this message from all computers.

On Wed, Feb 27, 2008 at 8:19 PM, Gerd Wagner <ger...@t-...> wrote:
>  Lar...@ce... wrote:
>  > Since we
>  > use the xml features of this database, we would like to have xml results
>  > displayed correctly. Currently SQuirreL displays "<Sonstiges>" ("other"
>  > ;-)) in the view, which isn't very useful to us. If there isn't any plugin
>  > available we would write one or enhance the existing db2 plugin. In that
>  > case, how and where should we start?
>  First please have a look at
>  http://squirrel-sql.sourceforge.net/index.php?page=programing
>
>  At the bottom of this page there are links to an PDF document. (The document is
>  available in three languages). At the bottom of this document you find a rather
>  detailed description of an example how to build a Plugin. The example is even
>  based on DB2 so you are lucky in a way.

Lars,

Let me re-iterate Gerd's suggestion here to add to the existing
plugin.  All plugins have the ability to define custom type handlers
by implementing the IDataTypeComponent and registering the custom type
handler with the CellComponentFactory during initialization.  For
example, the Oracle plugin does already handle the XML type in Oracle.
 For example, the code in OraclePlugin.java is:

         CellComponentFactory.registerDataTypeFactory(
             new OracleXmlTypeDataTypeComponentFactory() , 2007,
             "SYS.XMLTYPE");

We use the factory pattern instead of a concrete implementation class
so that SQuirreL core can create the custom type for columns with Type
= 2007 whenever it needs to.  When your custom handler will only be
used for sessions that have the same dialect type you specify in
IDataTypeComponentFactory, so there is no problem with registering
different custom handlers that handler the same type.  This plugin API
is also documented here:

http://squirrel-sql.wiki.sourceforge.net/SQuirreL+SQL+Client+Plugin+API

Let us know if you run into any issues that don't seem to be handled
well by the existing custom type handler plugin API.  We can always
modify the API, if it is found to be lacking.

Rob

Hi Lars,


Lar...@ce... wrote:
> Dear SQuirreL Team.
> 
> we are using your great tool together with a db2 v9.1 database.
Thanks a lot.


> Since we
> use the xml features of this database, we would like to have xml results
> displayed correctly. Currently SQuirreL displays "<Sonstiges>" ("other"
> ;-)) in the view, which isn't very useful to us. If there isn't any plugin
> available we would write one or enhance the existing db2 plugin. In that
> case, how and where should we start?
First please have a look at
http://squirrel-sql.sourceforge.net/index.php?page=programing

At the bottom of this page there are links to an PDF document. (The document is 
available in three languages). At the bottom of this document you find a rather 
detailed description of an example how to build a Plugin. The example is even 
based on DB2 so you are lucky in a way.

Since there already is an existing DB2 Plugin for SQuirreL you are to decide if 
you'd like to add your XML features to this Plugin or create a new Plugin. At 
first sight I'd advice you to try to add to the existing Plugin.

Hope this helps.

Gerd


> 
> Thanks for any help and hints!
> 
> Regards,
> Lars
> ______________________________________________________
> 
> Cedros Gesellschaft fuer Datenverarbeitung mbH
> Siegburger Strasse 35 . D-53757 Sankt Augustin
> Telefon +49 (0)22 41-88 34-0 . Telefax +49 (0)22 41-88 34 11
> Geschaeftsfuehrung: Armin Dreiling, Markus Michels USt-ID DE123113291;
> Registergericht: Amtsgericht Siegburg, HR B 3526
> ______________________________________________________
> 
> Diese E-Mail kann vertrauliche und/oder rechtlich geschuetzte
> Informationen enthalten und ist nur fuer die Person bestimmt, an die
> adressiert wurde. Sollten Sie diese Nachricht irrtuemlich erhalten
> haben, untersagen wir, diese zu verteilen, zu veroeffentlichen,
> auszudrucken oder zu speichern. Bitte benachrichtigen Sie den
> Absender ueber den irrtuemlichen Erhalt und loeschen Sie diese E-Mail
> von jedem Computer.
> 
> This e-mail may contain confidential and/or legally protected
> information and is only intended for the person it is addressed to.
> If you have received this message in error, it is prohibited to copy,
> disclose, publish, print or save it. You should notify the sender and
> delete this message from all computers.
> 
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
> 

Dear SQuirreL Team.

we are using your great tool together with a db2 v9.1 database. Since we
use the xml features of this database, we would like to have xml results
displayed correctly. Currently SQuirreL displays "<Sonstiges>" ("other"
;-)) in the view, which isn't very useful to us. If there isn't any plugin
available we would write one or enhance the existing db2 plugin. In that
case, how and where should we start?

Thanks for any help and hints!

Regards,
Lars
______________________________________________________

Cedros Gesellschaft fuer Datenverarbeitung mbH
Siegburger Strasse 35 . D-53757 Sankt Augustin
Telefon +49 (0)22 41-88 34-0 . Telefax +49 (0)22 41-88 34 11
Geschaeftsfuehrung: Armin Dreiling, Markus Michels USt-ID DE123113291;
Registergericht: Amtsgericht Siegburg, HR B 3526
______________________________________________________

Diese E-Mail kann vertrauliche und/oder rechtlich geschuetzte
Informationen enthalten und ist nur fuer die Person bestimmt, an die
adressiert wurde. Sollten Sie diese Nachricht irrtuemlich erhalten
haben, untersagen wir, diese zu verteilen, zu veroeffentlichen,
auszudrucken oder zu speichern. Bitte benachrichtigen Sie den
Absender ueber den irrtuemlichen Erhalt und loeschen Sie diese E-Mail
von jedem Computer.

This e-mail may contain confidential and/or legally protected
information and is only intended for the person it is addressed to.
If you have received this message in error, it is prohibited to copy,
disclose, publish, print or save it. You should notify the sender and
delete this message from all computers.

Hi,

I completed the translation of the SQuirreL tutorial in Italian at last!

May I send it to this mailing list or should I have to send it to a 
different address?

Bye meo

On Feb 18, 2008 8:03 PM, Robert Manning <rob...@gm...> wrote:
> On Feb 18, 2008 7:18 PM, Robert Manning <rob...@gm...> wrote:
> Further testing revealed that the previous patch discards existing
> selections erroneously.  So the attached patch should be used instead.

Well, I somehow managed to provide the same exact patch in the
previous email :)  The new patch (patch.txt) is attached.

Rob

On Feb 18, 2008 7:18 PM, Robert Manning <rob...@gm...> wrote:
> On Feb 14, 2008 5:18 PM, Baxter, Betsy <bb...@ci...> wrote:
> > Is there something we can do to enable the right-click to set focus on
> > an item?
>
> Hi Betsy,
>
> This behavior appears to me to be hard-coded.  The attached univ. diff
> patch can be applied to the latest version of
>
> app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/ObjectTree.java
>
> in CVS and should give you the behavior you desire.

Further testing revealed that the previous patch discards existing
selections erroneously.  So the attached patch should be used instead.
 When selecting a node that is not already selected, then the
selection changes; but if the node(or nodes) is already selected, then
existing selection is not modified.

BTW, this behavior is inconsistent with other lists in the application
(for example, like drivers and aliases).  It will take a bit more
effort to make this desired behaviour consistent across the entire
application.  But this should at least give you what you requested.
Let me know if you have any troubles with it.

Rob

On Feb 14, 2008 5:18 PM, Baxter, Betsy <bb...@ci...> wrote:
> We have developed a plug-in that retrieves meta-data and data from our
> proprietary database.  Our customers are complaining that they have to
> left-click to set focus on an item in our plug-in and then right-click
> to display the options for that item in the tree.  This is different
> than many Windows tools like Windows Explorer where they only have to
> right-click to set focus.  The users feel it is frustrating because the
> right-click displays a menu for the last thing they set focus on and
> they don't immediately realize that this is the wrong item.
>
> Is there something we can do to enable the right-click to set focus on
> an item?

Hi Betsy,

This behavior appears to me to be hard-coded.  The attached univ. diff
patch can be applied to the latest version of

app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/ObjectTree.java

in CVS and should give you the behavior you desire.  Let me know if it
works for you (especially if it doesn't work), and I'll try to
come up with a configuration for it in the next release.  It makes
alot of sense to me that users would want this behavior, but then
again, someone might actually like the extra mouse clicks :)

Rob

We have developed a plug-in that retrieves meta-data and data from our
proprietary database.  Our customers are complaining that they have to
left-click to set focus on an item in our plug-in and then right-click
to display the options for that item in the tree.  This is different
than many Windows tools like Windows Explorer where they only have to
right-click to set focus.  The users feel it is frustrating because the
right-click displays a menu for the last thing they set focus on and
they don't immediately realize that this is the wrong item.

Is there something we can do to enable the right-click to set focus on
an item?

Thanks and regards,


Betsy Baxter
ATG Engineering and Support
Cincom Systems
513.612.2676

On Jan 28, 2008 7:25 AM, Cristiano Guadagnino <cri...@gm...> wrote:
> Hi all,
> I am new to this list.
>
> I have been using SquirrelSQL professionally for a few months now (I
> am a DB Administrator in a medium-scale financial institution). I am
> enjoying Squirrel very much, and have to say that Squirrel compares
> favorably with a lot of closed-source, commercial analogous softwares.
>
> I should also mention that I am using Squirrel mostly to work on DB2
> 8.1 for z/OS and DB2 9 for LUW.
>
> I am interested in expanding the support for DB2 on z/OS in SquirrelSQL.
> Is anybody undertaking the same job already? Would you be interested
> in having something like this implemented?
> Should I extend the already existing DB2 plugin, or should I start from scratch?
>
> I have to say that my java skills are deep buried in the sands of
> time, so I don't really know if or when I'll be able to finish the
> task (my work is also absorbing a lot of my time), but I'd like to
> try.

Cris,

Welcome aboard!  To my knowledge no one is currently working on
expanding the DB2 plugin to work correctly on z/OS.  I wrote the
plugin originally for LUW, and expanded it with help from others to
work correctly on OS400.  I would do the work myself if I had access
to that platform.  However, I don't and I do not anticipate having
access anytime soon.  I would welcome any enhancements you could
contribute in any timeframe that you find convenient.  There are
plenty of other items that have my attention for the next few
releases, and I don't anticipate any substantial changes to the DB2
plugin during that time.  Also, I would recommend adding to the
existing plugin, rather than create a new one - less code duplication
and perhaps fewer opportunites for users to pick the wrong plugin :)
Let us know if you run into any difficulties.

Rob

Hi all,
I am new to this list.

I have been using SquirrelSQL professionally for a few months now (I
am a DB Administrator in a medium-scale financial institution). I am
enjoying Squirrel very much, and have to say that Squirrel compares
favorably with a lot of closed-source, commercial analogous softwares.

I should also mention that I am using Squirrel mostly to work on DB2
8.1 for z/OS and DB2 9 for LUW.

I am interested in expanding the support for DB2 on z/OS in SquirrelSQL.
Is anybody undertaking the same job already? Would you be interested
in having something like this implemented?
Should I extend the already existing DB2 plugin, or should I start from scratch?

I have to say that my java skills are deep buried in the sands of
time, so I don't really know if or when I'll be able to finish the
task (my work is also absorbing a lot of my time), but I'd like to
try.

Bye
Cris

Alex,

This issue has been unresolved for quite some time so it would be
great if you took some time to look into it.

See my responses below:

On Dec 28, 2007 12:10 PM, Alex Pivovarov <x4...@us...> wrote:
>
> Message body follows:
>
> Hi Rob
>
> About bug [ 1465615 ] Unsaved edits are lost when ....
>
> I think that main and second windows should work with files
> the same way as if I open two sessions (two main windows).
>
> 1. If I try to close secondary window I should be asked
> about save changes or not.
> 2. If I save changes in a secondary window implicitly it is
> my responsibility to control possible data overriding.
> (the same way as if I have two session and two main windows)

Indeed, that sounds like the most intuitive behavior.  I'm sure that
the original intent was for the main and secondary windows would work
the same way - as much as possible.  One exception being that closing
a secondary window shouldn't disconnect a session like main window
does; but closing a main window should cause secondary windows to
close.  This closing behavior is what the app currently does
correctly.

>
> Don't you think that firstly user should be asked about
> saving  file and only after it asked if he/she wants to
> close session.
> In this case saving changes could be placed under the
> closing window event -- does not matter main or secondary.

Yes, I agree.  I suppose that I didn't see that case because I always
disable the "Confirm Session Close" dialog, but enable the "Prompt for
unsaved changes" dialog.  The sequence that you described makes sense,
especially when both dialogs are enabled.

> Later we could add more advanced analysis and avoid saving
> data in the file if the file was already opened in other
> windows (allow only save as).

Yes; ideally we would want to somehow let the user know that they've
re-opened the same script in a secondary window.  Maybe set background
yellow to indicate that it's read-only and prevent changes?  I'm not
sure that is the perfect solution to this edge case, but I am positive
that allowing two editors with changes to the same file is a recipe
for disaster, from a user's point of view.

>
> It could be nice to do advanced right now. But now two main
> window behavior (with possible file overriding) already
> works and nobody complain to it -- so why simply not to do
> the same for the main/secondary windows?

Once again, you are correct.  More than one session can open the same
file.  And a new FileManager is created for each new SQL panel.
Perhaps you could introduce a FileHistoryService with a factory method
that maintains a singleton instance of FileHistoryService?  Each new
FileManager could then get a reference to this singleton and tell it
when it opens/closes a file.  The FileHistoryService could indicate
somehow when opening whether or not the file is already currently
opened in a another FileManager. Asking the user to confirm whether or
not to continue opening the file (albeit in read-only mode) would be a
nice touch.

>
> If you think it is ok I could look at it next week.
>

That would be great.

Rob

On Dec 20, 2007 2:53 AM, Alex Pivovarov <api...@gm...> wrote:
> Hi,
>
> I fixed a bug with Embedded Derby plugin 1541325. How can I submit the code?
> http://sourceforge.net/tracker/index.php?func=detail&aid=1541325&group_id=28383&atid=393414
>
> Should I submit it as a patch?

Alex,

I just finished testing and committing your changes to the trunk and
the 2.6 maintenance branch.  Well done!
The change will appear in the next snapshot and 2.6.3, both of which I
should have ready this weekend.  Thanks again for the contribution.

Rob

I see the patch that you attached to the bug. That will do just fine.
I'll put it in and it should go out in 2.6.3 if everything is ok.

Rob

On Dec 20, 2007 2:53 AM, Alex Pivovarov <api...@gm...> wrote:
> Hi,
>
> I fixed a bug with Embedded Derby plugin 1541325. How can I submit the code?
> http://sourceforge.net/tracker/index.php?func=detail&aid=1541325&group_id=28383&atid=393414
>
> Should I submit it as a patch?

Hi,

I fixed a bug with Embedded Derby plugin 1541325. How can I submit the code?
http://sourceforge.net/tracker/index.php?func=detail&aid=1541325&group_id=28383&atid=393414

Should I submit it as a patch?

Alex

Hi Bob,

what database do you want to connect to? What driver do you use?

Take care

Andreas

2007/12/14, Wheldon, Bob <bob...@na...>:
>
> Desr Sir/Madam,
>
> I cannot see any objects (Synonym, Table, View, Procedure, UDT), but
> only USERS, INSTANCES, SESSIONS in Squirrel Version 2.5.
>
> Thankyou and Regards,
>
> Bob Wheldon         Database Developer
> NAVTEQ B.V. Europe  Customer Support
>
> Otto-Volger-Str. 1  Work:   +49 (0)6196 / 589-365
> D-65843 Sulzbach/Ts Fax:    +49 (0)6196 / 589-334
> Germany             Mobile: +49 (0) 176 96036655
> http://www.NAVTEQ.com <http://www.navteq.com/>
> mailto:bob...@NA...
> Private: +49 (0) 177 5880772
>
>
>
>
> The information contained in this communication may be CONFIDENTIAL and is
> intended only for the use of the recipient(s) named above. If you are not
> the intended recipient, you are hereby notified that any dissemination,
> distribution, or copying of this communication, or any of its contents, is
> strictly prohibited. If you have received this communication in error,
> please notify the sender and delete/destroy the original message and any
> copy of it from your computer or paper files.
>
> -------------------------------------------------------------------------
> SF.Net email is sponsored by:
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services
> for just about anything Open Source.
>
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>
>

Desr Sir/Madam,
=20
I cannot see any objects (Synonym, Table, View, Procedure, UDT), but
only USERS, INSTANCES, SESSIONS in Squirrel Version 2.5.
=20
Thankyou and Regards,
=20
Bob Wheldon         Database Developer
NAVTEQ B.V. Europe  Customer Support=20

Otto-Volger-Str. 1  Work:   +49 (0)6196 / 589-365
D-65843 Sulzbach/Ts Fax:    +49 (0)6196 / 589-334
Germany             Mobile: +49 (0) 176 96036655
http://www.NAVTEQ.com <http://www.navteq.com/>  =20
mailto:bob...@NA...
Private: +49 (0) 177 5880772

=20


The information contained in this communication may be CONFIDENTIAL and i=
s intended only for the use of the recipient(s) named above. If you are n=
ot the intended recipient, you are hereby notified that any dissemination=
, distribution, or copying of this communication, or any of its contents,=
 is strictly prohibited. If you have received this communication in error=
, please notify the sender and delete/destroy the original message and an=
y copy of it from your computer or paper files.

On Dec 12, 2007 11:35 AM, Dula, Shane <sha...@ba...> wrote:
> I am running Java 1.4 and cannot upgrade to 1.5 right now at work.  I
> have  version 2.3 final.  Is there a version that will allow me to save
> as a spreadsheet without upgrading JAVA?  If so where can I find this
> version as I couldn't see it in the older versions link?

SQuirreL version 2.4 requires 1.5 or higher. Version 2.3.2 is the
latest version that can be run in JVM 1.4.  The in 2.3.2 changes were:

http://sourceforge.net/project/shownotes.php?release_id=470073&group_id=28383

The export to Excel feature was added in 2.4, so no there isn't a
version with that feature that can also run in JVM 1.4.

Rob

I am running Java 1.4 and cannot upgrade to 1.5 right now at work.  I
have  version 2.3 final.  Is there a version that will allow me to save
as a spreadsheet without upgrading JAVA?  If so where can I find this
version as I couldn't see it in the older versions link?

Thanks again,
Shane


 

-----Original Message-----
From: Robert Manning [mailto:rob...@gm...] 
Sent: Wednesday, December 12, 2007 8:44 AM
To: Dula, Shane
Cc: squ...@li...; squirrel-sql-develop
Subject: Re: [Squirrel-sql-users] Two quick questions

On Dec 12, 2007 7:54 AM, Dula, Shane <sha...@ba...>
wrote:
> Thanks.  I just downloaded  the 2.6 version.  So I will install that 
> version.  I'm assuming that I will need to redo my Alias' ?
>

No; driver and alias definitions should be preserved when upgrading.
They are stored in your user profile (platform-specific) directory and
not in the SQuirreL installation directory.

> For question 2. I'm using Oracle Thin driver on for Oracle 9i.
>

We have a feature request for handling password expiration.
Unfortunately, JDBC doesn't specify how this is done, so at the moment
it is database-specific.  I found a thread which discusses a possible
implementation using JDBC in Oracle:

http://forum.java.sun.com/thread.jspa?threadID=455430&messageID=2078732

In summary, for JDBC clients, it is a problem to use the "normal"
connection API since an expired password means that you cannot connect,
which also implies that you cannot change your password.
However, Oracle seems to provide a special connection property which
allows you to specify a new password (OCINewPassword).  That's not
documented by the driver, so SQuirreL doesn't let you specify a value.
 However, the JDBC FAQ references it:

http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm
#05_05

We could probably support this by augmenting the list that we get from
the driver - the problem is that it's specific to Oracle, so we probably
want to add an plugin API for plugins to do this.  Stay tuned!

Rob

On Dec 12, 2007 7:54 AM, Dula, Shane <sha...@ba...> wrote:
> Thanks.  I just downloaded  the 2.6 version.  So I will install that
> version.  I'm assuming that I will need to redo my Alias' ?
>

No; driver and alias definitions should be preserved when upgrading.
They are stored in your user profile (platform-specific) directory and
not in the SQuirreL installation directory.

> For question 2. I'm using Oracle Thin driver on for Oracle 9i.
>

We have a feature request for handling password expiration.
Unfortunately, JDBC doesn't specify how this is done, so at the moment
it is database-specific.  I found a thread which discusses a possible
implementation using JDBC in Oracle:

http://forum.java.sun.com/thread.jspa?threadID=455430&messageID=2078732

In summary, for JDBC clients, it is a problem to use the "normal"
connection API since an expired password means that you cannot
connect, which also implies that you cannot change your password.
However, Oracle seems to provide a special connection property which
allows you to specify a new password (OCINewPassword).  That's not
documented by the driver, so SQuirreL doesn't let you specify a value.
 However, the JDBC FAQ references it:

http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm#05_05

We could probably support this by augmenting the list that we get from
the driver - the problem is that it's specific to Oracle, so we
probably want to add an plugin API for plugins to do this.  Stay
tuned!

Rob

You have correctly determined that this feature doesn't exist in the
manner that you have described.  It is very resourceful to think of
using the auto-correction feature - I'd say you get some extra points
for that :)

The "SQL Parametrisation" plugin alters SQL being executed to insert
values for "variables" that it finds in the SQL statements.  As each
statement is executed, it prompts the user for value(s) to variables
that it finds, then takes the user's value and inserts it into the
statement and allows the altered statement to be executed.  It
registers as an ISQLExecutionListener (if memory serves me correctly)
and gets a callback prior to executing the statement.  You should be
able to look at how this plugin is written and derive something that
intercepts SQL to achieve your needs.  Of course, you would also need
to have preferences that the plugin would read to determine which
sessions are to get this treatment.  Many of the plugins register an
IGlobalPreferencesTab implementation with GlobalPreferencesSheet, so
you should be able to find other examples to borrow from there as
well.

One thing that you should probably recognize here is that disabling
this new read-only feature within SQuirreL and outside of SQuirreL
would be a trivial matter.  So, you are in effect only going to keep
"honest" people "honest".  Still, I do see a use for this as you've
described to keep people from "accidentally" modifying the data in the
wrong session.  I think this would be a very useful plugin for others
if you choose to write it.

Rob

On Nov 27, 2007 9:45 AM, Serbulent <ser...@us...> wrote:
>
> Message body follows:
>
> Hi Rob,
>
> I have posted the following regarding Squirrel.
>
> I would really appreciated your prompt reply. I would like
> to recommend Squirrel based on a simulated read only access
> feature.
>
> I will be happy to update my posting for requested feature
> based on your answer.
>
> Thanks and regards
>
> Buletn
>
> Sometimes it is not possible to define read only access to
> users at
> database level when the permissions are granted to the
> public on the
> objects.
>
> We would like to use Squirrel where we can define that only
> certain user(s)
> have full access to a database e.g. production database. All
> the other
> users will not be able to change the data in the
> database;i.e. simulated
> read-only access.
>
> Is there a way to achieve this?
>
> I tried the following
>
> 1- I have tried to configure the auto-correct feature that
> converts delete,
> update, insert to NoDeleteOnProduction etc. as a temp solution.
>
> However, it is listed under Session->Syntax menu but it
> applies to all the
> database alias profiles. It is not possible to have this
> config only for
> production. Is there a workaround to this to make this
> config database
> alias specific?
>
> 2- There is session script plug-in which sounds very
> promising. However, I
> could not find even a single example of this.
>
> I would have hoped when a session is initialised it would be
> possible to
> inspect the database and login and set the session
> configuration like the
> auto correct above. Is it possible to do that?
> Regardless of that some examples of its usage would really
> be useful.
>
>
> Probably the best solution for this would be to have a
> Restricted Access
> plugin. I could not see anything regarding such as feature.
> Is there any
> plan?
>
> If we were to write such a plugin, that would regulate
> update, delete and
> insert statements execution based on a list of database and
> login names,
> which plugin would be a good example to look at.
>
> What application name would you suggest for this plug-in?
>
> --
> 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=1260170
>
>