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

[Squirrel-sql-users] Some data not updating

[<tri...@ya...>]

  Hi Squirrel-sql-users,


  I need to make a correction to my first post from a few days ago.

  I mentioned:

 "I had entered a lot of new data and Apache just did not see it.
 It was still reading the old data.

 How can I tell Squirrel to refresh the data?
 It looks like the directory is correct for the files."


 This is not correct.

 After looking more closely at the data all of it has been updated by
 Squirrel except for the most import part!
 My Product table.

 Any ideas  why this has happened and what I can try to get the table
 to update?

  Thanks very much!

    Mark

Re: [Squirrel-sql-users] (no subject)

[Alex M. <ale...@bl...>]

If you are looking for those vendor specific details you would be better off using SQLDeveloper for Oracle and IBM Data Studio for UDB. Both are free d/l.
I personally would not expect a generic SQL client like Squirrel to have support for 100% of each and every back end’s proprietory features.

Regards,
Alex

From: Sathesh S [mailto:Sat...@ho...]
Sent: Tuesday, November 22, 2016 11:29 AM
To: squ...@li...
Subject: [Squirrel-sql-users] (no subject)


Hello,

I tried using SQuirreL SQL for Oracle & UDB databases, I see some functionality are missing for both Oracle & UDB. Have anyone faced/observed similar issues and any workaround/fixes for the same.

Below are the issues which I see:

Oracle using ojdbc7 driver:

1.    It is not differentiating IOT or Partitioned tables visually.

2.    for IOT table is incorrect. Column level stats of the table are missing.

3.    Constraints are missing in Object navigator.

4.    Partitions and subpartition details are missing in Objects Navigator.

5.    Referential constraints or triggers are missing under tables.

6.    Do not see an option to generate AWR/ASH/SQL reports.



UDB using db2jcc4 driver:

1.    Does not show trigger

2.    Does not show Sequence

3.    Does not show Constraint

4.    Does not show Procedure text

5.    Not able to create procedures

6.    No option to cancel the running query

7.    No option for query explain plan



Any input will be helpful, thanks in advance.

Regards,
Sathesh

[Squirrel-sql-users] SQuirreL SQL for Oracle & UDB databases

[Sathesh S <Sat...@ho...>]

From: Sathesh S<mailto:Sat...@ho...>
Sent: Tuesday, November 22, 2016 9:59 PM
To: squ...@li...<mailto:squ...@li...>
Subject:


Hello,

I tried using SQuirreL SQL for Oracle & UDB databases, I see some functionality are missing for both Oracle & UDB. Have anyone faced/observed similar issues and any workaround/fixes for the same.

Below are the issues which I see:

Oracle using ojdbc7 driver:

1.    It is not differentiating IOT or Partitioned tables visually.

2.    for IOT table is incorrect. Column level stats of the table are missing.

3.    Constraints are missing in Object navigator.

4.    Partitions and subpartition details are missing in Objects Navigator.

5.    Referential constraints or triggers are missing under tables.

6.    Do not see an option to generate AWR/ASH/SQL reports.



UDB using db2jcc4 driver:

1.    Does not show trigger

2.    Does not show Sequence

3.    Does not show Constraint

4.    Does not show Procedure text

5.    Not able to create procedures

6.    No option to cancel the running query

7.    No option for query explain plan



Any input will be helpful, thanks in advance.

Regards,
Sathesh

[Squirrel-sql-users] (no subject)

[Sathesh S <Sat...@ho...>]

Hello,

I tried using SQuirreL SQL for Oracle & UDB databases, I see some functionality are missing for both Oracle & UDB. Have anyone faced/observed similar issues and any workaround/fixes for the same.

Below are the issues which I see:

Oracle using ojdbc7 driver:

1.    It is not differentiating IOT or Partitioned tables visually.

2.    for IOT table is incorrect. Column level stats of the table are missing.

3.    Constraints are missing in Object navigator.

4.    Partitions and subpartition details are missing in Objects Navigator.

5.    Referential constraints or triggers are missing under tables.

6.    Do not see an option to generate AWR/ASH/SQL reports.



UDB using db2jcc4 driver:

1.    Does not show trigger

2.    Does not show Sequence

3.    Does not show Constraint

4.    Does not show Procedure text

5.    Not able to create procedures

6.    No option to cancel the running query

7.    No option for query explain plan



Any input will be helpful, thanks in advance.

Regards,
Sathesh

[Squirrel-sql-users] Alias connection not updating

[<tri...@ya...>]

Hi Squirrel-sql-users,


 I was able to make a successful Alias connection a while back and get
 in to edit tables etc. of my Apache Derby Embedded files.

 Just this evening I wanted to get back in to edit some tables and the
 first thing I discovered was that Apache did not notice that my database
 had changed, new data entered into it.

 I had entered a lot of new data and Apache just did not see it.
 It was still reading the old data.

 How can I tell Squirrel to refresh the data?
 It looks like the directory is correct for the files.

  Thanks!

    Mark


-- 
All the best,
 Trio59-computing                          mailto:tri...@ya...

Re: [Squirrel-sql-users] SQUIRREL and postgresql

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

On Sat, 12 Nov 2016, Philippe Couas wrote:

> I have resolved problem good ip is 192.168.99.100 and not 172.17.0.x

That'd do it too. :)

Replying to the list so others know you've solved the problem.

> Regards
> Philippe
>
> 2016-11-11 19:10 GMT+01:00 John Hardin <jh...@im...>:
>
>> On Fri, 11 Nov 2016, Philippe Couas wrote:
>>
>> Currently i have SQUIRREL on my Computer and Postgres8.4 on remote HOST, my
>>> connection is refused, but if i install Postgres on my computer , i could
>>> connect to remote HOST with same parameters ?
>>> Why ?
>>>
>>
>> Was there a specific error message that stated a reason for not being able
>> to connect? Or was "connection refused" the error message?
>>
>> "connection refused" suggests that Squirrel is attempting to connect on a
>> TCP port that PGSQL is not listening on. What TCP port is your PGSQL
>> listening on? What TCP port (if any) was specified in your connect string
>> in Squirrel? Does explicitly specifying the TCP port number in the Squirrel
>> connect string allow you to connect successfully?

-- 
  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
-----------------------------------------------------------------------
   USMC Rules of Gunfighting #6: If you can choose what to bring to a
   gunfight, bring a long gun and a friend with a long gun.
-----------------------------------------------------------------------
  327 days since the first successful real return to launch site (SpaceX)

Re: [Squirrel-sql-users] SQUIRREL and postgresql

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

On Fri, 11 Nov 2016, Philippe Couas wrote:

> Currently i have SQUIRREL on my Computer and Postgres8.4 on remote HOST, my
> connection is refused, but if i install Postgres on my computer , i could
> connect to remote HOST with same parameters ?
> Why ?

Was there a specific error message that stated a reason for not being able 
to connect? Or was "connection refused" the error message?

"connection refused" suggests that Squirrel is attempting to connect on a 
TCP port that PGSQL is not listening on. What TCP port is your PGSQL 
listening on? What TCP port (if any) was specified in your connect string 
in Squirrel? Does explicitly specifying the TCP port number in the 
Squirrel connect string allow you to connect successfully?

-- 
  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
-----------------------------------------------------------------------
   From the Liberty perspective, it doesn't matter if it's a
   jackboot or a Birkenstock smashing your face.         -- Robb Allen
-----------------------------------------------------------------------
  Today: Veterans Day

[Squirrel-sql-users] SQUIRREL and postgresql

[Philippe C. <pc...@gm...>]

Hi
Currently i have SQUIRREL on my Computer and Postgres8.4 on remote HOST, my
connection is refused, but if i install Postgres on my computer , i could
connect to remote HOST with same parameters ?
Why ?

Regards

[Squirrel-sql-users] SQuirrel 3.7.1 won't open

[Colin C. <col...@gm...>]

