Skip to main content

[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>

"DTP development mailing list" <dtp-dev@xxxxxxxxxxx>
[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,

dtp-dev mailing list

Back to the top