RE: [dtp-dev] Execute multiple SQL statements one by one [BZ 191721]

[Hui.Cao@xxxxxxxxxx]

Hi Dimiter,
        If
you are using the latest source code, have you updated the whole plugin
instead of just the grammar file? 'cause the parser is regerated.

Best Regards!

Max (Hui) Cao
Sybase Shanghai RD

jograham@xxxxxxxxxx
Sent by: dtp-dev-bounces@xxxxxxxxxxx

2007-06-14 04:56

Please respond to
DTP development mailing list <dtp-dev@xxxxxxxxxxx>

To	DTP development mailing list <dtp-dev@xxxxxxxxxxx>
cc
Subject	RE: [dtp-dev] Execute multiple SQL statements one by one [BZ 191721]

Hi Dimiter,

Max's fix was delivered yesterday, and will appear in the first DTP 1.5RC4
build, scheduled for this Friday (6/15).

Regards,
John Graham
Eclipse Data Tools Platform PMC Chair
Staff Software Engineer, Sybase, Inc.
http://dataplat.blogspot.com/



                    
                     
                     
          
             "Dimitrov,    
                     
                     
   
             Dimiter"    
                     
                     
     
             <d.dimitrov@sap.c  
                     
                 To 
             om>      
                "DTP development
mailing list"      
             Sent by:      
           <dtp-dev@xxxxxxxxxxx>  
            
             dtp-dev-bounces@e    
                     
               cc 
             clipse.org      
                     
                     
 
                    
                     
                     
  Subject 
                    
                  RE: [dtp-dev]
Execute multiple SQL  
             06/13/2007 04:47    
     statements one by one [BZ 191721]   
             PM        
                     
                     
       
                    
                     
                     
          
                    
                     
                     
          
             Please respond to    
                     
                  
              DTP development  
                     
                     
               mailing list    
                     
                     
             <dtp-dev@eclipse.  
                     
                    
                   org>
                     
                     
       
                    
                     
                     
          
                    
                     
                     
          




Hi Max,

Thank you for the fix, but unfortunately I didn't see diference. I tried
to
get last version 1.3 of
org.eclipse.datatools.sqltools.db.generic/grammar/sql.jjt and tested with
it, but the issue still exists. I separated the statements as you have
done
it in the test (with sequence ;\r\n ). Do you have idea where is my mistake
and whether I missed something?

Best Regards,
Dimiter

From: dtp-dev-bounces@xxxxxxxxxxx [mailto:dtp-dev-bounces@xxxxxxxxxxx]
On
Behalf Of Hui.Cao@xxxxxxxxxx
Sent: Friday, 8. June 2007 18:24
To: DTP development mailing list
Subject: RE: [dtp-dev] Execute multiple SQL statements one by one


Hi Dimiter,
        Sorry for the late reply. I was in a trip last
week and just got
the chance to look into the problem you encountered. This is a bug of the
Generic SQL Parser, which regards the separater (; or GO) as part of the
preceeding statement. I have fired a BZ 191721 for it and I'll ask the
DTP-PMC's approval to checkin this BZ in RC3. Thanks!

Best Regards!

Max (Hui) Cao
Sybase Shanghai RD

                    
                     
                     
          
 "Dimitrov, Dimiter"            
                     
                    
 <d.dimitrov@xxxxxxx>              
                     
                 
 Sent by:                  
                     
                     
   
 dtp-dev-bounces@xxxxxxxxxxx            
                     
         To 
                    
                     
    "DTP development mailing    
                    
                     
    list" <dtp-dev@xxxxxxxxxxx> 
 2007-05-29 00:26                
                     
                cc 
                    
                     
                     
          
                    
                     
                     
  Subject 
         Please respond to        
            RE: [dtp-dev] Execute  
    
   DTP development mailing list          
     multiple SQL statements one 
       <dtp-dev@xxxxxxxxxxx>      
            by one        
             
                    
                     
                     
          
                    
                     
                     
          
                    
                     
                     
          
                    
                     
                     
          
                    
                     
                     
          
                    
                     
                     
          
                    
                     
                     
          





Hi Hui,

Thank you for helpful direction. I estimated that I don’t need my own
SQL
parser (at least for now). I tried to separate SQL statements with
";"(which fortunately is default separator in MAXDB and this
is registered
in database definition too), but unfortunately GenericSQLParser didn’t
split statements, separated with it. I tried to debug the process, but
the
code is obfuscated and this code is not clear to me
(GenericSQLParser:1246):

      if (jj_2_14(2147483647)) {
        delimiter();
      } else {

The result is that the SQL Parser didn’t recognize the separators. This
is
an example snippet:

CREATE TABLE DD_ADDRESS (
                    
           ID INTEGER NOT NULL,
                    
           EGN TIMESTAMP,
                    
           STRING VARCHAR(255) UNICODE,
                    
           FAMILY VARCHAR(255) UNICODE,
                    
           NAME VARCHAR(255) UNICODE,
                    
           CITY VARCHAR(255) UNICODE,
                    
           NUMBER <UNKNOWN> NOT NULL
                );
ALTER TABLE DD_ADDRESS ADD CONSTRAINT DD_ADDRESS_PK PRIMARY KEY (ID)

Is the separator is used correct, or I have made mistake? I tried to type
it on new row, to use GO instead of, but without any success. I tried to
create JDBC connection to MAXDB and ORACLE in addition, but the behavior
remained the same. The interesting is that this work for Derby, but the
check is different (also unclear for me). Could you take a look and direct
me what the problem is?

Best Regards,
Dimiter



From: dtp-dev-bounces@xxxxxxxxxxx [mailto:dtp-dev-bounces@xxxxxxxxxxx]
On
Behalf Of Hui.Cao@xxxxxxxxxx
Sent: Thursday, 17. May 2007 04:34
To: DTP development mailing list
Subject: 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            
                     
         To 
                    
                     
     "DTP development mailing   
                    
                     
     list"            
         
 2007-05-16 23:52                
              <dtp-dev@xxxxxxxxxxx>
     
                    
                     
                     
       cc 
                    
                     
                     
          
          Please respond to      
                     
           Subject 
    DTP development mailing list        
       [dtp-dev] Execute multiple 
        <dtp-dev@xxxxxxxxxxx>      
            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_______________________________________________

dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev
_______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev


_______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev