You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@hop.apache.org by Rob Burgess <ba...@hotmail.com> on 2025/03/05 21:22:04 UTC
SQLite connection fails after upgrading to HOP v2.12.0
Hi
After upgrading to Hop v2.12 from v2.8 and installing Java v17, my SQLite database connection fails with the following error:
No suitable driver found
My SQLLite version is 3.45.3
How do I resolve this issue?
Thanks
Rob
Re: SQLite connection fails after upgrading to HOP v2.12.0
Posted by Hans Van Akelyen <ha...@gmail.com>.
Hi Rob,
It’s an error on our side that the driver is no longer included. Must have
happened when we moved them from the plugin level to lib/jdbc.
I have a personal preference for Postgres but it all depends on your
project needs and infrastructure.
Kr,
Hans
On Wed, 5 Mar 2025 at 22:43, Rob Burgess <ba...@hotmail.com> wrote:
> Thanks Hans
>
> I'm using SQLite with the Hop Workflow Log.
>
> What is a good alternative database for workflow logging in Hop?
>
> *Rob*
>
> Mob: (021) 090 72100
>
>
> ------ Original Message ------
> From "Hans Van Akelyen" <ha...@gmail.com>
> To users@hop.apache.org
> Date 6/03/2025 10:30:01 am
> Subject Re: SQLite connection fails after upgrading to HOP v2.12.0
>
> Hi Rob,
>
> We are probably no longer including the driver. I’ll see if I can get that
> fixed for the next release.
>
> You can copy the driver from the /plugins/databases/sqlite/lib folder of
> the old installation to /lib/jdbc in the new installation
>
> The database connection window will tell you if it can find the driver.
>
> Hope this helps,
> Hans
>
> On Wed, 5 Mar 2025 at 22:22, Rob Burgess <ba...@hotmail.com> wrote:
>
>> Hi
>>
>> After upgrading to Hop v2.12 from v2.8 and installing Java v17, my SQLite
>> database connection fails with the following error:
>>
>> No suitable driver found
>>
>> My SQLLite version is 3.45.3
>>
>> How do I resolve this issue?
>>
>> Thanks
>>
>> *Rob*
>>
>>
SQLite connection fails after upgrading to HOP v2.12.0
Posted by Rob Burgess <ba...@hotmail.com>.
Thanks Hans
I'm using SQLite with the Hop Workflow Log.
What is a good alternative database for workflow logging in Hop?
Rob
Mob: (021) 090 72100
------ Original Message ------
From "Hans Van Akelyen" <ha...@gmail.com>>
To users@hop.apache.org<ma...@hop.apache.org>
Date 6/03/2025 10:30:01 am
Subject Re: SQLite connection fails after upgrading to HOP v2.12.0
Hi Rob,
We are probably no longer including the driver. I’ll see if I can get that fixed for the next release.
You can copy the driver from the /plugins/databases/sqlite/lib folder of the old installation to /lib/jdbc in the new installation
The database connection window will tell you if it can find the driver.
Hope this helps,
Hans
On Wed, 5 Mar 2025 at 22:22, Rob Burgess <ba...@hotmail.com>> wrote:
Hi
After upgrading to Hop v2.12 from v2.8 and installing Java v17, my SQLite database connection fails with the following error:
No suitable driver found
My SQLLite version is 3.45.3
How do I resolve this issue?
Thanks
Rob
Re: SQLite connection fails after upgrading to HOP v2.12.0
Posted by Hans Van Akelyen <ha...@gmail.com>.
Hi Rob,
We are probably no longer including the driver. I’ll see if I can get that
fixed for the next release.
You can copy the driver from the /plugins/databases/sqlite/lib folder of
the old installation to /lib/jdbc in the new installation
The database connection window will tell you if it can find the driver.
Hope this helps,
Hans
On Wed, 5 Mar 2025 at 22:22, Rob Burgess <ba...@hotmail.com> wrote:
> Hi
>
> After upgrading to Hop v2.12 from v2.8 and installing Java v17, my SQLite
> database connection fails with the following error:
>
> No suitable driver found
>
> My SQLLite version is 3.45.3
>
> How do I resolve this issue?
>
> Thanks
>
> *Rob*
>
>