squirrel-sql-users — A subscriber only discussion list for SQuirreL

[Squirrel-sql-users] Connect to Oracle database with Squirrel-sql using ssh tunneling , when we do not have straight connect to server with IP adress

[Kamil M. <kma...@po...>]

Hello,

I would lilke to ask if somebody know how to 
connect to Oracle database with  Squirrel-sql using ssh tunneling , when we do not have straight connect to server with IP adress.
I would like to connect on Windows 7 platform.
Please give me some honts or information how to configure and connect with Oracle database using ssh tunneling.

Regards
Kamil 

[Squirrel-sql-users] DB2 CLOB and XML Fields

[carlo L. <car...@co...>]

Dear Colleagues,
I'm using Squirrel as sql client for both DB2 linux V10 and iSeries V5R3-4, and I'm very satisfied due to its professional grade. I have a couple of questions for the users.

In the ADMIN_COPY_SCHEMA procedure the error table format contains two CLOBs (character large object), that SQUIRREL does not display; does anyone know which setup up parameter has to applied and where (or, if the feature is not yet implemented) ?

In a table we have a column INFO type XML. In SQUIRREL metadata we see this description:
- column name iNFO 
- column type name XML
- column type 2009
but in SQUIRREL results, the INFO field is said < UnknownType (2,009) > and the very short contained document is not shown.
 
Again, I ask for comments and suggestions.
Thanks for the cooperation.
Best regards,
carlo lunghi

Re: [Squirrel-sql-users] SQuirrel SQL Client does not open on Windows

[John E. <joh...@gm...>]

On 07/03/2014 03:17, Anukul Singhal wrote:
> Hello,
> Is there something which I can check to make the SQuirrel client working?
> Any advice/suggestions will be highly appreciated.

I had major problems getting Squirrel working on Windows because the classpath 
needed is longer than Windows can handle. I solved the problem by unpacking the 
jars into a directory called "lib" and then starting Squirrel like this:

"C:\Program Files\Java\jdk1.7.0_09\bin\javaw.exe" -Xmx256m -cp 
squirrel-sql.jar;lib net.sourceforge.squirrel_sql.client.Main --log-config-file 
"C:\Program Files\Squirrel-3.2.1\log4j.properties" --squirrel-home "C:\Program 
Files\Squirrel-3.2.1"

The developers don't seem to have tested on Windows, unfortunately.
-- 
John English

[Squirrel-sql-users] squirrel sql with jbase error

[Adetunji A. <two...@ya...>]

Hello all,

I am trying to issue an sql query in squirel as below:
'select * from FBNK.CUSTOMER'
and i am getting an error invalid column @ID.
anyone with an idea of what i am doing wrong?

Thank you.
 
Adetunji 

Re: [Squirrel-sql-users] SQuirrel SQL Client does not open on Windows

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

On Fri, 7 Mar 2014, Anukul Singhal wrote:

> Is there something which I can check to make the SQuirrel client working?
>
> Any advice/suggestions will be highly appreciated.

I've attached my squirrel-sql.bat which works on win7 x64. I have 12GB RAM 
so you might need to tweak the -Xms and -Xmx settings
if you have less.

If you want to run squirrel a the command prompt window to see whether 
Java displays any errors, you'll probably have to remove
the "start '...' /B" bit so that it doesn't launch in a new window, and 
remark out the "@echo off" at the top.

-- 
  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
-----------------------------------------------------------------------
   Failure to plan ahead on someone else's part does not constitute
   an emergency on my part.                 -- David W. Barts in a.s.r
-----------------------------------------------------------------------
  3 days until Daylight Saving Time begins in U.S. - Spring Forward

Re: [Squirrel-sql-users] SQuirrel SQL Client does not open on Windows

[Anukul S. <an...@gm...>]

Hello,

Is there something which I can check to make the SQuirrel client working?

Any advice/suggestions will be highly appreciated.

Thank you,
Anukul



On 5 March 2014 05:33, Anukul Singhal <an...@gm...> wrote:

> I have tried executing the .bat file from command prompt and I do not get
> any message back. I have also tried by explicitly giving javaw at the
> start, but its still doesn't do anything.
> I tried to look in the system, if it creates any error file, but I
> couldn't find any.
> To me it seems that it is the java environment variable which is not set.
> Can you help me if I have the java environment variable set and if its not
> there, how to set it up?
>
> Thanks,
> Anukul
>
>
>
> On 5 March 2014 04:30, John Hardin <jh...@im...> wrote:
>
>> On Wed, 5 Mar 2014, Anukul Singhal wrote:
>>
>>  I have recently installed SQuirrel SQL client on my windows laptop. I
>>> have
>>> Windows 7 Enterprise OS, 64 bit machine.
>>> The install has been successful, but when i click squirrel-sql.bat from
>>> the
>>> install directory or Program group, it just opens a black window for a
>>> flash of a millisecond and closes.
>>>
>>> What can I do to make the SQuirrel SQL client for windows open ?
>>>
>>
>> Run the .bat file from a command prompt window and take a look into any
>> error messages that it displays.
>>
>> --
>>  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
>> -----------------------------------------------------------------------
>>   Failure to plan ahead on someone else's part does not constitute
>>   an emergency on my part.                 -- David W. Barts in a.s.r
>> -----------------------------------------------------------------------
>>  5 days until Daylight Saving Time begins in U.S. - Spring Forward
>>
>
>

Re: [Squirrel-sql-users] ISAM Files

[Stefan G. <new...@sg...>]

>>
>> On the website I only can find some general comments but everything
>else
>> requires a registration :-(
>
>Bummer. However, registration does not necessarily mean giving them
>money.
>
Your probably right. :)

I'm using a workaround right now. I was a bit naive about accessing ISAM files.

Thanks for your help. 

Cheers

Stefan

-- 
Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.

Re: [Squirrel-sql-users] PostgreSQL 'inet' types displayed as '<Object>'?

[Owen, G. <go...@li...>]

> > And by extension, I could get back to the base behavior of pgAdmin and psql with the following:
> >
> > 	select regexp_replace(CAST(ip AS varchar(20)), '/\\d{1,2}', ''), ...
> >
> > But it's a little daunting to think of rewriting any SQL I want to use 
> > in Squirrel to that extent.
>
> A database function would probably be preferable. SELECT ip_to_str(ip), ...

Just to circle back on my own thread, PostgreSQL provides the functions necessary to handle this.  So simply querying for host(ip) rather than ip is the appropriate solution.

http://www.postgresql.org/docs/8.4/static/functions-net.html

That's a much simpler and more reasonable shift to make, at least to my mind.  The fact that pgAdmin and psql hide that complexity had me looking at it the wrong way...

Thanks again for the help!
gowen



The information in this message is for the intended recipient(s) only and may be the proprietary and/or confidential property of Litle & Co., LLC, and thus protected from disclosure. If you are not the intended recipient(s), or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any use, dissemination, distribution or copying of this communication is prohibited. If you have received this communication in error, please notify Litle & Co. immediately by replying to this message and then promptly deleting it and your reply permanently from your computer.

Re: [Squirrel-sql-users] SQuirrel SQL Client does not open on Windows

[Jim It <ji...@ho...>]

Anukul,
it sounds like your CLASSPATH environmental user variable is not set correctly.  This can be tricky with windows 7 because of long directory names, so I created a DOS bat file which does some of the work for me.  Save the following as .bat extension in the same directory where IBM jars are located and execute from dos command line.  (Jar files can come from Client Access installation or downloaded elsewhere.)
When you run the .bat file from DOS command, you will be displayed with your current CLASSPATH variable values and the new variable string to be added to current CLASSPATH variable.
Jim

echo offsetlocal enabledelayedexpansionset pathname=FOR /R C:. %%F in (*.jar) do (Set pathname=!pathname!%%~dpsF%%~nxF;)clsecho --------------------------------------------------------------------------------echo                          CLASSPATH Environment Variable                         echo --------------------------------------------------------------------------------echo                                     Current                                     echo --------------------------------------------------------------------------------echo %CLASSPATH%echo.echo --------------------------------------------------------------------------------echo                                      Add-on                                     echo --------------------------------------------------------------------------------set tmpname=!pathname!set outname=%tmpname:~0,-1%echo %outname%echo.echo -------------------------------------------------------------------------------- 		 	   		  

Re: [Squirrel-sql-users] SQuirrel SQL Client does not open on Windows

[Anukul S. <an...@gm...>]

I have tried executing the .bat file from command prompt and I do not get
any message back. I have also tried by explicitly giving javaw at the
start, but its still doesn't do anything.
I tried to look in the system, if it creates any error file, but I couldn't
find any.
To me it seems that it is the java environment variable which is not set.
Can you help me if I have the java environment variable set and if its not
there, how to set it up?

Thanks,
Anukul



On 5 March 2014 04:30, John Hardin <jh...@im...> wrote:

> On Wed, 5 Mar 2014, Anukul Singhal wrote:
>
>  I have recently installed SQuirrel SQL client on my windows laptop. I have
>> Windows 7 Enterprise OS, 64 bit machine.
>> The install has been successful, but when i click squirrel-sql.bat from
>> the
>> install directory or Program group, it just opens a black window for a
>> flash of a millisecond and closes.
>>
>> What can I do to make the SQuirrel SQL client for windows open ?
>>
>
> Run the .bat file from a command prompt window and take a look into any
> error messages that it displays.
>
> --
>  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
> -----------------------------------------------------------------------
>   Failure to plan ahead on someone else's part does not constitute
>   an emergency on my part.                 -- David W. Barts in a.s.r
> -----------------------------------------------------------------------
>  5 days until Daylight Saving Time begins in U.S. - Spring Forward
>

Re: [Squirrel-sql-users] SQuirrel SQL Client does not open on Windows

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

On Wed, 5 Mar 2014, Anukul Singhal wrote:

> I have recently installed SQuirrel SQL client on my windows laptop. I have
> Windows 7 Enterprise OS, 64 bit machine.
> The install has been successful, but when i click squirrel-sql.bat from the
> install directory or Program group, it just opens a black window for a
> flash of a millisecond and closes.
>
> What can I do to make the SQuirrel SQL client for windows open ?

Run the .bat file from a command prompt window and take a look into any 
error messages that it displays.

-- 
  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
-----------------------------------------------------------------------
   Failure to plan ahead on someone else's part does not constitute
   an emergency on my part.                 -- David W. Barts in a.s.r
-----------------------------------------------------------------------
  5 days until Daylight Saving Time begins in U.S. - Spring Forward

[Squirrel-sql-users] SQuirrel SQL Client does not open on Windows

[Anukul S. <an...@gm...>]

Greetings,
I have recently installed SQuirrel SQL client on my windows laptop. I have
Windows 7 Enterprise OS, 64 bit machine.
The install has been successful, but when i click squirrel-sql.bat from the
install directory or Program group, it just opens a black window for a
flash of a millisecond and closes.

What can I do to make the SQuirrel SQL client for windows open ?

Thanks,
Anukul

Re: [Squirrel-sql-users] PostgreSQL 'inet' types displayed as '<Object>'?

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

On Mon, 3 Mar 2014, Owen, Greg wrote:

> John Hardin wrote:
>> Well, absent implementing native support for the "inet" data type in Squirrel/JDBC, what does this return?
>>
>>  	select CAST(ip AS varchar(20)), count(ip)
>>  	from reports
>>  	group by ip
>>  	order by count(ip) desc
>
> That returns a much improved:
>
> ip,count
> 10.1.2.12/32,23
> 10.1.2.163/32,21
> 10.1.2.97/32,15
> 10.1.2.56/32,9
>
> And by extension, I could get back to the base behavior of pgAdmin and psql with the following:
>
> 	select regexp_replace(CAST(ip AS varchar(20)), '/\\d{1,2}', ''), ...
>
> But it's a little daunting to think of rewriting any SQL I want to use 
> in Squirrel to that extent.

A database function would probably be preferable. SELECT ip_to_str(ip), ...

> I had been rather hoping I was simply missing a driver property checkbox 
> or the like.

I expect that would be something the pgSQL JDBC driver would provide, 
sorry I can't help you with that.

> Thank you, John, that's very helpful even if not what I was hoping to hear!

Happy to help. You have to do something similar to get readable GUIDs out 
of SQL Server.

-- 
  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
-----------------------------------------------------------------------
   Failure to plan ahead on someone else's part does not constitute
   an emergency on my part.                 -- David W. Barts in a.s.r
-----------------------------------------------------------------------
  6 days until Daylight Saving Time begins in U.S. - Spring Forward

Re: [Squirrel-sql-users] PostgreSQL 'inet' types displayed as '<Object>'?

[Owen, G. <go...@li...>]

John Hardin wrote:
> Well, absent implementing native support for the "inet" data type in Squirrel/JDBC, what does this return?
> 
>  	select CAST(ip AS varchar(20)), count(ip)
>  	from reports
>  	group by ip
>  	order by count(ip) desc

That returns a much improved:

ip,count
10.1.2.12/32,23
10.1.2.163/32,21
10.1.2.97/32,15
10.1.2.56/32,9

And by extension, I could get back to the base behavior of pgAdmin and psql with the following:

	select regexp_replace(CAST(ip AS varchar(20)), '/\\d{1,2}', ''), ...

But it's a little daunting to think of rewriting any SQL I want to use in Squirrel to that extent.  I had been rather hoping I was simply missing a driver property checkbox or the like.

Thank you, John, that's very helpful even if not what I was hoping to hear!

The information in this message is for the intended recipient(s) only and may be the proprietary and/or confidential property of Litle & Co., LLC, and thus protected from disclosure. If you are not the intended recipient(s), or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any use, dissemination, distribution or copying of this communication is prohibited. If you have received this communication in error, please notify Litle & Co. immediately by replying to this message and then promptly deleting it and your reply permanently from your computer.

Re: [Squirrel-sql-users] PostgreSQL 'inet' types displayed as '<Object>'?

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

On Mon, 3 Mar 2014, Owen, Greg wrote:

> Where 'ip' is defined as type 'inet', the following query:
>
> select ip,count(ip) from reports group by ip order by count(ip) desc
>
> returns:
>
> ip,count
> <Other>,23
> <Other>,21
> <Other>,15
> <Other>,9
>
> Is there something I need to do to persuade Squirrel to display 
> PostgreSQL's 'inet' type as a string?  The actual values I see (in psql, 
> using pgAdmin, etc.) are normal dotted quad IP addresses.

Well, absent implementing native support for the "inet" data type in 
Squirrel/JDBC, what does this return?

 	select CAST(ip AS varchar(20)), count(ip)
 	from reports
 	group by ip
 	order by count(ip) desc


-- 
  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
-----------------------------------------------------------------------
   Failure to plan ahead on someone else's part does not constitute
   an emergency on my part.                 -- David W. Barts in a.s.r
-----------------------------------------------------------------------
  6 days until Daylight Saving Time begins in U.S. - Spring Forward

[Squirrel-sql-users] PostgreSQL 'inet' types displayed as '<Object>'?

[Owen, G. <go...@li...>]

Hi,

Apologies in advance, I searched the archives but couldn't find an answer to what's probably a stupid question.

Database is PostgreSQL 8.4, using driver postgresql-9.3-1101.jdbc41.jar under Java 7 update 51.

Where 'ip' is defined as type 'inet', the following query:

select ip,count(ip) from reports group by ip order by count(ip) desc

returns:

ip,count
<Other>,23
<Other>,21
<Other>,15
<Other>,9

Is there something I need to do to persuade Squirrel to display PostgreSQL's 'inet' type as a string?  The actual values I see (in psql, using pgAdmin, etc.) are normal dotted quad IP addresses.

Any help appreciated!

Thanks,
gowen

The information in this message is for the intended recipient(s) only and may be the proprietary and/or confidential property of Litle & Co., LLC, and thus protected from disclosure. If you are not the intended recipient(s), or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any use, dissemination, distribution or copying of this communication is prohibited. If you have received this communication in error, please notify Litle & Co. immediately by replying to this message and then promptly deleting it and your reply permanently from your computer.

Re: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

[Jim It <ji...@ho...>]

Eric,
There are a whole host of jdbc properties which can effect the way the IBM system handles jdbc requests.
http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/topic/rzahh/javadoc/com/ibm/as400/micro/doc-files/JDBCProperties.html?resultof=%22%53%79%73%74%65%6d%22%20%22%73%79%73%74%65%6d%22%20%22%70%72%6f%70%65%72%74%69%65%73%3a%22%20%22%70%72%6f%70%65%72%74%69%22%20
The one that changed is metadata source.  The default setting was 0 - Database metadata will be retrieved through the Retrieve Object Information (ROI) data flow, but was change to 1 - Database metadata will be retrieved by calling system stored procedures in 7.1.
Go into Alias properties, Driver Properties tab and specify the driver properties you want to use and the value you want to use, in this case 1.

Jim
 		 	   		  

Re: [Squirrel-sql-users] ISAM Files

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

On Mon, 3 Mar 2014, Stefan Grewe wrote:

> Am 01.03.2014 23:26, schrieb John Hardin:
>
> Thanks for your reply.
>> On Sat, 1 Mar 2014, Stefan Grewe wrote:
>>
>>> I'm currently using Squirrel with various MySQL, MS-SQL and Oracle Database.
>>> Now I got some ISAM files including copybook.I'm not quite sure what
>>> type of ISAM this is but application that produces the data uses a
>>> driver from transsoft.
>>
>> Have you tried looking at the JDBC drivers available on the transsoft
>> website?
>
> On the website I only can find some general comments but everything else
> requires a registration :-(

Bummer. However, registration does not necessarily mean giving them money.

>>> Is there support for that type of files in Squirrel? I've seen that
>>> there is support for HXTT drivers but ist there an, preferably open
>>> source, alternative?
>>
>> Can't really know without knowing what flavor of ISAM is in use.
>
> Did some research. Could C-ISAM Microfocus be an answer to that
> question? :-)

:) Possibly, but I have no idea for sure. As transsoft appears to be in 
the business of providing access to legacy Cobol and ISAM data, that might 
very well be it.

I suggest you try to get in touch with the developers of the application 
in question and see if they can tell you which type of ISAM their 
application is using. If they say "whatever transsoft defaults to" then 
you'd have to ask transsoft.

Absent information from the application developer and transsoft, the most 
I can suggest is trial and error - try to get as many different flavors of 
ISAM JDBC drivers as you can, and try them, and see if you can find one 
that works. Make sure you're doing this against copies of the files, not 
the production database!

If you can download a copy of the Microfocus C-ISAM JDBC driver, even a 
trial version, they try it out. That might let you determine whether 
that's the ISAM format the database uses. Then you can focus your search 
on whether there's a free JDBC driver for that ISAM format.

> I want / have to query information out of these files.  I do not want to
> change anything.

That simplifies things a bit.

-- 
  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
-----------------------------------------------------------------------
   Failure to plan ahead on someone else's part does not constitute
   an emergency on my part.                 -- David W. Barts in a.s.r
-----------------------------------------------------------------------
  6 days until Daylight Saving Time begins in U.S. - Spring Forward

[Squirrel-sql-users] Issues with DB2/AS400 v 7.1

