Eclipse Community Forums - RDF feed
https://www.eclipse.org/forums/
Eclipse Community ForumsListening to SQL Results
https://www.eclipse.org/forums/index.php/mv/msg/15540/49706/#msg_49706
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
Hello all,<br>
<br>
I want to catch all the SQL statements (insert, removes & updates)
that the user executes in a database in my RCP application (and then
save them <u>when the editor is disposed</u> to an <u>incremental</u>
XML file, to create sort of a log on what happened/was executed to a
particular table across all sessions in my RCP app).<br>
<br>
My first guess was to see how the "SQL Results View" is doing the
listening and replicate this behavior; However the listener seems to be
in an "internal" package. So, no workaround here!?<br>
<br>
Other than that ... I saw the existence of the extension points
provided by the results plugin: <b>reExecuteScript</b>, <b>resultSetOutputter</b>,
<b>resultSetViewer</b>;<br>
Do these allow me to do the job? Are there any examples on the use of
these?<br>
<br>
Thanks a lot!<br>
ARibeiro<br>
</body>
</html>]]>Andre Ribeiro2008-09-05T10:05:01-00:00Re: Listening to SQL Results
https://www.eclipse.org/forums/index.php/mv/msg/15540/49739/#msg_49739
Originally posted by: hui.cao.sybase.ocm
Hi Andr=E9,
Please feel free to open a BZ for exposing the interface. The 3 =
extension points are not designed for your case: "reExecuteScript" is =
used to re-execute a result instance which is invoked via context menu =
in the view; "resultSetOutputter" is used to save the results in =
different formats as a concequence of "save"/"export" actions; =
"resultSetViewer" allows the results to be viewed in another UI =
component, such as Visual SQL Builder.=20
I want to catch all the SQL statements (insert, removes & updates) =
that the user executes in a database in my RCP application (and then =
save them when the editor is disposed to an incremental XML file, to =
create sort of a log on what happened/was executed to a particular table =
across all sessions in my RCP app).
My first guess was to see how the "SQL Results View" is doing the =
listening and replicate this behavior; However the listener seems to be =
in an "internal" package. So, no workaround here!?
Other than that ... I saw the existence of the extension points =
provided by the results plugin: reExecuteScript, resultSetOutputter, =
resultSetViewer;
Do these allow me to do the job? Are there any examples on the use of =
these?
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.6000.16705" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY text=3D#000000 bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi <FONT face=3D"Times New Roman"=20
size=3D3>Andr=E9,</FONT></FONT></DIV>
<DIV><FONT face=3DArial size=3D2> Please feel free to =
open a BZ=20
for exposing the interface. The 3 extension points are not designed for =
your=20
case: <FONT face=3D"Times New Roman"><FONT=20
size=3D3><STRONG>"</STRONG><STRONG>reExecuteScript" </STRONG>is used to =
re-execute=20
a result instance which is invoked via context menu in the =
view;=20
<STRONG>"resultSetOutputter" </STRONG>is used to save the results in =
different=20
formats as a concequence of "save"/"export" actions; =
<STRONG>"resultSetViewer"=20
</STRONG>allows the results to be viewed in another UI component, such =
as Visual=20
SQL Builder. </FONT></FONT></FONT></DIV>
<DIV><BR>-- <BR>Best Regards!</DIV>
<DIV> </DIV>
<DIV>Max (Hui) Cao<BR>Sybase Shanghai RD</DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Andr=E9 Ribeiro" <<A=20
href=3D"mailto:aferrazlr@gmail.com">aferrazlr@gmail.com</A>> wrote =
in message=20
<A=20
=
href=3D"news:48C1044D.9020804@gmail.com">news:48C1044D.9020804@gmail.com<=
/A>...</DIV>Hello=20
all,<BR><BR>I want to catch all the SQL statements (insert, removes =
&=20
updates) that the user executes in a database in my RCP application =
(and then=20
save them <U>when the editor is disposed</U> to an <U>incremental</U> =
XML=20
file, to create sort of a log on what happened/was executed to a =
particular=20
table across all sessions in my RCP app).<BR><BR>My first guess was to =
see how=20
the "SQL Results View" is doing the listening and replicate this =
behavior;=20
However the listener seems to be in an "internal" package. So, no =
workaround=20
here!?<BR><BR>Other than that ... I saw the existence of the extension =
points=20
provided by the results plugin: <B>reExecuteScript</B>,=20
<B>resultSetOutputter</B>, <B>resultSetViewer</B>;<BR>Do these allow =
me to do=20
the job? Are there any examples on the use of these?<BR><BR>Thanks a=20
lot!<BR>ARibeiro<BR></BLOCKQUOTE></BODY></HTML>
Hi Andr=E9,
Please feel free to open a BZ for exposing the interface. The 3 =
extension points are not designed for your case: "reExecuteScript" is =
used to re-execute a result instance which is invoked via context menu =
in the view; "resultSetOutputter" is used to save the results in =
different formats as a concequence of "save"/"export" actions; =
"resultSetViewer" allows the results to be viewed in another UI =
component, such as Visual SQL Builder.=20
I want to catch all the SQL statements (insert, removes & updates) =
that the user executes in a database in my RCP application (and then =
save them when the editor is disposed to an incremental XML file, to =
create sort of a log on what happened/was executed to a particular table =
across all sessions in my RCP app).
My first guess was to see how the "SQL Results View" is doing the =
listening and replicate this behavior; However the listener seems to be =
in an "internal" package. So, no workaround here!?
Other than that ... I saw the existence of the extension points =
provided by the results plugin: reExecuteScript, resultSetOutputter, =
resultSetViewer;
Do these allow me to do the job? Are there any examples on the use of =
these?
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.6000.16705" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY text=3D#000000 bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi <FONT face=3D"Times New Roman"=20
size=3D3>Andr=E9,</FONT></FONT></DIV>
<DIV><FONT face=3DArial size=3D2> Please feel free to =
open a BZ=20
for exposing the interface. The 3 extension points are not designed for =
your=20
case: <FONT face=3D"Times New Roman"><FONT=20
size=3D3><STRONG>"</STRONG><STRONG>reExecuteScript" </STRONG>is used to =
re-execute=20
a result instance which is invoked via context menu in the =
view;=20
<STRONG>"resultSetOutputter" </STRONG>is used to save the results in =
different=20
formats as a concequence of "save"/"export" actions; =
<STRONG>"resultSetViewer"=20
</STRONG>allows the results to be viewed in another UI component, such =
as Visual=20
SQL Builder. </FONT></FONT></FONT></DIV>
<DIV><BR>-- <BR>Best Regards!</DIV>
<DIV> </DIV>
<DIV>Max (Hui) Cao<BR>Sybase Shanghai RD</DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Andr=E9 Ribeiro" <<A=20
href=3D"mailto:aferrazlr@gmail.com">aferrazlr@gmail.com</A>> wrote =
in message=20
<A=20
=
href=3D"news:48C1044D.9020804@gmail.com">news:48C1044D.9020804@gmail.com<=
/A>...</DIV>Hello=20
all,<BR><BR>I want to catch all the SQL statements (insert, removes =
&=20
updates) that the user executes in a database in my RCP application =
(and then=20
save them <U>when the editor is disposed</U> to an <U>incremental</U> =
XML=20
file, to create sort of a log on what happened/was executed to a =
particular=20
table across all sessions in my RCP app).<BR><BR>My first guess was to =
see how=20
the "SQL Results View" is doing the listening and replicate this =
behavior;=20
However the listener seems to be in an "internal" package. So, no =
workaround=20
here!?<BR><BR>Other than that ... I saw the existence of the extension =
points=20
provided by the results plugin: <B>reExecuteScript</B>,=20
<B>resultSetOutputter</B>, <B>resultSetViewer</B>;<BR>Do these allow =
me to do=20
the job? Are there any examples on the use of these?<BR><BR>Thanks a=20
lot!<BR>ARibeiro<BR></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0010_01C911CD.AF3258D0--]]>Hui Cao2008-09-08T08:12:26-00:00Re: Listening to SQL Results
https://www.eclipse.org/forums/index.php/mv/msg/15540/49769/#msg_49769
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
a BZ ?! :)<br>
<br>
Hui Cao wrote:
<blockquote cite="mid:ga2mpo$l7c$1@build.eclipse.org" type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta content="MSHTML 6.00.6000.16705" name="GENERATOR">
<style></style>
<div><font face="Arial" size="2">Hi <font face="Times New Roman"
size="3">André,</font></font></div>
<div><font face="Arial" size="2"> Please feel free to open a BZ
for exposing the interface. The 3 extension points are not designed for
your case: <font face="Times New Roman"><font size="3"><strong>"</strong><strong>reExecuteScript"
</strong>is used to re-execute a result instance which is invoked via
context menu in the view; <strong>"resultSetOutputter" </strong>is
used to save the results in different formats as a concequence of
"save"/"export" actions; <strong>"resultSetViewer" </strong>allows
the results to be viewed in another UI component, such as Visual SQL
Builder. </font></font></font></div>
<div><br>
-- <br>
Best Regards!</div>
<div> </div>
<div>Max (Hui) Cao<br>
Sybase Shanghai RD</div>
<blockquote
style="border-left: 2px solid rgb(0, 0, 0); padding-right: 0px; padding-left: 5px; margin-left: 5px; margin-right: 0px;">
<div>"André Ribeiro" <<a moz-do-not-send="true"
href="mailto:aferrazlr@gmail.com">aferrazlr@gmail.com</a>> wrote in
message <a moz-do-not-send="true"
href="news:48C1044D.9020804@gmail.com">news:48C1044D.9020804@gmail.com</a>...</div>
Hello all,<br>
<br>
I want to catch all the SQL statements (insert, removes & updates)
that the user executes in a database in my RCP application (and then
save them <u>when the editor is disposed</u> to an <u>incremental</u>
XML file, to create sort of a log on what happened/was executed to a
particular table across all sessions in my RCP app).<br>
<br>
My first guess was to see how the "SQL Results View" is doing the
listening and replicate this behavior; However the listener seems to be
in an "internal" package. So, no workaround here!?<br>
<br>
Other than that ... I saw the existence of the extension points
provided by the results plugin: <b>reExecuteScript</b>, <b>resultSetOutputter</b>,
<b>resultSetViewer</b>;<br>
Do these allow me to do the job? Are there any examples on the use of
these?<br>
<br>
Thanks a lot!<br>
ARibeiro<br>
</blockquote>
</blockquote>
</body>
</html>]]>Andre Ribeiro2008-09-08T09:02:16-00:00Re: Listening to SQL Results
https://www.eclipse.org/forums/index.php/mv/msg/15540/593049/#msg_593049
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
a BZ ?! :)<br>
<br>
Hui Cao wrote:
<blockquote cite="mid:ga2mpo$l7c$1@build.eclipse.org" type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta content="MSHTML 6.00.6000.16705" name="GENERATOR">
<style></style>
<div><font face="Arial" size="2">Hi <font face="Times New Roman"
size="3">André,</font></font></div>
<div><font face="Arial" size="2"> Please feel free to open a BZ
for exposing the interface. The 3 extension points are not designed for
your case: <font face="Times New Roman"><font size="3"><strong>"</strong><strong>reExecuteScript"
</strong>is used to re-execute a result instance which is invoked via
context menu in the view; <strong>"resultSetOutputter" </strong>is
used to save the results in different formats as a concequence of
"save"/"export" actions; <strong>"resultSetViewer" </strong>allows
the results to be viewed in another UI component, such as Visual SQL
Builder. </font></font></font></div>
<div><br>
-- <br>
Best Regards!</div>
<div> </div>
<div>Max (Hui) Cao<br>
Sybase Shanghai RD</div>
<blockquote
style="border-left: 2px solid rgb(0, 0, 0); padding-right: 0px; padding-left: 5px; margin-left: 5px; margin-right: 0px;">
<div>"André Ribeiro" <<a moz-do-not-send="true"
href="mailto:aferrazlr@gmail.com">aferrazlr@gmail.com</a>> wrote in
message <a moz-do-not-send="true"
href="news:48C1044D.9020804@gmail.com">news:48C1044D.9020804@gmail.com</a>...</div>
Hello all,<br>
<br>
I want to catch all the SQL statements (insert, removes & updates)
that the user executes in a database in my RCP application (and then
save them <u>when the editor is disposed</u> to an <u>incremental</u>
XML file, to create sort of a log on what happened/was executed to a
particular table across all sessions in my RCP app).<br>
<br>
My first guess was to see how the "SQL Results View" is doing the
listening and replicate this behavior; However the listener seems to be
in an "internal" package. So, no workaround here!?<br>
<br>
Other than that ... I saw the existence of the extension points
provided by the results plugin: <b>reExecuteScript</b>, <b>resultSetOutputter</b>,
<b>resultSetViewer</b>;<br>
Do these allow me to do the job? Are there any examples on the use of
these?<br>
<br>
Thanks a lot!<br>
ARibeiro<br>
</blockquote>
</blockquote>
</body>
</html>]]>Andre Ribeiro2008-09-08T09:02:16-00:00Re: Listening to SQL Results
https://www.eclipse.org/forums/index.php/mv/msg/15540/49799/#msg_49799
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
oh yeah right a BugZilla! ... <br>
<br>
<a class="moz-txt-link-freetext" href="https://bugs.eclipse.org/bugs/show_bug.cgi?id=246536">https://bugs.eclipse.org/bugs/show_bug.cgi?id=246536</a><br>
<br>
thanks,<br>
AR<br>
<br>
André Ribeiro wrote:
<blockquote cite="mid:48C4EA18.5090705@gmail.com" type="cite">
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
a BZ ?! :)<br>
<br>
Hui Cao wrote:
<blockquote cite="mid:ga2mpo$l7c$1@build.eclipse.org" type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta content="MSHTML 6.00.6000.16705" name="GENERATOR">
<style></style>
<div><font face="Arial" size="2">Hi <font face="Times New Roman"
size="3">André,</font></font></div>
<div><font face="Arial" size="2"> Please feel free to open a BZ
for exposing the interface. The 3 extension points are not designed for
your case: <font face="Times New Roman"><font size="3"><strong>"</strong><strong>reExecuteScript"
</strong>is used to re-execute a result instance which is invoked
via
context menu in the view; <strong>"resultSetOutputter" </strong>is
used to save the results in different formats as a concequence of
"save"/"export" actions; <strong>"resultSetViewer" </strong>allows
the results to be viewed in another UI component, such as Visual SQL
Builder. </font></font></font></div>
<div><br>
-- <br>
Best Regards!</div>
<div> </div>
<div>Max (Hui) Cao<br>
Sybase Shanghai RD</div>
<blockquote
style="border-left: 2px solid rgb(0, 0, 0); padding-right: 0px; padding-left: 5px; margin-left: 5px; margin-right: 0px;">
<div>"André Ribeiro" <<a moz-do-not-send="true"
href="mailto:aferrazlr@gmail.com">aferrazlr@gmail.com</a>> wrote in
message <a moz-do-not-send="true"
href="news:48C1044D.9020804@gmail.com">news:48C1044D.9020804@gmail.com</a>...</div>
Hello all,<br>
<br>
I want to catch all the SQL statements (insert, removes & updates)
that the user executes in a database in my RCP application (and then
save them <u>when the editor is disposed</u> to an <u>incremental</u>
XML file, to create sort of a log on what happened/was executed to a
particular table across all sessions in my RCP app).<br>
<br>
My first guess was to see how the "SQL Results View" is doing the
listening and replicate this behavior; However the listener seems to be
in an "internal" package. So, no workaround here!?<br>
<br>
Other than that ... I saw the existence of the extension points
provided by the results plugin: <b>reExecuteScript</b>, <b>resultSetOutputter</b>,
<b>resultSetViewer</b>;<br>
Do these allow me to do the job? Are there any examples on the use of
these?<br>
<br>
Thanks a lot!<br>
ARibeiro<br>
</blockquote>
</blockquote>
</blockquote>
</body>
</html>]]>Andre Ribeiro2008-09-08T09:30:08-00:00Re: Listening to SQL Results
https://www.eclipse.org/forums/index.php/mv/msg/15540/593055/#msg_593055
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
oh yeah right a BugZilla! ... <br>
<br>
<a class="moz-txt-link-freetext" href="https://bugs.eclipse.org/bugs/show_bug.cgi?id=246536">https://bugs.eclipse.org/bugs/show_bug.cgi?id=246536</a><br>
<br>
thanks,<br>
AR<br>
<br>
André Ribeiro wrote:
<blockquote cite="mid:48C4EA18.5090705@gmail.com" type="cite">
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
a BZ ?! :)<br>
<br>
Hui Cao wrote:
<blockquote cite="mid:ga2mpo$l7c$1@build.eclipse.org" type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta content="MSHTML 6.00.6000.16705" name="GENERATOR">
<style></style>
<div><font face="Arial" size="2">Hi <font face="Times New Roman"
size="3">André,</font></font></div>
<div><font face="Arial" size="2"> Please feel free to open a BZ
for exposing the interface. The 3 extension points are not designed for
your case: <font face="Times New Roman"><font size="3"><strong>"</strong><strong>reExecuteScript"
</strong>is used to re-execute a result instance which is invoked
via
context menu in the view; <strong>"resultSetOutputter" </strong>is
used to save the results in different formats as a concequence of
"save"/"export" actions; <strong>"resultSetViewer" </strong>allows
the results to be viewed in another UI component, such as Visual SQL
Builder. </font></font></font></div>
<div><br>
-- <br>
Best Regards!</div>
<div> </div>
<div>Max (Hui) Cao<br>
Sybase Shanghai RD</div>
<blockquote
style="border-left: 2px solid rgb(0, 0, 0); padding-right: 0px; padding-left: 5px; margin-left: 5px; margin-right: 0px;">
<div>"André Ribeiro" <<a moz-do-not-send="true"
href="mailto:aferrazlr@gmail.com">aferrazlr@gmail.com</a>> wrote in
message <a moz-do-not-send="true"
href="news:48C1044D.9020804@gmail.com">news:48C1044D.9020804@gmail.com</a>...</div>
Hello all,<br>
<br>
I want to catch all the SQL statements (insert, removes & updates)
that the user executes in a database in my RCP application (and then
save them <u>when the editor is disposed</u> to an <u>incremental</u>
XML file, to create sort of a log on what happened/was executed to a
particular table across all sessions in my RCP app).<br>
<br>
My first guess was to see how the "SQL Results View" is doing the
listening and replicate this behavior; However the listener seems to be
in an "internal" package. So, no workaround here!?<br>
<br>
Other than that ... I saw the existence of the extension points
provided by the results plugin: <b>reExecuteScript</b>, <b>resultSetOutputter</b>,
<b>resultSetViewer</b>;<br>
Do these allow me to do the job? Are there any examples on the use of
these?<br>
<br>
Thanks a lot!<br>
ARibeiro<br>
</blockquote>
</blockquote>
</blockquote>
</body>
</html>]]>Andre Ribeiro2008-09-08T09:30:08-00:00