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

Re: [Squirrel-sql-users] Export CSV-No numeric commas

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

Am 16.08.22 um 17:05 schrieb Justin Taylor:
> When I export results to a CSV, it includes commas in numeric values 
> (i.e. thousands separators).  How do I turn those off?
> 
> TIA

Near the bottom of the export dialog select "Use formatting as 
configured in Global Prefs ..."

To configure the numeric type formatting in Global Prefs go to menu File 
--> Global Preferences --> tab Data Type Controls --> section "FLOAT 
REAL DOUBLE NUMERIC ..."

Gerd

[Squirrel-sql-users] possible bug mysql jconnector mysql

[crystal <ice...@pr...>]

Hi all-

It seems that in the same session (i hit new sql tab) even after i click autocommit off it seems to save the update before it is committed.

I am also wondering if that is part of the reason why when i run this query that only one transaction id shows:

SELECT tx.trx_id
FROM information_schema.innodb_trx txWHERE tx.trx_mysql_thread_id = connection_id()

please check it out and let me know when you have a chance.

THANKS

Sent with [Proton Mail](https://proton.me/) secure email.

[Squirrel-sql-users] Export CSV-No numeric commas

[Justin T. <JU...@lo...>]

When I export results to a CSV, it includes commas in numeric values (i.e. thousands separators).  How do I turn those off?

TIA

Re: [Squirrel-sql-users] SQuirreL SQL will not start.

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

SQuirreL 4.4.0 requires Java 11 or higher. The Java version you are 
trying to use is Java 1.8.0_321.

Free and open source current Java versions can be downloaded here:
https://adoptium.net/

Gerd

Am 15.04.22 um 16:42 schrieb Ray Marsh:
> Good morning everyone. I hope someone can help me.
> 
> I have installed SQuirreL SQL in my root directory because it would not 
> in Program Files. I tried a couple of things but ended up putting it in 
> the root, which should be fine. That's just background information in 
> case it is relevant.
> 
> When I try to start the application I get this error message. I have the 
> latest Java version and no older versions are installed on my Win10 PC.
> 
> How do I address this issue?
> 
> image.png
> 
> Thank you very much.
> 
> Raymond Marsh
> e: rma...@gm... <mailto:rma...@gm...>
> 
> 
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Squirrel-sql-users] SQuirreL SQL will not start.

[Ray M. <rma...@gm...>]

Good morning everyone. I hope someone can help me.

I have installed SQuirreL SQL in my root directory because it would not in
Program Files. I tried a couple of things but ended up putting it in the
root, which should be fine. That's just background information in case it
is relevant.

When I try to start the application I get this error message. I have the
latest Java version and no older versions are installed on my Win10 PC.

How do I address this issue?

[image: image.png]

Thank you very much.

Raymond Marsh
e: rma...@gm...

Re: [Squirrel-sql-users] Mac install

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

Am 18.03.22 um 17:21 schrieb Ira Fuchs:
> I am new to Squirrel SQL. I downloaded the latest snapshot for the Mac and after starting it, I get the message from the Java Version Checker thatMy JVM must be 11->17 and that I am using 1.8.0_321 (via the Java launcher).
> How do I get this working?
> 

On my Mac it worked the following way:


Go to https://adoptium.net/releases.html and download either the
MacOS x64 JDK tar.gz file
or the
macOS aarch64 JDK tar.gz file
depending on your Mac's architecture. As your installed Java version is 
1.8 it probably is MacOS x64.

Unpack the JDK tar.gz file in some directory of your choice.

Download your preferred MacOS version of SQuirreL.

Open a command line terminal in the director of your SQuirreL download 
and execute:
<yourJDKUnpackDir>/Contents/Home/bin/java -jar 
./squirrel-sql-<yourSquirreLVersion>-MACOSX-install.jar

This will start SQuirreL's MacOS-Installer.

After SQuirreL is installed you have to tell it to use your downloaded 
Java JDK. To do so edit the file
<yourSquirrelInstallDir>/Contents/MacOS/squirrel-sql.sh

After the comment at the beginning of the file add the line
export JAVA_HOME=<YourJDKUnpackDir>/Contents/Home

Now SQuirreL should start with your downloaded JDK.

[Squirrel-sql-users] Mac install

[Ira F. <ira...@gm...>]

I am new to Squirrel SQL. I downloaded the latest snapshot for the Mac and after starting it, I get the message from the Java Version Checker thatMy JVM must be 11->17 and that I am using 1.8.0_321 (via the Java launcher). 
How do I get this working?

Re: [Squirrel-sql-users] log4j and Squirrel-SQL older versions prior to 4.3

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

Sorry, but the only  SQuirreL versions without Log4J dependency are 
snapshot 20220222_1929 or higher. The latest snapshot is available here:
https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/


As SQuirreL is open source you may well try to check out the source code 
of the "4.2.0 release" commit which was about the last Java 8 compatible 
version and the patch the changes which removed Log4J back to this 
version. If you do so your are only obliged to make your changes open 
source available. Your could do so for example by dropping a patch here:
https://sourceforge.net/p/squirrel-sql/patches/

Gerd

Am 03.03.22 um 06:35 schrieb stu...@fu...:
> Hi,
> 
> We have been using Squirrel SQL in our development environment with Java 
> 8 and our own DB Driver.jar for accessing a BLOB ; works perfectly – 
> thank you.
> 
> However because of the recent log4j vulnerabilities also impacting 
> versions 1.* of log4j we have been told to stop using squirrel
> 
> We have attempt to try squirrel 4.3 but because of its requirement 
> requiring java 11 or above, we cannot go to this version.
> 
> We have even tried the following
> 
> https://logging.apache.org/log4j/2.x/manual/migration.html#:~:text=You%20may%20be%20able%20to,2's%20log4j%2D1.2%2Dapi 
> <https://logging.apache.org/log4j/2.x/manual/migration.html#:~:text=You%20may%20be%20able%20to,2's%20log4j%2D1.2%2Dapi> 
> 
> 
> i.e. with version 4.1.0 we removed log4j.jar from the lib directory, and 
> added in
> 
> log4j-1.2-api-2.17.2.jar
> 
> log4j-api-2.17.2.jar
> 
> log4j-core-2.17.2.jar
> 
> and added the system property to your log4j.properties as follows:-
> 
> log4j1.compatibility=true
> 
> however Squirrel 4.1.0 fails to launch and we still have the same problem.
> 
> 
> We really need version 4.1.0 to work with java 8 and to have this log4j 
> vulnerability patched or removed please?
> 
> Is there any suggestions or workarounds you can suggest?
> 
> Will version 4.1.0 be patched to fix the log4j vulnerability?
> 
> Really sorry to ask this.
> 
> Thank you for your help.
> 
> Stu Slater
> 
> Unless otherwise stated, this email has been sent from Fujitsu Services 
> Limited (registered in England No 96056); Fujitsu EMEA PLC (registered 
> in England No 2216100) both with registered offices at: 22 Baker Street, 
> London W1U 3BW; PFU (EMEA) Limited, (registered in England No 1578652) 
> registered offices at: Belmont, Belmont Road, Uxbridge, England, UB8 1HE 
> and Fujitsu Research of Europe Ltd (registered in England No. 4153469) 
> 4th Floor, Building 3, Hyde Park Hayes, 11 Millington Road, Hayes, UB3 4AZ.
> 
> This email is only for the use of its intended recipient. Its contents 
> are subject to a duty of confidence and may be privileged. Fujitsu does 
> not guarantee that this email has not been intercepted and amended or 
> that it is virus-free.
> 
> 
> 
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: [Squirrel-sql-users] log4j and Squirrel-SQL older versions prior to 4.3

[<stu...@fu...>]

Further to my post below and many thanks to max...@he...<mailto:max...@he...>

Unfortunately going to an open JDK of java does not help us; since Java 11 is incompatible with our DB Driver we are using, i.e. we have written our own FIBDBDriver.jar which allows squirrel-sql to interface to our BLOB and query various views and data within this BLOB.  This however FIBDBDriver.jar is only compatible with java 8, 7 etc.. .it is not compatible with java 11 or above as when I try and connect I get errors. – sorry I should of said this in my original post.

We have tried this with Open JDK 11.0.8+10 for Windows.

Sorry for not including this information in the original post.


From: Slater, Stuart
Sent: Thursday, March 3, 2022 5:36 AM
To: squ...@li...
Subject: log4j and Squirrel-SQL older versions prior to 4.3
Importance: High

Hi,

We have been using Squirrel SQL in our development environment with Java 8 and our own DB Driver.jar for accessing a BLOB ; works perfectly – thank you.
However because of the recent log4j vulnerabilities also impacting versions 1.* of log4j we have been told to stop using squirrel
We have attempt to try squirrel 4.3 but because of its requirement requiring java 11 or above, we cannot go to this version.
We have even tried the following
https://logging.apache.org/log4j/2.x/manual/migration.html#:~:text=You%20may%20be%20able%20to,2's%20log4j%2D1.2%2Dapi
i.e. with version 4.1.0 we removed log4j.jar from the lib directory, and added in
log4j-1.2-api-2.17.2.jar
log4j-api-2.17.2.jar
log4j-core-2.17.2.jar
and added the system property to your log4j.properties as follows:-
log4j1.compatibility=true
however Squirrel 4.1.0 fails to launch and we still have the same problem.

We really need version 4.1.0 to work with java 8 and to have this log4j vulnerability patched or removed please?

Is there any suggestions or workarounds you can suggest?
Will version 4.1.0 be patched to fix the log4j vulnerability?

Really sorry to ask this.

Thank you for your help.
Stu Slater

Unless otherwise stated, this email has been sent from Fujitsu Services Limited (registered in England No 96056); Fujitsu EMEA PLC (registered in England No 2216100) both with registered offices at: 22 Baker Street, London W1U 3BW; PFU (EMEA) Limited, (registered in England No 1578652) registered offices at: Belmont, Belmont Road, Uxbridge, England, UB8 1HE and Fujitsu Research of Europe Ltd (registered in England No. 4153469) 4th Floor, Building 3, Hyde Park Hayes, 11 Millington Road, Hayes, UB3 4AZ.

This email is only for the use of its intended recipient. Its contents are subject to a duty of confidence and may be privileged. Fujitsu does not guarantee that this email has not been intercepted and amended or that it is virus-free.

[Squirrel-sql-users] log4j and Squirrel-SQL older versions prior to 4.3

[<stu...@fu...>]

Hi,

We have been using Squirrel SQL in our development environment with Java 8 and our own DB Driver.jar for accessing a BLOB ; works perfectly - thank you.
However because of the recent log4j vulnerabilities also impacting versions 1.* of log4j we have been told to stop using squirrel
We have attempt to try squirrel 4.3 but because of its requirement requiring java 11 or above, we cannot go to this version.
We have even tried the following
https://logging.apache.org/log4j/2.x/manual/migration.html#:~:text=You%20may%20be%20able%20to,2's%20log4j%2D1.2%2Dapi
i.e. with version 4.1.0 we removed log4j.jar from the lib directory, and added in
log4j-1.2-api-2.17.2.jar
log4j-api-2.17.2.jar
log4j-core-2.17.2.jar
and added the system property to your log4j.properties as follows:-
log4j1.compatibility=true
however Squirrel 4.1.0 fails to launch and we still have the same problem.

We really need version 4.1.0 to work with java 8 and to have this log4j vulnerability patched or removed please?

Is there any suggestions or workarounds you can suggest?
Will version 4.1.0 be patched to fix the log4j vulnerability?

Really sorry to ask this.

Thank you for your help.
Stu Slater

Unless otherwise stated, this email has been sent from Fujitsu Services Limited (registered in England No 96056); Fujitsu EMEA PLC (registered in England No 2216100) both with registered offices at: 22 Baker Street, London W1U 3BW; PFU (EMEA) Limited, (registered in England No 1578652) registered offices at: Belmont, Belmont Road, Uxbridge, England, UB8 1HE and Fujitsu Research of Europe Ltd (registered in England No. 4153469) 4th Floor, Building 3, Hyde Park Hayes, 11 Millington Road, Hayes, UB3 4AZ.

This email is only for the use of its intended recipient. Its contents are subject to a duty of confidence and may be privileged. Fujitsu does not guarantee that this email has not been intercepted and amended or that it is virus-free.

Re: [Squirrel-sql-users] Opensource_SquirrelSQLClient_4.2.0

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

Recently all SQuirreL dropped all Log4j dependencies. Accordingly only 
recent snapshots contain this change, for example
https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20220222_1929/

Unfortunately neither for version 4.2.0 nor for any other version 
existing today there will be any patch releases.


https://adoptium.net/releases.html provides current Java versions that 
don't require installation but just unzipping. Perhaps that's an option.

Gerd



Am 23.02.22 um 22:08 schrieb Manyam, Hema "Sekhar":
> Hi,
> 
> We are trying to use Opensource_SquirrelSQLClient_4.2.0 for connecting 
> to database. This is the first time we are going to install the client 
> software at our company. There are several log4j files packaged with the 
> product.
> 
> Log4j issue was reported during November 2021, the log4j file inside 
> package were created during May 2021.
> 
> We cannot install v4.3 as it needs Java SE v11 as prereq. We have JRE 
> v1.8 at our company so we can only install v4.2.0.
> 
> Please let me know whether log4j related issues were resolved in v4.2.0.
> 
> Thanks,
> 
> *Sekhar*
> 
> DTCC DISCLAIMER: This email and any files transmitted with it are 
> confidential and intended solely for the use of the individual or entity 
> to whom they are addressed. If you have received this email in error, 
> please notify us immediately and delete the email and any attachments 
> from your system. The recipient should check this email and any 
> attachments for the presence of viruses. The company accepts no 
> liability for any damage caused by any virus transmitted by this email. 
> Message content created by DTCC is automatically secured using Transport 
> Layer Security (TLS) encryption and will be encrypted and sent through a 
> secure transmission connection if the recipient's system is configured 
> to support TLS on the incoming email gateway. If there is no TLS 
> configured or the encryption certificate is invalid on the recipient's 
> system, the email communication will be sent through an unencrypted 
> channel. Organizations communicating with DTCC should be using TLS v1.2 
> or newer to ensure continuation of encrypted communications. DTCC will 
> not be responsible for any disclosure of private information or any 
> related security incident resulting from an organization's inability to 
> receive secure electronic communications through the current version of 
> TLS.
> 
> 
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Squirrel-sql-users] Opensource_SquirrelSQLClient_4.2.0

[Manyam, H. \Sekhar\ <hm...@dt...>]

Hi,
We are trying to use Opensource_SquirrelSQLClient_4.2.0 for connecting to database. This is the first time we are going to install the client software at our company. There are several log4j files packaged with the product.

Log4j issue was reported during November 2021, the log4j file inside package were created during May 2021.
We cannot install v4.3 as it needs Java SE v11 as prereq. We have JRE v1.8 at our company so we can only install v4.2.0.
Please let me know whether log4j related issues were resolved in v4.2.0.
[cid:image001.jpg@01D828C7.2EE78F40]

Thanks,
Sekhar
DTCC DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify us immediately and delete the email and any attachments from your system. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. Message content created by DTCC is automatically secured using Transport Layer Security (TLS) encryption and will be encrypted and sent through a secure transmission connection if the recipient's system is configured to support TLS on the incoming email gateway. If there is no TLS configured or the encryption certificate is invalid on the recipient's system, the email communication will be sent through an unencrypted channel. Organizations communicating with DTCC should be using TLS v1.2 or newer to ensure continuation of encrypted communications. DTCC will not be responsible for any disclosure of private information or any related security incident resulting from an organization's inability to receive secure electronic communications through the current version of TLS.

Re: [Squirrel-sql-users] timestamp escape with sql2ins command

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

Am 17.02.22 um 18:11 schrieb Kevin Dziulko via Squirrel-sql-users:
> Under Global Preferences -> Data Type Controls, I have the following 
> option enabled:
>     () Use String version of Timestamp ('2022-02-17 11:56:16.449')
> 
> Then when I run a SELECT statement that involves a timestamp column, and 
> do a ctrl+t and use the sql2ins command, the generated INSERT statement 
> contains the "{ts }".
> 
> Is this a bug?  How do I make the generated INSERT statement NOT contain 
> the "{ts }"?
> 

As the UI says this option is used for internally generated WHERE 
clauses only.

I just committed a change that should meet your needs. Excerpt from 
change log:
Scripting of the data types TIMESTAMP, DATE, TIME can now be chosen to 
use the standard JDBC format, e.g. {ts '2022-02-20 22:41:47'}, or a 
string version, e.g. '2022-02-20 22:41:47'. The format can be chosen at 
menu File --> Global Preferences --> tab Data Type Controls --> sections 
Timestamp, Date, Time --> Panels titled "For script generation"

I'm just uploading a new snapshot with the feature. See
https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20220220_2301/

Gerd

[Squirrel-sql-users] timestamp escape with sql2ins command

[Kevin D. <dzi...@ya...>]

Under Global Preferences -> Data Type Controls, I have the following option enabled:
   () Use String version of Timestamp ('2022-02-17 11:56:16.449')

Then when I run a SELECT statement that involves a timestamp column, and do a ctrl+t and use the sql2ins command, the generated INSERT statement contains the "{ts }".

Is this a bug?  How do I make the generated INSERT statement NOT contain the "{ts }"?

Re: [Squirrel-sql-users] Log4j 2?

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

Am 05.01.22 um 23:23 schrieb Dmitriy Volodin - IDM-C via Squirrel-sql-users:
> Are there any plans to migrate to Log4j 2 (2.17.1 at least)?
> 
> Thanks!
> 

P.S.: I forgot to mention the link to our change log:
http://sourceforge.net/p/squirrel-sql/git/ci/master/tree/sql12/core/doc/changes.txt

Re: [Squirrel-sql-users] Log4j 2?

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

Am 05.01.22 um 23:23 schrieb Dmitriy Volodin - IDM-C via Squirrel-sql-users:
> Are there any plans to migrate to Log4j 2 (2.17.1 at least)?
> 
> Thanks!
> 

I have not decided on this, yet. I already know it requires some more 
work than just updating the libraries. If someone would send me a patch 
I'd promise sympathetically consider it.
I'm also thinking about getting rid of Log4j at all. I assume it 
wouldn't be to hard to implement the logging functionality SQuirreL 
needs myself. Of course a patch of that kind would be considered 
friendly as well.

As to the vulnerabilities of Log4J that came known lately: I think 
SQuirreL already dealt with these responsibly. Please see the two recent 
change log entries starting with
"On Log4j vulnerability CVE-2021-44228 (log4shell) concerning Log4j2 
versions from 2.0-beta9 to 2.14.1 ..."
and with
"Fixed Log4j vulnerability CVE-2021-4104 concerning Log4j version 1.*"

Also note that SQuirreL is a standalone application which does not offer 
to be connected to from outside. Essentially the only remote component 
that may cause SQuirreL to write logs is the databases you use SQuirreL 
to connect to.

Gerd

[Squirrel-sql-users] Log4j 2?

[Dmitriy V. - IDM-C <dmi...@gs...>]

Are there any plans to migrate to Log4j 2 (2.17.1 at least)?

Thanks!

Re: [Squirrel-sql-users] Squirrel 4.3.0 : help where download Java 11

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

See
https://adoptium.net/

You may either use the preselected "Temurin 17 (LTS)" which is Java 17 
or "Temurin 11 (LTS)" which is Java 11 and the minimum supported version 
of SQuirreL 4.3.0.

Gerd

Am 27.11.21 um 17:51 schrieb Massimo Re:
> Hi guys
> 
> Java 11 or higher is required for Squirrel 4.3.0 version.
> 
> If i search on web, i can find JDK 11 ...
> Is this correct version ?
> It contains also JRE or not ?
> 
> Someone can post a correct link where download Java 11 version ?
> 
> Is possibile to insert this link in official squirrel download page to 
> avoid searching and download a wrong version ?
> 
> Thank you
> 
> Max
> 
> 
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 

[Squirrel-sql-users] Squirrel 4.3.0 : help where download Java 11

[Massimo Re <max...@gm...>]

Hi guys

Java 11 or higher is required for Squirrel 4.3.0 version.

If i search on web, i can find JDK 11 ...
Is this correct version ?
It contains also JRE or not ?

Someone can post a correct link where download Java 11 version ?

Is possibile to insert this link in official squirrel download page to
avoid searching and download a wrong version ?

Thank you

Max

Re: [Squirrel-sql-users] Deploy on macOS

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

When you use SQuirreL's MAC OS installer the last of the dialogs allows 
to save an installer script. To silently repeat the installation execute 
the following command:

java -jar squirrel-sql-<YourSquirrelVersion>-MACOSX-install.jar 
<pathToInstallerScript>


Gerd

Am 16.07.21 um 20:34 schrieb Olsen, Jason E:
> Is there an option to silently deploy this out to users on macOS using 
> an MDM like Jamf?
> 
> I packaged and deployed it to /private/var/tmp, and then I attempted to 
> silently install it with a command line like:
> 
> java -DINSTALL_PATH=/Applications -jar 
> /private/var/tmp/squirrel-sql-4.2.0-MACOSX-install.jar -options-system
> 
> However I'm getting this error:
> - ERROR -
> java.io.FileNotFoundException: -options-system (No such file or directory)
> java.io.FileNotFoundException: -options-system (No such file or directory)
> at java.base/java.io.FileInputStream.open0(Native Method)
> at java.base/java.io.FileInputStream.open(FileInputStream.java:211)
> at java.base/java.io.FileInputStream.<init>(FileInputStream.java:153)
> at com.izforge.izpack.installer.AutomatedInstaller.getXMLData(Unknown 
> Source)
> at com.izforge.izpack.installer.AutomatedInstaller.<init>(Unknown Source)
> at com.izforge.izpack.installer.Installer.main(Unknown Source)
> 
> Thanks
> 
> 
> 
> Please be aware that if you reply directly to this particular message, 
> your reply may not be secure. Do not use email to send us communications 
> that contain unencrypted confidential information such as passwords, 
> account numbers or Social Security numbers. If you must provide this 
> type of information, please visit comerica.com to submit a secure form 
> using any of the ”Contact Us” forms. In addition, you should not send 
> via email any inquiry or request that may be time sensitive. The 
> information in this e-mail is confidential. It is intended for the 
> individual or entity to whom it is addressed. If you have received this 
> email in error, please destroy or delete the message and advise the 
> sender of the error by return email.
> 
> 
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 

[Squirrel-sql-users] Deploy on macOS

[Olsen, J. E <je...@co...>]

Is there an option to silently deploy this out to users on macOS using an MDM like Jamf?

I packaged and deployed it to /private/var/tmp, and then I attempted to silently install it with a command line like:
java -DINSTALL_PATH=/Applications -jar /private/var/tmp/squirrel-sql-4.2.0-MACOSX-install.jar -options-system

However I'm getting this error:
- ERROR -
java.io.FileNotFoundException: -options-system (No such file or directory)
java.io.FileNotFoundException: -options-system (No such file or directory)
at java.base/java.io.FileInputStream.open0(Native Method)
at java.base/java.io.FileInputStream.open(FileInputStream.java:211)
at java.base/java.io.FileInputStream.<init>(FileInputStream.java:153)
at com.izforge.izpack.installer.AutomatedInstaller.getXMLData(Unknown Source)
at com.izforge.izpack.installer.AutomatedInstaller.<init>(Unknown Source)
at com.izforge.izpack.installer.Installer.main(Unknown Source)


Thanks



Please be aware that if you reply directly to this particular message, your reply may not be secure. Do not use email to send us communications that contain unencrypted confidential information such as passwords, account numbers or Social Security numbers. If you must provide this type of information, please visit comerica.com to submit a secure form using any of the "Contact Us" forms. In addition, you should not send via email any inquiry or request that may be time sensitive. The information in this e-mail is confidential. It is intended for the individual or entity to whom it is addressed. If you have received this email in error, please destroy or delete the message and advise the sender of the error by return email.

Re: [Squirrel-sql-users] Sybase ASE wrong precision and scale of VARCHAR/VARBINARY

[Info <in...@dr...>]

My bad: the correct driver name for ASE is jconn4.jar , not sajdbc4.jar 
that is for ASA.
The driver returns zeroes for both precision and scale.
Since it is SAP's driver and I am only doing a quick fix on someone's 
software, using Dev edition, I have no way of contacting them.

On 21/06/12 15:45, Gerd Wagner wrote:
> Am 08.06.21 um 19:55 schrieb info:
> > Metadata tab is wrong about Sybase ASE varchar/varbinary column width.
> >
> Sorry I can't reproduce your problem as I don't have access to Sybase 
> ASE. I couldn't find an official docker image and tried this
> https://hub.docker.com/r/jaschweder/sybase
> but it didn't work.
>
> As the problem doesn't occur on other databases I assume it is a 
> problem of Sybase or the JDBC driver.
>
> Below is a small Java program that you can use to reproduce the problem.
> If you are able to reproduce the problem this way please contact your 
> database and/or JDBC driver vendor.
>
> Gerd
>
> ---------
>
> package pack;
>
> import java.sql.Connection;
> import java.sql.DriverManager;
> import java.sql.ResultSet;
> import java.sql.ResultSetMetaData;
> import java.sql.SQLException;
>
> public class PrecisionAndScaleTest
> {
>    public static void main(String[] args) throws Exception
>    {
>       Class.forName("<yourDriverClass>");
>
>       Connection con = DriverManager.getConnection(
>             "<yourJdbcUrl>", "<yourUser>", "<yourPassword>");
>
>       String sql = "<yourSQL>";
>       ResultSet res = con.createStatement().executeQuery(sql);
>       ResultSetMetaData resMetaData = res.getMetaData();
>
>       // 1 means first column in <yourSQL>
>       int precision = resMetaData.getPrecision(1);
>       int scale = resMetaData.getScale(1);
>
>       System.out.println("precision = " + precision);
>       System.out.println("scale = " + scale);
>    }
> }
>

Re: [Squirrel-sql-users] Sybase ASE wrong precision and scale of VARCHAR/VARBINARY

[Info <in...@dr...>]

Developer edition of Sybase ASE 16 is available for download from SAP. 
It also comes with their official JDBC driver sajdbc4.jar under SDK folder.

On 21/06/12 15:45, Gerd Wagner wrote:
> Am 08.06.21 um 19:55 schrieb info:
> > Metadata tab is wrong about Sybase ASE varchar/varbinary column width.
> >
> Sorry I can't reproduce your problem as I don't have access to Sybase 
> ASE. I couldn't find an official docker image and tried this
> https://hub.docker.com/r/jaschweder/sybase
> but it didn't work.
>
> As the problem doesn't occur on other databases I assume it is a 
> problem of Sybase or the JDBC driver.
>
> Below is a small Java program that you can use to reproduce the problem.
> If you are able to reproduce the problem this way please contact your 
> database and/or JDBC driver vendor.
>
> Gerd
>
> ---------
>
> package pack;
>
> import java.sql.Connection;
> import java.sql.DriverManager;
> import java.sql.ResultSet;
> import java.sql.ResultSetMetaData;
> import java.sql.SQLException;
>
> public class PrecisionAndScaleTest
> {
>    public static void main(String[] args) throws Exception
>    {
>       Class.forName("<yourDriverClass>");
>
>       Connection con = DriverManager.getConnection(
>             "<yourJdbcUrl>", "<yourUser>", "<yourPassword>");
>
>       String sql = "<yourSQL>";
>       ResultSet res = con.createStatement().executeQuery(sql);
>       ResultSetMetaData resMetaData = res.getMetaData();
>
>       // 1 means first column in <yourSQL>
>       int precision = resMetaData.getPrecision(1);
>       int scale = resMetaData.getScale(1);
>
>       System.out.println("precision = " + precision);
>       System.out.println("scale = " + scale);
>    }
> }
>

Re: [Squirrel-sql-users] Sybase ASE wrong precision and scale of VARCHAR/VARBINARY

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

Am 08.06.21 um 19:55 schrieb info:
 > Metadata tab is wrong about Sybase ASE varchar/varbinary column width.
 >
Sorry I can't reproduce your problem as I don't have access to Sybase 
ASE. I couldn't find an official docker image and tried this
https://hub.docker.com/r/jaschweder/sybase
but it didn't work.

As the problem doesn't occur on other databases I assume it is a problem 
of Sybase or the JDBC driver.

Below is a small Java program that you can use to reproduce the problem.
If you are able to reproduce the problem this way please contact your 
database and/or JDBC driver vendor.

Gerd

---------

package pack;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;

public class PrecisionAndScaleTest
{
    public static void main(String[] args) throws Exception
    {
       Class.forName("<yourDriverClass>");

       Connection con = DriverManager.getConnection(
             "<yourJdbcUrl>", "<yourUser>", "<yourPassword>");

       String sql = "<yourSQL>";
       ResultSet res = con.createStatement().executeQuery(sql);
       ResultSetMetaData resMetaData = res.getMetaData();

       // 1 means first column in <yourSQL>
       int precision = resMetaData.getPrecision(1);
       int scale = resMetaData.getScale(1);

       System.out.println("precision = " + precision);
       System.out.println("scale = " + scale);
    }
}

[Squirrel-sql-users] Sybase ASE wrong precision and scale of VARCHAR/VARBINARY

[info <in...@dr...>]

Metadata tab is wrong about Sybase ASE varchar/varbinary column width.