Re: find-and-load-foreign-library and Oracle

--===============1132045995==
Content-Type: multipart/alternative; 
	boundary="----=_Part_105268_27455217.1184936491443"

------=_Part_105268_27455217.1184936491443
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On 7/19/07, Kevin Rosenberg <kevin-HJRc7zDS/[email protected]> wrote:
>
> Ricardo Boccato Alves wrote:
> > I think it is in the oracle-loader.lisp at the definition of
> > *oracle-client-library-filenames*. This variable is passed to
> > find-and-load-foreign-library at the method
> > clsql-sys:database-type-load-foreign (the last one defined in that file.
>
> Yes, that looks promising. It appears the Oracle backend was left out
> when the change was made to use the OS to find libraries in the
> default location that the OS will check. However, I'm not sure if
> Oracle typically does puts their library directories the list of
> library directories that the OS checks. I know they typically use the
> ORACLE_HOME enviromental variable as a base to their the library
> directories.
>
> If you're using Linux, would you check if Oracle puts their library
> directory in /etc/ld.so.conf file or the LD_LIBRARY_PATH. Or, if
> you're using Windows, if the Oracle library location is in the PATH
> environmental variable.


In my linux (ubuntu 7.04 - Oracle 10g Express)
it doesn't put the library directory in /etc/ld.so.conf or LD_LIBRARY_PATH.
It sets the ORACLE_HOME directory (in my machine:
"/usr/lib/oracle/xe/app/oracle/product/10.2.0/server") and I know the
library path is "/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/"
since I used to do a (push-library-path ...) using it.

In windows (xp - Oracle 9i.2 (just the client)) the PATH contains
"C:\oracle\ora92\bin" and I don't have a ORACLE_HOME variable set.

[]s,
Ricardo Boccato Alves.

------=_Part_105268_27455217.1184936491443
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<span class="gmail_quote">On 7/19/07, <b class="gmail_sendername">Kevin Rosenberg</b> &lt;<a href="mailto:kevin-HJRc7zDS/[email protected]" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">kevin-HJRc7zDS/[email protected]</a>&gt; wrote:
</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Ricardo Boccato Alves wrote:<br>&gt; I think it is in the oracle-loader.lisp at the definition of<br>&gt; *oracle-client-library-filenames*. This variable is passed to<br>&gt; find-and-load-foreign-library at the method<br>

&gt; clsql-sys:database-type-load-foreign (the last one defined in that file.<br><br>Yes, that looks promising. It appears the Oracle backend was left out<br>when the change was made to use the OS to find libraries in the
<br>default location that the OS will check. However, I&#39;m not sure if<br>Oracle typically does puts their library directories the list of<br>library directories that the OS checks. I know they typically use the<br>ORACLE_HOME enviromental variable as a base to their the library
<br>directories.<br><br>If you&#39;re using Linux, would you check if Oracle puts their library<br>directory in /etc/ld.so.conf file or the LD_LIBRARY_PATH. Or, if<br>you&#39;re using Windows, if the Oracle library location is in the PATH
<br>environmental variable.</blockquote><div><br>In&nbsp;my&nbsp;linux&nbsp;(ubuntu 7.04 - Oracle 10g Express) it&nbsp;doesn&#39;t&nbsp;put&nbsp;the&nbsp;library&nbsp;directory&nbsp;in&nbsp;/etc/ld.so.conf&nbsp;or&nbsp;LD_LIBRARY_PATH. It sets the ORACLE_HOME directory (in my machine: &quot;/usr/lib/oracle/xe/app/oracle/product/10.2.0/server&quot;)&nbsp;and&nbsp;I know the library path is &quot;/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/&quot; since I used to do a (push-library-path ...) using it.
<br><br>In windows (xp - Oracle 9i.2 (just the client)) the PATH contains &quot;C:\oracle\ora92\bin&quot; and I don&#39;t have a ORACLE_HOME variable set.<br>
</div><br>[]s,<br>Ricardo Boccato Alves.<br>

------=_Part_105268_27455217.1184936491443--

--===============1132045995==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
CLSQL-Devel mailing list
[email protected]
http://lists.b9.com/mailman/listinfo/clsql-devel

--===============1132045995==--