Bug 1272599
| Summary: | Oracle connection profile type does not support service name | ||||||
|---|---|---|---|---|---|---|---|
| Product: | [JBoss] JBoss Data Virtualization 6 | Reporter: | Cojan van Ballegooijen <cojan> | ||||
| Component: | Tooling, Teiid | Assignee: | Barry LaFond <blafond> | ||||
| Status: | CLOSED NOTABUG | QA Contact: | Matus Makovy <mmakovy> | ||||
| Severity: | unspecified | Docs Contact: | |||||
| Priority: | unspecified | ||||||
| Version: | 6.2.0 | CC: | blafond, drieden, vhalbert | ||||
| Target Milestone: | --- | ||||||
| Target Release: | --- | ||||||
| Hardware: | Unspecified | ||||||
| OS: | Unspecified | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: | ||||||
| Last Closed: | 2015-12-07 17:24:12 UTC | Type: | Bug | ||||
| Regression: | --- | Mount Type: | --- | ||||
| Documentation: | --- | CRM: | |||||
| Verified Versions: | Category: | --- | |||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||
| Embargoed: | |||||||
| Attachments: |
|
||||||
The Oracle Connection profile wizard is an Eclipse plugin. Designer has no control over how that URL is constructed. Can we get this BZ moved over to where ever handles the connection profiles? Now using only JIRA... closing. The needinfo request[s] on this closed bug have been removed as they have been unresolved for 1000 days |
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.