Matt RaibleMatt Raible is a Web Developer and Java Champion. Connect with him on LinkedIn.

The Angular Mini-Book The Angular Mini-Book is a guide to getting started with Angular. You'll learn how to develop a bare-bones application, test it, and deploy it. Then you'll move on to adding Bootstrap, Angular Material, continuous integration, and authentication.

Spring Boot is a popular framework for building REST APIs. You'll learn how to integrate Angular with Spring Boot and use security best practices like HTTPS and a content security policy.

For book updates, follow @angular_book on Twitter.

The JHipster Mini-Book The JHipster Mini-Book is a guide to getting started with hip technologies today: Angular, Bootstrap, and Spring Boot. All of these frameworks are wrapped up in an easy-to-use project called JHipster.

This book shows you how to build an app with JHipster, and guides you through the plethora of tools, techniques and options you can use. Furthermore, it explains the UI and API building blocks so you understand the underpinnings of your great application.

For book updates, follow @jhipster-book on Twitter.

10+ YEARS


Over 10 years ago, I wrote my first blog post. Since then, I've authored books, had kids, traveled the world, found Trish and blogged about it all.

RECENT ENTRIES


Tag Cloud


abbie appfuse birthday denver family grails gwt jack java javascript jhipster jsf linkedin maven roller skiing softwaresummit spring springmvc struts2 travel trish vacation webframeworks wicket
« Music is for the... | Main | How to setup Tomcat... »
Friday January 17, 2003

Connection Timeout using Oracle with Tomcat

Hopefully one of you java-bloggers has seen this before and can assist. I've already sent this to tomcat-users, but since this blog seems to be more google-friendly than mailing lists - I like to post problems/solutions here. Hope you don't mind.

I am using Tomcat's JDBCRealm as well as a DBCP Connection pool. I am connecting to Oracle 9, and everything works fine - for about 24 hours. I've experienced this with MySQL and adding autoReconnect=true to the connectionURL fixed the problem. However, adding this to Oracle's connectionURL causes a "Cannot load JDBC driver class 'null'". My connectionURL is: 

jdbc:oracle:thin:username/password@host:1521:sid

Posted in Java at Jan 17 2003, 09:34:18 AM MST 3 Comments
Comments:

Strange JDBC URL... Our Oracle JDBC URL are: jdbc:oracle:thin:@<host>:<port>:<sid> i.e. no username/password.

Posted by Sebastiano Pilla on January 17, 2003 at 06:03 PM MST #

I agree with you, and in my DBCP Connection Pool setup, this is what I use. However, in Tomcat's JDBCRealm - this is the (correct) syntax to set it up for Oracle.

Posted by Matt Raible on January 17, 2003 at 08:03 PM MST #

I enabled the checking in the Tomcat realm, by adding a validation query to the server.xml <parameter> <name>validationQuery</name> <value>select * from dual</value> </parameter> since then it worked. If you do a "select sid, username from v$session;" in SQLPlus, you will see the SID increasing every now and then, meaning that the DBCP was reconnecting.

Posted by Anonymous on March 07, 2003 at 03:00 PM MST #

Post a Comment:
  • HTML Syntax: Allowed