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

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

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

Regards,
Patrick Yee
Center for E-Commerce Infrastructure Development

Making E-Commerce Everyday Commerce



Ronald van Kuijk wrote:

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