Filter [springSecurityFilterChain]: could not be initialized

[sanket reddy]

Hi All,

I am getting the below error page sometimes when i deploy my code in Websphere. same thing works fine in tomcat.

I double checked and the below queires works fine :-

SELECT CHNL_CD as code, CHNL_NM as description FROM TBLREF_CHNL ORDER BY DISP_ORD_NUM

[color=red]Error page exception
The server cannot use the error page specified for your application to handle the Original Exception printed below. Please see the Error Page Exception below for a description of the problem with the specified error page.


Original Exception: 
Error Message: Filter [springSecurityFilterChain]: could not be initialized
Error Code: 500
Target Servlet: null
Error Stack: 
org.springframework.beans.factory.BeanCreationExce ption: Error creating bean with name 'staticDataUtil' defined in class path resource [context/Servlet.xml]: Invocation of init method failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT CHNL_CD as code, CHNL_NM as description FROM TBLREF_CHNL ORDER BY DISP_ORD_NUM]; nested exception is java.sql.SQLException: ORA-00942: table or view does not exist 
at org.springframework.beans.factory.support.Abstract AutowireCapableBeanFactory.initializeBean(Abstract AutowireCapableBeanFactory.java:1338) 
at org.springframework.beans.factory.support.Abstract AutowireCapableBeanFactory.doCreateBean(AbstractAu towireCapableBeanFactory.java:473) 
at org.springframework.beans.factory.support.Abstract AutowireCapableBeanFactory$1.run(AbstractAutowireC apableBeanFactory.java:409) 
at java.security.AccessController.doPrivileged(Access Controller.java:219) 
at org.springframework.beans.factory.support.Abstract AutowireCapableBeanFactory.createBean(AbstractAuto wireCapableBeanFactory.java:380) 
at org.springframework.beans.factory.support.Abstract BeanFactory$1.getObject(AbstractBeanFactory.java:2 64) 
at org.springframework.beans.factory.support.DefaultS ingletonBeanRegistry.getSingleton(DefaultSingleton BeanRegistry.java:222) 
at org.springframework.beans.factory.support.Abstract BeanFactory.doGetBean(AbstractBeanFactory.java:261 ) 
at org.springframework.beans.factory.support.Abstract BeanFactory.getBean(AbstractBeanFactory.java:185) 
at org.springframework.beans.factory.support.Abstract BeanFactory.getBean(AbstractBeanFactory.java:164) 
at org.springframework.beans.factory.support.DefaultL istableBeanFactory.preInstantiateSingletons(Defaul tListableBeanFactory.java:429) 
at org.springframework.context.support.AbstractApplic ationContext.finishBeanFactoryInitialization(Abstr actApplicationContext.java:728) 
at org.springframework.context.support.AbstractApplic ationContext.refresh(AbstractApplicationContext.ja va:380) 
at org.springframework.web.context.ContextLoader.crea teWebApplicationContext(ContextLoader.java:255) 
at org.springframework.web.context.ContextLoader.init WebApplicationContext(ContextLoader.java:199) 
at org.springframework.web.context.ContextLoaderListe ner.contextInitialized(ContextLoaderListener.java: 45) 
at com.ibm.ws.wswebcontainer.webapp.WebApp.notifyServ letContextCreated(WebApp.java:652) 
at com.ibm.ws.webcontainer.webapp.WebApp.commonInitia lizationFinish(WebApp.java:354) 
at com.ibm.ws.wswebcontainer.webapp.WebApp.initialize (WebApp.java:292) 
at com.ibm.ws.wswebcontainer.webapp.WebGroup.addWebAp plication(WebGroup.java:92) 
at com.ibm.ws.wswebcontainer.VirtualHost.addWebApplic ation(VirtualHost.java:157) 
at com.ibm.ws.wswebcontainer.WebContainer.addWebApp(W ebContainer.java:671) 
at com.ibm.ws.wswebcontainer.WebContainer.addWebAppli cation(WebContainer.java:624) 
at com.ibm.ws.webcontainer.component.WebContainerImpl .install(WebContainerImpl.java:335) 
at com.ibm.ws.webcontainer.component.WebContainerImpl .start(WebContainerImpl.java:551) 
at com.ibm.ws.runtime.component.ApplicationMgrImpl.st art(ApplicationMgrImpl.java:1305) 
at com.ibm.ws.runtime.component.DeployedApplicationIm pl.fireDeployedObjectStart(DeployedApplicationImpl .java:1138) 
at com.ibm.ws.runtime.component.DeployedModuleImpl.st art(DeployedModuleImpl.java:569) 
at com.ibm.ws.runtime.component.DeployedApplicationIm pl.start(DeployedApplicationImpl.java:817) 
at com.ibm.ws.runtime.component.ApplicationMgrImpl.st artApplication(ApplicationMgrImpl.java:951) 
at com.ibm.ws.runtime.component.ApplicationMgrImpl$Ap pInitializer.run(ApplicationMgrImpl.java:2157) 
at com.ibm.wsspi.runtime.component.WsComponentImpl$_A synchInitializer.run(WsComponentImpl.java:342) 
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.j ava:1473) 
Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT CHNL_CD as code, CHNL_NM as description FROM TBLREF_CHNL ORDER BY DISP_ORD_NUM]; nested exception is java.sql.SQLException: ORA-00942: table or view does not exist 
at org.springframework.jdbc.support.SQLErrorCodeSQLEx ceptionTranslator.doTranslate(SQLErrorCodeSQLExcep tionTranslator.java:220) 
at org.springframework.jdbc.support.AbstractFallbackS QLExceptionTranslator.translate(AbstractFallbackSQ LExceptionTranslator.java:72) 
at org.springframework.jdbc.core.JdbcTemplate.execute (JdbcTemplate.java:407) 
at org.springframework.jdbc.core.JdbcTemplate.query(J dbcTemplate.java:458) 
at org.springframework.jdbc.core.JdbcTemplate.query(J dbcTemplate.java:466) 
at com.express_scripts.borg.macmra.dao.JdbcStaticData DaoImpl.getChannelData(JdbcStaticDataDaoImpl.java: 40) 
at com.express_scripts.borg.macmra.dao.JdbcStaticData DaoImpl$$FastClassByCGLIB$$19c345cc.invoke(<genera ted>) 
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy. java:191) 
at org.springframework.aop.framework.Cglib2AopProxy$C glibMethodInvocation.invokeJoinpoint(Cglib2AopProx y.java:700) 
at org.springframework.aop.framework.ReflectiveMethod Invocation.proceed(ReflectiveMethodInvocation.java :149) 
at com.express_scripts.inf.logging.util.LogMethodPara msAndResponseAdvice.invoke(LogMethodParamsAndRespo nseAdvice.java:107) 
at org.springframework.aop.framework.ReflectiveMethod Invocation.proceed(ReflectiveMethodInvocation.java :171) 
ramework.beans.factory.support.AbstractAutowireCap ableBeanFactory.initializeBean(AbstractAutowireCap ableBeanFactory.java:1335) 
... 32 more 
Caused by: java.sql.SQLException: ORA-00942: table or view does not exist 
at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:112) 
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:331) 
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:288) 
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java: 745) 
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStateme nt.java:207) 
at oracle.jdbc.driver.T4CStatement.executeForDescribe (T4CStatement.java:801) 
at oracle.jdbc.driver.OracleStatement.executeMaybeDes cribe(OracleStatement.java:1039) 
at oracle.jdbc.driver.T4CStatement.executeMaybeDescri be(T4CStatement.java:841) 
at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:1134) 
at oracle.jdbc.driver.OracleStatement.executeQuery(Or acleStatement.java:1274) 
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.pmiExecu teQuery(WSJdbcStatement.java:1540) 
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeQ uery(WSJdbcStatement.java:880) 
at org.springframework.jdbc.core.JdbcTemplate$1QueryS tatementCallback.doInStatement(JdbcTemplate.java:4 43) 
at org.springframework.jdbc.core.JdbcTemplate.execute (JdbcTemplate.java:396) 
... 67 more [/color]

