Eclipse Community Forums: DTP » New Connection Profile Type

Help

Home

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

Show: Today's Messages :: Show Polls :: Message Navigator

New Connection Profile Type [message #656516]

Sat, 26 February 2011 03:39

Drew Bertola

Messages: 4
Registered: February 2011

Junior Member

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

Report message to a moderator

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

Mon, 28 February 2011 19:58

Drew Bertola

Messages: 4
Registered: February 2011

Junior Member

BTW, I'm on Helios.

Report message to a moderator

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

Wed, 09 March 2011 18:33

Brian Fitzpatrick

Messages: 500
Registered: July 2009

Senior Member

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.

Report message to a moderator

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

Wed, 09 March 2011 18:45

Drew Bertola

Messages: 4
Registered: February 2011

Junior Member

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

Report message to a moderator

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

Wed, 09 March 2011 23:11

Brian Fitzpatrick

Messages: 500
Registered: July 2009

Senior Member

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

Report message to a moderator

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

Thu, 10 March 2011 04:28

Drew Bertola

Messages: 4
Registered: February 2011

Junior Member

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.

Report message to a moderator

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

Thu, 10 March 2011 20:33

Brian Fitzpatrick

Messages: 500
Registered: July 2009

Senior Member

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Aug 15 18:35:45 GMT 2022

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter