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

Re: [Squirrel-sql-develop] Procedure execution plugin

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

On Fri, 5 Aug 2011, Robert Manning wrote:

>> This plugin shows the parameters in a table - let's you enter the 
>> values for input arguments and when you execute the SP, it shows the 
>> values of the OUT variables in the same table.

> You are correct - the current Oracle plugin doesn't have the functionality
> that you've described.

That sounds to me like a very attractive way to run SPs/functions with 
_any_ backend. I would hope that it's generalizable.

Does it also display the return code of the SP/function? That's useful to 
know, too...

-- 
  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
-----------------------------------------------------------------------
   Gun Control: The theory that a woman found dead in an alley, raped
   and strangled with her panty hose, is somehow morally superior to
   a woman explaining to police how her attacker got that fatal bullet
   wound.                                             -- L. Neil Smith
-----------------------------------------------------------------------
  Today: the 276th anniversary of John Peter Zenger's acquittal

Re: [Squirrel-sql-develop] Procedure execution plugin

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

You are correct - the current Oracle plugin doesn't have the functionality
that you've described.  Please submit a patch for your plugin here:

http://sourceforge.net/tracker/?group_id=28383&atid=393416

You can attach the files that you want to contribute there in an archive
file.   We can then take a look at how to integrate it into the existing
Oracle plugin or add it to the distro as a separate plugin.

Rob

On Fri, Aug 5, 2011 at 12:03 PM, Subhabrata Biswas <
sub...@gm...> wrote:

> Hi Rob,
>
> I guess the Oracle plugin let's you execute procedures that don't have
> OUT parameters? Or did I get that wrong? I could not find a way to do
> that and hence wrote this plugin. This plugin shows the parameters in
> a table - let's you enter the values for input arguments and when you
> execute the SP, it shows the values of the OUT variables in the same
> table.
>
> Regards,
>
> -- Subhabrata
>
>
> On Fri, Aug 5, 2011 at 4:44 PM, Robert Manning
> <rob...@gm...> wrote:
> > Hello,
> >
> > The Oracle plugin that ships with SQuirreL today allows you to execute
> > stored procedures from the SQL editor.  Can you give it a try and tell us
> > how your plugin is different or does a better job of it ?
> >
> > For bug reports you can file them here:
> >
> > http://sourceforge.net/tracker/?group_id=28383&atid=393414
> >
> > Rob
> >
> > On Fri, Aug 5, 2011 at 6:43 AM, Subhabrata Biswas
> > <sub...@gm...> wrote:
> >>
> >> Hi,
> >>
> >> I needed a plugin for executing stored procedures in our Oracle
> >> database. I have developed the same and wish to contribute it back to
> >> the community.
> >>
> >> I had access to an Oracle database only - I have not tested this on
> >> any other database. However, I stuck to standard JDBC calls only in
> >> order to maximize its chances of working with other databases too.
> >>
> >> Is this plugin interesting to the community? If yes, how do I contribute
> >> it?
> >>
> >> In the process I have found a bug in core Squirrel SQL too (problems
> >> when a custom IMainPanelTab is closed - entry is removed from _tabPnl
> >> and not from _tabs in MainPanel::removeMainpanelTab()). Where do I
> >> report this bug?
> >>
> >> Best regards,
> >>
> >> -- Subhabrata Biswas
> >>
> >>
> >>
> ------------------------------------------------------------------------------
> >> BlackBerry&reg; DevCon Americas, Oct. 18-20, San Francisco, CA
> >> The must-attend event for mobile developers. Connect with experts.
> >> Get tools for creating Super Apps. See the latest technologies.
> >> Sessions, hands-on labs, demos & much more. Register early & save!
> >> http://p.sf.net/sfu/rim-blackberry-1
> >> _______________________________________________
> >> Squirrel-sql-develop mailing list
> >> Squ...@li...
> >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
> >
> >
>

Re: [Squirrel-sql-develop] Procedure execution plugin

[Subhabrata B. <sub...@gm...>]

Hi Rob,

I guess the Oracle plugin let's you execute procedures that don't have
OUT parameters? Or did I get that wrong? I could not find a way to do
that and hence wrote this plugin. This plugin shows the parameters in
a table - let's you enter the values for input arguments and when you
execute the SP, it shows the values of the OUT variables in the same
table.

Regards,

-- Subhabrata


On Fri, Aug 5, 2011 at 4:44 PM, Robert Manning
<rob...@gm...> wrote:
> Hello,
>
> The Oracle plugin that ships with SQuirreL today allows you to execute
> stored procedures from the SQL editor.  Can you give it a try and tell us
> how your plugin is different or does a better job of it ?
>
> For bug reports you can file them here:
>
> http://sourceforge.net/tracker/?group_id=28383&atid=393414
>
> Rob
>
> On Fri, Aug 5, 2011 at 6:43 AM, Subhabrata Biswas
> <sub...@gm...> wrote:
>>
>> Hi,
>>
>> I needed a plugin for executing stored procedures in our Oracle
>> database. I have developed the same and wish to contribute it back to
>> the community.
>>
>> I had access to an Oracle database only - I have not tested this on
>> any other database. However, I stuck to standard JDBC calls only in
>> order to maximize its chances of working with other databases too.
>>
>> Is this plugin interesting to the community? If yes, how do I contribute
>> it?
>>
>> In the process I have found a bug in core Squirrel SQL too (problems
>> when a custom IMainPanelTab is closed - entry is removed from _tabPnl
>> and not from _tabs in MainPanel::removeMainpanelTab()). Where do I
>> report this bug?
>>
>> Best regards,
>>
>> -- Subhabrata Biswas
>>
>>
>> ------------------------------------------------------------------------------
>> BlackBerry&reg; DevCon Americas, Oct. 18-20, San Francisco, CA
>> The must-attend event for mobile developers. Connect with experts.
>> Get tools for creating Super Apps. See the latest technologies.
>> Sessions, hands-on labs, demos & much more. Register early & save!
>> http://p.sf.net/sfu/rim-blackberry-1
>> _______________________________________________
>> Squirrel-sql-develop mailing list
>> Squ...@li...
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>
>

Re: [Squirrel-sql-develop] Procedure execution plugin

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

Hello,

The Oracle plugin that ships with SQuirreL today allows you to execute
stored procedures from the SQL editor.  Can you give it a try and tell us
how your plugin is different or does a better job of it ?

For bug reports you can file them here:

http://sourceforge.net/tracker/?group_id=28383&atid=393414

Rob

On Fri, Aug 5, 2011 at 6:43 AM, Subhabrata Biswas <
sub...@gm...> wrote:

> Hi,
>
> I needed a plugin for executing stored procedures in our Oracle
> database. I have developed the same and wish to contribute it back to
> the community.
>
> I had access to an Oracle database only - I have not tested this on
> any other database. However, I stuck to standard JDBC calls only in
> order to maximize its chances of working with other databases too.
>
> Is this plugin interesting to the community? If yes, how do I contribute
> it?
>
> In the process I have found a bug in core Squirrel SQL too (problems
> when a custom IMainPanelTab is closed - entry is removed from _tabPnl
> and not from _tabs in MainPanel::removeMainpanelTab()). Where do I
> report this bug?
>
> Best regards,
>
> -- Subhabrata Biswas
>
>
> ------------------------------------------------------------------------------
> BlackBerry&reg; DevCon Americas, Oct. 18-20, San Francisco, CA
> The must-attend event for mobile developers. Connect with experts.
> Get tools for creating Super Apps. See the latest technologies.
> Sessions, hands-on labs, demos & much more. Register early & save!
> http://p.sf.net/sfu/rim-blackberry-1
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>

[Squirrel-sql-develop] Procedure execution plugin

[Subhabrata B. <sub...@gm...>]

Hi,

I needed a plugin for executing stored procedures in our Oracle
database. I have developed the same and wish to contribute it back to
the community.

I had access to an Oracle database only - I have not tested this on
any other database. However, I stuck to standard JDBC calls only in
order to maximize its chances of working with other databases too.

Is this plugin interesting to the community? If yes, how do I contribute it?

In the process I have found a bug in core Squirrel SQL too (problems
when a custom IMainPanelTab is closed - entry is removed from _tabPnl
and not from _tabs in MainPanel::removeMainpanelTab()). Where do I
report this bug?

Best regards,

-- Subhabrata Biswas

Re: [Squirrel-sql-develop] Help for an Eclipse noob

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

On Tue, 5 Jul 2011, Robert Manning wrote:

> Looking at the error message it appears that Maven Central refused the
> request for this pom:
>
> http://repo1.maven.org/maven2/org/sonatype/oss/oss-parent/7/oss-parent-7.pom
>
> <http://repo1.maven.org/maven2/org/sonatype/oss/oss-parent/7/oss-parent-7.pom>That
> is very unusual, but I suppose there is no 100% reliable Internet service
> still these days.  It seems to be fine now.

It seemed to be fine in a web browser when I was having the problem over 
the weekend. I was able to grab that file in Firefox no problem at the 
time I was getting the errors in Eclipse.

> In any case, did the error stop appearing in Eclipse (and the projects 
> compile without errors)?

Not as of the time I replied to you earlier today. I've been off Eclipse 
onto building a new firewall and haven't tried since then. I will try 
again and let you know.

I'm not sure how much effort to give this, as the command-line procedure 
to compile and run one plugin does work, and I have been able to run the 
Eclipse debugger against Squirrel that way.

Now I'm a bit more daunted by wrapping my head around the Squirrel object 
model and planning for the changes I'd like to make... :)

