[jboss-dev-forums] [Design of Messaging on JBoss (Messaging/JBoss)] - Re: JMS specific columns in DB

[timfox]

"clebert.suconic at jboss.com" wrote : 
  | 
  | It's even worse...
  | 
  | If you use composed fields... and if you need eventually to perform a JOIN...
  | you will need to do something like
  | WHERE SUBSTRING(COMPOSED_FIELD,1,5) = "DESTINATION"
  | 
  | or something like that...
  | 
  | 

Read my previous answer. Anything that is used in joins is in it's own field.

The core "destination" is the channel. This what the core is concerned with. The Jms destination means nothing to the core, it's just a piece of baggage that's passed around. That's pretty much already the case.


anonymous wrote : 
  | If you have 100 systems... it's better to have 100 columns than a single column with 100 substrings to deal with. :-)
  | 

Who said you'd have to deal with substrings?


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4011812#4011812

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4011812