RE: [JBoss-user] servlet load-on-startup

2003-10-07 Thread Rupp, Heiko
Hi,

 Using Tomcat embedded in JBoss 3.2.1.  If I declare a servlet as 
 load-on-startup does the web container call the servlet's 
 init() method  and wait for it to finish before the web app is marked as 
 available for access from incoming HTTP requests?

As far as I know, the init() is always called before the first
call to service() (which in turn calls doGet() etc). In case that
init() was not called automatically by the load-on-startup 
functionality, it is called when the first request comes in.

  Heiko
-- 
Heiko W. Rupp   EMail: [EMAIL PROTECTED]
Senior Consultant   Telefon: +49 711 222 992 - 900
Cellent AG Finance SolutionsTelefax: +49 711 222 992 - 999
Calwer Str. 33  D-70173 Stuttgart


---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] JBoss+FreeBSD: Unable to create MBean server instance

2003-10-07 Thread
Hi!

I have FreeBSD 4.8 + JDK 1.3.1 + JBoss 3.2.2RC4

When I try to run JBoss, it exits with this message:

10:45:10,641 ERROR [Server] Failed to start
java.lang.RuntimeException: Unable to create the MBean server instance. 
Class org.jboss.mx.server.MBeanServerImpl has raised an exception in 
constructor: java.lang.NoSuchFieldError: 
org.jboss.mx.modelmbean.ModelMBeanInvoker: field ALL_DESCRIPTORS not found
 at 
javax.management.MBeanServerFactory.createMBeanServer(MBeanServerFactory.java:180)
 at 
javax.management.MBeanServerFactory.createMBeanServer(MBeanServerFactory.java:80)
 at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:327)
 at org.jboss.system.server.ServerImpl.start(ServerImpl.java:291)
 at org.jboss.Main.boot(Main.java:150)
 at org.jboss.Main$1.run(Main.java:388)
 at java.lang.Thread.run(Thread.java:484)

What should I do? What is the matter? Where's the problem?
Please advise me.
WBR,
Vitaly Voropinov


---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


Re: [JBoss-user] JBoss-IDE 1.2.1 released

2003-10-07 Thread SHAHIN HADJIKULIEV

Hi,
As I have understood , you have coppied the hole extracted zip file
org.jboss.ide.eclipse_1.2.1.bin.dist.zip

The rifght way is to copy folders located under plugins directory  of
extracted folder

org.jboss.ide.eclipse_1.2.1.bin.dist
 |
 -plugins


Shahin




   
  
Meyer-Willner, Bernhard  
  
[EMAIL PROTECTED]   To: '[EMAIL PROTECTED]' 
 
cacmg.com  [EMAIL PROTECTED]
   
Sent by:   cc: 
  
[EMAIL PROTECTED]   Subject: Re: [JBoss-user] JBoss-IDE 
1.2.1 released
eforge.net 
  
   
  
   
  
10/06/2003 09:03 PM
  
Please respond to jboss-user   
  
   
  
   
  




Unfortunaly I don't see the JBoss-IDE under Other. What am I doing wrong?