Good day,

I've been using SQuirrel 3.7.1 for quite a while without issue. This
afternoon I Installed Ruby 2.3.1p112 (added to path) and Gem 2.6.8 to work
on a Jekyll-based project; now SQuirrel won't open. When I click the
executable, I get a brief Command Prompt window that is extinguished
immediately; moreover, there is no logfile. I'm running Windows 7 on a 64
bit machine. Wanted to check and see if this group had any ideas before I
uninstalled anything.

Many thanks,

Colin

Re: [Squirrel-sql-users] How to configure SquirrelSQL so than it can get connection to PostgreSQL through SSL

[<mr...@tu...>]

Gerd,

Finally, I managed to solve the problem.
It was because my environment variable "JAVA_HOME" was wrong (I installed Squirrel-SQL from squirrelsql-3.7.1-standard.ZIP).
The launch file "squirrel-sql.but" from this package uses this variable, hence the problem.

Now after I set the right JAVA_HOME variable everything works fine.
I should be more attentive, sorry.

Thank you for your time.

Mikhail.

07.11.2016, 23:20, "Gerd Wagner" <ger...@t-...>:
> Mikhail,
>
> the code you sent was just what I was asking for.
>
> Please try the following:
> - Select the SQuirreL Alias to your database.
> - In the Aliases toolbar click the 6th button from the right. The tool
> tip of that button is 'Edit properties of the selected Alias'.
> - In the dialog go the 'Driver properties' tab.
> - Check the 'Use driver properties' check box at the top
> - Check the 'Specify' column for the row with name 'ssl'
> - Enter true in the value column of the same row. (Note: the description
> of the current selected parameter is given at the bottom of the dialog)
>
> Hope this helps
>
> Gerd
>
> Am 06.11.2016 um 06:57 schrieb mr...@tu...:
>>  Gerd,
>>  firstly thank you for your answer.
>>
>>  To be honest I don't understand what you mean by saying "... what a plain JDBC connect to your database looks like". So I'm sending you a simple test application that successfully connects to the database server.
>>
>>  package test_pg_ssl;
>>  import java.sql.Connection;
>>  import java.sql.DriverManager;
>>  import java.sql.SQLException;
>>  import java.util.Properties;
>>
>>  public class TestPgSSL {
>>     public static void main(String[] args) {
>>        Connection conn = null;
>>        String url = "jdbc:postgresql://192.168.1.10/hospice_fr";
>>        Properties props = new Properties();
>>        props.setProperty("user","hospice");
>>        props.setProperty("password","************");
>>        props.setProperty("ssl","true");
>>        try {
>>           conn = DriverManager.getConnection(url,props);
>>        }
>>        catch (SQLException ex) {
>>           ex.printStackTrace();
>>       }
>>
>>        String stop = "Is connection established?";
>>     }
>>  }
>>  To simplify the task I ran the test_pg_ssl under debugger on the client and when getting the code line 'String stop = "Is connection established?"' I ran the 'ps' command on the server. I was able to see the connection is successfully established then:
>>  mikhail@debian16:~$ ps fax | grep hospice | grep -v grep
>>   1126 ? Ss 0:00 \_ postgres: hospice_fr hospice 192.168.1.101(59790) idle
>>  Note:
>>  192.168.1.101 is my client IP
>>  By the way. If I commented out a code line 'props.setProperty("ssl","true")' I got such an exception:
>>  org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "192.168.1.101", user "hospice", database "hospice_fr", SSL off
>>
>>  I also send you a client and a server configurations.
>>
>>  Here is a PostgreSQL database server configuration:
>>  mikhail@debian16:/etc/postgresql/9.4/main$ cat postgresql.conf | grep ssl
>>  ssl = true
>>  #ssl_ciphers = 'HIGH:MEDIUM:+3DES:!aNULL'
>>  #ssl_prefer_server_ciphers = on
>>  #ssl_ecdh_curve = 'prime256v1'
>>  #ssl_renegotiation_limit = 512MB
>>  ssl_cert_file = '/etc/ssl/certs/ssl-cert-snakeoil.pem'
>>  ssl_key_file = '/etc/ssl/private/ssl-cert-snakeoil.key'
>>  #ssl_ca_file = ''
>>  #ssl_crl_file = ''
>>  mikhail@debian16:/etc/postgresql/9.4/main$ cat pg_hba.conf | grep host
>>  hostssl hospice_fr hospice 192.168.1.10/32 md5
>>  hostssl hospice_fr hospice 192.168.1.101/32 md5
>>  hostssl hospice_fr hospice 192.168.1.102/32 md5
>>  hostssl hospice_fr hospice 192.168.1.202/32 md5
>>  host all all 127.0.0.1/32 md5
>>  host all all ::1/128 md5
>>  # Allow replication connections from localhost, by a user with the
>>  #host replication postgres 127.0.0.1/32 md5
>>  #host replication postgres ::1/128 md5
>>  Notes:
>>  192.168.1.10 - is a PostgreSQL database server IP
>>  192.168.1.101|102|... are client boxes IP
>>
>>  Here is a code fragment that successfully let my Java clients connect to the PostgreSQL database server:
>>  public class Data {
>>      public static Connection connACF = null;
>>      public static Connection connACT = null;
>>      [...]
>>      public static void initConn() throws SQLException {
>>          String url = "jdbc:postgresql://"+Conf.db_ip+"/"+Conf.DB_NAME;
>>          Properties props = new Properties();
>>          props.setProperty("user",Conf.DB_USER)
>>          props.setProperty("password","************");
>>          props.setProperty("ssl","true");
>>          props.setProperty("logUnclosedConnections","true");
>>          props.setProperty("socketTimeout",Conf.DB_TIMEOUT);
>>
>>          if (connACF!=null && !connACF.isClosed())
>>              connACF.close();
>>          connACF = DriverManager.getConnection(url,props);
>>          connACF.setAutoCommit(false);
>>          connACF.setTransactionIsolation(Connection.TRANSACTION_SERIALIZABLE);
>>
>>          if (connACT!=null && !connACT.isClosed())
>>              connACT.close();
>>          connACT = DriverManager.getConnection(url,props);
>>          connACT.setAutoCommit(true);
>>      }
>>      [...]
>>  }
>>  Notes:
>>  Conf.db_ip = '192.168.1.10'
>>  Conf.DB_NAME = 'hospice_fr'
>>  Conf.DB_USER = 'hospice'
>>  Conf.DB_TIMEOUT = 10
>>  The application uses two connection:
>>      one with autoCommit==true (when it needs to do one update during a transaction),
>>      the other with autoCommit==false (when it needs to do more than one updates during a transaction)
>>
>>  Thank you again, Mikhail.
>>
>>  05.11.2016, 13:03, "Gerd Wagner" <ger...@t-...>:
>>>  Could you please send a code example, what a plain JDBC connect to your
>>>  database looks like? It would be nice if you could do it outside your
>>>  application's project just to make sure the example doesn't profit from
>>>  any configurations you did for your application.
>>>
>>>  Thanks Gerd
>>>
>>>  Am 29.10.2016 um 09:13 schrieb mr...@tu...:
>>>>   I have got a Debian Jessie box with a PostgreSQL (9.4) database installed and configured to get SSL connection.
>>>>   On Windows 10 box I'm writing a Java (1.8.0_111) application that connects to the database through SSL using PostgreSQL-JDBC driver (9.4.1211).
>>>>   To let the application get a database certificate I did the following:
>>>>      on the Debian Jessy box:
>>>>         cp /etc/ssl/certs/ssl-cert-snakeoil.pem server.crt
>>>>         openssl x509 -in server.crt -out server.crt.der -outform der
>>>>      on the Windows 10 box:
>>>>         cd C:\Program Files (x86)\Java\jre1.8.0_111\lib\security
>>>>         keytool -keystore cacerts -alias postgresql -import -file server.crt.der
>>>>   My application successfully connects to the database through SSL.
>>>>
>>>>   Than (to get more opportunities for debugging the application) I try to get connection to the database from Squirrel SQL (3.7.1) with the following configuration:
>>>>   Squirrel SQL connection configuration:
>>>>      Alias: hospice32_fr
>>>>      Driver: PostgreSQL
>>>>      URL: jdbc:postgresql://192.168.1.10/hospice_fr
>>>>      User: hospice
>>>>      Password: ****************
>>>>   Squirrel SQL connection driver properties:
>>>>      ssl: <checked> true
>>>>      sslcert: <checked> C:\Program Files\Java\jre1.8.0_111\lib\security\cacerts
>>>>      all the rest options are unchecked
>>>>
>>>>   Connection failed with such an error message:
>>>>      java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.postgresql.util.PSQLException: SSL error: sun.security.validator.ValidatorException: PKIX path building failed:
>>>>      sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
>>>>      [...]
>>>>
>>>>   I also tried to replace the sslcert property with <SOME_DIR>/server.crt.der and <SOME_DIR>/server.crt, to check PGDBNAME, PGHOST, PGPORT,user properties.
>>>>   Result was the same: No connection.
>>>>
>>>>   Could anybody please help me to configure SquirrelSQL so than it can get connection to PostgreSQL through SSL.
>>>>
>>>>   Thank you, Mikhail.
>>>>
>>>>   ------------------------------------------------------------------------------
>>>>   The Command Line: Reinvented for Modern Developers
>>>>   Did the resurgence of CLI tooling catch you by surprise?
>>>>   Reconnect with the command line and become more productive.
>>>>   Learn the new .NET and ASP.NET CLI. Get your free copy!
>>>>   http://sdm.link/telerik
>>>>   _______________________________________________
>>>>   Squirrel-sql-users mailing list
>>>>   Squ...@li...
>>>>   https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>>
>>  ------------------------------------------------------------------------------
>>  Developer Access Program for Intel Xeon Phi Processors
>>  Access to Intel Xeon Phi processor-based developer platforms.
>>  With one year of Intel Parallel Studio XE.
>>  Training and support from Colfax.
>>  Order your platform today. http://sdm.link/xeonphi
>>  _______________________________________________
>>  Squirrel-sql-users mailing list
>>  Squ...@li...
>>  https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: [Squirrel-sql-users] How to configure SquirrelSQL so than it can get connection to PostgreSQL through SSL

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

