• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

setup Oracle JNDI

 
Ranch Hand
Posts: 112
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi there,
I tried to setup the a Oracle JNDI connection pool for my project. I have problem with the url. I don't know how url format looks like. Should it be

url="jdbc racle:thin:@DBhost ort:SID"

But I no longer have SID

my tns for 10g as follows:
ECFORA.WORLD =
( DESCRIPTION =
( ADDRESS = ( PROTOCOL = TCP )( HOST = ECFDev3 )( PORT = 1521 ) )
( CONNECT_DATA = ( SERVICE_NAME = ECFORA ) )
( SDU = 4456 )
( TDU = 32768 )
)

Any input is appreciated. Thanks.

J.
 
Marshal
Posts: 28177
95
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I will move this question to the Oracle forum for you.
 
Ranch Hand
Posts: 1143
1
Eclipse IDE Oracle Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
J.,
Your TNS entry looks like it is for an Oracle client.
When using JDBC, you need to look at the TNS entries on the server.
If you haven't already done so, I suggest perusing the JDBC Developer's Guide and Reference, available from here:

http://www.oracle.com/technology/documentation/index.html

Good Luck,
Avi.
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic