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

[Squirrel-sql-develop] New plugin

[bouchra e. <bel...@gm...>]

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?

Many thinks in advance.

Best regards,

Bouchra

Re: [Squirrel-sql-develop] display ony SQL time taken to retrieve info but not display data

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

On Mon, 9 Dec 2013, Ema...@rb... wrote:

>
>   I run some simple Select queries against my datasources. Some of the
>   queries return too much data but as I am working on performance tuning
>   I am only interested in the time that it took to retrieve all rows and
>   not in the data itself.
>
>   So I would like to know if it is possible to get only the time taken
>   to return all the rows from a SQL query against my datasources without
>   bringing back any data??
>
>   Any ideas would be a great help - either with a command to be added in
>   my SQL Select statement or just pointing where in the SQuirreL java
>   code I could change to dispose the data.

Are you trying to measure the server performance or the network 
performance?

If you're trying to measure the server performance, select into a temp 
table. This is a little overstated because you are measuring the overhead 
of writing the rows to the temp table in addition to querying the rows 
from the source table(s).


MSSQL example:

 	SELECT
 	  ...
 	INTO @t_x
 	FROM
 	  ...
 	;

 	DROP TABLE @t_x;

I think that running a query in a cursor loop that simply ignores the rows 
may avoid that overhead but it probably introduces cursor-related overhead 
of its own.

I'm not sure if there's another more-efficient way to run a query and 
simply discard the results within the engine.


If you're trying to measure network performance there's really no way to 
avoid bringing back the data. However, you don't need to *keep* the data 
once it's been retrieved. I suggested earlier that there is a mechanism 
within Squirrel to redirect query output to a file. If you redirect the 
query output to the *nix file "/dev/null" or the Windows file "nul:" it 
will simply be discarded. Your timing will measure who long it takes to 
run the query and return the rows to the client, but you don't have to see 
the data, and there shouldn't be any timing impact from allocating local 
storage for the rowset or formatting for display.


Also: make sure you uncheck the rowlimit option in the query pane.

-- 
  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
-----------------------------------------------------------------------
   "Bother," said Pooh as he struggled with /etc/sendmail.cf, "it never
   does quite what I want. I wish Christopher Robin was here."
                                            -- Peter da Silva in a.s.r
-----------------------------------------------------------------------
  7 days until Christmas

Re: [Squirrel-sql-develop] display ony SQL time taken to retrieve info but not display data

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

On Mon, 9 Dec 2013, Ema...@rb... wrote:

>   I run some simple Select queries against my datasources. Some of the
>   queries return too much data but as I am working on performance tuning
>   I am only interested in the time that it took to retrieve all rows and
>   not in the data itself.
>
>   So I would like to know if it is possible to get only the time taken
>   to return all the rows from a SQL query against my datasources without
>   bringing back any data??
>
>   Any ideas would be a great help - either with a command to be added in
>   my SQL Select statement or just pointing where in the SQuirreL java
>   code I could change to dispose the data.

There are options to query the data to a file (I don't know the details 
because I've never used Squirrel to do that, sorry).

How about: use that option and enter the filename "/dev/null" for *nix or 
"nul:" for Windows.

-- 
  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
-----------------------------------------------------------------------
  6 days until Bill of Rights day

[Squirrel-sql-develop] display ony SQL time taken to retrieve info but not display data

[<Ema...@rb...>]

Hi,

   I run some simple Select queries against my datasources. Some of the queries return too much data but as I am working on performance tuning I am only interested in the time that it took to retrieve all rows and not in the data itself.

   So I would like to know if it is possible to get only the time taken to return all the rows from a SQL query against my datasources without bringing back any data??

   Any ideas would be a great help - either with a command to be added in my SQL Select statement or just pointing where in the SQuirreL java code I could change to dispose the data.

Many thanks

Emanuel Chiavegato

*********************************************************************************** 
The Royal Bank of Scotland plc. Registered in Scotland No 90312. 
Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. 
Authorised by the Prudential Regulation Authority and regulated 
by the Financial Conduct Authority and Prudential Regulation Authority. 
The Royal Bank of Scotland N.V. is authorised and regulated by the 
De Nederlandsche Bank and has its seat at Amsterdam, the 
Netherlands, and is registered in the Commercial Register under 
number 33002587. Registered Office: Gustav Mahlerlaan 350, 
Amsterdam, The Netherlands. The Royal Bank of Scotland N.V. and 
The Royal Bank of Scotland plc are authorised to act as agent for each 
other in certain jurisdictions. 
  
This e-mail message is confidential and for use by the addressee only. 
If the message is received by anyone other than the addressee, please 
return the message to the sender by replying to it and then delete the 
message from your computer. Internet e-mails are not necessarily 
secure. The Royal Bank of Scotland plc and The Royal Bank of Scotland 
N.V. including its affiliates ("RBS group") does not accept responsibility 
for changes made to this message after it was sent. For the protection
of RBS group and its clients and customers, and in compliance with
regulatory requirements, the contents of both incoming and outgoing
e-mail communications, which could include proprietary information and
Non-Public Personal Information, may be read by authorised persons
within RBS group other than the intended recipient(s). 

Whilst all reasonable care has been taken to avoid the transmission of 
viruses, it is the responsibility of the recipient to ensure that the onward 
transmission, opening or use of this message and any attachments will 
not adversely affect its systems or data. No responsibility is accepted 
by the RBS group in this regard and the recipient should carry out such 
virus and other checks as it considers appropriate. 

Visit our website at www.rbs.com 
***********************************************************************************  

[Squirrel-sql-develop] display ony SQL time taken to retrieve info but not display data

[<Ema...@rb...>]

Hi,

   I run some simple Select queries against my datasources. Some of the queries return too much data but as I am working on performance tuning I am only interested in the time that it took to retrieve all rows and not in the data itself.

   So I would like to know if it is possible to get only the time taken to return all the rows from a SQL query against my datasources without bringing back any data??

   Any ideas would be a great help - either with a command to be added in my SQL Select statement or just pointing where in the SQuirreL java code I could change to dispose the data.

Many thanks

Emanuel Chiavegato


*********************************************************************************** 
The Royal Bank of Scotland plc. Registered in Scotland No 90312. 
Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. 
Authorised by the Prudential Regulation Authority and regulated 
by the Financial Conduct Authority and Prudential Regulation Authority. 
The Royal Bank of Scotland N.V. is authorised and regulated by the 
De Nederlandsche Bank and has its seat at Amsterdam, the 
Netherlands, and is registered in the Commercial Register under 
number 33002587. Registered Office: Gustav Mahlerlaan 350, 
Amsterdam, The Netherlands. The Royal Bank of Scotland N.V. and 
The Royal Bank of Scotland plc are authorised to act as agent for each 
other in certain jurisdictions. 
  
This e-mail message is confidential and for use by the addressee only. 
If the message is received by anyone other than the addressee, please 
return the message to the sender by replying to it and then delete the 
message from your computer. Internet e-mails are not necessarily 
secure. The Royal Bank of Scotland plc and The Royal Bank of Scotland 
N.V. including its affiliates ("RBS group") does not accept responsibility 
for changes made to this message after it was sent. For the protection
of RBS group and its clients and customers, and in compliance with
regulatory requirements, the contents of both incoming and outgoing
e-mail communications, which could include proprietary information and
Non-Public Personal Information, may be read by authorised persons
within RBS group other than the intended recipient(s). 

Whilst all reasonable care has been taken to avoid the transmission of 
viruses, it is the responsibility of the recipient to ensure that the onward 
transmission, opening or use of this message and any attachments will 
not adversely affect its systems or data. No responsibility is accepted 
by the RBS group in this regard and the recipient should carry out such 
virus and other checks as it considers appropriate. 

Visit our website at www.rbs.com 
***********************************************************************************  

Re: [Squirrel-sql-develop] embed squirrel in my java app?

[Johnathan J. <ha...@gm...>]

I was going to mention as well, if only for posterity's sake, that there
are surely other pieces of code that would be easier to modify to the
requirements mentioned. I would check sample applications for some relevant
technologies (JPA, Hibernate, other Java DB technologies) and open source
projects on github, sourceforge, etc,


On Sun, Dec 8, 2013 at 12:27 PM, darrell smith <jsm...@gm...> wrote:

> the way i understood the requirements, a simple ETL into a sqlite db would
> also suffice.  squirrel is a perfectly capable front end for the sql-savvy,
> and there are a number of spreadsheet-like front ends that also support
> ad-hoc queries, for the not-so savvy, so you can tailor the tool to the
> operator.
>
>
> On Fri, Dec 6, 2013 at 10:51 PM, Johnathan James <ha...@gm...>wrote:
>
>> I bet you could embed Squirrel, but it seems like overkill..
>>
>> Maybe I am simplifying your requirements too much, but I assume you just
>> want to allow the user to enter a query, be able to execute it, and show
>> the results. Perhaps you want to also show a list of database tables, and
>> their structure.
>>
>> If that about covers it, then you'd only need to use something like JPA or
>> Hibernate to query the database. You could query the DB directly for table
>> listings and their structure, and/or use the JPA/Hibernate API.
>>
>> Even if I didn't divine your requirements correctly, I'd bet a bitcoin you
>> don't need to embed Squirrel to hit your mark.
>>
>> Disclaimer: I've submitted a few patches, but I am no where near an expert
>> on Squirrel.
>>
>>
>> On Fri, Dec 6, 2013 at 10:34 PM, Bruce Buchanan
>> <bru...@gm...>wrote:
>>
>> > greetings -
>> >
>> > I'm building a simple data utility that lets our team load data, browse
>> > it, do a vew simple views etc
>> >
>> > this is not a commercial project, just a one-off that I'm trying to put
>> > together quickly
>> >
>> > part of the use case is querying the data and I'm wondering why I should
>> > build a query tool from scratch
>> >
>> > and another part of the use case is that it be an easy to install, all
>> in
>> > one type tool
>> >
>> > so, the question: why not just embed squirrel? using H2 as my database,
>> >  also embedded
>> >
>> > thanks
>> >
>> > ps: if this just isnt possible w/ squirrel, does anyone have any ideas?
>> >
>> > thanks
>> >
>> >
>> >
>> >
>> >
>> ------------------------------------------------------------------------------
>> > Sponsored by Intel(R) XDK
>> > Develop, test and display web and hybrid apps with a single code base.
>> > Download it for free now!
>> >
>> >
>> http://pubads.g.doubleclick.net/gampad/clk?id=111408631&iu=/4140/ostg.clktrk
>> > _______________________________________________
>> > Squirrel-sql-develop mailing list
>> > Squ...@li...
>> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>> >
>>
>> ------------------------------------------------------------------------------
>> Sponsored by Intel(R) XDK
>> Develop, test and display web and hybrid apps with a single code base.
>> Download it for free now!
>>
>> http://pubads.g.doubleclick.net/gampad/clk?id=111408631&iu=/4140/ostg.clktrk
>> _______________________________________________
>> Squirrel-sql-develop mailing list
>> Squ...@li...
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>>
>
>

Re: [Squirrel-sql-develop] embed squirrel in my java app?

[darrell s. <jsm...@gm...>]

the way i understood the requirements, a simple ETL into a sqlite db would
also suffice.  squirrel is a perfectly capable front end for the sql-savvy,
and there are a number of spreadsheet-like front ends that also support
ad-hoc queries, for the not-so savvy, so you can tailor the tool to the
operator.


On Fri, Dec 6, 2013 at 10:51 PM, Johnathan James <ha...@gm...> wrote:

> I bet you could embed Squirrel, but it seems like overkill..
>
> Maybe I am simplifying your requirements too much, but I assume you just
> want to allow the user to enter a query, be able to execute it, and show
> the results. Perhaps you want to also show a list of database tables, and
> their structure.
>
> If that about covers it, then you'd only need to use something like JPA or
> Hibernate to query the database. You could query the DB directly for table
> listings and their structure, and/or use the JPA/Hibernate API.
>
> Even if I didn't divine your requirements correctly, I'd bet a bitcoin you
> don't need to embed Squirrel to hit your mark.
>
> Disclaimer: I've submitted a few patches, but I am no where near an expert
> on Squirrel.
>
>
> On Fri, Dec 6, 2013 at 10:34 PM, Bruce Buchanan
> <bru...@gm...>wrote:
>
> > greetings -
> >
> > I'm building a simple data utility that lets our team load data, browse
> > it, do a vew simple views etc
> >
> > this is not a commercial project, just a one-off that I'm trying to put
> > together quickly
> >
> > part of the use case is querying the data and I'm wondering why I should
> > build a query tool from scratch
> >
> > and another part of the use case is that it be an easy to install, all in
> > one type tool
> >
> > so, the question: why not just embed squirrel? using H2 as my database,
> >  also embedded
> >
> > thanks
> >
> > ps: if this just isnt possible w/ squirrel, does anyone have any ideas?
> >
> > thanks
> >
> >
> >
> >
> >
> ------------------------------------------------------------------------------
> > Sponsored by Intel(R) XDK
> > Develop, test and display web and hybrid apps with a single code base.
> > Download it for free now!
> >
> >
> http://pubads.g.doubleclick.net/gampad/clk?id=111408631&iu=/4140/ostg.clktrk
> > _______________________________________________
> > Squirrel-sql-develop mailing list
> > Squ...@li...
> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
> >
>
> ------------------------------------------------------------------------------
> Sponsored by Intel(R) XDK
> Develop, test and display web and hybrid apps with a single code base.
> Download it for free now!
>
> http://pubads.g.doubleclick.net/gampad/clk?id=111408631&iu=/4140/ostg.clktrk
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>

Re: [Squirrel-sql-develop] embed squirrel in my java app?

[Johnathan J. <ha...@gm...>]

I bet you could embed Squirrel, but it seems like overkill..

Maybe I am simplifying your requirements too much, but I assume you just
want to allow the user to enter a query, be able to execute it, and show
the results. Perhaps you want to also show a list of database tables, and
their structure.

If that about covers it, then you'd only need to use something like JPA or
Hibernate to query the database. You could query the DB directly for table
listings and their structure, and/or use the JPA/Hibernate API.

Even if I didn't divine your requirements correctly, I'd bet a bitcoin you
don't need to embed Squirrel to hit your mark.

Disclaimer: I've submitted a few patches, but I am no where near an expert
on Squirrel.


On Fri, Dec 6, 2013 at 10:34 PM, Bruce Buchanan
<bru...@gm...>wrote:

> greetings -
>
> I'm building a simple data utility that lets our team load data, browse
> it, do a vew simple views etc
>
> this is not a commercial project, just a one-off that I'm trying to put
> together quickly
>
> part of the use case is querying the data and I'm wondering why I should
> build a query tool from scratch
>
> and another part of the use case is that it be an easy to install, all in
> one type tool
>
> so, the question: why not just embed squirrel? using H2 as my database,
>  also embedded
>
> thanks
>
> ps: if this just isnt possible w/ squirrel, does anyone have any ideas?
>
> thanks
>
>
>
>
> ------------------------------------------------------------------------------
> Sponsored by Intel(R) XDK
> Develop, test and display web and hybrid apps with a single code base.
> Download it for free now!
>
> http://pubads.g.doubleclick.net/gampad/clk?id=111408631&iu=/4140/ostg.clktrk
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>

[Squirrel-sql-develop] embed squirrel in my java app?

[Bruce B. <bru...@gm...>]

greetings -

I'm building a simple data utility that lets our team load data, browse it, do a vew simple views etc

this is not a commercial project, just a one-off that I'm trying to put together quickly

part of the use case is querying the data and I'm wondering why I should build a query tool from scratch

and another part of the use case is that it be an easy to install, all in one type tool

so, the question: why not just embed squirrel? using H2 as my database,  also embedded

thanks

ps: if this just isnt possible w/ squirrel, does anyone have any ideas?

thanks


 

Re: [Squirrel-sql-develop] Patches for improved xls/xlsx export/imports

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

On 02.12.2013 21:28, André Schild wrote:
> Hello Gerd,
>
>
> Am 02.12.2013 21:06, schrieb Gerd Wagner:
>> Andre,
>>
>> sorry for getting back to you so late and with such a trivial problem
>> but I've been quite busy lately.
>>
>> The problem is that I can't find your patch. Please try to resend it
>> to me directly.
>
> It's attached to this bug
> https://sourceforge.net/p/squirrel-sql/bugs/625/
>
> And also attached to this mail.

Your patch has been applied to our Git repository. It will be included 
in future snapshots and versions.

Thanks a lot

Gerd

Re: [Squirrel-sql-develop] Patches for improved xls/xlsx export/imports

[André S. <an...@sc...>]

Hello Gerd,


Am 02.12.2013 21:06, schrieb Gerd Wagner:
> Andre,
>
> sorry for getting back to you so late and with such a trivial problem 
> but I've been quite busy lately.
>
> The problem is that I can't find your patch. Please try to resend it 
> to me directly.

It's attached to this bug
https://sourceforge.net/p/squirrel-sql/bugs/625/

And also attached to this mail.

With best regards

André

Re: [Squirrel-sql-develop] Patches for improved xls/xlsx export/imports

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

Andre,

sorry for getting back to you so late and with such a trivial problem 
but I've been quite busy lately.

The problem is that I can't find your patch. Please try to resend it to 
me directly.

Thanks

Gerd


On 14.11.2013 22:39, André Schild wrote:
> Hello Gerd,
>
> Am 13.11.2013 22:12, schrieb Gerd Wagner:
>> Hi André,
>>
>> thanks for your patch. I just had a look at it. It contains only
>> changes to the Dataimport Plugin's ExcelFileImporter class. This class
>> does not affect Excel export but only import.
>>
>> I would have expected changes to the DataExportExcelWriter class in
>> our fw modul. Is there something missing in your patch?
>
> Yes,
>
> I did export only the patch for the plugin part... :(
>
> But the patch2.patch attached to the bug is now including the patches
> for all 5 files.
>
> Thanks
>
> André
>

[Squirrel-sql-develop] Question to Develop

[Jesús B. <jes...@gm...>]

Hello mates. Me and a few partners are working in a project. This is for
our University and we picked the SQuirrel project to do this.

The objective of the project is to document and analyse how SQuirrel is
managed and we have some questions that we cant find in the project home
page.


What is a Registered User and what can he do that other users cant?

How can I get a change i made aproved?

How can I apply a patch to SQuirrel?


It is not neccesary to explain that points if there are in a URL. We will
thank you if you can paste the URL of the points or a brief explanation of
them.



Thank you.

[Squirrel-sql-develop] Corrupted screen in data window as a result of horizontal scroll with focus lost event

[Ciprian M. V. [GBIF] <cvi...@gb...>]

Hello everyone,

Can only hope this is the right place to report a bug. :-|

Fedora Linux 18, latest updates; NVIDIA 430 with NVIDIA proprietary 
driver. OpenJDKjava-1.7.0-openjdk-1.7.0.60. After the latest round of 
updates AND the change from areally old, locally compiled Oracle Java to 
latest OpenJDK, itis now almost impossible to use Squirrel SQL: if a 
results windowis wider than the screen, scrolling horizontally using the 
scroll bars will completely mess the scrolled area(ask if you want a 
screen capture). A vertical scroll thoughwill restore the affected area. 
In other words, it's enough to "hide" the affected area by moving it 
verticallyand bringing it back. 90% of thetimes, results grid is also 
restored when it receives the focus via a mouse click. Scrolling via the 
keyboard (cursors or TAB) gives mixed results: a few back and forth can 
completely mess the screen but then constant scrolling in one direction 
will at one point start bringing correctresultswhen approaching the 
listing's end.


Environment as reported by Squirrel 3.5.0:

java.runtime.name    OpenJDK Runtime Environment
sun.boot.library.path 
/usr/lib/jvm/java-1.7.0-openjdk-1.7.0.60.x86_64/jre/lib/amd64
java.vm.version    24.45-b08
java.vm.vendor    Oracle Corporation
java.vendor.url    http://java.oracle.com/
path.separator    :
java.vm.name    OpenJDK 64-Bit Server VM
file.encoding.pkg    sun.io
user.country    US
sun.java.launcher    SUN_STANDARD
sun.os.patch.level    unknown
java.vm.specification.name    Java Virtual Machine Specification
user.dir    /opt/SQuirreLSQLClient
java.runtime.version 1.7.0_45-mockbuild_2013_10_16_17_51-b00
java.awt.graphicsenv    sun.awt.X11GraphicsEnvironment
java.endorsed.dirs 
/usr/lib/jvm/java-1.7.0-openjdk-1.7.0.60.x86_64/jre/lib/endorsed
os.arch    amd64
javax.accessibility.assistive_technologies 
org.GNOME.Accessibility.JavaBridge
java.io.tmpdir    /tmp
line.separator

java.vm.specification.vendor    Oracle Corporation
os.name    Linux
sun.jnu.encoding    UTF-8
java.library.path 
/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
sun.awt.enableExtraMouseButtons    true
java.specification.name    Java Platform API Specification
java.class.version    51.0
sun.management.compiler    HotSpot 64-Bit Tiered Compilers
os.version    3.11.7-100.fc18.x86_64
user.home    /home/pkm
user.timezone    Europe/Copenhagen
java.awt.printerjob    sun.print.PSPrinterJob
file.encoding    UTF-8
java.specification.version    1.7
user.name    pkm
java.class.path 
/opt/SQuirreLSQLClient/squirrel-sql.jar:/opt/SQuirreLSQLClient/lib/antlr.jar:/opt/SQuirreLSQLClient/lib/asm-attrs.jar:/opt/SQuirreLSQLClient/lib/asm.jar:/opt/SQuirreLSQLClient/lib/autocomplete.jar:/opt/SQuirreLSQLClient/lib/axis.jar:/opt/SQuirreLSQLClient/lib/axis-jaxrpc.jar:/opt/SQuirreLSQLClient/lib/axis-saaj.jar:/opt/SQuirreLSQLClient/lib/axis-wsdl4j.jar:/opt/SQuirreLSQLClient/lib/cglib.jar:/opt/SQuirreLSQLClient/lib/common.jar:/opt/SQuirreLSQLClient/lib/commons-cli.jar:/opt/SQuirreLSQLClient/lib/commons-codec.jar:/opt/SQuirreLSQLClient/lib/commons-collections.jar:/opt/SQuirreLSQLClient/lib/commons-discovery.jar:/opt/SQuirreLSQLClient/lib/commons-httpclient.jar:/opt/SQuirreLSQLClient/lib/commons-lang.jar:/opt/SQuirreLSQLClient/lib/commons-logging.jar:/opt/SQuirreLSQLClient/lib/core.jar:/opt/SQuirreLSQLClient/lib/forms.jar:/opt/SQuirreLSQLClient/lib/fw.jar:/opt/SQuirreLSQLClient/lib/hibernate-annotations.jar:/opt/SQuirreLSQLClient/lib/hibernate-commons-annotations.jar:/opt/SQuirreLSQLClient/lib/hibernate-entitymanager.jar:/opt/SQuirreLSQLClient/lib/hibernate.jar:/opt/SQuirreLSQLClient/lib/icu4j.jar:/opt/SQuirreLSQLClient/lib/javahelp.jar:/opt/SQuirreLSQLClient/lib/jcommon.jar:/opt/SQuirreLSQLClient/lib/jfreechart.jar:/opt/SQuirreLSQLClient/lib/jide-oss.jar:/opt/SQuirreLSQLClient/lib/jmeld.jar:/opt/SQuirreLSQLClient/lib/jxl.jar:/opt/SQuirreLSQLClient/lib/log4j.jar:/opt/SQuirreLSQLClient/lib/nanoxml.jar:/opt/SQuirreLSQLClient/lib/org.eclipse.equinox.common.jar:/opt/SQuirreLSQLClient/lib/osgi.jar:/opt/SQuirreLSQLClient/lib/rsyntaxtextarea.jar:/opt/SQuirreLSQLClient/lib/rtext.jar:/opt/SQuirreLSQLClient/lib/spring-beans.jar:/opt/SQuirreLSQLClient/lib/spring-context.jar:/opt/SQuirreLSQLClient/lib/spring-context-support.jar:/opt/SQuirreLSQLClient/lib/spring-core.jar:/opt/SQuirreLSQLClient/lib/stringtemplate.jar:/opt/SQuirreLSQLClient/lib/swing-worker.jar:/opt/SQuirreLSQLClient/lib/treetable.jar:/opt/SQuirreLSQLClient/lib/versioncheck.jar:/opt/SQuirreLSQLClient/lib/x86.jar:/opt/SQuirreLSQLClient/lib/xml-apis.jar:
java.vm.specification.version    1.7
sun.arch.data.model    64
java.home /usr/lib/jvm/java-1.7.0-openjdk-1.7.0.60.x86_64/jre
sun.java.command    net.sourceforge.squirrel_sql.client.Main 
--log-config-file /opt/SQuirreLSQLClient/log4j.properties 
--squirrel-home /opt/SQuirreLSQLClient
java.specification.vendor    Oracle Corporation
user.language    en
awt.toolkit    sun.awt.X11.XToolkit
java.vm.info    mixed mode
java.version    1.7.0_45
java.ext.dirs 
/usr/lib/jvm/java-1.7.0-openjdk-1.7.0.60.x86_64/jre/lib/ext:/usr/java/packages/lib/ext
sun.boot.class.path 
/usr/lib/jvm/java-1.7.0-openjdk-1.7.0.60.x86_64/jre/lib/resources.jar:/usr/lib/jvm/java-1.7.0-openjdk-1.7.0.60.x86_64/jre/lib/rt.jar:/usr/lib/jvm/java-1.7.0-openjdk-1.7.0.60.x86_64/jre/lib/sunrsasign.jar:/usr/lib/jvm/java-1.7.0-openjdk-1.7.0.60.x86_64/jre/lib/jsse.jar:/usr/lib/jvm/java-1.7.0-openjdk-1.7.0.60.x86_64/jre/lib/jce.jar:/usr/lib/jvm/java-1.7.0-openjdk-1.7.0.60.x86_64/jre/lib/charsets.jar:/usr/lib/jvm/java-1.7.0-openjdk-1.7.0.60.x86_64/jre/lib/netx.jar:/usr/lib/jvm/java-1.7.0-openjdk-1.7.0.60.x86_64/jre/lib/plugin.jar:/usr/lib/jvm/java-1.7.0-openjdk-1.7.0.60.x86_64/jre/lib/rhino.jar:/usr/lib/jvm/java-1.7.0-openjdk-1.7.0.60.x86_64/jre/lib/jfr.jar:/usr/lib/jvm/java-1.7.0-openjdk-1.7.0.60.x86_64/jre/classes
java.vendor    Oracle Corporation
file.separator    /
java.vendor.url.bug    http://bugreport.sun.com/bugreport/
sun.cpu.endian    little
sun.io.unicode.encoding    UnicodeLittle
sun.font.fontmanager    sun.awt.X11FontManager

Re: [Squirrel-sql-develop] Patches for improved xls/xlsx export/imports

[André S. <an...@sc...>]

Hello Gerd,

Am 13.11.2013 22:12, schrieb Gerd Wagner:
> Hi André,
>
> thanks for your patch. I just had a look at it. It contains only 
> changes to the Dataimport Plugin's ExcelFileImporter class. This class 
> does not affect Excel export but only import.
>
> I would have expected changes to the DataExportExcelWriter class in 
> our fw modul. Is there something missing in your patch?

Yes,

I did export only the patch for the plugin part... :(

But the patch2.patch attached to the bug is now including the patches 
for all 5 files.

Thanks

André

Re: [Squirrel-sql-develop] Patches for improved xls/xlsx export/imports

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

Hi André,

thanks for your patch. I just had a look at it. It contains only changes 
to the Dataimport Plugin's ExcelFileImporter class. This class does not 
affect Excel export but only import.

I would have expected changes to the DataExportExcelWriter class in our 
fw modul. Is there something missing in your patch?


Gerd



On 11.11.2013 19:07, André Schild wrote:
> Hello,
>
> I just posted a patchset for allow exporting results into xlsx files
> and at the same time allow importing xlsx files too.
>
> I switched the support library from the outdate and no longer supported
> JExcelApi
> to the apache POI framework.
>
> This allows us to work with xlsx files too and at the same time create
> huge xlsx file with minimal memory requirements.
>
> Any chances that my patchset gets applied to git?
>
>
> The patch is available here:
>
> https://sourceforge.net/p/squirrel-sql/bugs/625/
>
>
> André
>
>
> ------------------------------------------------------------------------------
> November Webinars for C, C++, Fortran Developers
> Accelerate application performance with scalable programming models. Explore
> techniques for threading, error checking, porting, and tuning. Get the most
> from the latest Intel processors and coprocessors. See abstracts and register
> http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>

[Squirrel-sql-develop] Patches for improved xls/xlsx export/imports

[André S. <an...@sc...>]

Hello,

I just posted a patchset for allow exporting results into xlsx files
and at the same time allow importing xlsx files too.

I switched the support library from the outdate and no longer supported 
JExcelApi
to the apache POI framework.

This allows us to work with xlsx files too and at the same time create 
huge xlsx file with minimal memory requirements.

Any chances that my patchset gets applied to git?


The patch is available here:

https://sourceforge.net/p/squirrel-sql/bugs/625/


André

[Squirrel-sql-develop] Getting started

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

Hi everyone.

I'm using sq-sql for postgres from few days now, but it is missing an
ability to display UUID and postgis geometry.

I have checked out git repo and did some changes to add those
functionalities.

I can share the code, but tell me how (and do You want them ?:) ). I can't
do push, it says that i don't have a permission....

p.s. Great job done already on this tool. keep up!

[Squirrel-sql-develop] #618 sqlparam plugin asks for commented variables

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

Hi,
I've posted fix for bug 618.

https://sourceforge.net/p/squirrel-sql/bugs/618/#d0b7
I did some manual testing and it seems working.

mkls

[Squirrel-sql-develop] Is there any possibility to ask for paid bug fixing by SQuirreL developers?

[Stepan R. <xr...@se...>]

Good afternoon, 

we would like to use SQuirreL SQL in our company as an official SQL client for
 universal access to many types of our databases. But our company policy 
requires to have for official applications to have some type of support 
possibility better than "Ask in mailing list". 

Is there any possibility to ask for (well) paid bug fixing by SQuirreL 
developers? I do not suppose to use it now, since I did not have any serious 
bug for last many years, during which I have been using SQuirreL, but company 
policy says... 

Thank You in advance for Your answer, Stepan 

[Squirrel-sql-develop] How to Update MultiSource Plugin in Repository

[Lawrence, R. <ram...@ub...>]

Hello,

 

We have been working on updating the SQuirreL MultiSource plugin to a
new 1.0 version.  These updates are complete, and I would like to know
how to get the updates committed to the repository.  (The code has been
cloned from the SQuirreL git repository and modified locally.)

 

The new multisource plugin supports SQL joins across relational sources,
MongoDB, and any other source with a JDBC driver.  It now has an
improved interface to make it easier for users to use.  I look forward
to getting this update out to the community.  

 

--

Dr. Ramon Lawrence

Associate Professor, Computer Science

Director of Distributed Database Laboratory

University of British Columbia Okanagan

https://people.ok.ubc.ca/rlawrenc/

ram...@ub...

 

Re: [Squirrel-sql-develop] MongoDB JDBC Driver for SQuirreL SQL

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

On 12.09.2013 19:04, Lawrence, Ramon wrote:
> Hello,
>
>
>
> We have built a JDBC driver for MongoDB that supports SQL queries
> including SELECT, INSERT, UPDATE, and DELETE.   The driver has been
> tested with SQuirreL, and allows SQuirreL to support MongoDB.  Would it
> be possible to include the driver in the default driver list?  (For
> driver details, go to:
> http://www.unityjdbc.com/mongojdbc/add_mongo_driver.png)
Is committed our Git repository and will be available in future 
snapshots and versions.

Thanks

Gerd

[Squirrel-sql-develop] MongoDB JDBC Driver for SQuirreL SQL

[Lawrence, R. <ram...@ub...>]

Hello,

 

We have built a JDBC driver for MongoDB that supports SQL queries
including SELECT, INSERT, UPDATE, and DELETE.   The driver has been
tested with SQuirreL, and allows SQuirreL to support MongoDB.  Would it
be possible to include the driver in the default driver list?  (For
driver details, go to:
http://www.unityjdbc.com/mongojdbc/add_mongo_driver.png)

 

The MongoDB JDBC driver is free to use and distribute for open source
projects, educational, personal, and non-commercial use.  The driver can
be downloaded at http://www.unityjdbc.com/mongojdbc/ with instructions
on its use and SQL queries supported.

 

Any feedback on the MongoDB JDBC driver or requests for other NoSQL JDBC
drivers would be appreciated.

 

--

Dr. Ramon Lawrence

Associate Professor, Computer Science

Director of Distributed Database Laboratory

University of British Columbia Okanagan

https://people.ok.ubc.ca/rlawrenc/

ram...@ub...

 

[Squirrel-sql-develop] Problem build Version for GIT

[Dieter E. <di...@ew...>]

Hi *,
I'm pretty frustrated on  building a local version from a git clone.:

 Description    Resource    Path    Location    Type
CopyQualifiedObjectNameAction cannot be resolved to a type   
ObjectTree.java   
/squirrel-sql/app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree   
line 156    Java Proble
-- 
Dieter Engelhardt

Re: [Squirrel-sql-develop] OracleDialectExt Fix

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

On 02.07.2013 21:45, Aynor, Kailash wrote:
> Developers,
>      Can someone put in fix for obvious bug below that checks for TIMESTAMP (upper case) with lowercase nativeColumnTypeName.
>
Is committed to our Git repo. Will be available in future snapshots and 
versions.

Thanks

Gerd



> In squirrel_sql/fw/dialects/OracleDialectExt.java
>
>
>          @Override
>
> +       public int getJavaTypeForNativeType(String nativeColumnTypeName)
>
> +       {
>
> +              if (nativeColumnTypeName.toLowerCase().equals("nvarchar2")) {
>
> +                      return Types.NVARCHAR;
>
> +              }
>
> +              if (nativeColumnTypeName.toLowerCase().equals("nchar")) {
>
> +                      return Types.NCHAR;
>
> +              }
>
> +              if (nativeColumnTypeName.toLowerCase().equals("nclob")) {
>
> +                      return Types.NCLOB;
>
> +              }
>
> +              if (nativeColumnTypeName.toLowerCase().startsWith("TIMESTAMP")) {
>
> +                      return Types.TIMESTAMP;
>
> +              }
>
> +              return super.getJavaTypeForNativeType(nativeColumnTypeName);
>
> +       }
>
> Thanks.
> Kailash Aynor
>