Dear All,

I am facing problem, after deploying OpenReports3.0 in Tomacat5.5.

In this project JRE1.5, Hibernate, Spring, Struts, Quartz and MSSqlServer2000 is used.

I have downloaded Openreports3.0 from SourceForge.Net and made all the changes as per the Installation guide.

After creating war file by ANT, I deployed it in Tomcat 5.5, deployement is successful but application does not starts.


Mapping documents:
ApplicationContext.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">

<beans default-autowire="byName">

<!-- allow for property placeholders -->
<bean id="environment"
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"
lazy-init="false">
<property name="ignoreResourceNotFound" value="true" />
<property name="locations">
<list>
<value>
classpath:openreports.properties
</value>
</list>
</property>
</bean>

<bean id="hibernateDataSource" destroy-method="close" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName" value="${hibernate.jdbc.driver}" />
<property name="url" value="${hibernate.jdbc.url}" />
<property name="username" value="${hibernate.jdbc.username}" />
<property name="password" value="${hibernate.jdbc.password}" />
<property name="maxIdle" value="${hibernate.jdbc.maxIdle}" />
<property name="maxActive" value="${hibernate.jdbc.maxActive}" />
</bean>

<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource" ref="hibernateDataSource" />
<property name="configLocation" value="classpath:/hibernate.cfg.xml"/>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">${hibernate.dialect}</prop>
<prop key="hibernate.jdbc.batch_size">0</prop>
</props>
</property>
</bean>

<bean id="hibernateProvider" class="org.efs.openreports.providers.HibernateProvider" singleton="true">
<property name="sessionFactory" ref="sessionFactory"/>
</bean>

<bean id="quartzDataSource" destroy-method="close" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName" value="${quartz.jdbc.driver}" />
<property name="url" value="${quartz.jdbc.url}" />
<property name="username" value="${quartz.jdbc.username}" />
<property name="password" value="${quartz.jdbc.password}" />
<property name="maxIdle" value="${quartz.jdbc.maxIdle}" />
<property name="maxActive" value="${quartz.jdbc.maxActive}" />
</bean>

<bean id="scheduler"
class="org.springframework.scheduling.quartz.SchedulerFactoryBean">
<property name="dataSource" ref="quartzDataSource" />
<property name="applicationContextSchedulerContextKey" value="applicationContext"/>
<property name="quartzProperties">
<props>
<prop key="org.quartz.scheduler.instanceName">ReportScheduler</prop>
<prop key="org.quartz.scheduler.instanceId">AUTO</prop>
<prop key="org.quartz.threadPool.class">org.quartz.simpl.SimpleThreadPool</prop>
<prop key="org.quartz.threadPool.threadCount">${org.quartz.threadPool.threadCount}</prop>
<prop key="org.quartz.jobStore.class">org.quartz.impl.jdbcjobstore.JobStoreTX</prop>
<prop key="org.quartz.jobStore.isClustered">false</prop>
<prop key="org.quartz.jobStore.useProperties">false</prop>
<prop key="org.quartz.jobStore.tablePrefix">QRTZ_</prop>
<prop key="org.quartz.jobStore.driverDelegateClass">${quartz.jobStore.driverDelegateClass}</prop>
<prop key="org.quartz.jobStore.selectWithLockSQL">${quartz.jobStore.selectWithLockSQL}</prop>
</props>
</property>
</bean>

<bean id="propertiesProvider"
class="org.efs.openreports.providers.impl.PropertiesProviderImpl"
singleton="true">
<constructor-arg>
<ref bean="hibernateProvider" />
</constructor-arg>
</bean>

<bean id="directoryProvider"
class="org.efs.openreports.providers.DirectoryProvider"
singleton="true">
<constructor-arg>
<ref bean="propertiesProvider" />
</constructor-arg>
</bean>

<bean id="dateProvider"
class="org.efs.openreports.providers.DateProvider" singleton="true">
<constructor-arg>
<ref bean="propertiesProvider" />
</constructor-arg>
</bean>

