RE: [JBoss-user] how to upgrade from 3.0.4 to 3.2.2
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
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
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
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?
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
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?
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!!!!
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
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?
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
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?
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)
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?
--- 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?
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
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!!!!
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
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
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
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
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?
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?
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
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
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?
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
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
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
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
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
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
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
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
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
[JBoss-user] (no subject)
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
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!
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
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
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
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