[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
|
Re: [dtp-dev] Execute multiple SQL statements one by one
|
Hi Dimiter,
You
don't need to implement your own action. The "Execute All"/"Execute
Selected" actions in SQL editor takes care of this issue for you by
separating the SQL statements using statement terminators defined by SQLParser.
The default terminators are "GO" and ";" which are
defined in GenericeSQLParser. If it does not work for MAXDB, you can override
it in your MAXDB parser. To hook your parser into the framework, here are
the steps:
1. provide a org.eclipse.datatools.sqltools.editor.core.dbConfigurations
extension
2. return your parser in your MAXDBConfiguration.getSQLService().getSQLParser()
method
For other extensible behaviors, please
refer to SQLDevToolsTutorial.pdf located in the org.eclipse.datatools.sqltools/documents
directory of the datatools cvs repository.
Best Regards!
Max (Hui) Cao
Sybase Shanghai RD
"Dimitrov, Dimiter"
<d.dimitrov@xxxxxxx>
Sent by: dtp-dev-bounces@xxxxxxxxxxx
2007-05-16 23:52
|
Please respond to
DTP development mailing list <dtp-dev@xxxxxxxxxxx> |
|
|
To
| "DTP development mailing
list" <dtp-dev@xxxxxxxxxxx>
|
|
cc
|
|
|
Subject
| [dtp-dev] Execute multiple
SQL statements one by one |
|
Hi there,
I
want to ask a question related to the execution of SQL statements from
org.eclipse.datatools.sqltools.sqlscrapbook.SQLScrapbookEditor. I had
to execute multiple statements against MAXDB, but unfortunately MAXDB does
not have a possibility to execute multiple statements in one JDBC call.
So the solution is to execute the multiple statements one by one (but transparent
for the user �C not in the way, in which this functionality is realized
in Outline view). So my question is whether is possible to implement myself
this action (Execute All) depends on the connection and if yes how to do
that.
Thank you in advance,
Dimiter
_______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev
