Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » problem creating driver definitions
problem creating driver definitions [message #17368] Mon, 26 June 2006 19:22 Go to next message
Bryan Hunt is currently offline Bryan HuntFriend
Messages: 366
Registered: July 2009
Senior Member
When I select Preferences -> Connectivity -> Driver definitions, I'm
able to add a driver definition for DB2 where I specify the paths to
the necessary jar files. Now, when I go to create a new database
connection, I am not able to select the driver definition I created.
Does the new database connection wizzard not look at the list of
available driver definitions?

Bryan
Re: problem creating driver definitions [message #17387 is a reply to message #17368] Mon, 26 June 2006 20:11 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: jograham.sybase.com

Bryan Hunt wrote:

> When I select Preferences -> Connectivity -> Driver definitions, I'm
> able to add a driver definition for DB2 where I specify the paths to
> the necessary jar files. Now, when I go to create a new database
> connection, I am not able to select the driver definition I created.
> Does the new database connection wizzard not look at the list of
> available driver definitions?

> Bryan

Bryan,

Which build of DTP are you using? (Look in eclipse\features folder for
org.eclipse.datatools features.) When you try to create a new connection
profile, are you choosing the "SQL Model (generic)" one?

Regards,
John Graham
Eclipse Data Tools Platform PMC Chair
Re: problem creating driver definitions [message #17897 is a reply to message #17387] Tue, 27 June 2006 17:31 Go to previous messageGo to next message
Bryan Hunt is currently offline Bryan HuntFriend
Messages: 366
Registered: July 2009
Senior Member
John,

I'm using DTP 0.9.0.200606161 which was pulled from the Callisto site
yesterday from the update manager.

Here are the exact steps I'm trying:

Preferences -> Connectivity -> Driver Definitions
Select Database -> DB2 UDB -> V8.1
Click Add...
Expand Database -> DB2 UDB -> V8.1
Select IBM DB2 Universal as the template
Use the default driver name "IBM DB2 Universal"
Click ok
Add the db2jcc.jar and db2jcc_license_cu.jar
Click ok
Click ok to dismiss the preferences
In the Database Explorer view, click New Connection...
Expand DB2 UDB and select V8.1
The JDBC Driver selector will only let you select "Other" - I was
expecting to be able to select "IBM DB2 Universal" - the one I set up
above.

Bryan

On 2006-06-26 15:11:37 -0500, jograham@sybase.com (John Graham) said:

> Bryan Hunt wrote:
>
>> When I select Preferences -> Connectivity -> Driver definitions, I'm
>> able to add a driver definition for DB2 where I specify the paths to
>> the necessary jar files. Now, when I go to create a new database
>> connection, I am not able to select the driver definition I created.
>> Does the new database connection wizzard not look at the list of
>> available driver definitions?
>
>> Bryan
>
> Bryan,
>
> Which build of DTP are you using? (Look in eclipse\features folder for
> org.eclipse.datatools features.) When you try to create a new
> connection profile, are you choosing the "SQL Model (generic)" one?
>
> Regards,
> John Graham
> Eclipse Data Tools Platform PMC Chair
Re: problem creating driver definitions [message #17921 is a reply to message #17897] Tue, 27 June 2006 20:30 Go to previous messageGo to next message
Brian Payton is currently offline Brian PaytonFriend
Messages: 154
Registered: July 2009
Senior Member
Bryan,

It looks like you might be confusing the WTP Database Explorer with the
Data Source Explorer from DTP (which is understandable since they are
very similar). "New Connection..." is an action on the Database
Explorer. The equivalent action on the Data Source Explorer is "New
Connection Profile". The WTP Database Explorer doesn't know about the
Driver Definitions in the Preferences.

Brian Payton
SQL Tools Development
IBM Silicon Valley Lab

Bryan Hunt wrote:
> John,
>
> I'm using DTP 0.9.0.200606161 which was pulled from the Callisto site
> yesterday from the update manager.
>
> Here are the exact steps I'm trying:
>
> Preferences -> Connectivity -> Driver Definitions
> Select Database -> DB2 UDB -> V8.1
> Click Add...
> Expand Database -> DB2 UDB -> V8.1
> Select IBM DB2 Universal as the template
> Use the default driver name "IBM DB2 Universal"
> Click ok
> Add the db2jcc.jar and db2jcc_license_cu.jar
> Click ok
> Click ok to dismiss the preferences
> In the Database Explorer view, click New Connection...
> Expand DB2 UDB and select V8.1
> The JDBC Driver selector will only let you select "Other" - I was
> expecting to be able to select "IBM DB2 Universal" - the one I set up
> above.
>
> Bryan
>
> On 2006-06-26 15:11:37 -0500, jograham@sybase.com (John Graham) said:
>
>> Bryan Hunt wrote:
>>
>>> When I select Preferences -> Connectivity -> Driver definitions, I'm
>>> able to add a driver definition for DB2 where I specify the paths to
>>> the necessary jar files. Now, when I go to create a new database
>>> connection, I am not able to select the driver definition I
>>> created. Does the new database connection wizzard not look at the
>>> list of available driver definitions?
>>
>>> Bryan
>>
>> Bryan,
>>
>> Which build of DTP are you using? (Look in eclipse\features folder
>> for org.eclipse.datatools features.) When you try to create a new
>> connection profile, are you choosing the "SQL Model (generic)" one?
>>
>> Regards,
>> John Graham
>> Eclipse Data Tools Platform PMC Chair
>
>
Re: problem creating driver definitions [message #17934 is a reply to message #17921] Tue, 27 June 2006 21:07 Go to previous message
Bryan Hunt is currently offline Bryan HuntFriend
Messages: 366
Registered: July 2009
Senior Member
Brian,

That is my problem. Will there be a merger / hostile takeover of these
two explorers in the future?

Bryan

On 2006-06-27 15:30:23 -0500, Brian Payton <bpayton@us.ibm.com> said:

> Bryan,
>
> It looks like you might be confusing the WTP Database Explorer with the
> Data Source Explorer from DTP (which is understandable since they are
> very similar). "New Connection..." is an action on the Database
> Explorer. The equivalent action on the Data Source Explorer is "New
> Connection Profile". The WTP Database Explorer doesn't know about the
> Driver Definitions in the Preferences.
>
> Brian Payton
> SQL Tools Development
> IBM Silicon Valley Lab
>
> Bryan Hunt wrote:
>> John,
>>
>> I'm using DTP 0.9.0.200606161 which was pulled from the Callisto site
>> yesterday from the update manager.
>>
>> Here are the exact steps I'm trying:
>>
>> Preferences -> Connectivity -> Driver Definitions
>> Select Database -> DB2 UDB -> V8.1
>> Click Add...
>> Expand Database -> DB2 UDB -> V8.1
>> Select IBM DB2 Universal as the template
>> Use the default driver name "IBM DB2 Universal"
>> Click ok
>> Add the db2jcc.jar and db2jcc_license_cu.jar
>> Click ok
>> Click ok to dismiss the preferences
>> In the Database Explorer view, click New Connection...
>> Expand DB2 UDB and select V8.1
>> The JDBC Driver selector will only let you select "Other" - I was
>> expecting to be able to select "IBM DB2 Universal" - the one I set up
>> above.
>>
>> Bryan
>>
>> On 2006-06-26 15:11:37 -0500, jograham@sybase.com (John Graham) said:
>>
>>> Bryan Hunt wrote:
>>>
>>>> When I select Preferences -> Connectivity -> Driver definitions, I'm
>>>> able to add a driver definition for DB2 where I specify the paths to
>>>> the necessary jar files. Now, when I go to create a new database
>>>> connection, I am not able to select the driver definition I created.
>>>> Does the new database connection wizzard not look at the list of
>>>> available driver definitions?
>>>
>>>> Bryan
>>>
>>> Bryan,
>>>
>>> Which build of DTP are you using? (Look in eclipse\features folder for
>>> org.eclipse.datatools features.) When you try to create a new
>>> connection profile, are you choosing the "SQL Model (generic)" one?
>>>
>>> Regards,
>>> John Graham
>>> Eclipse Data Tools Platform PMC Chair
Re: problem creating driver definitions [message #579902 is a reply to message #17368] Mon, 26 June 2006 20:11 Go to previous message
John Graham is currently offline John GrahamFriend
Messages: 183
Registered: July 2009
Senior Member
Bryan Hunt wrote:

> When I select Preferences -> Connectivity -> Driver definitions, I'm
> able to add a driver definition for DB2 where I specify the paths to
> the necessary jar files. Now, when I go to create a new database
> connection, I am not able to select the driver definition I created.
> Does the new database connection wizzard not look at the list of
> available driver definitions?

> Bryan

Bryan,

Which build of DTP are you using? (Look in eclipse\features folder for
org.eclipse.datatools features.) When you try to create a new connection
profile, are you choosing the "SQL Model (generic)" one?

Regards,
John Graham
Eclipse Data Tools Platform PMC Chair
Re: problem creating driver definitions [message #580032 is a reply to message #17387] Tue, 27 June 2006 17:31 Go to previous message
Bryan Hunt is currently offline Bryan HuntFriend
Messages: 366
Registered: July 2009
Senior Member
John,

I'm using DTP 0.9.0.200606161 which was pulled from the Callisto site
yesterday from the update manager.

Here are the exact steps I'm trying:

Preferences -> Connectivity -> Driver Definitions
Select Database -> DB2 UDB -> V8.1
Click Add...
Expand Database -> DB2 UDB -> V8.1
Select IBM DB2 Universal as the template
Use the default driver name "IBM DB2 Universal"
Click ok
Add the db2jcc.jar and db2jcc_license_cu.jar
Click ok
Click ok to dismiss the preferences
In the Database Explorer view, click New Connection...
Expand DB2 UDB and select V8.1
The JDBC Driver selector will only let you select "Other" - I was
expecting to be able to select "IBM DB2 Universal" - the one I set up
above.

Bryan

On 2006-06-26 15:11:37 -0500, jograham@sybase.com (John Graham) said:

> Bryan Hunt wrote:
>
>> When I select Preferences -> Connectivity -> Driver definitions, I'm
>> able to add a driver definition for DB2 where I specify the paths to
>> the necessary jar files. Now, when I go to create a new database
>> connection, I am not able to select the driver definition I created.
>> Does the new database connection wizzard not look at the list of
>> available driver definitions?
>
>> Bryan
>
> Bryan,
>
> Which build of DTP are you using? (Look in eclipse\features folder for
> org.eclipse.datatools features.) When you try to create a new
> connection profile, are you choosing the "SQL Model (generic)" one?
>
> Regards,
> John Graham
> Eclipse Data Tools Platform PMC Chair
Re: problem creating driver definitions [message #580061 is a reply to message #17897] Tue, 27 June 2006 20:30 Go to previous message
Brian Payton is currently offline Brian PaytonFriend
Messages: 154
Registered: July 2009
Senior Member
Bryan,

It looks like you might be confusing the WTP Database Explorer with the
Data Source Explorer from DTP (which is understandable since they are
very similar). "New Connection..." is an action on the Database
Explorer. The equivalent action on the Data Source Explorer is "New
Connection Profile". The WTP Database Explorer doesn't know about the
Driver Definitions in the Preferences.

Brian Payton
SQL Tools Development
IBM Silicon Valley Lab

Bryan Hunt wrote:
> John,
>
> I'm using DTP 0.9.0.200606161 which was pulled from the Callisto site
> yesterday from the update manager.
>
> Here are the exact steps I'm trying:
>
> Preferences -> Connectivity -> Driver Definitions
> Select Database -> DB2 UDB -> V8.1
> Click Add...
> Expand Database -> DB2 UDB -> V8.1
> Select IBM DB2 Universal as the template
> Use the default driver name "IBM DB2 Universal"
> Click ok
> Add the db2jcc.jar and db2jcc_license_cu.jar
> Click ok
> Click ok to dismiss the preferences
> In the Database Explorer view, click New Connection...
> Expand DB2 UDB and select V8.1
> The JDBC Driver selector will only let you select "Other" - I was
> expecting to be able to select "IBM DB2 Universal" - the one I set up
> above.
>
> Bryan
>
> On 2006-06-26 15:11:37 -0500, jograham@sybase.com (John Graham) said:
>
>> Bryan Hunt wrote:
>>
>>> When I select Preferences -> Connectivity -> Driver definitions, I'm
>>> able to add a driver definition for DB2 where I specify the paths to
>>> the necessary jar files. Now, when I go to create a new database
>>> connection, I am not able to select the driver definition I
>>> created. Does the new database connection wizzard not look at the
>>> list of available driver definitions?
>>
>>> Bryan
>>
>> Bryan,
>>
>> Which build of DTP are you using? (Look in eclipse\features folder
>> for org.eclipse.datatools features.) When you try to create a new
>> connection profile, are you choosing the "SQL Model (generic)" one?
>>
>> Regards,
>> John Graham
>> Eclipse Data Tools Platform PMC Chair
>
>
Re: problem creating driver definitions [message #580073 is a reply to message #17921] Tue, 27 June 2006 21:07 Go to previous message
Bryan Hunt is currently offline Bryan HuntFriend
Messages: 366
Registered: July 2009
Senior Member
Brian,

That is my problem. Will there be a merger / hostile takeover of these
two explorers in the future?

Bryan

On 2006-06-27 15:30:23 -0500, Brian Payton <bpayton@us.ibm.com> said:

> Bryan,
>
> It looks like you might be confusing the WTP Database Explorer with the
> Data Source Explorer from DTP (which is understandable since they are
> very similar). "New Connection..." is an action on the Database
> Explorer. The equivalent action on the Data Source Explorer is "New
> Connection Profile". The WTP Database Explorer doesn't know about the
> Driver Definitions in the Preferences.
>
> Brian Payton
> SQL Tools Development
> IBM Silicon Valley Lab
>
> Bryan Hunt wrote:
>> John,
>>
>> I'm using DTP 0.9.0.200606161 which was pulled from the Callisto site
>> yesterday from the update manager.
>>
>> Here are the exact steps I'm trying:
>>
>> Preferences -> Connectivity -> Driver Definitions
>> Select Database -> DB2 UDB -> V8.1
>> Click Add...
>> Expand Database -> DB2 UDB -> V8.1
>> Select IBM DB2 Universal as the template
>> Use the default driver name "IBM DB2 Universal"
>> Click ok
>> Add the db2jcc.jar and db2jcc_license_cu.jar
>> Click ok
>> Click ok to dismiss the preferences
>> In the Database Explorer view, click New Connection...
>> Expand DB2 UDB and select V8.1
>> The JDBC Driver selector will only let you select "Other" - I was
>> expecting to be able to select "IBM DB2 Universal" - the one I set up
>> above.
>>
>> Bryan
>>
>> On 2006-06-26 15:11:37 -0500, jograham@sybase.com (John Graham) said:
>>
>>> Bryan Hunt wrote:
>>>
>>>> When I select Preferences -> Connectivity -> Driver definitions, I'm
>>>> able to add a driver definition for DB2 where I specify the paths to
>>>> the necessary jar files. Now, when I go to create a new database
>>>> connection, I am not able to select the driver definition I created.
>>>> Does the new database connection wizzard not look at the list of
>>>> available driver definitions?
>>>
>>>> Bryan
>>>
>>> Bryan,
>>>
>>> Which build of DTP are you using? (Look in eclipse\features folder for
>>> org.eclipse.datatools features.) When you try to create a new
>>> connection profile, are you choosing the "SQL Model (generic)" one?
>>>
>>> Regards,
>>> John Graham
>>> Eclipse Data Tools Platform PMC Chair
Previous Topic:New ODA plugin - cannot find dataSet element
Next Topic:Database connections not persisted
Goto Forum:
  


Current Time: Fri Apr 19 01:21:52 GMT 2024

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

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

Back to the top