-Ursprüngliche Nachricht-
Von: Francisco Figueiredo Jr. [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 6. Oktober 2003 18:30
An: [EMAIL PROTECTED]
Betreff: Re: [JBoss-user] JBoss-IDE 1.2.1 released


Meyer-Willner, Bernhard wrote:
 I downloaded JBossIDE and extracted it into my plugins dir but I can't
see
 it in Eclipse. What do I have to do to see and configure it?


Go to window-ShowView-Other.
A jboss-ide folder will be present where you can select the server
manager view.


I hope it helps.

Regards,

Francisco Figueiredo Jr.


 -Ursprüngliche Nachricht-
 Von: Laurent Etiemble [mailto:[EMAIL PROTECTED]
 Gesendet: Sonntag, 5. Oktober 2003 14:35
 An: Jboss-User; Jboss-Development
 Betreff: [JBoss-user] JBoss-IDE 1.2.1 released


 Hi,

 The JBoss-IDE 1.2.1 release is available.It is a maintenance release
which
 addresses many bugs.See release notes for more details :
 https://sourceforge.net/project/shownotes.php?release_id=187792

 Downloads are available through the SourceForge site :

http://prdownloads.sourceforge.net/jboss/org.jboss.ide.eclipse_1.2.1.bin.dis

 t.zip?download

 Updates are also possible within Eclipse through the Install/Update
 perspective. Just set up a bookmark to the following URL :
 http://jboss.sourceforge.net/jbosside/updates/

 Laurent Etiemble,
 JBoss-IDE project lead.




 ---
 This sf.net email is sponsored by:ThinkGeek
 Welcome to geek heaven.
 http://thinkgeek.com/sf
 ___
 JBoss-user mailing list
 [EMAIL PROTECTED]
 https://lists.sourceforge.net/lists/listinfo/jboss-user

 This e-mail and any attachment is for authorised use by the intended
recipient(s) only. It may contain proprietary material, confidential
information and/or be subject to legal privilege. It should not be copied,
disclosed to, retained or used by, any other party. If you are not an
intended recipient then please promptly delete this e-mail and any
attachment and all copies and inform the sender. Thank you.

 LogicaCMG global sponsors, Gartner Symposium, Cannes, 4th -7th November
2003

 http://symposium.gartner.com/story.php.id.3323.s.5.html

 Please note that LogicaCMG does not have control over content from,or
availability of, this website


 ---
 This sf.net email is sponsored by:ThinkGeek
 Welcome to geek heaven.
 http://thinkgeek.com/sf
 ___
 JBoss-user mailing list
 [EMAIL PROTECTED]
 https://lists.sourceforge.net/lists/listinfo/jboss-user





---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

This e-mail and any attachment is for authorised use by the intended
recipient(s) only. It may contain 

Re: [JBoss-user] JBoss-IDE 1.2.1 released

2003-10-07 Thread Meyer-Willner, Bernhard
That's what I did. In my eclipse/plugins directory I have several
directories belonging to JBossIDE, all starting with org.jboss.ide.eclipse .

Still I can't see JBossIDE in Eclipse the same way that I see other plugins.



-Ursprüngliche Nachricht-
Von: SHAHIN HADJIKULIEV [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 7. Oktober 2003 10:55
An: [EMAIL PROTECTED]
Betreff: Re: [JBoss-user] JBoss-IDE 1.2.1 released



Hi,
As I have understood , you have coppied the hole extracted zip file
org.jboss.ide.eclipse_1.2.1.bin.dist.zip

The rifght way is to copy folders located under plugins directory  of
extracted folder

org.jboss.ide.eclipse_1.2.1.bin.dist
 |
 -plugins


Shahin




 

Meyer-Willner, Bernhard

[EMAIL PROTECTED]   To:
'[EMAIL PROTECTED]'  
cacmg.com
[EMAIL PROTECTED]   
Sent by:   cc:

[EMAIL PROTECTED]   Subject: Re:
[JBoss-user] JBoss-IDE 1.2.1 released
eforge.net

 

 

10/06/2003 09:03 PM

Please respond to jboss-user

 

 





Unfortunaly I don't see the JBoss-IDE under Other. What am I doing wrong?

-Ursprüngliche Nachricht-
Von: Francisco Figueiredo Jr. [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 6. Oktober 2003 18:30
An: [EMAIL PROTECTED]
Betreff: Re: [JBoss-user] JBoss-IDE 1.2.1 released


Meyer-Willner, Bernhard wrote:
 I downloaded JBossIDE and extracted it into my plugins dir but I can't
see
 it in Eclipse. What do I have to do to see and configure it?


Go to window-ShowView-Other.
A jboss-ide folder will be present where you can select the server
manager view.


I hope it helps.

Regards,

Francisco Figueiredo Jr.


 -Ursprüngliche Nachricht-
 Von: Laurent Etiemble [mailto:[EMAIL PROTECTED]
 Gesendet: Sonntag, 5. Oktober 2003 14:35
 An: Jboss-User; Jboss-Development
 Betreff: [JBoss-user] JBoss-IDE 1.2.1 released


 Hi,

 The JBoss-IDE 1.2.1 release is available.It is a maintenance release
which
 addresses many bugs.See release notes for more details :
 https://sourceforge.net/project/shownotes.php?release_id=187792

 Downloads are available through the SourceForge site :

http://prdownloads.sourceforge.net/jboss/org.jboss.ide.eclipse_1.2.1.bin.dis

 t.zip?download

 Updates are also possible within Eclipse through the Install/Update
 perspective. Just set up a bookmark to the following URL :
 http://jboss.sourceforge.net/jbosside/updates/

 Laurent Etiemble,
 JBoss-IDE project lead.




 ---
 This sf.net email is sponsored by:ThinkGeek
 Welcome to geek heaven.
 http://thinkgeek.com/sf
 ___
 JBoss-user mailing list
 [EMAIL PROTECTED]
 https://lists.sourceforge.net/lists/listinfo/jboss-user

 This e-mail and any attachment is for authorised use by the intended
recipient(s) only. It may contain proprietary material, confidential
information and/or be subject to legal privilege. It should not be copied,
disclosed to, retained or used by, any other party. If you are not an
intended recipient then please promptly delete this e-mail and any
attachment and all copies and inform the sender. Thank you.

 LogicaCMG global sponsors, Gartner Symposium, Cannes, 4th -7th November
2003

 http://symposium.gartner.com/story.php.id.3323.s.5.html

 Please note that LogicaCMG does not have control over content from,or
availability of, this website


 ---
 This sf.net email is sponsored by:ThinkGeek
 Welcome to geek heaven.
 http://thinkgeek.com/sf
 ___
 JBoss-user mailing list
 [EMAIL PROTECTED]
 https://lists.sourceforge.net/lists/listinfo/jboss-user





---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

This e-mail and any attachment is for authorised use by the intended
recipient(s) only. It may contain proprietary material, confidential
information and/or be subject to legal privilege. It should not be copied,
disclosed to, retained or used by, any other party. If you are not an
intended recipient then please promptly delete this e-mail and any
attachment and all copies and inform the sender. Thank you.

LogicaCMG global sponsors, Gartner Symposium, Cannes, 4th -7th November
2003

http://symposium.gartner.com/story.php.id.3323.s.5.html

Please note that LogicaCMG does not have control over content from,or
availability of, this website


---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.

[JBoss-user] client reconnect to restarted server

2003-10-07 Thread Wolfram Ditzer
Hi,

I cann´t reconnect to a restarted JBOSS server.

1. Client connects to server, does something, wait:  OK
2. Restart JBOSS Server (3.X)
3. Client continues to access server,  communication problem is 
detected, so a reconnect is done:

  context = new InitialContext(jndi_props);
  Object obj = context.lookup(name)
I get here exception indicating that an TCP-connection error ocurred!

Bye Wolfram

  



---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] Re: problem in jbuilder7+jboss3.2.1

2003-10-07 Thread Edgar Silva
Hi Forge... 

There are some problems in this OpenTool, for example, some changes in the 
project like DataSources name, it doesn't reflect in jbosscmp-jdbc.xml, and 
you have to apply it by your own hands. 

It is bad, but is the best way to work with this enviroment, working with 
JBuilder's EJB-Designer. It´s very nice feature from JBuilder to draw 
visually your EJB´s, then some changes by hands in the jbosscmp-jdbc will be 
simple...It is a good  change: Simple way to do EJB´s by To Correct 
something in the jbosscmp... =) 

Have enumerous opentools at codecentral.borland.com , where you can find 
good toys. 

I think you can find new version from this JBossOpenTool in the url above. 

best regards 

Edgar Silva 

forge escreveu: 

Hello, everyone 

 

I'm using jbuilder7 + jboss 3.2.1 developing an EJB project. 

It need a jbossopentool.jar as plugin of jbuilder and I downloaded one, 

but it doesn't work well. I can't find JBOSSCMP-JDBC page in JB7. 

 

Does anyone know where I can download a jbossopentool.jar for my enviro? 

 

Thanks. 

Forge 

 

 

 

 

--http://www.eyou.com
--Îȶ¨¿É¿¿µÄÃâ·Ñµç×ÓÐÅÏä  ÓïÒôÓʼþ  Òƶ¯ÊéÇ©  ÈÕÀú·þÎñ  ÍøÂç´æ´¢...ÒÚÓÊδ¾¡ 

 

---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


Edgar A Silva
Diretor Técnico
Argos Tecnologia Ltda.
Borland Learning  Solutions Partner
(55 91)222.6578 - Belém/Pa - Brasil 

 
=
PLATAFORMA JAVA : UM COMPROMISSO DA ARGOS! 

# Pioneira no desenvolvimento de soluções Java na região norte;
# Fundadora e patrocinadora do BelJUG - Belém Java Users Group;
# Equipe composta de profissionais com certificações Borland e Sun;
# Maior formadora de profissionais Java da região;
# Parcerias Estratégicas: Borland(Produtos Java) e Summa(Serviços Java); 

Solicite-nos uma visita e descubra porque as principais empresas da
região confiam a nós sua solução Java. 

www.argostecnologia.com 

 
= 



---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


Re: [JBoss-user] value object challenge

2003-10-07 Thread Horia Muntean
Probably 'cause if the client is in the same VM, the method parameters 
(meetingDateValueObject) are passed by referece. If the client is in 
another VM, the method params are serialized over TCP/IP.

Regards,
Horia
Frank Morton wrote:

Using 3.2.2RC4. Same problem under redhat linux and macos X. Note later 
I explain
that this behaves differently with the client running in the same jvm 
vs. running in
a different jvm.

In a value object class (MeetingDateValueObject), I do the following:

 MeetingDateValue meetingDateValue = Factory.getMeetingDateValue();
 System.err.println(DEBUG: MeetingDateValueObject.update() id value 
before:  + getId());
 boolean temp =  meetingDateValue.update(protectionMap,this);
 System.err.println(DEBUG: MeetingDateValueObject.update() id value 
after:  + getId());

meetingDateValue is a stateless session bean. id is a property of the 
value object
and the primary key of the underlying entity bean. the update method 
is supposed to
set the id value, but getId() returns null before and after the update.

In the called session bean, I do the following (it is a facade for the 
entity bean):

 public boolean update(ProtectionMap 
protectionMap,MeetingDateValueObject meetingDateValueObject) {
  MeetingDateHome meetingDateHome = Factory.getMeetingDateHome();
  System.err.println(DEBUG: meeting date value object id before:  
+ meetingDateValueObject.getId());
  meetingDateHome.create(meetingDateValueObject);
  System.err.println(DEBUG: meeting date value object id before:  
+ meetingDateValueObject.getId());
  return(true);
 }

MeetingDateHome is an entity bean. The first debug message indicates 
that the id
property in the passed value object is null, which is correct. The 
second debug message
returns an accurate number, reflecting that the entity bean is properly 
setting the
value of id in the value object.

So, given that the entity bean exits with the value object id property 
having an accurate
value, why does the second debug message in the session bean still 
return a null
value for the id property?

An important consideration here is that this only happens if the client 
calling the session
bean is running in a different JVM. If they are running in the same JVM, 
the value in
the second debug message of the session bean is set accurately.

Will appreciate any insight.



---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


Re: Antwort: [JBoss-user] Maximum queue depth on JBoss

2003-10-07 Thread Horia Muntean
Well, Mr. Adrian Brock solved this lately. 10x.

https://sourceforge.net/tracker/?func=detailatid=381174aid=815941group_id=22866

Regards,
Horia
[EMAIL PROTECTED] wrote:

I am sorry, but simple answer: no



*Horia Muntean [EMAIL PROTECTED]*
Gesendet von: [EMAIL PROTECTED]
01.10.2003 11:25
Bitte antworten an jboss-user
	   
An:[EMAIL PROTECTED]
Kopie:
Thema:[JBoss-user] Maximum queue depth on JBoss



Hello,

Is there any way that one can configure maximum queue depth on JBoss
2.4.x or any other version for that matter?
Regards,
Horia


---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user



---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


RE: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-07 Thread Comtois, Pierre
No ... 3.2.2RC4 ... The date was an error on my part ... I extracted the
orginal from the zip file and will try again ...


Pierre Comtois
Business Acceleration Services, Solutions Consulting 
45 O'Connor Street, Suite 500*Ottawa, Ontario K1P 1A4
Ph: 613-787-4649  *  FAX: 613-567-6053  *  E-Mail:  [EMAIL PROTECTED]




-Original Message-
From: Adrian Brock [mailto:[EMAIL PROTECTED] 
Sent: October 6, 2003 7:40 PM
To: [EMAIL PROTECTED]
Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS


On Mon, 2003-10-06 at 22:23, Comtois, Pierre wrote:
 Default install puts it in  ... It's dated June 10/2003 ...
 

Ok, so you are using 3.2.1?

Copy the SQL Properties from the mysql-jdbc2-service.xml
into jbossmq-service.xml - replacing the hsqldb sql properties.

Where is the difficulty?
There is an MBean called the PersistenceManager that
takes a parameter called SQLProperties. 
By default it references DefaultDS and uses hsqldb sql.
You need to change it to match your jndi name and mysql sql statements.

It is harder with 3.2.1

With 3.2.2 it will be to just delete hsqldb-jdbc2-service.xml 
and replace it with mysql-jdbc2-service.xml

Regards,
Adrian

 
 Pierre Comtois
 Business Acceleration Services, Solutions Consulting 
 45 O'Connor Street, Suite 500*Ottawa, Ontario K1P 1A4
 Ph: 613-787-4649  *  FAX: 613-567-6053  *  E-Mail:
[EMAIL PROTECTED]
 
 
 
 
 -Original Message-
 From: Adrian Brock [mailto:[EMAIL PROTECTED] 
 Sent: October 6, 2003 4:56 PM
 To: [EMAIL PROTECTED]
 Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS
 
 
 Where did you get jbossmq-service.xml from?
 
 The persistence manager has been removed from that file.
 It is now in x-jdbc2-service.xml
 
 Supposedly to make it easier to drop in a different implementation 
 like you are trying :-)
 
 Regards,
 Adrian
 
 On Mon, 2003-10-06 at 21:47, Comtois, Pierre wrote:
  I've also copied mysql-jdbc2-service.xml from the examples to the 
  deploy/jms folder and deleted the hsql version.
  
  I'm still getting an error:
  
  16:41:14,011 INFO  [MainDeployer] Starting deployment of package: 
  file:/C:/jboss-3.2.2RC4/server/default/deploy/jms/jbossmq-service.xml
  16:41:14,322 INFO  [ServiceConfigurator] Problem configuring service 
  jboss.mq:service=PersistenceManager
  org.jboss.deployment.DeploymentException: Exception setting attribute
  javax.management.Attribute: name=MessageCache 
  value=jboss.mq:service=MessageCache on mbean 
  jboss.mq:service=PersistenceManager; - nested throwable:
  (java.lang.UnsupportedOperationException: This is now set on the 
  destination
  manager)
  at
 

org.jboss.system.ServiceConfigurator.setAttribute(ServiceConfigurator.java:4
  78)
  
  
  Sounds like I should remove name=MessageCache 
  value=jboss.mq:service=MessageCache attribute .. Would that be right ?
  
  
  Pierre Comtois
  Business Acceleration Services, Solutions Consulting 
  45 O'Connor Street, Suite 500*Ottawa, Ontario K1P 1A4
  Ph: 613-787-4649  *  FAX: 613-567-6053  *  E-Mail:  
  [EMAIL PROTECTED]
  
  
  
  
  -Original Message-
  From: Comtois, Pierre
  Sent: October 6, 2003 4:13 PM
  To: '[EMAIL PROTECTED]'
  Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS
  
  
  I deleted hsqldb-ds.xml and changed jndi name.
  I'm looking at what I'd need to change ...
  
  My install didn't have any reference to persistence in 
  jbossmq-service.xmlso copied the one I found at 
  http://www.jboss.org/thread.jsp?forum=48thread=39416message=3803454;
  q=jbos
  smq-service.xml#3803454 and put it in the default/deploy/jms folder.
  
  I found a section to :
  
  mbean code=org.jboss.mq.pm.jdbc2.PersistenceManager
   name=jboss.mq:service=PersistenceManager
  depends 
  optional-attribute-name=MessageCachejboss.mq:service=MessageCache/
  depend
  s
  depends 
  optional-attribute-name=ConnectionManagerjboss.jca:service=LocalTxC
  M,name
  =DefaultDS/depends
  attribute name=SqlProperties
  
  But it only includes SQL statements that do not seem to be 
  configurable specifically for my DB. Likely there are other attribs, 
  but can't find any mention of any in the archives.
  
  Can you point me where ?
  
  Thx ...
  
  
  Pierre Comtois
  Business Acceleration Services, Solutions Consulting 
  45 O'Connor Street, Suite 500*Ottawa, Ontario K1P 1A4
  Ph: 613-787-4649  *  FAX: 613-567-6053  *  E-Mail:
  [EMAIL PROTECTED]
  
  
  
  
  -Original Message-
  From: Adrian Brock [mailto:[EMAIL PROTECTED]
  Sent: October 6, 2003 2:24 PM
  To: [EMAIL PROTECTED]
  Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS
  
  
  If you want it to be the default db you should
  remove hsqldb-ds.xml
  change the jndi name in your mysql-ds.xml to DefaultDS
  
  You will also need to modify the sql properties in 
  jms/jbossmq-service.xml as discussed last week on this list.
  
  Regards,
  Adrian
  
  On Mon, 2003-10-06 at 19:15, Comtois, 

[JBoss-user] problem with XA transactions

2003-10-07 Thread Coors, Ruediger
Hi,

I have a problem switching from local transactions to XA transactions (
using JBoss 3.2.1,  DB is Oracle 9.2 ). 
After some try  error the app is running, but one problem at startup
remains. 
If table creation for CMP Entity Bean is switched on I get the following
error:

org.jboss.deployment.DeploymentException: Error while checking if table
aleady exists; - nested throwable: (java.sql.SQLExceptio
n: Nicht in einer Transaktion)
at
org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.tableExists(SQLUtil.java:731)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand
.java:143)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.jav
a:87)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreM
anager.java:499)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:
410)
at
org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java
:170)
at
org.jboss.ejb.EntityContainer.startService(EntityContainer.java:339)
at
org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispat
cher.java:284)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
at
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.jav
a:966)
at $Proxy11.start(Unknown Source)
at
org.jboss.system.ServiceController.start(ServiceController.java:392)

any help appreciated

Rüdiger Coors


---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


Re: [JBoss-user] problem with XA transactions

2003-10-07 Thread Adrian Brock
This problem has fixed for 3.2.2
It is a common problem with jdbc XA drivers - nobody seems to be able
to write them properly. :-)

http://sourceforge.net/tracker/index.php?func=detailaid=809006group_id=22866atid=381174

Regards,
Adrian

On Tue, 2003-10-07 at 14:58, Coors, Ruediger wrote:
 Hi,
 
 I have a problem switching from local transactions to XA transactions (
 using JBoss 3.2.1,  DB is Oracle 9.2 ). 
 After some try  error the app is running, but one problem at startup
 remains. 
 If table creation for CMP Entity Bean is switched on I get the following
 error:
 
 org.jboss.deployment.DeploymentException: Error while checking if table
 aleady exists; - nested throwable: (java.sql.SQLExceptio
 n: Nicht in einer Transaktion)
 at
 org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.tableExists(SQLUtil.java:731)
 at
 org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand
 .java:143)
 at
 org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.jav
 a:87)
 at
 org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreM
 anager.java:499)
 at
 org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:
 410)
 at
 org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java
 :170)
 at
 org.jboss.ejb.EntityContainer.startService(EntityContainer.java:339)
 at
 org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
 at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
 at
 sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
 .java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at
 org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispat
 cher.java:284)
 at
 org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
 at
 org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.jav
 a:966)
 at $Proxy11.start(Unknown Source)
 at
 org.jboss.system.ServiceController.start(ServiceController.java:392)
 
 any help appreciated
 
 Rdiger Coors
 
 
 ---
 This sf.net email is sponsored by:ThinkGeek
 Welcome to geek heaven.
 http://thinkgeek.com/sf
 ___
 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:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


RE: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-07 Thread Comtois, Pierre
Making progress ... but ever s-o-o-o-o slowly !

It would seem that the persistence tables specified by the
mysql-jdbc2-service.xml file are not getting creating resulting in
connection errors on startup. I found nothing in the archives that helped
...

  CREATE_MESSAGE_TABLE = CREATE TABLE JMS_MESSAGES (MESSAGEID INTEGER
NOT NULL, DESTINATION VARCHAR(150) NOT NULL, TXID INTEGER, TXOP CHAR(1),
MESSAGEBLOB BLOB, PRIMARY KEY (MESSAGEID, DESTINATION))
  CREATE_TX_TABLE = CREATE TABLE JMS_TRANSACTIONS (TXID INTEGER)
  CREATE_TABLES_ON_STARTUP = TRUE

What could be preventing these from getting created ... I've now changed
user temporarily to root to remove authorization issues from the equation.
If I have to, I'll create them by hand, but this likely indicates another
problem.

P.S. Is there an up-to-date document anywhere that details how to integrate
MySQL 4.x with JBOSS 3.2.2RC4? I've found stuff with Google but haven't
found anything up-to-date and accurate. I'm setting up a pc with around 12
different development modules/tools and this piece is taking much more time
than it should/can afford to get going on the actual development phase.
Maybe what I want to do is a rarity, but I don't think it is. A short white
paper would cost cycles initially, but would likely pay off over the long
haul.


Pierre Comtois
Business Acceleration Services, Solutions Consulting 
45 O'Connor Street, Suite 500*Ottawa, Ontario K1P 1A4
Ph: 613-787-4649  *  FAX: 613-567-6053  *  E-Mail:  [EMAIL PROTECTED]




