squirrel-sql-develop — A subscriber-only list for those interested in developing SQuirreL and Plugins.

[Squirrel-sql-develop] Empty Contents Tab in SQuirreL when Column-Names contain dashes

[Thomas L. <tom...@ne...>]

Hello,

we experience the problem that the contents tab in SQuirreL stays blank,
if a table contains columns whose names contain non standard characters.

For example column-name test-1. The dash is an invalid character.
For most databases this situation is solved by surrounding the 
column-name by quotes as in "test-1".

By analysing the problem and looking into the log files I discovered 
that SQuirreL actually
generates a SELECT-Statement without surrounding the column-name(s) by 
quotes if the column-names contain invalid characters. That is why the 
contents-tab does not show any data.

The problem can be reproduced easily using the following steps (in my 
case with HSQL-DB):

create table test ( "test-1" char(10) )
insert into test values ('1111111111')

SELECT test-1 FROM "PUBLIC"."TEST"; --> won't work (which is correct)

SELECT "test-1" FROM "PUBLIC"."TEST" --> will work

Contents-Tab stays empty.

I consider this a bug in SQuirreL. It should double-quote columns 
containing invalid characters when generating
the SELECT-Statement for the contents tab.

Your opinion about this? Is there a chance to get this changed in SQuirreL?

Thanks a lot,
Thomas

-- 
mailto:tho...@ne...
http://twitter.com/tommesl

Re: [Squirrel-sql-develop] squirrel-sql.jar in sql12/core/lib?

[Neville R. <row...@ho...>]

Hi Gerd,
An answer to the manifest contents is that the manifest can be built dynamically in the build.xml, rather than including a separate file. We can then build the classpath in the manifest automatically from the build classpath.
Shall I make those changes and push them over to you in the master git repository?
Neville

> Date: Tue, 17 Feb 2015 21:52:01 +0100
> From: ger...@t-...
> To: row...@ho...; squ...@li...
> Subject: Re: [Squirrel-sql-develop] squirrel-sql.jar in sql12/core/lib?
> 
> Hi Neville,
> 
> good to hear from you.
> 
> Am 16.02.2015 um 16:30 schrieb Neville Rowe:
> > Hi All, I used to contribute a little to Squirrel SQL many years ago.
> > Just starting to look at it again and there have many significant
> > improvements so thanks and congratulations to Gerd, Rob, etc.
> Thank you.
> 
> > Assuming I have some more time now I may start contributing again as
> > there are a couple of points I'd like to investigate. In the
> > meantime, two points 1) I notice that squirrel-sql.jar is in git
> > within core/lib - clearly a slightly older version to that which
> > someone compiles themselves. Is that necessary?
> No it's not. Thanks for pointing it out. I just removed the Jar from Git.
> 
> > 2) The main class is
> > listed in the manifest however according to Oracle if you do that
> > then you should also add the classpath within the manifest. I think I
> > possibly still have commit rights in which case could fix them,
> I never heard anybody asking for it. Probably because our usual 
> installation doesn't need it. But it would certainly do no harm to have 
> it done right. So please go ahead.
> 
> 
> > however it has been so long since I did that I thought an email would
> > be more polite...... Neville
> Is appreciated. Thanks.
> 
> Gerd
> 
> ------------------------------------------------------------------------------
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserved for billion-dollar corporations, FREE
> http://pubads.g.doubleclick.net/gampad/clk?id=190641631&iu=/4140/ostg.clktrk
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
 		 	   		  

Re: [Squirrel-sql-develop] Consulta

[Gerd W. <ger...@t-...>]

Am 17.02.2015 um 13:50 schrieb Adolfo Tomas Spinelli:
> Acabo de terminar una versión de prueba de un plugin para simplificar la
> construcción y/o modificación de Procedimientos Almacenados (Stored
> Procedures),
> Deseo saber los pasos a seguir para seguir adelante con el.
>
> Saludos Adolfo Spinelli
>
> Excuse my poor english:
Excuse me for not knowing Spanish. ;-)


>
> I just finished a trial version of a plugin to simplify the construction
> and / or modification of Stored Procedures. I want to know the steps to
> move forward with.

Thanks for your interest in SQuirreL

You may post a patch of your changes here:
http://sourceforge.net/p/squirrel-sql/patches/

or
create a merge request here
http://sourceforge.net/p/squirrel-sql/git/ci/master/tree/
I think the first step is to create a fork. But I have never done it 
myself. I just regularly receive merge requests and integrate them.

or
just mail me your changes.


Gerd

Re: [Squirrel-sql-develop] squirrel-sql.jar in sql12/core/lib?

[Gerd W. <ger...@t-...>]

Hi Neville,

good to hear from you.

Am 16.02.2015 um 16:30 schrieb Neville Rowe:
> Hi All, I used to contribute a little to Squirrel SQL many years ago.
> Just starting to look at it again and there have many significant
> improvements so thanks and congratulations to Gerd, Rob, etc.
Thank you.

> Assuming I have some more time now I may start contributing again as
> there are a couple of points I'd like to investigate. In the
> meantime, two points 1) I notice that squirrel-sql.jar is in git
> within core/lib - clearly a slightly older version to that which
> someone compiles themselves. Is that necessary?
No it's not. Thanks for pointing it out. I just removed the Jar from Git.

> 2) The main class is
> listed in the manifest however according to Oracle if you do that
> then you should also add the classpath within the manifest. I think I
> possibly still have commit rights in which case could fix them,
I never heard anybody asking for it. Probably because our usual 
installation doesn't need it. But it would certainly do no harm to have 
it done right. So please go ahead.


> however it has been so long since I did that I thought an email would
> be more polite...... Neville
Is appreciated. Thanks.

Gerd

[Squirrel-sql-develop] Consulta

[Adolfo T. S. <spi...@gm...>]

Acabo de terminar una versión de prueba de un plugin para simplificar la
construcción y/o modificación de Procedimientos Almacenados (Stored
Procedures),
Deseo saber los pasos a seguir para seguir adelante con el.

Saludos Adolfo Spinelli

Excuse my poor english:

I just finished a trial version of a plugin to simplify the construction
and / or modification of Stored Procedures. I want to know the steps to
move forward with.

Greetings Adolfo Spinelli

[Squirrel-sql-develop] squirrel-sql.jar in sql12/core/lib?

[Neville R. <row...@ho...>]

Hi All,
I used to contribute a little to Squirrel SQL many years ago. Just starting to look at it again and there have many significant improvements so thanks and congratulations to Gerd, Rob, etc.
Assuming I have some more time now I may start contributing again as there are a couple of points I'd like to investigate. In the meantime, two points
1) I notice that squirrel-sql.jar is in git within core/lib - clearly a slightly older version to that which someone compiles themselves. Is that necessary?2) The main class is listed in the manifest however according to Oracle if you do that then you should also add the classpath within the manifest.
I think I possibly still have commit rights in which case could fix them, however it has been so long since I did that I thought an email would be more polite......
Neville 		 	   		  

Re: [Squirrel-sql-develop] DB2Plugin: patch to add DECFLOAT datatype support

[Gerd W. <ger...@t-...>]

Hi Christian,

thanks for your interest in SQuirreL.

If it's the easiest for you you may just mail me your patch.


Alternatives would be to post the patch here:
http://sourceforge.net/p/squirrel-sql/patches/

Or to send me a pull request after creating a fork here:
http://sourceforge.net/p/squirrel-sql/git/ci/master/tree/


Gerd



Am 27.01.2015 um 18:00 schrieb Christian Sl:
> Hello everybody,
>
> yesterday I added support for DB2's vendor specific DECFLOAT datatype to the DB2 Plugin.
> As I don't have a sf.net account would it be ok to send you the patch by mail?
> So far the functionality seems, although not perfect (i am not able to detect negative zero values properly), very promising.
> Reading and updating is already possible (even for the special values like NaN, infinity and negative infinity).
> Basically the patch consists of 2 new classes (DB2DecfloatTypeDataTypeComponentFactory and
> its accompanying DB2DecfloatTypeDataType) in the net.sourceforge.squirrel_sql.plugins.db2.types package.
>
> Kind regards, Christian Slama
>
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming. The Go Parallel Website,
> sponsored by Intel and developed in partnership with Slashdot Media, is your
> hub for all things parallel software development, from weekly thought
> leadership blogs to news, videos, case studies, tutorials and more. Take a
> look and join the conversation now. http://goparallel.sourceforge.net/
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>

[Squirrel-sql-develop] DB2Plugin: patch to add DECFLOAT datatype support

[Christian S. <Chr...@gm...>]

Hello everybody,

yesterday I added support for DB2's vendor specific DECFLOAT datatype to the DB2 Plugin.
As I don't have a sf.net account would it be ok to send you the patch by mail?
So far the functionality seems, although not perfect (i am not able to detect negative zero values properly), very promising.
Reading and updating is already possible (even for the special values like NaN, infinity and negative infinity).
Basically the patch consists of 2 new classes (DB2DecfloatTypeDataTypeComponentFactory and
its accompanying DB2DecfloatTypeDataType) in the net.sourceforge.squirrel_sql.plugins.db2.types package.

Kind regards, Christian Slama

[Squirrel-sql-develop] setting up eClipse SQuirreL development environment

[david l. <dav...@ya...>]

Does anyone have a quick setup guide to adding SQuirreL to an eClipse development environment?  I downloaded the sql12 module from the CVS repository, but am not sure which folders should be added to my project.  I have one very minor tweak I'd like to propose a fix for (thought it would be a fun way to get involved rather than just make a bug request), but the organization of the code is a bit confusing.
Many thanks,
Dave

Re: [Squirrel-sql-develop] submitting patch

[Gerd W. <ger...@t-...>]

Am 13.11.2014 um 12:58 schrieb Michal Stekrt:
> Hi, <Squ...@li...>
> I would like to ask what is the proper way to submit a patch.
>
> I've submitted one some time ago as comment to issue but it didn't get any
> attention so I would like how to do it properly in order to get my patch
> evaluated and eventually included.
Ups, this should not happen. Sorry, but I really don't remember your patch.

You may post your patch here:
http://sourceforge.net/p/squirrel-sql/patches/

or
create a merge request here
http://sourceforge.net/p/squirrel-sql/git/ci/master/tree/
I think the first step is to create a fork. But I have never done it 
myself. I just regularly receive merge requests and integrate them.

or
just mail me your patch.


Thanks

Gerd

[Squirrel-sql-develop] submitting patch

[Michal S. <mi...@is...>]

Hi, <Squ...@li...>
I would like to ask what is the proper way to submit a patch.

I've submitted one some time ago as comment to issue but it didn't get any
attention so I would like how to do it properly in order to get my patch
evaluated and eventually included.

Thanks
Michal
<Squ...@li...>

Re: [Squirrel-sql-develop] JDBC Connection working in SquirrelSql but in Java code (Greenplum drvier to Pivotal HD)

[Robert M. <rob...@gm...>]

Sounds like you may not be running SQuirreL and your Java app on the same
machine.  That would be what is different - not custom SQuirreL code.
Check out this posting:

http://www.postgresql.org/message-id/1087704118.23312.35.camel@localhost.localdomain

(Greenplum is derived from PostgreSQL, I believe)

Rob

On Sat, Sep 27, 2014 at 2:22 PM, cha...@gm... <
cha...@gm...> wrote:

> Hi, All:
>
> Facing a weird issue with JDBC connection using Greenplum JDBC Driver to
> Pivotal HD - when configured in SquirrelSql 3.5.0, the connection works
> fine. However, when running pure JDBC Java code, the connecting attempt
> fails.
>
> Here are some details:
>
> - JDBC Driver class: com.pivotal.jdbc.GreenplumDriver
> - Driver: greenplum.jar from Pivotal HD website
> - URL: jdbc:pivotal:greenplum://<DB_host>:<DB_port>;DatabaseName=<DB>
> - JDBC Java code using JDK 1.7.0_51:
>     Class.forName(JDBC_DRIVER);
>     Connection conn = DriverManager.getConnection(DB_URL, USER, PASS);
>
>     Error message: FATAL: no pg_hba.conf entry for host "10.2.20.184".
>
>
> Would appreciate if anyone can point me to where SquirrelSql did something
> special to make the connection working! I need to JDBC java code working!
>
> - Charles
>
>
>
> --
> View this message in context:
> http://squirrel-sql-client.10976.n7.nabble.com/JDBC-Connection-working-in-SquirrelSql-but-in-Java-code-Greenplum-drvier-to-Pivotal-HD-tp3433.html
> Sent from the Developer mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
> Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
> Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
> Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
>
> http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>

[Squirrel-sql-develop] JDBC Connection working in SquirrelSql but in Java code (Greenplum drvier to Pivotal HD)

[<cha...@gm...>]

Hi, All:

Facing a weird issue with JDBC connection using Greenplum JDBC Driver to
Pivotal HD - when configured in SquirrelSql 3.5.0, the connection works
fine. However, when running pure JDBC Java code, the connecting attempt
fails.

Here are some details:

- JDBC Driver class: com.pivotal.jdbc.GreenplumDriver
- Driver: greenplum.jar from Pivotal HD website
- URL: jdbc:pivotal:greenplum://<DB_host>:<DB_port>;DatabaseName=<DB>
- JDBC Java code using JDK 1.7.0_51:
    Class.forName(JDBC_DRIVER);
    Connection conn = DriverManager.getConnection(DB_URL, USER, PASS);

    Error message: FATAL: no pg_hba.conf entry for host "10.2.20.184".


Would appreciate if anyone can point me to where SquirrelSql did something
special to make the connection working! I need to JDBC java code working!

- Charles



--
View this message in context: http://squirrel-sql-client.10976.n7.nabble.com/JDBC-Connection-working-in-SquirrelSql-but-in-Java-code-Greenplum-drvier-to-Pivotal-HD-tp3433.html
Sent from the Developer mailing list archive at Nabble.com.

Re: [Squirrel-sql-develop] Why Did You Switch To Ant

[Gerd W. <ger...@t-...>]

Am 10.08.2014 05:34, schrieb opticyclic:
> As someone who has an interest in build systems I see a lot of people
> switching away from ant and not a lot switch the other way.

The reason was simplification. Several poms often containing several 
hundred of lines of code were replaced by a single Ant script with a bit 
more than 200 lines of code.

It might well be that this simplification was due to our Plugin 
architecture which might not have been well suited for Maven.


Here's some detailed information on how the switch to Ant came about:

In February/March 2014 Jaroslaw Jarmolowicz sent me some patches 
concerning the Postgres Plugin (For details see 
http://sourceforge.net/p/squirrel-sql/git/ci/master/tree/sql12/core/doc/changes.txt) 
. These changes needed some Postgres specific libs at compile- and 
runtime. I was reluctant to put these in SQuirreL's global lib directory 
but wanted to have them in the Plugin's lib directory. I tried a while 
to get this to work with Maven and finally gave up.

So I decided to do a "bit" restructuring of the project and to introduce 
Ant.


Hope this helps you to understand my decision.

Gerd

>
> These days I get a lot of pressure to use Maven or Gradle in mt projects,
> and whilst each has benefits I still bump across things that are simple in
> Ant but not possible in the others (unless you use an ant plugin!).
> e.g. in Ant I filter out properties that contain PASS before I publish my
> jar to maven (using maven-ant tasks) so that my application can use the
> passwords in the properties but public dependencies don't have access. This
> isn't possible in Maven.
> Another example is extracting files from a zip/jar and flattening the
> result. Easy in Ant, not possible in Gradle (using default tasks).
>
> A recent commit looks like you have switched from Maven to Ant.
> http://sourceforge.net/p/squirrel-sql/git/ci/481d81922ec0eca5a50d07073ed0bb36176dcb19/
> Would you mind describing your reasons?
>
> Thanks!
> ------------------------------------------------------------------------------
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>

[Squirrel-sql-develop] Why Did You Switch To Ant

[opticyclic <opt...@us...>]

As someone who has an interest in build systems I see a lot of people
switching away from ant and not a lot switch the other way.

These days I get a lot of pressure to use Maven or Gradle in mt projects,
and whilst each has benefits I still bump across things that are simple in
Ant but not possible in the others (unless you use an ant plugin!).
e.g. in Ant I filter out properties that contain PASS before I publish my
jar to maven (using maven-ant tasks) so that my application can use the
passwords in the properties but public dependencies don't have access. This
isn't possible in Maven.
Another example is extracting files from a zip/jar and flattening the
result. Easy in Ant, not possible in Gradle (using default tasks).

A recent commit looks like you have switched from Maven to Ant.
http://sourceforge.net/p/squirrel-sql/git/ci/481d81922ec0eca5a50d07073ed0bb36176dcb19/
Would you mind describing your reasons?

Thanks!

Re: [Squirrel-sql-develop] No Data in Contents Tab using Sybase SQL Anywhere 5.5.04

[Thomas L. <tom...@ne...>]

Hi Rob,

I apologize for the late answer.

I didn't know that the jdbc-odbc-bridge was experimental.
Now, I even found a note by Oracle that there would not be any support 
for it in the future.

I did some tests with the JTds-Driver and the Open-Server-Gateway for 
the old SQL-Anywhere Version 5.5. Unfortunately this works even worse 
than the jdbc-odbc-bridge.

In the meantime our users of Sybase SQL-Anywhere decided to upgrade to a 
current version. I am pretty sure there will be available a working Type 
4 driver.

Therefore, I think the bug could be closed. However, I think it might be 
a good idea to write some log-messages if there are Exceptions within 
the metadata-accessing code. It might help to find out what is going on, 
if a driver fails to deliver the data.

All the Best,
Thomas


Am 07.07.2014 14:00, schrieb Robert Manning:
> Thomas,
>
> Its pretty well known that the jdbc-odbc-bridge driver is an experimental
> prototype.  SQuirreL relies on parts in the JDBC spec that this driver
> doesn't support.   DBVisualizer probably doesn't use as much, and so works
> fine for that driver.  If you can use a type 4 driver, that would be best.
>
> In my opinion, the best that could be attempted with a patch would be to
> refactor the metadata-accessing code that throws exceptions to catch them
> and return a suitable string such as "unavailable".
>
> Rob
>
>
> On Sun, Jul 6, 2014 at 5:10 AM, Thomas Lenarz <tom...@ne...>
> wrote:
>
>> Hi Rob,
>>
>> within our scenario the jdbc-odbc-bridge is used.
>>
>> I thought of a driver issue in the first place as well. However, I was
>> told that it works flawlessly using a direct ODBC-Connection (EXCEL) and a
>> jdbc-odbc-bridge connection using DBVisualizer. (I have tested it myself
>> and can confirm that it works.)
>>
>> Thats why, I finally did the debugging.
>>
>> I would like to try out a different driver preferably a Type 4 one.
>>
>> However, I haven't managed to create a working setup neither using the
>> Sybase jConnect nor the free JTds-Driver. I am not sure whether Sybase SQL
>> Anywhere 5.5 supports jdbc-Connections natively at all.
>>
>> Cheers,
>> Thomas
>>
>> Am 26.06.2014 03:37, schrieb Robert Manning:
>>
>>   It sounds like a buggy driver.  If that's the case, maybe the patch could
>>> be directed toward the dialect.  If it requires modifying the dialect
>>> interface, its a bit more serious and could require an update to the
>>> dialect interface.  However, perhaps you could raise an issue with the
>>> driver maintainers to correct what seems like a faulty driver
>>> implementation ?
>>>
>>> Rob
>>>
>>>
>>> On Wed, Jun 25, 2014 at 10:27 AM, Thomas Lenarz <tom...@ne...>
>>> wrote:
>>>
>>>   Hello,
>>>>
>>>> Recently I filed a bug concerning SQuirreL not displaying any data
>>>> within the contents tab using an old Sybase SQL Anywhere Database:
>>>>
>>>> #1148 Not Data in Contents Tab using Sybase SQL Anywhere 5.5.04
>>>>
>>>> By debugging I discovered that SQuirreL tries to get the metadata for
>>>> defaultValue, octetLength, ordinalPosition and isNullable. Access to
>>>> corresponding data within the Metadata causes Exceptions, which are
>>>> swallowed by a finally-clause and are not caught.
>>>>
>>>> For testing purposes I created a patch. It suppresses access to the
>>>> metadata-fields, causing the problem. The patch does only apply for a
>>>> Database of Dialect-Sybase.
>>>>
>>>> This patch actually does solve the problem within our environment.
>>>> However, I suppose it might not be general enough as more modern
>>>> versions of SQL Anywhere probably do not suffer that problem.
>>>>
>>>> I am wondering how to bring this issue forward. Should I add my
>>>> patch-files within the Sourceforge Patches section additionally to the
>>>> ones in the Bug-Section?
>>>>
>>>> Are there opinions or suggestions for a better, more general solution?
>>>> I there are I would volunteer to implement it.
>>>>
>>>> Thanks a lot,
>>>> Thomas
>>>>
>>>>
>>>> ------------------------------------------------------------
>>>> ------------------
>>>> Open source business process management suite built on Java and Eclipse
>>>> Turn processes into business applications with Bonita BPM Community
>>>> Edition
>>>> Quickly connect people, data, and systems into organized workflows
>>>> Winner of BOSSIE, CODIE, OW2 and Gartner awards
>>>> http://p.sf.net/sfu/Bonitasoft
>>>> _______________________________________________
>>>> Squirrel-sql-develop mailing list
>>>> Squ...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>>>>
>>>>
>>>
>>
>

[Squirrel-sql-develop] Can somebody work on bug 1050?

[John H. <jh...@im...>]

Folks:

I'm regularly accessing some MSSQL tables that have tinyint columns, and 
Squirrel internally uses a signed data type for these making them hard to 
work with.

http://sourceforge.net/p/squirrel-sql/bugs/1050/

Could somebody take a look? This bug has been open for a while now.

-- 
  John Hardin KA7OHZ                    http://www.impsec.org/~jhardin/
  jh...@im...    FALaholic #11174     pgpk -a jh...@im...
  key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C  AF76 D822 E6E6 B873 2E79
-----------------------------------------------------------------------
   Vista "security improvements" consist of attempting to shift blame
   onto the user when things go wrong.
-----------------------------------------------------------------------
  11 days until the 45th anniversary of Apollo 11 landing on the Moon

Re: [Squirrel-sql-develop] No Data in Contents Tab using Sybase SQL Anywhere 5.5.04

[Robert M. <rob...@gm...>]

Thomas,

Its pretty well known that the jdbc-odbc-bridge driver is an experimental
prototype.  SQuirreL relies on parts in the JDBC spec that this driver
doesn't support.   DBVisualizer probably doesn't use as much, and so works
fine for that driver.  If you can use a type 4 driver, that would be best.

In my opinion, the best that could be attempted with a patch would be to
refactor the metadata-accessing code that throws exceptions to catch them
and return a suitable string such as "unavailable".

Rob


On Sun, Jul 6, 2014 at 5:10 AM, Thomas Lenarz <tom...@ne...>
wrote:

> Hi Rob,
>
> within our scenario the jdbc-odbc-bridge is used.
>
> I thought of a driver issue in the first place as well. However, I was
> told that it works flawlessly using a direct ODBC-Connection (EXCEL) and a
> jdbc-odbc-bridge connection using DBVisualizer. (I have tested it myself
> and can confirm that it works.)
>
> Thats why, I finally did the debugging.
>
> I would like to try out a different driver preferably a Type 4 one.
>
> However, I haven't managed to create a working setup neither using the
> Sybase jConnect nor the free JTds-Driver. I am not sure whether Sybase SQL
> Anywhere 5.5 supports jdbc-Connections natively at all.
>
> Cheers,
> Thomas
>
> Am 26.06.2014 03:37, schrieb Robert Manning:
>
>  It sounds like a buggy driver.  If that's the case, maybe the patch could
>> be directed toward the dialect.  If it requires modifying the dialect
>> interface, its a bit more serious and could require an update to the
>> dialect interface.  However, perhaps you could raise an issue with the
>> driver maintainers to correct what seems like a faulty driver
>> implementation ?
>>
>> Rob
>>
>>
>> On Wed, Jun 25, 2014 at 10:27 AM, Thomas Lenarz <tom...@ne...>
>> wrote:
>>
>>  Hello,
>>>
>>> Recently I filed a bug concerning SQuirreL not displaying any data
>>> within the contents tab using an old Sybase SQL Anywhere Database:
>>>
>>> #1148 Not Data in Contents Tab using Sybase SQL Anywhere 5.5.04
>>>
>>> By debugging I discovered that SQuirreL tries to get the metadata for
>>> defaultValue, octetLength, ordinalPosition and isNullable. Access to
>>> corresponding data within the Metadata causes Exceptions, which are
>>> swallowed by a finally-clause and are not caught.
>>>
>>> For testing purposes I created a patch. It suppresses access to the
>>> metadata-fields, causing the problem. The patch does only apply for a
>>> Database of Dialect-Sybase.
>>>
>>> This patch actually does solve the problem within our environment.
>>> However, I suppose it might not be general enough as more modern
>>> versions of SQL Anywhere probably do not suffer that problem.
>>>
>>> I am wondering how to bring this issue forward. Should I add my
>>> patch-files within the Sourceforge Patches section additionally to the
>>> ones in the Bug-Section?
>>>
>>> Are there opinions or suggestions for a better, more general solution?
>>> I there are I would volunteer to implement it.
>>>
>>> Thanks a lot,
>>> Thomas
>>>
>>>
>>> ------------------------------------------------------------
>>> ------------------
>>> Open source business process management suite built on Java and Eclipse
>>> Turn processes into business applications with Bonita BPM Community
>>> Edition
>>> Quickly connect people, data, and systems into organized workflows
>>> Winner of BOSSIE, CODIE, OW2 and Gartner awards
>>> http://p.sf.net/sfu/Bonitasoft
>>> _______________________________________________
>>> Squirrel-sql-develop mailing list
>>> Squ...@li...
>>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>>>
>>>
>>
>

Re: [Squirrel-sql-develop] No Data in Contents Tab using Sybase SQL Anywhere 5.5.04

[Thomas L. <tom...@ne...>]

Hi Rob,

within our scenario the jdbc-odbc-bridge is used.

I thought of a driver issue in the first place as well. However, I was 
told that it works flawlessly using a direct ODBC-Connection (EXCEL) and 
a jdbc-odbc-bridge connection using DBVisualizer. (I have tested it 
myself and can confirm that it works.)

Thats why, I finally did the debugging.

I would like to try out a different driver preferably a Type 4 one.

However, I haven't managed to create a working setup neither using the 
Sybase jConnect nor the free JTds-Driver. I am not sure whether Sybase 
SQL Anywhere 5.5 supports jdbc-Connections natively at all.

Cheers,
Thomas

Am 26.06.2014 03:37, schrieb Robert Manning:
> It sounds like a buggy driver.  If that's the case, maybe the patch could
> be directed toward the dialect.  If it requires modifying the dialect
> interface, its a bit more serious and could require an update to the
> dialect interface.  However, perhaps you could raise an issue with the
> driver maintainers to correct what seems like a faulty driver
> implementation ?
>
> Rob
>
>
> On Wed, Jun 25, 2014 at 10:27 AM, Thomas Lenarz <tom...@ne...>
> wrote:
>
>> Hello,
>>
>> Recently I filed a bug concerning SQuirreL not displaying any data
>> within the contents tab using an old Sybase SQL Anywhere Database:
>>
>> #1148 Not Data in Contents Tab using Sybase SQL Anywhere 5.5.04
>>
>> By debugging I discovered that SQuirreL tries to get the metadata for
>> defaultValue, octetLength, ordinalPosition and isNullable. Access to
>> corresponding data within the Metadata causes Exceptions, which are
>> swallowed by a finally-clause and are not caught.
>>
>> For testing purposes I created a patch. It suppresses access to the
>> metadata-fields, causing the problem. The patch does only apply for a
>> Database of Dialect-Sybase.
>>
>> This patch actually does solve the problem within our environment.
>> However, I suppose it might not be general enough as more modern
>> versions of SQL Anywhere probably do not suffer that problem.
>>
>> I am wondering how to bring this issue forward. Should I add my
>> patch-files within the Sourceforge Patches section additionally to the
>> ones in the Bug-Section?
>>
>> Are there opinions or suggestions for a better, more general solution?
>> I there are I would volunteer to implement it.
>>
>> Thanks a lot,
>> Thomas
>>
>>
>> ------------------------------------------------------------------------------
>> Open source business process management suite built on Java and Eclipse
>> Turn processes into business applications with Bonita BPM Community Edition
>> Quickly connect people, data, and systems into organized workflows
>> Winner of BOSSIE, CODIE, OW2 and Gartner awards
>> http://p.sf.net/sfu/Bonitasoft
>> _______________________________________________
>> Squirrel-sql-develop mailing list
>> Squ...@li...
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>>
>

Re: [Squirrel-sql-develop] No Data in Contents Tab using Sybase SQL Anywhere 5.5.04

[Robert M. <rob...@gm...>]

It sounds like a buggy driver.  If that's the case, maybe the patch could
be directed toward the dialect.  If it requires modifying the dialect
interface, its a bit more serious and could require an update to the
dialect interface.  However, perhaps you could raise an issue with the
driver maintainers to correct what seems like a faulty driver
implementation ?

Rob


On Wed, Jun 25, 2014 at 10:27 AM, Thomas Lenarz <tom...@ne...>
wrote:

> Hello,
>
> Recently I filed a bug concerning SQuirreL not displaying any data
> within the contents tab using an old Sybase SQL Anywhere Database:
>
> #1148 Not Data in Contents Tab using Sybase SQL Anywhere 5.5.04
>
> By debugging I discovered that SQuirreL tries to get the metadata for
> defaultValue, octetLength, ordinalPosition and isNullable. Access to
> corresponding data within the Metadata causes Exceptions, which are
> swallowed by a finally-clause and are not caught.
>
> For testing purposes I created a patch. It suppresses access to the
> metadata-fields, causing the problem. The patch does only apply for a
> Database of Dialect-Sybase.
>
> This patch actually does solve the problem within our environment.
> However, I suppose it might not be general enough as more modern
> versions of SQL Anywhere probably do not suffer that problem.
>
> I am wondering how to bring this issue forward. Should I add my
> patch-files within the Sourceforge Patches section additionally to the
> ones in the Bug-Section?
>
> Are there opinions or suggestions for a better, more general solution?
> I there are I would volunteer to implement it.
>
> Thanks a lot,
> Thomas
>
>
> ------------------------------------------------------------------------------
> Open source business process management suite built on Java and Eclipse
> Turn processes into business applications with Bonita BPM Community Edition
> Quickly connect people, data, and systems into organized workflows
> Winner of BOSSIE, CODIE, OW2 and Gartner awards
> http://p.sf.net/sfu/Bonitasoft
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>

[Squirrel-sql-develop] No Data in Contents Tab using Sybase SQL Anywhere 5.5.04

[Thomas L. <tom...@ne...>]

Hello,

Recently I filed a bug concerning SQuirreL not displaying any data 
within the contents tab using an old Sybase SQL Anywhere Database:

#1148 Not Data in Contents Tab using Sybase SQL Anywhere 5.5.04

By debugging I discovered that SQuirreL tries to get the metadata for 
defaultValue, octetLength, ordinalPosition and isNullable. Access to 
corresponding data within the Metadata causes Exceptions, which are 
swallowed by a finally-clause and are not caught.

For testing purposes I created a patch. It suppresses access to the 
metadata-fields, causing the problem. The patch does only apply for a 
Database of Dialect-Sybase.

This patch actually does solve the problem within our environment.
However, I suppose it might not be general enough as more modern 
versions of SQL Anywhere probably do not suffer that problem.

I am wondering how to bring this issue forward. Should I add my 
patch-files within the Sourceforge Patches section additionally to the 
ones in the Bug-Section?

Are there opinions or suggestions for a better, more general solution?
I there are I would volunteer to implement it.

Thanks a lot,
Thomas

Re: [Squirrel-sql-develop] Plugin arguments?

[Gerd W. <ger...@t-...>]

Am 19.02.2014 00:15, schrieb David Greene:
> I'm creating a plugin for squirrel for internal use with one of our
> in-house applications.  I'd like the ability to pass command line
> arguments, but the Gnu argument parser is yelling at me that my args are
> not in the accepted list.  Is there a programmatic way to allow additional
> arguments without a patch to SQuirreL?
>
> I'm dreaming of a way that plugins could actually pass an arg list through
> the external interface; however, the arg parsing happens before plugins are
> loaded.
Just do the changes you wish to SQuirreL's core code and send me a patch 
or post it here:
http://sourceforge.net/p/squirrel-sql/patches/

I'd be willing to include a change like that.

Gerd

[Squirrel-sql-develop] Plugin arguments?

[David G. <da...@tr...>]

I'm creating a plugin for squirrel for internal use with one of our
in-house applications.  I'd like the ability to pass command line
arguments, but the Gnu argument parser is yelling at me that my args are
not in the accepted list.  Is there a programmatic way to allow additional
arguments without a patch to SQuirreL?

I'm dreaming of a way that plugins could actually pass an arg list through
the external interface; however, the arg parsing happens before plugins are
loaded.

Any ideas?

-David




-- 
*David Greene*
da...@tr...
http://trumpetx.com
(512) 762-0594 - mobile
(512) 630-2285 - g.voice

[Squirrel-sql-develop] Refactoring in SQLFilterSheet

[Jarosław J. <j.j...@gm...>]

Hi devs!

Im working on support for custom postgres types and got to place called
:SQLFilterSheet.java

It renders and manages wheres and order by generation and that's nice.
What i don't like is that we have IFs:

        if ((dataType == Types.CHAR) || (dataType == Types.CLOB)
                        || (dataType == Types.LONGVARCHAR)
                        || (dataType == Types.VARCHAR)) {
                    textColumns.put(columnName, Boolean.TRUE);
                }
and hardcoded operators for all types. (Integers don't use LIKE etc...)

I'm planning to get table definitions from CellComponentFactory and extend
IDataTypeComponent interface by:
getSupportedOperators()
getCondition(String operator, String inputValue)

Any suggestions from architectural point of view?

Regards
Jarosław Jarmołowicz

Re: [Squirrel-sql-develop] New plugin

[Gerd W. <ger...@t-...>]

Am 08.02.2014 21:06, schrieb bouchra elidrissi:
> Hi,
> I ask you kindly to inform me how I can commit  a new plugin to SQuirrel
> that can be appeared as one of its available plugins?

You may either add a patch of your code here:
http://sourceforge.net/p/squirrel-sql/patches/

or just mail it to me.


Thanks for your interest in SQuirreL

Gerd