aspose file tools*
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 Java 8 in Action this week in the Java 8 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: 29287
    
140

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Configuring Tomcat to Use Connection Pool
 
Similar Threads
No suitable driver error when configuring JDBC datasource for Tomcat and Struts
Is this true: JNDI equals Connection Pooling
Please Help! I Do Not See the Problem. Tomcat Connection Configuration Problem!
No suitable driver error when configuring JDBC datasource for Tomcat and Struts
Tomcat Database Connection Pooling Error