Getting JDBC performance and HTTP endpoint data with Spring Insight?

[nancydspiders]

More information, which may help or muddle things even further. I started with the petclinic application, enabled mysql, and got it running using an entry in servlet.xml: <Context docBase="path/to/petclinic/war" .../> and it looks just fine (jdbc calls in the trace, etc, and all the HTTP enpoints). But it looks like the file war/META-INF/context.xml isn't read (typos/errors in the file go unnoticed).

Then I copied all in the war directory to the catalina base (the tc Server instance), using eclipse's deployment mechanism. Now I get only the top level (ex: GET /petclinic/vets.do). But I know the context.xml file is read, because a typos/errors show up as errors in the logs.

I inserted a breakpoint at ClinicController#vetsHandler() and compared the stack traces (thinking maybe the valves were setup differently, but the two stacks looked the same.

[rahulsom]

I can see app traces fine in the recent activity view, but I can't see any HTTP endpoint activity either in the application health view.

Our app is Spring 2.5.x and running as the ROOT context in tomcat.

I see the same issue, however I'm not deploying on root. I am using a context path to deploy it. I just raised https://issuetracker.springsource.com/browse/INSIGHT-3

[cwagner]

I have a similar issue with an application I am trying to analyze using Insight. I deployed the application by copying the .war file in the webapps directory (i.e. it is not running in the ROOT context).

First of all, using the default configuration (which works fine on regular (non-Spring) Tomcat), the application won't start at all, and I get a lengthy Exception stack trace in my applications log file that the "myDataSource" bean could not be instanciated. The root cause is a javax.naming.NamingException with no error message.

The "myDataSource" bean is configured as follows:

    <bean id="myDataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
        <property name="jndiName">
            <value>java:comp/env/jdbc/hypodb</value>
        </property>
    </bean>

By default, the application provides the configuration for the resource in its META-INF/context.xml file. I tried moving the resource definition into the tc server's server.xml file under <GlobalNamingResources>, but I still get the same error.

So I changed the data source definition to skip JNDI and configure it directly in my Spring configuration, like so:

    <bean id="myDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://localhost:3306/mydatabase"/>
        <property name="username" value="xxxxxxx"/>
        <property name="password" value="xxxxxxx"/>
    </bean>

Now I can run the application on tc server and it shows up in Insight as well, but the traces contain nothing but information about the HTTP requests made (no call tracing, and no SQL tracing either, just like the OP). Also, under "Application Health", there are no endpoints listed.

I tried moving the MySQL JDBC driver into the webapp/lib directory, but it doesn't change anything. Still no SQL trace information available.

I'm using mysql-connector-java-5.0.7-bin.jar, the application is built using Spring 2.5 and Hibernate 3.0 (through JPA).

[jtravis]

I'm going to resurrect this thread. Litius, did you try putting the driver _only_ in WEB-INF/lib? That is the recommended fix. If you put it in both the WEB-INF/lib and the server/lib I don't believe it will take the latter.

[litius]

@jtravis,

Yeap, that is the first thing I tried (having the only jar in WEB-INF/lib).