Eclipse Community Forums: DTP » New Connection Profile Type

Home » Eclipse Projects » DTP » New Connection Profile Type(How ro create a connection profile type)

New Connection Profile Type [message #656516]

Fri, 25 February 2011 22:39

Eclipse User

Hi,

I'd like to use DTP with Aster nCluster, but there is no conncection profile type for that database. How do I create one?

Also, if I need to create a plugin, what tools would I need?

Thanks,
--
Drew

Re: New Connection Profile Type [message #656868 is a reply to message #656516]

Mon, 28 February 2011 14:58

Eclipse User

BTW, I'm on Helios.

Re: New Connection Profile Type [message #658779 is a reply to message #656868]

Wed, 09 March 2011 13:33

Eclipse User

Hi Drew...

Most of this has been covered in a series of blog posts:

http://fitzdtp.blogspot.com/2008/06/dtp-driver-framework-rep ost.html
http://fitzdtp.blogspot.com/2008/06/how-do-you-add-your-own- custom-driver.html
http://fitzdtp.blogspot.com/2008/08/dtp-sqlite-support-conti nued-on-to.html
http://fitzdtp.blogspot.com/2008/08/creating-actual-sqlite-c onnection.html
http://fitzdtp.blogspot.com/2008/08/creating-sqlite-connecti on-profile-ui.html

I walked through creating the bits for connecting to a SQLLite database in those. Hopefully they'll help get you on the right path.

Re: New Connection Profile Type [message #658784 is a reply to message #658779]

Wed, 09 March 2011 13:45

Eclipse User

Thanks Brian. Looks like the posts are tough to find. I will read them over and will follow up with any issues.

http://fitzdtp.blogspot.com/2008/06/dtp-driver-framework-rep ost.html
http://fitzdtp.blogspot.com/2008/06/how-do-you-add-your-own- custom-driver.html
http://fitzdtp.blogspot.com/2008/08/dtp-sqlite-support-conti nued-on-to.html
http://fitzdtp.blogspot.com/2008/08/creating-actual-sqlite-c onnection.html
http://fitzdtp.blogspot.com/2008/08/creating-sqlite-connect on-profile-ui.html

Re: New Connection Profile Type [message #658830 is a reply to message #658784]

Wed, 09 March 2011 18:11

Eclipse User

No, not really hard to find. There are links on the DTP Wiki page (http://wiki.eclipse.org/Data_Tools_Platform_Project). Smile

Re: New Connection Profile Type [message #658851 is a reply to message #658830]

Wed, 09 March 2011 23:28

Eclipse User

Hi Brian,

I read through "How do you add your own custom driver template?"

There's a set of 3 questions you have to determine the course of action you would take. The first question you ask is:

Quote:

Can I create a new Generic JDBC driver definition that references the jar (sqlitejdbc-v051-native.jar in this case)? Yes.

When I tried with Helios and DTP 1.7.0 I was not able to do this. Has this been tried?

I was able to add a jar and change the driver name. I tried to change the driver type, but couldn't. Anyway, at no point was I given an active OK or NEXT button.

Re: New Connection Profile Type [message #659064 is a reply to message #658851]

Thu, 10 March 2011 15:33

Eclipse User

Ok... So on the Driver Definitions preference page (Window->Preferences, Data Management->Connectivity->Driver Definitions), click Add.

That should open the "New Driver Definition" dialog.

Select "Generic JDBC Driver" in the list on the Name/Type tab.

Select the JAR List tab and click Add JAR/Zip. Browse to your jar in the File Browse dialog and click OK. That should add your jar to the jar list.

Then select the Properties tab.

Click on the Driver Class line in the table. Select the "..." button to the far right of that line. In the "Available Classes from Jar List" dialog, select "Browse for Class" and it should populate the list of classes. Select org.sqlite.JDBC. Click OK.

Now you should have the OK button enabled on the New Driver Definition dialog. Click it and now you have a driver definition pointing to the SQL Lite jdbc driver.

You can then use that Generic JDBC driver definition when you use the Generic JDBC connection profile.

HTH!
--Fitz

Previous Topic:	determining a connection's plug-in
Next Topic:	CSV and XML "Databases"

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jul 04 11:43:27 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter