Jump to content


Photo

Converter Um Select De Mysql Para Hsql


  • Faça o login para participar
4 replies to this topic

#1 crmclau

crmclau

    Novato no fórum

  • Usuários
  • 1 posts
  • Sexo:Feminino

Posted 14/05/2010, 15:01

Olá!

Eu preciso converter um Select feito para MySQL :

StringBuffer query = new StringBuffer( "SELECT cr.id AS chatid, cm.chatRoomId, cm.id, cm.senderId, cm.dateTime, cm.attachFileId, sst.TOOL_ID, GROUP_CONCAT(cm.txtMessage, CONCAT_WS(',',par.name,cm.
dateTime,' ')) AS txtmessage , cm.channelId, cr.laid,cr.coordinator, l.id, l.title, par.name,par.la_fk, ssp.SITE_ID, ssp.PAGE_ID, ssp.PAGE_ID FROM SAKAI_SITE_PAGE AS ssp, SAKAI_SITE_TOOL AS sst, chatmessage AS cm, chatroom AS cr, la AS l, participant AS par WHERE ssp.TITLE = 'Chat' AND l.toolid = '2' AND cr.laid = par.la_fk AND ssp.SITE_ID = l.worksiteid AND cr.laid = l.id AND cm.chatRoomId = cr.id AND ssp.PAGE_ID = sst.PAGE_ID AND cm.dateTime BETWEEN \'");
query.append("\' AND \'") ;
query.append(finalDate);
query.append("\' GROUP BY cm.chatRoomId");

Eu já li vários fóruns sobre HSQL, fiz algumas tentativas mas todas sem sucesso!
O problema é que não encontro nada que pode substituir as funções do MySql: GROUP_CONCAT, CONCAT_WS, e em uma outra consulta o SUBSTRING_INDEX.

Alguém pode me ajudar, please?????????

Agradeço desde já!

#2 Miguceamma

Miguceamma

    MiguPenjisse

  • Usuários
  • 11724 posts

Posted 12/09/2017, 23:53

Amoxil Bd cialis By Requip Online La Viagra Y Sus Efectos Viagra For .75 A Pill Medsindia cialis Cialis 20mg 12 St Preisvergleich
Ceallas And Viag For Sale cialis Keflex Pregnant Xenical En Ligne Amoxicillin 500mgs cialis Kaufen Viagra Billig
Cephalexin Safety In Pregnancy cialis Free Shipping Stendra Want To Buy No Script Needed
Cialis 5mg Tadalafil Lilly Order Now Bentyl With Free Shipping Drugs
Cephalexin For Dental <a href=http://cialtobuy.com>buy cialis</a> Q Es Propecia

#3 Miguceamma

Miguceamma

    MiguPenjisse

  • Usuários
  • 11724 posts

Posted 21/09/2017, 12:21

Generic Alternative To Cialis cialis online Info Cephalexin 250mg 400 Mg Metronidazole No Prescription Cialis Ha Funzionato Viagra Compresse Costo cialis online Canadian Pharmacy 24h Catalog
Nizoral Canada cialis Acquisto Levitra Generico
Cialis Vendita On Line In Italia Propecia Side Effects Rash Cialis Original Preis
Similar A Propecia <a href=http://cialtobuy.com>generic cialis</a> Priligy 30 Mg Cuanto Cuesta

#4 LarPhozyHah

LarPhozyHah

    Super Veterano

  • Usuários
  • 14515 posts
  • Sexo:Masculino
  • Localidade:San Miguel de Tucuman

Posted 30/09/2017, 10:50

Vendo Kamagra Cialis online pharmacy Propecia Barba

#5 Miguceamma

Miguceamma

    MiguPenjisse

  • Usuários
  • 11724 posts

Posted 26/10/2017, 23:12

My Canadian Pharcharmy Androgel When Will Alli Diet Pill Be Available vardenafil 20 mg.no prescription Do People Overdose On Amoxicillin Cephalexin Online Pharmacy
Can You Have Alcohol With Amoxil viagra Viagra Como Se Toma




0 user(s) are reading this topic

0 membro(s), 0 visitante(s) e 0 membros anônimo(s)

IPB Skin By Virteq