ebxmlms-general — General discussions

Re: [ebxmlms-general] Out of memory error in the MSH monitor

[David W. \(XML\) <da...@dr...>]

Mattias,

The patches and fixes to allow sending of any size message (we tested up =
to 150MB) are in the source code ZIP downloadable from:

 http://ebxmlbook.com/interop/=20

Included in that is the fixes to the error in the mimetype handling that =
corrupts the first 16 bytes of a binary file.

I'm not sure if any of these corrections made it into the main trunk =
codebase.

Basically you need these fixes to send files larger than 10Mb.

DW

  ----- Original Message -----=20
  From: Mattias J=20
  To: ebx...@li...=20
  Sent: Thursday, July 21, 2005 7:37 AM
  Subject: Re: [ebxmlms-general] Out of memory error in the MSH monitor


  At 2005-07-21 12:48, you wrote:

    When I repeatedly sent a message with one attachment of size 600KB =
100 times from the MSH monitor in one Windows PC (call it A) to the MSH =
monitor in another Windows PC (call it B), the monitor in B showed the =
java.lang.OutOfMemoryError after displaying the first 66 messages =
received in the "Receive History" (the remaining 34 messages could be =
displayed after OutOfMemoryError occurred), while the monitor in A =
revealed all 100 messages sent with the state "Sent and Acknowledgement =
Received" when right-clicking the messages in the "Sent History" in A.=20

    The OutOfMemoryError still occurred until the MSH monitor in B was =
restarted.  Right after the restart, the remaining 34 messages were =
displayed in the "Receive History".=20

    The default MaxPayloadSize (1000000) in msh_client.properties.xml is =
used. PC A has 512MB RAM and paging file size allocated is 768MB, while =
PC B has 768MB RAM and paging file size allocated is 1152MB.

  Well, how much memory did you assign to the JVM?
  Check out -Xmn, -Xms and -Xmx

Re: [ebxmlms-general] Out of memory error in the MSH monitor

[David W. \(XML\) <da...@dr...>]

See patches available from http://ebxmlbook.com/interop ZIP file - to =
correct problems with binary attachment handling in Hermes.

DW
  ----- Original Message -----=20
  From: em...@og...=20
  To: ebx...@li...=20
  Sent: Thursday, July 21, 2005 6:48 AM
  Subject: [ebxmlms-general] Out of memory error in the MSH monitor



  When I repeatedly sent a message with one attachment of size 600KB 100 =
times from the MSH monitor in one Windows PC (call it A) to the MSH =
monitor in another Windows PC (call it B), the monitor in B showed the =
java.lang.OutOfMemoryError after displaying the first 66 messages =
received in the "Receive History" (the remaining 34 messages could be =
displayed after OutOfMemoryError occurred), while the monitor in A =
revealed all 100 messages sent with the state "Sent and Acknowledgement =
Received" when right-clicking the messages in the "Sent History" in A.=20

  The OutOfMemoryError still occurred until the MSH monitor in B was =
restarted.  Right after the restart, the remaining 34 messages were =
displayed in the "Receive History".=20

  The default MaxPayloadSize (1000000) in msh_client.properties.xml is =
used. PC A has 512MB RAM and paging file size allocated is 768MB, while =
PC B has 768MB RAM and paging file size allocated is 1152MB.=20

  I have some questions based on the above incident:=20

  1. Although PC B did not reveals all messages, PC A reveals that all =
mesages "Sent and Acknowledgement Received", I wonder whether PC B =
successfully receive all 100 messages?=20
  2. Any recommendation on the hardware requirements on running Hermes, =
especially a large volume of messages need to be processed?=20
  3. Although PC B has more RAM and virtual memory than PC A, but the =
out of memory error did not occur in A. Is there any difference in the =
memory or other hardware requirement for sending messages and receiving =
messages.=20
  4. Any other experience sharing is welcomed.=20


  Regards,=20
  MC

Re: [ebxmlms-general] Connectionpooling and transactions

[Ronald v. K. <rtv...@xs...>]

Patrick,

I'm totally aware of the security reasons, but for the other changes it i=
s easier to split it
first. I can allways make innerclasses of it afterwards. But on the other=
 hand, I'd solve the
security issue by using a java.policy file. Isn't that what is was for or=
iginally? Not many
developers know it and try to solve it in another way. One can even sign =
all hermes classes and
have the important ones only be accessed by code that is also signed. Thi=
s keeps the classes much
more clean imo.

Ronald

Patrick Yee probeerde me het volgende duidelijk te maken:
> Sorry for late reply. It is really nice to know the progress. Regarding
> the inner classes, I think there are various reasons for having them.
> Some are for package security, so that only the nested classes can
> access them. Also there are some being created just for convenience.
>
> Regards,
> Patrick Yee
> Center for E-Commerce Infrastructure Development
>
> Making E-Commerce Everyday Commerce
>
>
>
> Ronald van Kuijk wrote:
>
>>Hi Patrick,
>>
>>Great to hear. I'm already going fairly good. There is a lot of refacto=
ring I'd like to do. I was
>>not confident before but now I've heard this, I'll go for it for sure.
>>
>>Since all servlet engines also support JMX at the moment, I'd like to c=
onvert the real commands
>> to
>>an MBean (stop, resume, backup, getStatus etc...) and have main servlet=
 just for receiving
>>messages from other MHS, either by http or by starting another monitor =
for smtp. Getting messages
>>to the MHS from a businessprocess can go through other 'monitors' (we d=
iscussed naming these
>>something else before, but I lost this conversation) Configurable (http=
, jms, ejb, ...) and
>>possibly also as a JBI SPI (would be nice, connecting hermes to a stand=
ard ESB right...?)
>>
>>One question I have is why there are so many innner classes? Is this be=
cause of security reasons
>>so they cannot be accessed from outside?
>>
>>I'll keep you guys posted.
>>
>>Ronald
>>
>>Patrick Yee probeerde me het volgende duidelijk te maken:
>>
>>
>>>By the time we were designing Hermes, Hibernate is not that well
>>>considered... (yes, the other way to interpret this is, we are quite
>>>closed in terms of employing other libraries). I think your opinion is=
 a
>>>good one.
>>>
>>>Regards,
>>>Patrick Yee
>>>Center for E-Commerce Infrastructure Development
>>>
>>>Making E-Commerce Everyday Commerce
>>>
>>>
>>>
>>>R. van Kuijk (Ronald) wrote:
>>>
>>>
>>>
>>>>Hmm... I missed the option to redirect file persistence to a database=
. I'll have a look. With
>>>>'still it is not transaction-aware' you mean that the filepersistence=
 is not really transaction
>>>>aware? There are some 'in vm-locking mechamisms' in there but no real=
 commit/rollback etc.
>>>> Would
>>>>that be needed? Kind of difficult, but I'll see.
>>>>
>>>>Ok, another question. I have a fairly clear picture of the front-end =
messageserver,
>>>>messageservicehandler etc and how the command parsing works. In addit=
ion to that, I dug a
>>>> little
>>>>bit deeper into hermes again especially the DBTableManager classes et=
c. If it is possible I'd
>>>>like to get some info on the architectural choices that were made to =
come to such a solution.
>>>> It
>>>>looks like it is some persistence mapping, for which there currently =
are very nice
>>>> out-of-the-box
>>>>solutions (think hibernate). IMVVHO (it is a very, very humble one) t=
his would also be a nice
>>>>change and would make it possible to support more databases.
>>>>
>>>>I'll try to work something out which makes it possible to store messa=
ges in either a file or a
>>>>database (configurable?)
>>>>
>>>>
>>>>-----Oorspronkelijk bericht-----
>>>>Van: ebx...@li...
>>>>[mailto:ebx...@li...] Namens Patrick Y=
ee
>>>>Verzonden: woensdag 6 juli 2005 4:02
>>>>Aan: ebx...@li...
>>>>Onderwerp: Re: [ebxmlms-general] Connectionpooling and transactions. =
was: Problems after lost
>>>>connection to database
>>>>
>>>>Now, Hermes supports a custom way (API) to redirect the file persiste=
nce
>>>>to database. However, still it is not transaction-aware. So we may ne=
ed
>>>>to modify that API as well. What do you think?
>>>>Regards, -Patrick
>>>>
>>>>
>>>>Ronald van Kuijk wrote:
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>>Sounds interesting. But with regard to this immediately a second que=
stion comes to mind. There
>>>>>is
>>>>>also a transactionmechanism in place which does a kind of xa over a =
database and a filesystem.
>>>>>This makes it almost impossible to use the default JTA for this, whi=
ch would make the hermes
>>>>>core
>>>>>even smaller. For our company, storing the messages in a DB as a blo=
b is not a problem since
>>>>> we
>>>>>require clustering and failover any way. It is in fact even a requir=
ement unless there would
>>>>> be
>>>>>a
>>>>>JTA compatible filesystem persistency layer (JCA?)).
>>>>>
>>>>>Replacing the DBConnectionPool with a standard based solution can be=
 done by me, since I've
>>>>> done
>>>>>it before and probably have the code somewhere. DBCP does not have t=
o be provided then, since
>>>>>all
>>>>>servlet engines and j2ee servers contain one. But regarding the file=
 persistency I'd like to
>>>>> get
>>>>>a
>>>>>response from more users since that is another issue.
>>>>>
>>>>>Comments?
>>>>>
>>>>>
>>>>>Patrick Yee probeerde me het volgende duidelijk te maken:
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>>There is no strict reason for using our own implementation. So it w=
ould
>>>>>>be good to have some contribution to port Hermes to make use of oth=
er
>>>>>>database pool, like DBCP.
>>>>>>Regards, -Patrick
>>>>>>
>>>>>>Regards, -Patrick
>>>>>>
>>>>>>
>>>>>>Mattias J wrote:
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>>Yes, why not include for example Jakarta Commons DBCP?
>>>>>>>
>>>>>>>At 2005-06-27 09:29, you wrote:
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>>I guess the problem is that you have implemented your own
>>>>>>>>databasepool, without sophisticated recovery mechanism.
>>>>>>>>Our own application use javax.sql.DataSource, to get a connection=
. I
>>>>>>>>guess there is a recovery mechanism in that solution, as our own
>>>>>>>>application runs fine when the connection gets back.
>>>>>>>>Is there anyway to use javax.sql.DataSource instead of your
>>>>>>>>implementation of the connection pool? I guess my question is mor=
e to
>>>>>>>>why you are using your own implemtation, are you using some extra
>>>>>>>>stuff, I can't get from javax.sql.DataSource?
>>>>>>>>
>>>>>>>>Regards Kenneth
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>>From: Patrick Yee <kc...@ce...>
>>>>>>>>>To: ebx...@li...
>>>>>>>>>CC: tr...@ho...
>>>>>>>>>Subject: Re: [ebxmlms-general] Problems after lost connection to
>>>>>>>>>database
>>>>>>>>>Date: Sun, 26 Jun 2005 19:19:35 +0800
>>>>>>>>>
>>>>>>>>>We have not implemented a sophisticated recovery mechanism in th=
e
>>>>>>>>>database connection pool. The only mechanism we have done is,
>>>>>>>>>whenever a connection is proved to be bad, we will not put it ba=
ck
>>>>>>>>>to the connection pool. Actually there was a suggestion some tim=
e
>>>>>>>>>ago that we can do a "select *" on some tables before we use the
>>>>>>>>>pooled database connection. We think that will create certain
>>>>>>>>>performance issue, and so we shelved that idea. Of course, if yo=
u
>>>>>>>>>want it, you can just patch the database connection pool classes=
 and
