• Post Reply Bookmark Topic Watch Topic
  • New Topic

Configuring Tomcat to Use Connection Pool

 
JiaPei Jen
Ranch Hand
Posts: 1309
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am configuring the Tomcat for using connection pool. And the configuration requires us to provide the database name in the <url> element.

Question 1. Is there a colon between "jdbc racle:thin" and the @ sign.

Question 2. Does it mean the devora2 is the database name?

Question 3. I am told the schema name is "xyz". where should I put the schema name?

Thanks in advance.

[edited to disable smilies]
[ September 07, 2004: Message edited by: Jeanne Boyarsky ]
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 36007
422
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
JiaPei,
1) Yes, there is a colon there.
2) It's actually the SID. (system id) This is similar conceptually to a database name.
3) You don't put it in the URL. Once you have a connection, the schema is used in queries. For example, select * from xyz.table.
 
Julian Kennedy
Ranch Hand
Posts: 823
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Question 1. Is there a colon between "jdbcracle:thin" and the @ sign.
Answer: Yes. Source: Google!

Question 2. Does it mean the devora2 is the database name?
Answer: Yes, kinda; technically it's the Oracle SID.

Question 3. I am told the schema name is "xyz". where should I put the schema name?
The schema name in an Oracle DB is effectively the username. Does that help?

Jules
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!