Hi All,

basically I've got a java server listening on specified port; within
Oracle triggers I use UTL_TCP package to send columns data that changed
to the server.

is there any other than UTL_TCP used within oracle triggers solution to
talk to Java deamon?

before i start implementing i'd like to find out other alternatives.

thanks

best regards
schw

just to add something, the server is always running on the same machine
as oracle.


schw wrote:
> Hi All,
>
> basically I've got a java server listening on specified port; within
> Oracle triggers I use UTL_TCP package to send columns data that changed
> to the server.
>
> is there any other than UTL_TCP used within oracle triggers solution to
> talk to Java deamon?
>
> before i start implementing i'd like to find out other alternatives.
>
> thanks
>
> best regards
> schw

schw schreef:

> just to add something, the server is always running on the same machine
> as oracle.
>
>
> schw wrote:
> > Hi All,
> >
> > basically I've got a java server listening on specified port; within
> > Oracle triggers I use UTL_TCP package to send columns data that changed
> > to the server.
> >
> > is there any other than UTL_TCP used within oracle triggers solution to
> > talk to Java deamon?
> >
> > before i start implementing i'd like to find out other alternatives.
> >
> > thanks
> >

What is this daemon doing with the data it gets presented?

basically it passes it over to other servers


Frank van Bortel wrote:
> schw schreef:
>
> > just to add something, the server is always running on the same machine
> > as oracle.
> >
> >
> > schw wrote:
> > > Hi All,
> > >
> > > basically I've got a java server listening on specified port; within
> > > Oracle triggers I use UTL_TCP package to send columns data that changed
> > > to the server.
> > >
> > > is there any other than UTL_TCP used within oracle triggers solution to
> > > talk to Java deamon?
> > >
> > > before i start implementing i'd like to find out other alternatives.
> > >
> > > thanks
> > >
>
> What is this daemon doing with the data it gets presented?

"schw" <schwartz@alpha.net.pl> wrote in message
news:1156494426.258935.228940@i3g2000cwc.googlegro ups.com...
> Hi All,
>
> basically I've got a java server listening on specified port; within
> Oracle triggers I use UTL_TCP package to send columns data that changed
> to the server.
>
> is there any other than UTL_TCP used within oracle triggers solution to
> talk to Java deamon?
>
> before i start implementing i'd like to find out other alternatives.
>
> thanks
>
> best regards
> schw
>
You want to be careful. The way you propose to implement you will passon
data that may not exist. For example,
insert x data
utl_tcp sends data
client issues rollback;
now you are out of synch.

Instead wrap the ult_tcp into a package and call dbms_job to run once
immediately. The dbms_job won't run if there is a rollback only if there is
a commit. (see asktom.oracle.com)
Jim

schw wrote:
> Hi All,
>
> basically I've got a java server listening on specified port; within
> Oracle triggers I use UTL_TCP package to send columns data that changed
> to the server.
>
> is there any other than UTL_TCP used within oracle triggers solution to
> talk to Java deamon?
>
> before i start implementing i'd like to find out other alternatives.
>
> thanks
>
> best regards
> schw

No version number and you really do need to stop top posting.

But other than that I'd suggest you look at Advanced Queuing and
specifically the implementation of JMS messaging.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org