Activity for Claus
-
Claus posted a comment on ticket #2379
It works for me, thank you!
-
It works for me, thank you! The context menu should provide only the most important commands, thus the duplication command has been removed. The command continues to be available in the main menu (at the top of the window). For those who want the context menu commands back, I've now added two options in the KeeUIExt plugin: Show 'Duplicate Group' command in the group context menu. Show 'Duplicate Entry' command in the entry context menu. The latest version of the KeeUIExt plugin is available here:...
-
Thanks, it works. Thats fine for me!
-
Oh sorry - additional error INSERT INTO "test" ("Dummy") VALUES ('a'); INSERT INTO "test" ("Dummy") VALUES ('b'); Table has to be in lower case too... If create table "test" would have been create table "TeSt" it should be INSERT INTO "TeSt" ("Dummy") VALUES ('a');
-
Tested in SQuirreL snapshot-20220705_1007 and snapshot-20220614_2245
-
Copy as SQL INSERT-VALUES statement wont work with quoted Column Names
-
Copy as WIKI Table - JIRA/Confluence
-
I should add - it should be called CTRL-B or CTRL-click in english tickets :-)
-
I should add - it should be called CTRL-B or CTRL-Click in english tickets :-)
-
STRG-B (jump to tree entry) wont work if multiple names exists
-
I use jdk-16.0.2+7 from Adopt Open JDK. This can be used free of license https://adoptopenjdk.net/releases.html?variant=openjdk16&jvmVariant=hotspot
-
Check which Java Version is running if you start program as jar using java -version in any command line. This will your default java add the same inside your bat and check again. My suggestion: Use Java 16 like me. It works fine.
-
Hi, I found the following in superuser.com: The problem here seems to be that Swing is by default claiming that it is DPI aware, so windows doesn't scale it. Use this switch to turn off this behavior and windows will start scaling your swing app: -Dsun.java2d.dpiaware=false [EDIT: Unfortunately, this flag no longer seems to work in Java 8, I was testing it in Java 6. Looks like this is a known issue.] [EDIT 2: You can modify a Java 8 install to work correctly, using a program to modify the EXE manifests....
-
Thanxs very much for this update. It works fine until there is only one line. Then the blue row selection line wont let shine this color through...
-
I use a 32" 2.5k screen with Adopt Open JDK 16x64 It runs inside Windows Server 2012R2 and since a few weeks Server 2019. It works fine in my setup. Can you provide some screenshots? Do you use a "look and feel"? There are some that can result to such a small font. Also there is a option in global preferences where you can change default font sizes.
-
nagle algorithm
-
Add new JDBC Property
-
Search and Replace - Switch between SQL Tab without Closing SaR wont work
-
Hmm. I used drag and drop to move file from filesystem to SQuirreL - now i can use the button again. weird. If I look into log i can only see this: 2021-10-19 08:49:27,540 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.Main - Exception occurred dispatching Event java.awt.event.MouseEvent[MOUSE_RELEASED,(322,129),absolute(314,121),button=1,modifiers=Button1,clickCount=3] on frame0 java.nio.file.InvalidPathException: Trailing char < > at index 90: Filepath...\Filename.sql at java.base/sun.nio.fs.WindowsPathParser.normalize(WindowsPathParser.java:191)...
-
Cannot click on open files icon anymore
-
NULL Values color
-
Multiple Create / Comment Statements very slow
-
System i Metadata: Source for View wont show correctly
-
System i Metadata: Indexe wont show correctly
-
You are still right. We found exceptions like this also in 10.4-driver Version. It happened near the end so it was not a problem before. Thank you very much!
-
I should add - if I query the database using SQuirreL i do not get any error: SELECT * FROM EXAMPLETABLE WHERE (EXAMPLECOLUMN = 1234567890) (using current jdbc-Driver). This happens only in Prepared SQL Statements
-
Oh you are so right. That has to be the problem. But why does this work with previous driver version? I saw in JDBC Properties a few days ago an Option to activate DataTruncationTest. We did not activate https://www.ibm.com/docs/en/i/7.3?topic=ssw_ibm_i_73/rzahh/javadoc/com/ibm/as400/access/doc-files/JDBCProperties.html data truncation Specifies whether truncation of character data generates warnings and exceptions. When this property is "true", the following apply: Writing truncated character data...
-
SELECT * FROM EXAMPLETABLE WHERE (EXAMPLECOLUMN = ?) CREATE TABLE EXAMPLETABLE( EXAMPLETABLE_ID NUMERIC(15) NOT NULL, EXAMPLECOLUMN NUMERIC(9) NOT NULL, A_FK NUMERIC(15) NOT NULL, B_IK NUMERIC(9), C_FK NUMERIC(15), D_FK NUMERIC(15), E_AKTIV NUMERIC(1) NOT NULL, F_GUELTIG_AB NUMERIC(8) NOT NULL, G_FK NUMERIC(15), H NUMERIC(1), I_FK NUMERIC(15), J_FK NUMERIC(15), K_FK NUMERIC(15), L_FK NUMERIC(15), M NUMERIC(1) NOT NULL ); ALTER TABLE EXAMPLETABLE ADD CONSTRAINT EXAMPLETABLE_PK PRIMARY KEY (EXAMPLETABLE_ID);...
-
Data type mismatch. (P#=1) testDataTruncation(AS400JDBCConnectionImpl.java:6141)
-
I see there is an Option SYSTEM_TABLE in Result. This value is N. Would it be better to create a Ticket at IBM? I guess this is used to return values as TABLES or SYSTEM TABLES?
-
DatabaseMetaData.getTables returns Systemtables
-
Works fine. Thank you!!
-
Works fine. Thank you!!
-
System i / Power 9 / AS400 - UTF-8 Column Infos
-
I think this helped... I report again if this happens again. Thanxs for fast help!
-
Java-level deadlock
-
I should add I currently use a System i 7.3 (AS400)
-
Current schema / Code Completion
-
Okay, new Version, new Options. DN is now delimited by " " Thats OK.
-
Export dsv
-
I think you should go to search - on Tab Options you can select your Attributes (like givenName, sAMAccountName, ...) and search. Report can be saved. I did not try commandline right now...
-
You can close the Ticket. I found a different Option in our SQL-Tool which was not set correctly.
-
Not Working: JRE 1.8.0_192-b12 Working: JRE 1.8.0_131-b11
-
(I checked them - they are identically)
-
Sorry, but this cannot be true by default: We have two different AS400 / System i installations. Here it works: JDBC-Treiber Klassenname com.ibm.as400.access.AS400JDBCDriver JDBC-Treiber-Klassenpfad D:\Tools\JDBC\DB2-jtOpen\java8\jt400.jar getURL jdbc:as400://yyy getDriverName AS/400 Toolbox for Java JDBC Driver getDatabaseProductName DB2 UDB for AS/400 getDatabaseProductVersion 07.03.0000 V7R3m0 getDriverVersion 12.1 getUserName HVRF1060 getDefaultTransactionIsolation TRANSACTION_READ_UNCOMMITTED...
-
Decimal Values will be returned formated
-
SIGNAL MESSAGE_TEXT truncated after 70 chars
-
Hi, thanks for your anwser. 1. Oh, right :-) This is ok. 2. I cannot reproduce this behavior by myself. You can close the ticket. Thanks!
-
Hi, I should add: CPU Usage is 100% (one Core) at this time...
-
Code Completion - SQuirreL hangs
-
Current Version : 4.0.0
-
Search and Replace strange behavior
-
I have full access to a AS400 System i (currently 7r3). I had tested it using the following SQL: select date('1939-01-01') from sysibm.sysdummy1 union all select date('1940-01-01') from sysibm.sysdummy1; First one returns NULL, second one a date: NULL 1940-01-01 If you change Global Preferences \ Data type Controls \ Date (SQL type 91) Use default format (xxxxx) to Long, Medium, Short, ... Nothing changes. If you change JDBC-URL to jdbc:as400://<servername>;date format=iso;time format=iso; You will...
-
Hi Gerd, firstly - thanks for this solution. It will help me, but is not exactly what I intended ( 80% ;-) ). Is it possible to define this "LIKE scheme" so it will be appended dynamically? In your solution I have to open Session Properties every time a new schema has been added... Please keep the current solution - it works at last for me, but is not as convenient as it could be...
-
Hi, this may be your solution: https://www-01.ibm.com/support/docview.wss?uid=nas8N1017268 "jdbc:as400://RCHASSLH;date format=iso;time format=iso;" Greetings Claus
-
Hi, this may be your solution: https://www-01.ibm.com/support/docview.wss?uid=nas8N1017268 "jdbc:as400://RCHASSLH;date format=iso;time format=iso;" Greetings Claus
-
Some additions: 1. We use AS 400 / System i 7.3 2. We use HikariCP-java7 as Connection Manager 3. We found this Issue, but the fix seems to be implemented in HikariCP-java9 only https://github.com/brettwooldridge/HikariCP/issues/247
-
Some Additions: We use AS 400 / System i 7.3 We use HikariCP-java7 as Connection Manager * We found this Issue, but the fix seems to be implemented in HikariCP-java9 only https://github.com/brettwooldridge/HikariCP/issues/247
-
The connection does not exist - checkOpen
-
In Current Version 9.8 you can see changes from 9.7. Ticket may be closed.
-
Custom Schema Properties
-
SQuirreL 3.9.1-stable: nanoxml.jar Latest Version: nanoxml.jar v2.2.1 I should add: Since this week - we can use a better Internet Connection (our Profile is not in our company site located). Since then it is way better.
-
Save Preferences on Networkdrive extremly slow
-
I am using Windows 2008 Terminal Server. I got same error again, when I directly...
-
Queries on different tab where executed
-
Generally define which Schema should be shown per Default
1
