<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html>
<head>
<meta name="Generator" content="Zarafa WebAccess v6.20.4-14107">
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<title>Re: [cl-rdbms-devel] hu.dwim.rdbms.oracle-timestamp-with-timezone-local-time-bug</title>
<style type="text/css">
body
{
font-family: Arial, Verdana, Sans-Serif;
font-size: 12px;
padding: 5px 5px 5px 5px;
margin: 0px;
border-style: none;
background-color: #ffffff;
}
p, ul, li
{
margin-top: 0px;
margin-bottom: 0px;
}
</style>
</head>
<body>
<p>hello</p><p><br />No more bugs. Right now I'm rewriting the application around simple sql statements, that's why I guess.<br />As for the oracle setup, you did not ask and it's pretty late but maybe the following helps.<br /><br />I used the instructions that can be found here: http://blog.cachemiss.com/articles/Installing%20Oracle%20XE%20on%20Debian%20AMD64.pod<br />Make sure you download the right files (no large files required) and don't forget to link to the server's tnsnames.ora file.<br /><br />On my system, things look this way. Good luck and once more thank you.<br /><br />Regards,<br />chris<br /><br />~$ uname -a<br />Linux catch22 2.6.32-3-amd64 #1 SMP Wed Feb 24 18:07:42 UTC 2010 x86_64 GNU/Linux (debian)<br /><br />~$ cat ~/.bashrc<br /><br />...<br /><br />export ORACLE_HOME=~/usr/instantclient_10_2<br />export XE=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server<br />export ORACLE_SID=XE<br />export LD_LIBRARY_PATH=~/lib:/lib:/usr/lib:/usr/local/lib:~/usr/instantclient_10_2:$XE/lib<br />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 <br />export ORACLE_USERID='chris/woirgend'<br />export ORACLE_DSN='dbi:Oracle:XE'<br />export TNS_ADMIN=~/usr/instantclient_10_2/network/admin<br /><br />...<br /><br />chris@catch22:~/usr/instantclient_10_2$ pwd<br />/home/chris/usr/instantclient_10_2<br /><br /><br />chris@catch22:~/usr/instantclient_10_2$ ls -alsh<br />insgesamt 109M<br />4,0K drwxr-xr-x 4 chris chris 4,0K 1. Nov 17:27 .<br />4,0K drwxr-xr-x 25 chris chris 4,0K 1. Nov 18:38 ..<br />4,0K -rw-r--r-- 1 chris chris 228 26. Okt 20:55 BASIC_README<br />1,6M -r--r--r-- 1 chris chris 1,6M 26. Okt 20:55 classes12.jar<br /> 0 lrwxrwxrwx 1 chris chris 56 1. Nov 17:27 ctx -> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/<br /> 76K -rwxr-xr-x 1 chris chris 70K 26. Okt 20:55 genezi<br />4,0K -r--r--r-- 1 chris chris 1,5K 26. Okt 20:55 glogin.sql<br /> 0 lrwxrwxrwx 1 chris chris 57 1. Nov 17:27 ldap -> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ldap/<br /> 25M -rwxr-xr-x 1 chris chris 25M 26. Okt 20:55 libclntsh.so.10.1<br />7,6M -r-xr-xr-x 1 chris chris 7,5M 26. Okt 20:55 libnnz10.so<br />1,6M -rwxr-xr-x 1 chris chris 1,6M 26. Okt 20:55 libocci.so.10.1<br /> 70M -rwxr-xr-x 1 chris chris 70M 26. Okt 20:55 libociei.so<br />152K -r-xr-xr-x 1 chris chris 147K 26. Okt 20:55 libocijdbc10.so<br />1,4M -r-xr-xr-x 1 chris chris 1,4M 26. Okt 20:55 libsqlplusic.so<br />1,3M -r-xr-xr-x 1 chris chris 1,3M 26. Okt 20:55 libsqlplus.so<br />4,0K -rw-r--r-- 1 chris chris 140 26. Okt 20:55 linkora.sh<br />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<br />4,0K drwxr-xr-x 3 chris chris 4,0K 1. Nov 17:27 network<br />1,6M -r--r--r-- 1 chris chris 1,5M 26. Okt 20:55 ojdbc14.jar<br />4,0K drwxr-xr-x 4 chris chris 4,0K 26. Okt 20:55 sdk<br />4,0K -rw-r----- 1 chris chris 2,2K 1. Nov 16:21 sqlnet.log<br /> 12K -r-xr-xr-x 1 chris chris 9,1K 26. Okt 20:55 sqlplus<br />4,0K -rw-r--r-- 1 chris chris 232 26. Okt 20:55 SQLPLUS_README<br />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<br /><br /><br />chris@catch22:~$ cat ~/code/lisp-tp/hu-dwim/hu.dwim.rdbms/source/oracle/backend.lisp<br />;;; -*- mode: Lisp; Syntax: Common-Lisp; -*-<br />;;;<br />;;; Copyright (c) 2006 by the authors.<br />;;;<br />;;; See LICENCE for details.<br /><br />(in-package :hu.dwim.rdbms.oracle)<br /><br />(cffi:define-foreign-library<br /> (oracle-oci :search-path<br />; #P"/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/"<br /> #P"/home/chris/usr/instantclient_10_2/"<br /> )<br /> (:unix "libocci.so.10.1")<br /> (:windows "libocixe.dll")<br /> (t (:default "libocci"))<br /> )<br /><br />;;;;;;<br />;;; Backend API<br /><br />...</p><blockquote style="border-left: 2px solid rgb(50, 95, 186); padding-left: 5px; margin-left: 5px;">-----Ursprüngliche Nachricht-----<br /><strong>Von:</strong> Attila Lendvai <attila.lendvai@gmail.com><br /><strong>Gesendet:</strong> Fr 26.11.2010 09:55<br /><strong>An:</strong> Marshall McLuhan <marshall.mcluhan@gmx.net>; <br /><strong>CC:</strong> cl-rdbms-devel@common-lisp.net; <br /><strong>Betreff:</strong> Re: [cl-rdbms-devel] hu.dwim.rdbms.oracle-timestamp-with-timezone-local-time-bug<br /><br />hi!<br /><br />> How do I handle such thing most efficiently? Should I report them at all?<br /><br />definitely, all bug reports are very welcome!<br /><br />for the record, i've starred your mail, but i've failed to install<br />oracle in the 2 hours i'm willing to invest into oracle for now.<br /><br />hopefully others could come up with suggestions, or oracle makes sure<br />that their monster can be installed on a 64bit ubuntu with reasonable<br />effort.<br /><br />-- <br /> attila<br /><br /><br /><br /><br /></blockquote>
!DSPAM:4d07f46448583216624486!
</body>
</html>