Mikhail,

the code you sent was just what I was asking for.

Please try the following:
- Select the SQuirreL Alias to your database.
- In the Aliases toolbar click the 6th button from the right. The tool 
tip of that button is 'Edit properties of the selected Alias'.
- In the dialog go the 'Driver properties' tab.
- Check the 'Use driver properties' check box at the top
- Check the 'Specify' column for the row with name 'ssl'
- Enter true in the value column of the same row. (Note: the description 
of the current selected parameter is given at the bottom of the dialog)

Hope this helps

Gerd



Am 06.11.2016 um 06:57 schrieb mr...@tu...:
> Gerd,
> firstly thank you for your answer.
>
> To be honest I don't understand what you mean by saying "... what a plain JDBC connect to your database looks like". So I'm sending you a simple test application that successfully connects to the database server.
>
> package test_pg_ssl;
> import java.sql.Connection;
> import java.sql.DriverManager;
> import java.sql.SQLException;
> import java.util.Properties;
>
> public class TestPgSSL {
>    public static void main(String[] args) {
>       Connection conn = null;
>       String url = "jdbc:postgresql://192.168.1.10/hospice_fr";
>       Properties props = new Properties();
>       props.setProperty("user","hospice");
>       props.setProperty("password","************");
>       props.setProperty("ssl","true");
>       try {
>          conn = DriverManager.getConnection(url,props);
>       }
>       catch (SQLException ex) {
>          ex.printStackTrace();
>      }
>
>       String stop = "Is connection established?";
>    }
> }
> To simplify the task I ran the test_pg_ssl under debugger on the client and when getting the code line 'String stop = "Is connection established?"' I ran the 'ps' command on the server. I was able to see the connection is successfully established then:
> mikhail@debian16:~$ ps fax | grep hospice | grep -v grep
>  1126 ?        Ss     0:00  \_ postgres: hospice_fr hospice 192.168.1.101(59790) idle
> Note:
> 192.168.1.101 is my client IP
> By the way. If I commented out a code line 'props.setProperty("ssl","true")' I got such an exception:
> org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "192.168.1.101", user "hospice", database "hospice_fr", SSL off
>
>
> I also send you a client and a server configurations.
>
> Here is a PostgreSQL database server configuration:
> mikhail@debian16:/etc/postgresql/9.4/main$ cat postgresql.conf | grep ssl
> ssl = true
> #ssl_ciphers = 'HIGH:MEDIUM:+3DES:!aNULL'
> #ssl_prefer_server_ciphers = on
> #ssl_ecdh_curve = 'prime256v1'
> #ssl_renegotiation_limit = 512MB
> ssl_cert_file = '/etc/ssl/certs/ssl-cert-snakeoil.pem'
> ssl_key_file = '/etc/ssl/private/ssl-cert-snakeoil.key'
> #ssl_ca_file = ''
> #ssl_crl_file = ''
> mikhail@debian16:/etc/postgresql/9.4/main$ cat pg_hba.conf | grep host
> hostssl hospice_fr hospice 192.168.1.10/32  md5
> hostssl hospice_fr hospice 192.168.1.101/32 md5
> hostssl hospice_fr hospice 192.168.1.102/32 md5
> hostssl hospice_fr hospice 192.168.1.202/32 md5
> host all all 127.0.0.1/32 md5
> host all all ::1/128      md5
> # Allow replication connections from localhost, by a user with the
> #host replication postgres 127.0.0.1/32 md5
> #host replication postgres ::1/128      md5
> Notes:
> 192.168.1.10 - is a PostgreSQL database server IP
> 192.168.1.101|102|... are client boxes IP
>
> Here is a code fragment that successfully let my Java clients connect to the PostgreSQL database server:
> public class Data {
>     public static Connection connACF = null;
>     public static Connection connACT = null;
>     [...]
>     public static void initConn() throws SQLException {
>         String url = "jdbc:postgresql://"+Conf.db_ip+"/"+Conf.DB_NAME;
>         Properties props = new Properties();
>         props.setProperty("user",Conf.DB_USER)
>         props.setProperty("password","************");
>         props.setProperty("ssl","true");
>         props.setProperty("logUnclosedConnections","true");
>         props.setProperty("socketTimeout",Conf.DB_TIMEOUT);
>
>         if (connACF!=null && !connACF.isClosed())
>             connACF.close();
>         connACF = DriverManager.getConnection(url,props);
>         connACF.setAutoCommit(false);
>         connACF.setTransactionIsolation(Connection.TRANSACTION_SERIALIZABLE);
> 		
>         if (connACT!=null && !connACT.isClosed())
>             connACT.close();
>         connACT = DriverManager.getConnection(url,props);
>         connACT.setAutoCommit(true);
>     }
>     [...]
> }
> Notes:
> Conf.db_ip = '192.168.1.10'
> Conf.DB_NAME = 'hospice_fr'
> Conf.DB_USER = 'hospice'
> Conf.DB_TIMEOUT = 10
> The application uses two connection:
>     one with autoCommit==true (when it needs to do one update during a transaction),
>     the other with autoCommit==false (when it needs to do more than one updates during a transaction)
>
> Thank you again, Mikhail.
>
>
> 05.11.2016, 13:03, "Gerd Wagner" <ger...@t-...>:
>> Could you please send a code example, what a plain JDBC connect to your
>> database looks like? It would be nice if you could do it outside your
>> application's project just to make sure the example doesn't profit from
>> any configurations you did for your application.
>>
>> Thanks Gerd
>>
>> Am 29.10.2016 um 09:13 schrieb mr...@tu...:
>>>  I have got a Debian Jessie box with a PostgreSQL (9.4) database installed and configured to get SSL connection.
>>>  On Windows 10 box I'm writing a Java (1.8.0_111) application that connects to the database through SSL using PostgreSQL-JDBC driver (9.4.1211).
>>>  To let the application get a database certificate I did the following:
>>>     on the Debian Jessy box:
>>>        cp /etc/ssl/certs/ssl-cert-snakeoil.pem server.crt
>>>        openssl x509 -in server.crt -out server.crt.der -outform der
>>>     on the Windows 10 box:
>>>        cd C:\Program Files (x86)\Java\jre1.8.0_111\lib\security
>>>        keytool -keystore cacerts -alias postgresql -import -file server.crt.der
>>>  My application successfully connects to the database through SSL.
>>>
>>>  Than (to get more opportunities for debugging the application) I try to get connection to the database from Squirrel SQL (3.7.1) with the following configuration:
>>>  Squirrel SQL connection configuration:
>>>     Alias: hospice32_fr
>>>     Driver: PostgreSQL
>>>     URL: jdbc:postgresql://192.168.1.10/hospice_fr
>>>     User: hospice
>>>     Password: ****************
>>>  Squirrel SQL connection driver properties:
>>>     ssl: <checked> true
>>>     sslcert: <checked> C:\Program Files\Java\jre1.8.0_111\lib\security\cacerts
>>>     all the rest options are unchecked
>>>
>>>  Connection failed with such an error message:
>>>     java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.postgresql.util.PSQLException: SSL error: sun.security.validator.ValidatorException: PKIX path building failed:
>>>     sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
>>>     [...]
>>>
>>>  I also tried to replace the sslcert property with <SOME_DIR>/server.crt.der and <SOME_DIR>/server.crt, to check PGDBNAME, PGHOST, PGPORT,user properties.
>>>  Result was the same: No connection.
>>>
>>>  Could anybody please help me to configure SquirrelSQL so than it can get connection to PostgreSQL through SSL.
>>>
>>>  Thank you, Mikhail.
>>>
>>>  ------------------------------------------------------------------------------
>>>  The Command Line: Reinvented for Modern Developers
>>>  Did the resurgence of CLI tooling catch you by surprise?
>>>  Reconnect with the command line and become more productive.
>>>  Learn the new .NET and ASP.NET CLI. Get your free copy!
>>>  http://sdm.link/telerik
>>>  _______________________________________________
>>>  Squirrel-sql-users mailing list
>>>  Squ...@li...
>>>  https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
> ------------------------------------------------------------------------------
> Developer Access Program for Intel Xeon Phi Processors
> Access to Intel Xeon Phi processor-based developer platforms.
> With one year of Intel Parallel Studio XE.
> Training and support from Colfax.
> Order your platform today. http://sdm.link/xeonphi
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

Re: [Squirrel-sql-users] How to configure SquirrelSQL so than it can get connection to PostgreSQL through SSL

[<mr...@tu...>]

Gerd,
firstly thank you for your answer.

To be honest I don't understand what you mean by saying "... what a plain JDBC connect to your database looks like". So I'm sending you a simple test application that successfully connects to the database server.

package test_pg_ssl;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;

public class TestPgSSL {
   public static void main(String[] args) {
      Connection conn = null;
      String url = "jdbc:postgresql://192.168.1.10/hospice_fr";
      Properties props = new Properties();
      props.setProperty("user","hospice");
      props.setProperty("password","************");
      props.setProperty("ssl","true");
      try {
         conn = DriverManager.getConnection(url,props);
      }
      catch (SQLException ex) {
         ex.printStackTrace();
     }

      String stop = "Is connection established?";
   }
}
To simplify the task I ran the test_pg_ssl under debugger on the client and when getting the code line 'String stop = "Is connection established?"' I ran the 'ps' command on the server. I was able to see the connection is successfully established then:
mikhail@debian16:~$ ps fax | grep hospice | grep -v grep
 1126 ?        Ss     0:00  \_ postgres: hospice_fr hospice 192.168.1.101(59790) idle
Note:
192.168.1.101 is my client IP
By the way. If I commented out a code line 'props.setProperty("ssl","true")' I got such an exception:
org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "192.168.1.101", user "hospice", database "hospice_fr", SSL off


I also send you a client and a server configurations.

Here is a PostgreSQL database server configuration:
mikhail@debian16:/etc/postgresql/9.4/main$ cat postgresql.conf | grep ssl
ssl = true
#ssl_ciphers = 'HIGH:MEDIUM:+3DES:!aNULL'
#ssl_prefer_server_ciphers = on
#ssl_ecdh_curve = 'prime256v1'
#ssl_renegotiation_limit = 512MB
ssl_cert_file = '/etc/ssl/certs/ssl-cert-snakeoil.pem'
ssl_key_file = '/etc/ssl/private/ssl-cert-snakeoil.key'
#ssl_ca_file = ''
#ssl_crl_file = ''
mikhail@debian16:/etc/postgresql/9.4/main$ cat pg_hba.conf | grep host
hostssl hospice_fr hospice 192.168.1.10/32  md5
hostssl hospice_fr hospice 192.168.1.101/32 md5
hostssl hospice_fr hospice 192.168.1.102/32 md5
hostssl hospice_fr hospice 192.168.1.202/32 md5
host all all 127.0.0.1/32 md5
host all all ::1/128      md5
# Allow replication connections from localhost, by a user with the
#host replication postgres 127.0.0.1/32 md5
#host replication postgres ::1/128      md5
Notes:
192.168.1.10 - is a PostgreSQL database server IP
192.168.1.101|102|... are client boxes IP

Here is a code fragment that successfully let my Java clients connect to the PostgreSQL database server:
public class Data {
    public static Connection connACF = null;
    public static Connection connACT = null;
    [...]
    public static void initConn() throws SQLException {
        String url = "jdbc:postgresql://"+Conf.db_ip+"/"+Conf.DB_NAME;
        Properties props = new Properties();
        props.setProperty("user",Conf.DB_USER)
        props.setProperty("password","************");
        props.setProperty("ssl","true");
        props.setProperty("logUnclosedConnections","true");
        props.setProperty("socketTimeout",Conf.DB_TIMEOUT);

        if (connACF!=null && !connACF.isClosed())
            connACF.close();
        connACF = DriverManager.getConnection(url,props);
        connACF.setAutoCommit(false);
        connACF.setTransactionIsolation(Connection.TRANSACTION_SERIALIZABLE);
		
        if (connACT!=null && !connACT.isClosed())
            connACT.close();
        connACT = DriverManager.getConnection(url,props);
        connACT.setAutoCommit(true);
    }
    [...]
}
Notes:
Conf.db_ip = '192.168.1.10'
Conf.DB_NAME = 'hospice_fr'
Conf.DB_USER = 'hospice'
Conf.DB_TIMEOUT = 10
The application uses two connection:
    one with autoCommit==true (when it needs to do one update during a transaction),
    the other with autoCommit==false (when it needs to do more than one updates during a transaction)

Thank you again, Mikhail.


