Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • 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
Marshal
Posts: 35279
384
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic