Re: [dtp-dev] Test Connection not working

[Lawrence E Dunnell <ledunnel@xxxxxxxxxx>]

If it helps, I can add the Oracle driver
definition and the Oracle database definition plug-in into the build.  Then
you can  connect to Oracle without having to implement anything.  There
is a milestone build planned for Friday.  Just let me know.

Larry Dunnell
Internet address: ledunnel@xxxxxxxxxx

Anil Samuel <anil.samuel@xxxxxxxxx>
Sent by: dtp-dev-bounces@xxxxxxxxxxx

01/16/2006 08:00 PM

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

To	DTP development mailing list <dtp-dev@xxxxxxxxxxx>
cc
Subject	Re: [dtp-dev] Test Connection not working

I will be happy to view the database objects the way you
mentioned, for now. But the last step of connection wizard not proceeding
any further.

Anthos

On 1/17/06, Lawrence E Dunnell <ledunnel@xxxxxxxxxx>
wrote:

If you only add the driver definition like the  one I sent then you
will be able to view your database objects in the data source explorer.
 It will use the SQL Model and content extensions provided by DTP.
  If you add your own own implementation for the org.eclipse.datatools.connectivity.connectionProfile
extension point you will need to do a lot more work.

Larry Dunnell
Internet address: ledunnel@xxxxxxxxxx

Anil Samuel <anil.samuel@xxxxxxxxx>
Sent by: dtp-dev-bounces@xxxxxxxxxxx

01/16/2006 06:56 PM

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

To	DTP development mailing list <dtp-dev@xxxxxxxxxxx>
cc
Subject	Re: [dtp-dev] Test Connection not working

The code is not reaching there .. I suppose I dont need to have a element
for "org.eclipse.datatools.connectivity.connectionFactory.pingFactory"
..

Regards
Anthos

On 1/17/06, Lawrence E Dunnell <ledunnel@xxxxxxxxxx
> wrote: 

I'm sorry the code isn't currently handling SQL Exceptions in a user-friendly
way.  If you want to see the SQLException when the driver tries to
connect, you can set a breakpoint at Line 53 in org.eclipse.datatools.connectivity.DriverConnectionBase.java
in the org.eclipse.datatools.connectivity plug-in.

Larry Dunnell
Internet address: ledunnel@xxxxxxxxxx

Anil Samuel < anil.samuel@xxxxxxxxx>
Sent by: dtp-dev-bounces@xxxxxxxxxxx

01/16/2006 06:29 PM

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

To	DTP development mailing list <dtp-dev@xxxxxxxxxxx >
cc
Subject	Re: [dtp-dev] Test Connection not working

Thanks again.

I used the plugin's own plugin.xml to specify this extension point; I tried
the extension point (driverExtension)
you sent in last email; but no difference in behaviour. I see that Derby,
DB2 and Sybase extension points are declared/specified in the org.eclipse.datatools.connectivity.db.generic's
plugin.xml. Since the specification is working, I guess that is not the
problem. Anyway I will try coping it there and see the difference.

Regards
Anthos

On 1/17/06, Lawrence E Dunnell <ledunnel@xxxxxxxxxx
> wrote: 

I copied the following driver definition into the plugin.xml file for the
org.eclipse.datatools.connectivity.db.generic plug-in.  Although,
I was not able to test it since our Oracle server is down, I was able to
generate the expected connection error so I think it will work.  

<extension 
       point="org.eclipse.datatools.connectivity.driverExtension
">
    
    <category
          id="org.eclipse.datatools.connectivity.sqm.core.driverCategory"
          name="Database"/>
  
    <driverTemplate
          createDefault="false"
          emptyJarListIsOK="false"
          id="org.eclipse.datatools.connectivity.db.oracle.genericDriverTemplate"
          jarList="classes12.jar"
          name="Oracle
JDBC Driver for Oracle 10" 
          parentCategory="org.eclipse.datatools.connectivity.sqm.core.driverCategory"
> 
       <properties>
          <property
                generated="false"
                id="org.eclipse.datatools.connectivity.sqm.core.driverClass"
                name="Driver
Class" 
                value="oracle.jdbc.OracleDriver"
                required="true"
                visible="true"/>
          <property
                generated="false"
                id="org.eclipse.datatools.connectivity.sqm.core.vendor"
                name="Vendor"
                value="Oracle"
                required="true"
                visible="false"/>
          <property
                generated="false"
                id="org.eclipse.datatools.connectivity.sqm.core.version"
                name="Version"
                value="10"
                required="true"
                visible="false"/>
  
          <property
                generated="false"
                id="org.eclipse.datatools.connectivity.sqm.core.databaseName"
                name="Database
Name" 
                value="db"
                required="true"
                visible="true"/>
         
                  
          <property
                generated="false"
                id="org.eclipse.datatools.connectivity.sqm.core.URL"
                name="Connection
URL" 
                value="jdbc:oracle:thin:@server:1521:db"
                required="true"
                visible="true"/>
          <property
                generated="false"
                id="org.eclipse.datatools.connectivity.sqm.core.username"
                name="User
ID" 
                value=""
                required="false"
                visible="true"/>
          <property
                generated="false"
                id="org.eclipse.datatools.connectivity.sqm.core.password"
                name="Password"
                value=""
                required="false"
                visible="true"/>
       </properties>
    </driverTemplate>
 </extension>
    

Larry Dunnell
Internet address: ledunnel@xxxxxxxxxx

Anil Samuel < anil.samuel@xxxxxxxxx>
Sent by: dtp-dev-bounces@xxxxxxxxxxx

01/16/2006 05:01 PM

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

To	DTP development mailing list <dtp-dev@xxxxxxxxxxx >
cc
Subject	Re: [dtp-dev] Test Connection not working

Hi

Thanks for that.

I copied this dir, org.eclipse.datatools.connectivity.dbdefinition.oracle,
recursively to plugins; but it didnot make any difference; btw, there is
no stacktrace (or smoke!!). 

The plugins directory contents for oracle and derby is below.

[anthos@anthos-mac plugins]$ ll *oracle*
oracle.datatools.connectivity_0.1.0:
total 176
drwxr-xr-x     7 anthos  anthos    238 Jan 16
21:02 . 
drwxr-xr-x   184 anthos  anthos   6256 Jan 17 11:55 ..
-rw-r--r--     1 anthos  anthos   1229 Jan 16 21:01
about.html
-rw-r--r--     1 anthos  anthos    589 Jan 16
21:01 plugin.properties
-rw-r--r--     1 anthos  anthos   3895 Jan 16 21:01
plugin.xml
-rw-r--r--     1 anthos  anthos  46916 Jan 16 21:01
rdb_oracle.jar
-rw-r--r--     1 anthos  anthos  25904 Jan 16 21:01
rdb_oraclesrc.zip

org.eclipse.datatools.connectivity.dbdefinition.oracle:
total 48 
drwxr-xr-x    10 anthos  anthos   340 Jan 17 11:55
.
drwxr-xr-x   184 anthos  anthos  6256 Jan 17 11:55 ..
-rw-r--r--     1 anthos  anthos    14 Jan 17 11:55
.cvsignore
-rw-r--r--     1 anthos  anthos   521 Jan 17 11:55
.project 
drwxr-xr-x     5 anthos  anthos   170 Jan 17 11:55
CVS
-rw-r--r--     1 anthos  anthos  1229 Jan 17 11:55
about.html
-rw-r--r--     1 anthos  anthos   646 Jan 17 11:55
build.properties
-rw-r--r--     1 anthos  anthos   743 Jan 17 11:55
plugin.properties
-rw-r--r--     1 anthos  anthos  1385 Jan 17 11:55
plugin.xml
drwxr-xr-x     4 anthos  anthos   136 Jan 17 11:55
runtime
[anthos@anthos-mac plugins]$ ll *derby*
org.eclipse.datatools.connectivity.dbdefinition.derby_0.7.0: 
total 24
drwxrwxrwx     6 anthos  anthos   204 Dec 23 10:59
.
drwxr-xr-x   184 anthos  anthos  6256 Jan 17 11:55 ..
-rw-rw-rw-     1 anthos  anthos  1250 Dec 23 10:59
about.html
-rw-rw-rw-     1 anthos  anthos   667 Dec 23 10:59
plugin.properties
-rw-rw-rw-     1 anthos  anthos   769 Dec 23 10:59
plugin.xml
drwxrwxrwx     3 anthos  anthos   102 Dec 23 10:59
runtime

org.eclipse.datatools.connectivity.derby_0.7.0:
total 232
drwxrwxrwx     7 anthos  anthos    238 Dec 23
10:59 . 
drwxr-xr-x   184 anthos  anthos   6256 Jan 17 11:55 ..
-rw-rw-rw-     1 anthos  anthos   1250 Dec 23 10:59
about.html
-rw-rw-rw-     1 anthos  anthos    601 Dec 23
10:59 plugin.properties
-rw-rw-rw-     1 anthos  anthos   1393 Dec 23 10:59
plugin.xml
-rw-rw-rw-     1 anthos  anthos  61600 Dec 23 10:59
rdb_derby.jar
-rw-rw-rw-     1 anthos  anthos  39794 Dec 23 10:59
rdb_derbysrc.zip

Regards
Anthos 
On 1/17/06, Lawrence E Dunnell <ledunnel@xxxxxxxxxx
> wrote: 

You need the Oracle DBDefinition which is currently not part of the DTP
build, however, it is currently located in the "attic" and I
just updated it so that it will work.  You can checkout the  org.eclipse.datatools.connectivity.dbdefinition.oracle
plug-in from  HEAD/org.eclipse.datatools.connectivity/attic/.  If
that doesn't fix the problem, please send a stacktrace(), if there is one.

Larry Dunnell
Internet address: ledunnel@xxxxxxxxxx

Anil Samuel < anil.samuel@xxxxxxxxx>
Sent by: dtp-dev-bounces@xxxxxxxxxxx

01/16/2006 03:16 PM

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

To	dtp-dev@xxxxxxxxxxx
cc
Subject	[dtp-dev] Test Connection not working

Hi

I am looking to build a DTP based interface to Oracle DB. I used the Derby
code as the startign point. I managed to get the Connection Driver showing
using which I can select it in the New Database wizard. It does show the
jdbc url and other details. But nothing happens when I hit "Test Connection"
or "Finish". 

Any leads ?

Anthos

-- 
Anil Samuel <anil.samuel@xxxxxxxxxx
> 

Senior Technical Member
Product Development 
Oracle Corporation _______________________________________________
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





-- 
Anil Samuel <anil.samuel@xxxxxxxxxx>
Senior Technical Member 
Product Development
Oracle Corporation _______________________________________________
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





-- 
Anil Samuel <anil.samuel@xxxxxxxxxx>
Senior Technical Member 
Product Development
Oracle Corporation _______________________________________________
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





-- 
Anil Samuel <anil.samuel@xxxxxxxxxx>
Senior Technical Member 
Product Development
Oracle Corporation _______________________________________________
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





-- 
Anil Samuel <anil.samuel@xxxxxxxxxx>
Senior Technical Member 
Product Development
Oracle Corporation _______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev