[
https://issues.jboss.org/browse/TEIIDDES-2232?page=com.atlassian.jira.plu...
]
Barry LaFond commented on TEIIDDES-2232:
----------------------------------------
Using Generic JDBC connection profile will work if:
1) When you define your Generic JDBC driver, set/select the appropriate driver jar
(*odbc14.jar*)
2) In the driver properties tab, set the driver class to *oracle.jdbc.OracleDriver*
3) Set your full URL
4) Define *Database* (partssupplier), *User* (partssupplier) and pwd values
5) After importing/creating your source model use *Modeling > Set Translator Name* and
select *oracle* translator
Then view connection profile to affirm your proper connection properties are in the source
model
Preview and Execute VDB should function as normal.
Cannot create JDBC/Oracle connection profile using ServiceName
syntax
---------------------------------------------------------------------
Key: TEIIDDES-2232
URL:
https://issues.jboss.org/browse/TEIIDDES-2232
Project: Teiid Designer
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Teiid Integration
Affects Versions: 8.4
Reporter: Tom Johnston
Cannot successfully create a jdbc url like:
"jdbc:oracle:thin:scott/tiger@//myhost:1521/myservicename"
which is found here:
http://docs.oracle.com/cd/B14117_01/java.101/b10979/urls.htm
Note the "../myservicename"
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)