CTRL + SHIFT + F, *uck Me.

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!

Leave a Reply

Your email address will not be published. Required fields are marked *

Solve this: Time limit is exhausted. Please reload CAPTCHA.

This site uses Akismet to reduce spam. Learn how your comment data is processed.