[Pljava-dev] NPE using existing TriggerData ResultSet

Hi,

I was trying to use the existing postgresql connection from TriggerData
in Trigger function trying to write some data back to postgresql (in
another table) by using:

public static void triggerFunction(TriggerData td)
{
.
ResultSet _rsnew = td.getNew();
.
.
.
function(_rsnew.getStatement().getConnection()); //<========= (NPE here)
.
.
}

private static function (java.sql.Connection conn)
{
.
.
.
}

However, I am getting NPE at statement
"_renew.getStatement().getConnection()".

Is this a bug? Do you have another solution to reuse existing postgresql
connection?

Thanks a lot for helping.

Regards,
Kong

No, that's not a bug. There's no statement associated with the ResultSet
obtained from TriggerData. The statement:

Connection conn = DriverManager.getConnection("jdbc:default:connection");

will always return the current (i.e. the existing postgresql) connection.

- thomas

kstian wrote:

> Hi,
>
> I was trying to use the existing postgresql connection from
> TriggerData in Trigger function trying to write some data back to
> postgresql (in another table) by using:
>
> public static void triggerFunction(TriggerData td)
> {
> .
> ResultSet _rsnew = td.getNew();
> .
> .
> .
> function(_rsnew.getStatement().getConnection()); //<========= (NPE
> here)
> .
> .
> }
>
>
> private static function (java.sql.Connection conn)
> {
> .
> .
> .
> }
>
> However, I am getting NPE at statement
> "_renew.getStatement().getConnection()".
>
> Is this a bug? Do you have another solution to reuse existing
> postgresql connection?
>
> Thanks a lot for helping.
>
> Regards,
> Kong
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev