Re: [dtp-connect-dev] Where to get the shared connection?

[Hui.Cao@xxxxxxxxxx]

Rob,
        BTW,
these 2 requirements are needed for SQL Dev Tools M3, so it'll be too late
if we can only get these API in M4.

Best Regards!

Max ( Hui ) Cao
DTP SQL Dev Tools committer
Sr S/W Eng - Dev
Sybase, Inc. Shanghai, China

Hui.Cao@xxxxxxxxxx
Sent by: dtp-connect-dev-bounces@xxxxxxxxxxx

01/09/2006 11:30 AM

Please respond to
DTP Connectivity project development list <dtp-connect-dev@xxxxxxxxxxx>

To	DTP Connectivity project development list <dtp-connect-dev@xxxxxxxxxxx>
cc
Subject	Re: [dtp-connect-dev] Where to get the shared connection?

Rob, 
        Thanks for replying to my email.
        For both the shared SQL model database object
and the shared connection, can we have some kind of static API to access
them? e.g. IConnection ConnectionProfileManager.getSharedConnection(String
connectionProfileName, String connectionFactoryId)? I feel this API is
necessary because multiple clients such as Data Source Explorer and SQL
Dev Tools need to access the IConnection object without having to each
creating a connection of their own. Just for your reference.
        I have added comments
in bugzilla bug 114400 about requirements from SQL Dev Tools. It'll be
highly appreciated if the IllegalStateException problem caused by IConnectionProfile.createConnection
can be addressed soon if possible. 

Best Regards!

Max ( Hui ) Cao
Sr S/W Eng - Dev
Sybase, Inc. Shanghai, China
Tel: 86-21-68799918-3047

rcernich@xxxxxxxxxx
Sent by: dtp-connect-dev-bounces@xxxxxxxxxxx

01/07/2006 07:44 AM

Please respond to
DTP Connectivity project development list <dtp-connect-dev@xxxxxxxxxxx>

To	DTP Connectivity project development list <dtp-connect-dev@xxxxxxxxxxx>
cc
Subject	Re: [dtp-connect-dev] Where to get the shared connection?

Hui,

Sorry for taking so long to get back to you.

Currently, the SQL model can be accessed using the java.sql.Connection
factory.  This factory returns an object of type ConnectionInfo.  From
this
object, use the getSharedDatabase() method to get the SQL model Database
object.  getSharedConnection() and getRawConnection() both return
the
underlying java.sql.Connection used by the ConnectionInfo object.

We will be refactoring this for M3 so that it functions as specified in
the
quick start guide (or at least close to what is specified).  So, for
M3,
you will need to use
org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfo
for the connection factory ID and getRawConnection() on the returned
object will be a ConnectionInfo object.  The java.sql.Connection factory
will return a java.sql.Connection.

ConnectionInfo.getSharedConnection() is slightly misnamed, since it returns
the java.sql.Connection object used by the underlying ConnectionInfo
implementation; this is a carry over from the WTP code.  This method,
along
with other methods and object names may be adjusted when we complete our
API review prior to M4.

Also expected in the M3 release will be some form of connection management
that will facilitate connection sharing.  I will have a preliminary
design
out sometime next week.

Please let me know if you need anymore information.

Rob



                    
                     
                     
         
            Hui.Cao@xxxxxxxxx    
                     
                  
            m        
                     
                     
        
            Sent by:      
                     
                     
To 
            dtp-connect-dev-b    
    DTP Connectivity project          
 
            ounces@xxxxxxxxxx    
    development list            
       
            g        
                <dtp-connect-dev@xxxxxxxxxxx>
      
                    
                     
                     
      cc 
                    
                     
                     
         
            01/03/2006 03:52    
                     
           Subject 
            AM        
               Re: [dtp-connect-dev]
Where to get  
                    
                 the shared
connection?              
                    
                     
                     
         
            Please respond to    
                     
                  
            DTP Connectivity    
                     
                   
                 project  
                     
                     
   
            development list    
                     
                   
            <dtp-connect-dev@    
                     
                  
              eclipse.org>  
                     
                     
 
                    
                     
                     
         
                    
                     
                     
         





A related question is how to get the catalog model. I have tried to create
a SQL model connection using
"org.eclipse.datatools.modelbase.sql.schema.Database" as the
connection
factory id but got a NullPointerException. SQL Dev Tools is on a tight
schedule, so any help is highly appreciated!


Best Regards!

Max ( Hui ) Cao
Sr S/W Eng - Dev
Sybase, Inc. Shanghai, China
Tel: 86-21-68799918-3047



                    
                     
                     
         
Hui.Cao@xxxxxxxxxx                
                     
                 
Sent by:                  
                     
                     
   
dtp-connect-dev-bounces@xxxxxxxxxxx          
                     
   To 
                    
                     
   dtp-connect-dev@xxxxxxxxxxx 
                    
                     
                     
      cc 
01/03/2006 03:34 PM                
                     
                
                    
                     
                     
 Subject 
                    
                     
   [dtp-connect-dev] Where to  
           Please respond to      
           get the shared connection?  
  DTP Connectivity project development        
                     
     
   list <dtp-connect-dev@xxxxxxxxxxx>        
                     
      
                    
                     
                     
         
                    
                     
                     
         
                    
                     
                     
         
                    
                     
                     
         
                    
                     
                     
         






Hi,
      Is there any API for SQL Dev Tools to get the shared
connection
created by a connection profile? I see that ConnectionInfoImpl maintains
a
shared connection, but the ConnectionInfoImpl instance itself can only
be
accessed through IConnectionProfile.createConnection, which will cause
IllegalStateException when called more than once.

Best Regards!

Max ( Hui ) Cao
DTP SQL Dev Tools committer
Sr S/W Eng - Dev
Sybase, Inc. Shanghai, China
_______________________________________________
dtp-connect-dev mailing list
dtp-connect-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-connect-dev
_______________________________________________
dtp-connect-dev mailing list
dtp-connect-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-connect-dev


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

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