RE: [JBoss-user] how to upgrade from 3.0.4 to 3.2.2

2003-10-28 Thread Srinivas Malladi
use -ds for datasources. For example use oracle-ds.xml and contents of file for local 
transcations 











  
yourjndiname

jdbc:oracle:thin:@:1521:
oracle.jdbc.driver.OracleDriver
oracleusername
oraceusepassword
10
20
  
   

 





-Original Message-
From: Gary S. Cuozzo [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 28, 2003 5:47 PM
To: JBoss-user
Subject: RE: [JBoss-user] how to upgrade from 3.0.4 to 3.2.2


Eric,
For your datasource config, the -service files seemed to be replaced
with -ds files.  When I migrated from 3.0.4, I started fresh with one of
the files in .../jboss/docs/examples/jca.  There are some oracle files
in there.

Hope that helps.
Gary.


On Tue, 2003-10-28 at 16:56, Eric J Kaplan wrote:
> Jae
> 
>  
> 
> I know you had the best intentions, but could you be more specific?  I
> already know the formats have changed because it doesnÿt work.
> 
>  
> 
> Regards
> 
>  
> 
> Eric
> 
>  
> 
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Jae
> Gangemi
> Sent: Tuesday, October 28, 2003 4:33 PM
> To: [EMAIL PROTECTED]
> Subject: RE: [JBoss-user] how to upgrade from 3.0.4 to 3.2.2
> 
>  
> 
>  
> 
> 
>   i believe the deployment descriptors and datasource file formats
> changed from 3.0.x to 3.2.x. i had to deal w/ the same types of issues
> 
> 
> way back when i upgraded. also, make sure you are using the correct
> dtd definitions in any ejbs that you may be using. 
> 
> 
>  
> 
> 
>   hope this helps!
> 
> 
> -jae 
> 
> -Original Message-
> From: Eric J Kaplan [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, October 28, 2003 3:56 PM
> To: [EMAIL PROTECTED]
> Subject: [JBoss-user] how to upgrade from 3.0.4 to 3.2.2
> 
> All
> 
>  
> 
> Can someone illuminate me as to the upgrade path from 3.0.4 to
> 3.2.2.  I thought it would be a simple matter of dropping
> oracle-service.xml from 3.0.4 deploy directory into the 3.2.2
> directory but this is not the case.  I get a bunch of error
> messages, shown below.  Can someone pls tell me what I need to
> do.  Hopefully, benefiting from this jboss upgrade does not
> involve major work on my end.
> 
>  
> 
> Regards
> 
>  
> 
> Eric Kaplan
> 
>  
> 
> 15:50:17,921 INFO  [MainDeployer] Starting deployment of
> package: file:/C:/arman
> 
> ta-3rdparty/jboss-3.2.2/server/default/deploy/oracle-service.xml
> 
> 15:50:17,984 INFO  [ServiceConfigurator] Problem configuring
> service jboss.jca:s
> 
> ervice=LocalTxDS,name=OracleDS
> 
> org.jboss.deployment.DeploymentException: No Attribute found
> with name: JndiName
> 
>  
> 
> at
> org.jboss.system.ServiceConfigurator.configure(ServiceConfigurator.ja
> 
> va:338)
> 
> at
> org.jboss.system.ServiceConfigurator.internalInstall(ServiceConfigura
> 
> tor.java:176)
> 
> at
> org.jboss.system.ServiceConfigurator.processDependency(ServiceConfigu
> 
> rator.java:443)
> 
> at
> org.jboss.system.ServiceConfigurator.configure(ServiceConfigurator.ja
> 
> va:356)
> 
> at
> org.jboss.system.ServiceConfigurator.internalInstall(ServiceConfigura
> 
> tor.java:176)
> 
> at
> org.jboss.system.ServiceConfigurator.install(ServiceConfigurator.java
> 
> :118)
> 
> at
> org.jboss.system.ServiceController.install(ServiceController.java:225
> 
> )
> 
> at
> sun.reflect.GeneratedMethodAccessor36.invoke(Unknown Source)
> 
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
> 
> sorImpl.java:25)
> 
> at java.lang.reflect.Method.invoke(Method.java:324)
> 
> at
> org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBea
> 
> nDispatcher.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)
> 
> at
> org.jboss.deployment.MainDeployer.create(MainDeployer.java:786)
> 
> at
> org.jboss.deployment.MainDeployer

Re: [JBoss-user] MDB and Jaas

2003-10-28 Thread Brian Wallis
On Wed, 29 Oct 2003 02:21, Adrian Brock wrote:
> This works by wrapping the real connection factory. The wrapper's
> createTopicConnection() is redirected to the real connection factory's
> createTopicConnection(user, passwd); passing the jaas user/credential.

Great, thanks. I thought there had to be something like that within JBoss. 

brian wallis...



---
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] 3.2.2 : Incorrect SQL generation

2003-10-28 Thread Phil Shrimpton
On Tuesday 28 October 2003 18:40, Alexey Loubyansky wrote:

Alex

> > Beacuse the detail tables are listed in the FROM clause of the SQL,
> > the Joins should always be done or all records from the detail tables
> > will be returned regardless of if they have a 'match' in the master table
> > or not.
>
> Do you agree that some results will be missed when joining all the tables?

Using that form of SQL join, yes I agree. 

> >>>SELECT OBJECT(O) from Customer WHERE (o.id = ?1 OR o.contact.surname =
> >>>?2)
> >>>
> > But there is a FK/releationship between Customer.ContactID Contact.ID, so
> > records where those two fields don't match should not be returned
> >
> >>You can specify also DISTINCT in EJBQL.
> >
> > You can, and it does work,  but in my case it makes the difference
> > between returning the resultset from a few hundred milliseconds in 3.0.2
> > to about 12 minutes in 3.2.2
>
> It is the real problem.

This is because in my case I have over 25 records in each of the three 
detail tables, and althougth only one record in each table matches the 
'master record', I get a resultset of over 80 records.

> >>Now, suppose, I add a customer w/o a contact.
> >>Insert into customer (id, contactid) values (2, NULL)
> >>
> >>The EJBQL query is the same but customer id parameter is 2.
> >>3.0.8 will return empty collection. Is it correct?
> >
> > I would say yes as Jboss is generating old style SQL-89 joins.
>
> Then, I would say, no. Because, the result is incorrect. 

The result is correct for the SQL-89 style joins 3.0.x generated (and what I 
expect), but maybe not correct for what that EJB-QL should return according 
to the spec (if there is a spec?)

> You did convince me that it is implemented not the right way. 

Don't just take my word on it.  The fact that only I have rasied this issue, 
and nobody else should rasie a few warning flags, it does for me

> But at least it
> produces correct results. (And you agreed, right?)

Yes.

> >  I generally
> > use, when coding direcly, SQL92 joins (which perform a lot better in most
> > RDBMS's BTW), and can handle the situation of a null detail table id by
> > using left outer joins.
>
> I will work on it.

Implementing joins SQL-92 style would make things a lot easier (and perform 
better) IMO, but not all DB's handle them, although the majority of the do.

Phil

-- 
 10:07pm  up 50 days, 17 min,  1 user,  load average: 0.60, 0.24, 0.14
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


Re: [JBoss-user] Problem with SQL query for MySQL

2003-10-28 Thread Rafal Kedziorski
At 20:24 28.10.2003 +0200, Alexey Loubyansky wrote:
It is fixed now.
In main cvs branch?

Regards,
Rafal

alex

Rafal Kedziorski wrote:

hi,
I'm using MySQL 4.0.13 and 4.0.14 (4.0.16 I will test tomorrow) and JBoss 
3.2.2. And I have problems with this query (generated by JBoss):
insert into user(class_id, retail_id, mandant_id, language_id, 
user_data_id, nickname, login_name, password, status, creation_date, 
last_login_date) values ('35F7A660096411D89BC0D1907F01', '1234', 2, 
1, null, null, '[EMAIL PROTECTED]', 'demo', 8, '2003-10-28 17:31:36', null)
but the same query with space after user
insert into user (class_id, retail_id, mandant_id, language_id, 
user_data_id, nickname, login_name, password, status, creation_date, 
last_login_date) values ('35F7A660096411D89BC0D1907F01', '1234', 2, 
1, null, null, '[EMAIL PROTECTED]', 'demo', 8, '2003-10-28 17:31:36', null)
works.
This exception is shown:
17:31:36,406 ERROR [UserEntityBean] Could not create entity 
java.sql.SQLException: Syntax error or access violation,  message from 
server: "You have an error in your SQL syntax.  Check the manual that 
corresponds to your MySQL server version for the right syntax to use near 
'user(class_id, retail_id, mandant_id, language_id, user_data_id" at 
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1651) at 
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:889) at 
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:956) at 
com.mysql.jdbc.Connection.execSQL(Connection.java:1874) at 
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1700 
) at 
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1569 
) at 
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:321) 
at 
org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCMySQLCreateCommand.executeInsert(JDBCMySQLCreateCommand.java:66) 
at 
org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.performInsert(JDBCAbstractCreateCommand.java:295) 
at 
org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.execute(JDBCAbstractCreateCommand.java:144) 
at 
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:518) 
at 
org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:208) 
at 
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:269) 
at 
org.jboss.ejb.EntityContainer.createLocalHome(EntityContainer.java:580) 
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.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1042) 
at 
org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88) 
at 
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:197) 
at 
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:214) 

...

Regards,
Rafal
---
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] serial mdb execution?

2003-10-28 Thread Adrian Brock
This was discussed last month on this list.

The invoker drives the mdb. 
For the behaviour you want, there is little point configuring
1 mdb instance if you have 15 XASessions (each with an
attached message) waiting to use that instance.

Also, the pool is only a constraint if you use
strict pooling.

Regards,
Adrian

On Tue, 2003-10-28 at 22:34, [EMAIL PROTECTED] wrote:
> Just for my own understanding of Jboss JMS/MDB implementation, what is the
> difference between changing the invoker configuration as described below and
> changing the container pool configuration in the Standard Message Driven
> Bean (standardjboss.xml):
> 
>   
>  100
>   
> 
> If I put the Maximum size of the container-pool-conf to 1, I will also
> serialize all message handling, am I not?
> If yes, what make more sense between this change and the invoker change
> (also I agree that trying to serialize the message handling is not a good
> idea)?
> 
> Thomas
> 
> -Original Message-
> From: Adrian Brock [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, October 28, 2003 5:50 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [JBoss-user] serial mdb execution?
> 
> 
> On Tue, 2003-10-28 at 16:17, Scheil, Sven wrote:
> > 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.
> 
> 
> The number of concurrent sessions for an MDB is configured on the invoker.
> This is from standardjboss.xml in 3.2. You can make your own configurations
> using jboss.xml
> 
> This isn't guaranteed to work. The MDB could rollback the message delivery
> causing the messages to be delivered out of order.
> 
> Why do people take an asynchronous system like messaging and try to
> reimplement a synchronous system. What is wrong with invocations?
> 
>   
>  message-driven-bean
>  default
> 
> org.jboss.ejb.plugins.jms.JMSContainerInvoker
>  
>
> DefaultJMSProvider
>
> StdJMSPool
> 15 
> 1
> 
>10
>
>   queue/DLQ
>   10
>   0
>
> 
>  
>   
> 
> 
> Regards,
> Adrian
> 
> > 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
-- 
 
Adrian Brock
Director of Support
Back Office
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] how to upgrade from 3.0.4 to 3.2.2

2003-10-28 Thread Gary S. Cuozzo
Eric,
For your datasource config, the -service files seemed to be replaced
with -ds files.  When I migrated from 3.0.4, I started fresh with one of
the files in .../jboss/docs/examples/jca.  There are some oracle files
in there.

Hope that helps.
Gary.


On Tue, 2003-10-28 at 16:56, Eric J Kaplan wrote:
> Jae
> 
>  
> 
> I know you had the best intentions, but could you be more specific?  I
> already know the formats have changed because it doesn’t work.
> 
>  
> 
> Regards
> 
>  
> 
> Eric
> 
>  
> 
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Jae
> Gangemi
> Sent: Tuesday, October 28, 2003 4:33 PM
> To: [EMAIL PROTECTED]
> Subject: RE: [JBoss-user] how to upgrade from 3.0.4 to 3.2.2
> 
>  
> 
>  
> 
> 
>   i believe the deployment descriptors and datasource file formats
> changed from 3.0.x to 3.2.x. i had to deal w/ the same types of issues
> 
> 
> way back when i upgraded. also, make sure you are using the correct
> dtd definitions in any ejbs that you may be using. 
> 
> 
>  
> 
> 
>   hope this helps!
> 
> 
> -jae 
> 
> -Original Message-
> From: Eric J Kaplan [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, October 28, 2003 3:56 PM
> To: [EMAIL PROTECTED]
> Subject: [JBoss-user] how to upgrade from 3.0.4 to 3.2.2
> 
> All
> 
>  
> 
> Can someone illuminate me as to the upgrade path from 3.0.4 to
> 3.2.2.  I thought it would be a simple matter of dropping
> oracle-service.xml from 3.0.4 deploy directory into the 3.2.2
> directory but this is not the case.  I get a bunch of error
> messages, shown below.  Can someone pls tell me what I need to
> do.  Hopefully, benefiting from this jboss upgrade does not
> involve major work on my end.
> 
>  
> 
> Regards
> 
>  
> 
> Eric Kaplan
> 
>  
> 
> 15:50:17,921 INFO  [MainDeployer] Starting deployment of
> package: file:/C:/arman
> 
> ta-3rdparty/jboss-3.2.2/server/default/deploy/oracle-service.xml
> 
> 15:50:17,984 INFO  [ServiceConfigurator] Problem configuring
> service jboss.jca:s
> 
> ervice=LocalTxDS,name=OracleDS
> 
> org.jboss.deployment.DeploymentException: No Attribute found
> with name: JndiName
> 
>  
> 
> at
> org.jboss.system.ServiceConfigurator.configure(ServiceConfigurator.ja
> 
> va:338)
> 
> at
> org.jboss.system.ServiceConfigurator.internalInstall(ServiceConfigura
> 
> tor.java:176)
> 
> at
> org.jboss.system.ServiceConfigurator.processDependency(ServiceConfigu
> 
> rator.java:443)
> 
> at
> org.jboss.system.ServiceConfigurator.configure(ServiceConfigurator.ja
> 
> va:356)
> 
> at
> org.jboss.system.ServiceConfigurator.internalInstall(ServiceConfigura
> 
> tor.java:176)
> 
> at
> org.jboss.system.ServiceConfigurator.install(ServiceConfigurator.java
> 
> :118)
> 
> at
> org.jboss.system.ServiceController.install(ServiceController.java:225
> 
> )
> 
> at
> sun.reflect.GeneratedMethodAccessor36.invoke(Unknown Source)
> 
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
> 
> sorImpl.java:25)
> 
> at java.lang.reflect.Method.invoke(Method.java:324)
> 
> at
> org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBea
> 
> nDispatcher.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)
> 
> at
> org.jboss.deployment.MainDeployer.create(MainDeployer.java:786)
> 
> at
> org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:641)
> 
> at
> org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:605)
> 
> at
> sun.reflect.GeneratedMethodAccessor37.invoke(Unknown Source)
> 
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
> 
> sorImpl.java:25)
> 
> at java.lang.reflect.Method.invoke(Metho

RE: [JBoss-user] serial mdb execution?

2003-10-28 Thread thomas . cherel

Just for my own understanding of Jboss JMS/MDB implementation, what is the
difference between changing the invoker configuration as described below and
changing the container pool configuration in the Standard Message Driven
Bean (standardjboss.xml):

  
 100
  

If I put the Maximum size of the container-pool-conf to 1, I will also
serialize all message handling, am I not?
If yes, what make more sense between this change and the invoker change
(also I agree that trying to serialize the message handling is not a good
idea)?

Thomas

-Original Message-
From: Adrian Brock [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 28, 2003 5:50 PM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] serial mdb execution?


On Tue, 2003-10-28 at 16:17, Scheil, Sven wrote:
> 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.


The number of concurrent sessions for an MDB is configured on the invoker.
This is from standardjboss.xml in 3.2. You can make your own configurations
using jboss.xml

This isn't guaranteed to work. The MDB could rollback the message delivery
causing the messages to be delivered out of order.

Why do people take an asynchronous system like messaging and try to
reimplement a synchronous system. What is wrong with invocations?

  
 message-driven-bean
 default

org.jboss.ejb.plugins.jms.JMSContainerInvoker
 
   
DefaultJMSProvider
   
StdJMSPool
15 
1

   10
   
  queue/DLQ
  10
  0
   

 
  


Regards,
Adrian

> 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
-- 
 
Adrian Brock
Director of Support
Back Office
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


---
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] Protocol violation!!!!

2003-10-28 Thread Eric J Kaplan
I apologize.  We didn't notice before but there was an out of memory
error on the server which was most likely the root cause.

Regards

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Eric J
Kaplan
Sent: Tuesday, October 28, 2003 2:49 PM
To: [EMAIL PROTECTED]
Subject: [JBoss-user] Protocol violation

We just experienced a problem with jboss from the client trying to call
a method in a session bean.  It seems to be some kind of protocol
violation.  I've included the log below.  Any ideas?  It's fairly
urgent.

Regards

Eric

2003-10-28 14:43:42,325 INFO  [main]
ArmantaDataAbstraction...initializing
2003-10-28 14:43:44,168 WARN  [main] Report date not set, defaulting to:
10/27/2
003
2003-10-28 14:44:17,926 INFO  [AWT-EventQueue-0] Setting reporting date
to:
10/2
7/2003
java.rmi.ServerException: RemoteException occurred in server thread;
nested
exce
ption is:
java.rmi.ServerException: EJBException:; nested exception is:
javax.ejb.EJBException: null; CausedByException is:
null; CausedByException is:
Protocol violation; nested exception is:
javax.ejb.EJBException: null; CausedByException is:
Protocol violation
at
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:292)
at sun.rmi.transport.Transport$1.run(Transport.java:148)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:4
60)
at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport
.java:701)
at java.lang.Thread.run(Thread.java:536)
at
sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(Stream
RemoteCall.java:247)
at
sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:
223)
at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:133)
at
org.jboss.invocation.jrmp.server.JRMPInvoker_Stub.invoke(Unknown
Sour
ce)
at
org.jboss.invocation.jrmp.interfaces.JRMPInvokerProxy.invoke(JRMPInvo
kerProxy.java:138)
at
org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.jav
a:108)
at
org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.
java:77)
at
org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:8
0)
at
org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessi
onInterceptor.java:111)
at
org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:76)
at $Proxy3.login(Unknown Source)
at com.armanta.rptgen.DataServer.login(DataServer.java:1307)
at com.armanta.guiutil.LoginDialog.c(LoginDialog.java:301)
at com.armanta.guiutil.LoginDialog.c(LoginDialog.java:176)
at com.armanta.guiutil.bd.actionPerformed(bd.java:235)
at
javax.swing.JTextField.fireActionPerformed(JTextField.java:489)
at javax.swing.JTextField.postActionEvent(JTextField.java:670)
at
javax.swing.JTextField$NotifyAction.actionPerformed(JTextField.java:7
84)
at
javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1512)
at
javax.swing.JComponent.processKeyBinding(JComponent.java:2435)
at
javax.swing.JComponent.processKeyBindings(JComponent.java:2470)
at javax.swing.JComponent.processKeyEvent(JComponent.java:2398)
at java.awt.Component.processEvent(Component.java:4943)
at java.awt.Container.processEvent(Container.java:1566)
at java.awt.Component.dispatchEventImpl(Component.java:3639)
at java.awt.Container.dispatchEventImpl(Container.java:1623)
at java.awt.Component.dispatchEvent(Component.java:3480)
at
java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.ja
va:1708)
at
java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboard
FocusManager.java:593)
at
java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeybo
ardFocusManager.java:765)
at
java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeybo
ardFocusManager.java:698)
at
java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFoc
usManager.java:559)
at java.awt.Component.dispatchEventImpl(Component.java:3509)
at java.awt.Container.dispatchEventImpl(Container.java:1623)
at java.awt.Window.dispatchEventImpl(Window.java:1590)
at java.awt.Component.dispatchEvent(Component.java:3480)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:450)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchTh
read.java:197)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.java:150)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:144)

at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:136)

at java.awt.EventDis

RE: [JBoss-user] how to upgrade from 3.0.4 to 3.2.2

2003-10-28 Thread Adrian Brock
On Tue, 2003-10-28 at 21:56, Eric J Kaplan wrote:
> Jae
> 
>  
> 
> I know you had the best intentions, but could you be more specific?  I
> already know the formats have changed because it doesnât work.
> 

Tobias's notes here should get your started.
http://www.jboss.org/thread.jsp?forum=67&thread=30909

I imagine most of your problems are due to the strict verification
of ejb deployments which can be turned off in conf/jboss-service.xml
You should fix them all eventually though (look at the warnings).

Regards,
Adrian

>  
> 
> Regards
> 
>  
> 
> Eric
> 
>  
> 
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Jae
> Gangemi
> Sent: Tuesday, October 28, 2003 4:33 PM
> To: [EMAIL PROTECTED]
> Subject: RE: [JBoss-user] how to upgrade from 3.0.4 to 3.2.2
> 
>  
> 
>  
> 
> 
>   i believe the deployment descriptors and datasource file formats
> changed from 3.0.x to 3.2.x. i had to deal w/ the same types of issues
> 
> 
> way back when i upgraded. also, make sure you are using the correct
> dtd definitions in any ejbs that you may be using. 
> 
> 
>  
> 
> 
>   hope this helps!
> 
> 
> -jae 
> 
> -Original Message-
> From: Eric J Kaplan [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, October 28, 2003 3:56 PM
> To: [EMAIL PROTECTED]
> Subject: [JBoss-user] how to upgrade from 3.0.4 to 3.2.2
> 
> All
> 
>  
> 
> Can someone illuminate me as to the upgrade path from 3.0.4 to
> 3.2.2.  I thought it would be a simple matter of dropping
> oracle-service.xml from 3.0.4 deploy directory into the 3.2.2
> directory but this is not the case.  I get a bunch of error
> messages, shown below.  Can someone pls tell me what I need to
> do.  Hopefully, benefiting from this jboss upgrade does not
> involve major work on my end.
> 
>  
> 
> Regards
> 
>  
> 
> Eric Kaplan
> 
>  
> 
> 15:50:17,921 INFO  [MainDeployer] Starting deployment of
> package: file:/C:/arman
> 
> ta-3rdparty/jboss-3.2.2/server/default/deploy/oracle-service.xml
> 
> 15:50:17,984 INFO  [ServiceConfigurator] Problem configuring
> service jboss.jca:s
> 
> ervice=LocalTxDS,name=OracleDS
> 
> org.jboss.deployment.DeploymentException: No Attribute found
> with name: JndiName
> 
>  
> 
> at
> org.jboss.system.ServiceConfigurator.configure(ServiceConfigurator.ja
> 
> va:338)
> 
> at
> org.jboss.system.ServiceConfigurator.internalInstall(ServiceConfigura
> 
> tor.java:176)
> 
> at
> org.jboss.system.ServiceConfigurator.processDependency(ServiceConfigu
> 
> rator.java:443)
> 
> at
> org.jboss.system.ServiceConfigurator.configure(ServiceConfigurator.ja
> 
> va:356)
> 
> at
> org.jboss.system.ServiceConfigurator.internalInstall(ServiceConfigura
> 
> tor.java:176)
> 
> at
> org.jboss.system.ServiceConfigurator.install(ServiceConfigurator.java
> 
> :118)
> 
> at
> org.jboss.system.ServiceController.install(ServiceController.java:225
> 
> )
> 
> at
> sun.reflect.GeneratedMethodAccessor36.invoke(Unknown Source)
> 
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
> 
> sorImpl.java:25)
> 
> at java.lang.reflect.Method.invoke(Method.java:324)
> 
> at
> org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBea
> 
> nDispatcher.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)
> 
> at
> org.jboss.deployment.MainDeployer.create(MainDeployer.java:786)
> 
> at
> org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:641)
> 
> at
> org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:605)
> 
> at
> sun.reflect.GeneratedMethodAccessor37.invoke(Unknown Source)
> 
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
> 
> sorImpl.java:25)
>  

Re: [JBoss-user] serial mdb execution?

2003-10-28 Thread Adrian Brock
On Tue, 2003-10-28 at 16:17, Scheil, Sven wrote:
> 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.


The number of concurrent sessions for an MDB is configured on the
invoker. This is from standardjboss.xml in 3.2. You can make your
own configurations using jboss.xml

This isn't guaranteed to work. The MDB could rollback the message
delivery causing the messages to be delivered out of order.

Why do people take an asynchronous system like messaging and
try to reimplement a synchronous system. What is wrong with
invocations?

  
 message-driven-bean
 default

org.jboss.ejb.plugins.jms.JMSContainerInvoker
 
   
DefaultJMSProvider
   
StdJMSPool
15 
1

   10
   
  queue/DLQ
  10
  0
   

 
  


Regards,
Adrian

> 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
-- 
 
Adrian Brock
Director of Support
Back Office
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] JZ0C0: Connection is already closed

2003-10-28 Thread Adrian Brock
Hi,

I don't think this is the same problem.

The fix you mention was a simple typo.
This diff fixes that problem:
http://cvs.sourceforge.net/viewcvs.py/jboss/jbosscx/src/main/org/jboss/resource/connectionmanager/CachedConnectionManager.java?r1=1.2.2.10&r2=1.2.2.10.2.1

The fix you want is actually in 3.2.2
JBoss should not be try to close a connection after it has destroyed it
because of an error.
http://cvs.sourceforge.net/viewcvs.py/jboss/jbosscx/src/main/org/jboss/resource/adapter/jdbc/BaseWrapperManagedConnection.jpp?r1=1.1.2.6&r2=1.1.2.7

Regards,
Adrian

On Tue, 2003-10-28 at 16:03, Muraly R wrote:
> Hi Gurus,
> I am using JB0ss3.0.7.
> I am getting the following Info messages in my JBoss logs.
> INFO  [LocalTxConnectionManager$LocalConnectionEventListener]
> throwable from unregister connection
> java.lang.IllegalStateException: Trying to return an unknown
> connection1! [EMAIL PROTECTED]
> 
> After this when during some of the transaction intensive processes, I
> get the following exceptions:
> 15:36:09,570 ERROR [LogInterceptor] EJBException, causedBy:
> java.sql.SQLException: JZ0C0: Connection is already closed.
> 
> which causes the current transaction to terminate.
> 
> I did check out the user list and found the following link:
> http://sourceforge.net/tracker/index.php?func=detail&aid=692398&group_id=22866&atid=376685
> 
> Does the ERROR above is because of the INFO message.?
> 
> SInce the product is on the final phase of development, we cannot
> afford to migarte to 3.2 version as specified in the link.
> 
> Any suggestions on how the issue can be resolved will be much
> appreciable.
> 
> Please find attached the stack trace  as attachment. There are
> lot of such messages, I am pasting only the snip due to the
> restriction on mail size send.
> 
> TIA
> Muraly
-- 
 
Adrian Brock
Director of Support
Back Office
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] forums down/slow?

2003-10-28 Thread Eric J Kaplan
Thanks Ionel.  We still see a problem (just with the forums, I can get
to other parts of jboss.org just fine).  I'm located in New Jersey, USA.
Our ISP is a major vendor, and we don't have problems with other sights.
Very very strange!

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ionel
GARDAIS
Sent: Tuesday, October 28, 2003 3:19 PM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] forums down/slow?

 --- Eric J Kaplan <[EMAIL PROTECTED]> a écrit :
> Can anyone get to the forums?  I go to jboss.org,
> click on forums, and
> they never come up.

Got them w/o problems ... 21:18 GMT+1

=
-- 
Regards,
Ionel

___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com


---
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] java thread dumper for windows background processes - (Not for background processes)

2003-10-28 Thread Nicholas
This works for most Win32 platforms Win98 and beyond,
but only if the process is in a window. We built it to
execute a thread dump if the target process hit a
threshhold number of threads. I think the window bit
is mandatory.

The command line is:

td.vbs c:\\j2sdk1.4.2\\bin\\java.exe 60 100 "JBoss
Server"

Script Name: td.cbs
Arg 1: Full Command Line Name (Double Back Slashes)
Arg 2: Thread Threshhold
Arg 3: Sleep time between polls (ms)
Arg 4: Name of Window where the target process is
running (where the Ctrl-C will be sent)

Note that the executable name can be replaced with the
PID if you have multiple "java.exe"'s running. The
"column" name is ProcessId. 

We also installed this process as a service.

I have also attached a sar for an MBean we called
ThreadMonster which spawned a bunch of threads on
demmand (via the JMX-Console) so we could test it.

Example:


C:\wsf>td.vbs c:\\j2sdk1.4.2\\bin\\java.exe 60 1
"JBoss Server"
Microsoft (R) Windows Script Host Version 5.6
Copyright (C) Microsoft Corporation 1996-2001. All
rights reserved.

===
Thread Dump Watcher - Started:10/28/2003:3:33:28 PM
===
Program Name:c:\\j2sdk1.4.2\\bin\\java.exe
Threshhold:60
Sleep Time:1
Target Window Name:JBoss Server
Process Query:Select * from Win32_Process where
ExecutablePath = 'c:\\j2sdk1.4.2\\bin\\java.exe'
===
10/28/2003:3:33:28 PM - Process
[c:\j2sdk1.4.2\bin\java.exe] ThreadCount:54
10/28/2003:3:33:38 PM - Process
[c:\j2sdk1.4.2\bin\java.exe] ThreadCount:54
10/28/2003:3:33:48 PM - Process
[c:\j2sdk1.4.2\bin\java.exe] ThreadCount:54
10/28/2003:3:33:58 PM - Process
[c:\j2sdk1.4.2\bin\java.exe] ThreadCount:54


###td.vbs
Set objArgs = WScript.Arguments
Set StdOut = WScript.StdOut
Dim query
Dim processName
Dim sleepTime
Dim targetWindow
Dim threadCount
processName = objArgs(0)
threadCount = objArgs(1)
sleepTime = objArgs(2)
targetWindow = objArgs(3)
StdOut.WriteLine
"==="
StdOut.WriteLine "Thread Dump Watcher - Started:" &
Date() & ":" & Time()
StdOut.WriteLine
"==="
StdOut.WriteLine "Program Name:" & processName
StdOut.WriteLine "Threshhold:" & threadCount
StdOut.WriteLine "Sleep Time:" & sleepTime
StdOut.WriteLine "Target Window Name:" &
targetWindow
query = "Select * from Win32_Process where
ExecutablePath = '" & processName & "'"
StdOut.WriteLine "Process Query:" & query
StdOut.WriteLine
"==="

While 1=1
On Error Resume Next
strComputer = "."
Set objWMIService = GetObject("winmgmts:\\" &
strComputer & "\root\cimv2")
Set colItems = objWMIService.ExecQuery(query,,48)
For Each objItem in colItems
StdOut.WriteLine  Date() & ":" & Time() & " -
Process [" & objItem.ExecutablePath & "] ThreadCount:"
 & objItem.ThreadCount  
If objItem.ThreadCount > threadCount Then
StdOut.WriteLine 
""
StdOut.WriteLine  Date() & ":" & 
Time() & " -
ALERT - Process [" & objItem.ExecutablePath & "]
ThreadCount:"  & objItem.ThreadCount
StdOut.WriteLine 
""
Set WshShell =
WScript.CreateObject("WScript.Shell")
WshShell.AppActivate(targetWindow)
WshShell.SendKeys ("^{BREAK}")
End If
Next
WScript.sleep(sleepTime)
Wend

#

--- Sebastian Hauer <[EMAIL PROTECTED]> wrote:
> Hi JBoss users,
> 
> Sorry for being off topic here but I figured some of
> you might have had
> the sam

Re: [JBoss-user] forums down/slow?

2003-10-28 Thread Ionel GARDAIS
 --- Eric J Kaplan <[EMAIL PROTECTED]> a écrit :
> Can anyone get to the forums?  I go to jboss.org,
> click on forums, and
> they never come up.

Got them w/o problems ... 21:18 GMT+1

=
-- 
Regards,
Ionel

___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com


---
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] forums down/slow?

2003-10-28 Thread Eric J Kaplan








Can anyone get to the forums?  I go to jboss.org, click on forums, and they
never come up.

 

Eric J. Kaplan

Armanta, Inc.

350 Mt. Kemble
  Ave.

Morristown, NJ 07960

 








[JBoss-user] using mail datasource

2003-10-28 Thread Jiri Chaloupka
Hallo, I was tried sending the form to e-mail adress and I got :
19:57:11,390 ERROR [STDERR] java.lang.IllegalStateException: Not connected
19:57:11,391 ERROR [STDERR] at 
com.sun.mail.smtp.SMTPTransport.checkConnected(SMTPTransport.java:1029)
19:57:11,391 ERROR [STDERR] at 
com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:288)


I Havem datasource defined in mail-service.xml deployed as java:/Mail, and 
Postfix program on localhost.

I have code:
Context initCtx = new InitialContext();
javax.mail.Session session = (javax.mail.Session) initCtx.lookup("java:/
Mail");
MimeMessage message = new MimeMessage(session);
message.setFrom(new InternetAddress("[EMAIL PROTECTED]"));
message.setSubject("mail.subject");
message.setText(body.toString());
Transport transport = session.getTransport();
transport.sendMessage(message,
 new InternetAddress[]{new InternetAddress("[EMAIL PROTECTED]")});

Where is problem?
Thanks, Jiri



---
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] Protocol violation!!!!

2003-10-28 Thread Eric J Kaplan
We just experienced a problem with jboss from the client trying to call
a method in a session bean.  It seems to be some kind of protocol
violation.  I've included the log below.  Any ideas?  It's fairly
urgent.

Regards

Eric

2003-10-28 14:43:42,325 INFO  [main]
ArmantaDataAbstraction...initializing
2003-10-28 14:43:44,168 WARN  [main] Report date not set, defaulting to:
10/27/2
003
2003-10-28 14:44:17,926 INFO  [AWT-EventQueue-0] Setting reporting date
to:
10/2
7/2003
java.rmi.ServerException: RemoteException occurred in server thread;
nested
exce
ption is:
java.rmi.ServerException: EJBException:; nested exception is:
javax.ejb.EJBException: null; CausedByException is:
null; CausedByException is:
Protocol violation; nested exception is:
javax.ejb.EJBException: null; CausedByException is:
Protocol violation
at
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:292)
at sun.rmi.transport.Transport$1.run(Transport.java:148)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:4
60)
at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport
.java:701)
at java.lang.Thread.run(Thread.java:536)
at
sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(Stream
RemoteCall.java:247)
at
sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:
223)
at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:133)
at
org.jboss.invocation.jrmp.server.JRMPInvoker_Stub.invoke(Unknown
Sour
ce)
at
org.jboss.invocation.jrmp.interfaces.JRMPInvokerProxy.invoke(JRMPInvo
kerProxy.java:138)
at
org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.jav
a:108)
at
org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.
java:77)
at
org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:8
0)
at
org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessi
onInterceptor.java:111)
at
org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:76)
at $Proxy3.login(Unknown Source)
at com.armanta.rptgen.DataServer.login(DataServer.java:1307)
at com.armanta.guiutil.LoginDialog.c(LoginDialog.java:301)
at com.armanta.guiutil.LoginDialog.c(LoginDialog.java:176)
at com.armanta.guiutil.bd.actionPerformed(bd.java:235)
at
javax.swing.JTextField.fireActionPerformed(JTextField.java:489)
at javax.swing.JTextField.postActionEvent(JTextField.java:670)
at
javax.swing.JTextField$NotifyAction.actionPerformed(JTextField.java:7
84)
at
javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1512)
at
javax.swing.JComponent.processKeyBinding(JComponent.java:2435)
at
javax.swing.JComponent.processKeyBindings(JComponent.java:2470)
at javax.swing.JComponent.processKeyEvent(JComponent.java:2398)
at java.awt.Component.processEvent(Component.java:4943)
at java.awt.Container.processEvent(Container.java:1566)
at java.awt.Component.dispatchEventImpl(Component.java:3639)
at java.awt.Container.dispatchEventImpl(Container.java:1623)
at java.awt.Component.dispatchEvent(Component.java:3480)
at
java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.ja
va:1708)
at
java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboard
FocusManager.java:593)
at
java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeybo
ardFocusManager.java:765)
at
java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeybo
ardFocusManager.java:698)
at
java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFoc
usManager.java:559)
at java.awt.Component.dispatchEventImpl(Component.java:3509)
at java.awt.Container.dispatchEventImpl(Container.java:1623)
at java.awt.Window.dispatchEventImpl(Window.java:1590)
at java.awt.Component.dispatchEvent(Component.java:3480)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:450)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchTh
read.java:197)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.java:150)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:144)

at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:136)

at java.awt.EventDispatchThread.run(EventDispatchThread.java:99)
Caused by: java.rmi.ServerException: EJBException:; nested exception is:
javax.ejb.EJBException: null; CausedByException is:
null; CausedByException is:
Protocol violation; nested exception is:
javax.ejb.EJBException: null; CausedByException is:
Protocol violation

Re: [JBoss-user] Off topic: java thread dumper for windows background processes

2003-10-28 Thread Dave Smith
On UNIX kill -3 
On Tue, 2003-10-28 at 13:57, Sebastian Hauer wrote:
> Hi JBoss users,
> 
> Sorry for being off topic here but I figured some of you might have had
> the same problem when you are forced to run JBoss on a windows platform
> and you ran as windows service.
> 
> I am looking for something that would enable me to take a thread dump
> from a java process running in the background.  As far as I know only
> CTLR BREAK will trigger a thread dump on windows java and so I guess I
> need some tool that would send this as an event to the java process.
> 
> Regards,
> Sebastian
> 
> ___
> This message is for the named recipient's use only.  It may contain sensitive and 
> private proprietary information.  No confidentiality is waived or lost by any 
> incorrect transmission.  If you are not the intended recipient, please immediately 
> delete it and all copies of it from your system, destroy any hard copies of it and 
> notify the sender.  You must not, directly or indirectly, use, disclose, distribute, 
> print, or copy any part of this message if you are not the intended recipient.  
> Sakonnet Technology, LLC and its subsidiaries reserve the right to monitor all 
> e-mail communications through their networks. Any views expressed in this message 
> are those of the individual sender, except where the message states otherwise and 
> the sender is authorized to state them to be the views of any such entity.  Unless 
> otherwise stated, any pricing information given in this message is indicative only, 
> is subject to change and does not constitute an offer to deal at any price quoted. 
> Any reference to the terms of executed transactions should be treated as preliminary 
> only and subject to our formal written confirmation. 
> 
> 
> 
> ---
> 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
-- 
Dave Smith
CANdata Systems Ltd
416-493-9020



---
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] Off topic: java thread dumper for windows background processes

2003-10-28 Thread Sebastian Hauer
Hi JBoss users,

Sorry for being off topic here but I figured some of you might have had
the same problem when you are forced to run JBoss on a windows platform
and you ran as windows service.

I am looking for something that would enable me to take a thread dump
from a java process running in the background.  As far as I know only
CTLR BREAK will trigger a thread dump on windows java and so I guess I
need some tool that would send this as an event to the java process.

Regards,
Sebastian

___
This message is for the named recipient's use only.  It may contain sensitive and 
private proprietary information.  No confidentiality is waived or lost by any 
incorrect transmission.  If you are not the intended recipient, please immediately 
delete it and all copies of it from your system, destroy any hard copies of it and 
notify the sender.  You must not, directly or indirectly, use, disclose, distribute, 
print, or copy any part of this message if you are not the intended recipient.  
Sakonnet Technology, LLC and its subsidiaries reserve the right to monitor all e-mail 
communications through their networks. Any views expressed in this message are those 
of the individual sender, except where the message states otherwise and the sender is 
authorized to state them to be the views of any such entity.  Unless otherwise stated, 
any pricing information given in this message is indicative only, is subject to change 
and does not constitute an offer to deal at any price quoted. Any reference to the 
terms of executed transactions should be treated as preliminary only and subject to 
our formal written confirmation. 



---
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] 3.2.2 : Incorrect SQL generation

2003-10-28 Thread Alexey Loubyansky
Phil Shrimpton wrote:

On Tuesday 28 October 2003 15:16, Alexey Loubyansky wrote:

Alex


o.contact.surnameUpper = ?2 OR o.vehicle.registrationNumber = ?3
in English.

My interpretation is "select all o that have contact with surname ?2 OR
have vehicle with registration number ?3"
Note, o is allowed to have either contact OR vehicle OR both of them.
Your interpretation is correct, the problem is is that the SQL
generated only does the 'join' with the detail tables if, say
contact.surnameUpper equals the parameter supplied, if not it returns all
records from the contact table, even though only one has a releationship
with 'o'.
Yes, but joining three tables alltogether means my interpretation is
wrong. Don't you think so? 


No.  Beacuse the detail tables are listed in the FROM clause of the SQL, the 
Joins should always be done or all records from the detail tables will be 
returned regardless of if they have a 'match' in the master table or not.
Do you agree that some results will be missed when joining all the tables?


SELECT OBJECT(O) from Customer WHERE (o.id = ?1 OR o.contact.surname =
?2)
Customer ID  Customer.ContactID Contact.ID  Surname
1  2   1  smith
1  2   2  blogs
1  2   3  dow
..becase there is no surname match for "fleury", it returns all contacts
Yes. Remember, we select Customer.ID only. So, we still get the correct
result, i.e. Customer with id=1. 
But there is a FK/releationship between Customer.ContactID Contact.ID, so 
records where those two fields don't match should not be returned


You can specify also DISTINCT in EJBQL.


You can, and it does work,  but in my case it makes the difference between
returning the resultset from a few hundred milliseconds in 3.0.2 to about 12 
minutes in 3.2.2
It is the real problem.


Now, suppose, I add a customer w/o a contact.
Insert into customer (id, contactid) values (2, NULL)
The EJBQL query is the same but customer id parameter is 2.
3.0.8 will return empty collection. Is it correct?


I would say yes as Jboss is generating old style SQL-89 joins.
Then, I would say, no. Because, the result is incorrect. You did 
convince me that it is implemented not the right way. But at least it 
produces correct results. (And you agreed, right?)

 I generally 
use, when coding direcly, SQL92 joins (which perform a lot better in most 
RDBMS's BTW), and can handle the situation of a null detail table id by using 
left outer joins.
I will work on it.

Thank you,

alex

I hope I am missing something simple, but I have a number of these type
of queries, all work fine under JBoss 3.2.2 and another app server,  none
work correctly under 3.2.2
Therefore, please, don't give up. I'll fix it if I am wrong.


I could well be my misunderstanding of something.  And the fact that nobody 
else seems to have reported it does worry me a bit 

Phil




---
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] Problem with SQL query for MySQL

2003-10-28 Thread Alexey Loubyansky
It is fixed now.

alex

Rafal Kedziorski wrote:

hi,

I'm using MySQL 4.0.13 and 4.0.14 (4.0.16 I will test tomorrow) and 
JBoss 3.2.2. And I have problems with this query (generated by JBoss):

insert into user(class_id, retail_id, mandant_id, language_id, 
user_data_id, nickname, login_name, password, status, creation_date, 
last_login_date) values ('35F7A660096411D89BC0D1907F01', '1234', 2, 
1, null, null, '[EMAIL PROTECTED]', 'demo', 8, '2003-10-28 17:31:36', null)

but the same query with space after user

insert into user (class_id, retail_id, mandant_id, language_id, 
user_data_id, nickname, login_name, password, status, creation_date, 
last_login_date) values ('35F7A660096411D89BC0D1907F01', '1234', 2, 
1, null, null, '[EMAIL PROTECTED]', 'demo', 8, '2003-10-28 17:31:36', null)

works.

This exception is shown:

17:31:36,406 ERROR [UserEntityBean] Could not create entity 
java.sql.SQLException: Syntax error or access violation,  message from 
server: "You have an error in your SQL syntax.  Check the manual that 
corresponds to your MySQL server version for the right syntax to use 
near 'user(class_id, retail_id, mandant_id, language_id, user_data_id" 
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1651) at 
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:889) at 
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:956) at 
com.mysql.jdbc.Connection.execSQL(Connection.java:1874) at 
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1700) 
at 
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1569) 
at 
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:321) 
at 
org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCMySQLCreateCommand.executeInsert(JDBCMySQLCreateCommand.java:66) 
at 
org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.performInsert(JDBCAbstractCreateCommand.java:295) 
at 
org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.execute(JDBCAbstractCreateCommand.java:144) 
at 
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:518) 
at 
org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:208) 
at 
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:269) 
at 
org.jboss.ejb.EntityContainer.createLocalHome(EntityContainer.java:580) 
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.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1042) 
at 
org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88) 
at 
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:197) 
at 
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:214) 

...

Regards,
Rafal
---
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] serial mdb execution?

2003-10-28 Thread Barlow, Dustin
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/
 message-driven-bean-max1
 default
 
org.jboss.ejb.plugins.jms.JMSContainerInvoker
 
 
DefaultJMSProvider
 
StdJMSPool
1
1

   10
   
  queue/DLQ
  3
  0
   

 
   

Then have a container-configuration as follows:

  
 SingleThreaded Message Driven Bean
 false
 
message-driven-bean-max1-dlq
 
 
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor
org.jboss.ejb.plugins.LogInterceptor
 
org.jboss.ejb.plugins.RunAsSecurityInterceptor

org.jboss.ejb.plugins.TxInterceptorCMT
org.jboss.ejb.plugins.MetricsInterceptor
org.jboss.ejb.plugins.MessageDrivenInstanceIntercept
or

org.jboss.ejb.plugins.MessageDrivenInstanceInterceptor
org.jboss.ejb.plugins.MessageDrivenTxInterceptorBMT
org.jboss.ejb.plugins.MetricsInterceptor
 
org.jboss.resource.connectionmanager.CachedConnectionIntercepto
r
 
 
org.jboss.ejb.plugins.MessageDrivenInstancePool
 
 
 
 1
 1
 true
  
   


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

  
 SingletonMDB
 queue/Singleton
 SingleThreaded Message Driven
Bean
  


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?  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] serial mdb execution?

2003-10-28 Thread Stephane Nicoll
Greetings,

The update message should have some header saying it's an update (some string
property: action = "update"). Then you can map an MDB with the following JMS
Selector : "action = 'update'"

For this MDB you can extend the default container and specify that only one
MDB can be instantiated at the same time. That way you can reach what your
need. I have Xdoclet example of such a  config if needed.

But I don't really get your problem. You have transaction isolation for your
updates right? It shouldn't be a problem (I mean two objects updating the
same entity at the same time).

Regards,

Stephane

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Scheil, Sven
Sent: Tuesday, October 28, 2003 5:18 PM
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?  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] Problem with SQL query for MySQL

2003-10-28 Thread Rafal Kedziorski
hi,

I'm using MySQL 4.0.13 and 4.0.14 (4.0.16 I will test tomorrow) and JBoss 
3.2.2. And I have problems with this query (generated by JBoss):

insert into user(class_id, retail_id, mandant_id, language_id, 
user_data_id, nickname, login_name, password, status, creation_date, 
last_login_date) values ('35F7A660096411D89BC0D1907F01', '1234', 2, 1, 
null, null, '[EMAIL PROTECTED]', 'demo', 8, '2003-10-28 17:31:36', null)

but the same query with space after user

insert into user (class_id, retail_id, mandant_id, language_id, 
user_data_id, nickname, login_name, password, status, creation_date, 
last_login_date) values ('35F7A660096411D89BC0D1907F01', '1234', 2, 1, 
null, null, '[EMAIL PROTECTED]', 'demo', 8, '2003-10-28 17:31:36', null)

works.

This exception is shown:

17:31:36,406 ERROR [UserEntityBean] Could not create 
entity 
java.sql.SQLException: Syntax error or access violation,  message from 
server: "You have an error in your SQL syntax.  Check the manual that 
corresponds to your MySQL server version for the right syntax to use near 
'user(class_id, retail_id, mandant_id, language_id, 
user_data_id" 
at 
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1651) 
at 
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:889) 
at 
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:956) 
at 
com.mysql.jdbc.Connection.execSQL(Connection.java:1874) 
at 
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1700) 
at 
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1569) 
at 
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:321) 
at 
org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCMySQLCreateCommand.executeInsert(JDBCMySQLCreateCommand.java:66) 
at 
org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.performInsert(JDBCAbstractCreateCommand.java:295) 
at 
org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.execute(JDBCAbstractCreateCommand.java:144) 
at 
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:518) 
at 
org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:208) 
at 
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:269) 
at 
org.jboss.ejb.EntityContainer.createLocalHome(EntityContainer.java:580) 
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.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1042) 
at 
org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88) 
at 
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:197) 
at 
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:214) 

...

Regards,
Rafal 



---
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] 3.2.2 : Incorrect SQL generation

2003-10-28 Thread Phil Shrimpton
On Tuesday 28 October 2003 15:16, Alexey Loubyansky wrote:

Alex

> >> >> > o.contact.surnameUpper = ?2 OR o.vehicle.registrationNumber = ?3
> >>
> >>in English.
> >>
> >>My interpretation is "select all o that have contact with surname ?2 OR
> >>have vehicle with registration number ?3"
> >>Note, o is allowed to have either contact OR vehicle OR both of them.
> >
> > Your interpretation is correct, the problem is is that the SQL
> > generated only does the 'join' with the detail tables if, say
> > contact.surnameUpper equals the parameter supplied, if not it returns all
> > records from the contact table, even though only one has a releationship
> > with 'o'.
>
> Yes, but joining three tables alltogether means my interpretation is
> wrong. Don't you think so? 

No.  Beacuse the detail tables are listed in the FROM clause of the SQL, the 
Joins should always be done or all records from the detail tables will be 
returned regardless of if they have a 'match' in the master table or not.

> > SELECT OBJECT(O) from Customer WHERE (o.id = ?1 OR o.contact.surname =
> > ?2)
> >
> > Customer ID  Customer.ContactID Contact.ID  Surname
> > 1  2   1  smith
> > 1  2   2  blogs
> > 1  2   3  dow
> >
> > ..becase there is no surname match for "fleury", it returns all contacts
>
> Yes. Remember, we select Customer.ID only. So, we still get the correct
> result, i.e. Customer with id=1. 

But there is a FK/releationship between Customer.ContactID Contact.ID, so 
records where those two fields don't match should not be returned

> You can specify also DISTINCT in EJBQL.

You can, and it does work, but in my case it makes the difference between 
returning the resultset from a few hundred milliseconds in 3.0.2 to about 12 
minutes in 3.2.2

> Now, suppose, I add a customer w/o a contact.
> Insert into customer (id, contactid) values (2, NULL)
>
> The EJBQL query is the same but customer id parameter is 2.
> 3.0.8 will return empty collection. Is it correct?

I would say yes as Jboss is generating old style SQL-89 joins.  I generally 
use, when coding direcly, SQL92 joins (which perform a lot better in most 
RDBMS's BTW), and can handle the situation of a null detail table id by using 
left outer joins.

> > I hope I am missing something simple, but I have a number of these type
> > of queries, all work fine under JBoss 3.2.2 and another app server,  none
> > work correctly under 3.2.2
>
> Therefore, please, don't give up. I'll fix it if I am wrong.

I could well be my misunderstanding of something.  And the fact that nobody 
else seems to have reported it does worry me a bit 

Phil
-- 
  4:12pm  up 49 days, 18:22,  1 user,  load average: 0.48, 0.20, 0.12
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


[JBoss-user] serial mdb execution?

2003-10-28 Thread Scheil, Sven

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


RE: [JBoss-user] JBoss 3.2.2 and prepared statement cache

2003-10-28 Thread Martin Vilcans
I don't know whether it's a JBoss bug you've run into, but if you reuse the
same prepared statement instead of creating new ones in the loop, I guess
you won't experience the problem. You are supposed to reuse prepared
statements anyway, something like this:

ps = connection.prepareStatement("insert into search_table(search_id,
row_id, user_id, search_type) values(?,?,?,?)");
while(e.hasMoreElements())
   {
String val = (String)e.nextElement();

ps.setInt(1, cnt);
ps.setString(2, val);
ps.setString(3, userId);
ps.setString(4, searchType);
ps.executeUpdate();
}
closeStatement(ps);

Also, you'd better wrap closeStatement in a finally block.

Martin

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Ricardo Coutinho
Sent: Tuesday, October 28, 2003 3:31 PM
To: [EMAIL PROTECTED]
Subject: RE: [JBoss-user] JBoss 3.2.2 and prepared statement cache


Hi all,

I played around with the   and ran into a
problem.

In one part of my code I am reusing a statement to perform inserts into a
table within the same transaction...

while(e.hasMoreElements())
   {
String val = (String)e.nextElement();

ps = connection.prepareStatement("insert into search_table(search_id,
row_id, user_id, search_type) values(?,?,?,?)");
ps.setInt(1, cnt);
ps.setString(2, val);
ps.setString(3, userId);
ps.setString(4, searchType);
ps.executeUpdate();

closeStatement(ps);
}

The closeStatement() method checks if the statement is null before closing
it.

This code worked fine without the statement caching. But now I get an error
from the JDBC driver telling me that 'The statement is closed'. Has anyone
seen this behaviour?
Ricardo Coutinho
Software Engineer

Odyssey Asset Management Systems S.A.
Espace Kirchberg-Eolis
26-28, rue Edward Steichen
L-2540  Luxembourg-Kirchberg
Direct Line:+352 42 60 80 4425
fax: +352 42 91 92
http://www.odyssey-group.com
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Brian McSweeney
Sent: 28 October 2003 14:39
To: [EMAIL PROTECTED]
Subject: RE: [JBoss-user] JBoss 3.2.2 and prepared statement cache


Cool, thanks a million!
Brian

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Rafal
Kedziorski
Sent: 28 October 2003 11:18
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] JBoss 3.2.2 and prepared statement cache

At 12:32 28.10.2003, Brian McSweeney wrote:


Hi all,

Ive heard that there are significant performance increases with 3.2.2 to do
with prepared statement caching.
Is there anything that you have to do in terms of configuration files for
this, or is it just an automatic performance
increase.

You have to add i.e.:

100

in Your ds-xml configuration.


Regards,
Rafal




Thanks,
Brian
__
· This email and any files transmitted with it are CONFIDENTIAL and intended
solely for the use of the individual or entity to which they are addressed.
· Any unauthorized copying, disclosure, or distribution of the material
within
this email is strictly forbidden.
· Any views or opinions presented within this e-mail are solely those of the
author and do not necessarily represent those of Odyssey Asset Management
Systems SA unless otherwise specifically stated.
· An electronic message is not binding on its sender. Any message referring
to
a binding engagement must be confirmed in writing and duly signed.
· If you have received this email in error, please notify the sender
immediately
and delete the original.



---
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] 3.2.2 : Incorrect SQL generation

2003-10-28 Thread Alexey Loubyansky
Phil Shrimpton wrote:

On Tuesday 28 October 2003 10:13, Alexey Loubyansky wrote:
Let's describe the condition

>> > o.contact.surnameUpper = ?2 OR o.vehicle.registrationNumber = ?3

in English.

My interpretation is "select all o that have contact with surname ?2 OR
have vehicle with registration number ?3"
Note, o is allowed to have either contact OR vehicle OR both of them.


Correct


I think, your interpretation is "select all o that have contact AND have
vehicle AND (contact's surname is ?2 OR vehicle's registration number is
?3)"
Do I understand you right? 


No.  Your interpretation is correct, the problem is is that the SQL generated 
only does the 'join' with the detail tables if, say contact.surnameUpper 
equals the parameter supplied, if not it returns all records from the contact 
table, even though only one has a releationship with 'o'.
Yes, but joining three tables alltogether means my interpretation is 
wrong. Don't you think so? Please, write your variant of correct SQL for 
this case.

OK, here is a simple example, imagine these two DB tables

create table Customer (
  ID Integer,
  Contact_ID Integer
)
create table Contact (
  ID Integer,
  Surname Varchar(50)
)
..which results in two ejb's..

Contact {
  public Integer getID();
  public void setID(Integer id);
  public String getSurname();
  public void setSurname(String surname);
}
..Customer {
  public Integer getID();
  public void setID(Integer id);
  public Contact getContact();
  public void setContact(Contact contact);
}
If I want to write a finder for Customer that returns all Customers that 
match a given ID or given Surname, I would write something like..

SELECT OBJECT(O) from Customer WHERE (o.id = ?1 OR o.contact.surname = ?2)

Jboss 3.0.8 will generate SQL something like...

SELECT cus.ID 
FROM Customer cus, Contact con
WHERE
   (cus.ID = ? OR con.surname = ?)
   AND
   (cus.ContactID=con.ID)

Which will return all records where Customer.ID = parameter supplied or 
Contact.Surname = parameter supplied AND Contact.ID = Customer.ContactID.

Jboss 3.2.2 will generate SQL something like...

SELECT cus.ID 
FROM Customer cus, Contact con
WHERE
   cus.ID = ? OR (con.surname = ? AND cus.ContactID=con.ID)

Which will return all records where Customer.ID = parameter supplied or 
Contact.Surname = parameter supplied AND Contact.ID = Customer.ContactID OR 
all contacts where Contact.Surname != parameter supplied.

To make it clear, if the data in the tables was

Insert into customer (id, contactid) values (1, 2)

Insert into contacts (id, surname) values (1, "smith")
Insert into contacts (id, surname) values (2, "blogs")
Insert into contacts (id, surname) values (3, "dow")
If I passed customer.id = 1 and surname="fleury" to the finder above..

Jboss 3.0.8 will return

Customer ID  Customer.ContactID Contact.ID  Surname
1  2   2  blogs
Jboss 3.2.2 will return

Customer ID  Customer.ContactID Contact.ID  Surname
1  2   1  smith
1  2   2  blogs
1  2   3  dow
..becase there is no surname match for "fleury", it returns all contacts
Yes. Remember, we select Customer.ID only. So, we still get the correct 
result, i.e. Customer with id=1. You can specify also DISTINCT in EJBQL.

Now, suppose, I add a customer w/o a contact.
Insert into customer (id, contactid) values (2, NULL)
The EJBQL query is the same but customer id parameter is 2.
3.0.8 will return empty collection. Is it correct?
3.2.2 will return Customer with id=2.

I hope I am missing something simple, but I have a number of these type of 
queries, all work fine under JBoss 3.2.2 and another app server,  none work
correctly under 3.2.2
Therefore, please, don't give up. I'll fix it if I am wrong.

Thanks,

alex

Phil

  




---
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] MDB and Jaas

2003-10-28 Thread Adrian Brock
On Tue, 2003-10-28 at 12:56, Brian Wallis wrote:
> I have another question, this time about JAAS and JMS. 
> 
> If I am a client app and login via JAAS (using the clientloginmodule) and then 
> I want to subscribe to a JMS topic. As far as I can tell the JAAS login info 
> (principal/credential) is not used and I have to specify the 
> username/password for jms on the TopicConnection.createTopicConnection() 
> call. 
> 
> Is this correct or is there someway of linking the JAAS authentication to the 
> JMS authentication?

That is correct. The client connection factories don't know about JAAS.

If you are inside JBoss you can use the JMS resource adaptor
java:/JmsXA configured with the caller identity login module 
to pass the thread's identity through to JMS. 
The default is configured identity (guest/guest).

This works by wrapping the real connection factory. The wrapper's
createTopicConnection() is redirected to the real connection factory's
createTopicConnection(user, passwd); passing the jaas user/credential.

Regards,
Adrian

> 
> thanks, brian wallis...
> 
> 
> 
> ---
> This SF.net email is sponsored by: The SF.net Donation Program.
> Do you like what SourceForge.net is doing for the Open
> Source Community?  Make a contribution, and help us add new
> features and functionality. Click here: http://sourceforge.net/donate/
> ___
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
-- 
 
Adrian Brock
Director of Support
Back Office
JBoss Group, LLC 
 



---
This SF.net email is sponsored by: The SF.net Donation Program.
Do you like what SourceForge.net is doing for the Open
Source Community?  Make a contribution, and help us add new
features and functionality. Click here: http://sourceforge.net/donate/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


RE: [JBoss-user] JBoss 3.2.2 and prepared statement cache

2003-10-28 Thread Ricardo Coutinho



Hi 
all,
 
I 
played around with the   and ran into a problem.
 
In one 
part of my code I am reusing a statement to perform inserts into a table within 
the same transaction...
 
while(e.hasMoreElements())   {String 
val = (String)e.nextElement();
 
ps = connection.prepareStatement("insert into 
search_table(search_id, row_id, user_id, search_type) 
values(?,?,?,?)");ps.setInt(1, 
cnt);ps.setString(2, 
val);ps.setString(3, 
userId);ps.setString(4, 
searchType);ps.executeUpdate();
 
closeStatement(ps);}
 
The 
closeStatement() method checks if the statement is null before closing 
it.
 
This code worked fine without the statement caching. But now I get an 
error from the JDBC driver telling me that 'The statement is 
closed'. Has anyone seen this 
behaviour?
Ricardo Coutinho 
Software Engineer  Odyssey Asset Management Systems S.A. 
Espace Kirchberg-Eolis 
26-28, rue Edward 
Steichen L-2540  
Luxembourg-Kirchberg Direct 
Line:+352 42 60 80 4425 fax: 
+352 42 91 92 http://www.odyssey-group.com 

  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of Brian 
  McSweeneySent: 28 October 2003 14:39To: 
  [EMAIL PROTECTED]Subject: RE: [JBoss-user] JBoss 
  3.2.2 and prepared statement cache
  
  Cool, thanks a 
  million!
  Brian
   
  -Original 
  Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED] On Behalf Of Rafal KedziorskiSent: 28 October 2003 11:18To: 
  [EMAIL PROTECTED]Subject: Re: [JBoss-user] JBoss 3.2.2 and 
  prepared statement cache
   
  At 12:32 28.10.2003, Brian McSweeney 
  wrote:
  Hi all, Ive heard 
  that there are significant performance increases with 3.2.2 to do with 
  prepared statement caching. Is there anything that you have to do in terms 
  of configuration files for this, or is it just an automatic performance 
  increase.
  You have to add 
  i.e.:100in Your 
  ds-xml configuration.Regards,Rafal
  Thanks,Brian

__

· This email and any files transmitted with it are CONFIDENTIAL and intended
solely for the use of the individual or entity to which they are addressed.

· Any unauthorized copying, disclosure, or distribution of the material within
this email is strictly forbidden.

· Any views or opinions presented within this e-mail are solely those of the
author and do not necessarily represent those of Odyssey Asset Management
Systems SA unless otherwise specifically stated.

· An electronic message is not binding on its sender.  Any message referring to
a binding engagement must be confirmed in writing and duly signed.

· If you have received this email in error, please notify the sender immediately
and delete the original.


Re: [JBoss-user] MDB and Jaas

2003-10-28 Thread Brian Wallis

I have another question, this time about JAAS and JMS. 

If I am a client app and login via JAAS (using the clientloginmodule) and then 
I want to subscribe to a JMS topic. As far as I can tell the JAAS login info 
(principal/credential) is not used and I have to specify the 
username/password for jms on the TopicConnection.createTopicConnection() 
call. 

Is this correct or is there someway of linking the JAAS authentication to the 
JMS authentication?

thanks, brian wallis...



---
This SF.net email is sponsored by: The SF.net Donation Program.
Do you like what SourceForge.net is doing for the Open
Source Community?  Make a contribution, and help us add new
features and functionality. Click here: http://sourceforge.net/donate/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


RE: [JBoss-user] JBoss 3.2.2 and prepared statement cache

2003-10-28 Thread Brian McSweeney








Cool, thanks a million!

Brian

 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Rafal Kedziorski
Sent: 28 October 2003 11:18
To:
[EMAIL PROTECTED]
Subject: Re: [JBoss-user] JBoss
3.2.2 and prepared statement cache

 

At 12:32 28.10.2003,
Brian McSweeney wrote:



Hi all,
 
Ive heard that there are significant performance increases with 3.2.2 to
do with prepared statement caching. 
Is there anything that you have to do in terms of configuration files for this,
or is it just an automatic performance 
increase.


You have to add i.e.:

100

in Your ds-xml configuration.


Regards,
Rafal




 
Thanks,
Brian








Re: [JBoss-user] 3.2.2 : Incorrect SQL generation

2003-10-28 Thread Phil Shrimpton
On Tuesday 28 October 2003 10:13, Alexey Loubyansky wrote:

Hi,

> >>I think, the join should be done per the term, i.e. this way:
> >>
> >>(contact.SURNAME_UPPER = ? AND o.CONTACT_ID=contact.ID)
> >>OR (vehicle.REGNUMBER = ? AND  o.VEHICLE_ID=vehicle.ID)
> >
> > The problem with this, is the join is only done if the parameter matched,
> > if
>
> yes
>
> > note it would return all all records from the detail table due to short
> > circuit evaluation.
>
> Could you, please, elaborate on this? What is the detail table?

In this case the detail tables are vehicle and contact, each contain many 
records, but only one is 'linked' to the master record 

> Let's describe the condition
>
>  >> > o.contact.surnameUpper = ?2 OR o.vehicle.registrationNumber = ?3
>
> in English.
>
> My interpretation is "select all o that have contact with surname ?2 OR
> have vehicle with registration number ?3"
> Note, o is allowed to have either contact OR vehicle OR both of them.

Correct

> I think, your interpretation is "select all o that have contact AND have
> vehicle AND (contact's surname is ?2 OR vehicle's registration number is
> ?3)"
> Do I understand you right? 

No.  Your interpretation is correct, the problem is is that the SQL generated 
only does the 'join' with the detail tables if, say contact.surnameUpper 
equals the parameter supplied, if not it returns all records from the contact 
table, even though only one has a releationship with 'o'.

OK, here is a simple example, imagine these two DB tables

create table Customer (
  ID Integer,
  Contact_ID Integer
)

create table Contact (
  ID Integer,
  Surname Varchar(50)
)

..which results in two ejb's..

Contact {
  public Integer getID();
  public void setID(Integer id);
  public String getSurname();
  public void setSurname(String surname);
}

..Customer {
  public Integer getID();
  public void setID(Integer id);
  public Contact getContact();
  public void setContact(Contact contact);
}

If I want to write a finder for Customer that returns all Customers that 
match a given ID or given Surname, I would write something like..

SELECT OBJECT(O) from Customer WHERE (o.id = ?1 OR o.contact.surname = ?2)

Jboss 3.0.8 will generate SQL something like...

SELECT cus.ID 
FROM Customer cus, Contact con
WHERE
   (cus.ID = ? OR con.surname = ?)
   AND
   (cus.ContactID=con.ID)

Which will return all records where Customer.ID = parameter supplied or 
Contact.Surname = parameter supplied AND Contact.ID = Customer.ContactID.

Jboss 3.2.2 will generate SQL something like...

SELECT cus.ID 
FROM Customer cus, Contact con
WHERE
   cus.ID = ? OR (con.surname = ? AND cus.ContactID=con.ID)

Which will return all records where Customer.ID = parameter supplied or 
Contact.Surname = parameter supplied AND Contact.ID = Customer.ContactID OR 
all contacts where Contact.Surname != parameter supplied.

To make it clear, if the data in the tables was

Insert into customer (id, contactid) values (1, 2)

