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

[Squirrel-sql-develop] Google Bigquery JDBC driver for SquirreL SQL

[Endre A. <ad...@st...>]

Hey everyone,

I'm glad to be a part of this community.

As for and introduction I've just wanted to show you some of our team's
latest work:
http://code.google.com/p/starschema-bigquery-jdbc/wiki/SQuirreLSQL

This JDBC driver is a spinoff from one of hour projects, and we've wanted
to share with everyone who might find it useful - especially with you guys,
since it makes possible to use Google's Bigquery service with Squirrel SQL.

Any feedback would be much appreciated. Please send your patches/pull
requests to one of the project owners. Commiters will get free beer.

Have a nice day,
Endre

[Squirrel-sql-develop] High CPU usage profiled

[Ghadi S. <gsh...@gm...>]

I saw that Squirrel was using a lot of CPU when idle. I ran it through the
YourKit profiler and collected some metrics.  Here's the spoiler:
Squirrel's status bar with the Clock + Memory graph is the offending code.
 If you disable the status bar in preferences, CPU usage drops to 0.2% from
14%.  I checked this on both Mac JDK 6 and Oracle JDK 7 with Ivy Bridge.

I recommend killing the clock -- it merely calls repaint() every second and
everybody has one...
As for the heap usage -- also recommend off by default.  End users don't
know what garbage collection is.

Thanks for a great tool, btw.  I've used it for years.  YourKit gets a big
thumbs up from me, too.

Re: [Squirrel-sql-develop] squirrel 3.2.2

[Andreas O. <cpt...@gm...>]

Hi Anil,

you might need to provide some further information so other people on 
the list might be able to help you.

 1. Why did you choose not to install the most actual version? Why did
    you choose 3.2.2?
 2. What databases do you want to send querys to?
 3. What JDBC driver do you use?
 4. Does testing of the connection work?
 5. Has the user you use to connect enough access rights for the
    databases you want to see?

If you give answers to the above questions, someone might be able to 
provide you with a solution for your problem

Take care

Andreas


Am 23.07.2012 17:10, schrieb Anil K. Madan:
> I installed this version. I am not able to expand the tables to see the columns and other properties.
> Please help.
>
> Regards
> Anil Madan
> Senior Programmer  Analyst
> MS(Engg.)  MS( Comp Sc.) MCP, MCSD,MCAD
> Barnes & Noble Distribution Center
> 1 Barnes & Noble Way
> Monroe Township, NJ 08831
> Tel:  732-656-7319
> Fax:  732-656-3226
>
>
> -------------------------------------------------------------------------
> This electronic mail message contains information that (a) is or may be CONFIDENTIAL,
> PROPRIETARY IN NATURE, OR OTHERWISE PROTECTED BY LAW FROM DISCLOSURE, and (b) is intended
> only for the use of the addressee(s) named herein.  If you are not an intended recipient,
> please send an email immediately to pos...@bn...  and take the steps necessary to delete
> the message completely from your computer system.
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>

[Squirrel-sql-develop] squirrel 3.2.2

[Anil K. M. <am...@bn...>]

I installed this version. I am not able to expand the tables to see the columns and other properties.
Please help.

Regards
Anil Madan
Senior Programmer  Analyst
MS(Engg.)  MS( Comp Sc.) MCP, MCSD,MCAD
Barnes & Noble Distribution Center
1 Barnes & Noble Way
Monroe Township, NJ 08831
Tel:  732-656-7319
Fax:  732-656-3226


-------------------------------------------------------------------------
This electronic mail message contains information that (a) is or may be CONFIDENTIAL,
PROPRIETARY IN NATURE, OR OTHERWISE PROTECTED BY LAW FROM DISCLOSURE, and (b) is intended
only for the use of the addressee(s) named herein.  If you are not an intended recipient,
please send an email immediately to pos...@bn...  and take the steps necessary to delete
the message completely from your computer system.

[Squirrel-sql-develop] Help Me About Sqirrel SQL

[Sai B. <Sai...@in...>]

Hai,
     This is Saibaba M working as SSE from Infinite Software Solutions in Chennai, Basically iam a oracle resource, could u please let me know

1)how this squirrel SQL Exactly helps to a oracle resource?
2) How it similarly works like oracle tools SQL Plus, and TOAD?
3) How its better when compared to other tools?
4) Is there any other tools which is similar to this?
5) What are the other languages are connected with this?
6) What are the basic languages do a oracle resource known to go through this SQUIRREL SQL?





Thanks & Regards,



Sai Baba M| Senior Software Engineer

Infinite | exciting times…infinite possibilities…

Telecom |Finance|Healthcare|Manufacturing|Energy & Utilities|Retail|Government

Office : +91 44  4297 5900| Extn: 5825|Mobile: +91  9500095680|Web site: www.infinite.com<http://www.infinite.com/>

email : Sai...@in...<mailto:Sai...@in...>
______________________________________________________________________________________________________________________________

This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify so to the sender by e-mail and delete the original message. In such cases, please notify us immediately at san...@in... . Further, you are not to copy, disclose, or distribute this e-mail or its contents to any unauthorized person(s) .Any such actions are considered unlawful. This e-mail may contain viruses. Infinite has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachments. Infinite reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infinite e-mail system. 

***INFINITE******** End of Disclaimer********INFINITE******** 

Re: [Squirrel-sql-develop] Plugin to Support Multiple Source Querying

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

On 15.05.2012 07:06, Lawrence, Ramon wrote:
> Gerd,
>
> Thank you for your response.
>
> I am interested in having the plugin hosted in the SVN repository and
> having it released as an optional plugin.  I would like to make it as
> widely available as possible and will do whatever is needed to make that
> happen.
>
Great. I just committed your code together with the modifications I sent 
you yesterday to our SVN repo. Please sent me your Sourceforge user name 
and I'll register you as a developer.


>> From: Gerd Wagner [mailto:ger...@t-...]
>> Sent: Monday, May 14, 2012 2:52 PM
>
>> 1. Could you provide a HTML version of your manual. This way we could
> make
>> it available in our help system.
>
> Yes, I will produce a HTML version of the manual.
Good. You can even integrated in the help system yourself. Simply but it 
in your Plugin's doc directory and then override 
Plugin.getHelpFileName() to return the name of your html file.

>
>> 2. We usually don't ship JDBC drivers. So would it be alright for you
> to just
>> mention link to the download site in the manual and create a driver
> definition
>> in default_drivers.xml that includes the link to the drivers web site?
>
> Including the driver definition in default_drivers.xml is a good idea.
> I understand that there are issues with distributing drivers with
> SQuirreL.
Good. You'll be able to do that yourself soon. ;-)

> However, the plug-in has no functionality without the driver,
> so it does make sense to at least include it as part of the plugin
> distribution.
The same is true for any of our database specific Plugins.
But if you still want to make it available with SQuirreL just put it in 
your Plugin's doc directory.


It would be nice if you could document your Plugin as well as your 
future changes with some headlines in our global change log:
<sql12>/doc/src/main/resources/changes.txt


Thanks for contributing to SQuirreL

Gerd

Re: [Squirrel-sql-develop] Plugin to Support Multiple Source Querying

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

Gerd,

Thank you for your response.

I am interested in having the plugin hosted in the SVN repository and
having it released as an optional plugin.  I would like to make it as
widely available as possible and will do whatever is needed to make that
happen.

> From: Gerd Wagner [mailto:ger...@t-...]
> Sent: Monday, May 14, 2012 2:52 PM

> 1. Could you provide a HTML version of your manual. This way we could
make
> it available in our help system.

Yes, I will produce a HTML version of the manual.
 
> 2. We usually don't ship JDBC drivers. So would it be alright for you
to just
> mention link to the download site in the manual and create a driver
definition
> in default_drivers.xml that includes the link to the drivers web site?

Including the driver definition in default_drivers.xml is a good idea.
I understand that there are issues with distributing drivers with
SQuirreL.  However, the plug-in has no functionality without the driver,
so it does make sense to at least include it as part of the plugin
distribution.

> 3. I already changed your code a little to make it more compatible
with our
> build system. Attached you find the changed code.

I will go through the changes and get the code ready for committing to
the repository.

> 4. A little inconvenience: When I execute the following erroneous
statement: ...

Thanks.  I have fixed this error message in the latest unityjdbc.jar
driver.

I look forward to getting this plugin released out to the community.  

Sincerely,

Dr. Ramon Lawrence
Associate Professor, Computer Science
UBC Okanagan

Re: [Squirrel-sql-develop] Plugin to Support Multiple Source Querying

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

Ramon,

thanks for your interest in SQuirreL and sorry I didn't make it to 
contact you earlier.

I'm project admin of SQuirreL SQL. I had a look at your Plugin and find 
it really interesting. I'd like to host it in our SVN repository and 
deliver it with future version SQuirreL as an optional Plugin. If you'd 
agree with that I'd grant you commit rights to our SVN repository to 
enable you to conveniently work on your code. Please let me know if that 
would be alright for you.


Besides that there are some things I like to note:

1. Could you provide a HTML version of your manual. This way we could 
make it available in our help system.

2. We usually don't ship JDBC drivers. So would it be alright for you to 
just mention link to the download site in the manual and create a driver 
definition in default_drivers.xml that includes the link to the drivers 
web site?

3. I already changed your code a little to make it more compatible with 
our build system. Attached you find the changed code.


4. A little inconvenience: When I execute the following erroneous statement:

select *
from MySQL.ygwaEmples
inner join PostgreSQL_saratestdb.units on MySQL.ygwaEmples.id = 
PostgreSQL_saratestdb.units

I just get is a NullPointerException instead of a explaining error 
message. Of course the correct statement that includes the missing field 
at the end

