Re: Database connction problem

#1 08-24-2008, 12:48 PM

On Sun, 2008-08-24 at 07:06 -0700, vttoonses wrote:
> <caveat>
> I am new to lisp and do not understand everything about working in
> the environment.
> </caveat>
>
> <system info>
> OS - Mac OSX 10.5.4
> Lisp - Clozure Common Lisp Version 1.2-r10478M-trunk
> (DarwinX8664)
> Database - PostgreSQL 8.3.3
> </system info>
>
> I am trying to make a connection to a running datasource. Each time I
> execute the following command:
> (clsql:connect '("" "clsql" "gene" "") :database-type

ostgresql)
> I receive the following error message:
> Error: Couldn't load foreign libraries "clsql_uffi64",
> "clsql_uffi". (searched CLSQL-SYS:*FOREIGN-LIBRARY-SEARCH-PATHS*)
>
> The current value of clsql-sys:*foreign-library-search-paths* is (#P"/
> Users/gene/Development/clsystems/clsql-4.0.3/uffi/") and, while
> clsql_uffi.dylib exists there, clsql_uffi64.dylib does not. After some
> research, I found a post recommending copying the clsql_uffi file to
> the clsql_uffi64. This results in the following error:
> Error: Undefined function: CLSQL-UFFI:ATOL64
>
> Performing "nm" on the files shows an entry point for atol64. Possibly
> the linkage between lisp and the native library is broken?
>
> Any help resolving this issue would be greatly appreciated. I'm pretty
> much at my wit's end and I'd rather not go back to programming in
> Java.
>
> Thanks,
> Gene
>
> PS. I've previously posted to the clsql news group yet have received
> no response in more than a week. Hence, I am trying here.

hi,
this isn't exactly the answer you might be looking for, but seeing as
you're using PostgreSQL it might be ok to mention that i've found
Postmodern to work great in that context:
http://common-lisp.net/project/postmodern/

--
Lars Rune NÃ¸stdal
http://nostdal.org/

AJAX/Comet GUI type stuff for Common Lisp:
http://groups.google.com/group/symbolicweb

#2 08-24-2008, 03:22 PM

On Aug 24, 12:48*pm, Lars Rune Nøstdal <larsnost...@gmail.com> wrote:
> On Sun, 2008-08-24 at 07:06 -0700, vttoonses wrote:
> > <caveat>
> > * * I am new to lisp and do not understand everything about workingin
> > the environment.
> > </caveat>
>
> > <system info>
> > * * OS - Mac OSX 10.5.4
> > * * Lisp - Clozure Common Lisp Version 1.2-r10478M-trunk
> > (DarwinX8664)
> > * * Database - PostgreSQL 8.3.3
> > </system info>
>
> > I am trying to make a connection to a running datasource. Each time I
> > execute the following command:
> > * * (clsql:connect '("" "clsql" "gene" "") :database-type

ostgresql)
> > I receive the following error message:
> > * * Error: Couldn't load foreign libraries "clsql_uffi64",
> > "clsql_uffi". (searched CLSQL-SYS:*FOREIGN-LIBRARY-SEARCH-PATHS*)
>
> > The current value of clsql-sys:*foreign-library-search-paths* is (#P"/
> > Users/gene/Development/clsystems/clsql-4.0.3/uffi/") and, while
> > clsql_uffi.dylib exists there, clsql_uffi64.dylib does not. After some
> > research, I found a post recommending copying the clsql_uffi file to
> > the clsql_uffi64. This results in the following error:
> > Error: Undefined function: CLSQL-UFFI:ATOL64
>
> > Performing "nm" on the files shows an entry point for atol64. Possibly
> > the linkage between lisp and the native library is broken?
>
> > Any help resolving this issue would be greatly appreciated. I'm pretty
> > much at my wit's end and I'd rather not go back to programming in
> > Java.
>
> > Thanks,
> > Gene
>
> > PS. I've previously posted to the clsql news group yet have received
> > no response in more than a week. Hence, I am trying here.
>
> hi,
> this isn't exactly the answer you might be looking for, but seeing as
> you're using PostgreSQL it might be ok to mention that i've found
> Postmodern to work great in that context:
> *http://common-lisp.net/project/postmodern/
>
> --
> Lars Rune Nøstdalhttp://nostdal.org/
>
> AJAX/Comet GUI type stuff for Common Lisp:http://groups.google.com/group/symbolicweb

Thank you Lars! I wasn't intending to use PostgreSQL as I have more
experience with MySQL, but 1) I got the exact same errors with it, and
2) found more people using PostgreSQL so I thought I'd follow the
herd.

I tried Postmodern and it worked like a champ (even defined a prepared
statement).

Thanks again - this is a load off my mind.

Gene

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode