All(28) Eclipse(4) Java(5) JDBC(5) JSP(3) Maven(7) Personal (1) Spring(3) Tomcat(5)

<< Common Maven Commands | Home | Displaying repetitive type information with displaytag and struts >>

Archives

2009 November (0) October (0) September (0) August (0) July (0) June (0) May (0) April (0) March (0) February (2) January (0)	2008 December (0) November (1) October (0) September (1) August (0) July (2) June (0) May (0) April (0) March (2) February (5) January (1)
2007 December (1) November (13)

Recent Blog Entries

Continuum vs. Hudson and Triggering Hudson Builds with a Subversion Post Commit Hook Script
A little discussion on Continuum vs Hudson and How to trigger a continuous integration build on the Hudson server from a subversion post-commit hook script.Read more...Tags : ant continuous_integrati...
Log4J Configuration on Tomcat
Recently I wanted to turn up the logging level on our connection pooling mechanism in tomcat to determine a problem and it had been a while since I had configured log4j and I had to relearn how to turn on logging for an individual package or class. I ...
Days Since Javascript
Some simple javascript to calculate number of days since and months and days since a given date.Read more...Tags : jsp
Sample or Example Tomcat MySQL DBCP (Database Connection Pool) Configuration Settings
I have had a hard time finding DBCP settings that worked well and I have found few examples of full configuration, so here is what were using hope it helpsRead more...Tags : dbcp jdbc mysql tomcat
JavaRebel-Compiling and Reloading Java Code on the fly. Is much easier in Unexploded Format
Unexploded Format Development with JavaRebel is alot easier than exploded format.Read more...Tags : java
Comparison of 2 Java Excel APIs on Large Workbooks/Worksheets
I have recently had the need to output large excel files from a java web application. So I tried to compare two apis to see the largest spreadsheets I could generate. I was hoping that I could stream the Excel files, or that these apis had a flush ...

Recent Responses

Re: Continuum vs. Hudson and Triggering Hudson Builds with a Subversion Post Commit Hook Script
With polling we were getting transient jar exceptions alot. I have the following structure. 1. cross client project dependency 2. client specific project dependency 3. client specific war project Lets say I have polling setup to poll project 1 ...
Re: Continuum vs. Hudson and Triggering Hudson Builds with a Subversion Post Commit Hook Script
Hi Rob, Good post. I'm wondering why you wanted to trigger from svn instead of just have a short polling period in Hudson? Also, there are lots of "Maven people", so you could say that Nexus is also developed by Maven people, since we have ...
Re: How to handle redeploy of java WARs to tomcat5.5 on Windows and avoid jar file locking
This blog entry is a bit misleading at first. The first three paragraphs sound like you are going to discuss a solution for the problem that web apps sometimes do not undeploy completely because the jar files become locked, requiring the server to be shut ...

del.icio.us

ALL Rob's del.ic.ious bookmarks

Helpful Debugging MYSQL JDBC URL Parameters

I recently changed the JDBC urls I have used in my spring configuration for DBCP to add a couple of error debugging properties.

dumpMetadataOnColumnNotFound = Should the driver dump the field-level metadata of a result set into the exception message when ResultSet.findColumn() fails?

dumpQueriesOnException = Should the driver dump the contents of the query sent to the server in the message for SQLExceptions. This is really helpful to point out what the query is on SQLException. I have found this extremely useful.

<property name="url" value="jdbc:mysql://mysvr:3306/mydb?zeroDateTimeBehavior=convertToNull
&dumpMetaDataOnColumnNotFound=true&dumpQueriesOnException=true" />

The full list of query parameters can be seen at http://dev.mysql.com/doc/refman/5.1/en/connector-j-reference-configuration-properties.html

Add a comment

Posted by Robert Sinner on November 13, 2007 11:37:00 PM PST #

Add a comment Send a TrackBack

November 2007
Sun	Mon	Tue	Wed	Thu	Fri	Sat
				1	2	3
4	5	6	7	8	9	10
11	12	13	14	15	16	17
18	19	20	21	22	23	24
25	26	27	28	29	30
Oct \| Today \| Dec

Re: Helpful Debugging MYSQL JDBC URL Parameters Comment from Anonymous on November 22, 2009 1:02:14 AM PST #
Title
Body	HTML : b, strong, i, em, blockquote, br, p, pre, a href="", ul, ol, li, sub, sup
Name
E-mail address
Website
Remember me	Yes No
E-mail addresses are not publicly displayed, so please only leave your e-mail address if you would like to be notified when new comments are added to this blog entry (you can opt-out later).

Username
Password
Remember me

Helpful Debugging MYSQL JDBC URL Parameters

Re: Helpful Debugging MYSQL JDBC URL Parameters