Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » New Connection Profile Type(How ro create a connection profile type)
New Connection Profile Type [message #656516] Sat, 26 February 2011 03:39 Go to next message
Drew Bertola is currently offline Drew BertolaFriend
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
Re: New Connection Profile Type [message #656868 is a reply to message #656516] Mon, 28 February 2011 19:58 Go to previous messageGo to next message
Drew Bertola is currently offline Drew BertolaFriend
Messages: 4
Registered: February 2011
Junior Member
BTW, I'm on Helios.
Re: New Connection Profile Type [message #658779 is a reply to message #656868] Wed, 09 March 2011 18:33 Go to previous messageGo to next message
Brian Fitzpatrick is currently offline Brian FitzpatrickFriend
Messages: 495
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.
Re: New Connection Profile Type [message #658784 is a reply to message #658779] Wed, 09 March 2011 18:45 Go to previous messageGo to next message
Drew Bertola is currently offline Drew BertolaFriend
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
Re: New Connection Profile Type [message #658830 is a reply to message #658784] Wed, 09 March 2011 23:11 Go to previous messageGo to next message
Brian Fitzpatrick is currently offline Brian FitzpatrickFriend
Messages: 495
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
Re: New Connection Profile Type [message #658851 is a reply to message #658830] Thu, 10 March 2011 04:28 Go to previous messageGo to next message
Drew Bertola is currently offline Drew BertolaFriend
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.
Re: New Connection Profile Type [message #659064 is a reply to message #658851] Thu, 10 March 2011 20:33 Go to previous message
Brian Fitzpatrick is currently offline Brian FitzpatrickFriend
Messages: 495
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
Previous Topic:determining a connection's plug-in
Next Topic:CSV and XML "Databases"
Goto Forum:
  


Current Time: Sat Dec 20 20:17:12 GMT 2014

Powered by FUDForum. Page generated in 0.01948 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software