From: joaoaafonso at gmail.com (Joao Afonso)
Date: Tue, 5 Jul 2005 19:03:52 +0100
Subject: [Pljava-dev] Triggerdata questions
Message-ID: <ce04e69f050705110339fc5c9e@mail.gmail.com>

  Hi everyone,

  I have a number of tables in a db, let's call it Main, which are a
replication of tables that are in other databases (more than one). All
the tables in db Main are empty, they are just used for front end
access and defining the relations that may exist between the tables
from the different databases.

  When an insert (for ex.) is issued to db Main a trigger is fired
that calls a java function that supposedly would re-issue the insert
to the real db. But i don't know how this can be done. Using the
triggerdata passed to my function i tried the following:

  (being td the Triggerdata received by the function)     

  Statement stat = (td.getNew()).getStatement();

  The function always throws a nullPointerException. From what i've
read, the resultSet returned by .getNew() is always null on inserts
and deletes, so this must be where the exception comes from, but even
on an update the resultSet seems to be returning a null value.

  And what i want to ask you is if you think this can be done this
way? If so, what am i doing wrong? If not, do you see another
solution?

  Thanks in advance.