TimShadel.com

We’ve been grappling with a number of different problems with our app over the last week. We’ve made many improvements, including several changes to our Spring configs (which I may touch on another day), but we still had a problem where occasionally we ran out of database connections momentarily — no matter how many we had in the pool to start with.

So the other morning I got an itch to start coding while I was waiting for my carpool ride to show up. By the time I got to work, I had a rough draft of something I wanted to try out. It’s a simple logging DataSource. We converted our datasource to one driven by Spring a couple months ago, but we still have a combination of straight JDBC, an old custom in-house ORM tool, and Hibernate. Somewhere among them, we’ve got something occasionally misbehaving.

It’s a pretty simple concept. I decided to extend Spring’s DelegatingDatasourceProxy to make my LoggingDataSource. Configuration is just as simple as changing this:

<jee:jndi-lookup id=“dataSourceTarget“ jndi-name=“java:/MyJbossDS“/>

to this:

<bean id=“dataSource“ class=“com.timshadel.util.LoggingDataSource“>
    <property name=“targetDataSource“ ref=“dataSourceTarget“/>
    <property name=“filterPattern“ value=“^(com.timshadel|com.example).*“/>
</bean>

<jee:jndi-lookup id=“dataSourceTarget“ jndi-name=“java:/MyJbossDS“/>

When you turn it on, you might see something like this:

[main] INFO  com.timshadel.util.LoggingDataSource  - Connection request stack trace, filtered by ‘^(com.timshadel|com.example).*’
        com.example.myapp.model.MyClass.determineSomethingImportant(MyClass.java:770)
        com.example.myapp.model.MyClass.updateStatusString(MyClass.java:674)
        com.example.myapp.model.MyClass.loadStatusInfo(MyClass.java:643)
        com.example.myapp.model.MyClass.reloadStatusInfo(MyClass.java:332)
        com.example.myapp.util.helper.LegacyHelper.run(LegacyHelper.java:440)
[main] ERROR com.timshadel.util.LoggingDataSource  - Connection request stack trace, filtered by ‘^(com.timshadel|com.example).*’
        CAUGHT EXCEPTION (java.sql.SQLException): Pretend there’s no more connections.
        com.example.myapp.model.MyClass.determineSomethingImportant(MyClass.java:770)
        com.example.myapp.model.MyClass.updateStatusString(MyClass.java:674)
        com.example.myapp.model.MyClass.loadStatusInfo(MyClass.java:643)
        com.example.myapp.model.MyClass.reloadStatusInfo(MyClass.java:332)
        com.example.myapp.util.helper.LegacyHelper.run(LegacyHelper.java:440)

All of the stacktrace lines have been removed except those that match your pattern. This is helpful to make sure you cut through a typical enterprise Java call stack to only show the calls your code is making. For us that was helpful as a poor man’s way to determine which pieces of our code were using connections frequently. One simple run turned up a few hotspots. If we need to dig in a bit more, perhaps we’ll throw together a simple Ruby script to count how often a given call stack shows up in the log.

Also note, that since this puts the info out to Log4j, you can obviously pull this logging out to a completely separate file, set a different threshold, or use any of the other standard Log4j features to capture this information in a way that’s useful to you.

Finally, please remember that I pulled lots of this together while riding to work. It’s not really meant to be used for anything serious. Please expect warts and problems, but hopefully it’s enough to help get you goin’.

These days there’s lots of sleaze around, and one place where it annoys me is at the domain registrar GoDaddy.com. I’ve used them forever it seems — back when I saw their ad on AltaVista’s search engine. These days, though, I find their marketing to be sleazier than I appreciate. On top of that I’m not interested in paying the rates they require to keep your domain private, and for my new domains I’m interested in simple email setups and such. So Google Apps for Your Domain fits the bill quite nicely. It’s $10 per year, you get a GMail-ish setup plus more, and I don’t have to use GoDaddy.com.

I haven’t yet signed up with eNom for anything. I plan to purchase my first domain from them (via Google Apps) tomorrow. I may not be able to move all of my domains right away, but I think that by pushing my money to someone else that’s less offensive I’ll feel better about what it gets used for in the end. It’s small, but it’s one simple way to start standing up against the sleaze of the day.

It’s hard to believe that it’s been a year since my “burrito” podcasts on JSF. So what have I done in this last year with JSF? What is my opinion now and how has it changed?

Have you ever skipped out on a movie that was popular? Decided not to see it because it either didn’t fit your taste or didn’t mesh with your life in some other way? I have. I usually look back later on without regret. That’s the way I feel looking back at JSF a year later, but let give you some details.

(more…)