Insert into contacts (id, surname) values (1, "smith")
Insert into contacts (id, surname) values (2, "blogs")
Insert into contacts (id, surname) values (3, "dow")

If I passed customer.id = 1 and surname="fleury" to the finder above..

Jboss 3.0.8 will return

Customer ID  Customer.ContactID Contact.ID  Surname
1  2   2  blogs

Jboss 3.2.2 will return

Customer ID  Customer.ContactID Contact.ID  Surname
1  2   1  smith
1  2   2  blogs
1  2   3  dow

..becase there is no surname match for "fleury", it returns all contacts

I hope I am missing something simple, but I have a number of these type of 
queries, all work fine under JBoss 3.2.2 and another app server, none work 
correctly under 3.2.2

Phil

  
-- 
 10:42am  up 49 days, 12:52,  1 user,  load average: 0.25, 0.16, 0.10
ICQ: 760757 | AIM: pjshrimpton | Y!: pjshrimpton | [EMAIL PROTECTED]


---
This SF.net email is sponsored by: The SF.net Donation Program.
Do you like what SourceForge.net is doing for the Open
Source Community?  Make a contribution, and help us add new
features and functionality. Click here: http://sourceforge.net/donate/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


Re: [JBoss-user] JBoss 3.2.2 and prepared statement cache

2003-10-28 Thread Rafal Kedziorski


At 12:32 28.10.2003, Brian McSweeney wrote:
Hi
all,
 
I’ve heard that there are significant performance increases with 3.2.2 to
do with prepared statement caching. 
Is there anything that you have to do in terms of configuration files for
this, or is it just an automatic performance 
increase.
You have to add i.e.:
100
in Your ds-xml configuration.

Regards,
Rafal
 
Thanks,
Brian



[JBoss-user] (no subject)

2003-10-28 Thread deepak saini
hi all

I have downloaded jboss 3.2.2. it is bundled with tomcat.
I want to run a sample servlet.
Can anyone tell me where to find the instrcutions for the same.
Regards
Deepak Saini
_
Special offer from American Express.Don't miss out. 
http://server1.msn.co.in/features/amex/index.asp  Apply now!



---
This SF.net email is sponsored by: The SF.net Donation Program.
Do you like what SourceForge.net is doing for the Open
Source Community?  Make a contribution, and help us add new
features and functionality. Click here: http://sourceforge.net/donate/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] JBoss 3.2.2 and prepared statement cache

2003-10-28 Thread Brian McSweeney








Hi all,

 

I’ve heard that there
are significant performance increases with 3.2.2 to do with prepared statement
caching. 

Is there anything that you
have to do in terms of configuration files for this, or is it just an automatic
performance 

increase.

 

Thanks,

Brian








[JBoss-user] JMX HtmlAdaptor servlet produces ISO-8859-1 coded pages!

2003-10-28 Thread Milen Dyankov
Hi all,

I'm using "JBoss-3.2.1_tomcat-4.1.24" and I have few MBeans storing their properties 
in database.
I have noticed that "HtmlAdaptor" servlet produces "ISO-8859-1" coded pages. This 
causes a problem
when MBean properties contain non-English characters.
For example polish character "Ä" is written to database as "¥".
I guess a simple fix would be to change "HtmlAdaptor" servlet to produce "UTF-8" coded 
pages.
Or may be this is somehow configurable?

Milen Dyankov



---
This SF.net email is sponsored by: The SF.net Donation Program.
Do you like what SourceForge.net is doing for the Open
Source Community?  Make a contribution, and help us add new
features and functionality. Click here: http://sourceforge.net/donate/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


Re: [JBoss-user] 3.2.2 : Incorrect SQL generation

2003-10-28 Thread Alexey Loubyansky
Phil Shrimpton wrote:

On Friday 24 October 2003 10:50, Alexey Loubyansky wrote:

as for me, 3.0.8 is wrong and 3.2.2 is correct.
Interesting, especially as another app server (Borland's) generates the same 
SQL as 3.0.8

Since you use OR between the terms

> o.contact.surnameUpper = ?2 OR o.vehicle.registrationNumber = ?3

I think, the join should be done per the term, i.e. this way:

(contact.SURNAME_UPPER = ? AND o.CONTACT_ID=contact.ID)
OR (vehicle.REGNUMBER = ? AND  o.VEHICLE_ID=vehicle.ID)
The problem with this, is the join is only done if the parameter matched, if 
yes

not it would return all all records from the detail table due to short 
circuit evaluation.
Could you, please, elaborate on this? What is the detail table?

and not

(contact.SURNAME_UPPER = ? OR vehicle.REGNUMBER = ?)
AND (o.VEHICLE_ID=vehicle.ID AND o.CONTACT_ID=contact.ID)


This is correct, IMO,  as the join is always done, regardless of whether the 
parameter matches or not.
Let's describe the condition
>> > o.contact.surnameUpper = ?2 OR o.vehicle.registrationNumber = ?3
in English.
My interpretation is "select all o that have contact with surname ?2 OR 
have vehicle with registration number ?3"
Note, o is allowed to have either contact OR vehicle OR both of them.

I think, your interpretation is "select all o that have contact AND have 
vehicle AND (contact's surname is ?2 OR vehicle's registration number is 
?3)"
Do I understand you right? In this case, o must have both contact AND 
vehicle. So, if o has a contact with the matching surname but does not 
have vehicle, this o is missed. Why?
If you do want this, say it explicitly with o.contact.surnameUpper=?2 
AND o.vehicle IS NOT NULL.

alex



If you want the SQL that was generated in 3.0.8, you should use the
following EJB-QL query:
SELECT OBJECT(o)
FROM BaseTask AS o
WHERE
   o.callID = ?1 OR
   o.orderNumber = ?4 OR
  (o.contact.surnameUpper = ?2 OR
   o.vehicle.registrationNumber = ?3 OR
   o.address.postCode = ?5)
  AND o.contact IS NOT NULL
  AND o.vehicle IS NOT NULL
  AND o.address IS NOT NULL
SELECT
   o.CALL_ID
FROM
   TASK_BASE o,
   TASKS_PART_VEHICLE vehicle,
   TASKS_PART_CONTACT contact,
   TASKS_PART_ADDRESS address
WHERE
   (o.CALL_ID=?) OR
   (o.ORDER_NUM=?) OR
   (
  (contact.SURNAME_UPPER = ? OR
   vehicle.REGNUMBER = ? OR
   address.POSTCODE = ?)
AND
   o.VEHICLE_ID=vehicle.ID
AND
   o.CONTACT_ID=contact.ID
AND
   o.ADDRESS_ID=address.ID
AND
   o.VEHICLE_ID IS NOT NULL
AND
   o.CONTACT_ID IS NOT NULL
AND
   o.ADDRESS_ID IS NOT NULL)


Which is still wrong as it brings back all the records from the detail tables 
that don't match the 'id' in the master.

Phil





---
This SF.net email is sponsored by: The SF.net Donation Program.
Do you like what SourceForge.net is doing for the Open
Source Community?  Make a contribution, and help us add new
features and functionality. Click here: http://sourceforge.net/donate/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


Re: [JBoss-user] Looking for article on JBoss/Web Services/Axis

2003-10-28 Thread Giovanni Formenti
Just some links:
http://www.csd.abdn.ac.uk/~bscharla/teaching/mtp_software/jboss/jboss-net-He
lloWorld.shtml
http://www.csd.abdn.ac.uk/~bscharla/teaching/mtp_software/jboss/jboss-net-EJ
B-example.shtml

http://www.nsdev.org/jboss/stories/jboss-net.html

I'm searching too something about Web service & XDoclet in JBoss... if u
find something can u tell me? Thanx

Gio

- Original Message -
From: "Sasidharan, Manoj" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 27, 2003 10:32 PM
Subject: [JBoss-user] Looking for article on JBoss/Web Services/Axis


Hello All,

I am looking for some write-up on developing/using web services with JBoss
3.2.x or JBoss 4.x with Axis.

Thanks in advance.

rgds
MS


---
This SF.net email is sponsored by: The SF.net Donation Program.
Do you like what SourceForge.net is doing for the Open
Source Community?  Make a contribution, and help us add new
features and functionality. 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: The SF.net Donation Program.
Do you like what SourceForge.net is doing for the Open
Source Community?  Make a contribution, and help us add new
features and functionality. Click here: http://sourceforge.net/donate/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] Update: XDoclet changes for JBoss

2003-10-28 Thread Jon Barnett
I have updated the XDoclet changes for JBoss as I found that the 1.2b4
release also did not cater for the jboss-web.xml changes for JBoss 3.2,
leaving out the 3.2 DTD. The change I've suggested allows the use of
ejb-local-ref in jboss-web.xml. As this modification requires some
source changes, I have also provided the built JBoss processing module
at
http://www.amitysolutions.com.au/downloads/xdoclet-jboss-module-1.2b4.jar.
The description of the changes have been appended to
http://www.amitysolutions.com.au/documents/XDocletChange-technote.pdf.

Hope this is of use.

*-**
| Jon Barnett  |
| E-Mail: [EMAIL PROTECTED]   |
| Homepage: http://www.amitysolutions.com.auDate:   28.10.2003 |
|  |
| Je voudrais m'en aller avec la goëlette  |
| Qui se berce ce soir dans le port|
| Mystérieuse et solitaire |
| Et qui déploie enfin ses voiles violettes|
| Comme un immense oiseau de nuit dans le ciel d'or.   |
| Je voudrais m'en aller vers des îles de fleurs   |
| En écoutant chanter la mer perverse  |
| Sur un vieux rythme ensorceleur. |
| Je voudrais voir Damas et les villes de Perse|
| Avec les minarets légers dans l'air. |
| Excerpt from Asie, Shéhérazade by Tristan Klingsor   |
*-**


pgp0.pgp
Description: PGP signature