Hi Lukas,
I'm quite new to jooq but it seems to me that sqlxml support is
missing. In another post you said that is quite difficult to integrate it
in jooq and suggested to use somthing like a converter on column.
By now I'got a lot of xml code saved on db and often is managed by sql
queries.
(Use a stored is not an option for me cause I want just tables and no
others vendor dependent code on db causa I've got a lot of cross db shared
code).
My question is have you in plan to support jdbc sqlxml in the future? I was
using querydsl-sql in the past and I've suggested support that functions
and was made quite easily.
This is reference to
https://github.com/querydsl/querydsl/issues/1034
In some cases String conversion is ok but there are some limitation (i.e.
size) expecially on oracle so use sqlxml (streaming) works fine.
Also what about xpath operator native support?
I mean, do you think queries like the two following one could be supported
(near to native way, I know you can write it using expressions ) in the
future?
I would like to understand the approach to this kind of data managment on
middle-long terms.
Tks
Denis
*T-SQL*
WITH XML_QAS (
SELECT TOP (10) NM_Notifiche.ID_Notifica
,NM_Notifiche.ID_Evento
,NM_Notifiche.ID_tp_notifica
,NM_Notifiche.data
,NM_Notifiche.data_notifica
,NM_Notifiche.data_evasione
,NM_Notifiche.nrTentativo
,NM_Notifiche.note
,NM_Eventi.ID_Evento AS Expr1
,NM_Eventi.ID_tp_evento
,NM_Eventi.data AS Expr2
,NM_Eventi.data_notifica AS Expr3
,NM_Eventi.messaggio
,MAIL.value('subject[1]', 'nvarchar(255)') AS MAIL_SUBJECT
,MAIL.value('text[1]', 'nvarchar(255)') AS MAIL_TEXT
,MAIL.value('attachments[1]', 'nvarchar(255)') AS
MAIL_ATTACHMENT
,MAIL.value('idNotifica[1]', 'nvarchar(255)') AS ID_NOTIFICAXML
FROM NM_Notifiche
INNER JOIN NM_Eventi ON NM_Notifiche.ID_Evento = NM_Eventi.ID_Evento
CROSS APPLY
[messaggio].nodes('/nmMsgMessage[1]/notifiers[1]/*[idNotifica=sql:column("NM_Notifiche.ID_Notifica")]')
AS T_MESSAGGIO(MAIL)
WHERE NM_Notifiche.ID_EVENTO = 2548
)SELECT *FROM XML_QWHERE MAIL_SUBJECT NOT LIKE 'Sql monitor%'
AND MAIL_SUBJECT NOT LIKE '%SQLException%'
*PG*
WITH notifiers_xmlAS (
SELECT e.id_evento
,n.id_notifica
,unnest(xpath('/nmMsgMessage/notifiers/*', e.messaggio)) AS
notifier_xml
,unnest(xpath('/nmMsgMessage/notifiers/*/idNotifica/text()',
e.messaggio)::TEXT []::INT []) AS id_notifica_xml
FROM nm_eventi e
INNER JOIN nm_notifiche n ON e.id_evento = n.id_evento
WHERE e.id_evento = 7916
)SELECT id_evento
,id_notifica
,notifier_xml
,(xpath('/nmMsgMailNotifier/from/text()', notifier_xml)::TEXT []) [1]
ASFROM
,(xpath('/nmMsgMailNotifier/to/address/text()', notifier_xml)::TEXT [])
[1] AS recipients
,(xpath('/nmMsgMailNotifier/cc/address/text()', notifier_xml)::TEXT [])
[1] AS cc
,(xpath('/nmMsgMailNotifier/bcc/address/text()', notifier_xml)::TEXT
[]) [1] AS bcc
,(xpath('/nmMsgMailNotifier/subject/text()', notifier_xml)::TEXT [])
[1] AS subject
,(xpath('/nmMsgMailNotifier/text/text()', notifier_xml)::TEXT []) [1]
AS TEXTFROM notifiers_xmlWHERE id_notifica = id_notifica_xml
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