05.11.2016, 13:03, "Gerd Wagner" <ger...@t-...>:
> Could you please send a code example, what a plain JDBC connect to your
> database looks like? It would be nice if you could do it outside your
> application's project just to make sure the example doesn't profit from
> any configurations you did for your application.
>
> Thanks Gerd
>
> Am 29.10.2016 um 09:13 schrieb mr...@tu...:
>>  I have got a Debian Jessie box with a PostgreSQL (9.4) database installed and configured to get SSL connection.
>>  On Windows 10 box I'm writing a Java (1.8.0_111) application that connects to the database through SSL using PostgreSQL-JDBC driver (9.4.1211).
>>  To let the application get a database certificate I did the following:
>>     on the Debian Jessy box:
>>        cp /etc/ssl/certs/ssl-cert-snakeoil.pem server.crt
>>        openssl x509 -in server.crt -out server.crt.der -outform der
>>     on the Windows 10 box:
>>        cd C:\Program Files (x86)\Java\jre1.8.0_111\lib\security
>>        keytool -keystore cacerts -alias postgresql -import -file server.crt.der
>>  My application successfully connects to the database through SSL.
>>
>>  Than (to get more opportunities for debugging the application) I try to get connection to the database from Squirrel SQL (3.7.1) with the following configuration:
>>  Squirrel SQL connection configuration:
>>     Alias: hospice32_fr
>>     Driver: PostgreSQL
>>     URL: jdbc:postgresql://192.168.1.10/hospice_fr
>>     User: hospice
>>     Password: ****************
>>  Squirrel SQL connection driver properties:
>>     ssl: <checked> true
>>     sslcert: <checked> C:\Program Files\Java\jre1.8.0_111\lib\security\cacerts
>>     all the rest options are unchecked
>>
>>  Connection failed with such an error message:
>>     java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.postgresql.util.PSQLException: SSL error: sun.security.validator.ValidatorException: PKIX path building failed:
>>     sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
>>     [...]
>>
>>  I also tried to replace the sslcert property with <SOME_DIR>/server.crt.der and <SOME_DIR>/server.crt, to check PGDBNAME, PGHOST, PGPORT,user properties.
>>  Result was the same: No connection.
>>
>>  Could anybody please help me to configure SquirrelSQL so than it can get connection to PostgreSQL through SSL.
>>
>>  Thank you, Mikhail.
>>
>>  ------------------------------------------------------------------------------
>>  The Command Line: Reinvented for Modern Developers
>>  Did the resurgence of CLI tooling catch you by surprise?
>>  Reconnect with the command line and become more productive.
>>  Learn the new .NET and ASP.NET CLI. Get your free copy!
>>  http://sdm.link/telerik
>>  _______________________________________________
>>  Squirrel-sql-users mailing list
>>  Squ...@li...
>>  https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: [Squirrel-sql-users] How to configure SquirrelSQL so than it can get connection to PostgreSQL through SSL

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

Could you please send a code example, what a plain JDBC connect to your 
database looks like? It would be nice if you could do it outside your 
application's project just to make sure the example doesn't profit from 
any configurations you did for your application.

Thanks Gerd

Am 29.10.2016 um 09:13 schrieb mr...@tu...:
> I have got a Debian Jessie box with a PostgreSQL (9.4) database installed and configured to get SSL connection.
> On Windows 10 box I'm writing a Java (1.8.0_111) application that connects to the database through SSL using PostgreSQL-JDBC driver (9.4.1211).
> To let the application get a database certificate I did the following:
>    on the Debian Jessy box:
>       cp /etc/ssl/certs/ssl-cert-snakeoil.pem server.crt
>       openssl x509 -in server.crt -out server.crt.der -outform der
>    on the Windows 10 box:
>       cd C:\Program Files (x86)\Java\jre1.8.0_111\lib\security
>       keytool -keystore cacerts -alias postgresql -import -file server.crt.der
> My application successfully connects to the database through SSL.
>
> Than (to get more opportunities for debugging the application) I try to get connection to the database from Squirrel SQL (3.7.1) with the following configuration:
> Squirrel SQL connection configuration:
>    Alias:        hospice32_fr
>    Driver:      PostgreSQL
>    URL:	         jdbc:postgresql://192.168.1.10/hospice_fr
>    User:         hospice
>    Password: ****************
> Squirrel SQL connection driver properties:
>    ssl:    <checked>    true
>    sslcert: <checked> C:\Program Files\Java\jre1.8.0_111\lib\security\cacerts
>    all the rest options are unchecked
>
> Connection failed with such an error message:
>    java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.postgresql.util.PSQLException: SSL error: sun.security.validator.ValidatorException: PKIX path building failed:
>    sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
>    [...]
>
> I also tried to replace the sslcert property with <SOME_DIR>/server.crt.der and <SOME_DIR>/server.crt, to check PGDBNAME, PGHOST, PGPORT,user properties.
> Result was the same: No connection.
>
> Could anybody please help me to configure SquirrelSQL so than it can get connection to PostgreSQL through SSL.
>
> Thank you, Mikhail.
>
>
>
> ------------------------------------------------------------------------------
> The Command Line: Reinvented for Modern Developers
> Did the resurgence of CLI tooling catch you by surprise?
> Reconnect with the command line and become more productive.
> Learn the new .NET and ASP.NET CLI. Get your free copy!
> http://sdm.link/telerik
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

[Squirrel-sql-users] How to configure SquirrelSQL so than it can get connection to PostgreSQL through SSL

[<mr...@tu...>]

I have got a Debian Jessie box with a PostgreSQL (9.4) database installed and configured to get SSL connection.
On Windows 10 box I'm writing a Java (1.8.0_111) application that connects to the database through SSL using PostgreSQL-JDBC driver (9.4.1211).
To let the application get a database certificate I did the following:
   on the Debian Jessy box:
      cp /etc/ssl/certs/ssl-cert-snakeoil.pem server.crt
      openssl x509 -in server.crt -out server.crt.der -outform der
   on the Windows 10 box:
      cd C:\Program Files (x86)\Java\jre1.8.0_111\lib\security
      keytool -keystore cacerts -alias postgresql -import -file server.crt.der 
My application successfully connects to the database through SSL.

Than (to get more opportunities for debugging the application) I try to get connection to the database from Squirrel SQL (3.7.1) with the following configuration:
Squirrel SQL connection configuration:
   Alias:        hospice32_fr
   Driver:      PostgreSQL
   URL:	         jdbc:postgresql://192.168.1.10/hospice_fr
   User:         hospice
   Password: ****************
Squirrel SQL connection driver properties:
   ssl:    <checked>    true
   sslcert: <checked> C:\Program Files\Java\jre1.8.0_111\lib\security\cacerts
   all the rest options are unchecked

Connection failed with such an error message:
   java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.postgresql.util.PSQLException: SSL error: sun.security.validator.ValidatorException: PKIX path building failed:
   sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
   [...]

I also tried to replace the sslcert property with <SOME_DIR>/server.crt.der and <SOME_DIR>/server.crt, to check PGDBNAME, PGHOST, PGPORT,user properties.
Result was the same: No connection.

Could anybody please help me to configure SquirrelSQL so than it can get connection to PostgreSQL through SSL.

Thank you, Mikhail.

[Squirrel-sql-users] User/Role/Group information not displayed for Sybase ASE

[Sathesh S <Sat...@ho...>]

Dear All,

I’m using SQuirreL SQL with Sybase ASE, I could see the database names and other objects inside them.
But If want to perform some administration work like check the logins in the ASE or groups, I couldn’t see any option to list them. Is there any way to get the logins and other details.

Please advice.

Thanks,
Sathesh

Re: [Squirrel-sql-users] Unable to reconnect to Vertica

[Nester N. <nhe...@gm...>]

Hi Gerd,

Thanks for the update. I've installed the new snapshot and the reconnect
functionality is working again.

Thanks!
Michael.

On Tue, Oct 11, 2016 at 10:45 PM, Matt Ferreira <de...@ya...> wrote:

