This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC 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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30123
    
150

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.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, 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
 
Don't get me started about those stupid light bulbs.
 
subject: Configuring Tomcat to Use Connection Pool
 
Similar Threads
No suitable driver error when configuring JDBC datasource for Tomcat and Struts
Please Help! I Do Not See the Problem. Tomcat Connection Configuration Problem!
Is this true: JNDI equals Connection Pooling
Tomcat Database Connection Pooling Error
No suitable driver error when configuring JDBC datasource for Tomcat and Struts