<bean id="dataSourceProvider"
class="org.efs.openreports.providers.impl.DataSourceProviderImpl"
singleton="true">
<constructor-arg>
<ref bean="hibernateProvider" />
</constructor-arg>
</bean>

<bean id="groupProvider"
class="org.efs.openreports.providers.impl.GroupProviderImpl"
singleton="true">
<constructor-arg>
<ref bean="hibernateProvider" />
</constructor-arg>
</bean>

<bean id="parameterProvider"
class="org.efs.openreports.providers.impl.ParameterProviderImpl"
singleton="true">
<constructor-arg>
<ref bean="dataSourceProvider" />
</constructor-arg>
<constructor-arg>
<ref bean="dateProvider" />
</constructor-arg>
<constructor-arg>
<ref bean="hibernateProvider" />
</constructor-arg>
</bean>

<bean id="reportLogProvider"
class="org.efs.openreports.providers.impl.ReportLogProviderImpl"
singleton="true">
<constructor-arg>
<ref bean="hibernateProvider" />
</constructor-arg>
</bean>

<bean id="reportProvider"
class="org.efs.openreports.providers.impl.ReportProviderImpl"
singleton="true">
<constructor-arg>
<ref bean="directoryProvider" />
</constructor-arg>
<constructor-arg>
<ref bean="hibernateProvider" />
</constructor-arg>
</bean>

<bean id="userProvider"
class="org.efs.openreports.providers.impl.UserProviderImpl"
singleton="true">
<constructor-arg>
<ref bean="hibernateProvider" />
</constructor-arg>
</bean>

<bean id="mailProvider"
class="org.efs.openreports.providers.MailProvider" singleton="true">
<constructor-arg>
<ref bean="propertiesProvider" />
</constructor-arg>
</bean>

<bean id="chartProvider"
class="org.efs.openreports.providers.impl.ChartProviderImpl"
singleton="true">
<constructor-arg>
<ref bean="hibernateProvider" />
</constructor-arg>
</bean>

<bean id="tagProvider"
class="org.efs.openreports.providers.impl.TagProviderImpl" singleton="true">
<constructor-arg>
<ref bean="hibernateProvider" />
</constructor-arg>
</bean>

<bean id="birtProvider"
class="org.efs.openreports.providers.BirtProvider" singleton="true" />

<bean id="schedulerProvider"
class="org.efs.openreports.providers.impl.SchedulerProviderImpl" singleton="true" >
<property name="scheduler" ref="scheduler" />
</bean>

<bean id="alertProvider"
class="org.efs.openreports.providers.impl.AlertProviderImpl" singleton="true">
<constructor-arg>
<ref bean="dataSourceProvider" />
</constructor-arg>
<constructor-arg>
<ref bean="reportLogProvider" />
</constructor-arg>
<constructor-arg>
<ref bean="hibernateProvider" />
</constructor-arg>
</bean>

<bean id="searchResultsTableDecorator"
class="org.efs.openreports.util.SearchResultsTableDecorator">
<property name="tagProvider" ref="tagProvider" />
</bean>

<bean id="fileSystemDeliveryMethod"
class="org.efs.openreports.delivery.FileSystemDeliveryMethod">
<property name="directoryProvider" ref="directoryProvider" />
<property name="mailProvider" ref="mailProvider" />
</bean>

<bean id="emailDeliveryMethod"
class="org.efs.openreports.delivery.EMailDeliveryMethod">
<property name="mailProvider" ref="mailProvider" />
</bean>

</beans>


These are the settings in the Openreport's property file for SQL Server and Quartz

# properties used by the Spring configuration

hibernate.dialect=org.hibernate.dialect.SQLServerDialect

hibernate.jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
hibernate.jdbc.url=jdbc:sqlserver://192.168.103.40:1433;databaseName=openre ports;
hibernate.jdbc.username=idea
hibernate.jdbc.password=idea123
hibernate.jdbc.maxIdle=2
hibernate.jdbc.maxActive=5

quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.MSSQLDelegate

# use the following line for HSQLDB demo Quartz databases
#quartz.jobStore.selectWithLockSQL = SELECT * FROM {0}LOCKS UPDLOCK WHERE LOCK_NAME = ?

# use this for all other Quartz databases
quartz.jobStore.selectWithLockSQL = SELECT * FROM {0}LOCKS WHERE LOCK_NAME = ? FOR UPDATE

quartz.jdbc.driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
quartz.jdbc.url = jdbc:sqlserver://192.168.103.40:1433;databaseName=openreports;
quartz.jdbc.username = idea
quartz.jdbc.password = idea123
quartz.jdbc.maxIdle=2
quartz.jdbc.maxActive=5

#number of threads that are available for concurrent execution of jobs
org.quartz.threadPool.threadCount = 5



Full stack trace of any exception that occurs:

ERROR - ContextLoader.initWebApplicationContext(205) | Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'scheduler' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'springNonTxDataSource.ReportScheduler': org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Login failed for user 'idea'.) [See nested exception: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Login failed for user 'idea'.)]]
Caused by:
org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'springNonTxDataSource.ReportScheduler': org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Login failed for user 'idea'.) [See nested exception: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Login failed for user 'idea'.)]]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:55 7)
at org.quartz.impl.jdbcjobstore.JobStoreCMT.initialize(JobStoreCMT.java:144)
at org.springframework.scheduling.quartz.LocalDataSourceJobStore.initialize(LocalD ataSourceJobStore.java:133)
at org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1204)
at org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1355)
at org.springframework.scheduling.quartz.SchedulerFactoryBean.createScheduler(Sche dulerFactoryBean.java:674)
at org.springframework.scheduling.quartz.SchedulerFactoryBean.afterPropertiesSet(S chedulerFactoryBean.java:574)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.in vokeInitMethods(AbstractAutowireCapableBeanFactory.java:1118)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.in itializeBean(AbstractAutowireCapableBeanFactory.java:1085)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.cr eateBean(AbstractAutowireCapableBeanFactory.java:429)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Abstr actBeanFactory.java:250)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingl eton(DefaultSingletonBeanRegistry.java:141)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractB eanFactory.java:247)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractB eanFactory.java:161)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstant iateSingletons(DefaultListableBeanFactory.java:270)
at org.springframework.context.support.AbstractApplicationContext.refresh(Abstract ApplicationContext.java:346)
at org.springframework.web.context.support.AbstractRefreshableWebApplicationContex t.refresh(AbstractRefreshableWebApplicationContext.java:156)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(Conte xtLoader.java:246)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(Context Loader.java:184)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(Contex tLoaderListener.java:49)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:376 4)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:831)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:515)
at org.apache.catalina.startup.HostConfig.check(HostConfig.java:1231)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.commons.modeler.BaseModelMBean.invoke(BaseModelMBean.java:458)
at com.sun.jmx.mbeanserver.DynamicMetaDataImpl.invoke(Unknown Source)
at com.sun.jmx.mbeanserver.MetaDataImpl.invoke(Unknown Source)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(Unknown Source)
at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(Unknown Source)
at org.apache.catalina.manager.ManagerServlet.check(ManagerServlet.java:1394)
at org.apache.catalina.manager.HTMLManagerServlet.doPost(HTMLManagerServlet.java:2 17)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFil terChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain .java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: 174)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.ja va:525)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:10 8)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConn ection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:5 28)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorke rThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:6 89)
at java.lang.Thread.run(Unknown Source)
Caused by: org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'springNonTxDataSource.ReportScheduler': org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Login failed for user 'idea'.) [See nested exception: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Login failed for user 'idea'.)]
at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT. java:167)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStore Support.java:3652)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStore Support.java:3624)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.cleanVolatileTriggerAndJobs(JobSto reSupport.java:693)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:55 5)
... 55 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Login failed for user 'idea'.)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:8 55)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at org.springframework.scheduling.quartz.LocalDataSourceJobStore$2.getConnection(L ocalDataSourceJobStore.java:125)
at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:112 )
at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT. java:164)
... 59 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'idea'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.processLogon(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnecti onFactory.java:37)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnection Factory.java:290)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSour ce.java:877)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:8 51)
... 63 more
ERROR - StandardContext.listenerStart(3768) | Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'scheduler' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'springNonTxDataSource.ReportScheduler': org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Login failed for user 'idea'.) [See nested exception: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Login failed for user 'idea'.)]]
Caused by:
org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'springNonTxDataSource.ReportScheduler': org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Login failed for user 'idea'.) [See nested exception: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Login failed for user 'idea'.)]]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:55 7)
at org.quartz.impl.jdbcjobstore.JobStoreCMT.initialize(JobStoreCMT.java:144)
at org.springframework.scheduling.quartz.LocalDataSourceJobStore.initialize(LocalD ataSourceJobStore.java:133)
at org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1204)
at org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1355)
at org.springframework.scheduling.quartz.SchedulerFactoryBean.createScheduler(Sche dulerFactoryBean.java:674)
at org.springframework.scheduling.quartz.SchedulerFactoryBean.afterPropertiesSet(S chedulerFactoryBean.java:574)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.in vokeInitMethods(AbstractAutowireCapableBeanFactory.java:1118)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.in itializeBean(AbstractAutowireCapableBeanFactory.java:1085)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.cr eateBean(AbstractAutowireCapableBeanFactory.java:429)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Abstr actBeanFactory.java:250)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingl eton(DefaultSingletonBeanRegistry.java:141)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractB eanFactory.java:247)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractB eanFactory.java:161)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstant iateSingletons(DefaultListableBeanFactory.java:270)
at org.springframework.context.support.AbstractApplicationContext.refresh(Abstract ApplicationContext.java:346)
at org.springframework.web.context.support.AbstractRefreshableWebApplicationContex t.refresh(AbstractRefreshableWebApplicationContext.java:156)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(Conte xtLoader.java:246)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(Context Loader.java:184)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(Contex tLoaderListener.java:49)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:376 4)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:831)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:515)
at org.apache.catalina.startup.HostConfig.check(HostConfig.java:1231)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.commons.modeler.BaseModelMBean.invoke(BaseModelMBean.java:458)
at com.sun.jmx.mbeanserver.DynamicMetaDataImpl.invoke(Unknown Source)
at com.sun.jmx.mbeanserver.MetaDataImpl.invoke(Unknown Source)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(Unknown Source)
at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(Unknown Source)
at org.apache.catalina.manager.ManagerServlet.check(ManagerServlet.java:1394)
at org.apache.catalina.manager.HTMLManagerServlet.doPost(HTMLManagerServlet.java:2 17)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFil terChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain .java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: 174)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.ja va:525)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:10 8)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConn ection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:5 28)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorke rThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:6 89)
at java.lang.Thread.run(Unknown Source)
Caused by: org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'springNonTxDataSource.ReportScheduler': org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Login failed for user 'idea'.) [See nested exception: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Login failed for user 'idea'.)]
at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT. java:167)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStore Support.java:3652)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStore Support.java:3624)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.cleanVolatileTriggerAndJobs(JobSto reSupport.java:693)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:55 5)
... 55 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Login failed for user 'idea'.)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:8 55)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at org.springframework.scheduling.quartz.LocalDataSourceJobStore$2.getConnection(L ocalDataSourceJobStore.java:125)
at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:112 )
at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT. java:164)
... 59 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'idea'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.processLogon(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnecti onFactory.java:37)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnection Factory.java:290)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSour ce.java:877)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:8 51)
... 63 more

Name and version of the database you are using:MS SQL Server 2000

[/b]