Activity for sfst
-
sfst posted a comment on ticket #1517
So it can be closed?
-
According to https://discussion.evernote.com/forums/topic/138075-weird-characters-are-added-to-printed-in-my-note-when-entering-a-shortcut/ there is a problem when the default language is Dutch. Switching to English (US) apparently helps?
-
Time is passing fast :-) Another year passed, so maybe it is no longer needed to be kept open? ;-)
-
[..]does not work on Postgres Yes, unfortunately, which is a pity, but it isn't a requirement for SQuirreL SQL to only use the intersection of capabilities of Postgres and Oracle, right? 1.) Use standard quoting and standard escaping: select 'long string with some quoted semicolon '';'' in the string.' from dual That is what I am using, but it is an inconvenience. I am often inserting SQL commands into a setup table (some modules are fetching those commands to do some daily tasks like data integrity...
-
I understand you kept this open, so other people can find the solution, but now after one year it can be closed?
-
Using squirrel-sql-snapshot-20230109_2301-standard.jar I have tried with an Oracle database to compare 2 tables in different schemata (but different sessions) and got nothing. It logged: ERROR net.sourceforge.squirrel_sql.client.Main - Exception occurred dispatching Event java.awt.event.MouseEvent[MOUSE_RELEASED,(538,836),absolute(530,868),button=1,modifiers=Button1,clickCount=1] on frame0
-
Version 4.5.0 still throws this error. I am not sure whether it is related to the problem that this select command: select q'{long string with some quoted semicolon ';' in the string.}' from dual; Throws: --begin quote-- Error: ORA-01756: quoted string not properly terminated SQLState: 42000 ErrorCode: 1756 Position: 79 Error occurred in: select q'{long string with some quoted semicolon ' --end quote-- FYI: This here runs fine: select q'{long string with some quoted colon ':' and double dashes '--'...
-
Pardon my necro-posting, but the original article on the MS site is no longer available. There is a newer version at https://docs.microsoft.com/en-US/office/troubleshoot/excel/wrongly-assumes-1900-is-leap-year (MS does NOT forward from http://support.microsoft.com/kb/214058, but they DO forward from http://support.microsoft.com/kb/214326, which apparently was a related article.) (I also noticed that in the bug report I had used "CVS", which should have been "CSV")
-
Excel import throws error "An error occurred while reading import file data."
-
That's solved and can be closed?
-
With Oracle when trying to load into a table I have only RO access I get the clear error message: A database error occurred while inserting data: ORA-01031: insufficient privileges The problem occurred in line 0 Given we cannot solicit feedback from the anonymous OP we need someone testing that with DB2? (Otherwise close the ticket?)
-
Correct, and it (bug #843) was closed (and fixed) - so this one here can be closed too?
-
+1 It is an interesting suggestion (though it could be disliked by some users for changing a long established easy to understand behaviour). If the same alias is opened more than once it should "share" the export settings among those, right?
-
Neat observation. I am here, because a co-worker got "Error: Invalid SQL type: sqlKind=UNINITIALIZED SQLState:99999 ErrorCode:17439". I got the error demonstrated multiple times, but I cannot reproduce that problem, despite using the same SQuirreL version 4.2.0 and pasting the same command (we are both on Windows). But I am using OpenJDK and the co-worker is still on Oracle Java and we found that NOT sticking a multi line comment to the SQL command fixed the problem for the co-worker. So, this threw...
-
Thank you. Please close this as fixed (it's getting long, I have stuffed this enough :-) and I'll open extra feature requests about remaining issues.
-
Quite embarrassing mistake. (I only post if I can do the same problem at least twice.) Often my prepared statements have a suggested filename in the comment and I paste the filename, adjusting the date only. I finally found that I made a typo, having ",xls" instead of ".xls" (of course, pasting the typo "worked" each time when testing) d:\2021-05-14 STEP06.17 database PRD mismatching transactions,XLS So when switching the extension I got the impression the FIRST dot was used. Terribly sorry about...
-
I'm not sure why you say specifying "byte" would make it fail because your databases are "codepage based", but then I'm not an Oracle expert. I am not an Oracle expert either :-) Just an experience: When we copy a table from an "ANSI" database ( where 1 Char=1Byte ) into a UTF-8 database (English characters still take 1 Byte, but local characters take up multiple bytes), the local language characters "blow up", so they might no longer fit, if the table was created with BYTE. That depends on the data,...
-
Thank you for the nice Java snippet; I saved it, but I am not sure when I have time trying it. The semicolon observation is quite helpful - I had no idea this could be an issue. Unfortunately I am still on Oracle 11.1 ;-( After installing the latest driver for 12.1.0.2 (files dated 2018-04-23) and the latest SQuirreL snapshot: --works: insert into tmp_id(tmp_id) values(q'{test1 '!}') --throws ORA-00911: invalid character insert into tmp_id(tmp_id) values(q'{test2 '!}'); --works(!): begin insert into...
-
I always install into a fresh folder and remember encountering that problem, which was solved in later versions. It seems it was a bug, solved by now and the ticket can be closed.
-
Change to closed-fixed?
-
I am setting the NLS_LENGTH_SEMANTICS of my session before I create/copy tables, but with "alter session" (I don't have DBA rights in the production databases, but I can create tables in one schema). So I am happy with the "simple" create table scripts that don't bring forward the whole technical storage details (I stick to the defaults, which might be different in different databases) and do NOT specify the BYTE/CHAR in the create command. Would any change here also have implications for the table...
-
Oracle alternate quoting cannot be used with odd number of single quotes in literal string
-
Switching the export format removes filesname part after 1st dot
-
Is there anything in this request that SQuirreL SQL cannot do by now?
-
1) was implemented in the right-click menu: "Copy as SQL INSERT-VALUES statement" 2) please explain why exporting into a document format would be useful for enough users to add that feature; the export to CSV gives a text file you can import/paste into any text processing software 3) same as 2) 4) I am quite certain that in 2009 that feature already existed. I propose to close as fixed.
-
Run query output directly to a file (@file) blocks SQuirreL
-
Thank you. Please close this as fixed (it's getting long, I have stuffed this a enough :-) and I'll open extra feature requests about remaining issues.
-
The silent overwriting of existing files is a feature, right? Maybe the change log should mention that?
-
Keyboard shortcuts in dialogs
-
I understand this has been fixed and can be closed now?
-
I understand this has been fixed and be closed now?
-
SQuirreL doesn't explicitly execute the SQL you mentioned but uses the JDBC drivers database meta data access methods. I guess the SQL you see is generated by your JDBC driver. Interesting, I wasn't aware about that. I am using Oracle JDBC Driver version - "10.2.0.4.0" (a thin driver from 2008). Inside the driver I indeed could find the SQL fragment I had posted above. The same with another thin driver from 2014 I already have: Ant-Version: Apache Ant 1.7.1 Created-By: 20.75-b01 (Sun Microsystems...
-
Objecs, Source: Table column list merged for similar named tables
-
Import file in UTF-8 BOM format messes up 1st data field
-
Ok, I don't use the feature anyway :-) So the ticket can be closed then?
-
Can be closed now?
-
Windows: Export with filename containing colon claims success
-
Still open ;-)
-
So it is intentional that it does NOT work for the already open session via Session -> Session Properties -> tab Syntax? (Tested with snapshot from 2020-06-25 on Windows 8.1)
-
FYI: With the Oracle plugin loaded this fails: @file 'd:\test.csv' SELECT * FROM tmp_id; It logged: Logged by net.sourceforge.squirrel_sql.fw.sql.QueryTokenizer at 14/05/2020, 17:45: Unexpected exception while reading lines from file (file 'd:\test.csv' SELECT * FROM tmp_id) The stacktrace: java.io.FileNotFoundException: file 'd:\test.csv' SELECT * FROM tmp_id (The filename, directory name, or volume label syntax is incorrect) Using the "Unload" button for the Oracle plugin did not help; I had to...
-
FYI: With the Oracle plugin loaded this fails: @file 'd:/test.csv' SELECT * FROM tmp_id; It logged: Logged by net.sourceforge.squirrel_sql.fw.sql.QueryTokenizer at 14/05/2020, 17:45: Unexpected exception while reading lines from file (file 'd:/test.csv' SELECT * FROM tmp_id) The stacktrace: java.io.FileNotFoundException: file 'd:\test.csv' SELECT * FROM tmp_id (The filename, directory name, or volume label syntax is incorrect) Using the "Unload" button for the Oracle plugin did not help; I had to...
-
It sure can be closed now? ;-)
-
Thank you. Snapshot 2020-02-20 offers all functionality needed, so this request can be closed.
-
Import plugin does not remove double quotes
-
Could anyone please give a convincing explanation why running millions of individual insert commands is better than importing from a text file?
-
Thank you, the snapshot from 2019-11-25 shows a counter, which is really useful. Is it possible to log in the message window at the bottom the time taken for the import?
-
The log entry is: Exception occurred dispatching Event java.awt.event.InvocationEvent[INVOCATION_DEFAULT,runnable=net.sourceforge.squirrel_sql.client.session.mainpanel.notificationsound.SoundPlayer$$Lambda$361/0x0000000100484440@374c8b2b,notifier=null,catchExceptions=false,when=1579672493312] on sun.awt.windows.WToolkit@4b6d6cb
-
Thank you. Works great! The test button does not function on my system (Windows 8.1 Pro 64 bit; recently switched from Oracle JRE to AdoptOpenJDK 11.0.5+10; SQuirreL snapshot 20191225), but this is not of any importance.
-
Please upvote the original request instead of creating a new duplicate entry. Thank you for your co-operation.
-
JSON export doesn't allow to select the charset
-
Lately my Oracle database freezes SQuirreL for several minutes before throwing the error message, e.g. like referencing a non-existent table like this: select * from dual a,dual b where a.dummy=n.dummy; (Of course the command is more complex than that.) Immediately repeating the command without change always will give the error fast. So far this is impossible to reproduce, it doesn't seem to be related with the server load, I am currently guessing some network issue. So if any alert would be implemented...
-
SQuirreL homepage outdated info regarding minimum Java required
-
So this here can be closed too?
-
Import file no longer offers "one to one mapping"
-
Can be closed as fixed (v 3.9.1) - thank you, I really like this feature a lot :-)
-
Thank you for the information. I conclude that the 900,000 documents installation worked sufficiently well? Performance is hard to measure, and some problems can be solved by throwing more hardware onto it. But are there some estimates what to expect? Example: I was told about a 32 bit windows server 2003 with MS SQL and some home-grown ASP stuff that was giving timeouts if more than 2 users were searching for documents at the same time. (I didn't get hardware info.) (Clarification: I hope it is...
-
Thank you for the information. I conclude that the 900,000 documents installation worked sufficiently well? Performance is hard to measure, and some problems can be solved by throwing more hardware onto it. But are there some estimates what to expect? Example: I was told about a 32 bit windows server 2003 with MS SQL and some home-grown ASP stuff that was giving timeouts if more than 2 users were searching for documents at the same time. (I didn't get hardware info.)
-
Sorry if I missed that, but I cannot find an FAQ. (The Wiki also is rather sparse and seeddms-doc wasn't updated in a while ;-) Currently I am mostly interested in technical details, so I can estimate whether this software will fit my needs. E.g. requirements (I found those in the README.Install.md after downloading the latest beta) and limits of the software. I found a discussion from 2016 that mentioned that the "highest document id is 2^31" and that "SeedDMS puts each document into its own directory"....
-
Bookmark parameter to pick up current selection
-
I understand this was implemented and can be closed?
-
I wanted to fix a typo above and some spambot protection somehow engaged (my mouse is going bad and sometimes double-clicks). I noticed that the tabs "Code Completion" and "Syntax" do not get a vertical scroll bar when I make the "New Sessions Properties" pop-up rather narrow. Less than 650 vertical height and the table under "Configure function completion for function name prefixes" is basically invisible. It is not a problem for me for 2 reasons: -I got hardware better than the recommended minimum...
-
SQuirreL snapshot 20190121_2238 HP ProBook 430 G2 Intel HD Graphics 5500 Windows 8.1 Pro 64 bit 1920x1080 pixels external monitor or 1366x768 on laptop (OS always updated as prompted) Java 1.8.0_181-b13 just updated to 1.8.0_201-b09 still the same Expanding the window wide enough will eventually show all the text, but with varying degrees of incomplete text in between (see newer shot for another example). Certainly not a big problem, unfortunately I cannot edit the priority (back when numbers were...
-
SQuirreL snapshot 20190121_2238 HP ProBook 430 G2 Intel HD Graphics 5500 Windows 8.1 Pro 64 bit 1920x1080 pixels external monitor or 1366x768 on laptop (OS always updated as prompted) Java 1.8.0_181-b13 just updated to 1.8.0_201-b09 still the same Expanding the window wide enough will eventually show all the text, but with varying degrees of incomplete text in between (see newer shot for another example). Certainly not a big problem, unfortunately I cannot edit the priority (back when numbers were...
-
May I ask for clarification about the priority? When filing a bug the priority is just numbers from 1 to 9. I understand that higher numbers mean higher priorities, right? But I have never heard anyone saying "Safety it our number nine priority", and I have seen company internal lists where "1" was the highest priority, so I am not sure here. The creator of bug #1131 wasn't sure either, so I am not alone ;-) If I understand this here correctly it should be possible adding a clarification like this?...
-
But kept open for visibility?
-
May I ask for clarification about the priority? When filing a bug the priority is just numbers from 1 to 9. I understand that higher numbers mean higher priorities, right? But I have never heard anyone saying "Safety it our number nine priority", and I have seen company internal lists where "1" was the highest priority, so I am not sure here. The creator of bug #1131 wasn't sure either, so I am not alone ;-) I looked into other projects and some use words instead of numbers, so I conclude the project...
-
v.3.9.0 Export tab delimited CSV file no longer working
-
Session Properties, Code Completion incomplete help text
-
When I encountered this in the distant past it always turned out that I failed noticing that the new SQL command didn't actually deliver any output (there was an error message in the narrow bottom window) and I was staring at the output of the previous command. The Info tab with the execution date/time helps verifying the "age" of the output. That the old query result still is displayed is what I like from this product so much. Nowadays the error tab is a big improvement preventing this misunderstanding,...
-
I understand this is a duplicate of feature request #438? #438 Run query output to a file
-
Could you please give a few more details/examples if you still want that? My take is that I prefer avoiding bloating a good product. (If it can be done via a plugin it would be fine, of course.) BTW: Notepad++ has SQL syntax highlighting as well and does macros (I hardly ever use that, regex covers my needs). Its "Smart Highlighting" is very useful, because it highlights all identical strings without having to use the search function first. But I do not request that as a feature in SQuirreL. Notepad++...
-
So is version 3.8.1 working for you and the issue can be closed?
-
Nice, but it silently overwrites existing files. It also does not execute the command after the export. This block: SELECT '1' FROM tmp_id; SELECT '2' FROM -tmp_id; SELECT '3' FROM tmp_id; will stop at the offending line with an error message in a tab. But this: @file '/tmp/test.csv' SELECT * FROM tmp_id; @file '/tmp/test2.csv' SELECT * FROM -tmp_id; @file '/tmp/test3.csv' SELECT * FROM tmp_id; will run through the whole block, only with an error message in the message window at the bottom. (Tested...
-
No need to overengineer this feature. Ok, feeding the cat might be a bit over the top :-) I imagine a right-click menu item "Execute Selected Query to a CSV file" or something like that. That already exists in SQuirrel SQL under "Store result of SQL in file", but the OP wanted a feature that would NOT need manual intervention to save the data.
-
To "generate dummy or test data" I recommend you find out whether your database is capable enough doing things at the server side, which would be much more efficient than being slowed down by the network latency. E.g. in Oracle you can generate a table with the numbers 1 to 1,000,000 with this command: create table tmp_test as SELECT level AS N FROM dual CONNECT BY level <= 1000000; This took just a second on my test system. "to do performance or throughput testing by having squirrel simulate a load"...
-
I am on Windows 8.1 and noticed the same issue of increased CPU usage after the update from Java 131 to 161 (64 bit). I never force any garbage collection, but by just switching to a different database connection tab I already have open it reduces the constant CPU usage from 20% to 1%
-
What SQuirreL version are you using? I had a similar problem with v.3.8.0, but v.3.8.1 works for me now. Were those comments you removed /* */ blocks ? Issue #1314 might be leated to this here.
-
SQuirreL 3.8.1 no longer seems to have this problem - thank you. The issue can be closed.
-
Oracle Type RAW column(s) cause empty Overview/Charts
-
VOTE: squirrel-sql I am using it for many years now and IMO it is a mature product.
-
I understand the request about the java.sql.SQLWarning was implemented with the small screen icon ("Press to open logs") in the status bar, so that part could be closed. I don't know about the Explain Plan part, because I don't have any Sybase access - is that 2nd part the reason this request still is open?
-
I cannot reproduce that with any recent version and would certainly have noticed if that still was an issue, so I guess it was fixed. Note: I am using a fairly standard installation under Windows 8.1; I use the default L&F and do not change any font settings. In the past I had similar experiences the OP described with other software under windows XP with exotic fonts.
-
I am using the Oracle plugin and look at the Explain Plan regularly and only encounter temporary "hangs" with complex SQL commands, but certainly not with "very basic queries", so I guess it was fixed.
-
File --> Global Preferences --> tab Data Type Controls --> Section Unknown Data Types Thank you - I learned something new again :-) The output now is "61 0:0:0.0", which is fine with me. (The different format compared with SQLPLUS probably is some difference in the default formatting I guess.) Does that mean that bug report #723 Interval column content not displayed can be closed too?
-
Oracle type INTERVALDS not properly displayed
-
Do you have the sqlparam plugin turned on[..] Good catch! Yes, I always have that turned on and unloading it in 3.8.0 indeed helps - thank you. The question remains why only 3.8.0 has a problem with it. I misunderstood the "database specific Plugin", I had tried unloading the Oracle plugin, which still didn't allow me changing that option for removing multi line comments. Luckily I never had to use Oracle hints so far.
-
Argh! I forgot that tabs are not preserved on posting, the indentation tabs are essential! Sorry about that - I'll add an attachment with the whole post. (I probably would mess up the quoting today :-)
-
Argh! I forgot that tabs are not preserved on posting, the indentation tabs are essential! Sorry about that - I'll add an attachment with the whole post.
-
v3.8.0 multiline comment sometimes makes SQuirreL hang
-
Can you please specify the format of the file you opened? (Is it .mpp?) Is it possible to upload the file? Can you please try the Save as? Please pay close attention what is in "Files of type:", when I had "All Files" it saved an XML file with the .POD extension, which needed renaming, otherwise it could not be opened again. (As Windows by default hides the known file extensions this can be a difficult task on some computers.)
-
Thank you for keeping an eye on such things. Unfortunately visiting that link the switching to English over there doesn't seem to work for me. So what I figured out with Google Translate is that in January 2016 the antivirus vendor ClamAV detected Win.Adware.Outbrowse-1197 with their detection library as of 20160118 According to https://home.mcafee.com/virusinfo/virusprofile.aspx?key=5931632 not a virus, but some "potentially unwanted software". Another 53 Antivirus vendors apparently found nothing....
-
The attached file has the wrong file extension. If I rename it to XML and open it from inside ProjectLibre it opens just fine. This report is very useful, because it highlights the very common problem of wrong file extensions. So the bug is that the program is not doing a check of the proper file format on opening. I tested 1.7.0, which just does nothing if I open a file where the extension is mismatching (or not a ProjectLibre file at all). (Using Windows 8.1, 64 bit, latest Java) Expected behaviour:...
-
The attached file has the wrong file extension. If I rename it to XML and open it from inside ProjectLibre it opens just fine. This report is very useful, because it highlights the very common problem of wrong file extensions. So the bug is that the program is not doing a check of the proper file format on opening. I tested 1.7.0, which just does nothing if I open a file where the extension is mismatching (or not a ProjectLibre file a all). (Using Windows 8.1, 64 bit, latest Java) Expected behaviour:...
-
I appologize if I came accross that you didn't RTFM, because your point of poor manuals is absolutely valid. If the configuration menus are intuitive to new users, this lack of documentation could be tolerated (at least to some extent). IMO your initial request was useful, because it pointed out a certain weakness in a configuration menu. It is up to the developers now whether they are going to act upon your suggestion.
-
I appologize if I came accross that you didn't RTFM, because your point of poor manuals is absolutely valid. If the configuration menus are intuitive to new users, this lack of documentation could be tolerated (at least to some extent). IMO your initial request was useful, because it pointed out a certain weakness in a configuration menu. It is up to the developers now whether they are going to act upon your suggestion.
-
Ok, so I was wrong with "[..] is lumped into the "Other" group, which I understand the OP already realized." Anyway, if the developers would "[add] a 5th entry in the Fonts tab under Global Preferences to exclusively handle the font for the result grid.", it might be useful for some users? Otherwise this request should be closed.
-
Cancel save file dialog under Session->File->New file still clears input area
-
So the default of having this option checked is not optimal for new users of SQuirreL (at least not with certain databases)? Generally I prefer avoiding to change long established defaults, but if there a compelling reason we all should be open to change. (I am not sure whether the Auto Commit SQL default is optimal either, especially as we have to scroll UP every time to see that option - so it is a bit hidden.) BTW: I think the "perdefined" on the Session Properties -> SQL should be "predefine...
1 >
