platform: x86
lisp version: dev-lisp/sbcl-1.0 USE="doc ldb source threads unicode"
uffi version: dev-lisp/cl-uffi-1.5.16 USE=""
cl-sql version: dev-lisp/cl-sql-3.7.7 USE="mysql odbc postgres -sqlite -sqlite3"
lisp init: dev-lisp/gentoo-init-0.1
I am using cl-sql to talk to oracle databases (mostly 9i, 10g too).
When I use the tarball from Kevin Rosenberg's site, cl-sql works fine
for oracle when loaded in this way:
(eval-when (:compile-toplevel)
(push #P"/usr/share/common-lisp/source/md5/" asdf:*central-registry*) ;; necessary?
(push #P"/usr/share/common-lisp/source/uffi/" asdf:*central-registry*)
(push #P"/usr/share/common-lisp/source/clsql/" asdf:*central-registry*)
(asdf:operate 'asdf:load-op 'uffi)
(asdf:operate 'asdf:load-op 'clsql-oracle))
But the portage version of cl-sql does not work for oracle. If it
does, it must be different somehow. Is the portage version of cl-sql
supposed to work with oracle? What am I doing wrong?
I notice there are cl-sql USE flags for every database engine except
oracle. Should I be using the ODBC component of cl-sql or something?
Simply grepping for symbol names reveals significant differences in
teh tarball source vs. the portage source:
# portage version:
root@sphinktoo:/usr/share/common-lisp/source# grep -nr -e 'clsql-oracle' *
clsql/sql/fddl.lisp:97: ;; Fixme: move to clsql-oracle
clsql/sql/fddl.lisp:99: (when (and (find-package 'clsql-oracle)
clsql/sql/fddl.lisp:103: (symbol-name '#:clsql-oracle)))))
# tarball version:
root@hly20666lx:/usr/share/common-lisp/source# grep -nr -e 'clsql-oracle' *
clsql/doc/appendix.xml:763: prior to loading the <filename>clsql-oracle</filename> &asdf;
clsql/doc/appendix.xml:767: (asdf:operate 'asdf:load-op 'clsql-oracle)
clsql/doc/appendix.xml:776:(asdf:operate 'asdf:load-op 'clsql-oracle)
clsql/sql/fddl.lisp:97: ;; Fixme: move to clsql-oracle
clsql/sql/fddl.lisp:99: (when (and (find-package 'clsql-oracle)
clsql/sql/fddl.lisp:103: (symbol-name '#:clsql-oracle)))))
clsql/db-oracle/oracle-constants.lisp:17:(in-package #:clsql-oracle)
clsql/db-oracle/oracle-api.lisp:17:(in-package #:clsql-oracle)
clsql/db-oracle/oracle-sql.lisp:16:(in-package #:clsql-oracle)
clsql/db-oracle/oracle-objects.lisp:16:(in-package #:clsql-oracle)
clsql/db-oracle/oracle-package.lisp:19:(defpackage #:clsql-oracle
clsql/db-oracle/oracle-loader.lisp:17:(in-package #:clsql-oracle)
clsql/db-oracle/oracle-loader.lisp:47: :module "clsql-oracle"
clsql/db-oracle/foreign-resources.lisp:14:(in-package #:clsql-oracle)
clsql/clsql-oracle.asd:5:;;;; Name: clsql-oracle.asd
clsql/clsql-oracle.asd:10:;;;; $Id: clsql-oracle.asd 9476 2004-05-25 08:41:56Z kevin $
clsql/clsql-oracle.asd:19:(defpackage #:clsql-oracle-system (:use #:asdf #:cl))
clsql/clsql-oracle.asd:20:(in-package #:clsql-oracle-system)
clsql/clsql-oracle.asd:24:(defsystem clsql-oracle
clsql/clsql-oracle.asd:25: :name "clsql-oracle"
Carlos Konstanski