> I got the same problem as well(hadn't noticed as I rarely use vertica). I
> can test tomorrow if Michael hasn't by then
>
> > On Oct 11, 2016, at 4:11 PM, Gerd Wagner <ger...@t-...>
> wrote:
> >
> > Hi Michael,
> >
> > I just uploaded a new snapshot containing a fix. Since I wasn't able to
> > reproduce the problem it would be nice if you could try it out and let
> > me know if it worked.
> >
> > See:
> > https://sourceforge.net/projects/squirrel-sql/files/3-
> snapshots/snapshot-20161011_2203/
> >
> > Thanks
> > Gerd
> >
> >> Am 11.10.2016 um 14:49 schrieb Nester Neworchard:
> >> Hi,
> >>
> >> I've been using some 2-years old version for quite a time, but since I
> >> updated my Java recently it stopped to work. I've update it with the
> >> newest build, but now I'm no longer to reconnect to session with a
> >> Vertica DB. I get following error when selecting Session->Reconnect:
> >>
> >> Logged by net.sourceforge.squirrel_sql.client.Main at 10/11/16 2:29 PM:
> >>
> >> Exception occurred dispatching Event
> >> java.awt.event.MouseEvent[MOUSE_RELEASED,(370,399),
> absolute(-838,-517),button=1,modifiers=Button1,clickCount=1]
> >> on frame0
> >> java.lang.ClassCastException:
> >> net.sourceforge.squirrel_sql.fw.gui.SQLCatalogsComboBox$
> NoCatalogPlaceHolder
> >> cannot be cast to java.lang.String
> >> at
> >> net.sourceforge.squirrel_sql.client.gui.session.CatalogsPanel.
> getSelectedCatalog(CatalogsPanel.java:184)
> >> at
> >> net.sourceforge.squirrel_sql.client.gui.session.SessionPanel.
> getSelectedCatalogFromCatalogsComboBox(SessionPanel.java:513)
> >> at
> >> net.sourceforge.squirrel_sql.client.session.Session.
> reconnect(Session.java:561)
> >> at
> >> net.sourceforge.squirrel_sql.client.session.action.ReconnectAction.
> actionPerformed(ReconnectAction.java:67)
> >> at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
> >> ...
> >>
> >> When using Ctrl+Alt+T instead:
> >>
> >> Logged by net.sourceforge.squirrel_sql.client.Main at 10/11/16 2:47 PM:
> >> Exception occurred dispatching Event
> >> java.awt.event.KeyEvent[KEY_PRESSED,keyCode=84,keyText=T,
> keyChar=Undefined
> >> keyChar,modifiers=Ctrl+Alt,extModifiers=Ctrl+Alt,
> keyLocation=KEY_LOCATION_STANDARD,rawCode=84,primaryLevelUnicode=116,
> scancode=20,extendedKeyCode=0x54]
> >> on
> >> net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.
> SquirrelRSyntaxTextArea[,0,0,1138x347,layout=javax.swing.
> plaf.basic.BasicTextUI$UpdateHandler,alignmentX=0.0,
> alignmentY=0.0,border=javax.swing.plaf.basic.BasicBorders$
> MarginBorder@1b3404c,flags=16777576,maximumSize=,
> minimumSize=,preferredSize=,caretColor=javax.swing.plaf.
> ColorUIResource[r=0,g=0,b=0],disabledTextColor=javax.swing.
> plaf.ColorUIResource[r=167,g=166,b=170],editable=true,
> margin=javax.swing.plaf.InsetsUIResource[top=0,left=0,bottom=0,right=0],
> selectedTextColor=javax.swing.plaf.ColorUIResource[r=255,g=
> 255,b=255],selectionColor=java.awt.Color[r=200,g=200,b=
> 255],colums=0,columWidth=0,rows=0,rowHeight=16,word=true,wrap=false]
> >>
> >> java.lang.ClassCastException:
> >> net.sourceforge.squirrel_sql.fw.gui.SQLCatalogsComboBox$
> NoCatalogPlaceHolder
> >> cannot be cast to java.lang.String at
> >> net.sourceforge.squirrel_sql.client.gui.session.CatalogsPanel.
> getSelectedCatalog(CatalogsPanel.java:184)
> >> at
> >> net.sourceforge.squirrel_sql.client.gui.session.SessionPanel.
> getSelectedCatalogFromCatalogsComboBox(SessionPanel.java:513)
> >> at
> >> net.sourceforge.squirrel_sql.client.session.Session.
> reconnect(Session.java:561)
> >> at
> >> net.sourceforge.squirrel_sql.client.session.action.ReconnectAction.
> actionPerformed(ReconnectAction.java:67)
> >> at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
> >> ...
> >>
> >> Could that be caused by my configuration being imported from an old
> >> install? The connection otherwise works, I'm able to run queries and get
> >> results, so far only the Reconnect function makes troubles.
> >>
> >> Thanks,
> >> Michael
> >>
> >>
> >> ------------------------------------------------------------
> ------------------
> >> Check out the vibrant tech community on one of the world's most
> >> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> >>
> >>
> >>
> >> _______________________________________________
> >> Squirrel-sql-users mailing list
> >> Squ...@li...
> >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> >>
> >
> > ------------------------------------------------------------
> ------------------
> > Check out the vibrant tech community on one of the world's most
> > engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> > _______________________________________________
> > Squirrel-sql-users mailing list
> > Squ...@li...
> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>

Re: [Squirrel-sql-users] Unable to reconnect to Vertica

[Matt F. <de...@ya...>]

I got the same problem as well(hadn't noticed as I rarely use vertica). I can test tomorrow if Michael hasn't by then

> On Oct 11, 2016, at 4:11 PM, Gerd Wagner <ger...@t-...> wrote:
> 
> Hi Michael,
> 
> I just uploaded a new snapshot containing a fix. Since I wasn't able to 
> reproduce the problem it would be nice if you could try it out and let 
> me know if it worked.
> 
> See:
> https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20161011_2203/
> 
> Thanks
> Gerd
> 
>> Am 11.10.2016 um 14:49 schrieb Nester Neworchard:
>> Hi,
>> 
>> I've been using some 2-years old version for quite a time, but since I
>> updated my Java recently it stopped to work. I've update it with the
>> newest build, but now I'm no longer to reconnect to session with a
>> Vertica DB. I get following error when selecting Session->Reconnect:
>> 
>> Logged by net.sourceforge.squirrel_sql.client.Main at 10/11/16 2:29 PM:
>> 
>> Exception occurred dispatching Event
>> java.awt.event.MouseEvent[MOUSE_RELEASED,(370,399),absolute(-838,-517),button=1,modifiers=Button1,clickCount=1]
>> on frame0
>> java.lang.ClassCastException:
>> net.sourceforge.squirrel_sql.fw.gui.SQLCatalogsComboBox$NoCatalogPlaceHolder
>> cannot be cast to java.lang.String
>> at
>> net.sourceforge.squirrel_sql.client.gui.session.CatalogsPanel.getSelectedCatalog(CatalogsPanel.java:184)
>> at
>> net.sourceforge.squirrel_sql.client.gui.session.SessionPanel.getSelectedCatalogFromCatalogsComboBox(SessionPanel.java:513)
>> at
>> net.sourceforge.squirrel_sql.client.session.Session.reconnect(Session.java:561)
>> at
>> net.sourceforge.squirrel_sql.client.session.action.ReconnectAction.actionPerformed(ReconnectAction.java:67)
>> at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
>> ...
>> 
>> When using Ctrl+Alt+T instead:
>> 
>> Logged by net.sourceforge.squirrel_sql.client.Main at 10/11/16 2:47 PM:
>> Exception occurred dispatching Event
>> java.awt.event.KeyEvent[KEY_PRESSED,keyCode=84,keyText=T,keyChar=Undefined
>> keyChar,modifiers=Ctrl+Alt,extModifiers=Ctrl+Alt,keyLocation=KEY_LOCATION_STANDARD,rawCode=84,primaryLevelUnicode=116,scancode=20,extendedKeyCode=0x54]
>> on
>> net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelRSyntaxTextArea[,0,0,1138x347,layout=javax.swing.plaf.basic.BasicTextUI$UpdateHandler,alignmentX=0.0,alignmentY=0.0,border=javax.swing.plaf.basic.BasicBorders$MarginBorder@1b3404c,flags=16777576,maximumSize=,minimumSize=,preferredSize=,caretColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],disabledTextColor=javax.swing.plaf.ColorUIResource[r=167,g=166,b=170],editable=true,margin=javax.swing.plaf.InsetsUIResource[top=0,left=0,bottom=0,right=0],selectedTextColor=javax.swing.plaf.ColorUIResource[r=255,g=255,b=255],selectionColor=java.awt.Color[r=200,g=200,b=255],colums=0,columWidth=0,rows=0,rowHeight=16,word=true,wrap=false]
>> 
>> java.lang.ClassCastException:
>> net.sourceforge.squirrel_sql.fw.gui.SQLCatalogsComboBox$NoCatalogPlaceHolder
>> cannot be cast to java.lang.String at
>> net.sourceforge.squirrel_sql.client.gui.session.CatalogsPanel.getSelectedCatalog(CatalogsPanel.java:184)
>> at
>> net.sourceforge.squirrel_sql.client.gui.session.SessionPanel.getSelectedCatalogFromCatalogsComboBox(SessionPanel.java:513)
>> at
>> net.sourceforge.squirrel_sql.client.session.Session.reconnect(Session.java:561)
>> at
>> net.sourceforge.squirrel_sql.client.session.action.ReconnectAction.actionPerformed(ReconnectAction.java:67)
>> at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
>> ...
>> 
>> Could that be caused by my configuration being imported from an old
>> install? The connection otherwise works, I'm able to run queries and get
>> results, so far only the Reconnect function makes troubles.
>> 
>> Thanks,
>> Michael
>> 
>> 
>> ------------------------------------------------------------------------------
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
>> 
>> 
>> 
>> _______________________________________________
>> Squirrel-sql-users mailing list
>> Squ...@li...
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>> 
> 
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most 
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: [Squirrel-sql-users] Squirrel-sql-users Digest, Vol 120, Issue 1

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

Am 11.10.2016 um 22:02 schrieb Francesco:
> Hello,
>
> I have posted this questoin on StackOverflow:
>
> https://stackoverflow.com/questions/39684080/how-import-adventureworks-to-squirrel-sql
>
> Apparently there is no answer, you cannot import MS SQL in SQUirrel.
>
Import these (.mdf + .ldf) files into your MSSQL database server. For 
information how to do that please consult your MSSQL documentation.

When that is done you may connect the database server using SQuirreL. To 
do so you need a suitable JDBC driver.

Gerd

Re: [Squirrel-sql-users] Unable to reconnect to Vertica

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

Hi Michael,

I just uploaded a new snapshot containing a fix. Since I wasn't able to 
reproduce the problem it would be nice if you could try it out and let 
me know if it worked.

See:
https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20161011_2203/

Thanks
Gerd

Am 11.10.2016 um 14:49 schrieb Nester Neworchard:
> Hi,
>
> I've been using some 2-years old version for quite a time, but since I
> updated my Java recently it stopped to work. I've update it with the
> newest build, but now I'm no longer to reconnect to session with a
> Vertica DB. I get following error when selecting Session->Reconnect:
>
> Logged by net.sourceforge.squirrel_sql.client.Main at 10/11/16 2:29 PM:
>
>  Exception occurred dispatching Event
> java.awt.event.MouseEvent[MOUSE_RELEASED,(370,399),absolute(-838,-517),button=1,modifiers=Button1,clickCount=1]
> on frame0
> java.lang.ClassCastException:
> net.sourceforge.squirrel_sql.fw.gui.SQLCatalogsComboBox$NoCatalogPlaceHolder
> cannot be cast to java.lang.String
> at
> net.sourceforge.squirrel_sql.client.gui.session.CatalogsPanel.getSelectedCatalog(CatalogsPanel.java:184)
> at
> net.sourceforge.squirrel_sql.client.gui.session.SessionPanel.getSelectedCatalogFromCatalogsComboBox(SessionPanel.java:513)
> at
> net.sourceforge.squirrel_sql.client.session.Session.reconnect(Session.java:561)
> at
> net.sourceforge.squirrel_sql.client.session.action.ReconnectAction.actionPerformed(ReconnectAction.java:67)
> at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
> ...
>
> When using Ctrl+Alt+T instead:
>
> Logged by net.sourceforge.squirrel_sql.client.Main at 10/11/16 2:47 PM:
> Exception occurred dispatching Event
> java.awt.event.KeyEvent[KEY_PRESSED,keyCode=84,keyText=T,keyChar=Undefined
> keyChar,modifiers=Ctrl+Alt,extModifiers=Ctrl+Alt,keyLocation=KEY_LOCATION_STANDARD,rawCode=84,primaryLevelUnicode=116,scancode=20,extendedKeyCode=0x54]
> on
> net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelRSyntaxTextArea[,0,0,1138x347,layout=javax.swing.plaf.basic.BasicTextUI$UpdateHandler,alignmentX=0.0,alignmentY=0.0,border=javax.swing.plaf.basic.BasicBorders$MarginBorder@1b3404c,flags=16777576,maximumSize=,minimumSize=,preferredSize=,caretColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],disabledTextColor=javax.swing.plaf.ColorUIResource[r=167,g=166,b=170],editable=true,margin=javax.swing.plaf.InsetsUIResource[top=0,left=0,bottom=0,right=0],selectedTextColor=javax.swing.plaf.ColorUIResource[r=255,g=255,b=255],selectionColor=java.awt.Color[r=200,g=200,b=255],colums=0,columWidth=0,rows=0,rowHeight=16,word=true,wrap=false]
>
> java.lang.ClassCastException:
> net.sourceforge.squirrel_sql.fw.gui.SQLCatalogsComboBox$NoCatalogPlaceHolder
> cannot be cast to java.lang.String at
> net.sourceforge.squirrel_sql.client.gui.session.CatalogsPanel.getSelectedCatalog(CatalogsPanel.java:184)
> at
> net.sourceforge.squirrel_sql.client.gui.session.SessionPanel.getSelectedCatalogFromCatalogsComboBox(SessionPanel.java:513)
> at
> net.sourceforge.squirrel_sql.client.session.Session.reconnect(Session.java:561)
> at
> net.sourceforge.squirrel_sql.client.session.action.ReconnectAction.actionPerformed(ReconnectAction.java:67)
> at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
> ...
>
> Could that be caused by my configuration being imported from an old
> install? The connection otherwise works, I'm able to run queries and get
> results, so far only the Reconnect function makes troubles.
>
> Thanks,
> Michael
>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
>
>
>
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