-Original Message-
From: Adrian Brock [mailto:[EMAIL PROTECTED] 
Sent: October 6, 2003 7:40 PM
To: [EMAIL PROTECTED]
Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS


On Mon, 2003-10-06 at 22:23, Comtois, Pierre wrote:
 Default install puts it in  ... It's dated June 10/2003 ...
 

Ok, so you are using 3.2.1?

Copy the SQL Properties from the mysql-jdbc2-service.xml
into jbossmq-service.xml - replacing the hsqldb sql properties.

Where is the difficulty?
There is an MBean called the PersistenceManager that
takes a parameter called SQLProperties. 
By default it references DefaultDS and uses hsqldb sql.
You need to change it to match your jndi name and mysql sql statements.

It is harder with 3.2.1

With 3.2.2 it will be to just delete hsqldb-jdbc2-service.xml 
and replace it with mysql-jdbc2-service.xml

Regards,
Adrian

 
 Pierre Comtois
 Business Acceleration Services, Solutions Consulting 
 45 O'Connor Street, Suite 500*Ottawa, Ontario K1P 1A4
 Ph: 613-787-4649  *  FAX: 613-567-6053  *  E-Mail:
[EMAIL PROTECTED]
 
 
 
 
 -Original Message-
 From: Adrian Brock [mailto:[EMAIL PROTECTED] 
 Sent: October 6, 2003 4:56 PM
 To: [EMAIL PROTECTED]
 Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS
 
 
 Where did you get jbossmq-service.xml from?
 
 The persistence manager has been removed from that file.
 It is now in x-jdbc2-service.xml
 
 Supposedly to make it easier to drop in a different implementation 
 like you are trying :-)
 
 Regards,
 Adrian
 
 On Mon, 2003-10-06 at 21:47, Comtois, Pierre wrote:
  I've also copied mysql-jdbc2-service.xml from the examples to the 
  deploy/jms folder and deleted the hsql version.
  
  I'm still getting an error:
  
  16:41:14,011 INFO  [MainDeployer] Starting deployment of package: 
  file:/C:/jboss-3.2.2RC4/server/default/deploy/jms/jbossmq-service.xml
  16:41:14,322 INFO  [ServiceConfigurator] Problem configuring service 
  jboss.mq:service=PersistenceManager
  org.jboss.deployment.DeploymentException: Exception setting attribute
  javax.management.Attribute: name=MessageCache 
  value=jboss.mq:service=MessageCache on mbean 
  jboss.mq:service=PersistenceManager; - nested throwable:
  (java.lang.UnsupportedOperationException: This is now set on the 
  destination
  manager)
  at
 

org.jboss.system.ServiceConfigurator.setAttribute(ServiceConfigurator.java:4
  78)
  
  
  Sounds like I should remove name=MessageCache 
  value=jboss.mq:service=MessageCache attribute .. Would that be right ?
  
  
  Pierre Comtois
  Business Acceleration Services, Solutions Consulting 
  45 O'Connor Street, Suite 500*Ottawa, Ontario K1P 1A4
  Ph: 613-787-4649  *  FAX: 613-567-6053  *  E-Mail:  
  [EMAIL PROTECTED]
  
  
  
  
  -Original Message-
  From: Comtois, Pierre
  Sent: October 6, 2003 4:13 PM
  To: '[EMAIL PROTECTED]'
  Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS
  
  
  I deleted hsqldb-ds.xml and changed jndi name.
  I'm looking at what I'd need to change ...
  
  My install didn't have any reference to persistence in 
  jbossmq-service.xmlso copied the one I found at 
  http://www.jboss.org/thread.jsp?forum=48thread=39416message=3803454;
  q=jbos
  smq-service.xml#3803454 and put it in the default/deploy/jms folder.
  
  I found a section to :
  
  mbean code=org.jboss.mq.pm.jdbc2.PersistenceManager
   name=jboss.mq:service=PersistenceManager
  depends 
  

RE: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-07 Thread Adrian Brock
Some guy had the same problem last week and resolved it, 
but he seems to have vanished from this list when somebody
else has a problem. :-(

On Tue, 2003-10-07 at 15:34, Comtois, Pierre wrote:
 Making progress ... but ever s-o-o-o-o slowly !
 
 It would seem that the persistence tables specified by the
 mysql-jdbc2-service.xml file are not getting creating resulting in
 connection errors on startup. I found nothing in the archives that helped
 ...
 
   CREATE_MESSAGE_TABLE = CREATE TABLE JMS_MESSAGES (MESSAGEID INTEGER
 NOT NULL, DESTINATION VARCHAR(150) NOT NULL, TXID INTEGER, TXOP CHAR(1),
 MESSAGEBLOB BLOB, PRIMARY KEY (MESSAGEID, DESTINATION))
   CREATE_TX_TABLE = CREATE TABLE JMS_TRANSACTIONS (TXID INTEGER)
   CREATE_TABLES_ON_STARTUP = TRUE
 
 What could be preventing these from getting created ... I've now changed
 user temporarily to root to remove authorization issues from the equation.
 If I have to, I'll create them by hand, but this likely indicates another
 problem.
 

Please wait... I'm trying to hack your machine so I can see the error
message. :-)

 P.S. Is there an up-to-date document anywhere that details how to integrate
 MySQL 4.x with JBOSS 3.2.2RC4? I've found stuff with Google but haven't
 found anything up-to-date and accurate. I'm setting up a pc with around 12
 different development modules/tools and this piece is taking much more time
 than it should/can afford to get going on the actual development phase.
 Maybe what I want to do is a rarity, but I don't think it is. A short white
 paper would cost cycles initially, but would likely pay off over the long
 haul.
 

Remove mysql-jdbc2.xml and use the file version.
Come back to it when you are sure mysql works.

I'm currently preparing an enhanced jbossmq section for the admin
docs with the 3.2.2 release.

Regards,
Adrian

 
 Pierre Comtois
 Business Acceleration Services, Solutions Consulting 
 45 O'Connor Street, Suite 500*Ottawa, Ontario K1P 1A4
 Ph: 613-787-4649  *  FAX: 613-567-6053  *  E-Mail:  [EMAIL PROTECTED]
 
 
 
 
 -Original Message-
 From: Adrian Brock [mailto:[EMAIL PROTECTED] 
 Sent: October 6, 2003 7:40 PM
 To: [EMAIL PROTECTED]
 Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS
 
 
 On Mon, 2003-10-06 at 22:23, Comtois, Pierre wrote:
  Default install puts it in  ... It's dated June 10/2003 ...
  
 
 Ok, so you are using 3.2.1?
 
 Copy the SQL Properties from the mysql-jdbc2-service.xml
 into jbossmq-service.xml - replacing the hsqldb sql properties.
 
 Where is the difficulty?
 There is an MBean called the PersistenceManager that
 takes a parameter called SQLProperties. 
 By default it references DefaultDS and uses hsqldb sql.
 You need to change it to match your jndi name and mysql sql statements.
 
 It is harder with 3.2.1
 
 With 3.2.2 it will be to just delete hsqldb-jdbc2-service.xml 
 and replace it with mysql-jdbc2-service.xml
 
 Regards,
 Adrian
 
  
  Pierre Comtois
  Business Acceleration Services, Solutions Consulting 
  45 O'Connor Street, Suite 500*Ottawa, Ontario K1P 1A4
  Ph: 613-787-4649  *  FAX: 613-567-6053  *  E-Mail:
 [EMAIL PROTECTED]
  
  
  
  
  -Original Message-
  From: Adrian Brock [mailto:[EMAIL PROTECTED] 
  Sent: October 6, 2003 4:56 PM
  To: [EMAIL PROTECTED]
  Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS
  
  
  Where did you get jbossmq-service.xml from?
  
  The persistence manager has been removed from that file.
  It is now in x-jdbc2-service.xml
  
  Supposedly to make it easier to drop in a different implementation 
  like you are trying :-)
  
  Regards,
  Adrian
  
  On Mon, 2003-10-06 at 21:47, Comtois, Pierre wrote:
   I've also copied mysql-jdbc2-service.xml from the examples to the 
   deploy/jms folder and deleted the hsql version.
   
   I'm still getting an error:
   
   16:41:14,011 INFO  [MainDeployer] Starting deployment of package: 
   file:/C:/jboss-3.2.2RC4/server/default/deploy/jms/jbossmq-service.xml
   16:41:14,322 INFO  [ServiceConfigurator] Problem configuring service 
   jboss.mq:service=PersistenceManager
   org.jboss.deployment.DeploymentException: Exception setting attribute
   javax.management.Attribute: name=MessageCache 
   value=jboss.mq:service=MessageCache on mbean 
   jboss.mq:service=PersistenceManager; - nested throwable:
   (java.lang.UnsupportedOperationException: This is now set on the 
   destination
   manager)
 at
  
 
 org.jboss.system.ServiceConfigurator.setAttribute(ServiceConfigurator.java:4
   78)
   
   
   Sounds like I should remove name=MessageCache 
   value=jboss.mq:service=MessageCache attribute .. Would that be right ?
   
   
   Pierre Comtois
   Business Acceleration Services, Solutions Consulting 
   45 O'Connor Street, Suite 500*Ottawa, Ontario K1P 1A4
   Ph: 613-787-4649  *  FAX: 613-567-6053  *  E-Mail:  
   [EMAIL PROTECTED]
   
   
   
   
   -Original Message-
   From: Comtois, Pierre
   Sent: October 6, 2003 4:13 

RE: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-07 Thread Comtois, Pierre
I found a reference where a user ended up creating them manually which I'm
thinking of doing to go forward. If that doesn't work, then I'll use the
file method, but I hate giving up on it ...


Pierre Comtois
Business Acceleration Services, Solutions Consulting 
45 O'Connor Street, Suite 500*Ottawa, Ontario K1P 1A4
Ph: 613-787-4649  *  FAX: 613-567-6053  *  E-Mail:  [EMAIL PROTECTED]




-Original Message-
From: Adrian Brock [mailto:[EMAIL PROTECTED] 
Sent: October 7, 2003 11:01 AM
To: [EMAIL PROTECTED]
Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS


Some guy had the same problem last week and resolved it, 
but he seems to have vanished from this list when somebody
else has a problem. :-(

On Tue, 2003-10-07 at 15:34, Comtois, Pierre wrote:
 Making progress ... but ever s-o-o-o-o slowly !
 
 It would seem that the persistence tables specified by the 
 mysql-jdbc2-service.xml file are not getting creating resulting in 
 connection errors on startup. I found nothing in the archives that 
 helped ...
 
   CREATE_MESSAGE_TABLE = CREATE TABLE JMS_MESSAGES (MESSAGEID 
 INTEGER NOT NULL, DESTINATION VARCHAR(150) NOT NULL, TXID INTEGER, 
 TXOP CHAR(1), MESSAGEBLOB BLOB, PRIMARY KEY (MESSAGEID, DESTINATION))
   CREATE_TX_TABLE = CREATE TABLE JMS_TRANSACTIONS (TXID INTEGER)
   CREATE_TABLES_ON_STARTUP = TRUE
 
 What could be preventing these from getting created ... I've now 
 changed user temporarily to root to remove authorization issues from 
 the equation. If I have to, I'll create them by hand, but this likely 
 indicates another problem.
 

Please wait... I'm trying to hack your machine so I can see the error
message. :-)

 P.S. Is there an up-to-date document anywhere that details how to 
 integrate MySQL 4.x with JBOSS 3.2.2RC4? I've found stuff with Google 
 but haven't found anything up-to-date and accurate. I'm setting up a 
 pc with around 12 different development modules/tools and this piece 
 is taking much more time than it should/can afford to get going on the 
 actual development phase. Maybe what I want to do is a rarity, but I 
 don't think it is. A short white paper would cost cycles initially, 
 but would likely pay off over the long haul.
 

Remove mysql-jdbc2.xml and use the file version.
Come back to it when you are sure mysql works.

I'm currently preparing an enhanced jbossmq section for the admin docs with
the 3.2.2 release.

Regards,
Adrian

 
 Pierre Comtois
 Business Acceleration Services, Solutions Consulting 
 45 O'Connor Street, Suite 500*Ottawa, Ontario K1P 1A4
 Ph: 613-787-4649  *  FAX: 613-567-6053  *  E-Mail:  
 [EMAIL PROTECTED]
 
 
 
 
 -Original Message-
 From: Adrian Brock [mailto:[EMAIL PROTECTED]
 Sent: October 6, 2003 7:40 PM
 To: [EMAIL PROTECTED]
 Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS
 
 
 On Mon, 2003-10-06 at 22:23, Comtois, Pierre wrote:
  Default install puts it in  ... It's dated June 10/2003 ...
  
 
 Ok, so you are using 3.2.1?
 
 Copy the SQL Properties from the mysql-jdbc2-service.xml
 into jbossmq-service.xml - replacing the hsqldb sql properties.
 
 Where is the difficulty?
 There is an MBean called the PersistenceManager that
 takes a parameter called SQLProperties.
 By default it references DefaultDS and uses hsqldb sql.
 You need to change it to match your jndi name and mysql sql statements.
 
 It is harder with 3.2.1
 
 With 3.2.2 it will be to just delete hsqldb-jdbc2-service.xml
 and replace it with mysql-jdbc2-service.xml
 
 Regards,
 Adrian
 
  
  Pierre Comtois
  Business Acceleration Services, Solutions Consulting 
  45 O'Connor Street, Suite 500*Ottawa, Ontario K1P 1A4
  Ph: 613-787-4649  *  FAX: 613-567-6053  *  E-Mail:
 [EMAIL PROTECTED]
  
  
  
  
  -Original Message-
  From: Adrian Brock [mailto:[EMAIL PROTECTED]
  Sent: October 6, 2003 4:56 PM
  To: [EMAIL PROTECTED]
  Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS
  
  
  Where did you get jbossmq-service.xml from?
  
  The persistence manager has been removed from that file.
  It is now in x-jdbc2-service.xml
  
  Supposedly to make it easier to drop in a different implementation
  like you are trying :-)
  
  Regards,
  Adrian
  
  On Mon, 2003-10-06 at 21:47, Comtois, Pierre wrote:
   I've also copied mysql-jdbc2-service.xml from the examples to the
   deploy/jms folder and deleted the hsql version.
   
   I'm still getting an error:
   
   16:41:14,011 INFO  [MainDeployer] Starting deployment of package:
   file:/C:/jboss-3.2.2RC4/server/default/deploy/jms/jbossmq-service.xml
   16:41:14,322 INFO  [ServiceConfigurator] Problem configuring service 
   jboss.mq:service=PersistenceManager
   org.jboss.deployment.DeploymentException: Exception setting attribute
   javax.management.Attribute: name=MessageCache 
   value=jboss.mq:service=MessageCache on mbean 
   jboss.mq:service=PersistenceManager; - nested throwable:
   (java.lang.UnsupportedOperationException: 

[JBoss-user] SQLException from 3.2.2 branch when trying to remove an entity.

2003-10-07 Thread Jason Essington
I have some code that worked just fine in 3.2.1 but now it is having  
trouble in the 3.2.2 branch of JBoss.

I am getting an SQLException when I try to remove an entity that has a  
1-m cascade delete relationship.

The code I am using first gets a collection of entities via a finder  
then iterates over the collection calling .remove() on each entity  
something like:

for (Iterator i = mtmRecords.iterator(); i.hasNext();)
{
	FXMarkToMarketLocal record = (FXMarkToMarketLocal) i.next();
	try
	{
		if (record != null)
		{
			if (log.isDebugEnabled())
log.debug(\nRemoving Mark to Market record +  
record.getRid().toString()+\n);
			record.remove();
		}
	}
	catch (RemoveException e)
	{
		log.warn(Unable to remove an old mark to market record., e);
	}
}

JBoss seems to go ahead and disassociate the related entities then  
delete the entity and it's related entities (which are to be cascaded)  
just fine, but when this is complete, it tries to issue the following  
SQL statement:

SELECT rid,  FROM tfxmtm WHERE (rid=?) OR (rid=?) OR (rid=?) OR (rid=?)  
OR (rid=?) OR (rid=?) OR (rid=?) OR (rid=?) OR (rid=?) OR (rid=?) OR  
(rid=?)

This statement appears to be missing all of its CMP fields (minus the  
pk field), and is not valid sql. This causes the exception shown below.

Is there something I am doing that is no longer allowed in 3.2.2? Or is  
this just a bug?

java.sql.SQLException: ERROR:  parser: parse error at or near FROM at  
character 14

at  
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
at  
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connec 
tion.java:505)
at  
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Stateme 
nt.java:320)
at  
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme 
nt.java:48)
at  
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1St 
atement.java:153)
at  
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(Wr 
appedPreparedStatement.java:302)
at  
org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEnt 
ityCommand.java:158)
at  
org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEnt 
ityCommand.java:76)
at  
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadEntity(JDBCStoreMana 
ger.java:577)
at  
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadEntity(JDBCStoreMana 
ger.java:559)
at  
org.jboss.ejb.plugins.CMPPersistenceManager.loadEntity(CMPPersistenceMan 
ager.java:381)
at  
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.loadEnt 
ity(CachedConnectionInterceptor.java:352)
at  
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntitySync 
hronizationInterceptor.java:239)
at  
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke( 
CachedConnectionInterceptor.java:185)
at  
org.jboss.ejb.plugins.EntityReentranceInterceptor.invoke(EntityReentranc 
eInterceptor.java:114)
at  
org.jboss.ejb.plugins.EntityMultiInstanceInterceptor.invoke(EntityMultiI 
nstanceInterceptor.java:108)
at  
org.jboss.ejb.plugins.EntityLockInterceptor.invoke(EntityLockInterceptor 
.java:89)
at  
org.jboss.ejb.plugins.EntityCreationInterceptor.invoke(EntityCreationInt 
erceptor.java:54)
at  
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterce 
ptor.java:84)
at  
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptor 
CMT.java:267)
at  
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128)
at  
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.jav 
a:118)
at  
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
at  
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryF 
inderInterceptor.java:122)
at  
org.jboss.ejb.EntityContainer.internalInvoke(EntityContainer.java:490)
at org.jboss.ejb.Container.invoke(Container.java:700)
at  
org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyF 
actory.java:375)
at  
org.jboss.ejb.plugins.local.EntityProxy.invoke(EntityProxy.java:38)
at $Proxy399.getRid(Unknown Source)
at  
com.grcs.hedgehog.close.ejb.session.DetailSelectionBean.closeCurrentPeri 
od(DetailSelectionBean.java:174)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at  
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav 
a:39)
at  
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor 
Impl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at  
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(Stat 
elessSessionContainer.java:683)
at  

