Two Laptop Bag
The moose likes JDBC and Relational Databases and the fly likes Configuring Tomcat to Use Connection Pool Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Configuring Tomcat to Use Connection Pool" Watch "Configuring Tomcat to Use Connection Pool" New topic
Author

Configuring Tomcat to Use Connection Pool

JiaPei Jen
Ranch Hand

Joined: Nov 19, 2000
Posts: 1309
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

Joined: May 26, 2003
Posts: 32614
    
215

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.


[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Julian Kennedy
Ranch Hand

Joined: Aug 02, 2004
Posts: 823
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Configuring Tomcat to Use Connection Pool
 
It's not a secret anymore!