[<eri...@gm...>]

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html><head>
<meta content="text/html; charset=unicode" http-equiv="Content-Type">
<meta name="GENERATOR" content="MSHTML 9.00.8112.16533"></head>
<body>
<div>
<div>All,</div>
<div>&nbsp;</div>
<div>After our organization upgraded from AS400 DB2 (5.3 i believe) to 
7.1,&nbsp; SQuirrel is no longer able to list out the tables for a 
namespace.</div>
<div>
<div>&nbsp;</div>
<div>What I did to try to get this working:</div>
<div>&nbsp;</div>
<div>- I upgraded squirrel to 3.5.1, no go</div>-&nbsp; I upgraded the JTOpen 
(as/400) drivers, no go.</div>
<div>-&nbsp; I recreated the connection using the new drivers, no go.</div>
<div>
<div>- I created a JDBC connection from eclipse (ugh) and it does work with the 
new updated drivers. </div>-&nbsp; I set debug enabled and I get these failures 
when I do a 'refresh all' to view the tables under the namespace</div>
<div>&nbsp;</div>
<div>Any other thoughts?&nbsp; </div>
<div>&nbsp;</div>
<div>as400: CallableStatement STMT0002 (-953972964) : Descriptor 2 created or 
changed.<br>as400: Connection B10ED53C (-166244349) : Posting warning, id: 2 
error class: 1 return code: 466 reason: [SQL0466] 1 result sets are available 
from procedure SQLGETTYPEINFO in SYSIBM. state: 0100C.java.sql.SQLWarning: 
[SQL0466] 1 result sets are available from procedure SQLGETTYPEINFO in 
SYSIBM.<br>&nbsp;at 
com.ibm.as400.access.JDError.getSQLWarning(JDError.java:347)<br>&nbsp;at 
com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java:1015)<br>&nbsp;at 
com.ibm.as400.access.AS400JDBCPreparedStatement.execute(AS400JDBCPreparedStatement.java:1237)<br>&nbsp;at 
com.ibm.as400.access.AS400JDBCDatabaseMetaData.getTypeInfo(AS400JDBCDatabaseMetaData.java:5076)<br>&nbsp;at 
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getDataTypes(SQLDatabaseMetaData.java:709)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadDataTypes(SchemaInfo.java:900)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:315)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:208)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:198)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$3.run(ObjectTree.java:325)<br>&nbsp;at 
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)<br>&nbsp;at 
java.lang.Thread.run(Thread.java:773)</div>
<div>as400: Connection B10ED53C (-166244349) : Posting warning, id: 2 error 
class: 1 return code: 466 reason: [SQL0466] 1 result sets are available from 
procedure SQLGETTYPEINFO in SYSIBM. state: 0100C.java.sql.SQLWarning: [SQL0466] 
1 result sets are available from procedure SQLGETTYPEINFO in SYSIBM.<br>&nbsp;at 
com.ibm.as400.access.JDError.getSQLWarning(JDError.java:347)<br>&nbsp;at 
com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java:1015)<br>&nbsp;at 
com.ibm.as400.access.AS400JDBCPreparedStatement.execute(AS400JDBCPreparedStatement.java:1237)<br>&nbsp;at 
com.ibm.as400.access.AS400JDBCDatabaseMetaData.getTypeInfo(AS400JDBCDatabaseMetaData.java:5076)<br>&nbsp;at 
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getDataTypes(SQLDatabaseMetaData.java:709)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadDataTypes(SchemaInfo.java:900)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:315)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:208)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:198)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$3.run(ObjectTree.java:325)<br>&nbsp;at 
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)<br>&nbsp;at 
java.lang.Thread.run(Thread.java:773)</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div>as400: CallableStatement STMT0003 (1556167018) : Descriptor 3 created or 
changed.<br>as400: Connection B10ED53C (-166244349) : Posting warning, id: 3 
error class: 1 return code: 466 reason: [SQL0466] 1 result sets are available 
from procedure SQLTABLES in SYSIBM. state: 0100C.java.sql.SQLWarning: [SQL0466] 
1 result sets are available from procedure SQLTABLES in SYSIBM.<br>&nbsp;at 
com.ibm.as400.access.JDError.getSQLWarning(JDError.java:347)<br>&nbsp;at 
com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java:1015)<br>&nbsp;at 
com.ibm.as400.access.AS400JDBCPreparedStatement.execute(AS400JDBCPreparedStatement.java:1237)<br>&nbsp;at 
com.ibm.as400.access.AS400JDBCDatabaseMetaData.getSchemas(AS400JDBCDatabaseMetaData.java:3951)<br>&nbsp;at 
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getSchemas(SQLDatabaseMetaData.java:273)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.SessionManager.areAllSchemasAllowed(SessionManager.java:623)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getAllSchemaLoadInfos(SchemaInfoCache.java:126)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getMatchingSchemaLoadInfos(SchemaInfoCache.java:161)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getMatchingSchemaLoadInfos(SchemaInfoCache.java:154)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadStoredProcedures(SchemaInfo.java:592)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadStoredProcedures(SchemaInfo.java:413)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:352)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:208)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:198)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$3.run(ObjectTree.java:325)<br>&nbsp;at 
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)<br>&nbsp;at 
java.lang.Thread.run(Thread.java:773)</div>
<div>as400: Connection B10ED53C (-166244349) : Posting warning, id: 3 error 
class: 1 return code: 466 reason: [SQL0466] 1 result sets are available from 
procedure SQLTABLES in SYSIBM. state: 0100C.java.sql.SQLWarning: [SQL0466] 1 
result sets are available from procedure SQLTABLES in SYSIBM.<br>&nbsp;at 
com.ibm.as400.access.JDError.getSQLWarning(JDError.java:347)<br>&nbsp;at 
com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java:1015)<br>&nbsp;at 
com.ibm.as400.access.AS400JDBCPreparedStatement.execute(AS400JDBCPreparedStatement.java:1237)<br>&nbsp;at 
com.ibm.as400.access.AS400JDBCDatabaseMetaData.getSchemas(AS400JDBCDatabaseMetaData.java:3951)<br>&nbsp;at 
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getSchemas(SQLDatabaseMetaData.java:273)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.SessionManager.areAllSchemasAllowed(SessionManager.java:623)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getAllSchemaLoadInfos(SchemaInfoCache.java:126)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getMatchingSchemaLoadInfos(SchemaInfoCache.java:161)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getMatchingSchemaLoadInfos(SchemaInfoCache.java:154)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadStoredProcedures(SchemaInfo.java:592)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadStoredProcedures(SchemaInfo.java:413)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:352)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:208)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:198)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$3.run(ObjectTree.java:325)<br>&nbsp;at 
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)<br>&nbsp;at 
java.lang.Thread.run(Thread.java:773)</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div>as400: CallableStatement STMT0003 (788343637) : Descriptor 3 created or 
changed.<br>as400: Connection B10ED53C (-166244349) : Posting warning, id: 3 
error class: 1 return code: 466 reason: [SQL0466] 1 result sets are available 
from procedure SQLPROCEDURES in SYSIBM. state: 0100C.java.sql.SQLWarning: 
[SQL0466] 1 result sets are available from procedure SQLPROCEDURES in 
SYSIBM.<br>&nbsp;at 
com.ibm.as400.access.JDError.getSQLWarning(JDError.java:347)<br>&nbsp;at 
com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java:1015)<br>&nbsp;at 
com.ibm.as400.access.AS400JDBCPreparedStatement.execute(AS400JDBCPreparedStatement.java:1237)<br>&nbsp;at 
com.ibm.as400.access.AS400JDBCDatabaseMetaData.getProcedures(AS400JDBCDatabaseMetaData.java:3718)<br>&nbsp;at 
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getProcedures(SQLDatabaseMetaData.java:752)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadStoredProcedures(SchemaInfo.java:598)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadStoredProcedures(SchemaInfo.java:413)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:352)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:208)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:198)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$3.run(ObjectTree.java:325)<br>&nbsp;at 
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)<br>&nbsp;at 
java.lang.Thread.run(Thread.java:773)</div>
<div>as400: Connection B10ED53C (-166244349) : Posting warning, id: 3 error 
class: 1 return code: 466 reason: [SQL0466] 1 result sets are available from 
procedure SQLPROCEDURES in SYSIBM. state: 0100C.java.sql.SQLWarning: [SQL0466] 1 
result sets are available from procedure SQLPROCEDURES in SYSIBM.<br>&nbsp;at 
com.ibm.as400.access.JDError.getSQLWarning(JDError.java:347)<br>&nbsp;at 
com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java:1015)<br>&nbsp;at 
com.ibm.as400.access.AS400JDBCPreparedStatement.execute(AS400JDBCPreparedStatement.java:1237)<br>&nbsp;at 
com.ibm.as400.access.AS400JDBCDatabaseMetaData.getProcedures(AS400JDBCDatabaseMetaData.java:3718)<br>&nbsp;at 
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getProcedures(SQLDatabaseMetaData.java:752)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadStoredProcedures(SchemaInfo.java:598)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadStoredProcedures(SchemaInfo.java:413)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:352)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:208)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:198)<br>&nbsp;at 
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$3.run(ObjectTree.java:325)<br>&nbsp;at 
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)<br>&nbsp;at 
java.lang.Thread.run(Thread.java:773)</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div>&nbsp;</div></div></body></html>