[JBoss-user] JNDI names for session and entity beans?

2003-10-07 Thread Steven Harris
I've got local entity beans and remote stateless session beans, with JNDI
names defined in jboss.xml. Jboss seems to use the ejb-name as the JNDI
name of my local entity beans and the jndi-name as the JNDI name of my
stateless session beans. For example:

From ejb.jar
--

session
ejb-nameAssociationSvcEJB/ejb-name
homecom.pfn.wirepower.srv.service.associationSvc.AssociationSvcHome/home
remotecom.pfn.wirepower.srv.service.associationSvc.AssociationSvc/remote
ejb-classcom.pfn.wirepower.srv.service.associationSvc.impl.AssociationSvcB
ean/ejb-class
session-typeStateless/session-type
transaction-typeBean/transaction-type
..etc
/session

entity
ejb-nameSiteEJB/ejb-name
local-homecom.pfn.wirepower.srv.persistence.site.SiteLocalHome/local-home

localcom.pfn.wirepower.srv.persistence.site.SiteLocal/local
ejb-classcom.pfn.wirepower.srv.persistence.site.impl.SiteBean/ejb-class
persistence-typeContainer/persistence-type
prim-key-classjava.lang.Integer/prim-key-class
..etc
/entity


From JBoss.xml
---
session
ejb-nameAssociationSvcEJB/ejb-name
jndi-nameAssociationSvcHome/jndi-name
/session

entity
ejb-nameSiteEJB/ejb-name
jndi-nameSiteLocalHome/jndi-name
/entity

The JBoss console shows the jndiName=AssociationSvcHome and
jndiName=SiteEjb. Referencing them programatically from an MBean confirms
this. 


---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] Problems with HTTP invoker

2003-10-07 Thread Bob Cotton

JBoss 3.2.1
Apache 1.3 w/ mod_jk

Apache has mod_jk a list of workers configured as an 'lb' worker,
against a list of jboss servers all running tomcat with mod_jk.

Apache is installed on machine a, and the http invoker (in jboss ) is
installed on machine b. The http invoker is accessed through mod_jk.

we have the following in our service-bindings files:

service-config name=jboss:service=invoker,type=http
  delegateClass=org.jboss.services.binding.AttributeMappingDelegate
  delegate-config
attribute 
name=InvokerURLhttp://wstest01-gsjthree/invoker/EJBInvokerServlet/attribute
  /delegate-config
  binding/
/service-config

service-config name=jboss:service=invoker,type=httpHA
  delegateClass=org.jboss.services.binding.AttributeMappingDelegate
  delegate-config
attribute 
name=InvokerURLhttp://wstest01-gsjthree/invoker/EJBInvokerHAServlet/attribute
  /delegate-config
  binding/
/service-config

service-config name=jboss:service=invoker,type=http,target=Naming
  delegateClass=org.jboss.services.binding.AttributeMappingDelegate
  delegate-config
attribute 
name=InvokerURLhttp://wstest01-gsjthree/invoker/JMXInvokerServlet/attribute
  /delegate-config
  binding/
/service-config

service-config name=jboss:service=invoker,type=http,target=Naming,readonly=true
  delegateClass=org.jboss.services.binding.AttributeMappingDelegate
  delegate-config
attribute 
name=InvokerURLhttp://wstest01-gsjthree/invoker/JMXInvokerServlet/attribute
  /delegate-config
  binding/
/service-config


In our test system, everything works great. 

When we set this up in production, with the only change being the
InvokerURL starting with https, I get the following stack:

java.rmi.RemoteException: Service unavailable.
at 
org.jboss.invocation.jrmp.interfaces.JRMPInvokerProxyHA.invoke(JRMPInvokerProxyHA.java:291)
at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:87)
at 
org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45)
at org.jboss.proxy.ejb.HomeInterceptor.invoke(HomeInterceptor.java:173)
at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
at $Proxy2.create(Unknown Source)
at 
com.synxis.srms.ejbs.util.ServicesLocator.getStatelessSessionRemote(ServicesLocator.java:126)
at 
com.synxis.srms.ejbs.login.SrmsAuthServiceRemoteManager.reconnect(SrmsAuthServiceRemoteManager.java:101)
at 
com.synxis.srms.ejbs.login.SrmsAuthServiceRemoteManager.login(SrmsAuthServiceRemoteManager.java:163)

This is on ejbcreate. The home lookup works.

Ideas?

Thanks 
-Bob

-- 
SynXis Corporation  | [EMAIL PROTECTED]| no .sig today.
1610 Wynkoop, Suite 400 | Ph: (303)595-2511 | 
Denver, CO  80202   | Fax:(303)534-4257 | 



---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


RE: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-07 Thread Comtois, Pierre
Finally resolved the exception issue:

1. I created the tables manually and for my appl. Made them of type InnoDB

2. I gave SELECT permission to my user to the mysql database so it could
access its permission table. I'm a novice at MySql as well so I might have
messed that up myself :-)

3. I had put my computer name in the mysql-ds connection-url attribute ... I
put it back to localhost

ps: I would have thought that it would be better to specify a computer name
as opposed to localhost ... ?


