Re: [JBoss-user] Challenge for EJB-QL, JBossQL, or declared SQL?

2003-11-06 Thread harm
Doesn't 'ORDER BY' help you?




Darren Hartford [EMAIL PROTECTED] 
Sent by: [EMAIL PROTECTED]
11/05/2003 04:10 PM
Please respond to
[EMAIL PROTECTED]


To
[EMAIL PROTECTED]
cc

Subject
[JBoss-user] Challenge for EJB-QL, JBossQL, or declared SQL?






Hey all,
I got an interesting problem that I should think some of you may have 
already come across in some fashion or another.  I want to do a search to 
return a collection of objects, but it needs to be very specific as 
follows:

Example table:
batchnumber | sequence | receive_date | town | item | status
with example values:
1,1,11/5/2003,MONTREAL,widget, INVENTORY
1,2,11/5/2003,MONTREAL,widget, FRONT
1,3,11/5/2003,MONTREAL,widget, INVENTORY
2,1,11/5/2003,MONTREAL,foo, FRONT
3,1,11/5/2003,MONTREAL,bar, FRONT
3,2,11/5/2003,MONTREAL,bar, SOLD
4,1,11/5/2003,TORONTO,bar, FRONT
5,1,11/6/2003,MONTREAL,bar, INVENTORY

What I would like is the **last sequence-per-batchnumber** for results 
based on a search.
example psuedo-query:
SELECT OBJECT(o) WHERE ((o.town = MONTREAL) AND (o.receive_date = 
11/5/2003))
would return:
1,3,11/5/2003,MONTREAL,widget, INVENTORY
2,1,11/5/2003,MONTREAL,foo, FRONT
3,2,11/5/2003,MONTREAL,bar, SOLD

And another psuedo-query:
SELECT OBJECT(o) WHERE (o.item = bar) 
would return:
3,2,11/5/2003,MONTREAL,bar, SOLD
4,1,11/5/2003,TORONTO,bar, FRONT
5,1,11/6/2003,MONTREAL,bar, INVENTORY

Based on JBoss 3.2.2 and Mysql 3.23, could EJB-QL, JBossQL, or some type 
of declared SQL be able to solve this? An example pretty please!

Thanks everyone!
-D


---
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  Does it
help you create better code?   SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user




---
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  Does it
help you create better code?   SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] AOP framework documentation

2003-11-06 Thread harm
Dear JBoss team,

Is there a printable version of the AOP documentation?
I have bought the yearly subscription but cannot find anything related to 
the AOP framework...

Thanks,

Harm de Laat
Informatiefabriek
The Netherlands



---
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  Does it
help you create better code?   SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


RE: [JBoss-user] Challenge for EJB-QL, JBossQL, or declared SQL?

2003-11-06 Thread Stephane Nicoll
I am not sure ORDER BY is allowed (what about caching then?)
I know EJB QL does not allow that. Maybe JBoss QL.

Regards,

Stephane

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 06, 2003 9:24 AM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Challenge for EJB-QL, JBossQL, or declared
SQL?


Doesn't 'ORDER BY' help you?




Darren Hartford [EMAIL PROTECTED] 
Sent by: [EMAIL PROTECTED]
11/05/2003 04:10 PM
Please respond to
[EMAIL PROTECTED]


To
[EMAIL PROTECTED]
cc

Subject
[JBoss-user] Challenge for EJB-QL, JBossQL, or declared SQL?






Hey all,
I got an interesting problem that I should think some of you may have 
already come across in some fashion or another.  I want to do a search to 
return a collection of objects, but it needs to be very specific as 
follows:

Example table:
batchnumber | sequence | receive_date | town | item | status
with example values:
1,1,11/5/2003,MONTREAL,widget, INVENTORY
1,2,11/5/2003,MONTREAL,widget, FRONT
1,3,11/5/2003,MONTREAL,widget, INVENTORY
2,1,11/5/2003,MONTREAL,foo, FRONT
3,1,11/5/2003,MONTREAL,bar, FRONT
3,2,11/5/2003,MONTREAL,bar, SOLD
4,1,11/5/2003,TORONTO,bar, FRONT
5,1,11/6/2003,MONTREAL,bar, INVENTORY

What I would like is the **last sequence-per-batchnumber** for results 
based on a search.
example psuedo-query:
SELECT OBJECT(o) WHERE ((o.town = MONTREAL) AND (o.receive_date = 
11/5/2003))
would return:
1,3,11/5/2003,MONTREAL,widget, INVENTORY
2,1,11/5/2003,MONTREAL,foo, FRONT
3,2,11/5/2003,MONTREAL,bar, SOLD

And another psuedo-query:
SELECT OBJECT(o) WHERE (o.item = bar) 
would return:
3,2,11/5/2003,MONTREAL,bar, SOLD
4,1,11/5/2003,TORONTO,bar, FRONT
5,1,11/6/2003,MONTREAL,bar, INVENTORY

Based on JBoss 3.2.2 and Mysql 3.23, could EJB-QL, JBossQL, or some type 
of declared SQL be able to solve this? An example pretty please!

Thanks everyone!
-D


---
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  Does it
help you create better code?   SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user




---
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  Does it
help you create better code?   SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


---
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  Does it
help you create better code?   SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


RE: [JBoss-user] Challenge for EJB-QL, JBossQL, or declared SQL?

2003-11-06 Thread harm
ORDER BY works in JBossQL.
It is also in the EJB 2.1 spec. But, I believe JBoss 3.2.x currently 
supports 2.0.

Regards,

Harm de Laat
Informatiefabriek
The Netherlands




Stephane Nicoll [EMAIL PROTECTED] 
Sent by: [EMAIL PROTECTED]
11/06/2003 09:53 AM
Please respond to
[EMAIL PROTECTED]


To
[EMAIL PROTECTED]
cc

Subject
RE: [JBoss-user] Challenge for EJB-QL, JBossQL, or declared SQL?






I am not sure ORDER BY is allowed (what about caching then?)
I know EJB QL does not allow that. Maybe JBoss QL.

Regards,

Stephane

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 06, 2003 9:24 AM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Challenge for EJB-QL, JBossQL, or declared
SQL?


Doesn't 'ORDER BY' help you?




Darren Hartford [EMAIL PROTECTED] 
Sent by: [EMAIL PROTECTED]
11/05/2003 04:10 PM
Please respond to
[EMAIL PROTECTED]


To
[EMAIL PROTECTED]
cc

Subject
[JBoss-user] Challenge for EJB-QL, JBossQL, or declared SQL?






Hey all,
I got an interesting problem that I should think some of you may have 
already come across in some fashion or another.  I want to do a search to 
return a collection of objects, but it needs to be very specific as 
follows:

Example table:
batchnumber | sequence | receive_date | town | item | status
with example values:
1,1,11/5/2003,MONTREAL,widget, INVENTORY
1,2,11/5/2003,MONTREAL,widget, FRONT
1,3,11/5/2003,MONTREAL,widget, INVENTORY
2,1,11/5/2003,MONTREAL,foo, FRONT
3,1,11/5/2003,MONTREAL,bar, FRONT
3,2,11/5/2003,MONTREAL,bar, SOLD
4,1,11/5/2003,TORONTO,bar, FRONT
5,1,11/6/2003,MONTREAL,bar, INVENTORY

What I would like is the **last sequence-per-batchnumber** for results 
based on a search.
example psuedo-query:
SELECT OBJECT(o) WHERE ((o.town = MONTREAL) AND (o.receive_date = 
11/5/2003))
would return:
1,3,11/5/2003,MONTREAL,widget, INVENTORY
2,1,11/5/2003,MONTREAL,foo, FRONT
3,2,11/5/2003,MONTREAL,bar, SOLD

And another psuedo-query:
SELECT OBJECT(o) WHERE (o.item = bar) 
would return:
3,2,11/5/2003,MONTREAL,bar, SOLD
4,1,11/5/2003,TORONTO,bar, FRONT
5,1,11/6/2003,MONTREAL,bar, INVENTORY

Based on JBoss 3.2.2 and Mysql 3.23, could EJB-QL, JBossQL, or some type 
of declared SQL be able to solve this? An example pretty please!

Thanks everyone!
-D


---
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  Does it
help you create better code?   SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user




---
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  Does it
help you create better code?   SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


---
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  Does it
help you create better code?   SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user




---
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  Does it
help you create better code?   SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] relate 2 entities without a common key (WAS Re: [JBoss-user] relationship 1-* with foreign key)

2003-11-06 Thread Pedro Salazar
Greetings,


-I have 2 entities mapped from 2 database tables, ACCESS_PERMISSION and
ACCESS_SCHEDULE.
-the relation between them is, ACCESS_PERMISSION *has* several
ACCESS_SCHEDULE, and a 1-N
-*they don't share a common key*

ACCESS_PERMISSION
-
SID_ID
SERVICE_ID
A1
A2
...
CONSTRAINS: UNIQUE (SID_ID,SERVICE_ID)

ACCESS_SCHEDULE
---
SID_ID
SERVICE_ID
TIME_ACCESS_START
B1
B2

CONSTRAINTS: UNIQUE(SID_ID,SERVICE_ID,TIME_ACCESS_START)

Can I define a relationship between them? 
I tried to use a relation just with 2 attributes of table
ACCESS_SCHEDULE and not using the 3rd one (TIME_ACCESS_START) but JBOSS
shows me that error:


[ObjectName: jboss.j2ee:jndiName=ejb/AccessScheduleLocal,service=EJB
 state: FAILED
 I Depend On: 
 Depends On Me: org.jboss.deployment.DeploymentException: Mappings were
not provided for all fields: unmaped fields=[timeAccessStart] in
role=schedules_BELONG_TO_access_permission, ObjectName:
jboss.j2ee:jndiName=ejb/AccessPermissionLocal,service=EJB
 state: FAILED
 I Depend On: 
 Depends On Me: org.jboss.deployment.DeploymentException: Mappings were
not provided for all fields: unmaped fields=[timeAccessStart] in
role=schedules_BELONG_TO_access_permission]


Can I do this in another way? What is normal to do, a findByXX()
method in ACCESS_SCHEDULE and a interface method on ACCESS_PERMISSION?
But in that case, there must exist some programatic code and I don't
know how can I synchronize access to that methods?

To complete, I put in below also the xdoclet code of my relationship:


/** 
 * @ejb.relation
 *  name=access_permission_TO__access_schedule
 *  role-name=access_permission_HAS_schedules
 *  cascade-delete=no
 *  target-ejb=AccessSchedule
 *  target-role-name=schedules_BELONG_TO_access_permission
 *  target-cascade-delete=yes
 * @ejb.interface-method
 *  view-type=local
 * @ejb.transaction
 *  type=Supports
 * @jboss.relation
 *  related-pk-field=sidId
 *  fk-column=sidId
 * @jboss.relation
 *  related-pk-field=primitiveId
 *  fk-column=primitiveId
 * @jboss.target-relation
 *  related-pk-field=sidId
 *  fk-column=sidId
 * @jboss.target-relation
 *  related-pk-field=primitiveId
 *  fk-column=primitiveId
 * @jboss.relation-mapping
 *  style=relation-table
 * @jboss.relation-table
 *  table-name=uif_access_permission
 */
public abstract java.util.Collection getSchedules();


regards,
Pedro Salazar
-- 
-PS



---
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  Does it
help you create better code?   SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


Re: [JBoss-user] relate 2 entities without a common key (WAS Re: [JBoss-user] relationship 1-* with foreign key)

2003-11-06 Thread harm
I will give you an example of an 1 - N relation using XDoclet tags.
Using this code you can easisly figure out what to put in your code:

Advertisement --1N-- Correction

AdvertisementBean.java:
/**
 * @ejb.interface-method 
 * @ejb.relation 
 *  name = Advertisement-Correction
 *  role-name = AdvertisementHasCorrections
 *  cascade-delete = no
 * @ejb.value-object
 *  aggregate = 
nl.informatiefabriek.om.correction.value.CorrectionValue
 *  aggregate-name = AllCorrection
 *  members = 
nl.informatiefabriek.om.correction.interfaces.CorrectionLocal
 *  members-name = Corrections
 *  relation = external
 *  type = Collection
 * @jboss.relation-mapping style=foreign-key
 */
public abstract Collection getCorrections();

CorrectionBean.java:

/**
 * @ejb.interface-method 
 * @ejb.relation 
 *  name = Advertisement-Correction
 *  role-name = CorrectionBelongsToAdvertisement
 *  cascade-delete = yes
 * @jboss.relation-mapping style = foreign-key
 * @jboss.relation
 *  fk-column=advertisement_fk
 *  related-pk-field=advertisementId
 */
public abstract AdvertisementLocal getAdvertisement();


If you don't need relationships between value objects you can just leave 
out he @ejb.value-object tags.

Regards,

Harm de Laat
Informatiefabriek
The Netherlands




Pedro Salazar [EMAIL PROTECTED] 
Sent by: [EMAIL PROTECTED]
11/06/2003 11:08 AM
Please respond to
[EMAIL PROTECTED]


To
[EMAIL PROTECTED]
cc

Subject
[JBoss-user] relate 2 entities without a common key (WAS Re: [JBoss-user] 
relationship 1-* with foreign key)






Greetings,


-I have 2 entities mapped from 2 database tables, ACCESS_PERMISSION and
ACCESS_SCHEDULE.
-the relation between them is, ACCESS_PERMISSION *has* several
ACCESS_SCHEDULE, and a 1-N
-*they don't share a common key*

ACCESS_PERMISSION
-
SID_ID
SERVICE_ID
A1
A2
...
CONSTRAINS: UNIQUE (SID_ID,SERVICE_ID)

ACCESS_SCHEDULE
---
SID_ID
SERVICE_ID
TIME_ACCESS_START
B1
B2

CONSTRAINTS: UNIQUE(SID_ID,SERVICE_ID,TIME_ACCESS_START)

Can I define a relationship between them? 
I tried to use a relation just with 2 attributes of table
ACCESS_SCHEDULE and not using the 3rd one (TIME_ACCESS_START) but JBOSS
shows me that error:


[ObjectName: jboss.j2ee:jndiName=ejb/AccessScheduleLocal,service=EJB
 state: FAILED
 I Depend On: 
 Depends On Me: org.jboss.deployment.DeploymentException: Mappings were
not provided for all fields: unmaped fields=[timeAccessStart] in
role=schedules_BELONG_TO_access_permission, ObjectName:
jboss.j2ee:jndiName=ejb/AccessPermissionLocal,service=EJB
 state: FAILED
 I Depend On: 
 Depends On Me: org.jboss.deployment.DeploymentException: Mappings were
not provided for all fields: unmaped fields=[timeAccessStart] in
role=schedules_BELONG_TO_access_permission]


Can I do this in another way? What is normal to do, a findByXX()
method in ACCESS_SCHEDULE and a interface method on ACCESS_PERMISSION?
But in that case, there must exist some programatic code and I don't
know how can I synchronize access to that methods?

To complete, I put in below also the xdoclet code of my relationship:


/** 
 * @ejb.relation
 *  name=access_permission_TO__access_schedule
 *  role-name=access_permission_HAS_schedules
 *  cascade-delete=no
 *  target-ejb=AccessSchedule
 *  target-role-name=schedules_BELONG_TO_access_permission
 *  target-cascade-delete=yes
 * @ejb.interface-method
 *  view-type=local
 * @ejb.transaction
 *  type=Supports
 * @jboss.relation
 *  related-pk-field=sidId
 *  fk-column=sidId
 * @jboss.relation
 *  related-pk-field=primitiveId
 *  fk-column=primitiveId
 * @jboss.target-relation
 *  related-pk-field=sidId
 *  fk-column=sidId
 * @jboss.target-relation
 *  related-pk-field=primitiveId
 *  fk-column=primitiveId
 * @jboss.relation-mapping
 *  style=relation-table
 * @jboss.relation-table
 *  table-name=uif_access_permission
 */
public abstract java.util.Collection getSchedules();


regards,
Pedro Salazar
-- 
-PS



---
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  Does it
help you create better code?   SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user




---
This SF.net email is sponsored by: 

[JBoss-user] HARMIServerImpl_Stub

2003-11-06 Thread Dayanand Kangala Shanmugham
Title: Message



Hi 
All,

We are using JBoss 3.2.1 and Tomcat 4.1.24 
integrated version in Clustered 
environment (using 2 machines) and are getting 
the following exception after running the server for few 
hours:


javax.naming.CommunicationException: Failed to 
connect to server 192.168.142.24:1100 
[Root exception is 
java.lang.ClassNotFoundException: 
org/jboss/ha/framework/server/HARMIServerImpl_Stub 
(no security manager: RMI class loader 
disabled)] at 
org.jnp.interfaces.NamingContext.getServer(NamingContext.java:216) at 
org.jnp.interfaces.NamingContext.discoverServer(NamingContext.java:1050) at 
org.jnp.interfaces.NamingContext.checkRef(NamingContext.java:1127) at 
org.jnp.interfaces.NamingContext.lookup(NamingContext.java:478) at 
org.jnp.interfaces.NamingContext.lookup(NamingContext.java:471) at 
javax.naming.InitialContext.lookup(InitialContext.java:347)

I have verified the 
presence of "jbossha-client.jar" file in the "JBoss Installation/client" 
folder. The above only seems to occur only in production test 
environment!

Any info about when the above exception can occur would 
be helpful in solving the above issue.


Regards,
Dayanand


[JBoss-user] Unexpected JBossQL result in 3.2.2

2003-11-06 Thread Stefan Arentz
From: Stefan Arentz [EMAIL PROTECTED]
Subject:Unexpected JBossQL result in 3.2.2
Date:   November 6, 2003 9:55:02 AM CET
To:   [EMAIL PROTECTED]
My object model is pretty simple:

 Subscription
  user- User   (1:1)
  lastSession - Session(1:1) Can be null
I'm trying to query all Subscription objects that have a not null 
lastSession field and then order the result by Session.createDate.

I'm doing this with JBossQL in JBoss 3.2.2.

This works:

 SELECT DISTINCT OBJECT(s)
  FROM Subscriptions AS s, Sessions as z
  WHERE s.user = ?1 and s.lastSession is not null and s.lastSession = z
  ORDER BY s.lastSession.createDate
  DESC LIMIT ?2
It returns the correct Subscription commands.

This doesn't:

 SELECT DISTINCT OBJECT(s)
  FROM Subscriptions AS s
  WHERE s.user = ?1 and s.lastSession is not null
  ORDER BY s.lastSession.createDate
  DESC LIMIT ?2
It returns the cartasian product of Subscription/User objects.

Is this the expected behaviour?

 S.



---
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  Does it
help you create better code?   SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] RE: Challenge for EJB-QL, JBossQL, or declared SQL?

2003-11-06 Thread Darren Hartford
I imagine ORDER BY is part of it, but the harder piece is getting the last sequence 
per batchnumber and THEN return that collection of objects (see example results below).

Regular SQL would be something like SELECT batchnumber, MAX(sequence as MAX_sequence) 
FROM thetable ORDER BY batchnumber for JUST getting the last sequence number.  You 
still have to do a JOIN or SUBSELECT from this query to attach to the actual search 
critera (item = foo or what-have-you). Then, the end result is still to return a 
collection of EJB local or remotes.

Is there an elegant, object-oriented way of handling this kind of scenario? A 'J2EE' 
way of handling it?

-D




Subject: RE: [JBoss-user] Challenge for EJB-QL, JBossQL, or declared SQL?
From: [EMAIL PROTECTED]
Date: Thu, 6 Nov 2003 10:52:24 +0100

ORDER BY works in JBossQL.
It is also in the EJB 2.1 spec. But, I believe JBoss 3.2.x currently 
supports 2.0.

Regards,

Harm de Laat
Informatiefabriek
The Netherlands


Stephane Nicoll [EMAIL PROTECTED] 
Sent by: [EMAIL PROTECTED]
11/06/2003 09:53 AM

I am not sure ORDER BY is allowed (what about caching then?)
I know EJB QL does not allow that. Maybe JBoss QL.

Regards,

Stephane

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 06, 2003 9:24 AM

Doesn't 'ORDER BY' help you?


Darren Hartford [EMAIL PROTECTED] 
Sent by: [EMAIL PROTECTED]
11/05/2003 04:10 PM

Hey all,
I got an interesting problem that I should think some of you may have 
already come across in some fashion or another.  I want to do a search to 
return a collection of objects, but it needs to be very specific as 
follows:

Example table:
batchnumber | sequence | receive_date | town | item | status
with example values:
1,1,11/5/2003,MONTREAL,widget, INVENTORY
1,2,11/5/2003,MONTREAL,widget, FRONT
1,3,11/5/2003,MONTREAL,widget, INVENTORY
2,1,11/5/2003,MONTREAL,foo, FRONT
3,1,11/5/2003,MONTREAL,bar, FRONT
3,2,11/5/2003,MONTREAL,bar, SOLD
4,1,11/5/2003,TORONTO,bar, FRONT
5,1,11/6/2003,MONTREAL,bar, INVENTORY

What I would like is the **last sequence-per-batchnumber** for results 
based on a search.
example psuedo-query:
SELECT OBJECT(o) WHERE ((o.town = MONTREAL) AND (o.receive_date = 
11/5/2003))
would return:
1,3,11/5/2003,MONTREAL,widget, INVENTORY
2,1,11/5/2003,MONTREAL,foo, FRONT
3,2,11/5/2003,MONTREAL,bar, SOLD

And another psuedo-query:
SELECT OBJECT(o) WHERE (o.item = bar) 
would return:
3,2,11/5/2003,MONTREAL,bar, SOLD
4,1,11/5/2003,TORONTO,bar, FRONT
5,1,11/6/2003,MONTREAL,bar, INVENTORY

Based on JBoss 3.2.2 and Mysql 3.23, could EJB-QL, JBossQL, or some type 
of declared SQL be able to solve this? An example pretty please!

Thanks everyone!
-D


---
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  Does it
help you create better code?   SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


RE: [JBoss-user] Dynamic Addition of Roles using JAAS

2003-11-06 Thread Kevin Conner
 I meant here authentication. But I have some doubts - is it done
 in the end of successful authentication, or just before the first
 authorization? - I don't know it.

The information is cached after a successful authentication and
expires after a specified period.

The login module is called if the user is not in the cache or if
the authentication credential does not match the cached credential.

Kev


---
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  Does it
help you create better code?   SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] Commit Option Confusion

2003-11-06 Thread Phil Shrimpton
Hi,

I am tuning an app before deployment on 3.2.2.

As this app 'owns' its own database and the DB is not that quick, I though 
that changing from the default commit option B to A should give me some 
improvements, but seems to make no difference.

My tests complete in the same time with both option A and B, the SQL 
generated is identical with both options, and the CacheSize settings for the 
EJB's in the jmx-console are always Zero.

I am missing something or is my understanding of Commit options flawed?

Phil
-- 
  2:20pm  up 58 days, 16:30,  1 user,  load average: 0.46, 0.23, 0.15
ICQ: 760757 | AIM: pjshrimpton | Y!: pjshrimpton | [EMAIL PROTECTED]


---
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  Does it
help you create better code?   SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


AW: [JBoss-user] serial mdb execution?

2003-11-06 Thread Scheil, Sven
thank you. this works pretty well :-)



-Ursprüngliche Nachricht-
Von: Barlow, Dustin [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 28. Oktober 2003 18:21
An: '[EMAIL PROTECTED]'
Betreff: RE: [JBoss-user] serial mdb execution?


First you need to configure the invoker-proxy-binding for the MDB.  Notice
the MaximumSize and the MaxMessages.  You can find the following in
server/target/conf/standardjboss.xml.  You can also define these in the
jboss.xml jar deployed with your MDB if you don't want to change/add them to
standardjboss.xml

invoker-proxy-binding
 namemessage-driven-bean-max1/name
 invoker-mbeandefault/invoker-mbean
 
proxy-factoryorg.jboss.ejb.plugins.jms.JMSContainerInvoker/proxy-factory
 proxy-factory-config
 
JMSProviderAdapterJNDIDefaultJMSProvider/JMSProviderAdapterJNDI
 
ServerSessionPoolFactoryJNDIStdJMSPool/ServerSessionPoolFactoryJNDI
MaximumSize1/MaximumSize
MaxMessages1/MaxMessages
MDBConfig
   ReconnectIntervalSec10/ReconnectIntervalSec
   DLQConfig
  DestinationQueuequeue/DLQ/DestinationQueue
  MaxTimesRedelivered3/MaxTimesRedelivered
  TimeToLive0/TimeToLive
   /DLQConfig
/MDBConfig
 /proxy-factory-config
  /invoker-proxy-binding 

Then have a container-configuration as follows:

  container-configuration
 container-nameSingleThreaded Message Driven Bean/container-name
 call-loggingfalse/call-logging
 
invoker-proxy-binding-namemessage-driven-bean-max1-dlq/invoker-proxy-bind
ing-name
 container-interceptors
 
interceptororg.jboss.ejb.plugins.ProxyFactoryFinderInterceptor/intercepto
r
interceptororg.jboss.ejb.plugins.LogInterceptor/interceptor
 
interceptororg.jboss.ejb.plugins.RunAsSecurityInterceptor/interceptor
!-- CMT --
interceptor
transaction=Containerorg.jboss.ejb.plugins.TxInterceptorCMT/interceptor
interceptor transaction=Container
metricsEnabled=trueorg.jboss.ejb.plugins.MetricsInterceptor/interceptor
interceptor
transaction=Containerorg.jboss.ejb.plugins.MessageDrivenInstanceIntercept
or/interceptor
!-- BMT --
interceptor
transaction=Beanorg.jboss.ejb.plugins.MessageDrivenInstanceInterceptor/i
nterceptor
interceptor
transaction=Beanorg.jboss.ejb.plugins.MessageDrivenTxInterceptorBMT/inte
rceptor
interceptor transaction=Bean
metricsEnabled=trueorg.jboss.ejb.plugins.MetricsInterceptor/interceptor
 
interceptororg.jboss.resource.connectionmanager.CachedConnectionIntercepto
r/interceptor
 /container-interceptors
 
instance-poolorg.jboss.ejb.plugins.MessageDrivenInstancePool/instance-poo
l
 instance-cache/instance-cache
 persistence-manager/persistence-manager
 container-pool-conf
 MaximumSize1/MaximumSize
 MinimumSize1/MinimumSize
 strictMaximumSizetrue/strictMaximumSize
  /container-pool-conf
  /container-configuration 


Then in your jboss.xml file for your MDB make sure to have your MDB use the
container configuration:

  message-driven
 ejb-nameSingletonMDB/ejb-name
 destination-jndi-namequeue/Singleton/destination-jndi-name
 configuration-nameSingleThreaded Message Driven
Bean/configuration-name
  /message-driven


Hope this helps,

Dustin

 -Original Message-
 From: Scheil, Sven [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, October 28, 2003 11:18 AM
 To: [EMAIL PROTECTED]
 Subject: [JBoss-user] serial mdb execution?
 
 
 
 I'm sending several messages with different types to an mdb. 
 One type stands
 for an update message. That means take the data from the message and
 update several entity beans with it. These updates have to be execute
 dstrictly serial. But it comes that more than one update 
 message at the same
 time is send and jboss instantiates 2 or more mdb to execute 
 the messages in
 parallel.
 
 How can I configure (or design?) my mdb that it exceute the 
 messages of type
 update strictly one after the other.
 
 thanx sven
 
 CargoSoft GmbH
 Linzer Str. 3
 28359 Bremen
 Telefon+49 421 2020 440
 Telefax+49 421 2020 189
 http://www.cargosoft.de
 eMail: [EMAIL PROTECTED]
 Hotline: [EMAIL PROTECTED]
 
 
 
 
 ---
 This SF.net email is sponsored by: SF.net Giveback Program.
 Does SourceForge.net help you be more productive?  Does it
 help you create better code?   SHARE THE LOVE, and help us help
 YOU!  Click Here: http://sourceforge.net/donate/
 ___
 JBoss-user mailing list
 [EMAIL PROTECTED]
 https://lists.sourceforge.net/lists/listinfo/jboss-user
 


---
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  

Re: [JBoss-user] relate 2 entities without a common key (WAS Re: [JBoss-user] relationship 1-* with foreign key)

2003-11-06 Thread Pedro Salazar
On Thu, 2003-11-06 at 10:57, [EMAIL PROTECTED] wrote:
 I will give you an example of an 1 - N relation using XDoclet tags.
 Using this code you can easisly figure out what to put in your code:
 
 Advertisement --1N-- Correction
 
 AdvertisementBean.java:
 /**
  * @ejb.interface-method 
  * @ejb.relation 
  *  name = Advertisement-Correction
  *  role-name = AdvertisementHasCorrections
  *  cascade-delete = no
  * @ejb.value-object
  *  aggregate = 
 nl.informatiefabriek.om.correction.value.CorrectionValue
  *  aggregate-name = AllCorrection
  *  members = 
 nl.informatiefabriek.om.correction.interfaces.CorrectionLocal
  *  members-name = Corrections
  *  relation = external
  *  type = Collection
  * @jboss.relation-mapping style=foreign-key
  */
 public abstract Collection getCorrections();
 
 CorrectionBean.java:
 
 /**
  * @ejb.interface-method 
  * @ejb.relation 
  *  name = Advertisement-Correction
  *  role-name = CorrectionBelongsToAdvertisement
  *  cascade-delete = yes
  * @jboss.relation-mapping style = foreign-key
  * @jboss.relation
  *  fk-column=advertisement_fk
  *  related-pk-field=advertisementId
  */
 public abstract AdvertisementLocal getAdvertisement();
 
 
 If you don't need relationships between value objects you can just leave 
 out he @ejb.value-object tags.

Hi,

Could you please show me what keys are you using on your relation? To
build a relationship you must have the same key on both sides of the
relation, right? If not, JBOSS throws an error.

Since I don't have it, I only could made a ejbSelect, but I don't know
what I'm losing on a select besides the CASCADE_DELETE. What is the
performance gain/loose of using relationship, select or a value-object?
What is value-object aggregation ?

thanks,
Pedro Salazar.
-- 
-PS



---
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  Does it
help you create better code?   SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] CMP or BMP transactions, isolation level, performance

2003-11-06 Thread Pedro Salazar
Greetings,

I would like to ask if even with the CMP beans is possible to customize
the transaction isolation level?

If yes, how can I do it? 

I have an idea that CMP beans are the most light and fastest beans. But
I think in the most of the times, we should have business logic in beans
that requires synchronization. It stills worth going to CMP and lock the
all bean operations or just go to BMP beans to use the programatic and
customize the block of the transaction?

regards,
Pedro Salazar
-- 
-PS



---
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  Does it
help you create better code?   SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


RE: [JBoss-user] RE: JMS problem?

2003-11-06 Thread Eric J Kaplan
Adrian

We have since seen this problem again.  It may be indeed a false report
due to load on the server, but we can't be 100% sure.  It's now hurting
customer's perceptions.  You mentioned the RMIConnectionFactory as being
more resilient, but there are other problems.  What are these problems?
How does this compare to the UILConnectionFactory in 3.0.4?  Upgrading
to 3.2.2 for us isn't practical.  Our primary concern at this point is
resiliency.

We have also been told that our client is running about 7 users on
citrix, meaning there are 7 clients all running from the same machine.
Is this an issue with the oil connection factory?

Regards

Eric Kaplan

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Adrian
Brock
Sent: Friday, October 24, 2003 10:06 PM
To: [EMAIL PROTECTED]
Subject: RE: [JBoss-user] RE: JMS problem?

On Tue, 2003-10-21 at 14:02, Eric J Kaplan wrote:
 Adrian
 
 Yes, we have disabled the code on our end to close the connection on
 shutdown via a shutdown hook because we were having clients
sporadically
 hang on exit. 

Can you supply a threaddump?
ctrl-break on windows
ctrl-\ on linux

  However, could this then affect other clients up and
 running?  

And the same on the server?

 Horia Muntean suggests a network problem.  We are suspicious
 that our client has had network issues, but what specifically would
 cause a client to get disconnected from jms (outside of a major
network
 outage, which I know they didn't have)?  

JBoss performs a ping (every 60 secs by default). If it didn't get
a pong within a further 60 secs it assumes the server is gone.

I've only ever seen a false report with this when the server is doing
a lot of paging memory - disk. This causes very long garbage
collections (the pong doesn't get any cpu).

Does using the RMIConnectionFactory solve your problem it is more
resilent to network problems compared to plain sockets connections.
But there is a cost associated with this.

 I would imagine there is a
 certain amount of robustness built into it such that network hiccups
(of
 which there are a lot of I'm sure) don't cause clients to completely
 disconnect.  Is there a configuration parameter we can tweak to
insulate
 ourselves here?  Is there something we should look at specifically on
 our network?  Is this just a problem with the OIL connection factory?
 

Try adding a simple script on the client that pings the server at
regular intervals. Do server to client as well if you paranoid :-)
Any failures or long responses should appear in the
output. Network monitoring tools would be better if you have them.

Regards,
Adrian

 Sorry for all the questions, but we need to get down to the bottom of
 this.  Our client is a little antsy.
 
 Regards
 
 Eric
 
 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of Adrian
 Brock
 Sent: Monday, October 20, 2003 5:28 PM
 To: [EMAIL PROTECTED]
 Subject: Re: [JBoss-user] RE: JMS problem?
 
 
 On Mon, 2003-10-20 at 21:22, Eric J Kaplan wrote:
  More detail.  Messages from the jboss server log when the problem
  initially occurred. Ideas?
  
   
  
  2003-10-20 10:16:01,687 WARN 
  [org.jboss.mq.server.ClientConsumer:ID:14] Could not send messages
to
  a receiver.
  
  java.rmi.RemoteException: Cannot contact the remote object; nested
  exception is: 
  
  java.net.SocketException: Connection reset
  
  at
  org.jboss.mq.il.oil.OILClientIL.waitAnswer(OILClientIL.java:211)
  
  at
  org.jboss.mq.il.oil.OILClientIL.receive(OILClientIL.java:141)
  
  at
  org.jboss.mq.server.ClientConsumer.doWork(ClientConsumer.java:295)
  
  at
 

org.jboss.mq.threadpool.ThreadPool$WorkerThread.run(ThreadPool.java:230)
  
  Caused by: java.net.SocketException: Connection reset
  
  at
  java.net.SocketInputStream.read(SocketInputStream.java:168)
  
  at
  java.io.BufferedInputStream.fill(BufferedInputStream.java:183)
  
  at
  java.io.BufferedInputStream.read(BufferedInputStream.java:201)
  
  at
 

java.io.ObjectInputStream$PeekInputStream.peek(ObjectInputStream.java:21
 33)
  
  at
 

java.io.ObjectInputStream$BlockDataInputStream.readBlockHeader(ObjectInp
 utStream.java:2316)
  
  at
 

java.io.ObjectInputStream$BlockDataInputStream.refill(ObjectInputStream.
 java:2383)
  
  at
 

java.io.ObjectInputStream$BlockDataInputStream.read(ObjectInputStream.ja
 va:2455)
  
  at
 

java.io.ObjectInputStream$BlockDataInputStream.readByte(ObjectInputStrea
 m.java:2604)
  
  at
  java.io.ObjectInputStream.readByte(ObjectInputStream.java:845)
  
  at
  org.jboss.mq.il.oil.OILClientIL.waitAnswer(OILClientIL.java:200)
  
  ... 3 more
  
  2003-10-20 10:16:01,687 ERROR
  [org.jboss.mq.server.JMSDestinationManager] The connection to client
  ID:14 failed.
  
 
 This message says jbossmq was trying 

Re: [JBoss-user] (no subject)

2003-11-06 Thread Adrian Brock
 Caused by: java.lang.NoClassDefFoundError: org/apache/log4j/Category

Have you modified the classpath or have you added jars in jre/lib/ext?

Regards,
Adrian

On Thu, 2003-11-06 at 16:14, praveen kushwaha wrote:
 hello 
 everybody
  
  i m used and deployed JBoss3.2.2RC4 with jdk1.4.2_01
  
 but now i  am facing an error 
  i dont know why this is coming again and again 
 i had downloaded new jboss3.2.2 after deleting perious one 
 but the problem is same
  
 iF anybody can give me solution ?? Welcome
  
 ERROR DETAILS=
  
 21:00:29,406 INFO  [Server] Core system initialized
 21:00:29,421 INFO  [MainDeployer] Starting deployment of package:
 file:/D:/docs11i/jboss-3.2.2/server/default/conf/jboss-service.xml
 21:00:31,421 WARN  [NestedThrowable] Duplicate throwable nesting of
 same base type: class org.jboss.deployment.DeploymentException is
  assignable from: class org.jboss.deployment.DeploymentException
 21:00:31,437 ERROR [MainDeployer] could not create deployment:
 file:/D:/docs11i/jboss-3.2.2/server/default/conf/jboss-service.xml
 org.jboss.deployment.DeploymentException: create operation failed for
 package file:/D:/docs11i/jboss-3.2.2/server/default/conf/jboss-
 service.xml; - nested throwable:
 (org.jboss.deployment.DeploymentException: - nested throwable:
 (java.lang.reflect.UndeclaredThrowabl
 eException))
 at
 org.jboss.deployment.SARDeployer.create(SARDeployer.java:202)
;  at
 org.jboss.deployment.MainDeployer.create(MainDeployer.java:776)
 at
 org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:631)
 at
 org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:605)
 at
 org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:589)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at
 sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at
 sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at
 org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
 at
 org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
 at
 org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
 at $Proxy5.deploy(Unknown Source)
 at
 org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:384)
 at
 org.jboss.system.server.ServerImpl.start(ServerImpl.java:291)
 at org.jboss.Main.boot(Main.java:150)
 at org.jboss.Main$1.run(Main.java:388)
 at java.lang.Thread.run(Thread.java:534)
 Caused by: org.jboss.deployment.DeploymentException: - nested
 throwable: (java.lang.reflect.UndeclaredThrowableException)
 at
 org.jboss.system.ServiceConfigurator.install(ServiceConfigurator.java:143)
 at
 org.jboss.system.ServiceController.install(ServiceController.java:225)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at
 sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at
 sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at
 org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
 at
 org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
 at
 org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
 at $Proxy4.install(Unknown Source)
 at
 org.jboss.deployment.SARDeployer.create(SARDeployer.java:183)
 ... 17 more
 Caused by: java.lang.reflect.UndeclaredThrowableException
 at
 org.jboss.system.ServiceCreator.install(ServiceCreator.java:181)
 at
 org.jboss.system.ServiceConfigurator.internalInstall(ServiceConfigurator.java:155)
 at
 org.jboss.system.ServiceConfigurator.install(ServiceConfigurator.java:118)
 ... 27 more
 Caused by: java.lang.NoClassDefFoundError: org/apache/log4j/Category
 at org.jnp.server.Main.init(Main.java:118)
 at
 org.jboss.naming.NamingService.init(NamingService.java:52)
 at
 sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at
 sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
 at
 sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at
 java.lang.reflect.Constructor.newInstance(Constructor.java:274)
 at
 org.jboss.mx.server.MBeanServerImpl.instantiate(MBeanServerImpl.java:847)
 at
 org.jboss.mx.server.MBeanServerImpl.instantiate(MBeanServerImpl.java:291)
 at
 org.jboss.mx.server.MBeanServerImpl.createMBean(MBeanServerImpl.java:318)
 at
 org.jboss.system.ServiceCreator.install(ServiceCreator.java:98)
 ... 29 more
 21:00:31,593 ERROR [Server] Failed to start
 

