nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

birt tnsnames

marinaO

Hello,

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

that's what i'v done:

Entry in c:tnsnamestnsnames.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

Find more posts tagged with

Comments

micajblock

My guess is that you need to put the TNDNAMES setting in eclipse.ini not in the command line. A side question is why are you using TNSNAMES? One of the benefits of using JDBC is that it does not require such a file for connection.

marinaO

Hi, i don't understand what's the benefit to put TNSNAMES settings in eclipse.ini. Because eclipse.ini is a text file containing command-line options that are added to the command line used when Eclipse is started up. By the way i've tried without success :-( Well it would be nice to connect without having to specify a server and a port number. Especially for ipv6 and windows xp. On other programs we successfully worked with tnsnames. Now we want to do same with BIRT. I've read on web that i should be possible with eclipse. And BIRT is based on eclipse. So i guess it should be possible. But it seems i miss something... Kind regards

micajblock

<blockquote class="ipsBlockquote" data-author="marinaO" data-cid="127545" data-time="1398256613"><div>i don't understand what's the benefit to put TNSNAMES settings in eclipse.ini.</div></blockquote>Because Eclipse has it's own JVM and setting using the command line will not affect the JVM Eclipse uses. As to why it is not working I do not know. I do not have Oracle installed.