Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on May 16th, 2012  |  syntax: XML  |  size: 1.79 KB  |  hits: 18  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. <dataConfig>
  2.         <dataSource driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/noticias" user="root" password="pedro"/>
  3.         <document>
  4.                 <entity name="ARTICLEbase" query="SELECT * FROM ARTICLEbase">
  5.                         <field column="serial" name="id"/>
  6.                         <field column="title" name="title_t"/>
  7.                         <field column="approval_on" name="data_dt"/>
  8.  
  9.                         <entity name="ARTICLEcontent_lead" query="SELECT * FROM ARTICLEcontent where (type='1' AND artigo='${ARTICLEbase.serial}' )">
  10.                                 <field column="stuff" name="lead_t"/>
  11.                         </entity>
  12.  
  13.                         <entity name="ARTICLEcontent_texto" query="SELECT * FROM ARTICLEcontent where (type='2' AND artigo='${ARTICLEbase.serial}' )">
  14.                                 <field column="stuff" name="texto_t"/>
  15.                         </entity>
  16.                        
  17.                         <entity name="ARTICLEcontent_antTitulo" query="SELECT * FROM ARTICLEcontent where (type='3' AND artigo='${ARTICLEbase.serial}' )">
  18.                                 <field column="stuff" name="texto_t"/>
  19.                         </entity>
  20.                        
  21.                         <entity name="ARTICLEcontent_teletexto_titulo" query="SELECT * FROM ARTICLEcontent where (type='9' AND artigo='${ARTICLEbase.serial}' )">
  22.                                 <field column="stuff" name="texto_t"/>
  23.                         </entity>
  24.                        
  25.                         <entity name="ARTICLEcontent_teletexto_texto" query="SELECT * FROM ARTICLEcontent where (type='10' AND artigo='${ARTICLEbase.serial}' )">
  26.                                 <field column="stuff" name="texto_t"/>
  27.                         </entity>
  28.                        
  29.                         <entity name="ARTICLEcontent_artRelacionados" query="SELECT * FROM ARTICLEcontent where (type='13' AND artigo='${ARTICLEbase.serial}' )">
  30.                                 <field column="stuff" name="texto_t"/>
  31.                         </entity>
  32.                        
  33.                         <entity name="ARTICLEtopic" query="SELECT * FROM (ARTICLEtopic LEFT JOIN ARTICLEtopictxt ON ARTICLEtopic.topic = ARTICLEtopictxt.serial) WHERE ARTICLEtopic.article='${ARTICLEbase.serial}'">
  34.                                 <field column="legenda" name="topic_s"/>
  35.                         </entity>
  36.  
  37.                 </entity>
  38.  
  39.         </document>
  40. </dataConfig>
create a new version of this paste RAW Paste Data