Here is the part Servlet.xml 

[code]<bean id="staticDataUtil" class="com.express_scripts.borg.macmra.util.Static DataUtil" scope="singleton" factory-method="getInstance" init-method="populateStaticData" >
<constructor-arg ref="staticDataBOImpl" />
<constructor-arg ref="staticDataCache" />
</bean>

<bean id="gcnValidator"
class="com.express_scripts.borg.macmra.validator.G cnValidator" />

<bean id="gcnController"
class="com.express_scripts.borg.macmra.controller. GcnController">
<property name="methodNameResolver">
<ref bean="paramResolver" />
</property>
<property name="lpRunBO"><ref bean="lpRunBOImpl"/></property>
<property name="validatorMap">
<map>
<entry key="gcnValidator">
<ref bean="gcnValidator" />
</entry>
</map>
</property>
<property name="gcnBO">
<ref bean="gcnBOImpl" />
</property>
<property name="staticDataUtil">
<ref bean="staticDataUtil"/>
</property>
</bean>

Here is the part of web.xml

<!-- Enables Spring Security -->

<filter>
<filter-name>springSecurityFilterChain</filter-name>
<filter-class>org.springframework.web.filter.DelegatingFil terProxy</filter-class>
</filter>

<filter-mapping>
<filter-name>springSecurityFilterChain</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>

[/code]
I am not sure why we get the error randomly StaticDataUtil.java init.

Regards
Sanket