Next item up for bid ... I want to access the newly configured DB using the
JBoss console ( http://localhost:8080/jmx-console/index.jsp ). Seems that
now I have no link in jmx-console to access the Hypwersonic service ... The
link to it is gone ...
Is this normal ? Am I missing something ? My thought is that I have to
configures the jmx ...

Looking at displayMBeans.jsp, that the mbean is missing in the MBeanData
array ...
%
  MBeanData[] data = domainData.getData();
  for(int d = 0; d  data.length; d ++)
  {
 String name = data[d].getObjectName().toString();
 String properties = data[d].getNameProperties();
%
  lia href=HtmlAdaptor?action=inspectMBeanname=%=
URLEncoder.encode(name) %%= URLDecoder.decode(properties) %/a/li
%


Ideas ?

Pierre Comtois
Business Acceleration Services, Solutions Consulting 
45 O'Connor Street, Suite 500*Ottawa, Ontario K1P 1A4
Ph: 613-787-4649  *  FAX: 613-567-6053  *  E-Mail:  [EMAIL PROTECTED]




-Original Message-
From: Adrian Brock [mailto:[EMAIL PROTECTED] 
Sent: October 7, 2003 11:01 AM
To: [EMAIL PROTECTED]
Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS


Some guy had the same problem last week and resolved it, 
but he seems to have vanished from this list when somebody
else has a problem. :-(

On Tue, 2003-10-07 at 15:34, Comtois, Pierre wrote:
 Making progress ... but ever s-o-o-o-o slowly !
 
 It would seem that the persistence tables specified by the 
 mysql-jdbc2-service.xml file are not getting creating resulting in 
 connection errors on startup. I found nothing in the archives that 
 helped ...
 
   CREATE_MESSAGE_TABLE = CREATE TABLE JMS_MESSAGES (MESSAGEID 
 INTEGER NOT NULL, DESTINATION VARCHAR(150) NOT NULL, TXID INTEGER, 
 TXOP CHAR(1), MESSAGEBLOB BLOB, PRIMARY KEY (MESSAGEID, DESTINATION))
   CREATE_TX_TABLE = CREATE TABLE JMS_TRANSACTIONS (TXID INTEGER)
   CREATE_TABLES_ON_STARTUP = TRUE
 
 What could be preventing these from getting created ... I've now 
 changed user temporarily to root to remove authorization issues from 
 the equation. If I have to, I'll create them by hand, but this likely 
 indicates another problem.
 

Please wait... I'm trying to hack your machine so I can see the error
message. :-)

 P.S. Is there an up-to-date document anywhere that details how to 
 integrate MySQL 4.x with JBOSS 3.2.2RC4? I've found stuff with Google 
 but haven't found anything up-to-date and accurate. I'm setting up a 
 pc with around 12 different development modules/tools and this piece 
 is taking much more time than it should/can afford to get going on the 
 actual development phase. Maybe what I want to do is a rarity, but I 
 don't think it is. A short white paper would cost cycles initially, 
 but would likely pay off over the long haul.
 

Remove mysql-jdbc2.xml and use the file version.
Come back to it when you are sure mysql works.

I'm currently preparing an enhanced jbossmq section for the admin docs with
the 3.2.2 release.

Regards,
Adrian

 
 Pierre Comtois
 Business Acceleration Services, Solutions Consulting 
 45 O'Connor Street, Suite 500*Ottawa, Ontario K1P 1A4
 Ph: 613-787-4649  *  FAX: 613-567-6053  *  E-Mail:  
 [EMAIL PROTECTED]
 
 
 
 
 -Original Message-
 From: Adrian Brock [mailto:[EMAIL PROTECTED]
 Sent: October 6, 2003 7:40 PM
 To: [EMAIL PROTECTED]
 Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS
 
 
 On Mon, 2003-10-06 at 22:23, Comtois, Pierre wrote:
  Default install puts it in  ... It's dated June 10/2003 ...
  
 
 Ok, so you are using 3.2.1?
 
 Copy the SQL Properties from the mysql-jdbc2-service.xml
 into jbossmq-service.xml - replacing the hsqldb sql properties.
 
 Where is the difficulty?
 There is an MBean called the PersistenceManager that
 takes a parameter called SQLProperties.
 By default it references DefaultDS and uses hsqldb sql.
 You need to change it to match your jndi name and mysql sql statements.
 
 It is harder with 3.2.1
 
 With 3.2.2 it will be to just delete hsqldb-jdbc2-service.xml
 and replace it with mysql-jdbc2-service.xml
 
 Regards,
 Adrian
 
  
  Pierre Comtois
  Business Acceleration Services, Solutions Consulting 
  45 O'Connor Street, Suite 500*Ottawa, Ontario K1P 1A4
  Ph: 613-787-4649  *  FAX: 613-567-6053  *  E-Mail:
 [EMAIL PROTECTED]
  
  
  
  
  -Original Message-
  From: Adrian Brock [mailto:[EMAIL PROTECTED]
  Sent: October 6, 2003 4:56 PM
  To: [EMAIL PROTECTED]
  

Re: [JBoss-user] SQLException from 3.2.2 branch when trying to remove an entity.

2003-10-07 Thread Alexey Loubyansky
What JBoss version exactly are you using? 3.2.2RC5?
Could you post the exact code that fails?
Thanks,

alex

Jason Essington wrote:

I have some code that worked just fine in 3.2.1 but now it is having  
trouble in the 3.2.2 branch of JBoss.

I am getting an SQLException when I try to remove an entity that has a  
1-m cascade delete relationship.

The code I am using first gets a collection of entities via a finder  
then iterates over the collection calling .remove() on each entity  
something like:

for (Iterator i = mtmRecords.iterator(); i.hasNext();)
{
FXMarkToMarketLocal record = (FXMarkToMarketLocal) i.next();
try
{
if (record != null)
{
if (log.isDebugEnabled())
log.debug(\nRemoving Mark to Market record +  
record.getRid().toString()+\n);
record.remove();
}
}
catch (RemoveException e)
{
log.warn(Unable to remove an old mark to market record., e);
}
}

JBoss seems to go ahead and disassociate the related entities then  
delete the entity and it's related entities (which are to be cascaded)  
just fine, but when this is complete, it tries to issue the following  
SQL statement:

SELECT rid,  FROM tfxmtm WHERE (rid=?) OR (rid=?) OR (rid=?) OR (rid=?)  
OR (rid=?) OR (rid=?) OR (rid=?) OR (rid=?) OR (rid=?) OR (rid=?) OR  
(rid=?)

This statement appears to be missing all of its CMP fields (minus the  
pk field), and is not valid sql. This causes the exception shown below.

Is there something I am doing that is no longer allowed in 3.2.2? Or is  
this just a bug?

java.sql.SQLException: ERROR:  parser: parse error at or near FROM at  
character 14

at  
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
at  
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connec 
tion.java:505)
at  
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Stateme 
nt.java:320)
at  
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme 
nt.java:48)
at  
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1St 
atement.java:153)
at  
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(Wr 
appedPreparedStatement.java:302)
at  
org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEnt 
ityCommand.java:158)
at  
org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEnt 
ityCommand.java:76)
at  
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadEntity(JDBCStoreMana 
ger.java:577)
at  
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadEntity(JDBCStoreMana 
ger.java:559)
at  
org.jboss.ejb.plugins.CMPPersistenceManager.loadEntity(CMPPersistenceMan 
ager.java:381)
at  
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.loadEnt 
ity(CachedConnectionInterceptor.java:352)
at  
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntitySync 
hronizationInterceptor.java:239)
at  
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke( 
CachedConnectionInterceptor.java:185)
at  
org.jboss.ejb.plugins.EntityReentranceInterceptor.invoke(EntityReentranc 
eInterceptor.java:114)
at  
org.jboss.ejb.plugins.EntityMultiInstanceInterceptor.invoke(EntityMultiI 
nstanceInterceptor.java:108)
at  
org.jboss.ejb.plugins.EntityLockInterceptor.invoke(EntityLockInterceptor 
.java:89)
at  
org.jboss.ejb.plugins.EntityCreationInterceptor.invoke(EntityCreationInt 
erceptor.java:54)
at  
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterce 
ptor.java:84)
at  
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptor 
CMT.java:267)
at  
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128)
at  
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.jav 
a:118)
at  
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
at  
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryF 
inderInterceptor.java:122)
at  
org.jboss.ejb.EntityContainer.internalInvoke(EntityContainer.java:490)
at org.jboss.ejb.Container.invoke(Container.java:700)
at  
org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyF 
actory.java:375)
at  
org.jboss.ejb.plugins.local.EntityProxy.invoke(EntityProxy.java:38)
at $Proxy399.getRid(Unknown Source)
at  
com.grcs.hedgehog.close.ejb.session.DetailSelectionBean.closeCurrentPeri 
od(DetailSelectionBean.java:174)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at  
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav 
a:39)
at  
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor 
Impl.java:25)
at 

Re: [JBoss-user] Problems with HTTP invoker

2003-10-07 Thread Adrian Brock

org.jboss.invocation.jrmp.interfaces.JRMPInvokerProxyHA.invoke(JRMPInvokerProxyHA.java:291)

This is HA RMI. 

What does your jboss.xml look like for this bean?
Does it have an invoker binding for https?
Did you lookup the correct jndi name?

Regards,
Adrian

On Tue, 2003-10-07 at 19:34, Bob Cotton wrote:
 JBoss 3.2.1
 Apache 1.3 w/ mod_jk
 
 Apache has mod_jk a list of workers configured as an 'lb' worker,
 against a list of jboss servers all running tomcat with mod_jk.
 
 Apache is installed on machine a, and the http invoker (in jboss ) is
 installed on machine b. The http invoker is accessed through mod_jk.
 
 we have the following in our service-bindings files:
 
 service-config name=jboss:service=invoker,type=http
   delegateClass=org.jboss.services.binding.AttributeMappingDelegate
   delegate-config
 attribute 
 name=InvokerURLhttp://wstest01-gsjthree/invoker/EJBInvokerServlet/attribute
   /delegate-config
   binding/
 /service-config
 
 service-config name=jboss:service=invoker,type=httpHA
   delegateClass=org.jboss.services.binding.AttributeMappingDelegate
   delegate-config
 attribute 
 name=InvokerURLhttp://wstest01-gsjthree/invoker/EJBInvokerHAServlet/attribute
   /delegate-config
   binding/
 /service-config
 
 service-config name=jboss:service=invoker,type=http,target=Naming
   delegateClass=org.jboss.services.binding.AttributeMappingDelegate
   delegate-config
 attribute 
 name=InvokerURLhttp://wstest01-gsjthree/invoker/JMXInvokerServlet/attribute
   /delegate-config
   binding/
 /service-config
 
 service-config 
 name=jboss:service=invoker,type=http,target=Naming,readonly=true
   delegateClass=org.jboss.services.binding.AttributeMappingDelegate
   delegate-config
 attribute 
 name=InvokerURLhttp://wstest01-gsjthree/invoker/JMXInvokerServlet/attribute
   /delegate-config
   binding/
 /service-config
 
 
 In our test system, everything works great. 
 
 When we set this up in production, with the only change being the
 InvokerURL starting with https, I get the following stack:
 
 java.rmi.RemoteException: Service unavailable.
 at 
 org.jboss.invocation.jrmp.interfaces.JRMPInvokerProxyHA.invoke(JRMPInvokerProxyHA.java:291)
 at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:87)
 at 
 org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
 at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45)
 at org.jboss.proxy.ejb.HomeInterceptor.invoke(HomeInterceptor.java:173)
 at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
 at $Proxy2.create(Unknown Source)
 at 
 com.synxis.srms.ejbs.util.ServicesLocator.getStatelessSessionRemote(ServicesLocator.java:126)
 at 
 com.synxis.srms.ejbs.login.SrmsAuthServiceRemoteManager.reconnect(SrmsAuthServiceRemoteManager.java:101)
 at 
 com.synxis.srms.ejbs.login.SrmsAuthServiceRemoteManager.login(SrmsAuthServiceRemoteManager.java:163)
 
 This is on ejbcreate. The home lookup works.
 
 Ideas?
 
 Thanks 
 -Bob
-- 
 
Adrian Brock
Director of Support
Back Office
JBoss Group, LLC 
 



---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


RE: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-07 Thread Adrian Brock
On Tue, 2003-10-07 at 19:37, Comtois, Pierre wrote:
 Finally resolved the exception issue:
 
 1. I created the tables manually and for my appl. Made them of type InnoDB
 

What is the sql for InnoDB, I would like to include a version in
docs/examples/jca

 2. I gave SELECT permission to my user to the mysql database so it could
 access its permission table. I'm a novice at MySql as well so I might have
 messed that up myself :-)
 

Doesn't a user get this right for tables they create?

 3. I had put my computer name in the mysql-ds connection-url attribute ... I
 put it back to localhost
 
 ps: I would have thought that it would be better to specify a computer name
 as opposed to localhost ... ?
 
 
 Next item up for bid ... I want to access the newly configured DB using the
 JBoss console ( http://localhost:8080/jmx-console/index.jsp ). Seems that
 now I have no link in jmx-console to access the Hypwersonic service ... The
 link to it is gone ...

It will be in the jboss.jca section.
If you didn't deploy hsqldb-ds.xml, of course you won't see it on the
console.

Regards,
Adrian

 Is this normal ? Am I missing something ? My thought is that I have to
 configures the jmx ...
 
 Looking at displayMBeans.jsp, that the mbean is missing in the MBeanData
 array ...
 %
   MBeanData[] data = domainData.getData();
   for(int d = 0; d  data.length; d ++)
   {
  String name = data[d].getObjectName().toString();
  String properties = data[d].getNameProperties();
 %
   lia href=HtmlAdaptor?action=inspectMBeanname=%=
 URLEncoder.encode(name) %%= URLDecoder.decode(properties) %/a/li
 %
 
 
 Ideas ?
 
 Pierre Comtois
 Business Acceleration Services, Solutions Consulting 
 45 O'Connor Street, Suite 500*Ottawa, Ontario K1P 1A4
 Ph: 613-787-4649  *  FAX: 613-567-6053  *  E-Mail:  [EMAIL PROTECTED]
 
 
 
 
 -Original Message-
 From: Adrian Brock [mailto:[EMAIL PROTECTED] 
 Sent: October 7, 2003 11:01 AM
 To: [EMAIL PROTECTED]
 Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS
 
 
 Some guy had the same problem last week and resolved it, 
 but he seems to have vanished from this list when somebody
 else has a problem. :-(
 
 On Tue, 2003-10-07 at 15:34, Comtois, Pierre wrote:
  Making progress ... but ever s-o-o-o-o slowly !
  
  It would seem that the persistence tables specified by the 
  mysql-jdbc2-service.xml file are not getting creating resulting in 
  connection errors on startup. I found nothing in the archives that 
  helped ...
  
CREATE_MESSAGE_TABLE = CREATE TABLE JMS_MESSAGES (MESSAGEID 
  INTEGER NOT NULL, DESTINATION VARCHAR(150) NOT NULL, TXID INTEGER, 
  TXOP CHAR(1), MESSAGEBLOB BLOB, PRIMARY KEY (MESSAGEID, DESTINATION))
CREATE_TX_TABLE = CREATE TABLE JMS_TRANSACTIONS (TXID INTEGER)
CREATE_TABLES_ON_STARTUP = TRUE
  
  What could be preventing these from getting created ... I've now 
  changed user temporarily to root to remove authorization issues from 
  the equation. If I have to, I'll create them by hand, but this likely 
  indicates another problem.
  
 
 Please wait... I'm trying to hack your machine so I can see the error
 message. :-)
 
  P.S. Is there an up-to-date document anywhere that details how to 
  integrate MySQL 4.x with JBOSS 3.2.2RC4? I've found stuff with Google 
  but haven't found anything up-to-date and accurate. I'm setting up a 
  pc with around 12 different development modules/tools and this piece 
  is taking much more time than it should/can afford to get going on the 
  actual development phase. Maybe what I want to do is a rarity, but I 
  don't think it is. A short white paper would cost cycles initially, 
  but would likely pay off over the long haul.
  
 
 Remove mysql-jdbc2.xml and use the file version.
 Come back to it when you are sure mysql works.
 
 I'm currently preparing an enhanced jbossmq section for the admin docs with
 the 3.2.2 release.
 
 Regards,
 Adrian
 
  
  Pierre Comtois
  Business Acceleration Services, Solutions Consulting 
  45 O'Connor Street, Suite 500*Ottawa, Ontario K1P 1A4
  Ph: 613-787-4649  *  FAX: 613-567-6053  *  E-Mail:  
  [EMAIL PROTECTED]
  
  
  
  
  -Original Message-
  From: Adrian Brock [mailto:[EMAIL PROTECTED]
  Sent: October 6, 2003 7:40 PM
  To: [EMAIL PROTECTED]
  Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS
  
  
  On Mon, 2003-10-06 at 22:23, Comtois, Pierre wrote:
   Default install puts it in  ... It's dated June 10/2003 ...
   
  
  Ok, so you are using 3.2.1?
  
  Copy the SQL Properties from the mysql-jdbc2-service.xml
  into jbossmq-service.xml - replacing the hsqldb sql properties.
  
  Where is the difficulty?
  There is an MBean called the PersistenceManager that
  takes a parameter called SQLProperties.
  By default it references DefaultDS and uses hsqldb sql.
  You need to change it to match your jndi name and mysql sql statements.
  
  It is harder with 3.2.1
  
  With 3.2.2 it will be to 

RE: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-07 Thread Michael Klem
At 9:24 PM +0100 10/7/03, Adrian Brock wrote:
On Tue, 2003-10-07 at 19:37, Comtois, Pierre wrote:
 Finally resolved the exception issue:

 1. I created the tables manually and for my appl. Made them of type InnoDB

From MySQL version 4.0, InnoDB is enabled by default. So sql used to 
create a db table will default to being an InnoDB table. To 
explicitly create a table as InnoDB do this:
  CREATE TABLE CUSTOMER (A INT, B CHAR (20), INDEX (A)) TYPE = InnoDB;

To see the type of a table use this:
  SHOW TABLE STATUS FROM test LIKE 'CUSTOMER'
More info can be found here:
http://www.mysql.com/doc/en/Using_InnoDB_tables.html
http://www.mysql.com/doc/en/InnoDB_in_MySQL_3.23.html
http://www.mysql.com/doc/en/InnoDB_start.html
What is the sql for InnoDB, I would like to include a version in
docs/examples/jca
 2. I gave SELECT permission to my user to the mysql database so it could
 access its permission table. I'm a novice at MySql as well so I might have
 messed that up myself :-)
Doesn't a user get this right for tables they create?

 3. I had put my computer name in the mysql-ds connection-url attribute ... I
 put it back to localhost
 ps: I would have thought that it would be better to specify a computer name
 as opposed to localhost ... ?
 Next item up for bid ... I want to access the newly configured DB using the
 JBoss console ( http://localhost:8080/jmx-console/index.jsp ). Seems that
 now I have no link in jmx-console to access the Hypwersonic service ... The
 link to it is gone ...
It will be in the jboss.jca section.
If you didn't deploy hsqldb-ds.xml, of course you won't see it on the
console.
Regards,
Adrian
 Is this normal ? Am I missing something ? My thought is that I have to
 configures the jmx ...
 Looking at displayMBeans.jsp, that the mbean is missing in the MBeanData
 array ...
 %
   MBeanData[] data = domainData.getData();
   for(int d = 0; d  data.length; d ++)
   {
  String name = data[d].getObjectName().toString();
  String properties = data[d].getNameProperties();
 %
   lia href=HtmlAdaptor?action=inspectMBeanname=%=
 URLEncoder.encode(name) %%= URLDecoder.decode(properties) %/a/li
 %
 Ideas ?

 Pierre Comtois
 Business Acceleration Services, Solutions Consulting
 45 O'Connor Street, Suite 500*Ottawa, Ontario K1P 1A4
 Ph: 613-787-4649  *  FAX: 613-567-6053  *  E-Mail:  [EMAIL PROTECTED]
 
 
 -Original Message-
 From: Adrian Brock [mailto:[EMAIL PROTECTED]
 Sent: October 7, 2003 11:01 AM
 To: [EMAIL PROTECTED]
 Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS
 Some guy had the same problem last week and resolved it,
  but he seems to have vanished from this list when somebody
 else has a problem. :-(

 On Tue, 2003-10-07 at 15:34, Comtois, Pierre wrote:
  Making progress ... but ever s-o-o-o-o slowly !
 
  It would seem that the persistence tables specified by the
  mysql-jdbc2-service.xml file are not getting creating resulting in
  connection errors on startup. I found nothing in the archives that
  helped ...
 
CREATE_MESSAGE_TABLE = CREATE TABLE JMS_MESSAGES (MESSAGEID
  INTEGER NOT NULL, DESTINATION VARCHAR(150) NOT NULL, TXID INTEGER,
  TXOP CHAR(1), MESSAGEBLOB BLOB, PRIMARY KEY (MESSAGEID, DESTINATION))
CREATE_TX_TABLE = CREATE TABLE JMS_TRANSACTIONS (TXID INTEGER)
CREATE_TABLES_ON_STARTUP = TRUE
 
  What could be preventing these from getting created ... I've now
  changed user temporarily to root to remove authorization issues from
  the equation. If I have to, I'll create them by hand, but this likely
  indicates another problem.
 
 Please wait... I'm trying to hack your machine so I can see the error
 message. :-)
  P.S. Is there an up-to-date document anywhere that details how to
   integrate MySQL 4.x with JBOSS 3.2.2RC4? I've found stuff with Google
  but haven't found anything up-to-date and accurate. I'm setting up a
  pc with around 12 different development modules/tools and this piece
  is taking much more time than it should/can afford to get going on the
  actual development phase. Maybe what I want to do is a rarity, but I
  don't think it is. A short white paper would cost cycles initially,
  but would likely pay off over the long haul.
 
 Remove mysql-jdbc2.xml and use the file version.
 Come back to it when you are sure mysql works.
 I'm currently preparing an enhanced jbossmq section for the admin docs with
 the 3.2.2 release.
 Regards,
 Adrian
 
  Pierre Comtois
  Business Acceleration Services, Solutions Consulting
  45 O'Connor Street, Suite 500*Ottawa, Ontario K1P 1A4
  Ph: 613-787-4649  *  FAX: 613-567-6053  *  E-Mail: 
  [EMAIL PROTECTED]
  
  
 
 
  -Original Message-
  From: Adrian Brock [mailto:[EMAIL PROTECTED]
  Sent: October 6, 2003 7:40 PM
  To: [EMAIL PROTECTED]
  Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS
 
 
  On Mon, 2003-10-06 at 22:23, Comtois, Pierre wrote:
   Default install puts it in  ... It's dated June 10/2003 

Re: [JBoss-user] Problems with HTTP invoker

2003-10-07 Thread Bob Cotton
Adrian Brock [EMAIL PROTECTED] writes:


 org.jboss.invocation.jrmp.interfaces.JRMPInvokerProxyHA.invoke(JRMPInvokerProxyHA.java:291)

 This is HA RMI. 
 Did you lookup the correct jndi name?

DUH. Thanks
 -Bob

-- 
SynXis Corporation  | [EMAIL PROTECTED]| no .sig today.
1610 Wynkoop, Suite 400 | Ph: (303)595-2511 | 
Denver, CO  80202   | Fax:(303)534-4257 | 



---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


Re: [JBoss-user] JNDI names for session and entity beans?

2003-10-07 Thread Adrian Brock
Are you talking about jsr77 and the web-console?
This was fixed in 3.2.2RC1

Regards,
Adrian

On Tue, 2003-10-07 at 19:18, Steven Harris wrote:
 I've got local entity beans and remote stateless session beans, with JNDI
 names defined in jboss.xml. Jboss seems to use the ejb-name as the JNDI
 name of my local entity beans and the jndi-name as the JNDI name of my
 stateless session beans. For example:
 
 From ejb.jar
 --
 
 session
 ejb-nameAssociationSvcEJB/ejb-name
 homecom.pfn.wirepower.srv.service.associationSvc.AssociationSvcHome/home
 remotecom.pfn.wirepower.srv.service.associationSvc.AssociationSvc/remote
 ejb-classcom.pfn.wirepower.srv.service.associationSvc.impl.AssociationSvcB
 ean/ejb-class
 session-typeStateless/session-type
 transaction-typeBean/transaction-type
 ..etc
 /session
 
 entity
 ejb-nameSiteEJB/ejb-name
 local-homecom.pfn.wirepower.srv.persistence.site.SiteLocalHome/local-home
 
 localcom.pfn.wirepower.srv.persistence.site.SiteLocal/local
 ejb-classcom.pfn.wirepower.srv.persistence.site.impl.SiteBean/ejb-class
 persistence-typeContainer/persistence-type
 prim-key-classjava.lang.Integer/prim-key-class
 ..etc
 /entity
 
 
 From JBoss.xml
 ---
 session
   ejb-nameAssociationSvcEJB/ejb-name
   jndi-nameAssociationSvcHome/jndi-name
 /session
 
 entity
   ejb-nameSiteEJB/ejb-name
   jndi-nameSiteLocalHome/jndi-name
 /entity
 
 The JBoss console shows the jndiName=AssociationSvcHome and
 jndiName=SiteEjb. Referencing them programatically from an MBean confirms
 this. 
 
 
 ---
 This sf.net email is sponsored by:ThinkGeek
 Welcome to geek heaven.
 http://thinkgeek.com/sf
 ___
 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:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


RE: [JBoss-user] value object challenge

2003-10-07 Thread JD Brennan
Change your method to:

public MeetingDateValueOBject update(ProtectionMap map,
 MeetingDateValueObject vo) 
{
   ...
   return vo;
}

In the same VM you can take advantage of the side-effect to
the argument.  But remotely RMI only returns the return value
over the wire, so any side-effects to arguments are lost.

I think a good rule of thumb is to return the modified object
and not to rely on side-effects.

JD

-Original Message-
From: Frank Morton [mailto:[EMAIL PROTECTED]
Sent: Monday, October 06, 2003 9:18 PM
To: [EMAIL PROTECTED]
Subject: [JBoss-user] value object challenge


Using 3.2.2RC4. Same problem under redhat linux and macos X. Note later 
I explain
that this behaves differently with the client running in the same jvm 
vs. running in
a different jvm.

In a value object class (MeetingDateValueObject), I do the following:

 MeetingDateValue meetingDateValue = Factory.getMeetingDateValue();
 System.err.println(DEBUG: MeetingDateValueObject.update() id value 
before:  + getId());
 boolean temp =  meetingDateValue.update(protectionMap,this);
 System.err.println(DEBUG: MeetingDateValueObject.update() id value 
after:  + getId());

meetingDateValue is a stateless session bean. id is a property of the 
value object
and the primary key of the underlying entity bean. the update method 
is supposed to
set the id value, but getId() returns null before and after the 
update.

In the called session bean, I do the following (it is a facade for the 
entity bean):

 public boolean update(ProtectionMap 
protectionMap,MeetingDateValueObject meetingDateValueObject) {
  MeetingDateHome meetingDateHome = Factory.getMeetingDateHome();
  System.err.println(DEBUG: meeting date value object id before:  
+ meetingDateValueObject.getId());
  meetingDateHome.create(meetingDateValueObject);
  System.err.println(DEBUG: meeting date value object id before:  
+ meetingDateValueObject.getId());
  return(true);
 }

MeetingDateHome is an entity bean. The first debug message indicates 
that the id
property in the passed value object is null, which is correct. The 
second debug message
returns an accurate number, reflecting that the entity bean is properly 
setting the
value of id in the value object.

So, given that the entity bean exits with the value object id 
property having an accurate
value, why does the second debug message in the session bean still 
return a null
value for the id property?

An important consideration here is that this only happens if the client 
calling the session
bean is running in a different JVM. If they are running in the same 
JVM, the value in
the second debug message of the session bean is set accurately.

Will appreciate any insight.



---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] Re:JBoss-usernbsp;digest,nbsp;Volnbsp;1nbsp;#5145nbsp;-nbsp;9nbsp;msgs

2003-10-07 Thread forge
Much Thanks.



I tried jboss3.2.2 and opentool2.5 and they work well now.



Another problem:

I developed an EAR by WSAD5 and it run well on WAS5.0.

Can I deployed the EAR directly on jboss and don't change anything?

Does anyone have experience on it?



Regards,

Forge



Message: 9

From: Edgar Silva [EMAIL PROTECTED]

To: [EMAIL PROTECTED]

Date: Tue, 07 Oct 2003 12:27:46 GMT

Subject: [JBoss-user] Re: problem in jbuilder7+jboss3.2.1

Reply-To: [EMAIL PROTECTED]



Hi Forge... 





There are some problems in this OpenTool, for example, some changes in the 

project like DataSources name, it doesn't reflect in jbosscmp-jdbc.xml, and


you have to apply it by your own hands. 



It is bad, but is the best way to work with this enviroment, working with 

JBuilder's EJB-Designer. It´s very nice feature from JBuilder to draw 

visually your EJB´s, then some changes by hands in the jbosscmp-jdbc will be


simple...It is a good  change: Simple way to do EJB´s by To Correct 

something in the jbosscmp... =) 



Have enumerous opentools at codecentral.borland.com , where you can find 

good toys. 



I think you can find new version from this JBossOpenTool in the url above. 



best regards 



Edgar Silva 





forge escreveu: 



 Hello, everyone 

 

  

 

 I'm using jbuilder7 + jboss 3.2.1 developing an EJB project. 

 

 It need a jbossopentool.jar as plugin of jbuilder and I downloaded one, 

 

 but it doesn't work well. I can't find JBOSSCMP-JDBC page in JB7. 

 

  

 

 Does anyone know where I can download a jbossopentool.jar for my enviro? 

 

  

 

 Thanks. 

 

 Forge 

 

  

 

  

 

  

 

  

 

 

 --http://www.eyou.com

 --Îȶ¨¿É¿¿µÄÃâ·Ñµç×ÓÐÅÏä  ÓïÒôÓʼþ  Òƶ¯ÊéÇ©  ÈÕÀú·þÎñ  ÍøÂç´æ´¢...ÒÚÓÊδ¾¡


 

  

 

 

 ---

 This sf.net email is sponsored by:ThinkGeek

 Welcome to geek heaven.

 http://thinkgeek.com/sf

 ___

 JBoss-user mailing list

 [EMAIL PROTECTED]

 https://lists.sourceforge.net/lists/listinfo/jboss-user

 





Edgar A Silva

Diretor Técnico

Argos Tecnologia Ltda.

Borland Learning  Solutions Partner

(55 91)222.6578 - Belém/Pa - Brasil 






=

PLATAFORMA JAVA : UM COMPROMISSO DA ARGOS! 



# Pioneira no desenvolvimento de soluções Java na região norte;

# Fundadora e patrocinadora do BelJUG - Belém Java Users Group;

# Equipe composta de profissionais com certificações Borland e Sun;

# Maior formadora de profissionais Java da região;

# Parcerias Estratégicas: Borland(Produtos Java) e Summa(Serviços Java); 



Solicite-nos uma visita e descubra porque as principais empresas da

região confiam a nós sua solução Java. 



www.argostecnologia.com 






= 









--__--__--



___

JBoss-user mailing list

[EMAIL PROTECTED]

https://lists.sourceforge.net/lists/listinfo/jboss-user





End of JBoss-user Digest

 





--http://www.eyou.com
--Îȶ¨¿É¿¿µÄÃâ·Ñµç×ÓÐÅÏä  ÓïÒôÓʼþ  Òƶ¯ÊéÇ©  ÈÕÀú·þÎñ  ÍøÂç´æ´¢...ÒÚÓÊδ¾¡




---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


Re: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-07 Thread Michael Klem
Forgot to mention, my interpretation of what the docs said is that 
you no longer need to specify a table type. MySQL will treat the 
tables as InnoDB tables as a default.

Just my .02

At 9:50 PM -0700 10/7/03, Michael Klem wrote:
Just quoting from the MySQL docs. I will verify for myself too. I am 
using 4.0.14

At 9:12 PM -0400 10/7/03, Guy Rouillier wrote:
Michael Klem wrote:
 From MySQL version 4.0, InnoDB is enabled by default. So sql used 
to create a db table will default to being an InnoDB table. To 
explicitly create a table as InnoDB do this:
  CREATE TABLE CUSTOMER (A INT, B CHAR (20), INDEX (A)) TYPE = InnoDB;
That has not been my experience.  I have MySQL 4 on both Windows 
2000 and Linux, and if I don't specify a type, tables end up as 
MyISAM.
--
Guy Rouillier



---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


--
 Michael Klem [EMAIL PROTECTED]626-296-3027
---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


--
 Michael Klem [EMAIL PROTECTED]626-296-3027
---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user