> Rob
>
> On Tue, Jul 5, 2011 at 4:54 PM, John Hardin <jh...@im...> wrote:
>
>> On Tue, 5 Jul 2011, Robert Manning wrote:
>>
>>  Did you configure ~/.m2/settings.xml as shown below? :
>>>
>>> http://sourceforge.net/apps/**trac/squirrel-sql/wiki/**
>>> MavenSettingsXmlFile<http://sourceforge.net/apps/trac/squirrel-sql/wiki/MavenSettingsXmlFile>
>>>
>>
>> Yes, I did.
>>
>>
>>  Rob
>>>
>>> On Mon, Jul 4, 2011 at 10:04 PM, John Hardin <jh...@im...> wrote:
>>>
>>>  Folks:
>>>>
>>>> I'd like to start hacking at Squirrel, so I've downloaded and installed
>>>> Eclipse 3.6, m2e + extras, and subclipse per
>>>> http://sourceforge.net/apps/**trac/squirrel-sql/wiki/**EclipseSetup<http://sourceforge.net/apps/trac/squirrel-sql/wiki/EclipseSetup>
>>>>
>>>> But I'm having problems, and I have zero experience in the Eclipse
>>>> environment.
>>>>
>>>> When I try to Run I get this:
>>>>
>>>> [INFO] Scanning for projects...Downloading:
>>>> http://repo1.maven.org/maven2/**org/sonatype/oss/oss-parent/7/**
>>>> oss-parent-7.pom<http://repo1.maven.org/maven2/org/sonatype/oss/oss-parent/7/oss-parent-7.pom>
>>>> [ERROR] The build could not read 1 project -> [Help 1]
>>>> [ERROR]
>>>> [ERROR]   The project
>>>> net.sf.squirrel-sql:**squirrelsql-launcher:3.3.0-**SNAPSHOT
>>>> (/home/jhardin/workspace/**squirrel/squirrel-root-pom/**
>>>> installer/squirrelsql-**launcher/pom.xml)
>>>> has 1 error
>>>> [ERROR]     Non-resolvable parent POM for
>>>> net.sf.squirrel-sql:squirrel-**root-pom:3.3.0-SNAPSHOT: Could not
>>>> transfer
>>>> artifact org.sonatype.oss:oss-parent:**pom:7 from/to central (
>>>> http://repo1.maven.org/maven2)**: Connection refused and
>>>> 'parent.relativePath' points at wrong local POM @
>>>> net.sf.squirrel-sql:squirrel-**root-pom:3.3.0-SNAPSHOT,
>>>> /home/jhardin/workspace/**squirrel/squirrel-root-pom/**pom.xml, line 9,
>>>> column
>>>> 10 -> [Help 2]
>>>> [ERROR]
>>>> [ERROR] To see the full stack trace of the errors, re-run Maven with the
>>>> -e
>>>> switch.
>>>> [ERROR] Re-run Maven using the -X switch to enable full debug logging.
>>>> [ERROR]
>>>> [ERROR] For more information about the errors and possible solutions,
>>>> please read the following articles:
>>>> [ERROR] [Help 1]
>>>> http://cwiki.apache.org/**confluence/display/MAVEN/**
>>>> ProjectBuildingException<http://cwiki.apache.org/confluence/display/MAVEN/ProjectBuildingException>
>>>> [ERROR] [Help 2]
>>>> http://cwiki.apache.org/**confluence/display/MAVEN/**
>>>> UnresolvableModelException<http://cwiki.apache.org/confluence/display/MAVEN/UnresolvableModelException>
>>>>
>>>> Eclipse appears to be able to talk to the 'net ok as I was able to
>>>> install the required extensions and get the sources, and there is content
>>>> at the maven.org URL when visited in a browser.
>>>>
>>>> Any suggestions for how to get this to compile?

-- 
  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
-----------------------------------------------------------------------
   No representation without taxation!
-----------------------------------------------------------------------
  2 days until Robert Heinlein's 104th birthday

Re: [Squirrel-sql-develop] Help for an Eclipse noob

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

If you are just concerned about one plugin this is fairly straightforward:
 1. Select the project plugin that you want to debug.
 2. Click "Run" -> "Debug Configurations"
 3. Click the "New Launch Configuration" button.
 4. Give the configuration a meaningful name.
 5. Ensure that the project listed in the project textfield is the plugin
that you selected.
 6. For the "Main class" field use: net.sourceforge.squirrel_sql.client.Main
 7. Click on the arguments tab.
 8. For "Program arguments" use "-pluginlist
net.sourceforge.squirrel_sql.plugins.<plugin>.<plugin class>"

For example in the last step I chose to work with the DBCopy plugin.  So I
used the value:

-pluginlist net.sourceforge.squirrel_sql.plugins.dbcopy.DBCopyPlugin

Click the "Debug" button and SQuirreL should launch with that plugin loaded
in a few seconds (no splash screen at the moment)

Rob

On Tue, Jul 5, 2011 at 4:55 PM, John Hardin <jh...@im...> wrote:

> On Tue, 5 Jul 2011, Robert Manning wrote:
>
>  Are you talking about launching from Eclipse, or are you looking for a
>> command-line innvocation that will include more/all plugins ?
>>
>
> I was hoping to be able to launch in debug mode from within Eclipse, but
> launching from teh command-line with only one plugin and connecting to that
> process to debug is working.
>
>
>  Rob
>>
>>
>> On Mon, Jul 4, 2011 at 11:52 PM, John Hardin <jh...@im...> wrote:
>>
>>  On Mon, 4 Jul 2011, John Hardin wrote:
>>>
>>>  But I'm having problems, and I have zero experience in the Eclipse
>>>> environment.
>>>>
>>>> When I try to Run I get this:
>>>>
>>>
>>> {etc...}
>>>
>>> Is running the single-plugin mode from the commandline as documented in
>>> the dev guide the only way to run Squirrel in the dev environment?
>>>
>>
> --
>  John Hardin KA7OHZ                    http://www.impsec.org/~**jhardin/<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
> ------------------------------**------------------------------**
> -----------
>  It's easy to be noble with other people's money.
>                                   -- John McKay, _The Welfare State:
>                                      No Mercy for the Middle Class_
> ------------------------------**------------------------------**
> -----------
>  2 days until Robert Heinlein's 104th birthday
>

Re: [Squirrel-sql-develop] Help for an Eclipse noob

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

Looking at the error message it appears that Maven Central refused the
request for this pom:

http://repo1.maven.org/maven2/org/sonatype/oss/oss-parent/7/oss-parent-7.pom

<http://repo1.maven.org/maven2/org/sonatype/oss/oss-parent/7/oss-parent-7.pom>That
is very unusual, but I suppose there is no 100% reliable Internet service
still these days.  It seems to be fine now.  In any case, did the error stop
appearing in Eclipse (and the projects compile without errors)?

Rob

On Tue, Jul 5, 2011 at 4:54 PM, John Hardin <jh...@im...> wrote:

> On Tue, 5 Jul 2011, Robert Manning wrote:
>
>  Did you configure ~/.m2/settings.xml as shown below? :
>>
>> http://sourceforge.net/apps/**trac/squirrel-sql/wiki/**
>> MavenSettingsXmlFile<http://sourceforge.net/apps/trac/squirrel-sql/wiki/MavenSettingsXmlFile>
>>
>
> Yes, I did.
>
>
>  Rob
>>
>> On Mon, Jul 4, 2011 at 10:04 PM, John Hardin <jh...@im...> wrote:
>>
>>  Folks:
>>>
>>> I'd like to start hacking at Squirrel, so I've downloaded and installed
>>> Eclipse 3.6, m2e + extras, and subclipse per
>>> http://sourceforge.net/apps/**trac/squirrel-sql/wiki/**EclipseSetup<http://sourceforge.net/apps/trac/squirrel-sql/wiki/EclipseSetup>
>>>
>>> But I'm having problems, and I have zero experience in the Eclipse
>>> environment.
>>>
>>> When I try to Run I get this:
>>>
>>> [INFO] Scanning for projects...Downloading:
>>> http://repo1.maven.org/maven2/**org/sonatype/oss/oss-parent/7/**
>>> oss-parent-7.pom<http://repo1.maven.org/maven2/org/sonatype/oss/oss-parent/7/oss-parent-7.pom>
>>> [ERROR] The build could not read 1 project -> [Help 1]
>>> [ERROR]
>>> [ERROR]   The project
>>> net.sf.squirrel-sql:**squirrelsql-launcher:3.3.0-**SNAPSHOT
>>> (/home/jhardin/workspace/**squirrel/squirrel-root-pom/**
>>> installer/squirrelsql-**launcher/pom.xml)
>>> has 1 error
>>> [ERROR]     Non-resolvable parent POM for
>>> net.sf.squirrel-sql:squirrel-**root-pom:3.3.0-SNAPSHOT: Could not
>>> transfer
>>> artifact org.sonatype.oss:oss-parent:**pom:7 from/to central (
>>> http://repo1.maven.org/maven2)**: Connection refused and
>>> 'parent.relativePath' points at wrong local POM @
>>> net.sf.squirrel-sql:squirrel-**root-pom:3.3.0-SNAPSHOT,
>>> /home/jhardin/workspace/**squirrel/squirrel-root-pom/**pom.xml, line 9,
>>> column
>>> 10 -> [Help 2]
>>> [ERROR]
>>> [ERROR] To see the full stack trace of the errors, re-run Maven with the
>>> -e
>>> switch.
>>> [ERROR] Re-run Maven using the -X switch to enable full debug logging.
>>> [ERROR]
>>> [ERROR] For more information about the errors and possible solutions,
>>> please read the following articles:
>>> [ERROR] [Help 1]
>>> http://cwiki.apache.org/**confluence/display/MAVEN/**
>>> ProjectBuildingException<http://cwiki.apache.org/confluence/display/MAVEN/ProjectBuildingException>
>>> [ERROR] [Help 2]
>>> http://cwiki.apache.org/**confluence/display/MAVEN/**
>>> UnresolvableModelException<http://cwiki.apache.org/confluence/display/MAVEN/UnresolvableModelException>
>>>
>>> Eclipse appears to be able to talk to the 'net ok as I was able to
>>> install the required extensions and get the sources, and there is content
>>> at the maven.org URL when visited in a browser.
>>>
>>> Any suggestions for how to get this to compile?
>>>
>>> And any suggestions for a noob's guide to Eclipse and Maven that will
>>> help
>>> me get started hacking Squirrel and testing my changes?
>>>
>>> TIA for any advice.
>>>
>>> --
>>>  John Hardin KA7OHZ                    http://www.impsec.org/~**jhardin/<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
>>> ------------------------------**------------------------------**
>>> -----------
>>>  The difference is that Unix has had thirty years of technical
>>>  types demanding basic functionality of it. And the Macintosh has
>>>  had fifteen years of interface fascist users shaping its progress.
>>>  Windows has the hairpin turns of the Microsoft marketing machine
>>>  and that's all.                                    -- Red Drag Diva
>>> ------------------------------**------------------------------**
>>> -----------
>>>  Today: the 235th anniversary of the Declaration of Independence
>>>
>>>
>>> ------------------------------**------------------------------**
>>> ------------------
>>> All of the data generated in your IT infrastructure is seriously
>>> valuable.
>>> Why? It contains a definitive record of application performance, security
>>> threats, fraudulent activity, and more. Splunk takes this data and makes
>>> sense of it. IT sense. And common sense.
>>> http://p.sf.net/sfu/splunk-**d2d-c2 <http://p.sf.net/sfu/splunk-d2d-c2>
>>> ______________________________**_________________
>>> Squirrel-sql-develop mailing list
>>> Squirrel-sql-develop@lists.**sourceforge.net<Squ...@li...>
>>> https://lists.sourceforge.net/**lists/listinfo/squirrel-sql-**develop<https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop>
>>>
>>>
>>
> --
>  John Hardin KA7OHZ                    http://www.impsec.org/~**jhardin/<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
> ------------------------------**------------------------------**
> -----------
>  It's easy to be noble with other people's money.
>                                   -- John McKay, _The Welfare State:
>                                      No Mercy for the Middle Class_
> ------------------------------**------------------------------**
> -----------
>  2 days until Robert Heinlein's 104th birthday
>

Re: [Squirrel-sql-develop] Help for an Eclipse noob

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

On Tue, 5 Jul 2011, Robert Manning wrote:

> Are you talking about launching from Eclipse, or are you looking for a
> command-line innvocation that will include more/all plugins ?

I was hoping to be able to launch in debug mode from within Eclipse, but 
launching from teh command-line with only one plugin and connecting to 
that process to debug is working.

> Rob
>
>
> On Mon, Jul 4, 2011 at 11:52 PM, John Hardin <jh...@im...> wrote:
>
>> On Mon, 4 Jul 2011, John Hardin wrote:
>>
>>> But I'm having problems, and I have zero experience in the Eclipse
>>> environment.
>>>
>>> When I try to Run I get this:
>>
>> {etc...}
>>
>> Is running the single-plugin mode from the commandline as documented in
>> the dev guide the only way to run Squirrel in the dev environment?

-- 
  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
-----------------------------------------------------------------------
   It's easy to be noble with other people's money.
                                    -- John McKay, _The Welfare State:
                                       No Mercy for the Middle Class_
-----------------------------------------------------------------------
  2 days until Robert Heinlein's 104th birthday

Re: [Squirrel-sql-develop] Help for an Eclipse noob

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

On Tue, 5 Jul 2011, Robert Manning wrote:

> Did you configure ~/.m2/settings.xml as shown below? :
>
> http://sourceforge.net/apps/trac/squirrel-sql/wiki/MavenSettingsXmlFile

Yes, I did.

> Rob
>
> On Mon, Jul 4, 2011 at 10:04 PM, John Hardin <jh...@im...> wrote:
>
>> Folks:
>>
>> I'd like to start hacking at Squirrel, so I've downloaded and installed
>> Eclipse 3.6, m2e + extras, and subclipse per
>> http://sourceforge.net/apps/trac/squirrel-sql/wiki/EclipseSetup
>>
>> But I'm having problems, and I have zero experience in the Eclipse
>> environment.
>>
>> When I try to Run I get this:
>>
>> [INFO] Scanning for projects...Downloading:
>> http://repo1.maven.org/maven2/org/sonatype/oss/oss-parent/7/oss-parent-7.pom
>> [ERROR] The build could not read 1 project -> [Help 1]
>> [ERROR]
>> [ERROR]   The project
>> net.sf.squirrel-sql:squirrelsql-launcher:3.3.0-SNAPSHOT
>> (/home/jhardin/workspace/squirrel/squirrel-root-pom/installer/squirrelsql-launcher/pom.xml)
>> has 1 error
>> [ERROR]     Non-resolvable parent POM for
>> net.sf.squirrel-sql:squirrel-root-pom:3.3.0-SNAPSHOT: Could not transfer
>> artifact org.sonatype.oss:oss-parent:pom:7 from/to central (
>> http://repo1.maven.org/maven2): Connection refused and
>> 'parent.relativePath' points at wrong local POM @
>> net.sf.squirrel-sql:squirrel-root-pom:3.3.0-SNAPSHOT,
>> /home/jhardin/workspace/squirrel/squirrel-root-pom/pom.xml, line 9, column
>> 10 -> [Help 2]
>> [ERROR]
>> [ERROR] To see the full stack trace of the errors, re-run Maven with the -e
>> switch.
>> [ERROR] Re-run Maven using the -X switch to enable full debug logging.
>> [ERROR]
>> [ERROR] For more information about the errors and possible solutions,
>> please read the following articles:
>> [ERROR] [Help 1]
>> http://cwiki.apache.org/confluence/display/MAVEN/ProjectBuildingException
>> [ERROR] [Help 2]
>> http://cwiki.apache.org/confluence/display/MAVEN/UnresolvableModelException
>>
>> Eclipse appears to be able to talk to the 'net ok as I was able to
>> install the required extensions and get the sources, and there is content
>> at the maven.org URL when visited in a browser.
>>
>> Any suggestions for how to get this to compile?
>>
>> And any suggestions for a noob's guide to Eclipse and Maven that will help
>> me get started hacking Squirrel and testing my changes?
>>
>> TIA for any advice.
>>
>> --
>>  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
>> -----------------------------------------------------------------------
>>   The difference is that Unix has had thirty years of technical
>>   types demanding basic functionality of it. And the Macintosh has
>>   had fifteen years of interface fascist users shaping its progress.
>>   Windows has the hairpin turns of the Microsoft marketing machine
>>   and that's all.                                    -- Red Drag Diva
>> -----------------------------------------------------------------------
>>  Today: the 235th anniversary of the Declaration of Independence
>>
>>
>> ------------------------------------------------------------------------------
>> All of the data generated in your IT infrastructure is seriously valuable.
>> Why? It contains a definitive record of application performance, security
>> threats, fraudulent activity, and more. Splunk takes this data and makes
>> sense of it. IT sense. And common sense.
>> http://p.sf.net/sfu/splunk-d2d-c2
>> _______________________________________________
>> Squirrel-sql-develop mailing list
>> Squ...@li...
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>>
>

-- 
  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
-----------------------------------------------------------------------
   It's easy to be noble with other people's money.
                                    -- John McKay, _The Welfare State:
                                       No Mercy for the Middle Class_
-----------------------------------------------------------------------
  2 days until Robert Heinlein's 104th birthday

Re: [Squirrel-sql-develop] Help for an Eclipse noob

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

Are you talking about launching from Eclipse, or are you looking for a
command-line innvocation that will include more/all plugins ?

Rob


On Mon, Jul 4, 2011 at 11:52 PM, John Hardin <jh...@im...> wrote:

> On Mon, 4 Jul 2011, John Hardin wrote:
>
> > But I'm having problems, and I have zero experience in the Eclipse
> > environment.
> >
> > When I try to Run I get this:
>
> {etc...}
>
> Is running the single-plugin mode from the commandline as documented in
> the dev guide the only way to run Squirrel in the dev environment?
>
> --
>  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
> -----------------------------------------------------------------------
>   Today: the 235th anniversary of the Declaration of Independence
>
>
> ------------------------------------------------------------------------------
> All of the data generated in your IT infrastructure is seriously valuable.
> Why? It contains a definitive record of application performance, security
> threats, fraudulent activity, and more. Splunk takes this data and makes
> sense of it. IT sense. And common sense.
> http://p.sf.net/sfu/splunk-d2d-c2
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>

Re: [Squirrel-sql-develop] Help for an Eclipse noob

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

Did you configure ~/.m2/settings.xml as shown below? :

http://sourceforge.net/apps/trac/squirrel-sql/wiki/MavenSettingsXmlFile

Rob

On Mon, Jul 4, 2011 at 10:04 PM, John Hardin <jh...@im...> wrote:

> Folks:
>
> I'd like to start hacking at Squirrel, so I've downloaded and installed
> Eclipse 3.6, m2e + extras, and subclipse per
> http://sourceforge.net/apps/trac/squirrel-sql/wiki/EclipseSetup
>
> But I'm having problems, and I have zero experience in the Eclipse
> environment.
>
> When I try to Run I get this:
>
> [INFO] Scanning for projects...Downloading:
> http://repo1.maven.org/maven2/org/sonatype/oss/oss-parent/7/oss-parent-7.pom
> [ERROR] The build could not read 1 project -> [Help 1]
> [ERROR]
> [ERROR]   The project
> net.sf.squirrel-sql:squirrelsql-launcher:3.3.0-SNAPSHOT
> (/home/jhardin/workspace/squirrel/squirrel-root-pom/installer/squirrelsql-launcher/pom.xml)
> has 1 error
> [ERROR]     Non-resolvable parent POM for
> net.sf.squirrel-sql:squirrel-root-pom:3.3.0-SNAPSHOT: Could not transfer
> artifact org.sonatype.oss:oss-parent:pom:7 from/to central (
> http://repo1.maven.org/maven2): Connection refused and
> 'parent.relativePath' points at wrong local POM @
> net.sf.squirrel-sql:squirrel-root-pom:3.3.0-SNAPSHOT,
> /home/jhardin/workspace/squirrel/squirrel-root-pom/pom.xml, line 9, column
> 10 -> [Help 2]
> [ERROR]
> [ERROR] To see the full stack trace of the errors, re-run Maven with the -e
> switch.
> [ERROR] Re-run Maven using the -X switch to enable full debug logging.
> [ERROR]
> [ERROR] For more information about the errors and possible solutions,
> please read the following articles:
> [ERROR] [Help 1]
> http://cwiki.apache.org/confluence/display/MAVEN/ProjectBuildingException
> [ERROR] [Help 2]
> http://cwiki.apache.org/confluence/display/MAVEN/UnresolvableModelException
>
> Eclipse appears to be able to talk to the 'net ok as I was able to
> install the required extensions and get the sources, and there is content
> at the maven.org URL when visited in a browser.
>
> Any suggestions for how to get this to compile?
>
> And any suggestions for a noob's guide to Eclipse and Maven that will help
> me get started hacking Squirrel and testing my changes?
>
> TIA for any advice.
>
> --
>  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
> -----------------------------------------------------------------------
>   The difference is that Unix has had thirty years of technical
>   types demanding basic functionality of it. And the Macintosh has
>   had fifteen years of interface fascist users shaping its progress.
>   Windows has the hairpin turns of the Microsoft marketing machine
>   and that's all.                                    -- Red Drag Diva
> -----------------------------------------------------------------------
>  Today: the 235th anniversary of the Declaration of Independence
>
>
> ------------------------------------------------------------------------------
> All of the data generated in your IT infrastructure is seriously valuable.
> Why? It contains a definitive record of application performance, security
> threats, fraudulent activity, and more. Splunk takes this data and makes
> sense of it. IT sense. And common sense.
> http://p.sf.net/sfu/splunk-d2d-c2
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>

Re: [Squirrel-sql-develop] Help for an Eclipse noob

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

On Mon, 4 Jul 2011, John Hardin wrote:

> But I'm having problems, and I have zero experience in the Eclipse
> environment.
>
> When I try to Run I get this:

{etc...}

Is running the single-plugin mode from the commandline as documented in 
the dev guide the only way to run Squirrel in the dev environment?

-- 
  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
-----------------------------------------------------------------------
  Today: the 235th anniversary of the Declaration of Independence

[Squirrel-sql-develop] Help for an Eclipse noob

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

Folks:

I'd like to start hacking at Squirrel, so I've downloaded and installed 
Eclipse 3.6, m2e + extras, and subclipse per 
http://sourceforge.net/apps/trac/squirrel-sql/wiki/EclipseSetup

But I'm having problems, and I have zero experience in the Eclipse 
environment.

When I try to Run I get this:

[INFO] Scanning for projects...Downloading: http://repo1.maven.org/maven2/org/sonatype/oss/oss-parent/7/oss-parent-7.pom
[ERROR] The build could not read 1 project -> [Help 1]
[ERROR]
[ERROR]   The project net.sf.squirrel-sql:squirrelsql-launcher:3.3.0-SNAPSHOT (/home/jhardin/workspace/squirrel/squirrel-root-pom/installer/squirrelsql-launcher/pom.xml) has 1 error
[ERROR]     Non-resolvable parent POM for net.sf.squirrel-sql:squirrel-root-pom:3.3.0-SNAPSHOT: Could not transfer artifact org.sonatype.oss:oss-parent:pom:7 from/to central (http://repo1.maven.org/maven2): Connection refused and 'parent.relativePath' points at wrong local POM @ net.sf.squirrel-sql:squirrel-root-pom:3.3.0-SNAPSHOT, /home/jhardin/workspace/squirrel/squirrel-root-pom/pom.xml, line 9, column 10 -> [Help 2]
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/ProjectBuildingException
[ERROR] [Help 2] http://cwiki.apache.org/confluence/display/MAVEN/UnresolvableModelException

Eclipse appears to be able to talk to the 'net ok as I was able to 
install the required extensions and get the sources, and there is content 
at the maven.org URL when visited in a browser.

Any suggestions for how to get this to compile?

And any suggestions for a noob's guide to Eclipse and Maven that will help 
me get started hacking Squirrel and testing my changes?

TIA for any advice.

-- 
  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
-----------------------------------------------------------------------
   The difference is that Unix has had thirty years of technical
   types demanding basic functionality of it. And the Macintosh has
   had fifteen years of interface fascist users shaping its progress.
   Windows has the hairpin turns of the Microsoft marketing machine
   and that's all.                                    -- Red Drag Diva
-----------------------------------------------------------------------
  Today: the 235th anniversary of the Declaration of Independence

Re: [Squirrel-sql-develop] How to compile squirrelsql?

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

Hello,

On my system, I got the same NullPointerException within the 
CopyDependencyMojo, when buildingsqurrelsql-other-installer.

I figured out, that with Maven 2.2.1, the attribute "factory" is not 
injected my maven. But I don't know why!

Using Maven 3.0.3, it works fine. (And Apache said, that Maven 3 is a 
drop in replacement for Maven 2 - lol )

Adam, which maven version are you using?


Stefan

Am 2011-03-07 23:24, schrieb Adam Winn:
> Thanks.  Please let me know what you find out.
>
> On Mon, Mar 7, 2011 at 12:25 PM, Robert Manning
> <rob...@gm...>wrote:
>
>> Hmmm.... I'll have to take a closer look.  It could be a problem with the
>> code I just added this weekend, though it built fine on the build server and
>> in my local environment.
>>
>> Rob

Re: [Squirrel-sql-develop] Patch integration into main

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

Adam,

Been a little busy lately.  Hey I just noticed that your dialect
(GreenplumDialectExt) reports in supportsProduct() that it supports a
product name that begins with "PostgreSQL".  That is not an ideal
arrangement since this dialect could be chosen to use against normal
PostgreSQL databases - that do support indexes.   So, could it be that this
database identifies itself as something other than PG? (look in the metadata
tab after connection and find the value for the key getDatabaseProductName)

Also, there are no source tab implementations - only custom tab is for
external tables.  Since the dialect appears to support views and sequences,
it would be nice to have some more details tabs and maybe a source tab for
views.  Did you want to work on that while you are in there?  Also, the
Netezza database is also a data warehouse appliance based on PostgreSQL ;
Are you sure there is no support in this database for synonyms and
procedures ?

Rob


On Tue, Apr 19, 2011 at 6:32 PM, Adam Winn <win...@gm...> wrote:

> I submitted a patch a while ago.  How/when will I know when it's been
> integrated into the main branch and into a release?
>
> Thanks,
> Adam
>
> ------------------------------------------------------------------------------
> Benefiting from Server Virtualization: Beyond Initial Workload
> Consolidation -- Increasing the use of server virtualization is a top
> priority.Virtualization can reduce costs, simplify management, and improve
> application availability and disaster protection. Learn more about boosting
> the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>

[Squirrel-sql-develop] Patch integration into main

[Adam W. <win...@gm...>]

I submitted a patch a while ago.  How/when will I know when it's been
integrated into the main branch and into a release?

Thanks,
Adam

[Squirrel-sql-develop] Installer dependency documentation

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

I have written up an explanation for how new library dependencies make it
into the installers:

https://sourceforge.net/apps/trac/squirrel-minimallysql/wiki/DeveloperGuide#Addingnewlibrarydependenciestothegenericinstaller<https://sourceforge.net/apps/trac/squirrel-sql/wiki/DeveloperGuide#Addingnewlibrarydependenciestothegenericinstaller>

There is also a new minimal test for verifying that the generic installer
can connect to an embedded derby database without errors.

Rob

[Squirrel-sql-develop] problems installing on win7 - workaround

[Zoltan L. <zo...@le...>]

hi,

i had some issue to get it working:
 (1) cannot install on win7 64bit => i selected
\User\user\AppData\Local\SquirrelSQL
 (2) with "real" oracle you need jdbc driver from sql-developer (for xe, all
thin driver does the job), anyway connection cannot established behind vpn
 (3) the startup .bat file has a misstyping in the very beginning where
IZPATH inherited from JAVA_HOME. A tailing % is missing.

cu

[Squirrel-sql-develop] user-interface test activation

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

There is a new profile in the sql12/app module called "uitests".  When
activated, all normal unit tests are run, then a new test execution runs all
tests that end with "UITest.java".  For example

mvn clean install -P uitests

will trigger a test called "GeneralPreferencesPanelUITest" to be run.  It
relies on the FEST Swing testing library for testing the
GeneralPreferencesPanel.  Since it displays the GeneralPreferencesPanel
during the test, it requires a desktop environment to run (that is, no
"headless" environment).

By default, this type of test is ignored and the following invocations are
*not* affected by this new profile

mvn clean install -DskipTests
mvn clean install

At the moment this profile is only available in the "app" module.  I will
relocate this profile in the near future so that it can be inherited and
activated in plugin projects as well.

Rob

Re: [Squirrel-sql-develop] Column value showing up as <Unknown(2, 003)>

[Adam W. <win...@gm...>]

I ended up using array_to_string(), which gave me a comma delimited string,
which works out great.

On Mon, Mar 14, 2011 at 8:51 PM, Robert Manning
<rob...@gm...>wrote:

> Type 2003 is an "ARRAY" type:
>
>
>     /**
>      * The constant in the Java programming language, sometimes referred to
>      * as a type code, that identifies the generic SQL type
>      * <code>ARRAY</code>.
>      * @since 1.2
>      */
>         public final static int ARRAY               = 2003;
>
> There is currently no DataTypeComponent for "array" types (Object Tree),
> and no support in ResultSetReader for "array" types as well (SQL ResultSet
> Panel).  You could add  a custom data type for Postgres to populate the
> contents tab in the object tree.  However, we need to add support in
> ResultSetReader as this is not currently plugin-accessible.  You could
> submit a feature request.  Patches are also welcome.
>
> Rob
>
> On Mon, Mar 14, 2011 at 10:05 PM, Adam Winn <win...@gm...> wrote:
>
>> I'm running a query against Greenplum, which is a postgres-based RDBMS.
>>  The
>> below query works fine run via psql and pgAdmin3, but when run in SQuirrel
>> SQL, the value for file_location is "<Unknown(2,003)>" and not the real
>> value of
>> "{file://hostname/home/gpadmin/daily_feed/mstr/2run_dim_merchant.dat}".
>>
>> SQuirreL SQL shows the getColumnTypeName as "_text" and the
>> getColumnClassName as "java.sql.Array".  pgAdmin3 says the file_location
>> type is "text[]".
>>
>> Do you know why SQuirreL SQL gives the value of "<Unknown(2,003)>"?
>>  Thanks!
>>
>> adam=# SELECT
>> ext.location as file_location,
>> ext.fmtopts as options,
>> ext.command as command,
>> ext.rejectlimit as reject_limit,
>> ext.rejectlimittype as reject_limit_type,
>> ext.fmterrtbl as error_table
>>      FROM pg_class c
>> LEFT OUTER JOIN pg_namespace nspace ON (nspace.oid=c.relnamespace)
>> LEFT OUTER JOIN pg_exttable ext ON (ext.reloid=c.oid)
>> LEFT OUTER JOIN pg_authid auth ON (auth.oid=c.relowner)
>>      WHERE
>> (c.relkind = 'x' OR (c.relkind = 'r' AND c.relstorage = 'x'))
>> AND nspname = 'public';
>>
>>
>> Native Greenplum (postgres-based).  Run via psql on the command line and
>> with pgAdmin3:
>>                          file_location
>>                       |             options              | command |
>> reject_limit | reject_limit_type | error_table
>>
>> ------------------------------------------------------------------+----------------------------------+---------+--------------+-------------------+-------------
>>  {file://hostname/home/gpadmin/daily_feed/mstr/2run_dim_merchant.dat} |
>> delimiter '|' null '' escape '\' |         |              |
>>  |
>>  {file://hostname/home/gpadmin/daily_feed/mstr/2run_dim_merchant.dat} |
>> delimiter '|' null '' escape '\' |         |              |
>>  |
>> (2 rows)
>>
>> Time: 12.716 ms
>>
>> SQuirreL SQL:
>> file_location options command reject_limit         reject_limit_type
>> error_table
>> <Unknown(2,003)> delimiter '|' null '' escape '\'         <null> <null>
>> <null> <null>
>> <Unknown(2,003)> delimiter '|' null '' escape '\'         <null> <null>
>> <null> <null>
>>
>> ------------------------------------------------------------------------------
>> Colocation vs. Managed Hosting
>> A question and answer guide to determining the best fit
>> for your organization - today and in the future.
>> http://p.sf.net/sfu/internap-sfd2d
>> _______________________________________________
>> Squirrel-sql-develop mailing list
>> Squ...@li...
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>>
>
>

[Squirrel-sql-develop] Squirrel does not list tables when connected to DB2

[Marcin K. <mr...@gm...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello everyone,

I'm not a SquirrelSQL developer, but wanted to notify Squirrel
developers of a problem: when DB2 (9.5 in my case) is installed on
Windows, Squirrel apparently cannot list tables - when I double click
Tables in a schema, the "twistie" becomes empty.

I've tried the following commands in db2 prompt to help squirrel see
tables, but it doesn't help:

terminate
connect to TLMA
bind "C:\Program Files\IBM\SQLLIB\bnd\db2schema.bnd" blocking all grant
public sqlerror continue
terminate


My client environment, if that matters:

Windows 7 x64
IBM Java 1.6
Squirrel 3.1.2

Regards,
mk
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.14 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQEcBAEBAgAGBQJNf1AFAAoJEFMgHzhQQ7hOQPcH/iP6zpcKdre7wgG/I/WFhzBx
WAieeErVob5+MgoVvObK0Ihu6LeSHeO4MkT4zqXylrQOeYfjORy/1K+jyIPU9ezC
mtkad/lf2Jj1YT325KM8+2lNsd+fn4ol4HDrEpMS3UVBROaw/29P5vpNmbDzUuCn
WCgW4G2gSGkKNtSzZ+RGyw88hm2XbUIfM5KpUSnBq955Fg+bmSJ+b5ds9EzvgHyh
633FUwvj0b2il8bhrJQgJhunfsMrQqztJeobkTVCOwsoWWGHb4JzkJxBxGhhAgVS
GYeU6GPYP7gGMjCjCWMXKfG5hxVKjZEAb11wjNXvbyBympaIfwz4GfsOC0JaGhc=
=vaxc
-----END PGP SIGNATURE-----

Re: [Squirrel-sql-develop] Column value showing up as <Unknown(2, 003)>

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

Type 2003 is an "ARRAY" type:


    /**
     * The constant in the Java programming language, sometimes referred to
     * as a type code, that identifies the generic SQL type
     * <code>ARRAY</code>.
     * @since 1.2
     */
        public final static int ARRAY               = 2003;

There is currently no DataTypeComponent for "array" types (Object Tree), and
no support in ResultSetReader for "array" types as well (SQL ResultSet
Panel).  You could add  a custom data type for Postgres to populate the
contents tab in the object tree.  However, we need to add support in
ResultSetReader as this is not currently plugin-accessible.  You could
submit a feature request.  Patches are also welcome.

Rob

On Mon, Mar 14, 2011 at 10:05 PM, Adam Winn <win...@gm...> wrote:

> I'm running a query against Greenplum, which is a postgres-based RDBMS.
>  The
> below query works fine run via psql and pgAdmin3, but when run in SQuirrel
> SQL, the value for file_location is "<Unknown(2,003)>" and not the real
> value of
> "{file://hostname/home/gpadmin/daily_feed/mstr/2run_dim_merchant.dat}".
>
> SQuirreL SQL shows the getColumnTypeName as "_text" and the
> getColumnClassName as "java.sql.Array".  pgAdmin3 says the file_location
> type is "text[]".
>
> Do you know why SQuirreL SQL gives the value of "<Unknown(2,003)>"?
>  Thanks!
>
> adam=# SELECT
> ext.location as file_location,
> ext.fmtopts as options,
> ext.command as command,
> ext.rejectlimit as reject_limit,
> ext.rejectlimittype as reject_limit_type,
> ext.fmterrtbl as error_table
>      FROM pg_class c
> LEFT OUTER JOIN pg_namespace nspace ON (nspace.oid=c.relnamespace)
> LEFT OUTER JOIN pg_exttable ext ON (ext.reloid=c.oid)
> LEFT OUTER JOIN pg_authid auth ON (auth.oid=c.relowner)
>      WHERE
> (c.relkind = 'x' OR (c.relkind = 'r' AND c.relstorage = 'x'))
> AND nspname = 'public';
>
>
> Native Greenplum (postgres-based).  Run via psql on the command line and
> with pgAdmin3:
>                          file_location
>                       |             options              | command |
> reject_limit | reject_limit_type | error_table
>
> ------------------------------------------------------------------+----------------------------------+---------+--------------+-------------------+-------------
>  {file://hostname/home/gpadmin/daily_feed/mstr/2run_dim_merchant.dat} |
> delimiter '|' null '' escape '\' |         |              |
>  |
>  {file://hostname/home/gpadmin/daily_feed/mstr/2run_dim_merchant.dat} |
> delimiter '|' null '' escape '\' |         |              |
>  |
> (2 rows)
>
> Time: 12.716 ms
>
> SQuirreL SQL:
> file_location options command reject_limit         reject_limit_type
> error_table
> <Unknown(2,003)> delimiter '|' null '' escape '\'         <null> <null>
> <null> <null>
> <Unknown(2,003)> delimiter '|' null '' escape '\'         <null> <null>
> <null> <null>
>
> ------------------------------------------------------------------------------
> Colocation vs. Managed Hosting
> A question and answer guide to determining the best fit
> for your organization - today and in the future.
> http://p.sf.net/sfu/internap-sfd2d
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>

[Squirrel-sql-develop] Column value showing up as <Unknown(2, 003)>

[Adam W. <win...@gm...>]

I'm running a query against Greenplum, which is a postgres-based RDBMS.  The
below query works fine run via psql and pgAdmin3, but when run in SQuirrel
SQL, the value for file_location is "<Unknown(2,003)>" and not the real
value of
"{file://hostname/home/gpadmin/daily_feed/mstr/2run_dim_merchant.dat}".

SQuirreL SQL shows the getColumnTypeName as "_text" and the
getColumnClassName as "java.sql.Array".  pgAdmin3 says the file_location
type is "text[]".

Do you know why SQuirreL SQL gives the value of "<Unknown(2,003)>"?  Thanks!

adam=# SELECT
ext.location as file_location,
ext.fmtopts as options,
ext.command as command,
ext.rejectlimit as reject_limit,
ext.rejectlimittype as reject_limit_type,
ext.fmterrtbl as error_table
      FROM pg_class c
LEFT OUTER JOIN pg_namespace nspace ON (nspace.oid=c.relnamespace)
LEFT OUTER JOIN pg_exttable ext ON (ext.reloid=c.oid)
LEFT OUTER JOIN pg_authid auth ON (auth.oid=c.relowner)
      WHERE
(c.relkind = 'x' OR (c.relkind = 'r' AND c.relstorage = 'x'))
AND nspname = 'public';


Native Greenplum (postgres-based).  Run via psql on the command line and
with pgAdmin3:
                          file_location
                       |             options              | command |
reject_limit | reject_limit_type | error_table
------------------------------------------------------------------+----------------------------------+---------+--------------+-------------------+-------------
 {file://hostname/home/gpadmin/daily_feed/mstr/2run_dim_merchant.dat} |
delimiter '|' null '' escape '\' |         |              |
  |
 {file://hostname/home/gpadmin/daily_feed/mstr/2run_dim_merchant.dat} |
delimiter '|' null '' escape '\' |         |              |
  |
(2 rows)

Time: 12.716 ms

SQuirreL SQL:
file_location options command reject_limit         reject_limit_type
error_table
<Unknown(2,003)> delimiter '|' null '' escape '\'         <null> <null>
<null> <null>
<Unknown(2,003)> delimiter '|' null '' escape '\'         <null> <null>
<null> <null>

Re: [Squirrel-sql-develop] Plugin ready to release

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

Hi Adam,

Please submit the plugin as a patch here:

https://sourceforge.net/tracker/?group_id=28383&atid=393416

<https://sourceforge.net/tracker/?group_id=28383&atid=393416>Rob


On Mon, Mar 14, 2011 at 9:24 PM, Adam Winn <win...@gm...> wrote:

> I have a plugin I would like to release.  Who can I send it to for review
> and incorporation into the main branch?
>
> Thanks,
> Adam
>
> ------------------------------------------------------------------------------
> Colocation vs. Managed Hosting
> A question and answer guide to determining the best fit
> for your organization - today and in the future.
> http://p.sf.net/sfu/internap-sfd2d
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>