Re: [Squirrel-sql-users] ISAM Files

[Stefan G. <new...@sg...>]

Am 01.03.2014 23:26, schrieb John Hardin:

Thanks for your reply.
> On Sat, 1 Mar 2014, Stefan Grewe wrote:
>
>> I'm currently using Squirrel with various MySQL, MS-SQL and Oracle Database.
>> Now I got some ISAM files including copybook.I'm not quite sure what
>> type of ISAM this is but application that produces the data uses a
>> driver from transsoft.
> Have you tried looking at the JDBC drivers available on the transsoft
> website?
On the website I only can find some general comments but everything else 
requires a registration :-(
>> Is there support for that type of files in Squirrel? I've seen that
>> there is support for HXTT drivers but ist there an, preferably open
>> source, alternative?
> Can't really know without knowing what flavor of ISAM is in use.
>
Did some research. Could C-ISAM Microfocus be an answer to that 
question? :-)
I´m not a programmer and at the moment quite lost i the COBOL world.

I want / have to query information out of these files.  I do not want to 
change anything.



Thanks for your time

Stefan

Re: [Squirrel-sql-users] ISAM Files

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

On Sat, 1 Mar 2014, Stefan Grewe wrote:

> I'm currently using Squirrel with various MySQL, MS-SQL and Oracle Database.
> Now I got some ISAM files including copybook.I'm not quite sure what
> type of ISAM this is but application that produces the data uses a
> driver from transsoft.

