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

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

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

Regards,
Patrick Yee
Center for E-Commerce Infrastructure Development

Making E-Commerce Everyday Commerce



Ronald van Kuijk wrote:

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