Bug 1272599 - Oracle connection profile type does not support service name
Summary: Oracle connection profile type does not support service name
Keywords:
Status: CLOSED NOTABUG
Alias: None
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Tooling, Teiid
Version: 6.2.0
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
: ---
Assignee: Barry LaFond
QA Contact: Matus Makovy
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2015-10-16 20:40 UTC by Cojan van Ballegooijen
Modified: 2023-09-14 03:06 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2015-12-07 17:24:12 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)
Connection Profile Wizard screen shot (1.18 MB, image/png)
2015-10-16 20:40 UTC, Cojan van Ballegooijen
no flags Details


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker TEIIDDES-2232 0 Major Open Cannot create JDBC/Oracle connection profile using ServiceName syntax 2018-04-06 12:53:06 UTC

Description Cojan van Ballegooijen 2015-10-16 20:40:11 UTC
Created attachment 1083809 [details]
Connection Profile Wizard screen shot

Description of problem:
When you create a new connection profile with an Oracle driver in my case 11 the connection url format is jdbc:oracle:thin:@server:1521:db

Version-Release number of selected component (if applicable):
9.0.3.Final

How reproducible:
See below

Steps to Reproduce:
1. Create a new Teiid Model Project
2. File->Import 
3. JDBC database >> Source Model
4. Click button New at the Connection Profile Dropdown box
5. Select Oracle as Connection Profile Type
6. Click button Add new driver at the Drivers Dropdown box
7. In the properties screen one can only use a SID 

Actual results:
N/A

Expected results:
Way to be able to use service name in the connection url

Additional info:
Workaround is to use the Generic JDBC driver but people might make mistakes since the default translator will be Generic jdbc instead of Oracle.

Comment 2 Cojan van Ballegooijen 2015-10-16 20:43:29 UTC
See also https://issues.jboss.org/browse/TEIIDDES-2232

Comment 3 Barry LaFond 2015-11-03 17:10:43 UTC
The Oracle Connection profile wizard is an Eclipse plugin.  Designer has no control over how that URL is constructed.

Comment 4 Van Halbert 2015-11-03 17:25:23 UTC
Can we get this BZ moved over to where ever handles the connection profiles?

Comment 6 Barry LaFond 2015-12-07 17:24:12 UTC
Now using only JIRA... closing.

Comment 7 Red Hat Bugzilla 2023-09-14 03:06:48 UTC
The needinfo request[s] on this closed bug have been removed as they have been unresolved for 1000 days


Note You need to log in before you can comment on or make changes to this bug.