cl-rdbms-devel

Download

cl-rdbms-devel@lists.common-lisp.net

December 2010

1 participants
1 discussions

Re: [cl-rdbms-devel] hu.dwim.rdbms.oracle-timestamp-with-timezone-local-time-bug
by Marshall McLuhan 14 Dec '10

14 Dec '10

hello No more bugs. Right now I'm rewriting the application around simple sql statements, that's why I guess. As for the oracle setup, you did not ask and it's pretty late but maybe the following helps. I used the instructions that can be found here: http://blog.cachemiss.com/articles/Installing%20Oracle%20XE%20on%20Debian%2… Make sure you download the right files (no large files required) and don't forget to link to the server's tnsnames.ora file. On my system, things look this way. Good luck and once more thank you. Regards, chris ~$ uname -a Linux catch22 2.6.32-3-amd64 #1 SMP Wed Feb 24 18:07:42 UTC 2010 x86_64 GNU/Linux (debian) ~$ cat ~/.bashrc .. export ORACLE_HOME=~/usr/instantclient_10_2 export XE=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server export ORACLE_SID=XE export LD_LIBRARY_PATH=~/lib:/lib:/usr/lib:/usr/local/lib:~/usr/instantclient_10_2:$XE/lib export PATH=~/bin:~/usr/instantclient_10_2:$XE/bin:/usr/local/bin:/usr/local/sbin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/bin/X11:/usr/games export ORACLE_USERID='chris/woirgend' export ORACLE_DSN='dbi:Oracle:XE' export TNS_ADMIN=~/usr/instantclient_10_2/network/admin .. chris@catch22:~/usr/instantclient_10_2$ pwd /home/chris/usr/instantclient_10_2 chris@catch22:~/usr/instantclient_10_2$ ls -alsh insgesamt 109M 4,0K drwxr-xr-x 4 chris chris 4,0K 1. Nov 17:27 . 4,0K drwxr-xr-x 25 chris chris 4,0K 1. Nov 18:38 .. 4,0K -rw-r--r-- 1 chris chris 228 26. Okt 20:55 BASIC_README 1,6M -r--r--r-- 1 chris chris 1,6M 26. Okt 20:55 classes12.jar 0 lrwxrwxrwx 1 chris chris 56 1. Nov 17:27 ctx -> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/ 76K -rwxr-xr-x 1 chris chris 70K 26. Okt 20:55 genezi 4,0K -r--r--r-- 1 chris chris 1,5K 26. Okt 20:55 glogin.sql 0 lrwxrwxrwx 1 chris chris 57 1. Nov 17:27 ldap -> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ldap/ 25M -rwxr-xr-x 1 chris chris 25M 26. Okt 20:55 libclntsh.so.10.1 7,6M -r-xr-xr-x 1 chris chris 7,5M 26. Okt 20:55 libnnz10.so 1,6M -rwxr-xr-x 1 chris chris 1,6M 26. Okt 20:55 libocci.so.10.1 70M -rwxr-xr-x 1 chris chris 70M 26. Okt 20:55 libociei.so 152K -r-xr-xr-x 1 chris chris 147K 26. Okt 20:55 libocijdbc10.so 1,4M -r-xr-xr-x 1 chris chris 1,4M 26. Okt 20:55 libsqlplusic.so 1,3M -r-xr-xr-x 1 chris chris 1,3M 26. Okt 20:55 libsqlplus.so 4,0K -rw-r--r-- 1 chris chris 140 26. Okt 20:55 linkora.sh 4,0K lrwxrwxrwx 1 chris chris 78 1. Nov 16:23 listener.ora -> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora 4,0K drwxr-xr-x 3 chris chris 4,0K 1. Nov 17:27 network 1,6M -r--r--r-- 1 chris chris 1,5M 26. Okt 20:55 ojdbc14.jar 4,0K drwxr-xr-x 4 chris chris 4,0K 26. Okt 20:55 sdk 4,0K -rw-r----- 1 chris chris 2,2K 1. Nov 16:21 sqlnet.log 12K -r-xr-xr-x 1 chris chris 9,1K 26. Okt 20:55 sqlplus 4,0K -rw-r--r-- 1 chris chris 232 26. Okt 20:55 SQLPLUS_README 4,0K lrwxrwxrwx 1 chris chris 78 1. Nov 16:03 tnsnames.ora -> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/tnsnames.ora chris@catch22:~$ cat ~/code/lisp-tp/hu-dwim/hu.dwim.rdbms/source/oracle/backend.lisp ;;; -*- mode: Lisp; Syntax: Common-Lisp; -*- ;;; ;;; Copyright (c) 2006 by the authors. ;;; ;;; See LICENCE for details. (in-package :hu.dwim.rdbms.oracle) (cffi:define-foreign-library (oracle-oci :search-path ; #P"/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/" #P"/home/chris/usr/instantclient_10_2/" ) (:unix "libocci.so.10.1") (:windows "libocixe.dll") (t (:default "libocci")) ) ;;;;;; ;;; Backend API .. -----Ursprüngliche Nachricht----- Von: Attila Lendvai <attila.lendvai(a)gmail.com> Gesendet: Fr 26.11.2010 09:55 An: Marshall McLuhan <marshall.mcluhan(a)gmx.net>; CC: cl-rdbms-devel(a)common-lisp.net; Betreff: Re: [cl-rdbms-devel] hu.dwim.rdbms.oracle-timestamp-with-timezone-local-time-bug hi! > How do I handle such thing most efficiently? Should I report them at all? definitely, all bug reports are very welcome! for the record, i've starred your mail, but i've failed to install oracle in the 2 hours i'm willing to invest into oracle for now. hopefully others could come up with suggestions, or oracle makes sure that their monster can be installed on a 64bit ubuntu with reasonable effort. -- attila !DSPAM:4d07f46448583216624486!

1 0