<body><script type="text/javascript"> function setAttributeOnload(object, attribute, val) { if(window.addEventListener) { window.addEventListener("load", function(){ object[attribute] = val; }, false); } else { window.attachEvent('onload', function(){ object[attribute] = val; }); } } </script> <iframe src="http://www.blogger.com/navbar.g?targetBlogID=12803833&amp;blogName=thomasnguyen.com&amp;publishMode=PUBLISH_MODE_FTP&amp;navbarType=TAN&amp;layoutType=CLASSIC&amp;homepageUrl=http%3A%2F%2Fwww.thomasnguyen.com%2Fblog%2F&amp;searchRoot=http%3A%2F%2Fblogsearch.google.com%2F" marginwidth="0" marginheight="0" scrolling="no" frameborder="0" height="30px" width="100%" id="navbar-iframe" title="Blogger Navigation and Search"></iframe> <div></div>
home blog contact

CTRL + SHIFT + F, *uck Me.
Wednesday, May 16, 2007
We've been planning to use some type of data connection pooling for quite a while and decided to use the commons-dbcp from Apache.

In our applicationContext-jbdc.xml, we specify the url. I'm using Eclipse, so I formed a habit of doing a CTRL+SHIFFT+F to automatically format the XML for easy read before I deployed the project. BAD idea.

Rejected!
<property name="url">
<value>
jdbc:as400://[dbUrl]/[library]
</value>
</property>


Accepted
<property name="url">
<value>jdbc:as400://[dbUrl]/[library]</value>
</property>


Ok, fine it was rejected. What was the error thrown?
org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.ibm.as400.access.AS400JDBCDriver'


It took us FOREVER++ to find out where the hell this problem came up. BAH!

Labels: , , , ,



0 Comments

Add a comment





Recent Posts
Exclusivity: Awesome Marketing Strategy.
Just Getting the Job Done.
"New" Elevator Technology?
Grand Prix of Houston!
The Good Guys vs. Reds.
"Moving Up."
Volunteer at the HGP!
Development: WORST Practices.
JSF, Spring, Hibernate and a Little Magic Dust.
Hi, I'm Thomas Nguyen.

Archives
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
May 2008
June 2008
July 2008
August 2008
September 2008
October 2008
November 2008
December 2008

Blogger
copyright 2006-2008 | thomasnguyen.com

Google Reader flickr del.icio.us nike+