From owner-freebsd-questions  Tue Dec 23 17:47:03 1997
Return-Path: <owner-freebsd-questions>
Received: (from root@localhost)
          by hub.freebsd.org (8.8.7/8.8.7) id RAA29547
          for questions-outgoing; Tue, 23 Dec 1997 17:47:03 -0800 (PST)
          (envelope-from owner-freebsd-questions)
Received: from cam.grad.kiev.ua (grad-UTC-28k8.ukrtel.net [195.5.25.54])
          by hub.freebsd.org (8.8.7/8.8.7) with ESMTP id RAA29516
          for <questions@freebsd.org>; Tue, 23 Dec 1997 17:46:20 -0800 (PST)
          (envelope-from Ruslan@Shevchenko.kiev.ua)
Received: from Shevchenko.kiev.ua (localhost [127.0.0.1])
	by cam.grad.kiev.ua (8.8.8/8.8.5) with ESMTP id DAA10585;
	Tue, 23 Dec 1997 03:44:08 GMT
Message-ID: <349F3381.CB89393E@Shevchenko.kiev.ua>
Date: Tue, 23 Dec 1997 03:44:04 +0000
From: Ruslan Shevchenko <Ruslan@Shevchenko.kiev.ua>
X-Mailer: Mozilla 4.04 [en] (X11; I; FreeBSD 2.2.5-STABLE i386)
MIME-Version: 1.0
To: Jeffrey Auerbach <jeff@starmedia.net>
CC: questions@freebsd.org
Subject: Re: oracle client for FreeBSD
References: <3.0.1.32.19971223162501.009529c0@officemail.starmedia.net>
Content-Type: text/plain; charset=koi8-r
Content-Transfer-Encoding: 7bit
Sender: owner-freebsd-questions@freebsd.org
X-Loop: FreeBSD.org
Precedence: bulk

Jeffrey Auerbach wrote:

> Are there any oracle DB clients for FreeBSD?  IS there any software that I
> can use to connect to my Oracle DB (incidentally is on Solaris)?
>

1. Directly:   (i.e. without middleware)
   1.1 Using  java think driver by Oracle.
       - :
         a) (Bad handling of International characters, sometime driver retry
errors
          "Can not convert character XX ")
         b) Very low performance of java code.
   1.2. Using SCO emulator.
          (try search in freebsd mailing lists about Oracle, you wil find a
guy,
           which run Oracle)
       -:
          a) You need SCO libs
          b) You must to do all on top of SCO emulator, i. e. native FreeBSD
code
               is not work.

2. Indirectly,
      Using middleware apps, which run on ORACLE  server.
       1.  If you develop custom app, then simple transfer information from
database
            from you server by socket connection.
       2.  You can use perl::DBD::net
             (requiare some hacking)
       3. You can use CORBA ORB.
             (it is as 1, but cleaner)
       4. If you need to provide info from database to WWW, then
            fastcgi-cgi bridge is for you.
              (details on http://www.fastcgi.com)
             I was used this tehnology, for me work quite well.
      5.  If you need to run you ORACLE apps on FreeBSD --- now I work
           under RPC-Oracle bridge.  It consists from server on the mashine
           with native ORACLE client and client library on FreeBSD, which
           provide standart OCI interface. It mean, that if you have existing

           applications, writeln for ORACLE on C or C++ or oraperl, than you
           can recompile it under FreeBSD without any changes
         (one limitation --- I support only  deferred mode)

         But I can not say, when it would be finished,
           becouse now I have many other work and development
           (in background mode) temporary stopped.
           Now cdemo2 work fine ;)

         If I will return to this stuff after holidays, than, I think near
.02.98
         full interface would be released.

    Yet one tip:
        Middleware solutions have better performace, in general, becouse
       native ORACLE clients are very big, and start slow. If you will run
native
       ORACLE client as persistent service, and will start light client on
       request,  it would be faster, then starting ORACLE client on each
       request.


> Jeffrey Auerbach
> Director of Technical Operations
> StarMedia Network
> (212)548-9618
> http://www.starmedia.com