select *
from MySQL.ygwaEmples
inner join PostgreSQL_saratestdb.units on MySQL.ygwaEmples.id = 
PostgreSQL_saratestdb.units.id

executes alright


Thanks

Gerd



On 11.05.2012 06:36, Lawrence, Ramon wrote:
> I have released a version 0.1 of the multiple source plugin that allows
> a user to build a virtual view of multiple sources and pose one SQL
> query across them.  It is available for download at:
>
>
>
> https://people.ok.ubc.ca/rlawrenc/multisource.zip
>
>
>
> Instructions for installation and use are in the package and can also be
> retrieved separately at:
>
>
>
> https://people.ok.ubc.ca/rlawrenc/MultipleSourcePlugin_for_SQuirreL_User
> Manual.pdf
>
>
>
> One of the code issues that I am not happy with deals with updating the
> object tree.  The idea is that when a virtual session is opened it will
> retrieve the schema information and update the object tree to show the
> tables in all sources.  I cannot get that to work properly at session
> start time, although it works perfectly fine later.
>
>
>
> I would appreciate any feedback on the plugin as well as testing on
> different data sources and suggestions for improvement.
>
>
>
> Sincerely,
>
>
>
> Dr. Ramon Lawrence
>
> Associate Professor, Computer Science
>
> UBC Okanagan
>
>
>
> From: Andreas Oswald [mailto:cpt...@gm...]
> Sent: Tuesday, May 08, 2012 9:35 AM
> To: Lawrence, Ramon; squ...@li...
> Subject: Re: [Squirrel-sql-develop] Plugin to Support Multiple Source
> Querying
>
>
>
> Hi Ramon,
>
> from my point of view this plugin would be very useful. I use SQuirreL
> for querying different types of databases and sometimes it would be very
> useful if I could interconnect the results from queries to different
> types of databases. What kind of restrictions would there be for the
> data sources that would be combined into the virtual data source? Due to
> the lack for JDBC drivers for some of my datasources the possibility of
> using ODBC connections would be very important. The disadvantages of
> using the JDBC to ODBC bridge have been thoroughly discussed in the
> SQuirreL mailing-lists, but sometimes there is no other possibility.
>
> Do you have plans to make those virtual datasource available for
> application server data sources as well? Using your solution as a
> javax.sql.DataSource would create great opportunities.
>
> Looking forward to what might develop from your ideas.
>
> If I could be of any kind of help I'd be happy to help developing.
>
> Especially I could provide help testing for
>
> *	Oracle
> *	MySQL
> *	MS SQL
> *	different ODBC datasources (e.g. Aspentech InfoPlus.21, MS
> Access databases)
>
> Also I could work on translating to german if that might be needed.
>
> Hope to hear from you soon.
>
> Kind regards
>
> Andreas Oswald
>
> Am 08.05.2012 17:46, schrieb Lawrence, Ramon:
>
> Hello,
>
>
>
> I am working on a plugin to allow a SQuirreL user to query multiple
> sources in one query.  I would like to see if there is interest in such
> a plugin and if so, the code review and development process to follow.
>
>
>
> Plugin details available at:
>
> http://people.ok.ubc.ca/rlawrenc/MultipleSourcePlugin_for_SQuirreL.pdf
>
>
>
> Thank you for your time.
>
>
>
> --
>
> Dr. Ramon Lawrence
>
> Associate Professor, Computer Science
>
> University of British Columbia Okanagan
>
> Kelowna, British Columbia, Canada
>
> ram...@ub...
>
> http://people.ok.ubc.ca/rlawrenc/
>
>
>
>
>
> ------------------------------------------------------------------------
> ------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond.
> Discussions
> will include endpoint security, mobile security and the latest in
> malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>

Re: [Squirrel-sql-develop] Plugin to Support Multiple Source Querying

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

I have released a version 0.1 of the multiple source plugin that allows
a user to build a virtual view of multiple sources and pose one SQL
query across them.  It is available for download at:

 

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

 

Instructions for installation and use are in the package and can also be
retrieved separately at:

 

https://people.ok.ubc.ca/rlawrenc/MultipleSourcePlugin_for_SQuirreL_User
Manual.pdf

 

One of the code issues that I am not happy with deals with updating the
object tree.  The idea is that when a virtual session is opened it will
retrieve the schema information and update the object tree to show the
tables in all sources.  I cannot get that to work properly at session
start time, although it works perfectly fine later.

 

I would appreciate any feedback on the plugin as well as testing on
different data sources and suggestions for improvement.

 

Sincerely,

 

Dr. Ramon Lawrence

Associate Professor, Computer Science

UBC Okanagan

 

From: Andreas Oswald [mailto:cpt...@gm...] 
Sent: Tuesday, May 08, 2012 9:35 AM
To: Lawrence, Ramon; squ...@li...
Subject: Re: [Squirrel-sql-develop] Plugin to Support Multiple Source
Querying

 