Re: [Squirrel-sql-users] Squirrel-sql-users Digest, Vol 120, Issue 1

[Francesco <in...@je...>]

Hello,

I have posted this questoin on StackOverflow:

https://stackoverflow.com/questions/39684080/how-import-adventureworks-to-squirrel-sql

Apparently there is no answer, you cannot import MS SQL in SQUirrel.

Thank you,

Francesco

Il 12/10/2016 01:50, squ...@li... ha 
scritto:
> Send Squirrel-sql-users mailing list submissions to
> 	squ...@li...
>
> To subscribe or unsubscribe via the World Wide Web, visit
> 	https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> or, via email, send a message with subject or body 'help' to
> 	squ...@li...
>
> You can reach the person managing the list at
> 	squ...@li...
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Squirrel-sql-users digest..."
>
>
> Today's Topics:
>
>     1. unsusbscribe please (Hern?n Laborde)
>     2. Re: "java printing" prints a blank page (Federico Bruni)
>     3. Re: Not able to generate DDL for Greenplum	database. (Sathesh S)
>     4. Unable to reconnect to Vertica (Nester Neworchard)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 27 Sep 2016 08:01:21 -0500
> From: Hern?n Laborde <her...@gm...>
> Subject: [Squirrel-sql-users] unsusbscribe please
> To: Squ...@li...
> Message-ID:
> 	<CAMETcCZzXQbPSZ=v8wWam+dk5OO3PvJ0NV-T=CgA...@ma...>
> Content-Type: text/plain; charset="utf-8"
>

