[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
Re: [dtp-dev] Test Connection not working
|
That will be good; Could you please ?
I still need to find my way into other related stuff.
Anthos
On 1/18/06, Lawrence E Dunnell <
ledunnel@xxxxxxxxxx> wrote:
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
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
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 _______________________________________________
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