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

Re: [Squirrel-sql-users] what to do with fw.jar

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

There have been no further updates to the stable version (3.4.0).  What is
the update URL that you are using ?

Rob

On Mon, Feb 25, 2013 at 10:15 AM, René A Valencourt
<RVa...@ct...>wrote:

> Hi Rob,****
>
> ** **
>
> >> The SQuirreL installer places this file along with many other jar
> files in the lib/ folder.****
>
> ** **
>
> Yes, it did.****
>
> ** **
>
> >> You appear to have the latest stable version installed (3.4.0).  Are
> you looking for information on how to install a snapshot version?****
>
> ** **
>
> My installation is a Windows 7 desktop.  I received notices (due to my
> subscription to SQuirreL notifications) that a new fw.jar was available.
> This was subsequent to the release of 3.4.0, and the notices mention only
> the fw.jar file, hence my question.****
>
> ** **
>
> If I understand you correctly, you’re saying that all I need to do is
> replace the fw.jar file in the lib folder, that no further installation is
> needed than what has already been done.  ?****
>
> ** **
>
> René A Valencourt, CCP, MCTS
> IS Dept.
> CTB, Inc.
> A Berkshire Hathaway Company****
>
> 574.658.5208
> 574.658.8002 (FAX)****
>
> ** **
>
> ** **
>
> *From:* Robert Manning [mailto:rob...@gm...]
> *Sent:* Saturday, February 23, 2013 6:59 AM
> *To:* RVa...@ct...
> *Subject:* Re: [Squirrel-sql-users] what to do with fw.jar****
>
> ** **
>
>
> The archive file "fw.jar" is a core library of "framework" classes used by
> SQuirreL.  The SQuirreL installer places this file along with many other
> jar files in the lib/ folder.  You shouldn't need to replace individual
> files in the this directory manually, unless directed to do so by a
> developer.  The installer and the software update feature will do this for
> you.  You appear to have the latest stable version installed (3.4.0).  Are
> you looking for information on how to install a snapshot version?
>
> Rob****
>
> ** **
>
> On Thu, Feb 21, 2013 at 9:47 AM, René A Valencourt <RVa...@ct...>
> wrote:****
>
> I have found no instructions on what to do with fw.jar.
>
> I have found it in the Squirrel-sql-3.4.0\lib directory.  Do I just replace
> it, or is there an install process?
>
> What exactly is the purpose of fw.jar?
>
> Thanks,
>
> René
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> 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.
> ************************************************************
>
>
>

Re: [Squirrel-sql-users] what to do with fw.jar

[René A V. <RVa...@ct...>]

Hi Rob,

 

>> The SQuirreL installer places this file along with many other jar files
in the lib/ folder.

 

Yes, it did.

 

>> You appear to have the latest stable version installed (3.4.0).  Are you
looking for information on how to install a snapshot version?

 

My installation is a Windows 7 desktop.  I received notices (due to my
subscription to SQuirreL notifications) that a new fw.jar was available.
This was subsequent to the release of 3.4.0, and the notices mention only
the fw.jar file, hence my question.

 

If I understand you correctly, you’re saying that all I need to do is
replace the fw.jar file in the lib folder, that no further installation is
needed than what has already been done.  ?

 

René A Valencourt, CCP, MCTS
IS Dept.
CTB, Inc.
A Berkshire Hathaway Company

574.658.5208
574.658.8002 (FAX)

 

 

From: Robert Manning [mailto:rob...@gm...] 
Sent: Saturday, February 23, 2013 6:59 AM
To: RVa...@ct...
Subject: Re: [Squirrel-sql-users] what to do with fw.jar

 


The archive file "fw.jar" is a core library of "framework" classes used by
SQuirreL.  The SQuirreL installer places this file along with many other jar
files in the lib/ folder.  You shouldn't need to replace individual files in
the this directory manually, unless directed to do so by a developer.  The
installer and the software update feature will do this for you.  You appear
to have the latest stable version installed (3.4.0).  Are you looking for
information on how to install a snapshot version?

Rob

 

On Thu, Feb 21, 2013 at 9:47 AM, René A Valencourt <RVa...@ct...>
wrote:

I have found no instructions on what to do with fw.jar.

I have found it in the Squirrel-sql-3.4.0\lib directory.  Do I just replace
it, or is there an install process?

What exactly is the purpose of fw.jar?

Thanks,

René
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
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.
************************************************************

[Squirrel-sql-users] Objects List Sequence is Case Sensitive

[Colin G. <Col...@en...>]

Hello,

I've been using Squirrel SQL for about 6 months now to access Sybase databases and I'm generally very happy with it, but one aspect that
Bugs me is the sequence of table objects.

At our installation all of our DBs are case insensitive but the Squirrel SQL seems to adhere strictly to case sensitive, thus giving me
two completely separate lists to work with.

Is it possible to make the object lists case insensitive?

Regards
Colin Graham



***************************************************************************
Please consider the environment before printing this e-mail.

This email is confidential and is intended solely for the use of the individual to whom it is addressed. Any views or opinions expressed are solely those of the author and do not necessarily represent those 
of Enterprise. If you are not the intended recipient of this email, please inform the sender immediately and delete this email from your system. If that is the case, you must not use, copy or disclose any part
of this email for any purpose.

Warning: Although the company has taken reasonable precautions to ensure no viruses are present in this 
e-mail, the company cannot accept responsibility for any loss or damage arising from the use of this e-mail 
or its contents.

As internet connections are capable of data corruption no responsibility is accepted for changes made to this message after it was sent. For this reason it may be inappropriate to rely upon the contents without obtaining written confirmation. Enterprise PLC, registered in England at Lancaster House, Centurion Way, Leyland, Lancashire, PR26 6TX. Registered No 6134591. 
***************************************************************************

[Squirrel-sql-users] what to do with fw.jar

[René A V. <RVa...@ct...>]

I have found no instructions on what to do with fw.jar.

I have found it in the Squirrel-sql-3.4.0\lib directory.  Do I just replace
it, or is there an install process?

What exactly is the purpose of fw.jar?

Thanks,

René

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

Re: [Squirrel-sql-users] Change Font in Editor

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

On 20.02.2013 21:44, Gary Furash wrote:
> How do you change the font in the editor?
> Using: latest version on windows 7 w/ JDK 1.7.0_13
> A post from 2 years ago indicates that this was fixed, so I'm assuming
> this was user error.
See menu File --> New Session Properties --> Tab SQL --> Button Font

Gerd

[Squirrel-sql-users] Change Font in Editor

[Gary F. <fu...@al...>]

How do you change the font in the editor?

Using: latest version on windows 7 w/ JDK 1.7.0_13

A post from 2 years ago indicates that this was fixed, so I'm assuming this
was user error.

[Squirrel-sql-users] Font Display in Editor -- Still Not Working

[Furash, G. F - (furashg) <fu...@em...>]

I can't find anything in the GUI to let me change the editor font. I'm using the latest version on Windows. I searched the site but the only thing that I found was a 2-3 year old post which said that a fix had been put in. I'm sure this is user error.

Re: [Squirrel-sql-users] Driver installation (MS SQL Server)

[Danny G. <dan...@gm...>]

NOTE:When you hit send, your message goes out to everyone subscribed to the
mailing list.  And hopefully someone helps you out.
And when you have knowledge you pay it forward and help someone else out by
answering a question.
:)


You need a driver and alias setup in squirrel to connect to a database
using squirrel as a client.

For the driver, the zip file will contain a jar file.  It should be called
something like sqljdbc4.jar.

So, create a driver in squirrel (with the + sign) name it whatever you
like, your example url should be something like:
jdbc:sqlserver://<computer name where database
resides>;databaseName=<database name>
NOTE: don't include the < or >   the string above is for connecting to an
existing database, to create a new one it's a little different..
Now click the Extra Class Path tab and browse to the sqljdbc.jar you
unzipped.
That should populate the Class Name dropdown with
com.microsoft.sqlserver.jdbc.SQLServerDriver
Click ok
Now you should have a driver in the left hand side with a blue check mark
next to it.

Now you need the alias, (ie: the credentials to logon to an actual database)
So create an alias in squirrel (with the + sign) name it whatever you like,
pick the driver you just created from the dropdown,
the url should be populated with whatever you specified at the driver
level, so your good there.
enter a valid username and password for the database you are trying to
connect to and click test.
If successful, now you have an alias with a blue check mark, and can chose
that alias and connect whenever you want

Should be good to go from there.

On Tue, Feb 19, 2013 at 9:05 PM, Andrew Saldivar <and...@ya...>wrote:

> Hello all,
>
> Please pardon this intrusion, as I have no idea what's supposed to happen
> when I hit "send".  Hopefully someone will receive it and respond.
>
> I have installed the 3.4 software on Windows XP running in a virtual
> machine on a Win7 x64 machine.  Seems to run fine except I can't seem to
> figure out how to install a driver.  The only JDBC driver that is installed
> (by default) is the ODBC bridge.
>
> I'm running Java 7. 13, which shows up as Java 1.7 (I think), then I
> downloaded the Microsoft JDBC 4 driver for SQL Server, which doesn't
> actually install, it just unzips into a folder.
>
> There's no documentation or information on what to do next.  Whatever I've
> tried leads to repeaded class no found error messages.  Is there any hope
> for getting this to work as a sever novice?  I've tried looking at a number
> of messages on the users list, but it seems expert knowledge is required to
> even understand the lingo.
>
> If anyone can advise as to how to set this program up so it works, I would
> appreciate a response.
>
> Thank you,
>
> Andrew
>
>
> ------------------------------------------------------------------------------
> Everyone hates slow websites. So do we.
> Make your web apps faster with AppDynamics
> Download AppDynamics Lite for free today:
> http://p.sf.net/sfu/appdyn_d2d_feb
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>

[Squirrel-sql-users] Driver installation (MS SQL Server)

[Andrew S. <and...@ya...>]

Hello all,

Please pardon this intrusion, as I have no idea what's supposed to happen when I hit "send".  Hopefully someone will receive it and respond.

I have installed the 3.4 software on Windows XP running in a virtual machine on a Win7 x64 machine.  Seems to run fine except I can't seem to figure out how to install a driver.  The only JDBC driver that is installed (by default) is the ODBC bridge.  


I'm running Java 7. 13, which shows up as Java 1.7 (I think), then I downloaded the Microsoft JDBC 4 driver for SQL Server, which doesn't actually install, it just unzips into a folder.

There's no documentation or information on what to do next.  Whatever I've tried leads to repeaded class no found error messages.  Is there any hope for getting this to work as a sever novice?  I've tried looking at a number of messages on the users list, but it seems expert knowledge is required to even understand the lingo.

If anyone can advise as to how to set this program up so it works, I would appreciate a response.

Thank you,

Andrew

Re: [Squirrel-sql-users] extended error msgs when using DB2

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

Yes, that will definitely cause the problem you are seeing.  Nice catch!
Please file a bug report here so that we can update the plugin to accept
your driver name as well as the current one that it recognizes:

http://sourceforge.net/p/squirrel-sql/bugs/

Rob

On Sun, Feb 17, 2013 at 10:53 AM, Marcin Krol <mr...@gm...> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hello Robert,
>
> I think I know why extended db2 error. In DB2Plugin.sessionStarted there
> is this code:
>
> // Install DB2JCCExceptionFormatter iff we're using the JCC driver
> try
> {
>     if
>
> (JCC_DRIVER_NAME.equals(session.getMetaData().getJDBCMetaData().getDriverName()))
>     {
>         session.setExceptionFormatter(new DB2JCCExceptionFormatter());
>     }
>
>
> ..
> public static final String JCC_DRIVER_NAME = "IBM DB2 JDBC Universal
> Driver Architecture";
>
> When I run the test code on DB2 9.7 IBM-provided driver (db2jcc.jar,
> db2jcc_license_cu.jar), I get this name:
>
>
> DatabaseMetaData md = con.getMetaData();
> System.out.println("Driver name: " + md.getDriverName());
>
> output:
>
> Driver name: IBM Data Server Driver for JDBC and SQLJ
>
>
> In my experience, this driver works perfectly with SquirrelSQL 3.4,
> I've had no problem using it. I also am able to get extended error codes
> like this, pretty much copy from Squirrel (your?) code:
>
> Method getSqlca = t.getClass().getMethod("getSqlca", (Class[]) null);
> Object sqlca = getSqlca.invoke(t, (Object[]) null);
>
> // String msg = sqlca.getMessage();
> Method getMessage = sqlca.getClass().getMethod("getMessage", (Class[])
> null);
> String msg = getMessage.invoke(sqlca, (Object[]) null).toString();
>
> output:
>
> "DBO.TEST5" is an undefined name.. SQLCODE=-204, SQLSTATE=42704,
> DRIVER=4.13.127
> Exception in thread "main" java.lang.NullPointerException
>         at test.TestDB2.main(TestDB2.java:60)
>
>
>
> Robert Manning wrote:
> > If you have the DB2 plugin loaded, it will attempt get "human-readable"
> > messages using DB2-specific classes in the JDBC driver.  Check to see
> > that you have the DB2 plugin loaded (Plugins -> Summary -> Internal Name
> > == db2)
> >
> > Rob
> >
> > On Fri, Feb 15, 2013 at 7:43 AM, Marcin Krol <mr...@gm...
> > <mailto:mr...@gm...>> wrote:
> >
> > Hello everyone,
> >
> > I have specified "errors=full" in Driver properties tab in Alias
> > properties, but I still get only typical error code:
> >
> >
> > Error: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=OWNER,
> > DRIVER=4.13.127
> > SQLState:  42703
> > ErrorCode: -206
> >
> >
> > The same query when ran in db2 cmdline tool:
> >
> > db2 => select * from sysibm.systables  where owner = 'SAM'  and type
> > = 'T';
> > SQL0206N  "OWNER" is not valid in the context where it is used.
> > SQLSTATE=42703
> >
> >
> > Is there a way of getting a message accompanying error code in Squirrel?
> >
> >
> > Regards,
> > Marcin Krol
>
> -
>
> ------------------------------------------------------------------------------
> Free Next-Gen Firewall Hardware Offer
> Buy your Sophos next-gen firewall before the end March 2013
> and get the hardware for free! Learn more.
> http://p.sf.net/sfu/sophos-d2d-feb
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> <mailto:Squ...@li...>
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v2.0.14 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
>
> iQEcBAEBAgAGBQJRIP0CAAoJEFMgHzhQQ7hO6yMH/iJW6hkC+PdzOHHdoq2KFPgm
> pPDp7IOVMHrhxetjFmQJ5SYpOJYGrGZCAHwOXQyFYA7Yc6e58D7T3khCMQ4nF+HU
> 1qyMoto33q2rVbHXiaNZt0FodvcqHCH7rvfhypfw93YTFPlbTo4MWUUAMyKoSXWV
> Zym8cd6hXd7TAAwtCJwYPqOgVu3oYJY0yn6Ru3d9329uZxn+CkA6vo621vN4G/7i
> B9plKGR13bD0hiNUngGFLLRoS1ZVyJWAW3aY9X5unh4DIzMXONtdz5kw+4nd+vhs
> xOyUjcqdNjqk2KBPumGBUIViAuAA+GbvFJNnkSRShe5cPN8RmiSvtND8w7gFXfY=
> =HsDZ
> -----END PGP SIGNATURE-----
>

Re: [Squirrel-sql-users] extended error msgs when using DB2

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

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

Hello Robert,

I think I know why extended db2 error. In DB2Plugin.sessionStarted there
is this code:

// Install DB2JCCExceptionFormatter iff we're using the JCC driver
try
{
    if
(JCC_DRIVER_NAME.equals(session.getMetaData().getJDBCMetaData().getDriverName()))
    {
        session.setExceptionFormatter(new DB2JCCExceptionFormatter());
    }


..
public static final String JCC_DRIVER_NAME = "IBM DB2 JDBC Universal
Driver Architecture";

When I run the test code on DB2 9.7 IBM-provided driver (db2jcc.jar,
db2jcc_license_cu.jar), I get this name:


DatabaseMetaData md = con.getMetaData();
System.out.println("Driver name: " + md.getDriverName());

output:

Driver name: IBM Data Server Driver for JDBC and SQLJ


In my experience, this driver works perfectly with SquirrelSQL 3.4,
I've had no problem using it. I also am able to get extended error codes
like this, pretty much copy from Squirrel (your?) code:

Method getSqlca = t.getClass().getMethod("getSqlca", (Class[]) null);
Object sqlca = getSqlca.invoke(t, (Object[]) null);

// String msg = sqlca.getMessage();
Method getMessage = sqlca.getClass().getMethod("getMessage", (Class[])
null);
String msg = getMessage.invoke(sqlca, (Object[]) null).toString();

output:

"DBO.TEST5" is an undefined name.. SQLCODE=-204, SQLSTATE=42704,
DRIVER=4.13.127
Exception in thread "main" java.lang.NullPointerException
	at test.TestDB2.main(TestDB2.java:60)



Robert Manning wrote:
> If you have the DB2 plugin loaded, it will attempt get "human-readable"
> messages using DB2-specific classes in the JDBC driver.  Check to see
> that you have the DB2 plugin loaded (Plugins -> Summary -> Internal Name
> == db2)
> 
> Rob
> 
> On Fri, Feb 15, 2013 at 7:43 AM, Marcin Krol <mr...@gm...
> <mailto:mr...@gm...>> wrote:
> 
> Hello everyone,
> 
> I have specified "errors=full" in Driver properties tab in Alias
> properties, but I still get only typical error code:
> 
> 
> Error: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=OWNER,
> DRIVER=4.13.127
> SQLState:  42703
> ErrorCode: -206
> 
> 
> The same query when ran in db2 cmdline tool:
> 
> db2 => select * from sysibm.systables  where owner = 'SAM'  and type
> = 'T';
> SQL0206N  "OWNER" is not valid in the context where it is used.
> SQLSTATE=42703
> 
> 
> Is there a way of getting a message accompanying error code in Squirrel?
> 
> 
> Regards,
> Marcin Krol

-
------------------------------------------------------------------------------
Free Next-Gen Firewall Hardware Offer
Buy your Sophos next-gen firewall before the end March 2013
and get the hardware for free! Learn more.
http://p.sf.net/sfu/sophos-d2d-feb
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
<mailto:Squ...@li...>
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users


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

iQEcBAEBAgAGBQJRIP0CAAoJEFMgHzhQQ7hO6yMH/iJW6hkC+PdzOHHdoq2KFPgm
pPDp7IOVMHrhxetjFmQJ5SYpOJYGrGZCAHwOXQyFYA7Yc6e58D7T3khCMQ4nF+HU
1qyMoto33q2rVbHXiaNZt0FodvcqHCH7rvfhypfw93YTFPlbTo4MWUUAMyKoSXWV
Zym8cd6hXd7TAAwtCJwYPqOgVu3oYJY0yn6Ru3d9329uZxn+CkA6vo621vN4G/7i
B9plKGR13bD0hiNUngGFLLRoS1ZVyJWAW3aY9X5unh4DIzMXONtdz5kw+4nd+vhs
xOyUjcqdNjqk2KBPumGBUIViAuAA+GbvFJNnkSRShe5cPN8RmiSvtND8w7gFXfY=
=HsDZ
-----END PGP SIGNATURE-----

[Squirrel-sql-users] Hibernate classNotFound error

[Hiroto S. <hir...@gm...>]

Hello,

I've been using SQuirrelL for some time, but I'm now attempting to use
Hibernate support for the first time.

I did fresh install of 3.4 on a Linux system with clean
~/.squirrel-sql directory to avoid complication and I installed all
the plugins.

Then I created new Hibernate configuration, added classpath to the
classes directory of my web application, and then also chose to "Run
Hibernate in SQUirreL's Java VM".

But when I press the "Connect/Disconnect selected configuration", I
get the following exception and connection fails:

java.lang.ClassNotFoundException: org.hibernate.cfg.Configuration
        at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
        at net.sourceforge.squirrel_sql.plugins.hibernate.server.IntraVmConnectionFactory.createHibernateConnection(IntraVmConnectionFacto\
ry.java:42)
        at net.sourceforge.squirrel_sql.plugins.hibernate.server.ServerMainImpl.createHibernateServerConnection(ServerMainImpl.java:48)
............

On my installation, I do see lib/hibernate.jar which does contain
org.hibernate.cfg.Configuration class.

Looking at the startup part of the log, I do see this jar getting
included in the java.class.path, so I don't understand why it is not
being found.

I would appreciate your help.

                   Hiroto

p.s.  I also have SQuirreL on MacOS and it behaves the same.

Re: [Squirrel-sql-users] extended error msgs when using DB2

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

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


I do have it loaded, it is marked in column Load at startup as well.
Version 0.04.

Db2: 10.1 GA (no fixpacks), platform: win7 x64.

Thanks!


Robert Manning wrote:
> If you have the DB2 plugin loaded, it will attempt get "human-readable"
> messages using DB2-specific classes in the JDBC driver.  Check to see
> that you have the DB2 plugin loaded (Plugins -> Summary -> Internal Name
> == db2)
> 
> Rob
> 
> On Fri, Feb 15, 2013 at 7:43 AM, Marcin Krol <mr...@gm...
> <mailto:mr...@gm...>> wrote:
> 
> Hello everyone,
> 
> I have specified "errors=full" in Driver properties tab in Alias
> properties, but I still get only typical error code:
> 
> 
> Error: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=OWNER,
> DRIVER=4.13.127
> SQLState:  42703
> ErrorCode: -206
> 
> 
> The same query when ran in db2 cmdline tool:
> 
> db2 => select * from sysibm.systables  where owner = 'SAM'  and type
> = 'T';
> SQL0206N  "OWNER" is not valid in the context where it is used.
> SQLSTATE=42703
> 
> 
> Is there a way of getting a message accompanying error code in Squirrel?
> 
> 
> Regards,
> Marcin Krol

-
------------------------------------------------------------------------------
Free Next-Gen Firewall Hardware Offer
Buy your Sophos next-gen firewall before the end March 2013
and get the hardware for free! Learn more.
http://p.sf.net/sfu/sophos-d2d-feb
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
<mailto:Squ...@li...>
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users


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

iQEcBAEBAgAGBQJRH4JKAAoJEFMgHzhQQ7hO2x8H/Rnb8YWR4jw4IzQIcEY0lS1P
xT3c48dZFql0iuL4fKNPdYYhBJVBH9aBjFCt6aiSe1rXbJjRs+tAcH1FwdwjtuqG
R5Ylz4LdBVv0uFL6V1AWbUeNul9Y/AHIG6kAhfFjOYRhoBAK0G4eNxcYHE4CqeDJ
+G0OWiD7qJaMp1TaXDe6SrIL/czG5Brskx2w0f9IpHXgJRRp7ZdKobZws7nssh+J
vUDG46Oogiwc4Dcmi4BYvpn17L2JC9CFk23X/4BOz2fLptxo2LJXstBHqv585hRG
NOCMHKjQ10PDPs1rgmSmF5w7JqJ9ZnZXd1W67cJ6/th9o0ewWskw+eSA/pi9s1o=
=1uHH
-----END PGP SIGNATURE-----

Re: [Squirrel-sql-users] extended error msgs when using DB2

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

If you have the DB2 plugin loaded, it will attempt get "human-readable"
messages using DB2-specific classes in the JDBC driver.  Check to see that
you have the DB2 plugin loaded (Plugins -> Summary -> Internal Name == db2)

Rob

On Fri, Feb 15, 2013 at 7:43 AM, Marcin Krol <mr...@gm...> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hello everyone,
>
> I have specified "errors=full" in Driver properties tab in Alias
> properties, but I still get only typical error code:
>
>
> Error: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=OWNER,
> DRIVER=4.13.127
> SQLState:  42703
> ErrorCode: -206
>
>
> The same query when ran in db2 cmdline tool:
>
> db2 => select * from sysibm.systables  where owner = 'SAM'  and type = 'T';
> SQL0206N  "OWNER" is not valid in the context where it is used.
> SQLSTATE=42703
>
>
> Is there a way of getting a message accompanying error code in Squirrel?
>
>
> Regards,
> Marcin Krol
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v2.0.14 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
>
> iQEcBAEBAgAGBQJRHi1oAAoJEFMgHzhQQ7hO0S4H/jI5M0+mCqE8UGvaZsc6xnP2
> DgEhDejEt6RmhtfbwniuYU1pDafFC+2149meTA3DuUc6gZoEk7rTXHXail4PTRnM
> wYdHi8Vpoo/3l+gEGHM8WZJ2DajNSPw0zmBDp5AC4VMZbb0uvUi8NTprQ9foyJV3
> OEPtFu1IGK1k9Yzm2fE3iMC9tDKTNge0xkrXUwmKCWJQxMDDY4fep3lzlzRAgcVX
> EnkGq7LWpLd16p5L5uomtq0F/SsafXbmK/zs+2WpjW4G1RvmuQ+rT2Vs0v5gwafL
> rARiMbxShBg9fWvFXCKgf7Rdan61csKm4TOmq3Wu5AuFFVncQcxomFmnRn1x2Ds=
> =8B0M
> -----END PGP SIGNATURE-----
>
>
> ------------------------------------------------------------------------------
> Free Next-Gen Firewall Hardware Offer
> Buy your Sophos next-gen firewall before the end March 2013
> and get the hardware for free! Learn more.
> http://p.sf.net/sfu/sophos-d2d-feb
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

[Squirrel-sql-users] extended error msgs when using DB2

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

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

Hello everyone,

I have specified "errors=full" in Driver properties tab in Alias
properties, but I still get only typical error code:


Error: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=OWNER,
DRIVER=4.13.127
SQLState:  42703
ErrorCode: -206


The same query when ran in db2 cmdline tool:

db2 => select * from sysibm.systables  where owner = 'SAM'  and type = 'T';
SQL0206N  "OWNER" is not valid in the context where it is used.
SQLSTATE=42703


Is there a way of getting a message accompanying error code in Squirrel?


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

iQEcBAEBAgAGBQJRHi1oAAoJEFMgHzhQQ7hO0S4H/jI5M0+mCqE8UGvaZsc6xnP2
DgEhDejEt6RmhtfbwniuYU1pDafFC+2149meTA3DuUc6gZoEk7rTXHXail4PTRnM
wYdHi8Vpoo/3l+gEGHM8WZJ2DajNSPw0zmBDp5AC4VMZbb0uvUi8NTprQ9foyJV3
OEPtFu1IGK1k9Yzm2fE3iMC9tDKTNge0xkrXUwmKCWJQxMDDY4fep3lzlzRAgcVX
EnkGq7LWpLd16p5L5uomtq0F/SsafXbmK/zs+2WpjW4G1RvmuQ+rT2Vs0v5gwafL
rARiMbxShBg9fWvFXCKgf7Rdan61csKm4TOmq3Wu5AuFFVncQcxomFmnRn1x2Ds=
=8B0M
-----END PGP SIGNATURE-----

Re: [Squirrel-sql-users] Import data plugin

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

That good to hear!

Rob

On Wed, Feb 6, 2013 at 7:48 AM, Danny Gallagher
<dan...@gm...>wrote:

> Worked perfectly.  Thanks
>
>
> On Tue, Feb 5, 2013 at 7:56 AM, Robert Manning <rob...@gm...
> > wrote:
>
>>
>> I was able to duplicate the problem.  Its a bug.  A work-around is to use
>> the dataimport-assemply.zip instead.  The dataimport.jar (along with the
>> other plugin *.jar files) are there for backwards compatibility for a much
>> older SQuirreL.  We will be removing them soon.
>>
>> Rob
>>
>> On Mon, Feb 4, 2013 at 6:37 PM, Danny Gallagher <
>> dan...@gm...> wrote:
>>
>>> Using 3.4.0.
>>>
>>> Java 1.6.0_30
>>>
>>> I was trying to get the import plugin to run.
>>>
>>> I do Help software update --> Check --> Tells me most recent --> OK -->
>>> Update Summary -->
>>> Change dataimport.jar to INSTALL --> Apply Changes --> Tells me will be
>>> applied on restart --> OK
>>> Restart --> Updates are ready to be installed, Install them now? --> Yes
>>> --> copying dataimport.jar -->
>>> it's in the lib directory --> Connect to a derby database --> Objects
>>> tab --> seleect a table --> right click -->
>>> no import option of any kind in the context menu.  If a look at the
>>> Update Summary again data import is marked as
>>> Installed? no
>>>
>>> Am I missing something?  This would be unbelievably helpful to me right
>>> now.
>>>
>>> Thanks for any help.
>>>
>>> Danny
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Free Next-Gen Firewall Hardware Offer
>>> Buy your Sophos next-gen firewall before the end March 2013
>>> and get the hardware for free! Learn more.
>>> http://p.sf.net/sfu/sophos-d2d-feb
>>> _______________________________________________
>>> Squirrel-sql-users mailing list
>>> Squ...@li...
>>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>>>
>>>
>>
>

Re: [Squirrel-sql-users] Import data plugin

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

I was able to duplicate the problem.  Its a bug.  A work-around is to use
the dataimport-assemply.zip instead.  The dataimport.jar (along with the
other plugin *.jar files) are there for backwards compatibility for a much
older SQuirreL.  We will be removing them soon.

Rob

On Mon, Feb 4, 2013 at 6:37 PM, Danny Gallagher
<dan...@gm...>wrote:

> Using 3.4.0.
>
> Java 1.6.0_30
>
> I was trying to get the import plugin to run.
>
> I do Help software update --> Check --> Tells me most recent --> OK -->
> Update Summary -->
> Change dataimport.jar to INSTALL --> Apply Changes --> Tells me will be
> applied on restart --> OK
> Restart --> Updates are ready to be installed, Install them now? --> Yes
> --> copying dataimport.jar -->
> it's in the lib directory --> Connect to a derby database --> Objects tab
> --> seleect a table --> right click -->
> no import option of any kind in the context menu.  If a look at the Update
> Summary again data import is marked as
> Installed? no
>
> Am I missing something?  This would be unbelievably helpful to me right
> now.
>
> Thanks for any help.
>
> Danny
>
>
> ------------------------------------------------------------------------------
> Free Next-Gen Firewall Hardware Offer
> Buy your Sophos next-gen firewall before the end March 2013
> and get the hardware for free! Learn more.
> http://p.sf.net/sfu/sophos-d2d-feb
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>

[Squirrel-sql-users] Import data plugin

[Danny G. <dan...@gm...>]

Using 3.4.0.

Java 1.6.0_30

I was trying to get the import plugin to run.

I do Help software update --> Check --> Tells me most recent --> OK -->
Update Summary -->
Change dataimport.jar to INSTALL --> Apply Changes --> Tells me will be
applied on restart --> OK
Restart --> Updates are ready to be installed, Install them now? --> Yes
--> copying dataimport.jar -->
it's in the lib directory --> Connect to a derby database --> Objects tab
--> seleect a table --> right click -->
no import option of any kind in the context menu.  If a look at the Update
Summary again data import is marked as
Installed? no

Am I missing something?  This would be unbelievably helpful to me right now.

Thanks for any help.

Danny

Re: [Squirrel-sql-users] Double Quotation for Field names

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

On 31.01.2013 09:11, Meissner, Rene wrote:
> Hello Everybody,
>
> i use squirrelsql to connect to our progressSQL DB via ODBC Openedge
> 10.1C Driver.
>
> The Connection worked well and i can send selfscripted querys without
> problems.
>
> But i can’t create SQL-Strings with SQL-Query Graph  because the autom.
> created Scipt doesnt't contain the nessesary double quotation for field
> names.
>
> For example the “Graph SQL” brings the following sql string:
>
> select PUB.supp-id from PUB.adfc
>
> but this doesn't work, progress needs this verson:
>
> select distinct PUB."supp-id" from PUB.adfc
>
> Is there a setting to resolve this issue?
No, there is not. This is a bug. You may want to file it here:
https://sourceforge.net/p/squirrel-sql/bugs/

Sorry

Gerd

[Squirrel-sql-users] Double Quotation for Field names

[Meissner, R. <Ren...@ha...>]

Hello Everybody,
i use squirrelsql to connect to our progressSQL DB via ODBC Openedge 10.1C Driver.
The Connection worked well and i can send selfscripted querys without problems.
But i can't create SQL-Strings with SQL-Query Graph  because the autom. created Scipt doesnt't contain the nessesary double quotation for field names.
For example the "Graph SQL" brings the following sql string:
select PUB.supp-id from PUB.adfc

but this doesn't work, progress needs this verson:
select distinct PUB."supp-id" from PUB.adfc

Is there a setting to resolve this issue?
Thanks,
Rene

Re: [Squirrel-sql-users] New SQuirreL source code repository: GIT

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

Will do.

Rob

On Mon, Jan 28, 2013 at 6:21 PM, Gerd Wagner <ger...@t-...>wrote:

> Hi all,
>
> SQuirreL has a new SQuirreL source code repository: GIT
>
>
> To create a local clone of the repository use the command line:
>
> git clone git://git.code.sf.net/p/**squirrel-sql/git<http://git.code.sf.net/p/squirrel-sql/git>squirrel-sql-git
>
> or
>
> git clone http://git.code.sf.net/p/**squirrel-sql/git<http://git.code.sf.net/p/squirrel-sql/git>squirrel-sql-git
>
> Registered developers should use:
>
> git clone ssh://<SF user name>@git.code.sf.net/p/**squirrel-sql/git<http://git.code.sf.net/p/squirrel-sql/git>squirrel-sql-git
>
>
>
> Great thanks to Venkatram Akkineni for preparing the repository and for
> helping me to import it to SQuirreL.
>
>
> @Rob: It would be great if you could do the necessary changes of the build
> system. Thanks.
>
>
>
> Gerd
>

[Squirrel-sql-users] New SQuirreL source code repository: GIT

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

Hi all,

SQuirreL has a new SQuirreL source code repository: GIT


To create a local clone of the repository use the command line:

git clone git://git.code.sf.net/p/squirrel-sql/git squirrel-sql-git

or

git clone http://git.code.sf.net/p/squirrel-sql/git squirrel-sql-git

Registered developers should use:

git clone ssh://<SF user name>@git.code.sf.net/p/squirrel-sql/git 
squirrel-sql-git



Great thanks to Venkatram Akkineni for preparing the repository and for 
helping me to import it to SQuirreL.


@Rob: It would be great if you could do the necessary changes of the 
build system. Thanks.



Gerd

Re: [Squirrel-sql-users] MySql Schema load

[Oleg P. <rel...@gm...>]

Unfortunately, it doesn't work as well. I just tried to create 2 aliases
for each schema, then I connected to both and tried to write a cross-schema
SQL.
SquirrelSQL still doesn't provide code assist for non-current schema, and
tree doesn't have info for other schemas.


Regards,
Oleg

On Fri, Jan 25, 2013 at 1:36 AM, Alexandre Peshansky <
Ale...@ei...> wrote:

>  My solution is to create as many aliases as schemes you need to access,
> each for one schema.  Then I can run cross-schema queries by specifying
> alias (I actually use it for Sybase, but it should work for MySQL as well).
> --
>  Alexandre Peshansky, MS
> Senior Bioinformatics Analyst, Research Informatics Core (RIC)
> Einstein-Montefiore Institute for Clinical and Translational Research
> (ICTR)
> Albert Einstein College of Medicine
> 1300 Morris Park Ave, Mazer Bldg., Rm 534 Bronx, NY 10461
> (718) 430-2440 (Mo, We, Fr)  (718) 920-4885 (Tu & Th)
>
>    ------------------------------
> *From:* Oleg Poleshuk [rel...@gm...]
> *Sent:* Wednesday, January 23, 2013 11:31 AM
> *To:* Squ...@li...
> *Subject:* [Squirrel-sql-users] MySql Schema load
>
>  Hi,
>
>  I'm using SQuirreL SQL 3.4.0 to access my local MySql database.
> Connection is opened fine, but I have to manually specify active Schema if
> I want to see it's tables.
> It makes impossible to write requests for multiple schemas as SQuirreL SQL
> doesn't recognize tables from non-current schema.
>
>  Alias properties -> Schemas is set to Load all and cache all Schemas. If
> I set it to Specify schema loading and caching and click on "Connect
> database to refresh Schema table" nothing happens. I enabled debug logging
> but couldn't find anything useful in a log file.
>
> I'm using latest Mysql Connector 5.1.22.
>
>  Thanks in advance for your help!
>
>
>  Regards,
> Oleg
>
>
>
>
>
> ------------------------------------------------------------------------------
> Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
> MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
> with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
> MVPs and experts. ON SALE this month only -- learn more at:
> http://p.sf.net/sfu/learnnow-d2d
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>

Re: [Squirrel-sql-users] MySql Schema load

[Alexandre P. <Ale...@ei...>]

My solution is to create as many aliases as schemes you need to access, each for one schema.  Then I can run cross-schema queries by specifying alias (I actually use it for Sybase, but it should work for MySQL as well).
--
Alexandre Peshansky, MS
Senior Bioinformatics Analyst, Research Informatics Core (RIC)
Einstein-Montefiore Institute for Clinical and Translational Research (ICTR)
Albert Einstein College of Medicine
1300 Morris Park Ave, Mazer Bldg., Rm 534 Bronx, NY 10461
(718) 430-2440 (Mo, We, Fr)  (718) 920-4885 (Tu & Th)

________________________________
From: Oleg Poleshuk [rel...@gm...]
Sent: Wednesday, January 23, 2013 11:31 AM
To: Squ...@li...
Subject: [Squirrel-sql-users] MySql Schema load

Hi,

I'm using SQuirreL SQL 3.4.0 to access my local MySql database.
Connection is opened fine, but I have to manually specify active Schema if I want to see it's tables.
It makes impossible to write requests for multiple schemas as SQuirreL SQL doesn't recognize tables from non-current schema.

Alias properties -> Schemas is set to Load all and cache all Schemas. If I set it to Specify schema loading and caching and click on "Connect database to refresh Schema table" nothing happens. I enabled debug logging but couldn't find anything useful in a log file.

I'm using latest Mysql Connector 5.1.22.

Thanks in advance for your help!


Regards,
Oleg

Re: [Squirrel-sql-users] Oracle HDS-OID Connection String

[Drav S. <hol...@re...>]

Won Takemura wrote:
> 1.       Does SQuirreL work with OID?

That's really dependant on the jdbc driver, and not squirrel (as far
as I understand it)

> 
> 2.       Can I still use the thin driver or do I need to update?

You should be able to use the thin driver.

> 
> 3.       What would the connection string look like given the information above?

The OCI specification states the URL should be of the form:

jdbc:oracle:thin:@ldap://<OID server name>:<OID port>/<DB SID or Service Name>,cn=OracleContext,dc=<yourdomain>

So:

jdbc:oracle:thin:@ldap://hdsoid.ute.company.com:3060/dbname,cn=OracleContext,dc=ute,dc=company,dc=com

> 4.       Any other configuration files / environment variables needed?

I would imagine ORACLE_HOME, and possibly TNS_ADMIN

Regards

D.