Bug 358307

Summary:	Kate does not store configured SQL connection
Product:	[Applications] kate	Reporter:	Andreas Blochberger <andreas.blochberger>
Component:	general	Assignee:	KWrite Developers <kwrite-bugs-null>
Status:	RESOLVED FIXED
Severity:	major	CC:	andreas, christoph, justin.zobel, maxmustermann1884, ms27, yjxrtzyx
Priority:	NOR
Version First Reported In:	unspecified
Target Milestone:	---
Platform:	Ubuntu
OS:	Linux
Latest Commit:		Version Fixed In:	22.04.0
Sentry Crash Report:

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