Have you tried looking at the JDBC drivers available on the transsoft 
website?

> Is there support for that type of files in Squirrel? I've seen that
> there is support for HXTT drivers but ist there an, preferably open
> source, alternative?

Can't really know without knowing what flavor of ISAM is in use.

-- 
  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
-----------------------------------------------------------------------
   Homeland Security: Specializing in Tactical Band-aids for Strategic
   Problems.                       -- Eric K. in Bruce Schneier's blog
-----------------------------------------------------------------------
  12 days until Albert Einstein's 135th Birthday

[Squirrel-sql-users] ISAM Files

[Stefan G. <new...@sg...>]

Hi,

I'm currently using Squirrel with various MySQL, MS-SQL and Oracle Database.
Now I got some ISAM files including copybook.I'm not quite sure what
type of ISAM this is but application that produces the data uses a
driver from transsoft.

Is there support for that type of files in Squirrel? I've seen that
there is support for HXTT drivers but ist there an, preferably open
source, alternative?

Thanks a lot

Stefan

[Squirrel-sql-users] Find in package body

[Toole, B. <to...@up...>]

I'm currently testing SQuirreL SQL for possible use in our University, and I have stumbled across my first of likely many questions.  When viewing the Package Body source from the Object browser, is it possible to execute a Search or Find command on the body to look for a specific procedure or SQL statement?

We have quite a few large packages, and it would be handy to be able to jump to a specific part of the package code - I just haven't been able to find a way to do that yet.

Thanks!

Brian Toole '07
Applications & Data Administrator
Web and Enterprise Services
University of Portland
Portland, OR 97203
(503) 943-7196
to...@up...<mailto:to...@up...>

[Squirrel-sql-users] Unable to Open Squirrel Client

[Ravishankar R. <vio...@gm...>]

I have been using Squirrel SQL client to access Vertica (on a Windows 7
machine). It was working fine until last week but I am unable to open the
Squirrel anymore and it throws an error

    "error occurred initializing plugin: oracle".

I haven't installed any additional plugins and this has been working fine
until last week. Can someone let me know how to fix this?

Thank you.

Ravi

[Squirrel-sql-users] Multiple ResultSets?

[Karl M. <Kar...@sa...>]

I'm having issues when submitting a query that generates multiple ResultSets. Only the first one is displayed. I don't know if this is an issue with my driver or Squirrel. Is there anything special I need to do to enable multiple ResultSet processing in Squirrel? If not, what calls is Squirrel making to determine if multiple ResultSets should be displayed?

Thanks for any info.

Karl.