>>>>>>>>>implement any advanced recovery mechanism as you like. :-)
>>>>>>>>>Regards, -Patrick
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>Kenneth Pedersen wrote:
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>>Hi
>>>>>>>>>>
>>>>>>>>>>If I loose the connection to my database for a short time
>>>>>>>>>>(1-2minutes), MSH do not operate properly afterwards.
>>>>>>>>>>
>>>>>>>>>>When the connection is lost this occurs in the MSH_client.log:
>>>>>>>>>>
>>>>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D>
>>>>>>>>>>DbConnectionPool.getConnection
>>>>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: <=3D
>>>>>>>>>>DbConnectionPool.getConnection
>>>>>>>>>>2005-06-21 09:13:34,384 ERROR [Thread-8]: [10002] Unknown error
>>>>>>>>>>Exception: java.sql.SQLException
>>>>>>>>>>Message: I/O Error: Connection reset by peer: socket write erro=
r
>>>>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D> Transaction.roll=
back
>>>>>>>>>>(txID: #2321)
>>>>>>>>>>2005-06-21 09:13:34,384 ERROR [Thread-8]: [10315] Cannot rollba=
ck
>>>>>>>>>>DB changes
>>>>>>>>>>Exception: java.sql.SQLException
>>>>>>>>>>Message: Invalid state, the Connection object is closed.
>>>>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D>
>>>>>>>>>>DbConnectionPool.freeConnection
>>>>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: <=3D
>>>>>>>>>>DbConnectionPool.freeConnection
>>>>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: <=3D Transaction.roll=
back
>>>>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D>
>>>>>>>>>>MessageServiceHandler.getNextUndeliveredMessage
>>>>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D>
>>>>>>>>>>MessageServer.getUndeliveredMessages
>>>>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D>
>>>>>>>>>>DbConnectionPool.getConnection
>>>>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D>
>>>>>>>>>>DbConnectionPool.createConnection
>>>>>>>>>>2005-06-21 09:13:35,352 ERROR [Thread-8]: [10306] Cannot create=
 DB
>>>>>>>>>>connection Exception: java.sql.SQLException Message: Network er=
ror
>>>>>>>>>>IOException: Connection refused: connect
>>>>>>>>>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: =3D> Transaction.roll=
back
>>>>>>>>>>(txID: #2323)
>>>>>>>>>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: <=3D Transaction.roll=
back
>>>>>>>>>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: =3D>
>>>>>>>>>>MessageServiceHandler.getNextUndeliveredMessage
>>>>>>>>>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: =3D>
>>>>>>>>>>MessageServer.getUndeliveredMessages
>>>>>>>>>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: =3D>
>>>>>>>>>>DbConnectionPool.getConnection
>>>>>>>>>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: =3D>
>>>>>>>>>>DbConnectionPool.createConnection
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>After the connection is restored MSH do not seem to get a prope=
r
>>>>>>>>>>connection.
>>>>>>>>>>This occurs then in the MSH_Client.log:
>>>>>>>>>>
>>>>>>>>>>2005-06-21 09:13:42,384 ERROR [Thread-8]: [10306] Cannot create=
 DB
>>>>>>>>>>connection
>>>>>>>>>>Exception: java.sql.SQLException Message: Network error
>>>>>>>>>>IOException: Connection refused: connect
>>>>>>>>>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: =3D> Transaction.roll=
back
>>>>>>>>>>(txID: #2338)
>>>>>>>>>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: <=3D Transaction.roll=
back
>>>>>>>>>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: =3D>
>>>>>>>>>>MessageServiceHandler.getNextUndeliveredMessage
>>>>>>>>>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: =3D>
>>>>>>>>>>MessageServer.getUndeliveredMessages
>>>>>>>>>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: =3D>
>>>>>>>>>>DbConnectionPool.getConnection
>>>>>>>>>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: =3D>
>>>>>>>>>>DbConnectionPool.createConnection
>>>>>>>>>>2005-06-21 09:13:43,384 ERROR [Thread-8]: [10306] Cannot create=
 DB
>>>>>>>>>>connection
>>>>>>>>>>Exception: java.sql.SQLException
>>>>>>>>>>Message: Network error IOException: Connection refused: connect
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>When i try to send a message through MSH i get this:
>>>>>>>>>>hk.hku.cecid.phoenix.message.handler.RequestException:
>>>>>>>>>>Failed to send query to MSH.
>>>>>>>>>>HTTP response code =3D 200
>>>>>>>>>>HTTP response message =3D OK
>>>>>>>>>>  at
>>>>>>>>>>hk.hku.cecid.phoenix.message.handler.Request.expectMapResponse(=
Unknown
>>>>>>>>>>Source)
>>>>>>>>>>  at
>>>>>>>>>>hk.hku.cecid.phoenix.message.handler.Request.sendMessageService=
HandlerConfig(Unknown
>>>>>>>>>>Source)
>>>>>>>>>>  at
>>>>>>>>>>hk.hku.cecid.phoenix.message.handler.Request.register(Unknown S=
ource)
>>>>>>>>>>  at hk.hku.cecid.phoenix.message.handler.Request.<init>(Unknow=
n
>>>>>>>>>>Source)
>>>>>>>>>>  at hk.hku.cecid.phoenix.message.handler.Request.<init>(Unknow=
n
>>>>>>>>>>Source)
>>>>>>>>>>  at
>>>>>>>>>>com.mysupply.ebxi.msh.MessageManager.sendMessage(MessageManager=
.java:149)
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>And of course I can not receive any messages through MSH either.
>>>>>>>>>>
>>>>>>>>>>Does anybody have the same problems, after a lost database
>>>>>>>>>>connection? The other part of my application that uses MSH, is
>>>>>>>>>>right back in action when the database connection is restored, =
but
>>>>>>>>>>not MSH.
>>>>>>>>>>
>>>>>>>>>>The app is running on jboss-4.0.1 (Tomcat 5.0.28), Java
>>>>>>>>>>jdk1.5.0_01. The database is Microsofts MSSQL 2000. The driver =
for
>>>>>>>>>>MSSQL is JTDS 1.0.
>>>>>>>>>>I have added this:
>>>>>>>>>><check-valid-connection-sql>select * from
>>>>>>>>>>some_table</check-valid-connection-sql>
>>>>>>>>>>to my datasource file: mssql-ds.xml which is deployed along wit=
h
>>>>>>>>>>msh.war.
>>>>>>>>>>
>>>>>>>>>>Everything is working fine, for days, until I loose the databas=
e
>>>>>>>>>>connection for a few minutes.
>>>>>>>>>>
>>>>>>>>>>_______________________________________________________________=
__
>>>>>>>>>>Del din verden med MSN Spaces  http://spaces.msn.com
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>-------------------------------------------------------
>>>>>>>>>>SF.Net email is sponsored by: Discover Easy Linux Migration Str=
ategies
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>from IBM. Find simple to follow Roadmaps, straightforward artic=
les,
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>>informative Webcasts and more! Get everything you need to get u=
p to
>>>>>>>>>>speed, fast. http://ads.osdn.com/?ad_id=3D7477&alloc_id=3D16492=
&op=3Dclick
>>>>>>>>>>_______________________________________________
>>>>>>>>>>ebxmlms-general mailing list
>>>>>>>>>>ebx...@li...
>>>>>>>>>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>_________________________________________________________________
>>>>>>>>Undg=E5 pop-ups med MSN Toolbar -  http://toolbar.msn.dk/ hent de=
n gratis!
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>-------------------------------------------------------
>>>>>>>>SF.Net email is sponsored by: Discover Easy Linux Migration Strat=
egies
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>from IBM. Find simple to follow Roadmaps, straightforward article=
s,
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>>informative Webcasts and more! Get everything you need to get up =
to
>>>>>>>>speed, fast. http://ads.osdn.com/?ad_id=3D7477&alloc_id=3D16492&o=
p=3Dclick
>>>>>>>>_______________________________________________
>>>>>>>>ebxmlms-general mailing list
>>>>>>>>ebx...@li...
>>>>>>>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>-------------------------------------------------------
>>>>>>>SF.Net email is sponsored by: Discover Easy Linux Migration Strate=
gies
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>from IBM. Find simple to follow Roadmaps, straightforward articles=
,
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>>informative Webcasts and more! Get everything you need to get up t=
o
>>>>>>>speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id=16492&op=CCk
>>>>>>>_______________________________________________
>>>>>>>ebxmlms-general mailing list
>>>>>>>ebx...@li...
>>>>>>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>-------------------------------------------------------
>>>>>>SF.Net email is sponsored by: Discover Easy Linux Migration Strateg=
ies
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>from IBM. Find simple to follow Roadmaps, straightforward articles,
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>>informative Webcasts and more! Get everything you need to get up to
>>>>>>speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id=16492&op=CCk
>>>>>>_______________________________________________
>>>>>>ebxmlms-general mailing list
>>>>>>ebx...@li...
>>>>>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>-------------------------------------------------------
>>>>SF.Net email is sponsored by: Discover Easy Linux Migration Strategie=
s
>>>>
>>>>
>>>>from IBM. Find simple to follow Roadmaps, straightforward articles,
>>>
>>>
>>>>informative Webcasts and more! Get everything you need to get up to
>>>>speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id=16492&op=3Dick
>>>>_______________________________________________
>>>>ebxmlms-general mailing list
>>>>ebx...@li...
>>>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>>>
>>>>
>>>>-------------------------------------------------------
>>>>SF.Net email is sponsored by: Discover Easy Linux Migration Strategie=
s
>>>>
>>>>
>>>>from IBM. Find simple to follow Roadmaps, straightforward articles,
>>>
>>>
>>>>informative Webcasts and more! Get everything you need to get up to
>>>>speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id=16492&op=CCk
>>>>_______________________________________________
>>>>ebxmlms-general mailing list
>>>>ebx...@li...
>>>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>>>
>>>>
>>>>
>>>>
>>>>
>>>-------------------------------------------------------
>>>SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
>>>from IBM. Find simple to follow Roadmaps, straightforward articles,
>>>informative Webcasts and more! Get everything you need to get up to
>>>speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id=16492&op=CCk
>>>_______________________________________________
>>>ebxmlms-general mailing list
>>>ebx...@li...
>>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id=16492&op=CCk
> _______________________________________________
> ebxmlms-general mailing list
> ebx...@li...
> https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>
>


--=20
Kijk niet terug, maar kijk naar mij
Against all odds

Re: [ebxmlms-general] Out of memory error in the MSH monitor

[Ronald v. K. <rtv...@xs...>]

Where is hermes itself running? You mention to monitors (PC A and PC B) but not where hermes
itself is running. So unless we know where exactely the error occured (monitor <-> hermes <->
monitor) it is difficult to answer your questions.

Ronald

em...@og... probeerde me het volgende duidelijk te maken:
> When I repeatedly sent a message with one attachment of size 600KB 100
> times from the MSH monitor in one Windows PC (call it A) to the MSH
> monitor in another Windows PC (call it B), the monitor in B showed the
> java.lang.OutOfMemoryError after displaying the first 66 messages received
> in the "Receive History" (the remaining 34 messages could be displayed
> after OutOfMemoryError occurred), while the monitor in A revealed all 100
> messages sent with the state "Sent and Acknowledgement Received" when
> right-clicking the messages in the "Sent History" in A.
>
> The OutOfMemoryError still occurred until the MSH monitor in B was
> restarted.  Right after the restart, the remaining 34 messages were
> displayed in the "Receive History".
>
> The default MaxPayloadSize (1000000) in msh_client.properties.xml is used.
> PC A has 512MB RAM and paging file size allocated is 768MB, while PC B has
> 768MB RAM and paging file size allocated is 1152MB.
>
> I have some questions based on the above incident:
>
> 1. Although PC B did not reveals all messages, PC A reveals that all
> mesages "Sent and Acknowledgement Received", I wonder whether PC B
> successfully receive all 100 messages?


> 2. Any recommendation on the hardware requirements on running Hermes,
> especially a large volume of messages need to be processed?

Since PC B (the monitor) gave an oom exception, I think your current hermes config (PC A) can
handle it nicely

> 3. Although PC B has more RAM and virtual memory than PC A, but the out of
> memory error did not occur in A. Is there any difference in the memory or
> other hardware requirement for sending messages and receiving messages.
> 4. Any other experience sharing is welcomed.
>
>
> Regards,
> MC


-- 
Kijk niet terug, maar kijk naar mij
Against all odds

Re: [ebxmlms-general] Out of memory error in the MSH monitor

[Mattias J <mj...@ex...>]

At 2005-07-21 12:48, you wrote:
>When I repeatedly sent a message with one attachment of size 600KB 
>100 times from the MSH monitor in one Windows PC (call it A) to the 
>MSH monitor in another Windows PC (call it B), the monitor in B 
>showed the java.lang.OutOfMemoryError after displaying the first 66 
>messages received in the "Receive History" (the remaining 34 
>messages could be displayed after OutOfMemoryError occurred), while 
>the monitor in A revealed all 100 messages sent with the state "Sent 
>and Acknowledgement Received" when right-clicking the messages in 
>the "Sent History" in A.
>
>The OutOfMemoryError still occurred until the MSH monitor in B was 
>restarted.  Right after the restart, the remaining 34 messages were 
>displayed in the "Receive History".
>
>The default MaxPayloadSize (1000000) in msh_client.properties.xml is 
>used. PC A has 512MB RAM and paging file size allocated is 768MB, 
>while PC B has 768MB RAM and paging file size allocated is 1152MB.

Well, how much memory did you assign to the JVM?
Check out -Xmn, -Xms and -Xmx

[ebxmlms-general] Out of memory error in the MSH monitor

[<em...@og...>]

When I repeatedly sent a message with one attachment of size 600KB 100 
times from the MSH monitor in one Windows PC (call it A) to the MSH 
monitor in another Windows PC (call it B), the monitor in B showed the 
java.lang.OutOfMemoryError after displaying the first 66 messages received 
in the "Receive History" (the remaining 34 messages could be displayed 
after OutOfMemoryError occurred), while the monitor in A revealed all 100 
messages sent with the state "Sent and Acknowledgement Received" when 
right-clicking the messages in the "Sent History" in A.

The OutOfMemoryError still occurred until the MSH monitor in B was 
restarted.  Right after the restart, the remaining 34 messages were 
displayed in the "Receive History".

The default MaxPayloadSize (1000000) in msh_client.properties.xml is used. 
PC A has 512MB RAM and paging file size allocated is 768MB, while PC B has 
768MB RAM and paging file size allocated is 1152MB.

I have some questions based on the above incident:

1. Although PC B did not reveals all messages, PC A reveals that all 
mesages "Sent and Acknowledgement Received", I wonder whether PC B 
successfully receive all 100 messages?
2. Any recommendation on the hardware requirements on running Hermes, 
especially a large volume of messages need to be processed?
3. Although PC B has more RAM and virtual memory than PC A, but the out of 
memory error did not occur in A. Is there any difference in the memory or 
other hardware requirement for sending messages and receiving messages.
4. Any other experience sharing is welcomed.


Regards,
MC

Re: [ebxmlms-general] help with getReceivedMessageIds()

[Patrick Y. <kc...@ce...>]

Can you check the sender MSH's log to make sure the sending side can 
really send the messages successfully? If seems there is something wrong 
at the sender side, since there are MessageError received.

Regards,
Patrick Yee
Center for E-Commerce Infrastructure Development

Making E-Commerce Everyday Commerce



Christopher Gorge Marges wrote:

>getReceivedMessageIds() always return null.  I have set up hermes on
>one machine.
>When I use the code found in 
>http://sourceforge.net/mailarchive/message.php?msg_id=10941613
>The program does not get any messages.  I just copied the code as-is
>and nothing happens, even after a loopback message was sent.
>
>When I use the Loopback sample code it 
>can send a test message then when the class is run again it does get
>the MessageErrors
>that are generated by the msh.
>
>Thanks.
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by the 'Do More With Dual!' webinar happening
>July 14 at 8am PDT/11am EDT. We invite you to explore the latest in dual
>core and dual graphics technology at this free one hour event hosted by HP,
>AMD, and NVIDIA.  To register visit http://www.hp.com/go/dualwebinar
>_______________________________________________
>ebxmlms-general mailing list
>ebx...@li...
>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>
>  
>

Re: [ebxmlms-general] no primary key on sent and received message

[Patrick Y. <kc...@ce...>]

Yeah.. I think the migration script should be quite risk-free, since the 
tables were in one-one relationship. ..p

Regards,
Patrick Yee
Center for E-Commerce Infrastructure Development

Making E-Commerce Everyday Commerce



Ronald van Kuijk wrote:

>Ok, if I combine them now, should we provide a migrationscript then? Maybe we should, but I'll
>focus on refactoring first.
>
>Ronald
>
>Patrick Yee probeerde me het volgende duidelijk te maken:
>  
>
>>:-) They can be combined. The reason is that we originally only had
>>messagestore. And later we wanted to add more columns to it but at the
>>same time we would like to keep the original table structure due to some
>>early deployment issues.
>>
>>Regards,
>>Patrick Yee
>>Center for E-Commerce Infrastructure Development
>>
>>Making E-Commerce Everyday Commerce
>>
>>
>>
>>Ronald van Kuijk wrote:
>>
>>    
>>
>>>All the tables which did not have a primary key (sentmessage, receivedmessage). I made the
>>>messageid columns the primary key.
>>>
>>>And now I'm experimenting a little, for 3 tables there are already classes that can be used for
>>>persistency with some small changes (ApplicationContext, MessageServiceHandlerConfig,
>>>EbxmlMessage
>>>
>>>I've made up my mind and (at least for myself since I do not know what the license says) will try
>>>to rewrite the persistency layer completely. This means:
>>>- get rid of DBTableManager
>>>- clean up all classes that use these prepaired statement things
>>>- get rid of the proprietary connectionpool
>>>- store the messages in a blob as long as there is no alternative (JTA/JCA compliant) file store
>>>
>>>This would make the code much more readably and have a persistency layer which is much easier to
>>>maintain (by others).
>>>
>>>There are some questions I already have. One simple, but important one is if messagestore and
>>>messageinfo could be combined. I've looked a little and could not find a reason to keep them
>>>separate (but it is now 04:17, so I do not see clearly anymore ;-))
>>>
>>>Ronald
>>>
>>>p.s. more will follow.......
>>>
>>>
>>>Steven Herod probeerde me het volgende duidelijk te maken:
>>>
>>>
>>>      
>>>
>>>>I've generated hibernate classes myself for hermes and added my own 'id' column definitions.
>>>>
>>>>Which tables?
>>>>
>>>>-----Original Message-----
>>>>From: ebx...@li...
>>>>[mailto:ebx...@li...] On Behalf Of Ronald van Kuijk
>>>>Sent: Wednesday, 6 July 2005 9:44 PM
>>>>To: ebx...@li...
>>>>Subject: [ebxmlms-general] no primary key on sent and received message
>>>>
>>>>I'm trying to reverse generate some components for accessing the DB using hibernate (from within
>>>>exadel studio). This works nice,
>>>>but for two tables there are no classes generated. This seems to be related to the fact that
>>>>these
>>>>two tables do not have primary
>>>>keys.
>>>>
>>>>Question: Can they have primarykeys and if so which columns
>>>>
>>>>My guess: Yes, compound c_time and c_messageid or maybe even single c_messageid
>>>>
>>>>Thanks,
>>>>
>>>>Ronald
>>>>
>>>>
>>>>
>>>>
>>>>-------------------------------------------------------
>>>>SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to
>>>>follow Roadmaps, straightforward
>>>>articles, informative Webcasts and more! Get everything you need to get up to speed, fast.
>>>>http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
>>>>_______________________________________________
>>>>ebxmlms-general mailing list
>>>>ebx...@li...
>>>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>>>
>>>>
>>>>
>>>>-------------------------------------------------------
>>>>SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
>>>>        
>>>>
>>>>from IBM. Find simple to follow Roadmaps, straightforward articles,
>>>      
>>>
>>>>informative Webcasts and more! Get everything you need to get up to
>>>>speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
>>>>_______________________________________________
>>>>ebxmlms-general mailing list
>>>>ebx...@li...
>>>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>>>
>>>>
>>>>
>>>>        
>>>>
>>>
>>>
>>>      
>>>
>>-------------------------------------------------------
>>SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
>>from IBM. Find simple to follow Roadmaps, straightforward articles,
>>informative Webcasts and more! Get everything you need to get up to
>>speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
>>_______________________________________________
>>ebxmlms-general mailing list
>>ebx...@li...
>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>
>>    
>>
>
>
>  
>

Re: [ebxmlms-general] Connectionpooling and transactions

[Patrick Y. <kc...@ce...>]

Sorry for late reply. It is really nice to know the progress. Regarding=20
the inner classes, I think there are various reasons for having them.=20
Some are for package security, so that only the nested classes can=20
access them. Also there are some being created just for convenience.

Regards,
Patrick Yee
Center for E-Commerce Infrastructure Development

Making E-Commerce Everyday Commerce



Ronald van Kuijk wrote:

>Hi Patrick,
>
>Great to hear. I'm already going fairly good. There is a lot of refactor=
ing I'd like to do. I was
>not confident before but now I've heard this, I'll go for it for sure.
>
>Since all servlet engines also support JMX at the moment, I'd like to co=
nvert the real commands to
>an MBean (stop, resume, backup, getStatus etc...) and have main servlet =
just for receiving
>messages from other MHS, either by http or by starting another monitor f=
or smtp. Getting messages
>to the MHS from a businessprocess can go through other 'monitors' (we di=
scussed naming these
>something else before, but I lost this conversation) Configurable (http,=
 jms, ejb, ...) and
>possibly also as a JBI SPI (would be nice, connecting hermes to a standa=
rd ESB right...?)
>
>One question I have is why there are so many innner classes? Is this bec=
ause of security reasons
>so they cannot be accessed from outside?
>
>I'll keep you guys posted.
>
>Ronald
>
>Patrick Yee probeerde me het volgende duidelijk te maken:
> =20
>
>>By the time we were designing Hermes, Hibernate is not that well
>>considered... (yes, the other way to interpret this is, we are quite
>>closed in terms of employing other libraries). I think your opinion is =
a
>>good one.
>>
>>Regards,
>>Patrick Yee
>>Center for E-Commerce Infrastructure Development
>>
>>Making E-Commerce Everyday Commerce
>>
>>
>>
>>R. van Kuijk (Ronald) wrote:
>>
>>   =20
>>
>>>Hmm... I missed the option to redirect file persistence to a database.=
 I'll have a look. With
>>>'still it is not transaction-aware' you mean that the filepersistence =
is not really transaction
>>>aware? There are some 'in vm-locking mechamisms' in there but no real =
commit/rollback etc. Would
>>>that be needed? Kind of difficult, but I'll see.
>>>
>>>Ok, another question. I have a fairly clear picture of the front-end m=
essageserver,
>>>messageservicehandler etc and how the command parsing works. In additi=
on to that, I dug a little
>>>bit deeper into hermes again especially the DBTableManager classes etc=
. If it is possible I'd
>>>like to get some info on the architectural choices that were made to c=
ome to such a solution. It
>>>looks like it is some persistence mapping, for which there currently a=
re very nice out-of-the-box
>>>solutions (think hibernate). IMVVHO (it is a very, very humble one) th=
is would also be a nice
>>>change and would make it possible to support more databases.
>>>
>>>I'll try to work something out which makes it possible to store messag=
es in either a file or a
>>>database (configurable?)
>>>
>>>
>>>-----Oorspronkelijk bericht-----
>>>Van: ebx...@li...
>>>[mailto:ebx...@li...] Namens Patrick Ye=
e
>>>Verzonden: woensdag 6 juli 2005 4:02
>>>Aan: ebx...@li...
>>>Onderwerp: Re: [ebxmlms-general] Connectionpooling and transactions. w=
as: Problems after lost
>>>connection to database
>>>
>>>Now, Hermes supports a custom way (API) to redirect the file persisten=
ce
>>>to database. However, still it is not transaction-aware. So we may nee=
d
>>>to modify that API as well. What do you think?
>>>Regards, -Patrick
>>>
>>>
>>>Ronald van Kuijk wrote:
>>>
>>>
>>>
>>>     =20
>>>
>>>>Sounds interesting. But with regard to this immediately a second ques=
tion comes to mind. There
>>>>is
>>>>also a transactionmechanism in place which does a kind of xa over a d=
atabase and a filesystem.
>>>>This makes it almost impossible to use the default JTA for this, whic=
h would make the hermes
>>>>core
>>>>even smaller. For our company, storing the messages in a DB as a blob=
 is not a problem since we
>>>>require clustering and failover any way. It is in fact even a require=
ment unless there would be
>>>>a
>>>>JTA compatible filesystem persistency layer (JCA?)).
>>>>
>>>>Replacing the DBConnectionPool with a standard based solution can be =
done by me, since I've done
>>>>it before and probably have the code somewhere. DBCP does not have to=
 be provided then, since
>>>>all
>>>>servlet engines and j2ee servers contain one. But regarding the file =
persistency I'd like to get
>>>>a
>>>>response from more users since that is another issue.
>>>>
>>>>Comments?
>>>>
>>>>
>>>>Patrick Yee probeerde me het volgende duidelijk te maken:
>>>>
>>>>
>>>>
>>>>
>>>>       =20
>>>>
>>>>>There is no strict reason for using our own implementation. So it wo=
uld
>>>>>be good to have some contribution to port Hermes to make use of othe=
r
>>>>>database pool, like DBCP.
>>>>>Regards, -Patrick
>>>>>
>>>>>Regards, -Patrick
>>>>>
>>>>>
>>>>>Mattias J wrote:
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>         =20
>>>>>
>>>>>>Yes, why not include for example Jakarta Commons DBCP?
>>>>>>
>>>>>>At 2005-06-27 09:29, you wrote:
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>           =20
>>>>>>
>>>>>>>I guess the problem is that you have implemented your own
>>>>>>>databasepool, without sophisticated recovery mechanism.
>>>>>>>Our own application use javax.sql.DataSource, to get a connection.=
 I
>>>>>>>guess there is a recovery mechanism in that solution, as our own
>>>>>>>application runs fine when the connection gets back.
>>>>>>>Is there anyway to use javax.sql.DataSource instead of your
>>>>>>>implementation of the connection pool? I guess my question is more=
 to
>>>>>>>why you are using your own implemtation, are you using some extra
>>>>>>>stuff, I can't get from javax.sql.DataSource?
>>>>>>>
>>>>>>>Regards Kenneth
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>             =20
>>>>>>>
>>>>>>>>From: Patrick Yee <kc...@ce...>
>>>>>>>>To: ebx...@li...
>>>>>>>>CC: tr...@ho...
>>>>>>>>Subject: Re: [ebxmlms-general] Problems after lost connection to
>>>>>>>>database
>>>>>>>>Date: Sun, 26 Jun 2005 19:19:35 +0800
>>>>>>>>
>>>>>>>>We have not implemented a sophisticated recovery mechanism in the
>>>>>>>>database connection pool. The only mechanism we have done is,
>>>>>>>>whenever a connection is proved to be bad, we will not put it bac=
k
>>>>>>>>to the connection pool. Actually there was a suggestion some time
>>>>>>>>ago that we can do a "select *" on some tables before we use the
>>>>>>>>pooled database connection. We think that will create certain
>>>>>>>>performance issue, and so we shelved that idea. Of course, if you
>>>>>>>>want it, you can just patch the database connection pool classes =
and
>>>>>>>>implement any advanced recovery mechanism as you like. :-)
>>>>>>>>Regards, -Patrick
>>>>>>>>
>>>>>>>>
>>>>>>>>Kenneth Pedersen wrote:
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>               =20
>>>>>>>>
>>>>>>>>>Hi
>>>>>>>>>
>>>>>>>>>If I loose the connection to my database for a short time
>>>>>>>>>(1-2minutes), MSH do not operate properly afterwards.
>>>>>>>>>
>>>>>>>>>When the connection is lost this occurs in the MSH_client.log:
>>>>>>>>>
>>>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D>
>>>>>>>>>DbConnectionPool.getConnection
>>>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: <=3D
>>>>>>>>>DbConnectionPool.getConnection
>>>>>>>>>2005-06-21 09:13:34,384 ERROR [Thread-8]: [10002] Unknown error
>>>>>>>>>Exception: java.sql.SQLException
>>>>>>>>>Message: I/O Error: Connection reset by peer: socket write error
>>>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D> Transaction.rollb=
ack
>>>>>>>>>(txID: #2321)
>>>>>>>>>2005-06-21 09:13:34,384 ERROR [Thread-8]: [10315] Cannot rollbac=
k
>>>>>>>>>DB changes
>>>>>>>>>Exception: java.sql.SQLException
>>>>>>>>>Message: Invalid state, the Connection object is closed.
>>>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D>
>>>>>>>>>DbConnectionPool.freeConnection
>>>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: <=3D
>>>>>>>>>DbConnectionPool.freeConnection
>>>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: <=3D Transaction.rollb=
ack
>>>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D>
>>>>>>>>>MessageServiceHandler.getNextUndeliveredMessage
>>>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D>
>>>>>>>>>MessageServer.getUndeliveredMessages
>>>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D>
>>>>>>>>>DbConnectionPool.getConnection
>>>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D>
>>>>>>>>>DbConnectionPool.createConnection
>>>>>>>>>2005-06-21 09:13:35,352 ERROR [Thread-8]: [10306] Cannot create =
DB
>>>>>>>>>connection Exception: java.sql.SQLException Message: Network err=
or
>>>>>>>>>IOException: Connection refused: connect
>>>>>>>>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: =3D> Transaction.rollb=
ack
>>>>>>>>>(txID: #2323)
>>>>>>>>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: <=3D Transaction.rollb=
ack
>>>>>>>>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: =3D>
>>>>>>>>>MessageServiceHandler.getNextUndeliveredMessage
>>>>>>>>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: =3D>
>>>>>>>>>MessageServer.getUndeliveredMessages
>>>>>>>>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: =3D>
>>>>>>>>>DbConnectionPool.getConnection
>>>>>>>>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: =3D>
>>>>>>>>>DbConnectionPool.createConnection
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>After the connection is restored MSH do not seem to get a proper
>>>>>>>>>connection.
>>>>>>>>>This occurs then in the MSH_Client.log:
>>>>>>>>>
>>>>>>>>>2005-06-21 09:13:42,384 ERROR [Thread-8]: [10306] Cannot create =
DB
>>>>>>>>>connection
>>>>>>>>>Exception: java.sql.SQLException Message: Network error
>>>>>>>>>IOException: Connection refused: connect
>>>>>>>>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: =3D> Transaction.rollb=
ack
>>>>>>>>>(txID: #2338)
>>>>>>>>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: <=3D Transaction.rollb=
ack
>>>>>>>>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: =3D>
>>>>>>>>>MessageServiceHandler.getNextUndeliveredMessage
>>>>>>>>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: =3D>
>>>>>>>>>MessageServer.getUndeliveredMessages
>>>>>>>>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: =3D>
>>>>>>>>>DbConnectionPool.getConnection
>>>>>>>>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: =3D>
>>>>>>>>>DbConnectionPool.createConnection
>>>>>>>>>2005-06-21 09:13:43,384 ERROR [Thread-8]: [10306] Cannot create =
DB
>>>>>>>>>connection
>>>>>>>>>Exception: java.sql.SQLException
>>>>>>>>>Message: Network error IOException: Connection refused: connect
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>When i try to send a message through MSH i get this:
>>>>>>>>>hk.hku.cecid.phoenix.message.handler.RequestException:
>>>>>>>>>Failed to send query to MSH.
>>>>>>>>>HTTP response code =3D 200
>>>>>>>>>HTTP response message =3D OK
>>>>>>>>>  at
>>>>>>>>>hk.hku.cecid.phoenix.message.handler.Request.expectMapResponse(U=
nknown
>>>>>>>>>Source)
>>>>>>>>>  at
>>>>>>>>>hk.hku.cecid.phoenix.message.handler.Request.sendMessageServiceH=
andlerConfig(Unknown
>>>>>>>>>Source)
>>>>>>>>>  at
>>>>>>>>>hk.hku.cecid.phoenix.message.handler.Request.register(Unknown So=
urce)
>>>>>>>>>  at hk.hku.cecid.phoenix.message.handler.Request.<init>(Unknown
>>>>>>>>>Source)
>>>>>>>>>  at hk.hku.cecid.phoenix.message.handler.Request.<init>(Unknown
>>>>>>>>>Source)
>>>>>>>>>  at
>>>>>>>>>com.mysupply.ebxi.msh.MessageManager.sendMessage(MessageManager.=
java:149)
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>And of course I can not receive any messages through MSH either.
>>>>>>>>>
>>>>>>>>>Does anybody have the same problems, after a lost database
>>>>>>>>>connection? The other part of my application that uses MSH, is
>>>>>>>>>right back in action when the database connection is restored, b=
ut
>>>>>>>>>not MSH.
>>>>>>>>>
>>>>>>>>>The app is running on jboss-4.0.1 (Tomcat 5.0.28), Java
>>>>>>>>>jdk1.5.0_01. The database is Microsofts MSSQL 2000. The driver f=
or
>>>>>>>>>MSSQL is JTDS 1.0.
>>>>>>>>>I have added this:
>>>>>>>>><check-valid-connection-sql>select * from
>>>>>>>>>some_table</check-valid-connection-sql>
>>>>>>>>>to my datasource file: mssql-ds.xml which is deployed along with
>>>>>>>>>msh.war.
>>>>>>>>>
>>>>>>>>>Everything is working fine, for days, until I loose the database
>>>>>>>>>connection for a few minutes.
>>>>>>>>>
>>>>>>>>>________________________________________________________________=
_
>>>>>>>>>Del din verden med MSN Spaces  http://spaces.msn.com
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>-------------------------------------------------------
>>>>>>>>>SF.Net email is sponsored by: Discover Easy Linux Migration Stra=
tegies
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>                 =20
>>>>>>>>>
>>>>>>>>>from IBM. Find simple to follow Roadmaps, straightforward articl=
es,
>>>>>>>>
>>>>>>>>
>>>>>>>>               =20
>>>>>>>>
>>>>>>>>>informative Webcasts and more! Get everything you need to get up=
 to
>>>>>>>>>speed, fast. http://ads.osdn.com/?ad_id=3D7477&alloc_id=3D16492&=
op=3Dclick
>>>>>>>>>_______________________________________________
>>>>>>>>>ebxmlms-general mailing list
>>>>>>>>>ebx...@li...
>>>>>>>>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>                 =20
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>               =20
>>>>>>>>
>>>>>>>_________________________________________________________________
>>>>>>>Undg=E5 pop-ups med MSN Toolbar -  http://toolbar.msn.dk/ hent den=
 gratis!
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>-------------------------------------------------------
>>>>>>>SF.Net email is sponsored by: Discover Easy Linux Migration Strate=
gies
>>>>>>>
>>>>>>>
>>>>>>>             =20
>>>>>>>
>>>>>>>from IBM. Find simple to follow Roadmaps, straightforward articles=
,
>>>>>>
>>>>>>
>>>>>>           =20
>>>>>>
>>>>>>>informative Webcasts and more! Get everything you need to get up t=
o
>>>>>>>speed, fast. http://ads.osdn.com/?ad_id=3D7477&alloc_id=3D16492&op=
=3Dclick
>>>>>>>_______________________________________________
>>>>>>>ebxmlms-general mailing list
>>>>>>>ebx...@li...
>>>>>>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>             =20
>>>>>>>
>>>>>>-------------------------------------------------------
>>>>>>SF.Net email is sponsored by: Discover Easy Linux Migration Strateg=
ies
>>>>>>
>>>>>>
>>>>>>           =20
>>>>>>
>>>>>>from IBM. Find simple to follow Roadmaps, straightforward articles,
>>>>>
>>>>>
>>>>>         =20
>>>>>
>>>>>>informative Webcasts and more! Get everything you need to get up to
>>>>>>speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id=16492&op=CCk
>>>>>>_______________________________________________
>>>>>>ebxmlms-general mailing list
>>>>>>ebx...@li...
>>>>>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>           =20
>>>>>>
>>>>>-------------------------------------------------------
>>>>>SF.Net email is sponsored by: Discover Easy Linux Migration Strategi=
es
>>>>>
>>>>>
>>>>>         =20
>>>>>
>>>>>from IBM. Find simple to follow Roadmaps, straightforward articles,
>>>>
>>>>
>>>>       =20
>>>>
>>>>>informative Webcasts and more! Get everything you need to get up to
>>>>>speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id=16492&op=CCk
>>>>>_______________________________________________
>>>>>ebxmlms-general mailing list
>>>>>ebx...@li...
>>>>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>         =20
>>>>>
>>>>
>>>>
>>>>       =20
>>>>
>>>
>>>-------------------------------------------------------
>>>SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
>>>     =20
>>>
>>>from IBM. Find simple to follow Roadmaps, straightforward articles,
>>   =20
>>
>>>informative Webcasts and more! Get everything you need to get up to
>>>speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id=16492&op=3Dick
>>>_______________________________________________
>>>ebxmlms-general mailing list
>>>ebx...@li...
>>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>>
>>>
>>>-------------------------------------------------------
>>>SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
>>>     =20
>>>
>>>from IBM. Find simple to follow Roadmaps, straightforward articles,
>>   =20
>>
>>>informative Webcasts and more! Get everything you need to get up to
>>>speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id=16492&op=CCk
>>>_______________________________________________
>>>ebxmlms-general mailing list
>>>ebx...@li...
>>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>>
>>>
>>>
>>>     =20
>>>
>>-------------------------------------------------------
>>SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
>>from IBM. Find simple to follow Roadmaps, straightforward articles,
>>informative Webcasts and more! Get everything you need to get up to
>>speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id=16492&op=CCk
>>_______________________________________________
>>ebxmlms-general mailing list
>>ebx...@li...
>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>
>>
>>   =20
>>
>
>
> =20
>

Re: [ebxmlms-general] Multiple Recipients EbXML Message

[Ronald v. K. <rtv...@xs...>]

Please do not crsosspost!!! Read my other reply.

Ronald

ian tabangay probeerde me het volgende duidelijk te maken:
> Hi.
> I would like to ask the group's suggestion and/or comment on how to handle multiple recipients in
> EBXML Messages.
> Is it possible? Is it even allowed? How does Hermes handle this?
> Thank you in advance.
>
> Ian Tabangay
> Supply Chain Networks, Inc.
> ia...@sc... <mailto:ia...@sc...>
>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> ebxmlms-general mailing list
> ebx...@li...
> https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>


-- 
Kijk niet terug, maar kijk naar mij
Against all odds

[ebxmlms-general] Re: [ebxmlms-develop] Multiple Recipients EbXML Message

[Ronald v. K. <rtv...@xs...>]

ian tabangay probeerde me het volgende duidelijk te maken:
> Hi.
> I would like to ask the group's suggestion and/or comment on how to han=
dle multiple recipients in
> EBXML Messages.
> Is it possible?

No idea

> Is it even allowed?

From the spec:

3.1.1 From and To Elements 762

The REQUIRED From element identifies the Party that originated the messag=
e. The REQUIRED To 763
element identifies the Party that is the intended recipient of the messag=
e. Both To and From can
contain 764
logical identifiers, such as a DUNS number, or identifiers that also impl=
y a physical location
such as an 765
eMail address. 766
The From and the To elements each contains: 767
=95 PartyId elements =96 occurs one or more times 768
=95 Role element =96 occurs zero or one times. 769
If either the From or To elements contains multiple PartyId elements, all=
 members of the list MUST
770
identify the same organization. Unless a single type value refers to mult=
iple identification
systems, the 771
value of any given type attribute MUST be unique within the list of Party=
Id elements contained
within 772
either the From or To element.

Especially lines 770 and 771 are important:

If either the From or To elements contains multiple PartyId elements, all=
 members of the list MUST
identify the same organization


>How does Hermes handle this?

No idea... did you try it?


Ronald


> Thank you in advance.
>
> Ian Tabangay
> Supply Chain Networks, Inc.
> ia...@sc... <mailto:ia...@sc...>
>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_id=3D7477&alloc_id=3D16492&op=3Dcl=
ick
> _______________________________________________
> ebxmlms-develop mailing list
> ebx...@li...
> https://lists.sourceforge.net/lists/listinfo/ebxmlms-develop
>


--=20
Kijk niet terug, maar kijk naar mij
Against all odds

[ebxmlms-general] Multiple Recipients EbXML Message

[ian t. <ia...@sc...>]

Hi.
I would like to ask the group's suggestion and/or comment on how to handle multiple recipients in EBXML Messages.
Is it possible? Is it even allowed? How does Hermes handle this?
Thank you in advance.

Ian Tabangay
Supply Chain Networks, Inc.
ia...@sc... <mailto:ia...@sc...>

Re: [ebxmlms-general] no primary key on sent and received message

[Ronald v. K. <rtv...@xs...>]

Ok, if I combine them now, should we provide a migrationscript then? Maybe we should, but I'll
focus on refactoring first.

Ronald

Patrick Yee probeerde me het volgende duidelijk te maken:
> :-) They can be combined. The reason is that we originally only had
> messagestore. And later we wanted to add more columns to it but at the
> same time we would like to keep the original table structure due to some
> early deployment issues.
>
> Regards,
> Patrick Yee
> Center for E-Commerce Infrastructure Development
>
> Making E-Commerce Everyday Commerce
>
>
>
> Ronald van Kuijk wrote:
>
>>All the tables which did not have a primary key (sentmessage, receivedmessage). I made the
>>messageid columns the primary key.
>>
>>And now I'm experimenting a little, for 3 tables there are already classes that can be used for
>>persistency with some small changes (ApplicationContext, MessageServiceHandlerConfig,
>> EbxmlMessage
>>
>>I've made up my mind and (at least for myself since I do not know what the license says) will try
>>to rewrite the persistency layer completely. This means:
>>- get rid of DBTableManager
>>- clean up all classes that use these prepaired statement things
>>- get rid of the proprietary connectionpool
>>- store the messages in a blob as long as there is no alternative (JTA/JCA compliant) file store
>>
>>This would make the code much more readably and have a persistency layer which is much easier to
>>maintain (by others).
>>
>>There are some questions I already have. One simple, but important one is if messagestore and
>>messageinfo could be combined. I've looked a little and could not find a reason to keep them
>>separate (but it is now 04:17, so I do not see clearly anymore ;-))
>>
>>Ronald
>>
>>p.s. more will follow.......
>>
>>
>>Steven Herod probeerde me het volgende duidelijk te maken:
>>
>>
>>>I've generated hibernate classes myself for hermes and added my own 'id' column definitions.
>>>
>>>Which tables?
>>>
>>>-----Original Message-----
>>>From: ebx...@li...
>>>[mailto:ebx...@li...] On Behalf Of Ronald van Kuijk
>>>Sent: Wednesday, 6 July 2005 9:44 PM
>>>To: ebx...@li...
>>>Subject: [ebxmlms-general] no primary key on sent and received message
>>>
>>>I'm trying to reverse generate some components for accessing the DB using hibernate (from within
>>>exadel studio). This works nice,
>>>but for two tables there are no classes generated. This seems to be related to the fact that
>>> these
>>>two tables do not have primary
>>>keys.
>>>
>>>Question: Can they have primarykeys and if so which columns
>>>
>>>My guess: Yes, compound c_time and c_messageid or maybe even single c_messageid
>>>
>>>Thanks,
>>>
>>>Ronald
>>>
>>>
>>>
>>>
>>>-------------------------------------------------------
>>>SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to
>>>follow Roadmaps, straightforward
>>>articles, informative Webcasts and more! Get everything you need to get up to speed, fast.
>>>http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
>>>_______________________________________________
>>>ebxmlms-general mailing list
>>>ebx...@li...
>>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>>
>>>
>>>
>>>-------------------------------------------------------
>>>SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
>>>from IBM. Find simple to follow Roadmaps, straightforward articles,
>>>informative Webcasts and more! Get everything you need to get up to
>>>speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
>>>_______________________________________________
>>>ebxmlms-general mailing list
>>>ebx...@li...
>>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>>
>>>
>>>
>>
>>
>>
>>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> ebxmlms-general mailing list
> ebx...@li...
> https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>


-- 
Kijk niet terug, maar kijk naar mij
Against all odds

Re: [ebxmlms-general] Connectionpooling and transactions

[Ronald v. K. <rtv...@xs...>]

Hi Patrick,

Great to hear. I'm already going fairly good. There is a lot of refactori=
ng I'd like to do. I was
not confident before but now I've heard this, I'll go for it for sure.

Since all servlet engines also support JMX at the moment, I'd like to con=
vert the real commands to
an MBean (stop, resume, backup, getStatus etc...) and have main servlet j=
ust for receiving
messages from other MHS, either by http or by starting another monitor fo=
r smtp. Getting messages
to the MHS from a businessprocess can go through other 'monitors' (we dis=
cussed naming these
something else before, but I lost this conversation) Configurable (http, =
jms, ejb, ...) and
possibly also as a JBI SPI (would be nice, connecting hermes to a standar=
d ESB right...?)

One question I have is why there are so many innner classes? Is this beca=
use of security reasons
so they cannot be accessed from outside?

I'll keep you guys posted.

Ronald

Patrick Yee probeerde me het volgende duidelijk te maken:
> By the time we were designing Hermes, Hibernate is not that well
> considered... (yes, the other way to interpret this is, we are quite
> closed in terms of employing other libraries). I think your opinion is =
a
> good one.
>
> Regards,
> Patrick Yee
> Center for E-Commerce Infrastructure Development
>
> Making E-Commerce Everyday Commerce
>
>
>
> R. van Kuijk (Ronald) wrote:
>
>>Hmm... I missed the option to redirect file persistence to a database. =
I'll have a look. With
>> 'still it is not transaction-aware' you mean that the filepersistence =
is not really transaction
>> aware? There are some 'in vm-locking mechamisms' in there but no real =
commit/rollback etc. Would
>> that be needed? Kind of difficult, but I'll see.
>>
>>Ok, another question. I have a fairly clear picture of the front-end me=
ssageserver,
>> messageservicehandler etc and how the command parsing works. In additi=
on to that, I dug a little
>> bit deeper into hermes again especially the DBTableManager classes etc=
. If it is possible I'd
>> like to get some info on the architectural choices that were made to c=
ome to such a solution. It
>> looks like it is some persistence mapping, for which there currently a=
re very nice out-of-the-box
>> solutions (think hibernate). IMVVHO (it is a very, very humble one) th=
is would also be a nice
>> change and would make it possible to support more databases.
>>
>>I'll try to work something out which makes it possible to store message=
s in either a file or a
>> database (configurable?)
>>
>>
>>-----Oorspronkelijk bericht-----
>>Van: ebx...@li...
>> [mailto:ebx...@li...] Namens Patrick Ye=
e
>>Verzonden: woensdag 6 juli 2005 4:02
>>Aan: ebx...@li...
>>Onderwerp: Re: [ebxmlms-general] Connectionpooling and transactions. wa=
s: Problems after lost
>> connection to database
>>
>>Now, Hermes supports a custom way (API) to redirect the file persistenc=
e
>>to database. However, still it is not transaction-aware. So we may need
>>to modify that API as well. What do you think?
>>Regards, -Patrick
>>
>>
>>Ronald van Kuijk wrote:
>>
>>
>>
>>>Sounds interesting. But with regard to this immediately a second quest=
ion comes to mind. There
>>> is
>>>also a transactionmechanism in place which does a kind of xa over a da=
tabase and a filesystem.
>>>This makes it almost impossible to use the default JTA for this, which=
 would make the hermes
>>> core
>>>even smaller. For our company, storing the messages in a DB as a blob =
is not a problem since we
>>>require clustering and failover any way. It is in fact even a requirem=
ent unless there would be
>>> a
>>>JTA compatible filesystem persistency layer (JCA?)).
>>>
>>>Replacing the DBConnectionPool with a standard based solution can be d=
one by me, since I've done
>>>it before and probably have the code somewhere. DBCP does not have to =
be provided then, since
>>> all
>>>servlet engines and j2ee servers contain one. But regarding the file p=
ersistency I'd like to get
>>> a
>>>response from more users since that is another issue.
>>>
>>>Comments?
>>>
>>>
>>>Patrick Yee probeerde me het volgende duidelijk te maken:
>>>
>>>
>>>
>>>
>>>>There is no strict reason for using our own implementation. So it wou=
ld
>>>>be good to have some contribution to port Hermes to make use of other
>>>>database pool, like DBCP.
>>>>Regards, -Patrick
>>>>
>>>>Regards, -Patrick
>>>>
>>>>
>>>>Mattias J wrote:
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>>Yes, why not include for example Jakarta Commons DBCP?
>>>>>
>>>>>At 2005-06-27 09:29, you wrote:
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>>I guess the problem is that you have implemented your own
>>>>>>databasepool, without sophisticated recovery mechanism.
>>>>>>Our own application use javax.sql.DataSource, to get a connection. =
I
>>>>>>guess there is a recovery mechanism in that solution, as our own
>>>>>>application runs fine when the connection gets back.
>>>>>>Is there anyway to use javax.sql.DataSource instead of your
>>>>>>implementation of the connection pool? I guess my question is more =
to
>>>>>>why you are using your own implemtation, are you using some extra
>>>>>>stuff, I can't get from javax.sql.DataSource?
>>>>>>
>>>>>>Regards Kenneth
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>>From: Patrick Yee <kc...@ce...>
>>>>>>>To: ebx...@li...
>>>>>>>CC: tr...@ho...
>>>>>>>Subject: Re: [ebxmlms-general] Problems after lost connection to
>>>>>>>database
>>>>>>>Date: Sun, 26 Jun 2005 19:19:35 +0800
>>>>>>>
>>>>>>>We have not implemented a sophisticated recovery mechanism in the
>>>>>>>database connection pool. The only mechanism we have done is,
>>>>>>>whenever a connection is proved to be bad, we will not put it back
>>>>>>>to the connection pool. Actually there was a suggestion some time
>>>>>>>ago that we can do a "select *" on some tables before we use the
>>>>>>>pooled database connection. We think that will create certain
>>>>>>>performance issue, and so we shelved that idea. Of course, if you
>>>>>>>want it, you can just patch the database connection pool classes a=
nd
>>>>>>>implement any advanced recovery mechanism as you like. :-)
>>>>>>>Regards, -Patrick
>>>>>>>
>>>>>>>
>>>>>>>Kenneth Pedersen wrote:
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>>Hi
>>>>>>>>
>>>>>>>>If I loose the connection to my database for a short time
>>>>>>>>(1-2minutes), MSH do not operate properly afterwards.
>>>>>>>>
>>>>>>>>When the connection is lost this occurs in the MSH_client.log:
>>>>>>>>
>>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D>
>>>>>>>>DbConnectionPool.getConnection
>>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: <=3D
>>>>>>>>DbConnectionPool.getConnection
>>>>>>>>2005-06-21 09:13:34,384 ERROR [Thread-8]: [10002] Unknown error
>>>>>>>>Exception: java.sql.SQLException
>>>>>>>>Message: I/O Error: Connection reset by peer: socket write error
>>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D> Transaction.rollba=
ck
>>>>>>>>(txID: #2321)
>>>>>>>>2005-06-21 09:13:34,384 ERROR [Thread-8]: [10315] Cannot rollback
>>>>>>>>DB changes
>>>>>>>>Exception: java.sql.SQLException
>>>>>>>>Message: Invalid state, the Connection object is closed.
>>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D>
>>>>>>>>DbConnectionPool.freeConnection
>>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: <=3D
>>>>>>>>DbConnectionPool.freeConnection
>>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: <=3D Transaction.rollba=
ck
>>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D>
>>>>>>>>MessageServiceHandler.getNextUndeliveredMessage
>>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D>
>>>>>>>>MessageServer.getUndeliveredMessages
>>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D>
>>>>>>>>DbConnectionPool.getConnection
>>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D>
>>>>>>>>DbConnectionPool.createConnection
>>>>>>>>2005-06-21 09:13:35,352 ERROR [Thread-8]: [10306] Cannot create D=
B
>>>>>>>>connection Exception: java.sql.SQLException Message: Network erro=
r
>>>>>>>>IOException: Connection refused: connect
>>>>>>>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: =3D> Transaction.rollba=
ck
>>>>>>>>(txID: #2323)
>>>>>>>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: <=3D Transaction.rollba=
ck
>>>>>>>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: =3D>
>>>>>>>>MessageServiceHandler.getNextUndeliveredMessage
>>>>>>>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: =3D>
>>>>>>>>MessageServer.getUndeliveredMessages
>>>>>>>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: =3D>
>>>>>>>>DbConnectionPool.getConnection
>>>>>>>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: =3D>
>>>>>>>>DbConnectionPool.createConnection
>>>>>>>>
>>>>>>>>
>>>>>>>>After the connection is restored MSH do not seem to get a proper
>>>>>>>>connection.
>>>>>>>>This occurs then in the MSH_Client.log:
>>>>>>>>
>>>>>>>>2005-06-21 09:13:42,384 ERROR [Thread-8]: [10306] Cannot create D=
B
>>>>>>>>connection
>>>>>>>>Exception: java.sql.SQLException Message: Network error
>>>>>>>>IOException: Connection refused: connect
>>>>>>>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: =3D> Transaction.rollba=
ck
>>>>>>>>(txID: #2338)
>>>>>>>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: <=3D Transaction.rollba=
ck
>>>>>>>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: =3D>
>>>>>>>>MessageServiceHandler.getNextUndeliveredMessage
>>>>>>>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: =3D>
>>>>>>>>MessageServer.getUndeliveredMessages
>>>>>>>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: =3D>
>>>>>>>>DbConnectionPool.getConnection
>>>>>>>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: =3D>
>>>>>>>>DbConnectionPool.createConnection
>>>>>>>>2005-06-21 09:13:43,384 ERROR [Thread-8]: [10306] Cannot create D=
B
>>>>>>>>connection
>>>>>>>>Exception: java.sql.SQLException
>>>>>>>>Message: Network error IOException: Connection refused: connect
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>When i try to send a message through MSH i get this:
>>>>>>>>hk.hku.cecid.phoenix.message.handler.RequestException:
>>>>>>>>Failed to send query to MSH.
>>>>>>>>HTTP response code =3D 200
>>>>>>>>HTTP response message =3D OK
>>>>>>>>   at
>>>>>>>>hk.hku.cecid.phoenix.message.handler.Request.expectMapResponse(Un=
known
>>>>>>>>Source)
>>>>>>>>   at
>>>>>>>>hk.hku.cecid.phoenix.message.handler.Request.sendMessageServiceHa=
ndlerConfig(Unknown
>>>>>>>>Source)
>>>>>>>>   at
>>>>>>>>hk.hku.cecid.phoenix.message.handler.Request.register(Unknown Sou=
rce)
>>>>>>>>   at hk.hku.cecid.phoenix.message.handler.Request.<init>(Unknown
>>>>>>>>Source)
>>>>>>>>   at hk.hku.cecid.phoenix.message.handler.Request.<init>(Unknown
>>>>>>>>Source)
>>>>>>>>   at
>>>>>>>>com.mysupply.ebxi.msh.MessageManager.sendMessage(MessageManager.j=
ava:149)
>>>>>>>>
>>>>>>>>
>>>>>>>>And of course I can not receive any messages through MSH either.
>>>>>>>>
>>>>>>>>Does anybody have the same problems, after a lost database
>>>>>>>>connection? The other part of my application that uses MSH, is
>>>>>>>>right back in action when the database connection is restored, bu=
t
>>>>>>>>not MSH.
>>>>>>>>
>>>>>>>>The app is running on jboss-4.0.1 (Tomcat 5.0.28), Java
>>>>>>>>jdk1.5.0_01. The database is Microsofts MSSQL 2000. The driver fo=
r
>>>>>>>>MSSQL is JTDS 1.0.
>>>>>>>>I have added this:
>>>>>>>><check-valid-connection-sql>select * from
>>>>>>>>some_table</check-valid-connection-sql>
>>>>>>>>to my datasource file: mssql-ds.xml which is deployed along with
>>>>>>>>msh.war.
>>>>>>>>
>>>>>>>>Everything is working fine, for days, until I loose the database
>>>>>>>>connection for a few minutes.
>>>>>>>>
>>>>>>>>_________________________________________________________________
>>>>>>>>Del din verden med MSN Spaces  http://spaces.msn.com
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>-------------------------------------------------------
>>>>>>>>SF.Net email is sponsored by: Discover Easy Linux Migration Strat=
egies
>>>>>>>>
>>>>>>>>
>>>>>>>>from IBM. Find simple to follow Roadmaps, straightforward article=
s,
>>>>>>>
>>>>>>>
>>>>>>>>informative Webcasts and more! Get everything you need to get up =
to
>>>>>>>>speed, fast. http://ads.osdn.com/?ad_id=3D7477&alloc_id=3D16492&o=
p=3Dclick
>>>>>>>>_______________________________________________
>>>>>>>>ebxmlms-general mailing list
>>>>>>>>ebx...@li...
>>>>>>>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>_________________________________________________________________
>>>>>>Undg=E5 pop-ups med MSN Toolbar -  http://toolbar.msn.dk/ hent den =
gratis!
>>>>>>
>>>>>>
>>>>>>
>>>>>>-------------------------------------------------------
>>>>>>SF.Net email is sponsored by: Discover Easy Linux Migration Strateg=
ies
>>>>>>
>>>>>>
>>>>>>from IBM. Find simple to follow Roadmaps, straightforward articles,
>>>>>
>>>>>
>>>>>>informative Webcasts and more! Get everything you need to get up to
>>>>>>speed, fast. http://ads.osdn.com/?ad_id=3D7477&alloc_id=3D16492&op=3D=
click
>>>>>>_______________________________________________
>>>>>>ebxmlms-general mailing list
>>>>>>ebx...@li...
>>>>>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>-------------------------------------------------------
>>>>>SF.Net email is sponsored by: Discover Easy Linux Migration Strategi=
es
>>>>>
>>>>>
>>>>>from IBM. Find simple to follow Roadmaps, straightforward articles,
>>>>
>>>>
>>>>>informative Webcasts and more! Get everything you need to get up to
>>>>>speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id=16492&op=CCk
>>>>>_______________________________________________
>>>>>ebxmlms-general mailing list
>>>>>ebx...@li...
>>>>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>-------------------------------------------------------
>>>>SF.Net email is sponsored by: Discover Easy Linux Migration Strategie=
s
>>>>
>>>>
>>>>from IBM. Find simple to follow Roadmaps, straightforward articles,
>>>
>>>
>>>>informative Webcasts and more! Get everything you need to get up to
>>>>speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id=16492&op=CCk
>>>>_______________________________________________
>>>>ebxmlms-general mailing list
>>>>ebx...@li...
>>>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>-------------------------------------------------------
>>SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
>>from IBM. Find simple to follow Roadmaps, straightforward articles,
>>informative Webcasts and more! Get everything you need to get up to
>>speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id=16492&op=3Dick
>>_______________________________________________
>>ebxmlms-general mailing list
>>ebx...@li...
>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>
>>
>>-------------------------------------------------------
>>SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
>>from IBM. Find simple to follow Roadmaps, straightforward articles,
>>informative Webcasts and more! Get everything you need to get up to
>>speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id=16492&op=CCk
>>_______________________________________________
>>ebxmlms-general mailing list
>>ebx...@li...
>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>
>>
>>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id=16492&op=CCk
> _______________________________________________
> ebxmlms-general mailing list
> ebx...@li...
> https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>
>


--=20
Kijk niet terug, maar kijk naar mij
Against all odds

Re: [ebxmlms-general] no primary key on sent and received message

[Patrick Y. <kc...@ce...>]

We welcome this and we are also willing to make the changes to the main 
trunk after reviewing the code. What do you guys think?

Regards,
Patrick Yee
Center for E-Commerce Infrastructure Development

Making E-Commerce Everyday Commerce



Ronald van Kuijk wrote:

>That's why I do it internally first (wil not go into production if HKU does not allow it) and will
>not even be a branch if they do not allow it. So I will totally obey the license. I hope I can
>show once it is finished that is is step forward.
>
>Ronald
>
>Steven Herod probeerde me het volgende duidelijk te maken:
>  
>
>>You are talking about significant changes here (they are welcome from my perspective however)
>>
>>But this is a branch of the hermes source code, how does HKU feel :)
>>
>>-----Original Message-----
>>From: ebx...@li...
>>[mailto:ebx...@li...] On Behalf Of Ronald van Kuijk
>>Sent: Thursday, 7 July 2005 12:19 PM
>>To: ebx...@li...
>>Subject: RE: [ebxmlms-general] no primary key on sent and received message
>>
>>All the tables which did not have a primary key (sentmessage, receivedmessage). I made the
>>messageid columns the primary key.
>>
>>And now I'm experimenting a little, for 3 tables there are already classes that can be used for
>>persistency with some small changes
>>(ApplicationContext, MessageServiceHandlerConfig, EbxmlMessage
>>
>>I've made up my mind and (at least for myself since I do not know what the license says) will try
>>to rewrite the persistency layer
>>completely. This means:
>>- get rid of DBTableManager
>>- clean up all classes that use these prepaired statement things
>>- get rid of the proprietary connectionpool
>>- store the messages in a blob as long as there is no alternative (JTA/JCA compliant) file store
>>
>>This would make the code much more readably and have a persistency layer which is much easier to
>>maintain (by others).
>>
>>There are some questions I already have. One simple, but important one is if messagestore and
>>messageinfo could be combined. I've
>>looked a little and could not find a reason to keep them separate (but it is now 04:17, so I do
>>not see clearly anymore ;-))
>>
>>Ronald
>>
>>p.s. more will follow.......
>>
>>
>>Steven Herod probeerde me het volgende duidelijk te maken:
>>    
>>
>>>I've generated hibernate classes myself for hermes and added my own 'id' column definitions.
>>>
>>>Which tables?
>>>
>>>-----Original Message-----
>>>From: ebx...@li...
>>>[mailto:ebx...@li...] On Behalf Of
>>>Ronald van Kuijk
>>>Sent: Wednesday, 6 July 2005 9:44 PM
>>>To: ebx...@li...
>>>Subject: [ebxmlms-general] no primary key on sent and received message
>>>
>>>I'm trying to reverse generate some components for accessing the DB
>>>using hibernate (from within exadel studio). This works nice, but for
>>>two tables there are no classes generated. This seems to be related to
>>>the fact that these two tables do not have primary keys.
>>>
>>>Question: Can they have primarykeys and if so which columns
>>>
>>>My guess: Yes, compound c_time and c_messageid or maybe even single
>>>c_messageid
>>>
>>>Thanks,
>>>
>>>Ronald
>>>
>>>
>>>
>>>
>>>-------------------------------------------------------
>>>SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
>>>from IBM. Find simple to follow Roadmaps, straightforward articles,
>>>informative Webcasts and more! Get everything you need to get up to speed, fast.
>>>http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
>>>_______________________________________________
>>>ebxmlms-general mailing list
>>>ebx...@li...
>>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>>
>>>
>>>
>>>-------------------------------------------------------
>>>SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
>>>from IBM. Find simple to follow Roadmaps, straightforward articles,
>>>informative Webcasts and more! Get everything you need to get up to
>>>speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
>>>_______________________________________________
>>>ebxmlms-general mailing list
>>>ebx...@li...
>>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>>
>>>      
>>>
>>--
>>Kijk niet terug, maar kijk naar mij
>>Against all odds
>>
>>
>>
>>-------------------------------------------------------
>>SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
>>from IBM. Find simple to follow Roadmaps, straightforward articles,
>>informative Webcasts and more! Get everything you need to get up to
>>speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
>>_______________________________________________
>>ebxmlms-general mailing list
>>ebx...@li...
>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>
>>
>>
>>-------------------------------------------------------
>>SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
>>from IBM. Find simple to follow Roadmaps, straightforward articles,
>>informative Webcasts and more! Get everything you need to get up to
>>speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
>>_______________________________________________
>>ebxmlms-general mailing list
>>ebx...@li...
>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>
>>    
>>
>
>
>  
>

Re: [ebxmlms-general] no primary key on sent and received message

[Patrick Y. <kc...@ce...>]

:-) They can be combined. The reason is that we originally only had 
messagestore. And later we wanted to add more columns to it but at the 
same time we would like to keep the original table structure due to some 
early deployment issues.

Regards,
Patrick Yee
Center for E-Commerce Infrastructure Development

Making E-Commerce Everyday Commerce



Ronald van Kuijk wrote:

>All the tables which did not have a primary key (sentmessage, receivedmessage). I made the
>messageid columns the primary key.
>
>And now I'm experimenting a little, for 3 tables there are already classes that can be used for
>persistency with some small changes (ApplicationContext, MessageServiceHandlerConfig, EbxmlMessage
>
>I've made up my mind and (at least for myself since I do not know what the license says) will try
>to rewrite the persistency layer completely. This means:
>- get rid of DBTableManager
>- clean up all classes that use these prepaired statement things
>- get rid of the proprietary connectionpool
>- store the messages in a blob as long as there is no alternative (JTA/JCA compliant) file store
>
>This would make the code much more readably and have a persistency layer which is much easier to
>maintain (by others).
>
>There are some questions I already have. One simple, but important one is if messagestore and
>messageinfo could be combined. I've looked a little and could not find a reason to keep them
>separate (but it is now 04:17, so I do not see clearly anymore ;-))
>
>Ronald
>
>p.s. more will follow.......
>
>
>Steven Herod probeerde me het volgende duidelijk te maken:
>  
>
>>I've generated hibernate classes myself for hermes and added my own 'id' column definitions.
>>
>>Which tables?
>>
>>-----Original Message-----
>>From: ebx...@li...
>>[mailto:ebx...@li...] On Behalf Of Ronald van Kuijk
>>Sent: Wednesday, 6 July 2005 9:44 PM
>>To: ebx...@li...
>>Subject: [ebxmlms-general] no primary key on sent and received message
>>
>>I'm trying to reverse generate some components for accessing the DB using hibernate (from within
>>exadel studio). This works nice,
>>but for two tables there are no classes generated. This seems to be related to the fact that these
>>two tables do not have primary
>>keys.
>>
>>Question: Can they have primarykeys and if so which columns
>>
>>My guess: Yes, compound c_time and c_messageid or maybe even single c_messageid
>>
>>Thanks,
>>
>>Ronald
>>
>>
>>
>>
>>-------------------------------------------------------
>>SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to
>>follow Roadmaps, straightforward
>>articles, informative Webcasts and more! Get everything you need to get up to speed, fast.
>>http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
>>_______________________________________________
>>ebxmlms-general mailing list
>>ebx...@li...
>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>
>>
>>
>>-------------------------------------------------------
>>SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
>>from IBM. Find simple to follow Roadmaps, straightforward articles,
>>informative Webcasts and more! Get everything you need to get up to
>>speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
>>_______________________________________________
>>ebxmlms-general mailing list
>>ebx...@li...
>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>
>>    
>>
>
>
>  
>

Re: [ebxmlms-general] Connectionpooling and transactions

[Patrick Y. <kc...@ce...>]

By the time we were designing Hermes, Hibernate is not that well=20
considered... (yes, the other way to interpret this is, we are quite=20
closed in terms of employing other libraries). I think your opinion is a=20
good one.

Regards,
Patrick Yee
Center for E-Commerce Infrastructure Development

Making E-Commerce Everyday Commerce



R. van Kuijk (Ronald) wrote:

>Hmm... I missed the option to redirect file persistence to a database. I=
'll have a look. With 'still it is not transaction-aware' you mean that t=
he filepersistence is not really transaction aware? There are some 'in vm=
-locking mechamisms' in there but no real commit/rollback etc. Would that=
 be needed? Kind of difficult, but I'll see.
>
>Ok, another question. I have a fairly clear picture of the front-end mes=
sageserver, messageservicehandler etc and how the command parsing works. =
In addition to that, I dug a little bit deeper into hermes again especial=
ly the DBTableManager classes etc. If it is possible I'd like to get some=
 info on the architectural choices that were made to come to such a solut=
ion. It looks like it is some persistence mapping, for which there curren=
tly are very nice out-of-the-box solutions (think hibernate). IMVVHO (it =
is a very, very humble one) this would also be a nice change and would ma=
ke it possible to support more databases.=20
>
>I'll try to work something out which makes it possible to store messages=
 in either a file or a database (configurable?)
>
>
>-----Oorspronkelijk bericht-----
>Van: ebx...@li... [mailto:ebxmlms-general=
-ad...@li...] Namens Patrick Yee
>Verzonden: woensdag 6 juli 2005 4:02
>Aan: ebx...@li...
>Onderwerp: Re: [ebxmlms-general] Connectionpooling and transactions. was=
: Problems after lost connection to database
>
>Now, Hermes supports a custom way (API) to redirect the file persistence=
=20
>to database. However, still it is not transaction-aware. So we may need=20
>to modify that API as well. What do you think?
>Regards, -Patrick
>
>
>Ronald van Kuijk wrote:
>
> =20
>
>>Sounds interesting. But with regard to this immediately a second questi=
on comes to mind. There is
>>also a transactionmechanism in place which does a kind of xa over a dat=
abase and a filesystem.
>>This makes it almost impossible to use the default JTA for this, which =
would make the hermes core
>>even smaller. For our company, storing the messages in a DB as a blob i=
s not a problem since we
>>require clustering and failover any way. It is in fact even a requireme=
nt unless there would be a
>>JTA compatible filesystem persistency layer (JCA?)).
>>
>>Replacing the DBConnectionPool with a standard based solution can be do=
ne by me, since I've done
>>it before and probably have the code somewhere. DBCP does not have to b=
e provided then, since all
>>servlet engines and j2ee servers contain one. But regarding the file pe=
rsistency I'd like to get a
>>response from more users since that is another issue.
>>
>>Comments?
>>
>>
>>Patrick Yee probeerde me het volgende duidelijk te maken:
>>=20
>>
>>   =20
>>
>>>There is no strict reason for using our own implementation. So it woul=
d
>>>be good to have some contribution to port Hermes to make use of other
>>>database pool, like DBCP.
>>>Regards, -Patrick
>>>
>>>Regards, -Patrick
>>>
>>>
>>>Mattias J wrote:
>>>
>>>  =20
>>>
>>>     =20
>>>
>>>>Yes, why not include for example Jakarta Commons DBCP?
>>>>
>>>>At 2005-06-27 09:29, you wrote:
>>>>
>>>>    =20
>>>>
>>>>       =20
>>>>
>>>>>I guess the problem is that you have implemented your own
>>>>>databasepool, without sophisticated recovery mechanism.
>>>>>Our own application use javax.sql.DataSource, to get a connection. I
>>>>>guess there is a recovery mechanism in that solution, as our own
>>>>>application runs fine when the connection gets back.
>>>>>Is there anyway to use javax.sql.DataSource instead of your
>>>>>implementation of the connection pool? I guess my question is more t=
o
>>>>>why you are using your own implemtation, are you using some extra
>>>>>stuff, I can't get from javax.sql.DataSource?
>>>>>
>>>>>Regards Kenneth
>>>>>
>>>>>      =20
>>>>>
>>>>>         =20
>>>>>
>>>>>>From: Patrick Yee <kc...@ce...>
>>>>>>To: ebx...@li...
>>>>>>CC: tr...@ho...
>>>>>>Subject: Re: [ebxmlms-general] Problems after lost connection to
>>>>>>database
>>>>>>Date: Sun, 26 Jun 2005 19:19:35 +0800
>>>>>>
>>>>>>We have not implemented a sophisticated recovery mechanism in the
>>>>>>database connection pool. The only mechanism we have done is,
>>>>>>whenever a connection is proved to be bad, we will not put it back
>>>>>>to the connection pool. Actually there was a suggestion some time
>>>>>>ago that we can do a "select *" on some tables before we use the
>>>>>>pooled database connection. We think that will create certain
>>>>>>performance issue, and so we shelved that idea. Of course, if you
>>>>>>want it, you can just patch the database connection pool classes an=
d
>>>>>>implement any advanced recovery mechanism as you like. :-)
>>>>>>Regards, -Patrick
>>>>>>
>>>>>>
>>>>>>Kenneth Pedersen wrote:
>>>>>>
>>>>>>        =20
>>>>>>
>>>>>>           =20
>>>>>>
>>>>>>>Hi
>>>>>>>
>>>>>>>If I loose the connection to my database for a short time
>>>>>>>(1-2minutes), MSH do not operate properly afterwards.
>>>>>>>
>>>>>>>When the connection is lost this occurs in the MSH_client.log:
>>>>>>>
>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D>
>>>>>>>DbConnectionPool.getConnection
>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: <=3D
>>>>>>>DbConnectionPool.getConnection
>>>>>>>2005-06-21 09:13:34,384 ERROR [Thread-8]: [10002] Unknown error
>>>>>>>Exception: java.sql.SQLException
>>>>>>>Message: I/O Error: Connection reset by peer: socket write error
>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D> Transaction.rollbac=
k
>>>>>>>(txID: #2321)
>>>>>>>2005-06-21 09:13:34,384 ERROR [Thread-8]: [10315] Cannot rollback
>>>>>>>DB changes
>>>>>>>Exception: java.sql.SQLException
>>>>>>>Message: Invalid state, the Connection object is closed.
>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D>
>>>>>>>DbConnectionPool.freeConnection
>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: <=3D
>>>>>>>DbConnectionPool.freeConnection
>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: <=3D Transaction.rollbac=
k
>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D>
>>>>>>>MessageServiceHandler.getNextUndeliveredMessage
>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D>
>>>>>>>MessageServer.getUndeliveredMessages
>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D>
>>>>>>>DbConnectionPool.getConnection
>>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D>
>>>>>>>DbConnectionPool.createConnection
>>>>>>>2005-06-21 09:13:35,352 ERROR [Thread-8]: [10306] Cannot create DB
>>>>>>>connection Exception: java.sql.SQLException Message: Network error
>>>>>>>IOException: Connection refused: connect
>>>>>>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: =3D> Transaction.rollbac=
k
>>>>>>>(txID: #2323)
>>>>>>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: <=3D Transaction.rollbac=
k
>>>>>>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: =3D>
>>>>>>>MessageServiceHandler.getNextUndeliveredMessage
>>>>>>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: =3D>
>>>>>>>MessageServer.getUndeliveredMessages
>>>>>>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: =3D>
>>>>>>>DbConnectionPool.getConnection
>>>>>>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: =3D>
>>>>>>>DbConnectionPool.createConnection
>>>>>>>
>>>>>>>
>>>>>>>After the connection is restored MSH do not seem to get a proper
>>>>>>>connection.
>>>>>>>This occurs then in the MSH_Client.log:
>>>>>>>
>>>>>>>2005-06-21 09:13:42,384 ERROR [Thread-8]: [10306] Cannot create DB
>>>>>>>connection
>>>>>>>Exception: java.sql.SQLException Message: Network error
>>>>>>>IOException: Connection refused: connect
>>>>>>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: =3D> Transaction.rollbac=
k
>>>>>>>(txID: #2338)
>>>>>>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: <=3D Transaction.rollbac=
k
>>>>>>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: =3D>
>>>>>>>MessageServiceHandler.getNextUndeliveredMessage
>>>>>>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: =3D>
>>>>>>>MessageServer.getUndeliveredMessages
>>>>>>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: =3D>
>>>>>>>DbConnectionPool.getConnection
>>>>>>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: =3D>
>>>>>>>DbConnectionPool.createConnection
>>>>>>>2005-06-21 09:13:43,384 ERROR [Thread-8]: [10306] Cannot create DB
>>>>>>>connection
>>>>>>>Exception: java.sql.SQLException
>>>>>>>Message: Network error IOException: Connection refused: connect
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>When i try to send a message through MSH i get this:
>>>>>>>hk.hku.cecid.phoenix.message.handler.RequestException:
>>>>>>>Failed to send query to MSH.
>>>>>>>HTTP response code =3D 200
>>>>>>>HTTP response message =3D OK
>>>>>>>   at
>>>>>>>hk.hku.cecid.phoenix.message.handler.Request.expectMapResponse(Unk=
nown
>>>>>>>Source)
>>>>>>>   at
>>>>>>>hk.hku.cecid.phoenix.message.handler.Request.sendMessageServiceHan=
dlerConfig(Unknown
>>>>>>>Source)
>>>>>>>   at
>>>>>>>hk.hku.cecid.phoenix.message.handler.Request.register(Unknown Sour=
ce)
>>>>>>>   at hk.hku.cecid.phoenix.message.handler.Request.<init>(Unknown
>>>>>>>Source)
>>>>>>>   at hk.hku.cecid.phoenix.message.handler.Request.<init>(Unknown
>>>>>>>Source)
>>>>>>>   at
>>>>>>>com.mysupply.ebxi.msh.MessageManager.sendMessage(MessageManager.ja=
va:149)
>>>>>>>
>>>>>>>
>>>>>>>And of course I can not receive any messages through MSH either.
>>>>>>>
>>>>>>>Does anybody have the same problems, after a lost database
>>>>>>>connection? The other part of my application that uses MSH, is
>>>>>>>right back in action when the database connection is restored, but
>>>>>>>not MSH.
>>>>>>>
>>>>>>>The app is running on jboss-4.0.1 (Tomcat 5.0.28), Java
>>>>>>>jdk1.5.0_01. The database is Microsofts MSSQL 2000. The driver for
>>>>>>>MSSQL is JTDS 1.0.
>>>>>>>I have added this:
>>>>>>><check-valid-connection-sql>select * from
>>>>>>>some_table</check-valid-connection-sql>
>>>>>>>to my datasource file: mssql-ds.xml which is deployed along with
>>>>>>>msh.war.
>>>>>>>
>>>>>>>Everything is working fine, for days, until I loose the database
>>>>>>>connection for a few minutes.
>>>>>>>
>>>>>>>_________________________________________________________________
>>>>>>>Del din verden med MSN Spaces  http://spaces.msn.com
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>-------------------------------------------------------
>>>>>>>SF.Net email is sponsored by: Discover Easy Linux Migration Strate=
gies
>>>>>>>             =20
>>>>>>>
>>>>>>>from IBM. Find simple to follow Roadmaps, straightforward articles=
,
>>>>>>           =20
>>>>>>
>>>>>>>informative Webcasts and more! Get everything you need to get up t=
o
>>>>>>>speed, fast. http://ads.osdn.com/?ad_id=3D7477&alloc_id=3D16492&op=
=3Dclick
>>>>>>>_______________________________________________
>>>>>>>ebxmlms-general mailing list
>>>>>>>ebx...@li...
>>>>>>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>>>>>>          =20
>>>>>>>
>>>>>>>             =20
>>>>>>>
>>>>>>        =20
>>>>>>
>>>>>>           =20
>>>>>>
>>>>>_________________________________________________________________
>>>>>Undg=E5 pop-ups med MSN Toolbar -  http://toolbar.msn.dk/ hent den g=
ratis!
>>>>>
>>>>>
>>>>>
>>>>>-------------------------------------------------------
>>>>>SF.Net email is sponsored by: Discover Easy Linux Migration Strategi=
es
>>>>>         =20
>>>>>
>>>>>from IBM. Find simple to follow Roadmaps, straightforward articles,
>>>>       =20
>>>>
>>>>>informative Webcasts and more! Get everything you need to get up to
>>>>>speed, fast. http://ads.osdn.com/?ad_id=3D7477&alloc_id=3D16492&op=3D=
click
>>>>>_______________________________________________
>>>>>ebxmlms-general mailing list
>>>>>ebx...@li...
>>>>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>>>>      =20
>>>>>
>>>>>         =20
>>>>>
>>>>-------------------------------------------------------
>>>>SF.Net email is sponsored by: Discover Easy Linux Migration Strategie=
s
>>>>       =20
>>>>
>>>>from IBM. Find simple to follow Roadmaps, straightforward articles,
>>>     =20
>>>
>>>>informative Webcasts and more! Get everything you need to get up to
>>>>speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id=16492&op=CCk
>>>>_______________________________________________
>>>>ebxmlms-general mailing list
>>>>ebx...@li...
>>>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>>>
>>>>    =20
>>>>
>>>>       =20
>>>>
>>>-------------------------------------------------------
>>>SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
>>>     =20
>>>
>>>from IBM. Find simple to follow Roadmaps, straightforward articles,
>>   =20
>>
>>>informative Webcasts and more! Get everything you need to get up to
>>>speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id=16492&op=CCk
>>>_______________________________________________
>>>ebxmlms-general mailing list
>>>ebx...@li...
>>>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>>
>>>
>>>  =20
>>>
>>>     =20
>>>
>>=20
>>
>>   =20
>>
>
>
>
>-------------------------------------------------------
>SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
>from IBM. Find simple to follow Roadmaps, straightforward articles,
>informative Webcasts and more! Get everything you need to get up to
>speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id=16492&op=3Dick
>_______________________________________________
>ebxmlms-general mailing list
>ebx...@li...
>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>
>
>-------------------------------------------------------
>SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
>from IBM. Find simple to follow Roadmaps, straightforward articles,
>informative Webcasts and more! Get everything you need to get up to
>speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id=16492&op=CCk
>_______________________________________________
>ebxmlms-general mailing list
>ebx...@li...
>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>
> =20
>

Re: [ebxmlms-general] https proxy

[Ronald v. K. <rtv...@xs...>]

Yes there is. If *you* extend hermes and pass the properties via the hermes there is a more
elegant solution. If extending it is not an option, I'm afraid you have to stick with the
commandline options.
Andeas Hausleitner probeerde me het volgende duidelijk te maken:
>
> I tried to use the proxy settings as to be configured in
> msh.properties.xml (using the element <Proxy>).
> The proxy settings will work for HTTP connection but it is ignored for
> HTTPS connections.
> The workaround I found is to set the Java system properties for tomcat
> (if used as servlet/jsp engine) using JAVA_OPTS=-Dhttps.proxyHost=host
> -Dhttps.proxyPort=port.
>
> Is there a more elegant way to set the proxy for HTTPS connections with
> hermes?
>
> Thanks,
> Andreas
>
> --
> ------------------------------------------
> Andreas Hausleitner, DI
> Software Developement
>
> enerbility software gmbh
> Burggasse 116/14
> A-1070 Wien
>
> email:  and...@en...
> http:   www.enerbility.com
> ------------------------------------------
>
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by the 'Do More With Dual!' webinar happening
> July 14 at 8am PDT/11am EDT. We invite you to explore the latest in dual
> core and dual graphics technology at this free one hour event hosted by HP,
> AMD, and NVIDIA.  To register visit http://www.hp.com/go/dualwebinar
> _______________________________________________
> ebxmlms-general mailing list
> ebx...@li...
> https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>


-- 
Kijk niet terug, maar kijk naar mij
Against all odds

[ebxmlms-general] https proxy

[Andeas H. <and...@en...>]

I tried to use the proxy settings as to be configured in
msh.properties.xml (using the element <Proxy>).
The proxy settings will work for HTTP connection but it is ignored for
HTTPS connections.
The workaround I found is to set the Java system properties for tomcat
(if used as servlet/jsp engine) using JAVA_OPTS=-Dhttps.proxyHost=host
-Dhttps.proxyPort=port.

Is there a more elegant way to set the proxy for HTTPS connections with
hermes?

Thanks,
Andreas

-- 
------------------------------------------
Andreas Hausleitner, DI
Software Developement

enerbility software gmbh
Burggasse 116/14
A-1070 Wien

email:  and...@en...
http:   www.enerbility.com
------------------------------------------

[ebxmlms-general] help with getReceivedMessageIds()

[Christopher G. M. <chr...@gm...>]

getReceivedMessageIds() always return null.  I have set up hermes on
one machine.
When I use the code found in=20
http://sourceforge.net/mailarchive/message.php?msg_id=3D10941613
The program does not get any messages.  I just copied the code as-is
and nothing happens, even after a loopback message was sent.

When I use the Loopback sample code it=20
can send a test message then when the class is run again it does get
the MessageErrors
that are generated by the msh.

Thanks.

RE: [ebxmlms-general] no primary key on sent and received message

[Mattias J <mj...@ex...>]

Sounds pretty interesting. The highly proprietary internals of Hermes 
makes it hard to extend. Building on well known technologies like 
Hibernate and JTA would make it much easier to create (and 
contribute) reporting and monitoring services.

At 2005-07-07 10:06, you wrote:
>If read the license and it is rather free.... I myself do not want a
>fork, since it will be two codebases to maintain and that is not the way
>to go. I like the people at the HKU to much to make a fuzz out of this,
>so If they do not like it, I'll abandon this path.
>
>Thanks for the offer, I'll try to see if I can put up a cvs or svn
>somewhere (closed, not accessible by others) so some designated people
>can watch the progress and possibly participate.
>
>Ronald
>
>-----Oorspronkelijk bericht-----
>Van: ebx...@li...
>[mailto:ebx...@li...] Namens Steven Herod
>Verzonden: donderdag 7 juli 2005 8:57
>Aan: ebx...@li...
>Onderwerp: RE: [ebxmlms-general] no primary key on sent and received
>message
>
>Its not so much the licensing, which I think is 'do what you want'
>
>If you need any help, let me know, I've been looking into the hibernate
>thing with hermes as part of a web based tracking tool I've
>been trying to build for tracking hermes messages.
>
>-----Original Message-----
>From: ebx...@li...
>[mailto:ebx...@li...] On Behalf Of Ronald
>van Kuijk
>Sent: Thursday, 7 July 2005 4:36 PM
>To: ebx...@li...
>Subject: RE: [ebxmlms-general] no primary key on sent and received
>message
>
>That's why I do it internally first (wil not go into production if HKU
>does not allow it) and will not even be a branch if they do
>not allow it. So I will totally obey the license. I hope I can show once
>it is finished that is is step forward.
>
>Ronald
>
>Steven Herod probeerde me het volgende duidelijk te maken:
> > You are talking about significant changes here (they are welcome from
> > my perspective however)
> >
> > But this is a branch of the hermes source code, how does HKU feel :)
> >
> > -----Original Message-----
> > From: ebx...@li...
> > [mailto:ebx...@li...] On Behalf Of
> > Ronald van Kuijk
> > Sent: Thursday, 7 July 2005 12:19 PM
> > To: ebx...@li...
> > Subject: RE: [ebxmlms-general] no primary key on sent and received
> > message
> >
> > All the tables which did not have a primary key (sentmessage,
> > receivedmessage). I made the messageid columns the primary key.
> >
> > And now I'm experimenting a little, for 3 tables there are already
> > classes that can be used for persistency with some small changes
> > (ApplicationContext, MessageServiceHandlerConfig, EbxmlMessage
> >
> > I've made up my mind and (at least for myself since I do not know what
>
> > the license says) will try to rewrite the persistency layer
> > completely. This means:
> > - get rid of DBTableManager
> > - clean up all classes that use these prepaired statement things
> > - get rid of the proprietary connectionpool
> > - store the messages in a blob as long as there is no alternative
> > (JTA/JCA compliant) file store
> >
> > This would make the code much more readably and have a persistency
> > layer which is much easier to maintain (by others).
> >
> > There are some questions I already have. One simple, but important one
>
> > is if messagestore and messageinfo could be combined. I've looked a
> > little and could not find a reason to keep them separate (but it is
> > now 04:17, so I do not see clearly anymore ;-))
> >
> > Ronald
> >
> > p.s. more will follow.......
> >
> >
> > Steven Herod probeerde me het volgende duidelijk te maken:
> >> I've generated hibernate classes myself for hermes and added my own
>'id' column definitions.
> >>
> >> Which tables?
> >>
> >> -----Original Message-----
> >> From: ebx...@li...
> >> [mailto:ebx...@li...] On Behalf Of
> >> Ronald van Kuijk
> >> Sent: Wednesday, 6 July 2005 9:44 PM
> >> To: ebx...@li...
> >> Subject: [ebxmlms-general] no primary key on sent and received
> >> message
> >>
> >> I'm trying to reverse generate some components for accessing the DB
> >> using hibernate (from within exadel studio). This works nice, but for
>
> >> two tables there are no classes generated. This seems to be related
> >> to the fact that these two tables do not have primary keys.
> >>
> >> Question: Can they have primarykeys and if so which columns
> >>
> >> My guess: Yes, compound c_time and c_messageid or maybe even single
> >> c_messageid
> >>
> >> Thanks,
> >>
> >> Ronald

[ebxmlms-general] Hermes Selected Best Infrastructure Building and Communication Application by Linux Business Award 2005]]

[Dorris T. <cw...@ce...>]

Hermes Selected Best Infrastructure Building and Communication Applicatio=
n
by Linux Business Award 2005

Hong Kong SAR, Peoples Republic of China =E2=80=93 July 7, 2005 =E2=80=93=
 Center for=20
E-Commerce Infrastructure Development (CECID), University of Hong Kong=20
(HKU) is pleased to announce that our open source ebXML=20
business-to-business (B2B) Messaging Server, Hermes, has won the Grand=20
Award in Infrastructure Building and Communication Application of Hong=20
Kong Linux Business Award 2005=20
<http://www.hitechweekly.com/linuxaward2005.htm>. Companies and products=20
competed under Business Adoption Award and Product Development Award in=20
sub-categories of Enterprise Business Application; Infrastructure=20
Building and Communication Application; Industry Based Application and=20
Linux Appliance resulting in four Grand Award and 10 Merit Award winners.

Organized by the HKSAR Office of the Government Chief Information=20
Officer, Hong Kong Productivity Council and Hong Kong Linux Industry=20
Association, Linux Business Award aims to educate and motivate=20
enterprises in deploying IT application on Linux platform. Five entries=20
were shortlisted to the final stage of Product Development Award=E2=80=99=
s=20
Infrastructure Building and Communication Application category. Based on=20
innovativeness and technology, deployment scale and scope, quality, cost=20
effectiveness and benefits to society, Hermes came up with the top score=20
to win the Grand Award. Two Merit Awards were also granted in this=20
category.

Hermes Business-to-Business (B2B) Messaging Server is an open-source=20
Message Service Handler embracing an e-commerce open standard (OASIS=20
ebXML Messaging Service v.2.0). This award-winning product provides a=20
standardized, reliable and secure infrastructure for enterprises to=20
exchange business data on the Internet. Developers from 80+ economies=20
have already downloaded Hermes=E2=80=99 source code since its release thr=
ee=20
years ago, and Hermes has many successful deployments. Some local users=20
of Hermes include MTR, OOCL, Sony, HMV, bigboXX.com and HKSAR=20
Government. Besides certified for ebXML and AS2 interoperability, Hermes=20
has won Certificates of Merit (Product Category) at the 6th HK Computer=20
Society IT Excellence Awards and Asia Pacific ICT Award 2004 (R&D=20
Category). Hermes is available for free from http://www.freebxml.org=20
<http://www.freebxml.org/>.

About CECID (www.cecid.hku.hk <http://www.cecid.hku.hk>)

Established in January 2002, Center for E-Commerce Infrastructure=20
Development (CECID) at the University of Hong Kong conducts e-commerce=20
research and development with the vision of helping organizations=20
increase their competitiveness in the global economy. CECID develops=20
e-commerce enabling technologies, participates in important=20
international e-commerce initiatives, supports e-commerce=20
standardization for Hong Kong and the Asia Pacific Region, and transfers=20
e-commerce technology and skills to the community. With projects=20
primarily funded by the Hong Kong Government's Innovation and Technology=20
Commission, CECID is an active member of OASIS and the ebXML Asia=20
Committee. The Center also collaborates with a number of lead technology=20
users in the Asia-Pacific.

PR Contacts for Press and Analysts=EF=BC=9A
Dorris Tai
Business Manager, Center for E-Commerce Infrastructure Development
Tel: +852 2859 2818
Fax: +852 2547 4611
e-M...@ce...
URL=EF=BC=9Ahttp://www.cecid.hku.hk

RE: [ebxmlms-general] no primary key on sent and received message

[R. v. K. \(Ronald\) <rv...@ab...>]

If read the license and it is rather free.... I myself do not want a
fork, since it will be two codebases to maintain and that is not the way
to go. I like the people at the HKU to much to make a fuzz out of this,
so If they do not like it, I'll abandon this path.

Thanks for the offer, I'll try to see if I can put up a cvs or svn
somewhere (closed, not accessible by others) so some designated people
can watch the progress and possibly participate.

Ronald

-----Oorspronkelijk bericht-----
Van: ebx...@li...
[mailto:ebx...@li...] Namens Steven Herod
Verzonden: donderdag 7 juli 2005 8:57
Aan: ebx...@li...
Onderwerp: RE: [ebxmlms-general] no primary key on sent and received
message

Its not so much the licensing, which I think is 'do what you want'

If you need any help, let me know, I've been looking into the hibernate
thing with hermes as part of a web based tracking tool I've
been trying to build for tracking hermes messages.

-----Original Message-----
From: ebx...@li...
[mailto:ebx...@li...] On Behalf Of Ronald
van Kuijk
Sent: Thursday, 7 July 2005 4:36 PM
To: ebx...@li...
Subject: RE: [ebxmlms-general] no primary key on sent and received
message

That's why I do it internally first (wil not go into production if HKU
does not allow it) and will not even be a branch if they do
not allow it. So I will totally obey the license. I hope I can show once
it is finished that is is step forward.

Ronald

Steven Herod probeerde me het volgende duidelijk te maken:
> You are talking about significant changes here (they are welcome from 
> my perspective however)
>
> But this is a branch of the hermes source code, how does HKU feel :)
>
> -----Original Message-----
> From: ebx...@li...
> [mailto:ebx...@li...] On Behalf Of 
> Ronald van Kuijk
> Sent: Thursday, 7 July 2005 12:19 PM
> To: ebx...@li...
> Subject: RE: [ebxmlms-general] no primary key on sent and received 
> message
>
> All the tables which did not have a primary key (sentmessage, 
> receivedmessage). I made the messageid columns the primary key.
>
> And now I'm experimenting a little, for 3 tables there are already 
> classes that can be used for persistency with some small changes 
> (ApplicationContext, MessageServiceHandlerConfig, EbxmlMessage
>
> I've made up my mind and (at least for myself since I do not know what

> the license says) will try to rewrite the persistency layer 
> completely. This means:
> - get rid of DBTableManager
> - clean up all classes that use these prepaired statement things
> - get rid of the proprietary connectionpool
> - store the messages in a blob as long as there is no alternative 
> (JTA/JCA compliant) file store
>
> This would make the code much more readably and have a persistency 
> layer which is much easier to maintain (by others).
>
> There are some questions I already have. One simple, but important one

> is if messagestore and messageinfo could be combined. I've looked a 
> little and could not find a reason to keep them separate (but it is 
> now 04:17, so I do not see clearly anymore ;-))
>
> Ronald
>
> p.s. more will follow.......
>
>
> Steven Herod probeerde me het volgende duidelijk te maken:
>> I've generated hibernate classes myself for hermes and added my own
'id' column definitions.
>>
>> Which tables?
>>
>> -----Original Message-----
>> From: ebx...@li...
>> [mailto:ebx...@li...] On Behalf Of 
>> Ronald van Kuijk
>> Sent: Wednesday, 6 July 2005 9:44 PM
>> To: ebx...@li...
>> Subject: [ebxmlms-general] no primary key on sent and received 
>> message
>>
>> I'm trying to reverse generate some components for accessing the DB 
>> using hibernate (from within exadel studio). This works nice, but for

>> two tables there are no classes generated. This seems to be related 
>> to the fact that these two tables do not have primary keys.
>>
>> Question: Can they have primarykeys and if so which columns
>>
>> My guess: Yes, compound c_time and c_messageid or maybe even single 
>> c_messageid
>>
>> Thanks,
>>
>> Ronald
>>
>>
>>
>>
>> -------------------------------------------------------
>> SF.Net email is sponsored by: Discover Easy Linux Migration 
>> Strategies from IBM. Find simple to follow Roadmaps, straightforward 
>> articles, informative Webcasts and more! Get everything you need to
get up to speed, fast.
>> http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
>> _______________________________________________
>> ebxmlms-general mailing list
>> ebx...@li...
>> https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>
>>
>>
>> -------------------------------------------------------
>> SF.Net email is sponsored by: Discover Easy Linux Migration 
>> Strategies from IBM. Find simple to follow Roadmaps, straightforward 
>> articles, informative Webcasts and more! Get everything you need to 
>> get up to speed, fast. 
>> http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
>> _______________________________________________
>> ebxmlms-general mailing list
>> ebx...@li...
>> https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>
>
>
> --
> Kijk niet terug, maar kijk naar mij
> Against all odds
>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies

> from IBM. Find simple to follow Roadmaps, straightforward articles, 
> informative Webcasts and more! Get everything you need to get up to 
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> ebxmlms-general mailing list
> ebx...@li...
> https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies

> from IBM. Find simple to follow Roadmaps, straightforward articles, 
> informative Webcasts and more! Get everything you need to get up to 
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> ebxmlms-general mailing list
> ebx...@li...
> https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>


--
Kijk niet terug, maar kijk naar mij
Against all odds



-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
_______________________________________________
ebxmlms-general mailing list
ebx...@li...
https://lists.sourceforge.net/lists/listinfo/ebxmlms-general



-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
_______________________________________________
ebxmlms-general mailing list
ebx...@li...
https://lists.sourceforge.net/lists/listinfo/ebxmlms-general

RE: [ebxmlms-general] no primary key on sent and received message

[Steven H. <sh...@te...>]

Its not so much the licensing, which I think is 'do what you want'

If you need any help, let me know, I've been looking into the hibernate thing with hermes as part of a web based tracking tool I've
been trying to build for tracking hermes messages.

-----Original Message-----
From: ebx...@li... [mailto:ebx...@li...] On Behalf Of Ronald van Kuijk
Sent: Thursday, 7 July 2005 4:36 PM
To: ebx...@li...
Subject: RE: [ebxmlms-general] no primary key on sent and received message

That's why I do it internally first (wil not go into production if HKU does not allow it) and will not even be a branch if they do
not allow it. So I will totally obey the license. I hope I can show once it is finished that is is step forward.

Ronald

Steven Herod probeerde me het volgende duidelijk te maken:
> You are talking about significant changes here (they are welcome from 
> my perspective however)
>
> But this is a branch of the hermes source code, how does HKU feel :)
>
> -----Original Message-----
> From: ebx...@li...
> [mailto:ebx...@li...] On Behalf Of 
> Ronald van Kuijk
> Sent: Thursday, 7 July 2005 12:19 PM
> To: ebx...@li...
> Subject: RE: [ebxmlms-general] no primary key on sent and received 
> message
>
> All the tables which did not have a primary key (sentmessage, 
> receivedmessage). I made the messageid columns the primary key.
>
> And now I'm experimenting a little, for 3 tables there are already 
> classes that can be used for persistency with some small changes 
> (ApplicationContext, MessageServiceHandlerConfig, EbxmlMessage
>
> I've made up my mind and (at least for myself since I do not know what 
> the license says) will try to rewrite the persistency layer 
> completely. This means:
> - get rid of DBTableManager
> - clean up all classes that use these prepaired statement things
> - get rid of the proprietary connectionpool
> - store the messages in a blob as long as there is no alternative 
> (JTA/JCA compliant) file store
>
> This would make the code much more readably and have a persistency 
> layer which is much easier to maintain (by others).
>
> There are some questions I already have. One simple, but important one 
> is if messagestore and messageinfo could be combined. I've looked a 
> little and could not find a reason to keep them separate (but it is 
> now 04:17, so I do not see clearly anymore ;-))
>
> Ronald
>
> p.s. more will follow.......
>
>
> Steven Herod probeerde me het volgende duidelijk te maken:
>> I've generated hibernate classes myself for hermes and added my own 'id' column definitions.
>>
>> Which tables?
>>
>> -----Original Message-----
>> From: ebx...@li...
>> [mailto:ebx...@li...] On Behalf Of 
>> Ronald van Kuijk
>> Sent: Wednesday, 6 July 2005 9:44 PM
>> To: ebx...@li...
>> Subject: [ebxmlms-general] no primary key on sent and received 
>> message
>>
>> I'm trying to reverse generate some components for accessing the DB 
>> using hibernate (from within exadel studio). This works nice, but for 
>> two tables there are no classes generated. This seems to be related 
>> to the fact that these two tables do not have primary keys.
>>
>> Question: Can they have primarykeys and if so which columns
>>
>> My guess: Yes, compound c_time and c_messageid or maybe even single 
>> c_messageid
>>
>> Thanks,
>>
>> Ronald
>>
>>
>>
>>
>> -------------------------------------------------------
>> SF.Net email is sponsored by: Discover Easy Linux Migration 
>> Strategies from IBM. Find simple to follow Roadmaps, straightforward 
>> articles, informative Webcasts and more! Get everything you need to get up to speed, fast.
>> http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
>> _______________________________________________
>> ebxmlms-general mailing list
>> ebx...@li...
>> https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>
>>
>>
>> -------------------------------------------------------
>> SF.Net email is sponsored by: Discover Easy Linux Migration 
>> Strategies from IBM. Find simple to follow Roadmaps, straightforward 
>> articles, informative Webcasts and more! Get everything you need to 
>> get up to speed, fast. 
>> http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
>> _______________________________________________
>> ebxmlms-general mailing list
>> ebx...@li...
>> https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>
>
>
> --
> Kijk niet terug, maar kijk naar mij
> Against all odds
>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies 
> from IBM. Find simple to follow Roadmaps, straightforward articles, 
> informative Webcasts and more! Get everything you need to get up to 
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> ebxmlms-general mailing list
> ebx...@li...
> https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies 
> from IBM. Find simple to follow Roadmaps, straightforward articles, 
> informative Webcasts and more! Get everything you need to get up to 
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> ebxmlms-general mailing list
> ebx...@li...
> https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>


--
Kijk niet terug, maar kijk naar mij
Against all odds



-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
_______________________________________________
ebxmlms-general mailing list
ebx...@li...
https://lists.sourceforge.net/lists/listinfo/ebxmlms-general

RE: [ebxmlms-general] no primary key on sent and received message

[Ronald v. K. <rtv...@xs...>]

That's why I do it internally first (wil not go into production if HKU does not allow it) and will
not even be a branch if they do not allow it. So I will totally obey the license. I hope I can
show once it is finished that is is step forward.

Ronald

Steven Herod probeerde me het volgende duidelijk te maken:
> You are talking about significant changes here (they are welcome from my perspective however)
>
> But this is a branch of the hermes source code, how does HKU feel :)
>
> -----Original Message-----
> From: ebx...@li...
> [mailto:ebx...@li...] On Behalf Of Ronald van Kuijk
> Sent: Thursday, 7 July 2005 12:19 PM
> To: ebx...@li...
> Subject: RE: [ebxmlms-general] no primary key on sent and received message
>
> All the tables which did not have a primary key (sentmessage, receivedmessage). I made the
> messageid columns the primary key.
>
> And now I'm experimenting a little, for 3 tables there are already classes that can be used for
> persistency with some small changes
> (ApplicationContext, MessageServiceHandlerConfig, EbxmlMessage
>
> I've made up my mind and (at least for myself since I do not know what the license says) will try
> to rewrite the persistency layer
> completely. This means:
> - get rid of DBTableManager
> - clean up all classes that use these prepaired statement things
> - get rid of the proprietary connectionpool
> - store the messages in a blob as long as there is no alternative (JTA/JCA compliant) file store
>
> This would make the code much more readably and have a persistency layer which is much easier to
> maintain (by others).
>
> There are some questions I already have. One simple, but important one is if messagestore and
> messageinfo could be combined. I've
> looked a little and could not find a reason to keep them separate (but it is now 04:17, so I do
> not see clearly anymore ;-))
>
> Ronald
>
> p.s. more will follow.......
>
>
> Steven Herod probeerde me het volgende duidelijk te maken:
>> I've generated hibernate classes myself for hermes and added my own 'id' column definitions.
>>
>> Which tables?
>>
>> -----Original Message-----
>> From: ebx...@li...
>> [mailto:ebx...@li...] On Behalf Of
>> Ronald van Kuijk
>> Sent: Wednesday, 6 July 2005 9:44 PM
>> To: ebx...@li...
>> Subject: [ebxmlms-general] no primary key on sent and received message
>>
>> I'm trying to reverse generate some components for accessing the DB
>> using hibernate (from within exadel studio). This works nice, but for
>> two tables there are no classes generated. This seems to be related to
>> the fact that these two tables do not have primary keys.
>>
>> Question: Can they have primarykeys and if so which columns
>>
>> My guess: Yes, compound c_time and c_messageid or maybe even single
>> c_messageid
>>
>> Thanks,
>>
>> Ronald
>>
>>
>>
>>
>> -------------------------------------------------------
>> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
>> from IBM. Find simple to follow Roadmaps, straightforward articles,
>> informative Webcasts and more! Get everything you need to get up to speed, fast.
>> http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
>> _______________________________________________
>> ebxmlms-general mailing list
>> ebx...@li...
>> https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>
>>
>>
>> -------------------------------------------------------
>> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
>> from IBM. Find simple to follow Roadmaps, straightforward articles,
>> informative Webcasts and more! Get everything you need to get up to
>> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
>> _______________________________________________
>> ebxmlms-general mailing list
>> ebx...@li...
>> https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>>
>
>
> --
> Kijk niet terug, maar kijk naar mij
> Against all odds
>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> ebxmlms-general mailing list
> ebx...@li...
> https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> ebxmlms-general mailing list
> ebx...@li...
> https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>


-- 
Kijk niet terug, maar kijk naar mij
Against all odds