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

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

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

Ronald

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


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