[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
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
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
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
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