Hi Ramon, 

from my point of view this plugin would be very useful. I use SQuirreL
for querying different types of databases and sometimes it would be very
useful if I could interconnect the results from queries to different
types of databases. What kind of restrictions would there be for the
data sources that would be combined into the virtual data source? Due to
the lack for JDBC drivers for some of my datasources the possibility of
using ODBC connections would be very important. The disadvantages of
using the JDBC to ODBC bridge have been thoroughly discussed in the
SQuirreL mailing-lists, but sometimes there is no other possibility. 

Do you have plans to make those virtual datasource available for
application server data sources as well? Using your solution as a
javax.sql.DataSource would create great opportunities. 

Looking forward to what might develop from your ideas. 

If I could be of any kind of help I'd be happy to help developing. 

Especially I could provide help testing for 

*	Oracle
*	MySQL
*	MS SQL
*	different ODBC datasources (e.g. Aspentech InfoPlus.21, MS
Access databases)

Also I could work on translating to german if that might be needed.

Hope to hear from you soon. 

Kind regards

Andreas Oswald

Am 08.05.2012 17:46, schrieb Lawrence, Ramon: 

Hello,
 
 
 
I am working on a plugin to allow a SQuirreL user to query multiple
sources in one query.  I would like to see if there is interest in such
a plugin and if so, the code review and development process to follow.
 
 
 
Plugin details available at:
 
http://people.ok.ubc.ca/rlawrenc/MultipleSourcePlugin_for_SQuirreL.pdf
 
 
 
Thank you for your time.
 
 
 
--
 
Dr. Ramon Lawrence
 
Associate Professor, Computer Science
 
University of British Columbia Okanagan
 
Kelowna, British Columbia, Canada
 
ram...@ub...
 
http://people.ok.ubc.ca/rlawrenc/
 
 
 
 
 
------------------------------------------------------------------------
------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond.
Discussions 
will include endpoint security, mobile security and the latest in
malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Squirrel-sql-develop mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop

 

Re: [Squirrel-sql-develop] Plugin to Support Multiple Source Querying

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

Andreas,

 

Thank you for your reply and your support.

 

The virtualization is designed to support any source that you have a
JDBC driver for and it has been tested with MySQL, Oracle, MS SQL,
HSQLDB, and PostgreSQL.  For sources without a JDBC driver, you can use
the JDBC-ODBC bridge.  More testing is definitely needed for all
sources.

 

By Thursday I should have a version of the plug-in available for people
to try.  I have participated in other open source projects before (e.g.
PostgreSQL) with a very formalized patch review process.  What is the
best way to distribute a plugin for testing or evaluation to the
community or project reviewers?  The simplest would be to provide the
plugin as a zip file on a web site and provide a link to it, but I want
to follow the process used by the SQuirreL community.

 

I look forward to working with you.

 

--

Dr. Ramon Lawrence

Associate Professor, Computer Science

UBC Okanagan

 

From: Andreas Oswald [mailto:cpt...@gm...] 
Sent: Tuesday, May 08, 2012 9:35 AM
To: Lawrence, Ramon; squ...@li...
Subject: Re: [Squirrel-sql-develop] Plugin to Support Multiple Source
Querying

 

Hi Ramon, 

from my point of view this plugin would be very useful. I use SQuirreL
for querying different types of databases and sometimes it would be very
useful if I could interconnect the results from queries to different
types of databases. What kind of restrictions would there be for the
data sources that would be combined into the virtual data source? Due to
the lack for JDBC drivers for some of my datasources the possibility of
using ODBC connections would be very important. The disadvantages of
using the JDBC to ODBC bridge have been thoroughly discussed in the
SQuirreL mailing-lists, but sometimes there is no other possibility. 

Do you have plans to make those virtual datasource available for
application server data sources as well? Using your solution as a
javax.sql.DataSource would create great opportunities. 

Looking forward to what might develop from your ideas. 

If I could be of any kind of help I'd be happy to help developing. 

Especially I could provide help testing for 

*	Oracle
*	MySQL
*	MS SQL
*	different ODBC datasources (e.g. Aspentech InfoPlus.21, MS
Access databases)

Also I could work on translating to german if that might be needed.

Hope to hear from you soon. 

Kind regards

Andreas Oswald

Am 08.05.2012 17:46, schrieb Lawrence, Ramon: 

Hello,
 
 
 
I am working on a plugin to allow a SQuirreL user to query multiple
sources in one query.  I would like to see if there is interest in such
a plugin and if so, the code review and development process to follow.
 
 
 
Plugin details available at:
 
http://people.ok.ubc.ca/rlawrenc/MultipleSourcePlugin_for_SQuirreL.pdf
 
 
 
Thank you for your time.
 
 
 
--
 
Dr. Ramon Lawrence
 
Associate Professor, Computer Science
 
University of British Columbia Okanagan
 
Kelowna, British Columbia, Canada
 
ram...@ub...
 
http://people.ok.ubc.ca/rlawrenc/
 
 
 
 
 
------------------------------------------------------------------------
------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond.
Discussions 
will include endpoint security, mobile security and the latest in
malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Squirrel-sql-develop mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop

 

Re: [Squirrel-sql-develop] Plugin to Support Multiple Source Querying

[Andreas O. <cpt...@gm...>]

Hi Ramon,

from my point of view this plugin would be very useful. I use SQuirreL 
for querying different types of databases and sometimes it would be very 
useful if I could interconnect the results from queries to different 
types of databases. What kind of restrictions would there be for the 
data sources that would be combined into the virtual data source? Due to 
the lack for JDBC drivers for some of my datasources the possibility of 
using ODBC connections would be very important. The disadvantages of 
using the JDBC to ODBC bridge have been thoroughly discussed in the 
SQuirreL mailing-lists, but sometimes there is no other possibility.

Do you have plans to make those virtual datasource available for 
application server data sources as well? Using your solution as a 
javax.sql.DataSource would create great opportunities.

Looking forward to what might develop from your ideas.

If I could be of any kind of help I'd be happy to help developing.

Especially I could provide help testing for

  * Oracle
  * MySQL
  * MS SQL
  * different ODBC datasources (e.g. Aspentech InfoPlus.21, MS Access
    databases)

Also I could work on translating to german if that might be needed.

Hope to hear from you soon.

Kind regards

Andreas Oswald

Am 08.05.2012 17:46, schrieb Lawrence, Ramon:
> Hello,
>
>
>
> I am working on a plugin to allow a SQuirreL user to query multiple
> sources in one query.  I would like to see if there is interest in such
> a plugin and if so, the code review and development process to follow.
>
>
>
> Plugin details available at:
>
> http://people.ok.ubc.ca/rlawrenc/MultipleSourcePlugin_for_SQuirreL.pdf
>
>
>
> Thank you for your time.
>
>
>
> --
>
> Dr. Ramon Lawrence
>
> Associate Professor, Computer Science
>
> University of British Columbia Okanagan
>
> Kelowna, British Columbia, Canada
>
> ram...@ub...
>
> http://people.ok.ubc.ca/rlawrenc/
>
>
>
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop

[Squirrel-sql-develop] Plugin to Support Multiple Source Querying

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

Hello,

 

I am working on a plugin to allow a SQuirreL user to query multiple
sources in one query.  I would like to see if there is interest in such
a plugin and if so, the code review and development process to follow.

 

Plugin details available at:

http://people.ok.ubc.ca/rlawrenc/MultipleSourcePlugin_for_SQuirreL.pdf

 

Thank you for your time.

 

--

Dr. Ramon Lawrence

Associate Professor, Computer Science

University of British Columbia Okanagan

Kelowna, British Columbia, Canada

ram...@ub...

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

 

 

Re: [Squirrel-sql-develop] Question

[Erwan D. <erw...@gm...>]

Hi,

If you mean joining data from two different database type or server, eg. 
from Oracle and MySQL, or from Oracle on server1 and Oracle on server2: 
No this is not possible with Squirrel.

However:
In some RDBMS like MS SQL Server, one can define several databases in 
the same database instance. In that case, you can use the syntaxe 
<dbname>.<schemaname>.<tablename> to build a query that joins data 
across databases.

Also, some RDBMS like Oracle or PostgreSQL can define access to remote 
databases (db-link in Oracle) or different RDBMS, but this is a RDBMS 
feature, not related to SQuirreL.

Erwan

Le 18/04/2012 16:31, David Edwards a écrit :
> Hi Squirrel
> Can one do a query with Squirrel-SQL joining data from different databases in the same query?
>
> Thanks,
> David
> ------------------------------------------------------------------------------
> Better than sec? Nothing is better than sec when it comes to
> monitoring Big Data applications. Try Boundary one-second
> resolution app monitoring today. Free.
> http://p.sf.net/sfu/Boundary-dev2dev
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop

[Squirrel-sql-develop] Question

[David E. <dav...@ya...>]

Hi Squirrel
Can one do a query with Squirrel-SQL joining data from different databases in the same query?

Thanks,
David

Re: [Squirrel-sql-develop] The message id: ids_s1_t00

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

A confusing message that indicates that a connection couldn't be
established ? :)

Rob

On Wed, Mar 14, 2012 at 9:44 AM, Rico Strydom <ric...@ho...>wrote:

>
> Hello,
>
> I'm running 2.6.6. Yesterday it was still working, but today I get this:
>
> com.tandem.t4jdbc.SQLMXException: The message id: ids_s1_t00
>  at
> com.tandem.t4jdbc.SQLMXMessages.createSQLException(SQLMXMessages.java:326)
>  at
> com.tandem.t4jdbc.InterfaceConnection.connect(InterfaceConnection.java:449)
>  at
> com.tandem.t4jdbc.InterfaceConnection.<init>(InterfaceConnection.java:117)
>  at
> com.tandem.t4jdbc.SQLMXConnection.makeConnection(SQLMXConnection.java:2015)
>  at com.tandem.t4jdbc.SQLMXConnection.<init>(SQLMXConnection.java:1963)
>  at
> com.tandem.t4jdbc.SQLMXDataSource.getConnection(SQLMXDataSource.java:143)
>  at
> com.tandem.t4jdbc.SQLMXDataSource.getConnection(SQLMXDataSource.java:192)
>  at com.tandem.t4jdbc.SQLMXDriver.connect(SQLMXDriver.java:176)
>  at
> net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
>  at
> net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnectionCommand.java:97)
>  at
> net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:279)
>  at
> net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
>  at java.lang.Thread.run(Unknown Source)
>
> Any idea what this could be?
>
> Regards
> Rico
>
> ------------------------------------------------------------------------------
> Virtualization & Cloud Management Using Capacity Planning
> Cloud computing makes use of virtualization - but cloud computing
> also focuses on allowing computing to be delivered as a service.
> http://www.accelacomm.com/jaw/sfnl/114/51521223/
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>

[Squirrel-sql-develop] The message id: ids_s1_t00

[Rico S. <ric...@ho...>]

Hello,
 
I'm running 2.6.6. Yesterday it was still working, but today I get this:
 
com.tandem.t4jdbc.SQLMXException: The message id: ids_s1_t00
 at com.tandem.t4jdbc.SQLMXMessages.createSQLException(SQLMXMessages.java:326)
 at com.tandem.t4jdbc.InterfaceConnection.connect(InterfaceConnection.java:449)
 at com.tandem.t4jdbc.InterfaceConnection.<init>(InterfaceConnection.java:117)
 at com.tandem.t4jdbc.SQLMXConnection.makeConnection(SQLMXConnection.java:2015)
 at com.tandem.t4jdbc.SQLMXConnection.<init>(SQLMXConnection.java:1963)
 at com.tandem.t4jdbc.SQLMXDataSource.getConnection(SQLMXDataSource.java:143)
 at com.tandem.t4jdbc.SQLMXDataSource.getConnection(SQLMXDataSource.java:192)
 at com.tandem.t4jdbc.SQLMXDriver.connect(SQLMXDriver.java:176)
 at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
 at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnectionCommand.java:97)
 at net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:279)
 at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
 at java.lang.Thread.run(Unknown Source)

Any idea what this could be?
 
Regards
Rico 		 	   		  

Re: [Squirrel-sql-develop] Ability to rename SQL Worksheet Tabs

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

Vladislav,


On 06.03.2012 13:28, Vladislav Vavra wrote:
> I would like to join SQuirreL SQL and so I looked to the feature
> requests and found request regarding ability to rename SQL Worksheet
> Tabs, id 3463374,
> http://sourceforge.net/tracker/?func=detail&aid=3463374&group_id=28383&atid=393417.

of course you can take care of that request. Below I quote some hints I 
send to people who are interested in contributing code to SQuirreL.

Thanks for your interest and have a lot of fun working on SQuirreL

Gerd




 > The usual way to start working is to do the changes you are interested
 > in and then send me patches of your changes.
 > Alternatively you may drop your patches here:
 > http://sourceforge.net/tracker/?group_id=28383&atid=393416
 > This way you make your work available to anybody who is interested in it
 > right from the beginning. We regularly check for now patches and add
 > them to our Subversion repository.
 >
 > Some information on how to build program SQuirreL can be found here:
 > http://www.squirrelsql.org/index.php?page=programing
 > http://www.squirrelsql.org/#overview
 >
 > If you have any further questions feel free to ask me or to post
 > messages to one of our mailing lists:
 > http://sourceforge.net/mail/?group_id=28383
 >

[Squirrel-sql-develop] Ability to rename SQL Worksheet Tabs

[Vladislav V. <vla...@gm...>]

Greetings,

I am student of Open Informatics at CTU in Prague. I'm attending Open
Source programing course and one of our duty is to join some open
source project and contribute to it.

I would like to join SQuirreL SQL and so I looked to the feature
requests and found request regarding ability to rename SQL Worksheet
Tabs, id 3463374,
http://sourceforge.net/tracker/?func=detail&aid=3463374&group_id=28383&atid=393417.

So I'm asking if this contribution would be acceptable and if it's
possible to work on it?

Best regars,

Vladislav Vavra

[Squirrel-sql-develop] Maven settings.xml update

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

I recently updated the "template" settings.xml that is needed to resolve
dependencies for SQuirreL SQL Client during builds.  This change corrects
an issue where some artifacts hosted in Maven Central were not resolved.
Please update your settings.xml (specifically the repositories section in
the "nexus" profile) when you have a chance.  The template can be found
here:
http://sourceforge.net/apps/trac/squirrel-sql/wiki/MavenSettingsXmlFile

Rob

[Squirrel-sql-develop] Fwd: Re: problem ...

[Stefan W. <wil...@ao...>]

Hi Anna,

I assume, that the Property "readOnly" is a property of the JDBC driver.

SQuirreL SQL supports the use of driver properties.

To add this to your connection do:
* Select your Alias and click "Alias Properties" in the context menu
* Then select the tab "Driver properties"
* Activate the checkbox "User driver properties"
* Look, if a property called "readOnly" is allready in your list. If 
not, you have to add one by right click on the table and choose "Add 
property" from the context menu. Use readOnly as Property name, true for 
the value and any description you want.
* Ensure, that for the property "readOnly", the checkbox "Specified" is 
enabled and the value is what you want.

Stefan


Am 2012-02-08 14:43, schrieb ave...@ce...:
> Good evening,
>
> excuse  me for my bad english but i have an answer for my problem , using
> squirrel 3.2.1 on connection with db2400 (system as400 ibm).
> I should like change this metadata value property :
>
>
> (Embedded image moved to file: pic11478.gif)isReadOnly(for data base access
> mode) true (now is false and account can change and delete records).
>
> How can i do?
>
>
> Thanks and "Ciao"
>
>
> by
>
>
> Anna
>
>
>
>
>   (Embedded image moved to file: pic29358.gif)
>
>
>   Anna Vegetti
>   Sistemi Informativi
>   Ceramica Sant'Agostino S.p.A.
>   Via Statale, 247
>   44047 - Sant'Agostino (Ferrara)
>   Telefono : +39 0532 844111/149 (diretto)
>   mailto :ave...@ce...
>   http://www.ceramicasantagostino.it
>
>
>
>   Il  contenuto e gli allegati di questo messaggio, sono da ritenere strettamente confidenziali e il
>   loro  utilizzo  è  riservato  in  via esclusiva al destinatario sopra indicato, essendone comunque
>   vietati  la  diffusione  e l'uso non autorizzato, sanzionati secondo quanto previsto dall'art. 167
>   del  D.Lgs. 30/06/2003 n. 196 - Codice Privacy - ove ciò non costituisca più grave reato. Chiunque
>   dovesse  entrare illegittimamente in possesso del testo e degli allegati del presente messaggio, è
>   pertanto pregato di procedere con la massima cura alla loro distruzione, comunicandoci via e-mail,
>   quanto accaduto all'ind...@ce....
>
>
>
>    (Embedded image moved to file: pic26962.gif)mc
>             Rispetta l'ambiente. Se non è necessario, non stampare questa email - Please consider
>             the environment before printing this email
>
>
>
>
>
> ------------------------------------------------------------------------------
> Virtualization&  Cloud Management Using Capacity Planning
> Cloud computing makes use of virtualization - but cloud computing
> also focuses on allowing computing to be delivered as a service.
> http://www.accelacomm.com/jaw/sfnl/114/51521223/
>
>
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop

Re: [Squirrel-sql-develop] problem ...

[Stefan W. <ste...@ao...>]

Hi Anna,

I assume, that the Property "readOnly" is a property of the JDBC driver.

SQuirreL SQL supports the use of driver properties.

To add this to your connection do:
* Select your Alias and click "Alias Properties" in the context menu
* Then select the tab "Driver properties"
* Activate the checkbox "User driver properties"
* Look, if a property called "readOnly" is allready in your list. If 
not, you have to add one by right click on the table and choose "Add 
property" from the context menu. Use readOnly as Property name, true for 
the value and any description you want.
* Ensure, that for the property "readOnly", the checkbox "Specified" is 
enabled and the value is what you want.

Stefan


Am 2012-02-08 14:43, schrieb ave...@ce...:
>
> Good evening,
>
> excuse  me for my bad english but i have an answer for my problem , using
> squirrel 3.2.1 on connection with db2400 (system as400 ibm).
> I should like change this metadata value property :
>
>
> (Embedded image moved to file: pic11478.gif)isReadOnly(for data base access
> mode) true (now is false and account can change and delete records).
>
> How can i do?
>
>
> Thanks and "Ciao"
>
>
> by
>
>
> Anna
>
>
>
>
>   (Embedded image moved to file: pic29358.gif)
>
>
>   Anna Vegetti
>   Sistemi Informativi
>   Ceramica Sant'Agostino S.p.A.
>   Via Statale, 247
>   44047 - Sant'Agostino (Ferrara)
>   Telefono : +39 0532 844111/149 (diretto)
>   mailto : ave...@ce...
>   http://www.ceramicasantagostino.it
>
>
>
>   Il  contenuto e gli allegati di questo messaggio, sono da ritenere strettamente confidenziali e il
>   loro  utilizzo  è  riservato  in  via esclusiva al destinatario sopra indicato, essendone comunque
>   vietati  la  diffusione  e l'uso non autorizzato, sanzionati secondo quanto previsto dall'art. 167
>   del  D.Lgs. 30/06/2003 n. 196 - Codice Privacy - ove ciò non costituisca più grave reato. Chiunque
>   dovesse  entrare illegittimamente in possesso del testo e degli allegati del presente messaggio, è
>   pertanto pregato di procedere con la massima cura alla loro distruzione, comunicandoci via e-mail,
>   quanto accaduto all'indirizzo amm...@ce....
>
>
>
>    (Embedded image moved to file: pic26962.gif)mc
>             Rispetta l'ambiente. Se non è necessario, non stampare questa email - Please consider
>             the environment before printing this email
>
>
>
>
>
> ------------------------------------------------------------------------------
> Virtualization&  Cloud Management Using Capacity Planning
> Cloud computing makes use of virtualization - but cloud computing
> also focuses on allowing computing to be delivered as a service.
> http://www.accelacomm.com/jaw/sfnl/114/51521223/
>
>
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop

[Squirrel-sql-develop] problem ...

[<ave...@ce...>]

Good evening,

excuse  me for my bad english but i have an answer for my problem , using
squirrel 3.2.1 on connection with db2400 (system as400 ibm).
I should like change this metadata value property :


(Embedded image moved to file: pic11478.gif)isReadOnly(for data base access
mode) true (now is false and account can change and delete records).

How can i do?


Thanks and "Ciao"


by


Anna
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
 (Embedded image moved to file: pic29358.gif)                                                       
                                                                                                    
                                                                                                    
 Anna Vegetti                                                                                       
 Sistemi Informativi                                                                                
 Ceramica Sant'Agostino S.p.A.                                                                      
 Via Statale, 247                                                                                   
 44047 - Sant'Agostino (Ferrara)                                                                    
 Telefono : +39 0532 844111/149 (diretto)                                                           
 mailto : ave...@ce...                                                          
 http://www.ceramicasantagostino.it                                                                 
                                                                                                    
                                                                                                    
                                                                                                    
 Il  contenuto e gli allegati di questo messaggio, sono da ritenere strettamente confidenziali e il 
 loro  utilizzo  è  riservato  in  via esclusiva al destinatario sopra indicato, essendone comunque 
 vietati  la  diffusione  e l'uso non autorizzato, sanzionati secondo quanto previsto dall'art. 167 
 del  D.Lgs. 30/06/2003 n. 196 - Codice Privacy - ove ciò non costituisca più grave reato. Chiunque 
 dovesse  entrare illegittimamente in possesso del testo e degli allegati del presente messaggio, è 
 pertanto pregato di procedere con la massima cura alla loro distruzione, comunicandoci via e-mail, 
 quanto accaduto all'indirizzo amm...@ce....                             
                                                                                                    
                                                                                                    
                                                                                                    
  (Embedded image moved to file: pic26962.gif)mc                                                    
           Rispetta l'ambiente. Se non è necessario, non stampare questa email - Please consider    
           the environment before printing this email                                               
                                                                                                    
                                                                                                    

Re: [Squirrel-sql-develop] Custom column renderers

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

On 12.01.2012 15:35, Garagan, Sean wrote:
> Good day,
>
> Is there a way to create a custom column renderer that works across all database dialects?
 > tried to create a custom DataTypeFactory to handle LOBs with a 
generic dialect but it is
> not found in the custom factory lookup code because GENERIC is treated like a DB dialect.
> If not, is this something planned for this release (or desired for this release :) )?
No, we don't have any plans for this right now. You may file a feature 
request here: http://sourceforge.net/tracker/?group_id=28383&atid=393417

Or much better implement it yourself and make a patch of your changes 
available here:
http://sourceforge.net/tracker/?group_id=28383&atid=393416

We regularly check for patches and integrate them into our source 
repository.

Gerd

[Squirrel-sql-develop] Custom column renderers

[Garagan, S. <Sea...@be...>]

Good day,

Is there a way to create a custom column renderer that works across all database dialects?  I tried to create a custom DataTypeFactory to handle LOBs with a generic dialect but it is not found in the custom factory lookup code because GENERIC is treated like a DB dialect.  If not, is this something planned for this release (or desired for this release :) )?

Thanks,
Sean

"We can't solve problems by using the same kind of thinking we used when we created them." - Albert Einstein

[Squirrel-sql-develop] Testing for plugins

[Garagan, S. <Sea...@be...>]

Good day,

I am looking at creating a *LOB viewer plugin to allow *LOB columns to be rendered based on the content (initially serialized Java classes but ideally extensible to other types).  I have a start to this but before I get much further, is there a specific pattern for implementing unit tests to handle DB calls?  Basically, is there any mechanism for an in-memory DB (like H2) specifically for use during test runs?  I saw that SQuirreL uses easymock but if there is something that has been built to use as a SQL-compliant DB during testing, I would definitely prefer to use that.

Thanks,
Sean

"We can't solve problems by using the same kind of thinking we used when we created them." - Albert Einstein