[Squirrel-sql-users] Unable to reconnect to Vertica

[Nester N. <nhe...@gm...>]

Hi,

I've been using some 2-years old version for quite a time, but since I
updated my Java recently it stopped to work. I've update it with the newest
build, but now I'm no longer to reconnect to session with a Vertica DB. I
get following error when selecting Session->Reconnect:

Logged by net.sourceforge.squirrel_sql.client.Main at 10/11/16 2:29 PM:

 Exception occurred dispatching Event
java.awt.event.MouseEvent[MOUSE_RELEASED,(370,399),absolute(-838,-517),button=1,modifiers=Button1,clickCount=1]
on frame0
java.lang.ClassCastException:
net.sourceforge.squirrel_sql.fw.gui.SQLCatalogsComboBox$NoCatalogPlaceHolder
cannot be cast to java.lang.String
at
net.sourceforge.squirrel_sql.client.gui.session.CatalogsPanel.getSelectedCatalog(CatalogsPanel.java:184)
at
net.sourceforge.squirrel_sql.client.gui.session.SessionPanel.getSelectedCatalogFromCatalogsComboBox(SessionPanel.java:513)
at
net.sourceforge.squirrel_sql.client.session.Session.reconnect(Session.java:561)
at
net.sourceforge.squirrel_sql.client.session.action.ReconnectAction.actionPerformed(ReconnectAction.java:67)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
...

When using Ctrl+Alt+T instead:

Logged by net.sourceforge.squirrel_sql.client.Main at 10/11/16 2:47 PM:
Exception occurred dispatching Event
java.awt.event.KeyEvent[KEY_PRESSED,keyCode=84,keyText=T,keyChar=Undefined
keyChar,modifiers=Ctrl+Alt,extModifiers=Ctrl+Alt,keyLocation=KEY_LOCATION_STANDARD,rawCode=84,primaryLevelUnicode=116,scancode=20,extendedKeyCode=0x54]
on
net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelRSyntaxTextArea[,0,0,1138x347,layout=javax.swing.plaf.basic.BasicTextUI$UpdateHandler,alignmentX=0.0,alignmentY=0.0,border=javax.swing.plaf.basic.BasicBorders$MarginBorder@1b3404c
,flags=16777576,maximumSize=,minimumSize=,preferredSize=,caretColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],disabledTextColor=javax.swing.plaf.ColorUIResource[r=167,g=166,b=170],editable=true,margin=javax.swing.plaf.InsetsUIResource[top=0,left=0,bottom=0,right=0],selectedTextColor=javax.swing.plaf.ColorUIResource[r=255,g=255,b=255],selectionColor=java.awt.Color[r=200,g=200,b=255],colums=0,columWidth=0,rows=0,rowHeight=16,word=true,wrap=false]

java.lang.ClassCastException:
net.sourceforge.squirrel_sql.fw.gui.SQLCatalogsComboBox$NoCatalogPlaceHolder
cannot be cast to java.lang.String at
net.sourceforge.squirrel_sql.client.gui.session.CatalogsPanel.getSelectedCatalog(CatalogsPanel.java:184)
at
net.sourceforge.squirrel_sql.client.gui.session.SessionPanel.getSelectedCatalogFromCatalogsComboBox(SessionPanel.java:513)
at
net.sourceforge.squirrel_sql.client.session.Session.reconnect(Session.java:561)
at
net.sourceforge.squirrel_sql.client.session.action.ReconnectAction.actionPerformed(ReconnectAction.java:67)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
...

Could that be caused by my configuration being imported from an old
install? The connection otherwise works, I'm able to run queries and get
results, so far only the Reconnect function makes troubles.

Thanks,
Michael

Re: [Squirrel-sql-users] Not able to generate DDL for Greenplum database.

[Sathesh S <Sat...@ho...>]

Hello All,


Can someone please help with this.

One more issue, the application is not showing the sequences and roles/logins in the Greenplum server.


Is there any fix or workaround for these issues.


Thanks & regards,
Sathesh Sundaram,

________________________________
From: Sathesh S <sat...@ho...>
Sent: 19 September 2016 21:30
To: squ...@li...
Subject: Not able to generate DDL for Greenplum database.


Hello,

I'm not able to generate DDL for Greenplum database,  the right click menu is not opening at all.

I use progress data direct JDBC driver.  And I have "SQL Scripts" plugin enabled and loaded.

Can someone help to fix this issue.

Thanks,
Sathesh

Re: [Squirrel-sql-users] "java printing" prints a blank page

[Federico B. <fed...@gm...>]

It turned out to be simply a problem of columns widths.
My bad that I didn't think of it, but Squirrel might have been more verbose
about this problem.
I've added my thoughts here:
https://sourceforge.net/p/squirrel-sql/feature-requests/534/#4445

What developers think about it?
Probably a print preview would avoid a new user to have the same problem I
had?
 (e.g. in Libreoffice the print preview is a key feature)

Thanks
Federico

2016-02-22 18:45 GMT+01:00 Federico Bruni <fed...@gm...>:

> 2016-02-22 18:38 GMT+01:00 Federico Bruni <fed...@gm...>:
>
>> It seems that this is a random bug.
>> Now it's not working even when SQL results are set to Editable table.
>>
>> I have no clue about how to debug this. I'll open a new issue in the
>> tracker hoping to get some feedback from developers.
>
>
> https://sourceforge.net/p/squirrel-sql/feature-requests/534/
>

[Squirrel-sql-users] unsusbscribe please

[Hernán L. <her...@gm...>]

-- 
*H*

Re: [Squirrel-sql-users] New to Squirrel

[Federico B. <fed...@gm...>]

In the past I tried downloading the drivers from IBM website and it was a
nightmare, a Kafka experience.

Thomas, in case you have the same trouble I had, you should find some
drivers if you download RazorSQL:
http://razorsql.com/

2016-09-20 21:54 GMT+02:00 Erwan Duroselle <erw...@gm...>:

> Hi Thomas,
> Database JDBC drivers are not provided with SquirreL, as they are usually
> not free software.
> You have to get the DB2 LUW driver from IBM's website, and install it in
> SquirreL.
> The SQuirreL help file (About/Help) will tell you how to access the driver
> from SQuirreL.
>
> Erwan
>
> 2016-09-20 20:04 GMT+02:00 Koczon, Thomas J <Tho...@vo...>:
>
>> Hi,
>>
>> I have just downloaded and installed the product.  I am trying to connect
>> to a db2 (luw) database but I do not see it in the Drivers list after I
>> installed.  I did check  off db2 (also Oracle,MS Sql server and Sybase)
>> when I installed the product but I do not see any with a check mark when I
>> run the product.
>>
>>
>>
>> Wondering if someone can help me to connect to db2 luw?
>>
>>
>>
>> thanks
>>
>>
>>
>> Thomas Koczon
>> Voya Financial ®
>>
>> Analytics and Data Management – Application Database Administration
>>
>> One Orange Way, A2N
>> Windsor, CT 06095-4774
>>
>> Phone:  860 580 1483
>> eMail:  tho...@vo...
>>
>>
>>
>>
>>
>> ---------------------------------------------------------
>>
>> NOTICE: The information contained in this electronic mail message is
>> confidential and intended only for certain recipients.  If you are not an
>> intended recipient, you are hereby notified that any disclosure,
>> reproduction, distribution or other use of this communication and any
>> attachments is strictly prohibited.  If you have received this
>> communication in error, please notify the sender by reply transmission and
>> delete the message without copying or disclosing it.
>>
>> ============================================================
>> ================================
>>
>> ------------------------------------------------------------
>> ------------------
>>
>> _______________________________________________
>> Squirrel-sql-users mailing list
>> Squ...@li...
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>>
>>
>
> ------------------------------------------------------------
> ------------------
>
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>