Oracle on Linux

[Chaitanya Chalasani]

On Monday 29 May 2006 23:59, Sebastian Bello wrote:
> An additional question:
> 4- how do you handle transactions?
Transactions are not possible with the way we are using. Auto commit has been 
enabled.

We load the mnesia database on startup and the application runs on mnesia 
while non realtime update/delete/insert queries are sent to oracle for MIS 
purpose. Though oracle lags behind during peak traffic it copes up once the 
traffic is low. 

>     Sebastian-
>
> ----- Original Message -----
> From: "Sebastian Bello" <sebastian@REDACTED>
> To: "Chaitanya Chalasani" <chaitanya@REDACTED>
> Cc: "Erlang Questions" <erlang-questions@REDACTED>
> Sent: Friday, May 26, 2006 11:20 AM
> Subject: Re: Oracle on Linux
>
> > Chaitanya,
> >
> > thanks for the source code.
> >
> > Some additional questions:
> > 1- do you use multiple connections to Oracle? How would/do you manage it
> > (resolved in the C++ class or with multiples ports)?
> > 2- how do you encode/decode responses (mainly in the case of SELECT
> > statements)? Do you read responses at the Erlang side as binaries and
> > then create the corresponding Erlang datatypes, or do you use ei to
> > generate Erlang datatypes on the C side?
> > 3- how do you multiplex queries (use for example a PID  to identify the
> > requester and return the response to it)?
> >
> > Thank you very much for your help!
> > Regards,
> >     Sebastian-
> >
> >
> > ----- Original Message -----
> > From: "Chaitanya Chalasani" <chaitanya@REDACTED>
> > To: "Joel Reymont" <joelr1@REDACTED>
> > Cc: "Erlang Questions" <erlang-questions@REDACTED>
> > Sent: Wednesday, May 24, 2006 1:44 AM
> > Subject: Re: Oracle on Linux
> >
> > > On Thursday 18 May 2006 15:57, Chaitanya Chalasani wrote:
> > > > On Tuesday 02 May 2006 15:30, Joel Reymont wrote:
> > > > > Folks,
> > > > >
> > > > > Is anyone using Oracle with Erlang on Linux? Are you using a
> > > > > commercial ODBC driver?
> > > > >
> > > > > I'm ideally looking for an OCI binding or a free Linux ODBC driver.
> > > > >
> > > > > Thanks, Joel
> > > > >
> > > > > --
> > > > > http://wagerlabs.com/
> > > >
> > > > I am away from my office all there days. The day I am back I will
>
> share
>
> > the
> >
> > > > source. I have already got the nod from my manager.:)
> > >
> > > The attachment is the c++ code of occi interface that acts as port
> >
> > executable.
> >
> > > Sorry for the delay

-- 
CHAITANYA CHALASANI
MEMBER - TECHNICAL TEAM
PYRO NETWORKS PVT LTD
MOBILE: +919849901241
URL: www.pyronetworks.com