RE: [JBoss-user] RE: JMS problem?

2003-11-06 Thread Adrian Brock
Since the problem is with the client disconnecting,
can configure log4j on the client?
JBossMQ will log what is going on (i.e. why the client is
disconnecting).

You can also:

QueueConnection qc = qcf.createQueueConnection();
qc.setExceptionListener(myExeptionListener);
to catch a disconnection and reconnect.
i.e. connection.close() - reinitialise the objects.
Many people hide the jms api behind a wrapper
to make this more transparent.

Another option is to download jboss-3.0.8 then copy
jbossmq.jar and jbossmq-client.jar into 3.0.4
There are many bug fixes between the two versions.
I've heard of a few people doing this successfully
in the forums.
3.0.4 was about the time I first started working
on JBossMQ

Regards,
Adrian

On Thu, 2003-11-06 at 20:47, Eric J Kaplan wrote:
 Adrian
 
 We have since seen this problem again.  It may be indeed a false report
 due to load on the server, but we can't be 100% sure.  It's now hurting
 customer's perceptions.  You mentioned the RMIConnectionFactory as being
 more resilient, but there are other problems.  What are these problems?
 How does this compare to the UILConnectionFactory in 3.0.4?  Upgrading
 to 3.2.2 for us isn't practical.  Our primary concern at this point is
 resiliency.
 
 We have also been told that our client is running about 7 users on
 citrix, meaning there are 7 clients all running from the same machine.
 Is this an issue with the oil connection factory?
 
 Regards
 
 Eric Kaplan
 
 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of Adrian
 Brock
 Sent: Friday, October 24, 2003 10:06 PM
 To: [EMAIL PROTECTED]
 Subject: RE: [JBoss-user] RE: JMS problem?
 
 On Tue, 2003-10-21 at 14:02, Eric J Kaplan wrote:
  Adrian
  
  Yes, we have disabled the code on our end to close the connection on
  shutdown via a shutdown hook because we were having clients
 sporadically
  hang on exit. 
 
 Can you supply a threaddump?
 ctrl-break on windows
 ctrl-\ on linux
 
   However, could this then affect other clients up and
  running?  
 
 And the same on the server?
 
  Horia Muntean suggests a network problem.  We are suspicious
  that our client has had network issues, but what specifically would
  cause a client to get disconnected from jms (outside of a major
 network
  outage, which I know they didn't have)?  
 
 JBoss performs a ping (every 60 secs by default). If it didn't get
 a pong within a further 60 secs it assumes the server is gone.
 
 I've only ever seen a false report with this when the server is doing
 a lot of paging memory - disk. This causes very long garbage
 collections (the pong doesn't get any cpu).
 
 Does using the RMIConnectionFactory solve your problem it is more
 resilent to network problems compared to plain sockets connections.
 But there is a cost associated with this.
 
  I would imagine there is a
  certain amount of robustness built into it such that network hiccups
 (of
  which there are a lot of I'm sure) don't cause clients to completely
  disconnect.  Is there a configuration parameter we can tweak to
 insulate
  ourselves here?  Is there something we should look at specifically on
  our network?  Is this just a problem with the OIL connection factory?
  
 
 Try adding a simple script on the client that pings the server at
 regular intervals. Do server to client as well if you paranoid :-)
 Any failures or long responses should appear in the
 output. Network monitoring tools would be better if you have them.
 
 Regards,
 Adrian
 
  Sorry for all the questions, but we need to get down to the bottom of
  this.  Our client is a little antsy.
  
  Regards
  
  Eric
  
  -Original Message-
  From: [EMAIL PROTECTED]
  [mailto:[EMAIL PROTECTED] On Behalf Of Adrian
  Brock
  Sent: Monday, October 20, 2003 5:28 PM
  To: [EMAIL PROTECTED]
  Subject: Re: [JBoss-user] RE: JMS problem?
  
  
  On Mon, 2003-10-20 at 21:22, Eric J Kaplan wrote:
   More detail.  Messages from the jboss server log when the problem
   initially occurred. Ideas?
   

   
   2003-10-20 10:16:01,687 WARN 
   [org.jboss.mq.server.ClientConsumer:ID:14] Could not send messages
 to
   a receiver.
   
   java.rmi.RemoteException: Cannot contact the remote object; nested
   exception is: 
   
   java.net.SocketException: Connection reset
   
   at
   org.jboss.mq.il.oil.OILClientIL.waitAnswer(OILClientIL.java:211)
   
   at
   org.jboss.mq.il.oil.OILClientIL.receive(OILClientIL.java:141)
   
   at
   org.jboss.mq.server.ClientConsumer.doWork(ClientConsumer.java:295)
   
   at
  
 
 org.jboss.mq.threadpool.ThreadPool$WorkerThread.run(ThreadPool.java:230)
   
   Caused by: java.net.SocketException: Connection reset
   
   at
   java.net.SocketInputStream.read(SocketInputStream.java:168)
   
   at
   java.io.BufferedInputStream.fill(BufferedInputStream.java:183)
   
   at
   

Re: [JBoss-user] Commit Option Confusion

2003-11-06 Thread Bill Burke
Are you doing a lot of finder queries?  Finder queries still go to DB 
except for findByPrimaryKey.  Also, do you have a lot of contention? 
Concurrent access?  Take a look at the for-pay docs on how to optimize this.

Bill

Phil Shrimpton wrote:

Hi,

I am tuning an app before deployment on 3.2.2.

As this app 'owns' its own database and the DB is not that quick, I though 
that changing from the default commit option B to A should give me some 
improvements, but seems to make no difference.

My tests complete in the same time with both option A and B, the SQL 
generated is identical with both options, and the CacheSize settings for the 
EJB's in the jmx-console are always Zero.

I am missing something or is my understanding of Commit options flawed?

Phil
--

Bill Burke
Chief Architect
JBoss Group LLC.



---
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  Does it
help you create better code?   SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


Re: [JBoss-user] CMP or BMP transactions, isolation level, performance

2003-11-06 Thread Bill Burke
By default, JBoss has serialized access to BMP or CMP beans at runtime 
via pessimistic locking.  There are different locking configurations 
that you can use that are specified in our for-pay documentation.

As for JDBC isolation levels, you can only set this on a per datasource 
level in the *-ds.xml config file transaction-isolation.  So you would 
define two different datasources that talk to the same DB, but define 
different isolation levels for both.

Bill

Pedro Salazar wrote:

Greetings,

I would like to ask if even with the CMP beans is possible to customize
the transaction isolation level?
If yes, how can I do it? 

I have an idea that CMP beans are the most light and fastest beans. But
I think in the most of the times, we should have business logic in beans
that requires synchronization. It stills worth going to CMP and lock the
all bean operations or just go to BMP beans to use the programatic and
customize the block of the transaction?
regards,
Pedro Salazar
--

Bill Burke
Chief Architect
JBoss Group LLC.



---
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  Does it
help you create better code?   SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


RE: [JBoss-user] RE: JMS problem?

2003-11-06 Thread eric . kaplan
Thanks Adrian.

How specifically should we configure log4j on the client?  We currently use
log4j for logging on the client in our application and have a
log4j.properties.

We'll try setting the exception listener and see if we can reconnect cleanly (at
a minimum detect what's happened).

Obviously, the last solution would be trivial to try as well.

Thanks for your help, we'll let you know how it turns out.

Quoting Adrian Brock [EMAIL PROTECTED]:

 Since the problem is with the client disconnecting,
 can configure log4j on the client?
 JBossMQ will log what is going on (i.e. why the client is
 disconnecting).
 
 You can also:
 
 QueueConnection qc = qcf.createQueueConnection();
 qc.setExceptionListener(myExeptionListener);
 to catch a disconnection and reconnect.
 i.e. connection.close() - reinitialise the objects.
 Many people hide the jms api behind a wrapper
 to make this more transparent.
 
 Another option is to download jboss-3.0.8 then copy
 jbossmq.jar and jbossmq-client.jar into 3.0.4
 There are many bug fixes between the two versions.
 I've heard of a few people doing this successfully
 in the forums.
 3.0.4 was about the time I first started working
 on JBossMQ
 
 Regards,
 Adrian
 
 On Thu, 2003-11-06 at 20:47, Eric J Kaplan wrote:
  Adrian
  
  We have since seen this problem again.  It may be indeed a false report
  due to load on the server, but we can't be 100% sure.  It's now hurting
  customer's perceptions.  You mentioned the RMIConnectionFactory as being
  more resilient, but there are other problems.  What are these problems?
  How does this compare to the UILConnectionFactory in 3.0.4?  Upgrading
  to 3.2.2 for us isn't practical.  Our primary concern at this point is
  resiliency.
  
  We have also been told that our client is running about 7 users on
  citrix, meaning there are 7 clients all running from the same machine.
  Is this an issue with the oil connection factory?
  
  Regards
  
  Eric Kaplan
  
  -Original Message-
  From: [EMAIL PROTECTED]
  [mailto:[EMAIL PROTECTED] On Behalf Of Adrian
  Brock
  Sent: Friday, October 24, 2003 10:06 PM
  To: [EMAIL PROTECTED]
  Subject: RE: [JBoss-user] RE: JMS problem?
  
  On Tue, 2003-10-21 at 14:02, Eric J Kaplan wrote:
   Adrian
   
   Yes, we have disabled the code on our end to close the connection on
   shutdown via a shutdown hook because we were having clients
  sporadically
   hang on exit. 
  
  Can you supply a threaddump?
  ctrl-break on windows
  ctrl-\ on linux
  
However, could this then affect other clients up and
   running?  
  
  And the same on the server?
  
   Horia Muntean suggests a network problem.  We are suspicious
   that our client has had network issues, but what specifically would
   cause a client to get disconnected from jms (outside of a major
  network
   outage, which I know they didn't have)?  
  
  JBoss performs a ping (every 60 secs by default). If it didn't get
  a pong within a further 60 secs it assumes the server is gone.
  
  I've only ever seen a false report with this when the server is doing
  a lot of paging memory - disk. This causes very long garbage
  collections (the pong doesn't get any cpu).
  
  Does using the RMIConnectionFactory solve your problem it is more
  resilent to network problems compared to plain sockets connections.
  But there is a cost associated with this.
  
   I would imagine there is a
   certain amount of robustness built into it such that network hiccups
  (of
   which there are a lot of I'm sure) don't cause clients to completely
   disconnect.  Is there a configuration parameter we can tweak to
  insulate
   ourselves here?  Is there something we should look at specifically on
   our network?  Is this just a problem with the OIL connection factory?
   
  
  Try adding a simple script on the client that pings the server at
  regular intervals. Do server to client as well if you paranoid :-)
  Any failures or long responses should appear in the
  output. Network monitoring tools would be better if you have them.
  
  Regards,
  Adrian
  
   Sorry for all the questions, but we need to get down to the bottom of
   this.  Our client is a little antsy.
   
   Regards
   
   Eric
   
   -Original Message-
   From: [EMAIL PROTECTED]
   [mailto:[EMAIL PROTECTED] On Behalf Of Adrian
   Brock
   Sent: Monday, October 20, 2003 5:28 PM
   To: [EMAIL PROTECTED]
   Subject: Re: [JBoss-user] RE: JMS problem?
   
   
   On Mon, 2003-10-20 at 21:22, Eric J Kaplan wrote:
More detail.  Messages from the jboss server log when the problem
initially occurred. Ideas?

 

2003-10-20 10:16:01,687 WARN 
[org.jboss.mq.server.ClientConsumer:ID:14] Could not send messages
  to
a receiver.

java.rmi.RemoteException: Cannot contact the remote object; nested
exception is: 

java.net.SocketException: Connection reset

at

[JBoss-user] JBOSS3.2.2 FAILED TO START ( SARDeployer problem ??)

2003-11-06 Thread praveen kushwaha
Note: forwarded message attached.
Yahoo! India Mobile: Ringtones, Wallpapers, Picture Messages and more.
Download now.---BeginMessage---
Warning, delivery failure! This is a status message indicating that a message could 
not be delivered to 1 or more recipients.

Original message subject: [JBoss-user] (no subject)
Date received: 06-Nov-2003 18:16:54 +


Recipients and delivery history

[EMAIL PROTECTED]
 Transcript of session follows ---
06-Nov-2003 18:16:54 + Received via SMTP from FIREWALL.PINDAR.COM
06-Nov-2003 18:16:56 + The mailbox for user m.prabhu is full

Reporting-MTA: dns;mail-newlands.pindar.com.

Final-Recipient: rfc822;[EMAIL PROTECTED]
Action: failed
Status: 5.0.0 (permanent failure)

---BeginMessage---
hello 
everybody
 
 i m used and deployed JBoss3.2.2RC4 with jdk1.4.2_01
 
but now i  am facing an error 
 i dont know why this is coming again and again 
i had downloaded new jboss3.2.2 after deleting perious one 
but the problem is same
 
iF anybody can give me solution ?? Welcome
 
ERROR DETAILS=
 
21:00:29,406 INFO  [Server] Core system initialized
21:00:29,421 INFO  [MainDeployer] Starting deployment of package: 
file:/D:/docs11i/jboss-3.2.2/server/default/conf/jboss-service.xml
21:00:31,421 WARN  [NestedThrowable] Duplicate throwable nesting of same base type: 
class org.jboss.deployment.DeploymentException is
 assignable from: class org.jboss.deployment.DeploymentException
21:00:31,437 ERROR [MainDeployer] could not create deployment: 
file:/D:/docs11i/jboss-3.2.2/server/default/conf/jboss-service.xml
org.jboss.deployment.DeploymentException: create operation failed for package 
file:/D:/docs11i/jboss-3.2.2/server/default/conf/jboss-
service.xml; - nested throwable: (org.jboss.deployment.DeploymentException: - nested 
throwable: (java.lang.reflect.UndeclaredThrowabl
eException))
at org.jboss.deployment.SARDeployer.create(SARDeployer.java:202)
at org.jboss.deployment.MainDeployer.create(MainDeployer.java:776)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:631)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:605)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:589)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at 
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
at $Proxy5.deploy(Unknown Source)
at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:384)
at org.jboss.system.server.ServerImpl.start(ServerImpl.java:291)
at org.jboss.Main.boot(Main.java:150)
at org.jboss.Main$1.run(Main.java:388)
at java.lang.Thread.run(Thread.java:534)
Caused by: org.jboss.deployment.DeploymentException: - nested throwable: 
(java.lang.reflect.UndeclaredThrowableException)
at org.jboss.system.ServiceConfigurator.install(ServiceConfigurator.java:143)
at org.jboss.system.ServiceController.install(ServiceController.java:225)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at 
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
at $Proxy4.install(Unknown Source)
at org.jboss.deployment.SARDeployer.create(SARDeployer.java:183)
... 17 more
Caused by: java.lang.reflect.UndeclaredThrowableException
at org.jboss.system.ServiceCreator.install(ServiceCreator.java:181)
at 
org.jboss.system.ServiceConfigurator.internalInstall(ServiceConfigurator.java:155)
at org.jboss.system.ServiceConfigurator.install(ServiceConfigurator.java:118)
... 27 more
Caused by: java.lang.NoClassDefFoundError: org/apache/log4j/Category
at org.jnp.server.Main.init(Main.java:118)
at org.jboss.naming.NamingService.init(NamingService.java:52)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at 
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at 

[JBoss-user] Help ----------ClassNotFoundException

2003-11-06 Thread Subramanian Sethuraman
Hi All,

Greetings.  I am Subramanian. S.  I am facing a problem while starting the
JBoss.  The description is below:

We are having a signed jar file call it as 'XYZ.jar'.  It is an encrypted
file(using some third party tool).  It is having some MBeans and EJBs.
It is available under an *.ear directory under server/default.

Whenever we are starting up the server,  We are getting a
'ClassNotFoundException' from that jar.

We feel that this may due to the encryption and the default ClassLoader of
jboss is unable to decrpt it.  Is it so?
If so, how can we specify the other classloaders to do the task.  Otherwise,
how can we solve this?


Please help me.

Thanking you in advance.
Subramanian. S



---
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  Does it
help you create better code?   SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] (no subject)

2003-11-06 Thread praveen kushwaha
hello 
everybody

i m used and deployed JBoss3.2.2RC4 with jdk1.4.2_01

but now i am facing an error 
i dont know why this is coming again and again 
i had downloaded new jboss3.2.2 after deleting perious one 
but the problem is same

iF anybody can give me solution?? Welcome

ERROR DETAILS=

21:00:29,406 INFO [Server] Core system initialized21:00:29,421 INFO [MainDeployer] Starting deployment of package: file:/D:/docs11i/jboss-3.2.2/server/default/conf/jboss-service.xml21:00:31,421 WARN [NestedThrowable] Duplicate throwable nesting of same base type: class org.jboss.deployment.DeploymentException isassignable from: class org.jboss.deployment.DeploymentException21:00:31,437 ERROR [MainDeployer] could not create deployment: file:/D:/docs11i/jboss-3.2.2/server/default/conf/jboss-service.xmlorg.jboss.deployment.DeploymentException: create operation failed for package file:/D:/docs11i/jboss-3.2.2/server/default/conf/jboss-service.xml; - nested throwable: (org.jboss.deployment.DeploymentException: - nested throwable: (java.lang.reflect.UndeclaredThrowableException)) at org.jboss.deployment.SARDeployer.create(SARDeployer.java:202)
 at org.jboss.deployment.MainDeployer.create(MainDeployer.java:776) at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:631) at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:605) at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:589) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at
 org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) at $Proxy5.deploy(Unknown Source) at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:384) at org.jboss.system.server.ServerImpl.start(ServerImpl.java:291) at org.jboss.Main.boot(Main.java:150) at org.jboss.Main$1.run(Main.java:388) at java.lang.Thread.run(Thread.java:534)Caused by: org.jboss.deployment.DeploymentException: - nested throwable:
 (java.lang.reflect.UndeclaredThrowableException) at org.jboss.system.ServiceConfigurator.install(ServiceConfigurator.java:143) at org.jboss.system.ServiceController.install(ServiceController.java:225) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) at
 org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) at $Proxy4.install(Unknown Source) at org.jboss.deployment.SARDeployer.create(SARDeployer.java:183) ... 17 moreCaused by: java.lang.reflect.UndeclaredThrowableException at org.jboss.system.ServiceCreator.install(ServiceCreator.java:181) at org.jboss.system.ServiceConfigurator.internalInstall(ServiceConfigurator.java:155) at org.jboss.system.ServiceConfigurator.install(ServiceConfigurator.java:118) ... 27 moreCaused by: java.lang.NoClassDefFoundError:
 org/apache/log4j/Category at org.jnp.server.Main.init(Main.java:118) at org.jboss.naming.NamingService.init(NamingService.java:52) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:274) at org.jboss.mx.server.MBeanServerImpl.instantiate(MBeanServerImpl.java:847) at
 org.jboss.mx.server.MBeanServerImpl.instantiate(MBeanServerImpl.java:291) at org.jboss.mx.server.MBeanServerImpl.createMBean(MBeanServerImpl.java:318) at org.jboss.system.ServiceCreator.install(ServiceCreator.java:98) ... 29 more21:00:31,593 ERROR [Server] Failed to startorg.jboss.deployment.DeploymentException: create operation failed for package file:/D:/docs11i/jboss-3.2.2/server/default/conf/jboss-service.xml; - nested throwable: (org.jboss.deployment.DeploymentException: - nested throwable: (java.lang.reflect.UndeclaredThrowableException)) at org.jboss.deployment.SARDeployer.create(SARDeployer.java:202) at org.jboss.deployment.MainDeployer.create(MainDeployer.java:776) at
 org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:631) at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:605) at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:589) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at