Google Groups Home
Help | Sign in
How to notify JBoss J2EE application in a trigger or rule???
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  2 messages - Collapse all
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
Markus Schaber  
View profile
 More options Jun 22 2006, 7:04 am
Newsgroups: pgsql.interfaces.jdbc
From: sch...@logix-tt.com (Markus Schaber)
Date: Thu, 22 Jun 2006 13:04:21 +0200
Local: Thurs, Jun 22 2006 7:04 am
Subject: Re: How to notify JBoss J2EE application in a trigger or rule???
Hi, Hoost,

Joost Kraaijeveld wrote:
> I want a PostgreSQL trigger or rule that notifies a JBoss deployed J2EE
> application of a certain event.

> I was hoping that pljava would work, but for some -yet unknown to me-
> reason, it does not work on my Debian AMD64 with Sun 1.5.0-7 JVM.

> Does anyone have an (working???) example or a pointer to an example of
> how to do this?

Hmm, did you try the GCJ-based pljava variant?

And, as an workaround, have an extra bean sitting in the JBoss that
LISTENs, and the trigger in SQL simply NOTIFYing it?

HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Discussion subject changed to "How to notify JBoss J2EE application in a trigger or" by Markus Schaber
Markus Schaber  
View profile
 More options Jun 22 2006, 7:34 am
Newsgroups: pgsql.interfaces.jdbc
From: sch...@logix-tt.com (Markus Schaber)
Date: Thu, 22 Jun 2006 13:34:56 +0200
Local: Thurs, Jun 22 2006 7:34 am
Subject: Re: How to notify JBoss J2EE application in a trigger or
Hi, Joost,

Joost Kraaijeveld wrote:
>>> Does anyone have an (working???) example or a pointer to an example of
>>> how to do this?
>> Hmm, did you try the GCJ-based pljava variant?
> No, I did not. As far as I know, I *must* use the Sun JVM for JBoss, and
> I don't know if and how I can mix the GJC and Sun Java environment. Is
> that possible with (almost) no hassle and readme's?

I guess that you want to use CORBA or Java Remote Interface between
PostgreSQL and JBoss, and those should abstract between differend JVMs.

>> And, as an workaround, have an extra bean sitting in the JBoss that
>> LISTENs, and the trigger in SQL simply NOTIFYing it?
> Can you elaborate on that? What do you mean with LISTEN and NOTIFY?

http://www.postgresql.org/docs/8.1/interactive/sql-listen.html
http://www.postgresql.org/docs/8.1/interactive/sql-notify.html

HTH,
Markus

--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2008 Google