[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
Re: [dtp-dev] Test Connection not working
|
Ok, I'll add this to the build, and it will appear in M3 this Friday.
Thanks,
John Graham
Staff Software Engineer
Sybase, Inc.
Lawrence E
Dunnell
<ledunnel@xxxxxx. To
com> DTP development mailing list
Sent by: <dtp-dev@xxxxxxxxxxx>
dtp-dev-bounces@e cc
clipse.org
Subject
Re: [dtp-dev] Test Connection not
01/18/2006 01:51 working
PM
Please respond to
DTP development
mailing list
<dtp-dev@eclipse.
org>
FYI. I have added the
org.eclipse.datatools.connectivity.dbdefinition.oracle plug-in into the
org.eclipse.datatools.connectivity/plugins directory in CVS and added the
driver definition to the plugin.xml in the
org.eclipse.datatools.connectivity.db.generic plug-in. The new plug-in
just needs to be added to the build system.
Larry Dunnell
Internet address: ledunnel@xxxxxxxxxx
Anil Samuel
<anil.samuel@xxxxxxxxx>
Sent by: To
dtp-dev-bounces@xxxxxxxxxxx DTP development mailing
list <dtp-dev@xxxxxxxxxxx>
cc
01/17/2006 09:56 PM
Subject
Re: [dtp-dev] Test
Please respond to Connection not working
DTP development mailing list
<dtp-dev@xxxxxxxxxxx>
Here are my observation after some debugging into connectivity codebase.
1.
org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl
(v. I011306):-
615: DatabaseDefinitionRegistry defRegistry =
RDBCorePlugin.getDefault ().getDatabaseDefinitionRegistry();
DatabaseDefinition dbDef = defRegistry.getDefinition(vendor,
version);
dbDef seems to be null at this point and is causing NPE later.
2. I have "org.eclipse.datatools.connectivity.dbdefinition.oracle " in the
plugins directory and so I guess the definition gets picked up; though I
have no confirmation for this.
How do I get around this ?
Regards
Anthos
On 1/18/06, Anil Samuel < anil.samuel@xxxxxxxxx> wrote:
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
Anil Samuel <anil.samuel@xxxxxxxxx
>
Sent by: To
dtp-dev-bounces@xxxxxxxxxxx DTP development mailing
list <dtp-dev@xxxxxxxxxxx>
cc
01/16/2006 08:00 PM
Subject
Re: [dtp-dev] Test
Connection not working
Please respond to
DTP development mailing list <
dtp-dev@xxxxxxxxxxx>
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 To
DTP development mailing
list <dtp-dev@xxxxxxxxxxx
01/16/2006 06:56 PM >
cc
Subject
Re: [dtp-dev] Test
Connection not working
Please respond to
DTP development mailing list <
dtp-dev@xxxxxxxxxxx >
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 To
DTP development mailing
list <dtp-dev@xxxxxxxxxxx
01/16/2006 06:29 PM >
cc
Subject
Re: [dtp-dev] Test
Connection not working
Please respond to
DTP development mailing list <
dtp-dev@xxxxxxxxxxx >
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 To
DTP development mailing
list <dtp-dev@xxxxxxxxxxx
01/16/2006 05:01 PM >
cc
Please respond to Subject
DTP development mailing list < Re: [dtp-dev] Test
dtp-dev@xxxxxxxxxxx > 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
To
01/16/2006 03:16 PM dtp-dev@xxxxxxxxxxx
cc
Please respond to Subject
DTP development mailing list < [dtp-dev] Test
dtp-dev@xxxxxxxxxxx > 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
_______________________________________________
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
--
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