Spring JDBC Problem getting log messages

[Justin Howard]

Hi All,

I am using Spring 3 with Spring JDBC. Spring JDBC doesnt seem to be working. So I tried to get the log messages for the jdbc. But thats not working too.
I have this in my web.xml (partial)

   
<context-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>/WEB-INF/classes/applicationContext.xml</param-value>
	</context-param>
	<context-param>
		<param-name>log4jConfigLocation</param-name>
		<param-value>/WEB-INF/classes/log4j.properties</param-value>
	</context-param>
	
	<listener>
	    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
	</listener>
	<listener>
		<listener-class>org.springframework.web.util.Log4jConfigListener</listener-class>
	</listener>

This is in my log4j.properties. I also made sure lo4j.properties is in the classpath.

   
log4j.rootLogger=DEBUG,R
log4j.appender.R=org.apache.log4j.RollingFileAppender
log4j.appender.R.File= C:/Program Files/Apache Software Foundation/Tomcat 6.0/logs/marketingformsLog.log
log4j.appender.R.layout=org.apache.log4j.PatternLayout
log4j.appender.R.layout.ConversionPattern=%d{dd MMM yyyy HH:mm:ss,SSS} %5p %c{1}:%L - %m%n
log4j.logger.org.springframework.jdbc.core=DEBUG
log4j.logger.org.springframework.beans.factory=DEBUG

Thanks

[Justin Howard]

Hi All,

Any suggestions to debug??

Thanks

[Jeanne Boyarsky]

ItDoesntWorkIsUseless What happened? Is there an error message in system out? system error? did the code not respond to something?

[Justin Howard]

Thanks. Sorry about the lack of information in the question.
I am not able to get Spring JDBC working. I am trying to get some log statements regarding the Spring JDBC in the logs to figure it out.
I am using Tomcat 6, Spring 3.
This is all I get in the logs now.

    
Mar 11 11:12:44 EST 2010]; root of context hierarchy
11 Mar 2010 11:12:44,276  INFO XmlBeanDefinitionReader:315 - Loading XML bean definitions from class path resource [applicationContext.xml]
11 Mar 2010 11:12:44,276 DEBUG DefaultDocumentLoader:72 - Using JAXP provider [org.apache.xerces.jaxp.DocumentBuilderFactoryImpl]
11 Mar 2010 11:12:44,276 DEBUG PluggableSchemaResolver:105 - Trying to resolve XML entity with public id [null] and system id [http://www.springframework.org/schema/beans/spring-beans-3.0.xsd]
11 Mar 2010 11:12:44,276 DEBUG PluggableSchemaResolver:140 - Loading schema mappings from [META-INF/spring.schemas]
11 Mar 2010 11:12:44,370 DEBUG PluggableSchemaResolver:146 - Loaded schema mappings: {http://www.springframework.org/schema/oxm/spring-oxm-3.0.xsd=org/springframework/oxm/config/spring-oxm-3.0.xsd, http://www.springframework.org/schema/util/spring-util.xsd=org/springframework/beans/factory/xml/spring-util-3.0.xsd, http://www.springframework.org/schema/jms/spring-jms-3.0.xsd=org/springframework/jms/config/spring-jms-3.0.xsd, http://www.springframework.org/schema/task/spring-task.xsd=org/springframework/scheduling/config/spring-task-3.0.xsd, http://www.springframework.org/schema/aop/spring-aop-3.0.xsd=org/springframework/aop/config/spring-aop-3.0.xsd, http://www.springframework.org/schema/aop/spring-aop-2.0.xsd=org/springframework/aop/config/spring-aop-2.0.xsd, http://www.springframework.org/schema/oxm/spring-oxm.xsd=org/springframework/oxm/config/spring-oxm-3.0.xsd, http://www.springframework.org/schema/tool/spring-tool-2.5.xsd=org/springframework/beans/factory/xml/spring-tool-2.5.xsd, http://www.springframework.org/schema/beans/spring-beans.xsd=org/springframework/beans/factory/xml/spring-beans-3.0.xsd, http://www.springframework.org/schema/jee/spring-jee-2.5.xsd=org/springframework/ejb/config/spring-jee-2.5.xsd, http://www.springframework.org/schema/aop/spring-aop.xsd=org/springframework/aop/config/spring-aop-3.0.xsd, http://www.springframework.org/schema/beans/spring-beans-2.0.xsd=org/springframework/beans/factory/xml/spring-beans-2.0.xsd, http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd=org/springframework/web/servlet/config/spring-mvc-3.0.xsd, http://www.springframework.org/schema/beans/spring-beans-3.0.xsd=org/springframework/beans/factory/xml/spring-beans-3.0.xsd, http://www.springframework.org/schema/task/spring-task-3.0.xsd=org/springframework/scheduling/config/spring-task-3.0.xsd, http://www.springframework.org/schema/tx/spring-tx-2.5.xsd=org/springframework/transaction/config/spring-tx-2.5.xsd, http://www.springframework.org/schema/context/spring-context-2.5.xsd=org/springframework/context/config/spring-context-2.5.xsd, http://www.springframework.org/schema/jdbc/spring-jdbc-3.0.xsd=org/springframework/jdbc/config/spring-jdbc-3.0.xsd, http://www.springframework.org/schema/tool/spring-tool-3.0.xsd=org/springframework/beans/factory/xml/spring-tool-3.0.xsd, http://www.springframework.org/schema/tx/spring-tx.xsd=org/springframework/transaction/config/spring-tx-3.0.xsd, http://www.springframework.org/schema/tool/spring-tool-2.0.xsd=org/springframework/beans/factory/xml/spring-tool-2.0.xsd, http://www.springframework.org/schema/util/spring-util-2.5.xsd=org/springframework/beans/factory/xml/spring-util-2.5.xsd, http://www.springframework.org/schema/lang/spring-lang.xsd=org/springframework/scripting/config/spring-lang-3.0.xsd, http://www.springframework.org/schema/lang/spring-lang-2.5.xsd=org/springframework/scripting/config/spring-lang-2.5.xsd, http://www.springframework.org/schema/jee/spring-jee-3.0.xsd=org/springframework/ejb/config/spring-jee-3.0.xsd, http://www.springframework.org/schema/jee/spring-jee-2.0.xsd=org/springframework/ejb/config/spring-jee-2.0.xsd, http://www.springframework.org/schema/context/spring-context.xsd=org/springframework/context/config/spring-context-3.0.xsd, http://www.springframework.org/schema/jee/spring-jee.xsd=org/springframework/ejb/config/spring-jee-3.0.xsd, http://www.springframework.org/schema/jms/spring-jms-2.5.xsd=org/springframework/jms/config/spring-jms-2.5.xsd, http://www.springframework.org/schema/jms/spring-jms.xsd=org/springframework/jms/config/spring-jms-3.0.xsd, http://www.springframework.org/schema/aop/spring-aop-2.5.xsd=org/springframework/aop/config/spring-aop-2.5.xsd, http://www.springframework.org/schema/mvc/spring-mvc.xsd=org/springframework/web/servlet/config/spring-mvc-3.0.xsd, http://www.springframework.org/schema/jdbc/spring-jdbc.xsd=org/springframework/jdbc/config/spring-jdbc-3.0.xsd, http://www.springframework.org/schema/tx/spring-tx-2.0.xsd=org/springframework/transaction/config/spring-tx-2.0.xsd, http://www.springframework.org/schema/tx/spring-tx-3.0.xsd=org/springframework/transaction/config/spring-tx-3.0.xsd, http://www.springframework.org/schema/context/spring-context-3.0.xsd=org/springframework/context/config/spring-context-3.0.xsd, http://www.springframework.org/schema/tool/spring-tool.xsd=org/springframework/beans/factory/xml/spring-tool-3.0.xsd, http://www.springframework.org/schema/util/spring-util-3.0.xsd=org/springframework/beans/factory/xml/spring-util-3.0.xsd, http://www.springframework.org/schema/lang/spring-lang-3.0.xsd=org/springframework/scripting/config/spring-lang-3.0.xsd, http://www.springframework.org/schema/util/spring-util-2.0.xsd=org/springframework/beans/factory/xml/spring-util-2.0.xsd, http://www.springframework.org/schema/lang/spring-lang-2.0.xsd=org/springframework/scripting/config/spring-lang-2.0.xsd, http://www.springframework.org/schema/beans/spring-beans-2.5.xsd=org/springframework/beans/factory/xml/spring-beans-2.5.xsd}
11 Mar 2010 11:12:44,370 DEBUG PluggableSchemaResolver:118 - Found XML schema [http://www.springframework.org/schema/beans/spring-beans-3.0.xsd] in classpath: org/springframework/beans/factory/xml/spring-beans-3.0.xsd
11 Mar 2010 11:12:44,386 DEBUG DefaultBeanDefinitionDocumentReader:87 - Loading bean definitions
11 Mar 2010 11:12:44,386 DEBUG XmlBeanDefinitionReader:185 - Loaded 2 bean definitions from location pattern [applicationContext.xml]
11 Mar 2010 11:12:44,386 DEBUG ClassPathXmlApplicationContext:461 - Bean factory for org.springframework.context.support.ClassPathXmlApplicationContext@3c33d3: org.springframework.beans.factory.support.DefaultListableBeanFactory@cfb11f: defining beans [researchDao,dataSource]; root of factory hierarchy
11 Mar 2010 11:12:44,386 DEBUG ClassPathXmlApplicationContext:735 - Unable to locate MessageSource with name 'messageSource': using default [org.springframework.context.support.DelegatingMessageSource@11799e7]
11 Mar 2010 11:12:44,386 DEBUG ClassPathXmlApplicationContext:759 - Unable to locate ApplicationEventMulticaster with name 'applicationEventMulticaster': using default [org.springframework.context.event.SimpleApplicationEventMulticaster@793542]
11 Mar 2010 11:12:44,386  INFO DefaultListableBeanFactory:532 - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@cfb11f: defining beans [researchDao,dataSource]; root of factory hierarchy
11 Mar 2010 11:12:44,386 DEBUG DefaultListableBeanFactory:214 - Creating shared instance of singleton bean 'researchDao'
11 Mar 2010 11:12:44,386 DEBUG DefaultListableBeanFactory:424 - Creating instance of bean 'researchDao'
11 Mar 2010 11:12:44,386 DEBUG DefaultListableBeanFactory:498 - Eagerly caching bean 'researchDao' to allow for resolving potential circular references
11 Mar 2010 11:12:44,386 DEBUG DefaultListableBeanFactory:214 - Creating shared instance of singleton bean 'dataSource'
11 Mar 2010 11:12:44,401 DEBUG DefaultListableBeanFactory:424 - Creating instance of bean 'dataSource'
11 Mar 2010 11:12:44,401 DEBUG DefaultListableBeanFactory:498 - Eagerly caching bean 'dataSource' to allow for resolving potential circular references
11 Mar 2010 11:12:44,401 DEBUG DefaultListableBeanFactory:1444 - Invoking afterPropertiesSet() on bean with name 'dataSource'
11 Mar 2010 11:12:44,401 DEBUG JndiTemplate:150 - Looking up JNDI object with name [java:comp/env/jdbc/dsnForms]
11 Mar 2010 11:12:44,401 DEBUG JndiObjectFactoryBean:111 - Located object with JNDI name [java:comp/env/jdbc/dsnForms]
11 Mar 2010 11:12:44,401 DEBUG DefaultListableBeanFactory:452 - Finished creating instance of bean 'dataSource'
11 Mar 2010 11:12:44,401 DEBUG DefaultListableBeanFactory:1444 - Invoking afterPropertiesSet() on bean with name 'researchDao'
11 Mar 2010 11:12:44,401 DEBUG DefaultListableBeanFactory:452 - Finished creating instance of bean 'researchDao'
11 Mar 2010 11:12:44,401 DEBUG DefaultListableBeanFactory:241 - Returning cached instance of singleton bean 'dataSource'
11 Mar 2010 11:12:44,401 DEBUG ClassPathXmlApplicationContext:786 - Unable to locate LifecycleProcessor with name 'lifecycleProcessor': using default [org.springframework.context.support.DefaultLifecycleProcessor@4cdac8]
11 Mar 2010 11:12:44,401 DEBUG DefaultListableBeanFactory:241 - Returning cached instance of singleton bean 'lifecycleProcessor'
11 Mar 2010 11:12:44,401 DEBUG ClassPathXmlApplicationContext:292 - Publishing event in org.springframework.context.support.ClassPathXmlApplicationContext@3c33d3: org.springframework.context.event.ContextRefreshedEvent[source=org.springframework.context.support.ClassPathXmlApplicationContext@3c33d3: startup date [Thu Mar 11 11:12:44 EST 2010]; root of context hierarchy]
11 Mar 2010 11:12:44,401 DEBUG DefaultListableBeanFactory:241 - Returning cached instance of singleton bean 'researchDao'
11 Mar 2010 11:39:53,572  INFO XmlWebApplicationContext:938 - Closing WebApplicationContext for namespace 'marketingforms-servlet': startup date [Thu Mar 11 09:50:05 EST 2010]; parent: Root WebApplicationContext
11 Mar 2010 11:39:53,572 DEBUG XmlWebApplicationContext:292 - Publishing event in WebApplicationContext for namespace 'marketingforms-servlet': org.springframework.context.event.ContextClosedEvent[source=WebApplicationContext for namespace 'marketingforms-servlet': startup date [Thu Mar 11 09:50:05 EST 2010]; parent: Root WebApplicationContext]
11 Mar 2010 11:39:53,572 DEBUG XmlWebApplicationContext:292 - Publishing event in Root WebApplicationContext: org.springframework.context.event.ContextClosedEvent[source=WebApplicationContext for namespace 'marketingforms-servlet': startup date [Thu Mar 11 09:50:05 EST 2010]; parent: Root WebApplicationContext]
11 Mar 2010 11:39:53,572 DEBUG DefaultListableBeanFactory:241 - Returning cached instance of singleton bean 'lifecycleProcessor'
11 Mar 2010 11:39:53,572  INFO DefaultListableBeanFactory:421 - Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@179f36b: defining beans []; parent: org.springframework.beans.factory.support.DefaultListableBeanFactory@10e434d

[Christophe Verré]

Sorry about the lack of information in the question. I am not able to get Spring JDBC working.

That's exactly what Jeanne is telling you : you are not telling us what is not working. What are you trying to do, and how ?