Smalltalk › Pharo › Pharo Smalltalk Users

Can't get an SQLite connection to work

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

5 messages Options

mbratch

Can't get an SQLite connection to work

Hello.

When I try to connect to an SQLite database using the DBXTalk/Garage
SQLite3 driver, I made sure I had the SQLite driver .so file in the
proper location and everything. Ultimately, the error I'm getting now
is: "KeyNotFound: key #filename not found in Dictionary".

I also tried using NBSQLite3, but have not been able to successfully
load it with the instructions given on smalltalkhub.com for the stable
version. The Gofer load results in the error, "MessageNotUnderstood:
receiver of "forCurrentPlatform" is nil".

I did quite a bit of investigating of each of these errors and can't
seem to find my way around them. Has anyone else encountered them or are
these a sign of something obvious I'm doing incorrectly? I know I've
haven't given much information here, so if there's something specific
you need to know, please ask. :)

Mark

mbratch

Re: Can't get an SQLite connection to work

Forgot to mention...

I tried a few different strings for the connectFromString, but here are
a couple of examples I tried, with the same error:

connection := GADriver fromConnectionString:
'SQLite3:///home/mark/Desktop/pharo5.0/projects/test_data.db'.

connection := GADriver fromConnectionString:
'SQLite3://home/mark/Desktop/pharo5.0/projects/test_data.db'.

connection := GADriver fromConnectionString:
'SQLite3://filename:/home/mark/Desktop/pharo5.0/projects/test_data.db'.

Then the error would occur on an attempt to connect:

connection connect

On 6/19/2016 6:35 AM, Mark Bratcher wrote:

> Hello.
>
> When I try to connect to an SQLite database using the DBXTalk/Garage
> SQLite3 driver, I made sure I had the SQLite driver .so file in the
> proper location and everything. Ultimately, the error I'm getting now
> is: "KeyNotFound: key #filename not found in Dictionary".
>
> I also tried using NBSQLite3, but have not been able to successfully
> load it with the instructions given on smalltalkhub.com for the stable
> version. The Gofer load results in the error, "MessageNotUnderstood:
> receiver of "forCurrentPlatform" is nil".
>
> I did quite a bit of investigating of each of these errors and can't
> seem to find my way around them. Has anyone else encountered them or
> are these a sign of something obvious I'm doing incorrectly? I know
> I've haven't given much information here, so if there's something
> specific you need to know, please ask. :)
>
> Mark
>

alistairgrant

Re: Can't get an SQLite connection to work

In reply to this post by mbratch

Hi Mark,

Assuming you're using Pharo 5.0...

On Sun, Jun 19, 2016 at 06:35:00AM -0400, Mark Bratcher wrote:

> Hello.
>
> When I try to connect to an SQLite database using the DBXTalk/Garage SQLite3
> driver, I made sure I had the SQLite driver .so file in the proper location
> and everything. Ultimately, the error I'm getting now is: "KeyNotFound: key
> #filename not found in Dictionary".
>
> I also tried using NBSQLite3, but have not been able to successfully load it
> with the instructions given on smalltalkhub.com for the stable version. The
> Gofer load results in the error, "MessageNotUnderstood: receiver of
> "forCurrentPlatform" is nil".

NBSQlite3 won't work in Pharo 5.0.

> I did quite a bit of investigating of each of these errors and can't seem to
> find my way around them. Has anyone else encountered them or are these a
> sign of something obvious I'm doing incorrectly? I know I've haven't given
> much information here, so if there's something specific you need to know,
> please ask. :)

Do you specifically want the Garage drivers, to access SQLite directly,
or use SQLite3 with Glorp?

The UDBC SQLite3 driver works well in Pharo 5.0 and can be used directly
with Glorp. Details of how to load Glorp with SQLite3 are in
[Pharo-users] [ANN] Glorp-SQLite3 for Pharo 5.

HTH,
Alistair

EstebanLM

Re: Can't get an SQLite connection to work

also, did you verify sqlite library is 32bits?

Esteban

> On 19 Jun 2016, at 20:07, Alistair Grant <[hidden email]> wrote:
>
> Hi Mark,
>
> Assuming you're using Pharo 5.0...
>
> On Sun, Jun 19, 2016 at 06:35:00AM -0400, Mark Bratcher wrote:
>> Hello.
>>
>> When I try to connect to an SQLite database using the DBXTalk/Garage SQLite3
>> driver, I made sure I had the SQLite driver .so file in the proper location
>> and everything. Ultimately, the error I'm getting now is: "KeyNotFound: key
>> #filename not found in Dictionary".
>>
>> I also tried using NBSQLite3, but have not been able to successfully load it
>> with the instructions given on smalltalkhub.com for the stable version. The
>> Gofer load results in the error, "MessageNotUnderstood: receiver of
>> "forCurrentPlatform" is nil".
>
> NBSQlite3 won't work in Pharo 5.0.
>
>
>> I did quite a bit of investigating of each of these errors and can't seem to
>> find my way around them. Has anyone else encountered them or are these a
>> sign of something obvious I'm doing incorrectly? I know I've haven't given
>> much information here, so if there's something specific you need to know,
>> please ask. :)
>
> Do you specifically want the Garage drivers, to access SQLite directly,
> or use SQLite3 with Glorp?
>
> The UDBC SQLite3 driver works well in Pharo 5.0 and can be used directly
> with Glorp. Details of how to load Glorp with SQLite3 are in
> [Pharo-users] [ANN] Glorp-SQLite3 for Pharo 5.
>
> HTH,
> Alistair
>
>

mbratch

Re: Can't get an SQLite connection to work

Yes, Pharo 5.0.

Hmm... good catch on the driver. I'm on a 64 bit system, so it's probably 64 bits. I'll have to locate a 32 bit driver...

Sent from TypeApp

On Jun 19, 2016, at 2:34 PM, Esteban Lorenzano <[hidden email]> wrote:

also, did you verify sqlite library is 32bits?

Esteban

 On 19 Jun 2016, at 20:07, Alistair Grant <[hidden email]> wrote:
 
 Hi Mark,
 
 Assuming you're using Pharo 5.0...
 
 On Sun, Jun 19, 2016 at 06:35:00AM -0400, Mark Bratcher wrote:
 Hello.
 
 When I try to connect to an SQLite database using the DBXTalk/Garage SQLite3
 driver, I made sure I had the SQLite driver .so file in the proper location
 and everything. Ultimately, the error I'm getting now is: "KeyNotFound: key
 #filename not found in Dictionary".
 
 I also tried using NBSQLite3, but have not been able to successfully load it
 with the instructions given on smalltalkhub.com for the stable version. The
 Gofer load results in the error, "MessageNotUnderstood: receiver of
 "forCurrentPlatform" is nil".
 
 NBSQlite3 won't work in Pharo 5.0.
 
 
 I did quite a bit of investigating of each of these errors and can't seem to
 find my way around them. Has anyone else encountered them or are these a
 sign of something obvious I'm doing incorrectly? I know I've haven't given
 much information here, so if there's something specific you need to know,
 please ask. :)
 
 Do you specifically want the Garage drivers, to access SQLite directly,
 or use SQLite3 with Glorp?
 
 The UDBC SQLite3 driver works well in Pharo 5.0 and can be used directly
 with Glorp.  Details of how to load Glorp with SQLite3 are in
 [Pharo-users]
[ANN] Glorp-SQLite3 for Pharo 5.
 
 HTH,
 Alistair