Bug 358307 - Kate does not store configured SQL connection
Summary: Kate does not store configured SQL connection
Status: RESOLVED FIXED
Alias: None
Product: kate
Classification: Applications
Component: general (other bugs)
Version First Reported In: unspecified
Platform: Ubuntu Linux
: NOR major
Target Milestone: ---
Assignee: KWrite Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-01-21 11:05 UTC by Andreas Blochberger
Modified: 2021-12-03 20:36 UTC (History)
6 users (show)

See Also:
Latest Commit:
Version Fixed In: 22.04.0
Sentry Crash Report:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description Andreas Blochberger 2016-01-21 11:05:55 UTC 
Kate does not store any SQL connections. Event when a connection is created, it does not show up on the drop down combo. It shows up in the "SQL" menu as radio menu item

Version 15.12.1
KDE Frameworks 5.18.0
Qt 5.5.1 (kompiliert gegen 5.5.1)



Reproducible: Always

Steps to Reproduce:
Steps to reproduce:
1. Enable SQL module
2. Create a new SQL connection
3. New connection works (but there is no drop down combo anymore to select it)
4. Restart kate
-> Configured SQL connection is gone (looks like it was never saved

Actual Results:  
No SQL connection configured

Expected Results:  
Saved SQL connection
Comment 1 Dominik Haumann 2019-02-02 08:11:19 UTC 
Do you use Kate Sessions? If not, could you try and see whether it works then?
Comment 2 maxmustermann1884 2019-06-06 21:15:43 UTC 
I have the same issue, tried using sessions and kwallet and a different pc.
connection information are stored in kwallet, but kate won't use them after a restart.
also when connecting to a sql database terminal output of kate returns this: "QSqlDatabasePrivate::removeDatabase: connection 'katesql-test' is still in use, all queries will cease to work."

haven't tried with a clean user profile yet, should this work out of the box?
Comment 3 SoulMelody 2019-06-27 08:48:31 UTC 
It's because the KateSQLView class should inherit the SessionConfigInterface.
See https://api.kde.org/frameworks/ktexteditor/html/classKTextEditor_1_1SessionConfigInterface.html
https://cgit.kde.org/kate.git/tree/addons/katesql/katesqlview.h
Comment 4 Justin Zobel 2020-11-13 03:36:55 UTC 
Can you please test and confirm if this issue is still occurring or if this bug report can be marked as resolved. I'm setting status to "needsinfo" pending your response, please change back to "reported" or "resolved" when you respond, thanks.
Comment 5 Andreas Blochberger 2020-11-13 06:58:38 UTC 
(In reply to Justin Zobel from comment #4)
Retested scenario from comment #0 with version 17.12.3 and it is still reproducible
Comment 6 Justin Zobel 2020-11-13 07:04:00 UTC 
(In reply to Andreas Blochberger from comment #5)
> (In reply to Justin Zobel from comment #4)
> Retested scenario from comment #0 with version 17.12.3 and it is still
> reproducible

17.12.3 is nearly 3 years old. Is there a way you can get newer versions in your distribution?
Comment 7 Andreas Blochberger 2020-11-13 15:59:29 UTC 
(In reply to Justin Zobel from comment #6)
> 17.12.3 is nearly 3 years old.
True. Tried it at home with kate 20.08.3 and it is also reproducible
Comment 8 Andreas Blochberger 2020-11-13 16:02:35 UTC 
Looking in the wallet manager, the connection I have created is there, but kate does not show it
Comment 9 Christoph Cullmann 2021-12-03 20:36:48 UTC 
Implement SessionConfigInterface in sql plugin (and expanded it's functionality to store SQLite connections)

https://invent.kde.org/utilities/kate/-/merge_requests/522