Re: [dtp-dev] Test Connection not working

[Lawrence E Dunnell <ledunnel@xxxxxxxxxx>]

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