Menu
▾
▴
ebxmlms-general — General discussions
You can subscribe to this list here.
| 2002 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
(1) |
Sep
|
Oct
(20) |
Nov
(11) |
Dec
(27) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2003 |
Jan
(11) |
Feb
(8) |
Mar
(17) |
Apr
(11) |
May
(9) |
Jun
(30) |
Jul
(18) |
Aug
|
Sep
(4) |
Oct
(34) |
Nov
(83) |
Dec
(28) |
| 2004 |
Jan
(4) |
Feb
|
Mar
(13) |
Apr
(20) |
May
(4) |
Jun
(26) |
Jul
(5) |
Aug
(2) |
Sep
(3) |
Oct
(7) |
Nov
(10) |
Dec
(24) |
| 2005 |
Jan
(7) |
Feb
(44) |
Mar
(9) |
Apr
(16) |
May
(9) |
Jun
(64) |
Jul
(48) |
Aug
(36) |
Sep
(27) |
Oct
(24) |
Nov
(20) |
Dec
(11) |
| 2006 |
Jan
(12) |
Feb
(13) |
Mar
(7) |
Apr
|
May
(16) |
Jun
(5) |
Jul
(2) |
Aug
(7) |
Sep
(19) |
Oct
(5) |
Nov
(9) |
Dec
(13) |
| 2007 |
Jan
(21) |
Feb
(12) |
Mar
(6) |
Apr
|
May
(2) |
Jun
(14) |
Jul
(1) |
Aug
(1) |
Sep
(1) |
Oct
(1) |
Nov
|
Dec
|
| 2008 |
Jan
|
Feb
(1) |
Mar
(2) |
Apr
(5) |
May
(2) |
Jun
(1) |
Jul
(6) |
Aug
|
Sep
(9) |
Oct
(3) |
Nov
(25) |
Dec
(32) |
| 2009 |
Jan
(11) |
Feb
(12) |
Mar
(18) |
Apr
(19) |
May
(31) |
Jun
(23) |
Jul
(35) |
Aug
(7) |
Sep
(2) |
Oct
|
Nov
|
Dec
(8) |
| 2010 |
Jan
(3) |
Feb
(3) |
Mar
(3) |
Apr
|
May
|
Jun
|
Jul
(1) |
Aug
(1) |
Sep
(1) |
Oct
(1) |
Nov
|
Dec
|
| 2013 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(1) |
Dec
|
| 2016 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Steven H. <sh...@te...> - 2005-07-07 02:30:24
|
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 |
|
From: Ronald v. K. <rtv...@xs...> - 2005-07-07 02:19:12
|
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 |
|
From: Steven H. <sh...@te...> - 2005-07-06 22:22:40
|
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 |
|
From: Ronald v. K. <rtv...@xs...> - 2005-07-06 11:46:06
|
Thanks, I'll have a look. Did you know btw that java.nio has file locking on filesystems which
support it. Could be a nice addition.
Ronald
Mattias J probeerde me het volgende duidelijk te maken:
> At 2005-07-06 09:43, you wrote:
>>Mathias.
>>
>>Good info. I'll have a look. This Jakarta Commons solution does not
>>come up in google if you use JTA in your search terms.
>>
>>Ok.. I had a quick look. Since it is not JTA/JCA compatible it seems
>>like a similar solution currently implemented in hermes. Then again,
>>it would not be wrong to drop these 'home made' extensions in favour
>>of existing ones right? (not that the home made solutions are bad,
>>not at all. My own cake is always better than the cake from the mall ;-)
>>
>>Is your solution a kind of java connector?
>
> Nope. I have very limited knowledge of JCA.
> It is a simple class wrapping java.io.File and implementing
> javax.transaction.xa.XAResource.
>
>>Can it be used as a drop-inn in any j2ee container?
>
> It assumes the transaction manager can be found in JNDI
> "java:comp/TransactionManager". But of course that can be made configurable.
>
>>If so, is it available to others ;-)
>
> It is both closed source and specific to our environment. We use it
> (mainly) when creating files. They are created as temporary files,
> and when the JTA transaction commits, the file is moved to the final
> destination and given the final name. If the transaction is rolled
> back, the file is deleted.
>
> Here is the outline of the implementation:
>
> In constructor of factory:
> // Enlist as resource in transaction
> TransactionManager tm = (TransactionManager)new
> InitialContext().lookup("java:comp/TransactionManager");
> javax.transaction.Transaction tx = tm.getTransaction();
> if(tx != null)
> tx.enlistResource(this);
>
> /** Manual delete */
> public void delete() { // NOTE! Assumes newly created files, does
> not work with existing files!
> if(xid != null) { // If enlisted in transaction
> // Delist from transaction
> TransactionManager tm = (TransactionManager)new
> InitialContext().lookup("java:comp/TransactionManager");
> tm.getTransaction().delistResource(this, TMSUCCESS);
> }
> [[Perform delete]]
> }
>
> /**
> * Close file and move to new directory. The method used by all
> other close methods internally.
> * @param newPath
> * @param newName
> */
> public final void rename(final String newName) {
> if(xid == null) // If not part of a transaction
> [[Perform rename]]
> else
> [[Remember name until commit]]
> }
>
> /////////////////////////////////////////////////////////////////////////////////////
> // Methods to implement XAResource
> /////////////////////////////////////////////////////////////////////////////////////
>
> public int getTransactionTimeout() throws XAException {
> return 0;
> }
>
> public boolean setTransactionTimeout(int i) throws XAException {
> return false;
> }
>
> public boolean isSameRM(XAResource xaResource) throws XAException {
> return xaResource == this; // If same file
> }
>
> public Xid[] recover(int flags) throws XAException {
> return null;
> }
>
> /**
> * Prepare for commit. After this we need to be sure the commit
> will be successful. For
> * example we need to make sure there is enought disc space for the file.
> */
> public int prepare(Xid xid) throws XAException {
> // We could do all the file flushing here
> [[Assert file name is set]]
> return XA_OK;
> }
>
> public void forget(Xid xid) throws XAException {
> this.xid = null;
> }
>
> public void rollback(Xid xid) throws XAException {
> this.xid = null;
> [[Delete the file]]
> }
>
> public void end(Xid xid, int flags) throws XAException {
> }
>
> public void start(Xid xid, int flags) throws XAException {
> this.xid = xid;
> }
>
> public void commit(Xid xid, boolean onePhase) throws XAException {
> if([[File not yet manually deleted]]) { // Unless the file was
> deleted (and delisted)
> [[Perform rename/move]]
> }
> this.xid = null;
> }
>
>
>
> / Mattias Jiderhamn
>
>
>
> -------------------------------------------------------
> 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
|
|
From: Ronald v. K. <rtv...@xs...> - 2005-07-06 11:44:23
|
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 |
|
From: Mattias J <mj...@ex...> - 2005-07-06 09:09:40
|
At 2005-07-06 09:43, you wrote:
>Mathias.
>
>Good info. I'll have a look. This Jakarta Commons solution does not
>come up in google if you use JTA in your search terms.
>
>Ok.. I had a quick look. Since it is not JTA/JCA compatible it seems
>like a similar solution currently implemented in hermes. Then again,
>it would not be wrong to drop these 'home made' extensions in favour
>of existing ones right? (not that the home made solutions are bad,
>not at all. My own cake is always better than the cake from the mall ;-)
>
>Is your solution a kind of java connector?
Nope. I have very limited knowledge of JCA.
It is a simple class wrapping java.io.File and implementing
javax.transaction.xa.XAResource.
>Can it be used as a drop-inn in any j2ee container?
It assumes the transaction manager can be found in JNDI
"java:comp/TransactionManager". But of course that can be made configurable.
>If so, is it available to others ;-)
It is both closed source and specific to our environment. We use it
(mainly) when creating files. They are created as temporary files,
and when the JTA transaction commits, the file is moved to the final
destination and given the final name. If the transaction is rolled
back, the file is deleted.
Here is the outline of the implementation:
In constructor of factory:
// Enlist as resource in transaction
TransactionManager tm = (TransactionManager)new
InitialContext().lookup("java:comp/TransactionManager");
javax.transaction.Transaction tx = tm.getTransaction();
if(tx != null)
tx.enlistResource(this);
/** Manual delete */
public void delete() { // NOTE! Assumes newly created files, does
not work with existing files!
if(xid != null) { // If enlisted in transaction
// Delist from transaction
TransactionManager tm = (TransactionManager)new
InitialContext().lookup("java:comp/TransactionManager");
tm.getTransaction().delistResource(this, TMSUCCESS);
}
[[Perform delete]]
}
/**
* Close file and move to new directory. The method used by all
other close methods internally.
* @param newPath
* @param newName
*/
public final void rename(final String newName) {
if(xid == null) // If not part of a transaction
[[Perform rename]]
else
[[Remember name until commit]]
}
/////////////////////////////////////////////////////////////////////////////////////
// Methods to implement XAResource
/////////////////////////////////////////////////////////////////////////////////////
public int getTransactionTimeout() throws XAException {
return 0;
}
public boolean setTransactionTimeout(int i) throws XAException {
return false;
}
public boolean isSameRM(XAResource xaResource) throws XAException {
return xaResource == this; // If same file
}
public Xid[] recover(int flags) throws XAException {
return null;
}
/**
* Prepare for commit. After this we need to be sure the commit
will be successful. For
* example we need to make sure there is enought disc space for the file.
*/
public int prepare(Xid xid) throws XAException {
// We could do all the file flushing here
[[Assert file name is set]]
return XA_OK;
}
public void forget(Xid xid) throws XAException {
this.xid = null;
}
public void rollback(Xid xid) throws XAException {
this.xid = null;
[[Delete the file]]
}
public void end(Xid xid, int flags) throws XAException {
}
public void start(Xid xid, int flags) throws XAException {
this.xid = xid;
}
public void commit(Xid xid, boolean onePhase) throws XAException {
if([[File not yet manually deleted]]) { // Unless the file was
deleted (and delisted)
[[Perform rename/move]]
}
this.xid = null;
}
/ Mattias Jiderhamn
|
|
From: R. v. K. \(Ronald\) <rv...@ab...> - 2005-07-06 07:43:55
|
Mathias. Good info. I'll have a look. This Jakarta Commons solution does not come = up in google if you use JTA in your search terms.=20 Ok.. I had a quick look. Since it is not JTA/JCA compatible it seems = like a similar solution currently implemented in hermes. Then again, it = would not be wrong to drop these 'home made' extensions in favour of = existing ones right? (not that the home made solutions are bad, not at = all. My own cake is always better than the cake from the mall ;-) Is your solution a kind of java connector? Can it be used as a drop-inn = in any j2ee container? If so, is it available to others ;-) Ronald -----Oorspronkelijk bericht----- Van: ebx...@li... = [mailto:ebx...@li...] Namens Mattias J Verzonden: woensdag 6 juli 2005 7:10 Aan: ebx...@li... Onderwerp: Re: [ebxmlms-general] Connectionpooling and transactions. = was: Problems after lost connection to database The Jakarta Commons Transaction API has some kind=20 of file transaction supports, but I haven't tried it. I have made my own JTA file wrapper (i.e. files=20 are XAResource:s), that supports file creation=20 and move/rename. Works like a charm, and quite trivial to implement. At 2005-07-06 04:01, you wrote: >Now, Hermes supports a custom way (API) to=20 >redirect the file persistence to database.=20 >However, still it is not transaction-aware. So=20 >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=20 >>immediately a second question comes to mind. There is >>also a transactionmechanism in place which does=20 >>a kind of xa over a database and a filesystem. >>This makes it almost impossible to use the=20 >>default JTA for this, which would make the hermes core >>even smaller. For our company, storing the=20 >>messages in a DB as a blob is not a problem since we >>require clustering and failover any way. It is=20 >>in fact even a requirement unless there would be a >>JTA compatible filesystem persistency layer (JCA?)). >> >>Replacing the DBConnectionPool with a standard=20 >>based solution can be done by me, since I've done >>it before and probably have the code somewhere.=20 >>DBCP does not have to be provided then, since all >>servlet engines and j2ee servers contain one.=20 >>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 = would >>>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 = 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 error >>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D> = Transaction.rollback >>>>>>>(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.rollback >>>>>>>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.rollback >>>>>>>(txID: #2323) >>>>>>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: <=3D = Transaction.rollback >>>>>>>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.rollback >>>>>>>(txID: #2338) >>>>>>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: <=3D = Transaction.rollback >>>>>>>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 = Source) >>>>>>> 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 = 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=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 = 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=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 = 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_id492&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_id492&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_id492&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 |
|
From: R. v. K. \(Ronald\) <rv...@ab...> - 2005-07-06 07:35:47
|
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 addition 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 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) this would also be a = nice change and would make 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:ebx...@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 = 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: >Sounds interesting. But with regard to this immediately a second = question 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, 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 = requirement 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 = would >>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 >> >>>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 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 = 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.rollback >>>>>>(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.rollback >>>>>>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.rollback >>>>>>(txID: #2323) >>>>>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: <=3D = Transaction.rollback >>>>>>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.rollback >>>>>>(txID: #2338) >>>>>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: <=3D = Transaction.rollback >>>>>>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(Unkn= own >>>>>>Source) >>>>>> at >>>>>>hk.hku.cecid.phoenix.message.handler.Request.sendMessageServiceHand= lerConfig(Unknown >>>>>>Source) >>>>>> at >>>>>>hk.hku.cecid.phoenix.message.handler.Request.register(Unknown = Source) >>>>>> 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.jav= a: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 = 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=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 = 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=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 = 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 >>> >> >>------------------------------------------------------- >>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 > ------------------------------------------------------- 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 |
|
From: Mattias J <mj...@ex...> - 2005-07-06 05:09:45
|
The Jakarta Commons Transaction API has some kind=20 of file transaction supports, but I haven't tried it. I have made my own JTA file wrapper (i.e. files=20 are XAResource:s), that supports file creation=20 and move/rename. Works like a charm, and quite trivial to implement. At 2005-07-06 04:01, you wrote: >Now, Hermes supports a custom way (API) to=20 >redirect the file persistence to database.=20 >However, still it is not transaction-aware. So=20 >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=20 >>immediately a second question comes to mind. There is >>also a transactionmechanism in place which does=20 >>a kind of xa over a database and a filesystem. >>This makes it almost impossible to use the=20 >>default JTA for this, which would make the hermes core >>even smaller. For our company, storing the=20 >>messages in a DB as a blob is not a problem since we >>require clustering and failover any way. It is=20 >>in fact even a requirement unless there would be a >>JTA compatible filesystem persistency layer (JCA?)). >> >>Replacing the DBConnectionPool with a standard=20 >>based solution can be done by me, since I've done >>it before and probably have the code somewhere.=20 >>DBCP does not have to be provided then, since all >>servlet engines and j2ee servers contain one.=20 >>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 would >>>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 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 error >>>>>>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D> Transaction.rollback >>>>>>>(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.rollback >>>>>>>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.rollback >>>>>>>(txID: #2323) >>>>>>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: <=3D Transaction.rollback >>>>>>>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.rollback >>>>>>>(txID: #2338) >>>>>>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: <=3D Transaction.rollback >>>>>>>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(Unknow= n >>>>>>>Source) >>>>>>> at >>>>>>>hk.hku.cecid.phoenix.message.handler.Request.sendMessageServiceHandle= rConfig(Unknown >>>>>>>Source) >>>>>>> at >>>>>>>hk.hku.cecid.phoenix.message.handler.Request.register(Unknown Source) >>>>>>> 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, 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= 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=3D= click >>>>>>>_______________________________________________ >>>>>>>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 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-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_id492&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_id492&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_id492&op=CCk >_______________________________________________ >ebxmlms-general mailing list >ebx...@li... >https://lists.sourceforge.net/lists/listinfo/ebxmlms-general |
|
From: Patrick Y. <kc...@ce...> - 2005-07-06 02:01:51
|
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: >Sounds interesting. But with regard to this immediately a second questio= n comes to mind. There is >also a transactionmechanism in place which does a kind of xa over a data= base and a filesystem. >This makes it almost impossible to use the default JTA for this, which w= ould 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 requiremen= t unless there would be a >JTA compatible filesystem persistency layer (JCA?)). > >Replacing the DBConnectionPool with a standard based solution can be don= e 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 per= sistency 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 would >>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 >> >>>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 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 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.rollback >>>>>>(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.rollback >>>>>>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.rollback >>>>>>(txID: #2323) >>>>>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: <=3D Transaction.rollback >>>>>>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.rollback >>>>>>(txID: #2338) >>>>>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: <=3D Transaction.rollback >>>>>>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(Unkn= own >>>>>>Source) >>>>>> at >>>>>>hk.hku.cecid.phoenix.message.handler.Request.sendMessageServiceHand= lerConfig(Unknown >>>>>>Source) >>>>>> at >>>>>>hk.hku.cecid.phoenix.message.handler.Request.register(Unknown Sourc= e) >>>>>> 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.jav= a: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 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 >>>>>> =20 >>>>>> >>>>> =20 >>>>> >>>>_________________________________________________________________ >>>>Undg=E5 pop-ups med MSN Toolbar - http://toolbar.msn.dk/ hent den gr= atis! >>>> >>>> >>>> >>>>------------------------------------------------------- >>>>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_id=3D7477&alloc_id=3D16492&op=3D= click >>>>_______________________________________________ >>>>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 >>> >> >>------------------------------------------------------- >>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 > |
|
From: Ronald v. K. <rtv...@xs...> - 2005-07-05 18:20:29
|
Sounds interesting. But with regard to this immediately a second question= comes to mind. There is also a transactionmechanism in place which does a kind of xa over a datab= ase and a filesystem. This makes it almost impossible to use the default JTA for this, which wo= uld 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 requirement= 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 pers= istency 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 would > 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 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 error >>>>> 2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D> Transaction.rollback >>>>> (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.rollback >>>>> 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.rollback >>>>> (txID: #2323) >>>>> 2005-06-21 09:13:35,352 DEBUG [Thread-8]: <=3D Transaction.rollback >>>>> 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.rollback >>>>> (txID: #2338) >>>>> 2005-06-21 09:13:42,384 DEBUG [Thread-8]: <=3D Transaction.rollback >>>>> 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(Unkn= own >>>>> Source) >>>>> at >>>>> hk.hku.cecid.phoenix.message.handler.Request.sendMessageServiceHand= lerConfig(Unknown >>>>> Source) >>>>> at >>>>> hk.hku.cecid.phoenix.message.handler.Request.register(Unknown Sourc= e) >>>>> 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.jav= a: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 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 >>>> >>>> >>> >>> _________________________________________________________________ >>> Undg=E5 pop-ups med MSN Toolbar - http://toolbar.msn.dk/ hent den gr= atis! >>> >>> >>> >>> ------------------------------------------------------- >>> 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_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 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 |
|
From: Patrick Y. <kc...@ce...> - 2005-07-05 09:53:24
|
There is no strict reason for using our own implementation. So it would=20 be good to have some contribution to port Hermes to make use of other=20 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=20 >> databasepool, without sophisticated recovery mechanism. >> Our own application use javax.sql.DataSource, to get a connection. I=20 >> guess there is a recovery mechanism in that solution, as our own=20 >> application runs fine when the connection gets back. >> Is there anyway to use javax.sql.DataSource instead of your=20 >> implementation of the connection pool? I guess my question is more to=20 >> why you are using your own implemtation, are you using some extra=20 >> 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=20 >>> database >>> Date: Sun, 26 Jun 2005 19:19:35 +0800 >>> >>> We have not implemented a sophisticated recovery mechanism in the=20 >>> database connection pool. The only mechanism we have done is,=20 >>> whenever a connection is proved to be bad, we will not put it back=20 >>> to the connection pool. Actually there was a suggestion some time=20 >>> ago that we can do a "select *" on some tables before we use the=20 >>> pooled database connection. We think that will create certain=20 >>> performance issue, and so we shelved that idea. Of course, if you=20 >>> want it, you can just patch the database connection pool classes and=20 >>> 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=20 >>>> (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>=20 >>>> DbConnectionPool.getConnection >>>> 2005-06-21 09:13:34,384 DEBUG [Thread-8]: <=3D=20 >>>> 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.rollback=20 >>>> (txID: #2321) >>>> 2005-06-21 09:13:34,384 ERROR [Thread-8]: [10315] Cannot rollback=20 >>>> 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>=20 >>>> DbConnectionPool.freeConnection >>>> 2005-06-21 09:13:34,384 DEBUG [Thread-8]: <=3D=20 >>>> DbConnectionPool.freeConnection >>>> 2005-06-21 09:13:34,384 DEBUG [Thread-8]: <=3D Transaction.rollback >>>> 2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D>=20 >>>> MessageServiceHandler.getNextUndeliveredMessage >>>> 2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D>=20 >>>> MessageServer.getUndeliveredMessages >>>> 2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D>=20 >>>> DbConnectionPool.getConnection >>>> 2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D>=20 >>>> DbConnectionPool.createConnection >>>> 2005-06-21 09:13:35,352 ERROR [Thread-8]: [10306] Cannot create DB=20 >>>> connection Exception: java.sql.SQLException Message: Network error >>>> IOException: Connection refused: connect >>>> 2005-06-21 09:13:35,352 DEBUG [Thread-8]: =3D> Transaction.rollback=20 >>>> (txID: #2323) >>>> 2005-06-21 09:13:35,352 DEBUG [Thread-8]: <=3D Transaction.rollback >>>> 2005-06-21 09:13:35,352 DEBUG [Thread-8]: =3D>=20 >>>> MessageServiceHandler.getNextUndeliveredMessage >>>> 2005-06-21 09:13:35,352 DEBUG [Thread-8]: =3D>=20 >>>> MessageServer.getUndeliveredMessages >>>> 2005-06-21 09:13:35,352 DEBUG [Thread-8]: =3D>=20 >>>> DbConnectionPool.getConnection >>>> 2005-06-21 09:13:35,352 DEBUG [Thread-8]: =3D>=20 >>>> DbConnectionPool.createConnection >>>> >>>> >>>> After the connection is restored MSH do not seem to get a proper=20 >>>> connection. >>>> This occurs then in the MSH_Client.log: >>>> >>>> 2005-06-21 09:13:42,384 ERROR [Thread-8]: [10306] Cannot create DB=20 >>>> connection >>>> Exception: java.sql.SQLException Message: Network error >>>> IOException: Connection refused: connect >>>> 2005-06-21 09:13:42,384 DEBUG [Thread-8]: =3D> Transaction.rollback=20 >>>> (txID: #2338) >>>> 2005-06-21 09:13:42,384 DEBUG [Thread-8]: <=3D Transaction.rollback >>>> 2005-06-21 09:13:42,384 DEBUG [Thread-8]: =3D>=20 >>>> MessageServiceHandler.getNextUndeliveredMessage >>>> 2005-06-21 09:13:42,384 DEBUG [Thread-8]: =3D>=20 >>>> MessageServer.getUndeliveredMessages >>>> 2005-06-21 09:13:42,384 DEBUG [Thread-8]: =3D>=20 >>>> DbConnectionPool.getConnection >>>> 2005-06-21 09:13:42,384 DEBUG [Thread-8]: =3D>=20 >>>> DbConnectionPool.createConnection >>>> 2005-06-21 09:13:43,384 ERROR [Thread-8]: [10306] Cannot create DB=20 >>>> 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=20 >>>> hk.hku.cecid.phoenix.message.handler.Request.expectMapResponse(Unkno= wn=20 >>>> Source) >>>> at=20 >>>> hk.hku.cecid.phoenix.message.handler.Request.sendMessageServiceHandl= erConfig(Unknown=20 >>>> Source) >>>> at=20 >>>> hk.hku.cecid.phoenix.message.handler.Request.register(Unknown Source= ) >>>> at hk.hku.cecid.phoenix.message.handler.Request.<init>(Unknown=20 >>>> Source) >>>> at hk.hku.cecid.phoenix.message.handler.Request.<init>(Unknown=20 >>>> Source) >>>> at=20 >>>> com.mysupply.ebxi.msh.MessageManager.sendMessage(MessageManager.java= :149)=20 >>>> >>>> >>>> And of course I can not receive any messages through MSH either. >>>> >>>> Does anybody have the same problems, after a lost database=20 >>>> connection? The other part of my application that uses MSH, is=20 >>>> right back in action when the database connection is restored, but=20 >>>> not MSH. >>>> >>>> The app is running on jboss-4.0.1 (Tomcat 5.0.28), Java=20 >>>> jdk1.5.0_01. The database is Microsofts MSSQL 2000. The driver for=20 >>>> MSSQL is JTDS 1.0. >>>> I have added this: >>>> <check-valid-connection-sql>select * from=20 >>>> some_table</check-valid-connection-sql> >>>> to my datasource file: mssql-ds.xml which is deployed along with=20 >>>> msh.war. >>>> >>>> Everything is working fine, for days, until I loose the database=20 >>>> 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 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_id=3D7477&alloc_id=3D16492&op=3D= click >>>> _______________________________________________ >>>> 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 gra= tis! >> >> >> >> ------------------------------------------------------- >> 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=3Dc= lick >> _______________________________________________ >> 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 > |
|
From: Gait B. <gai...@ti...> - 2005-07-01 08:59:44
|
Hi Christine, see inline. FWIW, I'm using the latest CVS build, not 0.9.3. --Gait Boxman, TIE, The Netherlands Christine Zimmer wrote: >Hi, >I'm sorry, but it still doesn't work. > > > >>You probably have input that configuration in msh.properties.xml. Please >>note that msh.properties.xml is for configuring Hermes server, while >>msh_client.properties.xml is for configuring the Hermes client. >>Regards, -Patrick >> >> > > > >>>>RunLoopBack launches a Hermes client, which will need a configuration >>>>file to locate the Hermes server. The configuration is located at >>>>msh_client.properties.xml. You can find that file in your download >>>>package and you should put it in the classpath or current working >>>>directory when launching Hermes client. >>>> >>>> > > >I put all the configuration files in the classpath. >I also know that msh.properties is for hermes server and >msh_client.properties.xml is for hermes client. >But I still get the following error: >Hermes is alive. However, Hermes does not respond to HTTP GET method. >what does that error mean, and what can I do? > > that's not an error, that's just the message that you get when you browse to the MSH url. ebMS doesn't use the HTTP GET method, only HTTP POST or HTTP PUT. This is just a message telling you it's running. In fact, this message tells you all is fine (so far). >the tomcat log file says: > >2005-07-01 09:46:11 StandardContext[/balancer]org.apache.webapp.balancer.BalancerFilter: init(): ruleChain: [org.apache.webapp.balancer.RuleChain: [org.apache.webapp.balancer.rules.URLStringMatchRule: Target string: News / Redirect URL: http://www.cnn.com], [org.apache.webapp.balancer.rules.RequestParameterRule: Target param name: paramName / Target param value: paramValue / Redirect URL: http://www.yahoo.com], [org.apache.webapp.balancer.rules.AcceptEverythingRule: Redirect URL: http://jakarta.apache.org]] >2005-07-01 09:46:20 StandardHost[localhost]: Error deploying application at context path null >java.lang.NullPointerException > at org.apache.commons.digester.Digester.createSAXException(Digester.java:2540) > at org.apache.commons.digester.Digester.createSAXException(Digester.java:2566) > at org.apache.commons.digester.Digester.endElement(Digester.java:1061) > at org.apache.catalina.util.CatalinaDigester.endElement(CatalinaDigester.java:76) > at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:633) > at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(XMLDocumentFragmentScannerImpl.java:1241) > at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(XMLDocumentFragmentScannerImpl.java:1685) > at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:368) > at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:834) > at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:764) > at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:148) > at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1242) > at org.apache.commons.digester.Digester.parse(Digester.java:1567) > at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:475) > at org.apache.catalina.core.StandardHost.install(StandardHost.java:863) > at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:480) > at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:425) > at org.apache.catalina.startup.HostConfig.start(HostConfig.java:961) > at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:347) > at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) > at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1091) > at org.apache.catalina.core.StandardHost.start(StandardHost.java:789) > at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083) > at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478) > at org.apache.catalina.core.StandardService.start(StandardService.java:476) > at org.apache.catalina.core.StandardServer.start(StandardServer.java:2298) > at org.apache.catalina.startup.Catalina.start(Catalina.java:547) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:585) > at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:286) > at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:387) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:585) > at org.apache.commons.launcher.ChildMain.run(ChildMain.java:269) > > This doesn't appear to be MSH related. I guess it's another app on your Tomcat server that is somehow badly configured. >2005-07-01 09:47:04 StandardContext[/jsp-examples]ContextListener: contextInitialized() >2005-07-01 09:47:04 StandardContext[/jsp-examples]SessionListener: contextInitialized() >2005-07-01 09:47:28 StandardContext[/servlets-examples]ContextListener: contextInitialized() >2005-07-01 09:47:28 StandardContext[/servlets-examples]SessionListener: contextInitialized() > >and msh.log says, that hermes still wants to receive messages from >that pop server I didn't specify, neither in msh.properties.xml nor in any >other properties file. > > It's a little tricky to suppress mail polling. What I've done is to comment out the Host element from MSH/Mail/Poll in msh.properties.xml. This will give a warning: 2005-05-11 09:22:46,400 WARN [main]: [10003] Property not properly set - MSH/Mail/*: mail polling disabled in msh.log during startup of the Hermes. Guess what, just what I wanted :-) > >Regards >Christine > > > > >------------------------------------------------------- >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 > > > |
|
From: Christine Z. <chr...@gm...> - 2005-07-01 08:00:14
|
Hi, I'm sorry, but it still doesn't work. > You probably have input that configuration in msh.properties.xml. Please > note that msh.properties.xml is for configuring Hermes server, while > msh_client.properties.xml is for configuring the Hermes client. > Regards, -Patrick >>>RunLoopBack launches a Hermes client, which will need a configuration >>>file to locate the Hermes server. The configuration is located at >>>msh_client.properties.xml. You can find that file in your download >>>package and you should put it in the classpath or current working >>>directory when launching Hermes client. I put all the configuration files in the classpath. I also know that msh.properties is for hermes server and msh_client.properties.xml is for hermes client. But I still get the following error: Hermes is alive. However, Hermes does not respond to HTTP GET method. what does that error mean, and what can I do? the tomcat log file says: 2005-07-01 09:46:11 StandardContext[/balancer]org.apache.webapp.balancer.BalancerFilter: init(): ruleChain: [org.apache.webapp.balancer.RuleChain: [org.apache.webapp.balancer.rules.URLStringMatchRule: Target string: News / Redirect URL: http://www.cnn.com], [org.apache.webapp.balancer.rules.RequestParameterRule: Target param name: paramName / Target param value: paramValue / Redirect URL: http://www.yahoo.com], [org.apache.webapp.balancer.rules.AcceptEverythingRule: Redirect URL: http://jakarta.apache.org]] 2005-07-01 09:46:20 StandardHost[localhost]: Error deploying application at context path null java.lang.NullPointerException at org.apache.commons.digester.Digester.createSAXException(Digester.java:2540) at org.apache.commons.digester.Digester.createSAXException(Digester.java:2566) at org.apache.commons.digester.Digester.endElement(Digester.java:1061) at org.apache.catalina.util.CatalinaDigester.endElement(CatalinaDigester.java:76) at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:633) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(XMLDocumentFragmentScannerImpl.java:1241) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(XMLDocumentFragmentScannerImpl.java:1685) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:368) at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:834) at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:764) at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:148) at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1242) at org.apache.commons.digester.Digester.parse(Digester.java:1567) at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:475) at org.apache.catalina.core.StandardHost.install(StandardHost.java:863) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:480) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:425) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:961) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:347) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1091) at org.apache.catalina.core.StandardHost.start(StandardHost.java:789) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478) at org.apache.catalina.core.StandardService.start(StandardService.java:476) at org.apache.catalina.core.StandardServer.start(StandardServer.java:2298) at org.apache.catalina.startup.Catalina.start(Catalina.java:547) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:286) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:387) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.commons.launcher.ChildMain.run(ChildMain.java:269) 2005-07-01 09:47:04 StandardContext[/jsp-examples]ContextListener: contextInitialized() 2005-07-01 09:47:04 StandardContext[/jsp-examples]SessionListener: contextInitialized() 2005-07-01 09:47:28 StandardContext[/servlets-examples]ContextListener: contextInitialized() 2005-07-01 09:47:28 StandardContext[/servlets-examples]SessionListener: contextInitialized() and msh.log says, that hermes still wants to receive messages from that pop server I didn't specify, neither in msh.properties.xml nor in any other properties file. Regards Christine |
|
From: R. v. K. \(Ronald\) <rv...@ab...> - 2005-06-29 19:04:01
|
YES, but... - Tomcat already has this with it - As does Jetty - As do all j2ee appservers So build on that and not include Jakarta commons DBCP ourselves. The = pure db stuff is not to difficult to swapout, I've done that before, but = the project was not realy interested since they wanted to be = independent.=20 If you swap out the proprietary db stuff for a standards based solution, = one thing that has to be done is to get some kind of transaction over = the database and file operations. This is for us one of the major issues = our ASP (and me as an architect, but I like to blame others ;-)) does = not let hermes run in production. Ronald -----Oorspronkelijk bericht----- Van: ebx...@li... = [mailto:ebx...@li...] Namens Mattias J Verzonden: maandag 27 juni 2005 10:25 Aan: ebx...@li... Onderwerp: Re: [ebxmlms-general] Problems after lost connection to = database 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=20 >your own databasepool, without sophisticated recovery mechanism. >Our own application use javax.sql.DataSource, to=20 >get a connection. I guess there is a recovery=20 >mechanism in that solution, as our own=20 >application runs fine when the connection gets back. >Is there anyway to use javax.sql.DataSource=20 >instead of your implementation of the connection=20 >pool? I guess my question is more to why you are=20 >using your own implemtation, are you using some=20 >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=20 >>recovery mechanism in the database connection=20 >>pool. The only mechanism we have done is,=20 >>whenever a connection is proved to be bad, we=20 >>will not put it back to the connection pool.=20 >>Actually there was a suggestion some time ago=20 >>that we can do a "select *" on some tables=20 >>before we use the pooled database connection.=20 >>We think that will create certain performance=20 >>issue, and so we shelved that idea. Of course,=20 >>if you want it, you can just patch the database=20 >>connection pool classes and implement any=20 >>advanced recovery mechanism as you like. :-) >>Regards, -Patrick >> >> >>Kenneth Pedersen wrote: >> >>>Hi >>> >>>If I loose the connection to my database for a=20 >>>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>=20 >>>Transaction.rollback (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.rollback >>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D>=20 >>>MessageServiceHandler.getNextUndeliveredMessage >>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D>=20 >>>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>=20 >>>DbConnectionPool.createConnection >>>2005-06-21 09:13:35,352 ERROR [Thread-8]:=20 >>>[10306] Cannot create DB connection Exception:=20 >>>java.sql.SQLException Message: Network error >>>IOException: Connection refused: connect >>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: =3D>=20 >>>Transaction.rollback (txID: #2323) >>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: <=3D Transaction.rollback >>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: =3D>=20 >>>MessageServiceHandler.getNextUndeliveredMessage >>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: =3D>=20 >>>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>=20 >>>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]:=20 >>>[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>=20 >>>Transaction.rollback (txID: #2338) >>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: <=3D Transaction.rollback >>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: =3D>=20 >>>MessageServiceHandler.getNextUndeliveredMessage >>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: =3D>=20 >>>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>=20 >>>DbConnectionPool.createConnection >>>2005-06-21 09:13:43,384 ERROR [Thread-8]:=20 >>>[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=20 >>> = hk.hku.cecid.phoenix.message.handler.Request.expectMapResponse(Unknown = Source) >>> at=20 >>> = hk.hku.cecid.phoenix.message.handler.Request.sendMessageServiceHandlerCon= fig(Unknown=20 >>> Source) >>> at=20 >>> hk.hku.cecid.phoenix.message.handler.Request.register(Unknown = Source) >>> at hk.hku.cecid.phoenix.message.handler.Request.<init>(Unknown = Source) >>> at hk.hku.cecid.phoenix.message.handler.Request.<init>(Unknown = Source) >>> at=20 >>> = 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=20 >>>lost database connection? The other part of my=20 >>>application that uses MSH, is right back in=20 >>>action when the database connection is restored, but not MSH. >>> >>>The app is running on jboss-4.0.1 (Tomcat=20 >>>5.0.28), Java jdk1.5.0_01. The database is=20 >>>Microsofts MSSQL 2000. The driver for MSSQL is JTDS 1.0. >>>I have added this: >>><check-valid-connection-sql>select * from=20 >>>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=20 >>>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 = 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=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 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=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 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 |
|
From: R. v. K. \(Ronald\) <rv...@ab...> - 2005-06-29 18:58:07
|
See..... -----Oorspronkelijk bericht----- Van: ebx...@li... [mailto:ebx...@li...] Namens Steven Herod Verzonden: woensdag 22 juni 2005 0:40 Aan: ebx...@li... Onderwerp: RE: [ebxmlms-general] Mailing list Check the email headers on the email you receive from the list, you'll see the instructions: List-Unsubscribe: <https://lists.sourceforge.net/lists/listinfo/ebxmlms-general>, <mailto:ebx...@li...?subject=unsubscrib e> -----Original Message----- From: ebx...@li... [mailto:ebx...@li...] On Behalf Of Lucia Melotti Sent: Wednesday, 22 June 2005 3:21 AM To: ebx...@li... Subject: [ebxmlms-general] Mailing list I would like to ususcribe from this Mailing list.. how can i do? Thanks Lucia ------------------------------------------------------- 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 |
|
From: Lucia M. <lme...@cs...> - 2005-06-27 16:53:24
|
I would like to unsuscribe from this mailing list |
|
From: Mattias J <mj...@ex...> - 2005-06-27 08:47:04
|
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=20 >your own databasepool, without sophisticated recovery mechanism. >Our own application use javax.sql.DataSource, to=20 >get a connection. I guess there is a recovery=20 >mechanism in that solution, as our own=20 >application runs fine when the connection gets back. >Is there anyway to use javax.sql.DataSource=20 >instead of your implementation of the connection=20 >pool? I guess my question is more to why you are=20 >using your own implemtation, are you using some=20 >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=20 >>recovery mechanism in the database connection=20 >>pool. The only mechanism we have done is,=20 >>whenever a connection is proved to be bad, we=20 >>will not put it back to the connection pool.=20 >>Actually there was a suggestion some time ago=20 >>that we can do a "select *" on some tables=20 >>before we use the pooled database connection.=20 >>We think that will create certain performance=20 >>issue, and so we shelved that idea. Of course,=20 >>if you want it, you can just patch the database=20 >>connection pool classes and implement any=20 >>advanced recovery mechanism as you like. :-) >>Regards, -Patrick >> >> >>Kenneth Pedersen wrote: >> >>>Hi >>> >>>If I loose the connection to my database for a=20 >>>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>=20 >>>Transaction.rollback (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.rollback >>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D>=20 >>>MessageServiceHandler.getNextUndeliveredMessage >>>2005-06-21 09:13:34,384 DEBUG [Thread-8]: =3D>=20 >>>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>=20 >>>DbConnectionPool.createConnection >>>2005-06-21 09:13:35,352 ERROR [Thread-8]:=20 >>>[10306] Cannot create DB connection Exception:=20 >>>java.sql.SQLException Message: Network error >>>IOException: Connection refused: connect >>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: =3D>=20 >>>Transaction.rollback (txID: #2323) >>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: <=3D Transaction.rollback >>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: =3D>=20 >>>MessageServiceHandler.getNextUndeliveredMessage >>>2005-06-21 09:13:35,352 DEBUG [Thread-8]: =3D>=20 >>>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>=20 >>>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]:=20 >>>[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>=20 >>>Transaction.rollback (txID: #2338) >>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: <=3D Transaction.rollback >>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: =3D>=20 >>>MessageServiceHandler.getNextUndeliveredMessage >>>2005-06-21 09:13:42,384 DEBUG [Thread-8]: =3D>=20 >>>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>=20 >>>DbConnectionPool.createConnection >>>2005-06-21 09:13:43,384 ERROR [Thread-8]:=20 >>>[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=20 >>> hk.hku.cecid.phoenix.message.handler.Request.expectMapResponse(Unknown= Source) >>> at=20 >>>= hk.hku.cecid.phoenix.message.handler.Request.sendMessageServiceHandlerConfi= g(Unknown=20 >>> Source) >>> at=20 >>> hk.hku.cecid.phoenix.message.handler.Request.register(Unknown Source) >>> at hk.hku.cecid.phoenix.message.handler.Request.<init>(Unknown= Source) >>> at hk.hku.cecid.phoenix.message.handler.Request.<init>(Unknown= Source) >>> at=20 >>>= 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=20 >>>lost database connection? The other part of my=20 >>>application that uses MSH, is right back in=20 >>>action when the database connection is restored, but not MSH. >>> >>>The app is running on jboss-4.0.1 (Tomcat=20 >>>5.0.28), Java jdk1.5.0_01. The database is=20 >>>Microsofts MSSQL 2000. The driver for MSSQL is JTDS 1.0. >>>I have added this: >>><check-valid-connection-sql>select * from=20 >>>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=20 >>>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 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=3Dclic= k >>>_______________________________________________ >>>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 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=3Dclick >_______________________________________________ >ebxmlms-general mailing list >ebx...@li... >https://lists.sourceforge.net/lists/listinfo/ebxmlms-general |
|
From: Kenneth P. <tr...@ho...> - 2005-06-27 07:29:13
|
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 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]: => >>DbConnectionPool.getConnection >>2005-06-21 09:13:34,384 DEBUG [Thread-8]: <= >>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]: => Transaction.rollback (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]: => >>DbConnectionPool.freeConnection >>2005-06-21 09:13:34,384 DEBUG [Thread-8]: <= >>DbConnectionPool.freeConnection >>2005-06-21 09:13:34,384 DEBUG [Thread-8]: <= Transaction.rollback >>2005-06-21 09:13:34,384 DEBUG [Thread-8]: => >>MessageServiceHandler.getNextUndeliveredMessage >>2005-06-21 09:13:34,384 DEBUG [Thread-8]: => >>MessageServer.getUndeliveredMessages >>2005-06-21 09:13:34,384 DEBUG [Thread-8]: => >>DbConnectionPool.getConnection >>2005-06-21 09:13:34,384 DEBUG [Thread-8]: => >>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]: => Transaction.rollback (txID: >>#2323) >>2005-06-21 09:13:35,352 DEBUG [Thread-8]: <= Transaction.rollback >>2005-06-21 09:13:35,352 DEBUG [Thread-8]: => >>MessageServiceHandler.getNextUndeliveredMessage >>2005-06-21 09:13:35,352 DEBUG [Thread-8]: => >>MessageServer.getUndeliveredMessages >>2005-06-21 09:13:35,352 DEBUG [Thread-8]: => >>DbConnectionPool.getConnection >>2005-06-21 09:13:35,352 DEBUG [Thread-8]: => >>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]: => Transaction.rollback (txID: >>#2338) >>2005-06-21 09:13:42,384 DEBUG [Thread-8]: <= Transaction.rollback >>2005-06-21 09:13:42,384 DEBUG [Thread-8]: => >>MessageServiceHandler.getNextUndeliveredMessage >>2005-06-21 09:13:42,384 DEBUG [Thread-8]: => >>MessageServer.getUndeliveredMessages >>2005-06-21 09:13:42,384 DEBUG [Thread-8]: => >>DbConnectionPool.getConnection >>2005-06-21 09:13:42,384 DEBUG [Thread-8]: => >>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 = 200 >> HTTP response message = OK >> at >>hk.hku.cecid.phoenix.message.handler.Request.expectMapResponse(Unknown >>Source) >> at >>hk.hku.cecid.phoenix.message.handler.Request.sendMessageServiceHandlerConfig(Unknown >>Source) >> at hk.hku.cecid.phoenix.message.handler.Request.register(Unknown >>Source) >> 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, 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 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 > > _________________________________________________________________ Undgå pop-ups med MSN Toolbar - http://toolbar.msn.dk/ hent den gratis! |
|
From: Steven H. <sh...@te...> - 2005-06-26 22:57:42
|
6 Records, The same 6 that were reinserted when we started up the client again. Oh, and I made a mistake, the correct syntax is TRUNCATE, not TRUNC... :( -----Original Message----- From: ebx...@li... [mailto:ebx...@li...] On Behalf Of Patrick Yee Sent: Sunday, 26 June 2005 9:07 PM To: ebx...@li... Subject: Re: [ebxmlms-general] Triggering a Incoming Listener How many records you have deleted then? -Patrick Steven Herod wrote: >Thanks so much for your reply. > >No, there was no message such as this because we deleted the contents >of the mshconfig table. >'TRUNC msh.mshconfig' is sql for deleting the contents of the table >(TRUNC = >TRUNCATE) > >So, it wouldn't have had any errors in trying to load missing objects >because we removed the config table which tells it which objects to load. > >After starting hermes we restarted the app handler, and that resent >both the config and serialised objects to hermes and all was fine. > > > >-----Original Message----- >From: ebx...@li... >[mailto:ebx...@li...] On Behalf Of >Patrick Yee >Sent: Monday, 20 June 2005 11:35 PM >To: ebx...@li... >Subject: Re: [ebxmlms-general] Triggering a Incoming Listener > >Steven, >I am not sure about the effect of 'Trunc msh.mshconfig". Could you give >me more information on that? However, it seems a bit strange to me that >you can still restart Hermes successfully for moving aside the >"objects*" files. The reason is: during Hermes starts up, it will read >the mshconfig table, each entry there contains a file name which points >to a serialized object. Hermes will then read the serialized object in >the objectStore folder. If it cannot find the object, exceptions will >be thrown. Did you aware of that in the log file? >Regards, -Patrick > > >Steven Herod wrote: > > > >>Last night, after reading through the source code and gaining a >>stronger understanding of the system, we executed the following steps: >> >>Hermes shutdown >>Apphandler shutdown >>Ran the SQL: 'Trunc msh.mshconfig' >>move aside of the 'objects*' files in '~msh/objectStore' >>Start of hermes >>Start of apphandler >> >> >> >> >> > > > >------------------------------------------------------- >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 |
|
From: Patrick Y. <kc...@ce...> - 2005-06-26 11:45:14
|
(Oops, sorry, I just asked you the same question in your another thread a moment ago. So, please ignore that.) You may try to have a detailed trace in the log file. Since your message handlers are polling the Hermes server for messages, you should be able to find those traces in the log file. And you can see that most of the time, the message handlers got nothing. Now a message was received by Hermes (you probably can find that log trace also), and we expect the next poll from the message handlers should get something. Now you say it takes 10 minutes before the message handlers get the message. So there may be two possibilities: 1. The message handler's poller stalled, so that it didn't poll for message in that 10 minutes 2. The polling mechanism is somehow faulty. So the message handler's poller did poll in that 10 minutes, but strangely get nothing. Of course, both cases are abnormal. But we have to dig more information in this way to get the real cause. Regards, -patrick Steven Herod wrote: >Sorry for the late response, had a busy day yesterday. > >Regarding your questions, there are only about 6 records in mshconfig, but >there are 16000 in messagestore > >If database speed was a problem, I would expect that all activities would be >affected (that is, it if went slow this time, it'd still be slow now and >would have gotten worse). > > > > >-----Original Message----- >From: ebx...@li... >[mailto:ebx...@li...] On Behalf Of Patrick >Yee >Sent: Monday, 20 June 2005 11:37 PM >To: ebx...@li... >Subject: Re: [ebxmlms-general] Again, unreliable execution of message >handlers. > >Steven, >How many records are there in the database? In particular, how many records >in mshconfig table? in messagestore table? I am still not sure about the >reason, just wondering whether the number of records in database is one of >the factors determining speed or not.. >Regards, -Patrick > > >Steven Herod wrote: > > > >>About a week ago, we had another incident of message handler not >>executing on message arrival. >> >>In this case however, it wasn't a complete failure, instead, it seemed >>to take about 10 minutes between hermes receiving the file and the >>message handler picking it up. >> >>Normal behaviour has this occuring within a few seconds, however, in this >>case, about 10 minute passed before the handler fired. Our messages are >>time sensitive, so this pushed the response time window outside of >>normal and raised an error with our customer. >> >>There are no log files indications of a reason for a delay, the >>message handler usually fires off within a few seconds of the message >> >> >arriving. > > >>I realise this is a little vague, but I'm wondering if anybody else has >>had this experience or observed this behaviour? >> >> >> >> >>------------------------------------------------------- >>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 > > |
|
From: Patrick Y. <kc...@ce...> - 2005-06-26 11:19:34
|
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 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]: => > DbConnectionPool.getConnection > 2005-06-21 09:13:34,384 DEBUG [Thread-8]: <= > 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]: => Transaction.rollback > (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]: => > DbConnectionPool.freeConnection > 2005-06-21 09:13:34,384 DEBUG [Thread-8]: <= > DbConnectionPool.freeConnection > 2005-06-21 09:13:34,384 DEBUG [Thread-8]: <= Transaction.rollback > 2005-06-21 09:13:34,384 DEBUG [Thread-8]: => > MessageServiceHandler.getNextUndeliveredMessage > 2005-06-21 09:13:34,384 DEBUG [Thread-8]: => > MessageServer.getUndeliveredMessages > 2005-06-21 09:13:34,384 DEBUG [Thread-8]: => > DbConnectionPool.getConnection > 2005-06-21 09:13:34,384 DEBUG [Thread-8]: => > 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]: => Transaction.rollback > (txID: #2323) > 2005-06-21 09:13:35,352 DEBUG [Thread-8]: <= Transaction.rollback > 2005-06-21 09:13:35,352 DEBUG [Thread-8]: => > MessageServiceHandler.getNextUndeliveredMessage > 2005-06-21 09:13:35,352 DEBUG [Thread-8]: => > MessageServer.getUndeliveredMessages > 2005-06-21 09:13:35,352 DEBUG [Thread-8]: => > DbConnectionPool.getConnection > 2005-06-21 09:13:35,352 DEBUG [Thread-8]: => > 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]: => Transaction.rollback > (txID: #2338) > 2005-06-21 09:13:42,384 DEBUG [Thread-8]: <= Transaction.rollback > 2005-06-21 09:13:42,384 DEBUG [Thread-8]: => > MessageServiceHandler.getNextUndeliveredMessage > 2005-06-21 09:13:42,384 DEBUG [Thread-8]: => > MessageServer.getUndeliveredMessages > 2005-06-21 09:13:42,384 DEBUG [Thread-8]: => > DbConnectionPool.getConnection > 2005-06-21 09:13:42,384 DEBUG [Thread-8]: => > 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 = 200 > HTTP response message = OK > at > hk.hku.cecid.phoenix.message.handler.Request.expectMapResponse(Unknown > Source) > at > hk.hku.cecid.phoenix.message.handler.Request.sendMessageServiceHandlerConfig(Unknown > Source) > at hk.hku.cecid.phoenix.message.handler.Request.register(Unknown > Source) > 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, 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 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 |
|
From: Patrick Y. <kc...@ce...> - 2005-06-26 11:06:45
|
How many records you have deleted then? -Patrick Steven Herod wrote: >Thanks so much for your reply. > >No, there was no message such as this because we deleted the contents of the >mshconfig table. >'TRUNC msh.mshconfig' is sql for deleting the contents of the table (TRUNC = >TRUNCATE) > >So, it wouldn't have had any errors in trying to load missing objects >because we removed the config table which tells it which objects to load. > >After starting hermes we restarted the app handler, and that resent both the >config and serialised objects to hermes and all was fine. > > > >-----Original Message----- >From: ebx...@li... >[mailto:ebx...@li...] On Behalf Of Patrick >Yee >Sent: Monday, 20 June 2005 11:35 PM >To: ebx...@li... >Subject: Re: [ebxmlms-general] Triggering a Incoming Listener > >Steven, >I am not sure about the effect of 'Trunc msh.mshconfig". Could you give me >more information on that? However, it seems a bit strange to me that you can >still restart Hermes successfully for moving aside the "objects*" files. The >reason is: during Hermes starts up, it will read the mshconfig table, each >entry there contains a file name which points to a serialized object. Hermes >will then read the serialized object in the objectStore folder. If it cannot >find the object, exceptions will be thrown. Did you aware of that in the log >file? >Regards, -Patrick > > >Steven Herod wrote: > > > >>Last night, after reading through the source code and gaining a >>stronger understanding of the system, we executed the following steps: >> >>Hermes shutdown >>Apphandler shutdown >>Ran the SQL: 'Trunc msh.mshconfig' >>move aside of the 'objects*' files in '~msh/objectStore' >>Start of hermes >>Start of apphandler >> >> >> >> >> > > > >------------------------------------------------------- >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 > > |
|
From: Patrick Y. <kc...@ce...> - 2005-06-26 11:02:48
|
You probably have input that configuration in msh.properties.xml. Please note that msh.properties.xml is for configuring Hermes server, while msh_client.properties.xml is for configuring the Hermes client. Regards, -Patrick Christine Zimmer wrote: >>RunLoopBack launches a Hermes client, which will need a configuration >>file to locate the Hermes server. The configuration is located at >>msh_client.properties.xml. You can find that file in your download >>package and you should put it in the classpath or current working >>directory when launching Hermes client. >> >> > > >I found that file, configured it and put it in the classpath, but nevertheless I get >this error. >And when deploying Hermes on Tomcat 5.5, it says: > > Hermes is alive. However, Hermes does not respond to HTTP GET method. > >msh.log says: >2005-06-20 17:34:15,234 DEBUG [Thread-31]: polling mail server for messages >2005-06-20 17:34:15,234 DEBUG [Thread-31]: => Mail.receive >2005-06-20 17:34:15,234 INFO [Thread-31]: Receiving pop3 messages from pop.web.de<INBOX> >2005-06-20 17:34:18,375 ERROR [Thread-31]: [10105] Invalid POP/IMAP server - Server: pop.web.de, Port: 110, Folder: INBOX, User: chr...@we... >User: chr...@we... Exception: javax.mail.MessagingException >Message: Connect failed; >nested exception is: >java.net.SocketTimeoutException: Read timed out > >I did not specify a server "pop.web.de" or an user "christine.obrien". > > Regards > Christine > > > >------------------------------------------------------- >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 > > |
|
From: Ronald v. K. <rtv...@xs...> - 2005-06-22 22:35:11
|
This is most likely not a hermes issue, but an issue of the ssl libs used. Try implementing a real simple https client and see what happens. Probabl= y the same error. Ronald Robert A. Stockfleth probeerde me het volgende duidelijk te maken: > After several more hours of testing and packet sniffing - it looks like > Hermes bombs out anytime a server tries to switch to SSL v3... How do = I get > Hermes to connect to a SSL3 server? It seems like it tries to use TLS > protocol because it doesn=92t support SSL3????? > > PLEASE help - I really want Hermes to work????! > > From packet sniffer: (192.168.20.165 =3D Hermes, 192.168.10.101 =3D Cy= clone) > -------------------------------------------------------------- > > No. Time Source Destination Protoco= l > Info > 34 9.128011 192.168.20.165 192.168.10.101 TCP > 1453 > https [SYN] Seq=3D0 Ack=3D0 Win=3D65535 Len=3D0 MSS=3D1460 > > 36 9.197628 192.168.10.101 192.168.20.165 TCP > https > 1453 [SYN, ACK] Seq=3D0 Ack=3D1 Win=3D16560 Len=3D0 MSS=3D1380 > > 37 9.197767 192.168.20.165 192.168.10.101 TCP > 1453 > https [ACK] Seq=3D1 Ack=3D1 Win=3D65535 [TCP CHECKSUM INCORRECT]= Len=3D0 > > 38 9.199660 192.168.20.165 192.168.10.101 SSLv2 > Client Hello > > 39 9.293068 192.168.10.101 192.168.20.165 TLS > Server Hello, Certificate, Certificate Request, Server Hello Done > > 40 9.484113 192.168.20.165 192.168.10.101 TCP > 1453 > https [ACK] Seq=3D101 Ack=3D1323 Win=3D64213 [TCP CHECKSUM INCOR= RECT] Len=3D0 > > 41 9.498985 192.168.20.165 192.168.10.101 TLS > Certificate, Client Key Exchange > > 42 9.512283 192.168.20.165 192.168.10.101 TLS > Change Cipher Spec > > 43 9.540430 192.168.20.165 192.168.10.101 TLS > Encrypted Handshake Message > > 44 9.601759 192.168.10.101 192.168.20.165 TLS > Alert (Level: Fatal, Description: Handshake Failure) > > 45 9.602017 192.168.10.101 192.168.20.165 TCP > https > 1453 [FIN, ACK] Seq=3D1330 Ack=3D247 Win=3D16560 Len=3D0 > > 46 9.602096 192.168.20.165 192.168.10.101 TCP > 1453 > https [ACK] Seq=3D290 Ack=3D1331 Win=3D64206 [TCP CHECKSUM INCOR= RECT] Len=3D0 > > 47 9.602259 192.168.20.165 192.168.10.101 TCP > 1453 > https [FIN, ACK] Seq=3D290 Ack=3D1331 Win=3D64206 [TCP CHECKSUM = INCORRECT] > Len=3D0 > > 48 9.602378 192.168.10.101 192.168.20.165 TCP > https > 1453 [RST] Seq=3D1331 Ack=3D3694123473 Win=3D0 Len=3D0 > > -------------------------------------------------------------- > > > > > > > ________________________________________ > From: Robert A. Stockfleth [mailto:ro...@no...] > Sent: Monday, June 20, 2005 3:27 PM > To: 'ebx...@li...' > Subject: SSLHandshakeException (SSL PROBLEM) > > Hello, I hope someone out there would be kind enough to help me out =96= I have > been struggling with this problem for a couple weeks now. > > I am running Hermes 1.0 on a Windows 2003 Server using Java 1.5.0_03 > runtime. Every time I attempt to send a message to =93othercompany=94=92= s MSH > server (not hermes, Cyclone I think) I receive the SSLHandshakeExceptio= n. I > have all the necessary trusted certs installed in my cacerts file that > Hermes is using as it=92s TrustedAnchor. I am able to sign messages wi= th the > test09 private key with no problem from the Monitor app. > > =93othercompany=94=92s MSH server requires that I send my certificate f= or > authentication. I have tested the authentication process in a browser = with > no problems. > > I have also tried the 9.31 version of Hermes with the same result. My > private key originally came in a .pfx file =96 I was able to sign messa= ges > from the Monitor application using the .pfx file, but when I put that a= s my > keystore in the config file for SSL, it would always say =93Cannot load= the > keystore on SSL client authentication : Cannot load keystore : Invalid > keystore format=94. So I programmatically put the private key into the= JKS > format. > > Is there a good way to debug the whole SSL handshaking process, I=92ve = seen > posts about "-Djavax.net.debug=3Dall" =96 but can somebody elaborate an= d be more > specific about what I need to do? > > Please help =96 I=92ve included as much pertinent information below as = I can > think of!!!!!! > > -Rob > > -- from log ---------- > Add SSL Client Authentication entry : https://othercompany/msh/ > \hermes\test.keystore > Sending message to https://othercompany/msh/ > Connection class : class > com.sun.net.ssl.internal.www.protocol.https.HttpsURLConnectionOldImpl > Instance of HttpsURLConnection : true > Configuration to a HTTPS connection > use key manager for url : https://othercompany/msh/ > [10505] Cannot send SOAP message Exception: > javax.net.ssl.SSLHandshakeException Message: Received fatal alert: > handshake_failure > ------------------------------------ > > -- from config file ------- > <SSL> > <!-- Optional property specifying the implementation class name o= f > com.sun.net.ssl.HostnameVerifier from JSSE 1.0 which handle = the > case > when the URL's hostname and the server's identification host= name > mismatch--> > <!-- <HostnameVerifier>Verifier</HostnameVerifier> --> > <TrustedAnchor> > <!-- Trust keystore for SSL Server Authentication --> > <KeyStore> > <Path>/hermes</Path> > <File>cacerts</File> > <Password>changeit</Password> > </KeyStore> > </TrustedAnchor> > > <ClientAuth> > <URL>https://othercompany/msh/</URL> > <KeyStore> > <Path>/hermes</Path> > <File>test.keystore</File> > <Alias>test09</Alias> > <Password>password</Password> > </KeyStore> > </ClientAuth> > </SSL> > ------------------------------------ > > > -- from keytool ------ > D:\jdk1.5.0_03\bin>keytool -list -keystore test.keystore > Enter keystore password: password > > Keystore type: jks > Keystore provider: SUN > > Your keystore contains 1 entries > > > test09, Jun 13, 2005, keyEntry, > Certificate fingerprint (MD5): > 5D:69:75:75:7C:6D:4A:E9:C6:82:4B:9F:A8:E6:52:05 > ------------------------------------ > > > > ------------------------------------------------------- > 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 |
266 messages has been excluded from this view by a project administrator.
