Federico Bruni | 31 Oct 20:04 2014
Picon

alternatives to sqlparam plugin?

Hi

I'm trying to achieve what is described here:
http://sourceforge.net/p/squirrel-sql/mailman/message/26645244/

i.e. run a a query that prompts me for a dynamic value.

But it seems that sqlparam has been removed from squirrel plugins.
There's any alternative?

Thanks
Federico
------------------------------------------------------------------------------
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Matt F | 29 Oct 13:50 2014
Picon

XLS export of BIGINTs

I frequently export sql results to a XLS (or XLSX) with BIGINTs. When opened by by excel, it cuts off the last few digits and turns them into 0. I know the obvious answer is to adjust excel to not do this, however I often send these out to others who may not have the technical expertise to do so. Any thoughts on how I c an modify the output to accommodate this?
 
==============================================
Matt Ferreira
defjab <at> yahoo.com
------------------------------------------------------------------------------
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
bjarne.m | 28 Oct 15:34 2014

Error during task execution: sun/io/ByteToCharConverter

Hello,

I updated my java version from 7.xx 32bit to 8.25 64bit. Since then I am
receiving the error message:

Error occured during task execution: sun/io/ByteToCharConverter

This happens when I try to setup the connection to my DB2 database. 

I used a 32 bit version of Squirrel before the error occured. When I started
occuring I upgrade to Squirrel 3.6 64bti. However, this didn't help. Any
suggestions what I could do?

--
View this message in context: http://squirrel-sql-client.10976.n7.nabble.com/Error-during-task-execution-sun-io-ByteToCharConverter-tp3469.html
Sent from the Users mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Stanislav Seltser | 27 Oct 01:07 2014

alias definitions are not saved on windows

Does anybody know how to save aliases on windows ? or which file it should be put into?

------------------------------------------------------------------------------
Gerd Wagner | 24 Oct 00:12 2014
Picon

Re: Issues with DB2/AS400 v 7.1

René,

thanks to Sam's advice I was able to connect to AS400 on PUB1.DE.

I can not load schema information, too. This is due to the following error:

java.sql.SQLException: [MCH1210] Empfängerwert zu klein, um Ergebnis zu 
halten.

Could you please see if you get the same error message? To see the error 
please connect to AS400 and then go to
menu Windows --> View SQuirreL Logs

In case you see the same error you may use the attached little Java 
program to reproduce it. (This requires a bit of java knowledge to 
compile and run the program.)

The error occurs inside the JTOpen driver when SQuirreL tries to load 
database schemas.

In this case you should contact the JTOpen team to fix the bug.

Gerd
Attachment (AS400Test.java): text/x-java, 964 bytes
------------------------------------------------------------------------------
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Gerd Wagner | 21 Oct 21:59 2014
Picon

Re: Issues with DB2/AS400 v 7.1

Am 20.10.2014 um 01:24 schrieb Sam Lennon:
> Gerd,
>
> You can get a free AS/400 accounts on WWW.PUB1.DE.  Sign up is very
> simple and automated.  DB2/400 is automatically included.  It is an
> older version of the operating system, but might be suitable for testing.
>

Thanks for the pointer. But I'm sorry I registered but didn't even 
manage to login to the system.

Perhaps someone could send me a JDBC-Url/user/password combination 
together with an URL where I could download the right JDBC driver so 
that I could right away connect with SQuirreL.

Best would be if I could reproduce René's problem with that login.

Thanks

Gerd

------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
René A Valencourt | 15 Oct 22:17 2014

Re: cannot browse tables in multiple MS SQLdatabases

This has been an ongoing problem for me, of not being able to see tables with SQL Server, as well as for DB2 on the IBM i, and has resulted in my putting Squirrel on the shelf.

 

Specifying DatabaseName for the MS SQL Server alias on the URL solved the problem there, but specifying “libraries” or “database name” for the IBM i didn’t work…  L

 

René A Valencourt, CCP, MCTS
Senior Programmer/Analyst

IS Department

(574)658-5208
(574)658-8002 (FAX)

CTB, Inc.
A Berkshire Hathaway Company

 

From: Alexandre Peshansky [mailto:Alex.Peshansky <at> einstein.yu.edu]
Sent: Friday, August 22, 2014 9:40 AM
To: Mironov, Leonid {BIS}; squirrel-sql-users <at> lists.sourceforge.net
Subject: Re: [Squirrel-sql-users] cannot browse tables in multiple MS SQLdatabases

 

Leonid,

You can create as many aliases as you need – one for each database.  Switching between tabs is even easier than jumping between databases and tables in the same tree – for me, at least.  You do need to log in for each alias, though, but only to see the trees – multi-database queries run fine as long as you are logged into any of the databases.

--

Alexandre Peshansky, MS

Senior Bioinformatics Analyst, Research Informatics Core (RIC)

Harold & Muriel Block Institute for Clinical & Translational Research at Einstein and Montefiore

Albert Einstein College of Medicine

1300 Morris Park Ave, Bronx, NY 10461

(718) 430-2440 (Mo, Tu, Th, Fr)  (718) 920-4885 (We)

 

From: Mironov, Leonid {BIS} [mailto:Leonid.Mironov <at> pepsico.com]
Sent: Friday, August 22, 2014 12:55 AM
To: Alex Malmyguine; squirrel-sql-users <at> lists.sourceforge.net
Subject: Re: [Squirrel-sql-users] cannot browse tables in multiple MS SQLdatabases

 

Yes, setting the default catalog makes life much easier - thanks for the tip, but I still can see tables of only one database at a time which makes writing multiple-database queries a rather irksome experience. I hoped that local refresh from the right-click context menu for the database, schema or TABLE object may bring the table list of the non-default database into the object tree view, but no such luck.

 

 

From: Alex Malmyguine [mailto:alex_malmyguine <at> woodbridgegroup.com]
Sent: Thursday, August 21, 2014 5:01 PM
To: squirrel-sql-users <at> lists.sourceforge.net; Mironov, Leonid {BIS}
Subject: RE: [Squirrel-sql-users] cannot browse tables in multiple MS SQLdatabases

 

Leonid,

 

I am still on 3.5.0 and I can Set Default Catalog on another database and refresh tree and cache, and it would fetch the objects.

Give it a try. Hopefully that would be a lesser inconvenience. It looks like Squirrel only fetches from default catalog.

 

Alex

 

From: Mironov, Leonid {BIS} [mailto:Leonid.Mironov <at> pepsico.com]
Sent: Thursday, August 21, 2014 6:05 AM
To: squirrel-sql-users <at> lists.sourceforge.net
Subject: [Squirrel-sql-users] cannot browse tables in multiple MS SQL databases

 

Squirrel 3.5.3 on windows 7 with jtds 1.3.1 is used to connect to MS SQL 10 with several databases on the same server using AD authentication, connection string is 'jdbc:jtds:sqlserver://address:1433/db;;integratedSecurity=true;authenticationScheme=JavaKerberos'. The problem is that with this connection string I can browse tables (i.e. expand <database>.<schema>.TABLE in the objects pane) only of the database specified in the connection string, others are empty, and if I don't specify database name there I cannot browse tables at all. All tables of all databases are still accessible in SQL queries but having to remember tables and fields by heart is rather trying, creating individual aliases for each of the databases is only a little better. Is it possible to browse tables of multiple databases?


************************************************************
This message may contain privileged, confidential and/or
trade secret information which is protected by law and is
intended only for the addressee. If you are not the intended
recipient, you are hereby notified that any dissemination,
distribution, or copying of this message is strictly
prohibited. If you have received this message in error,
please immediately notify us, and permanently delete all
copies of the message. Due to the nature of the Internet,
e-mail messages are not secure and may be delayed or
undelivered. Also, in accordance with CTB company policy,
e-mail messages may be reviewed or retained by CTB
employees in addition to or other than the intended recipient.


This footnote also confirms that this email message has
been swept by Postini for the presence of computer viruses.
************************************************************

************************************************************
This message may contain privileged, confidential and/or
trade secret information which is protected by law and is
intended only for the addressee. If you are not the intended
recipient, you are hereby notified that any dissemination,
distribution, or copying of this message is strictly
prohibited. If you have received this message in error,
please immediately notify us, and permanently delete all
copies of the message. Due to the nature of the Internet,
e-mail messages are not secure and may be delayed or
undelivered. Also, in accordance with CTB company policy,
e-mail messages may be reviewed or retained by CTB
employees in addition to or other than the intended recipient.


This footnote also confirms that this email message has
been swept by Postini for the presence of computer viruses.
************************************************************

------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Alex Malmyguine | 15 Oct 21:42 2014

Re: Issues with DB2/AS400 v 7.1

Rene:

 

What was the problem back then?

This is how driver is set up on my machine. As you can see I am still on 3.5.0 and it still works fine against i7.1

 

 

From: René A Valencourt [mailto:RValencourt <at> ctbinc.com]
Sent: Wednesday, October 15, 2014 3:29 PM
To: Alex Malmyguine
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Hello Alex,

 

This has been quite a delay in answering your question…

 

>> What versions of Squirrel and JT Open are you using?

 

I was on whatever version of Squirrel were current in April (either possibly 3.5.0 but maybe earlier) and JTOpen I thought was version 8.2, but I just discovered that the folder was empty (whether it were empty in April I don’t know).  So it had actually been using whatever came with Client Access, which was from 2012.

 

The IBM i is running OS v7r1, and I am running with Java 7.0.670.1 on my 64-bit Windows 7 PC.

 

So I:

·         upgraded to Squirrel 3.6

·         upgraded to JTOpen 8.3

·         updated my driver definition in squirrel to point to the new default jt400.jar (C:\Program Files (x86)\IBM\jtopen_8_3\lib\ jt400.jar)

 

and get the same result.

 

Then I

·         updated my driver definition in squirrel to point to the new jt400.jar for Java 6 and higher (C:\Program Files (x86)\IBM\jtopen_8_3\lib\java6\jt400.jar)

 

and still get the same result.

 

>> I am currently on Squirrel 3.5.0 with JT Open driver 7.1 and that works fine with iSeries 7.1 and 5.3 DB with default settings.  …You might want to use that as a workaround until you figured out Squirrel.

 

I downloaded JTOpen 7.1, and put its jt400.jar at the head of the list, but nothing changed.

 

Has anyone had this problem and found a resolution?

 

Thanks,

 

René A Valencourt, CCP, MCTS
Senior Programmer/Analyst

IS Department

(574)658-5208
(574)658-8002 (FAX)

CTB, Inc.
A Berkshire Hathaway Company

 

From: Alex Malmyguine [mailto:alex_malmyguine <at> woodbridgegroup.com]
Sent: Friday, April 25, 2014 4:37 PM
To: RValencourt <at> ctbinc.com
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Rene:

 

What versions of Squirrel and JT Open are you using?

 

I am currently on Squirrel 3.5.0 with JT Open driver 7.1 and that works fine with iSeries 7.1 and 5.3 DB with default settings.

 

Using the same JTOpen driver I can connect to iSeries from Oracle SQL Developer too. You might want to use that as a workaround until you figured out Squirrel.

 

Thank you!

Alex

 

From: René A Valencourt [mailto:RValencourt <at> ctbinc.com]
Sent: Friday, April 25, 2014 3:30 PM
To: 'Eric Gulatee'; 'Jim It'
Cc: squirrel-sql-users <at> lists.sourceforge.net
Subject: Re: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Jim >> There are a whole host of jdbc properties which can effect the way the IBM system handles jdbc requests.

 

Jim >> 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

 

Jim >> The one that changed is metadata source.  …change to 1 - Database metadata will be retrieved by calling system stored procedures in 7.1.

 

Jim >> 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.

 

Eric >> …I can now view the DB2/AS400  tables again using my Squirrel again.

 

Unfortunately, I changed the “metadata source” driver property to a value of ‘1’, and I still can’t view the table list.  I was using the Client Access driver from March 2012, but I just downloaded and registered with SQuirreL the March 2014 version 8.2 jt400.jar from the web site http://sourceforge.net/projects/jt400/ (the web page said it would be version 8.1), with the same result.

 

Now I just checked a Microsoft SQL Server connection, and see that I cannot expand any categories (such as “TABLE”) underneath a schema (such as “dbo”) within a SQL Server database, either.

 

So there must be some other setting that I have wrong?

 

René A Valencourt, CCP, MCTS
Senior Programmer/Analyst

IS Department

CTB, Inc.
A Berkshire Hathaway Company

 

From: Eric Gulatee [mailto:eric.gulatee <at> gmail.com]
Sent: Thursday, March 20, 2014 3:14 PM
To: Jim It
Cc: squirrel-sql-users <at> lists.sourceforge.net
Subject: Re: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Jim,

 

Thank you for the pointer.  I can now view the DB2/AS400  tables again using my Squirrel again.  Much appreciated.

 

Cheers,

Eric Gulatee

 

On Mon, Mar 3, 2014 at 3:44 PM, Jim It <jim_it <at> hotmail.com> wrote:

Eric,

 

There are a whole host of jdbc properties which can effect the way the IBM system handles jdbc requests.

 

 

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


------------------------------------------------------------------------------
Subversion Kills Productivity. Get off Subversion & Make the Move to Perforce.
With Perforce, you get hassle-free workflows. Merge that actually works.
Faster operations. Version large binaries.  Built-in WAN optimization and the
freedom to use Git, Perforce or both. Make the move to Perforce.
http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

 


************************************************************
This message may contain privileged, confidential and/or
trade secret information which is protected by law and is
intended only for the addressee. If you are not the intended
recipient, you are hereby notified that any dissemination,
distribution, or copying of this message is strictly
prohibited. If you have received this message in error,
please immediately notify us, and permanently delete all
copies of the message. Due to the nature of the Internet,
e-mail messages are not secure and may be delayed or
undelivered. Also, in accordance with CTB company policy,
e-mail messages may be reviewed or retained by CTB
employees in addition to or other than the intended recipient.


This footnote also confirms that this email message has
been swept by Postini for the presence of computer viruses.
************************************************************

************************************************************
This message may contain privileged, confidential and/or
trade secret information which is protected by law and is
intended only for the addressee. If you are not the intended
recipient, you are hereby notified that any dissemination,
distribution, or copying of this message is strictly
prohibited. If you have received this message in error,
please immediately notify us, and permanently delete all
copies of the message. Due to the nature of the Internet,
e-mail messages are not secure and may be delayed or
undelivered. Also, in accordance with CTB company policy,
e-mail messages may be reviewed or retained by CTB
employees in addition to or other than the intended recipient.


This footnote also confirms that this email message has
been swept by Postini for the presence of computer viruses.
************************************************************

------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Mike Conner | 16 Oct 15:44 2014

LazyInitializationException in Hibernate plugin

I was able to configure the Hibernate plugin using the JPA way (persistence.xml), however, when I try to query an object that contains lazy mappings, I get:

org.hibernate.LazyInitializationException

 

I can query for individual attributes, and it works.  It appears that the initial query, itself, is executing, but it fails on trying to display.

 

This is on Squirrel 3.6

 

Mike Conner
Senior Software Engineer

TeraMedica, Inc.
414.908.7748

      

Click here to make your RSNA 2014 appointment.  Visit us Nov. 30th-Dec. 4th in booth 7530, McCormick Place North.

Confidentiality Notice: This communication, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure, printing, saving, or distribution is prohibited. If you are not the intended recipient, please immediately contact the sender by reply e-mail and destroy all copies of the original message.

 

------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Federico Bruni | 15 Oct 19:02 2014
Picon

memory option?

I was trying to use the Create data feature of Scripts, but I always failed because of low memory. Then I found this:

It works now. I'm using version 3.6
What prevents you from replacing the hard-coded memory value with an environment variable or whatever a user can easily adjust?

That's the relevant part in the squirrel-sql.sh script (I've replaced 256m with 1280m):

# Launch SQuirreL application
$JAVACMD -Xmx1280m -cp "$CP" $MACOSX_SQUIRREL_PROPS -splash:"$SQUIRREL_SQL_HOME/icons/splash.jpg" net.sourceforge.squirrel_sql.client.Main --log-config-file "$UNIX_STYLE_HOME"/log4j.properties --squirrel-home "$UNIX_STYLE_HOME" $NATIVE_LAF_PROP $SCRIPT_ARGS

Regards
Federico
------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
KARR, DAVID | 15 Oct 17:25 2014
Picon

Links in "Latest News" for 3.6 and snapshot releases are reversed

I noticed that on <http://squirrel-sql.sourceforge.net/>, in the "Latest News" section, under the "New
release 3.6" section, the two installer links go to the snapshot, not the 3.6 release.  Underneath this are
the two links for the snapshot installer, which are actually links to the 3.6 release.

------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho

Gmane