Eclipse Community Forums: BIRT » birt and tnsnames

Help

Home

Home » Archived » BIRT » birt and tnsnames

Show: Today's Messages :: Show Polls :: Message Navigator

birt and tnsnames [message #1259371]

Fri, 28 February 2014 10:04

Marina Orth

Messages: 51
Registered: September 2012

Member

Hello,

i'm trying to connect to a jdbc data source using tnsname.

that's what i'v done:

Entry in c:\tnsnames\tnsnames.ora:
TEST.LOC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.122)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TEST)
)
)

Set the system property in cmd line:
java -Doracle.net.tns_admin=c:\tnsnames

A new jdbc data source:
driver class: oracle.jdbc.OracleDriver (v10.2)
database url: jdbc:oracle:thin:@TEST.LOC

After click on Test Connection i got an error message (see picture).

So where's the problem? Doesen't BIRT support tnsnames?

Kind regards

Marina