javax.faces.el.EvaluationException: /pages/certification/examList.xhtml @25,44 rendered="#{not empty examBean.exams}": Exception getting value of property exams of base of type : com.avivausa.wellness.exam.web.ExamBean at com.sun.facelets.el.LegacyValueBinding.getValue(LegacyValueBinding.java(Compiled Code)) at javax.faces.component.UIComponentBase.isRendered(UIComponentBase.java(Compiled Code)) at org.apache.myfaces.component.html.ext.HtmlDataTable.isRendered(HtmlDataTable.java:1014) at com.sun.facelets.tag.jsf.ComponentSupport.encodeRecursive(ComponentSupport.java(Compiled Code)) at com.sun.facelets.tag.jsf.ComponentSupport.encodeRecursive(ComponentSupport.java(Compiled Code)) at com.sun.facelets.FaceletViewHandler.renderView(FaceletViewHandler.java(Compiled Code)) at org.apache.myfaces.lifecycle.RenderResponseExecutor.execute(RenderResponseExecutor.java(Compiled Code)) at org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java(Compiled Code)) at javax.faces.webapp.FacesServlet.service(FacesServlet.java(Compiled Code)) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java(Compiled Code)) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java(Compiled Code)) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled Code)) at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java(Compiled Code)) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java(Compiled Code)) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java(Compiled Code)) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled Code)) at org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java(Compiled Code)) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java(Compiled Code)) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled Code)) at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java(Compiled Code)) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java(Compiled Code)) at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java(Compiled Code)) at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java(Compiled Code)) at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java(Compiled Code)) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java(Compiled Code)) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java(Compiled Code)) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java(Compiled Code)) at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminaters(NewConnectionInitialReadCallback.java(Compiled Code)) at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java(Compiled Code)) at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java(Compiled Code)) at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java(Compiled Code)) at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java(Compiled Code)) at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java(Compiled Code)) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code)) Caused by: javax.faces.el.EvaluationException: Bean: com.avivausa.wellness.exam.web.ExamBean, property: exams at org.apache.myfaces.el.PropertyResolverImpl.getProperty(PropertyResolverImpl.java(Compiled Code)) at org.apache.myfaces.el.PropertyResolverImpl.getValue(PropertyResolverImpl.java(Compiled Code)) at org.apache.myfaces.custom.security.SecurityContextPropertyResolver.getValue(SecurityContextPropertyResolver.java(Compiled Code)) at com.sun.facelets.el.LegacyELContext$LegacyELResolver.getValue(LegacyELContext.java(Compiled Code)) at com.sun.el.parser.AstValue.getValue(AstValue.java(Compiled Code)) at com.sun.el.parser.AstEmpty.getValue(AstEmpty.java(Compiled Code)) at com.sun.el.parser.AstNot.getValue(AstNot.java(Compiled Code)) at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java(Compiled Code)) at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java(Compiled Code)) ... 34 more Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code)) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code)) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code)) at java.lang.reflect.Method.invoke(Method.java(Compiled Code)) ... 43 more Caused by: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [SELECT BLTN_ID FROM AGTXNET.AGENT_PORTAL_BLTN_ACPT WHERE AL_USER_ID = ?]; SQL state [null]; error code [-99999]; Jdbc type 0 not yet supported.; nested exception is com.ibm.db2.jcc.a.SqlException: Jdbc type 0 not yet supported. at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:120) at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:276) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:554) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:588) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:617) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:625) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:657) at com.avivausa.wellness.exam.app.dao.ExamDaoStatusImpl.getExams(ExamDaoStatusImpl.java:31) at com.avivausa.wellness.exam.app.ExamServiceImpl.getExams(ExamServiceImpl.java:33) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code)) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code)) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code)) at java.lang.reflect.Method.invoke(Method.java(Compiled Code)) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java(Compiled Code)) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java(Compiled Code)) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy2.getExams(Unknown Source) at com.avivausa.wellness.exam.web.ExamBean.getExams(ExamBean.java:77) ... 48 more Caused by: com.ibm.db2.jcc.a.SqlException: Jdbc type 0 not yet supported. at com.ibm.db2.jcc.a.n.a(n.java:1003) at com.ibm.db2.jcc.a.n.a(n.java:892) at com.ibm.db2.jcc.a.n.a(n.java:873) at com.ibm.db2.jcc.a.id.b(id.java:565) at com.ibm.db2.jcc.a.id.setNull(id.java:555) at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.setNull(WSJdbcPreparedStatement.java:1096) at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValueInternal(StatementCreatorUtils.java:154) at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValue(StatementCreatorUtils.java:94) at org.springframework.jdbc.core.ArgPreparedStatementSetter.setValues(ArgPreparedStatementSetter.java:51) at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:593) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:538) ... 67 more
<UIViewRoot locale="en" renderKitId="HTML_BASIC" rendered="true" transient="false" viewId="/pages/certification/examList.xhtml"><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd" ><html xmlns="http://www.w3.org/1999/xhtml"><head> <title>Aviva Wellness</title> <link rel="stylesheet" href="#{facesContext.externalContext.requestContextPath}/avivaDesign/css/layout_screen.css" media="screen"/> <link rel="stylesheet" href="#{facesContext.externalContext.requestContextPath}/avivaDesign/css/layout_print.css" media="print"/> <script type="text/javascript" src="http://api.maps.yahoo.com/ajaxymap?v=3.7&appid=n474OkHV34EVoWHwEAxN0IAmUBODWfIrTJsxMmmrF09sH3TrJ4ar9szh9LZUdCAuwg--"/> <script type="text/javascript" src="#{facesContext.externalContext.requestContextPath}/avivaDesign/js/layout/jquery-1.2.3.pack.js"/> <script type="text/javascript" src="#{facesContext.externalContext.requestContextPath}/avivaDesign/js/layout/ui.tabs.pack.js"/> <script type="text/javascript" src="#{facesContext.externalContext.requestContextPath}/avivaDesign/js/layout/popup.js"/> <script type="text/javascript" src="#{facesContext.externalContext.requestContextPath}/avivaDesign/js/layout/avivaLayoutCurrentTime.js"/> <script type="text/javascript" src="#{facesContext.externalContext.requestContextPath}/avivaDesign/js/layout/ui.datepicker.pack.js" charset="utf-8"/> <script type="text/javascript" src="#{facesContext.externalContext.requestContextPath}/avivaDesign/js/layout/ready.js"/> <script type="text/javascript">window.onload = function() { avivaLayoutCurrentTime(); }</script> </head> <body> <div id="container"> <div id="header"> <div class="topbar"> <ul> <li class="noborder"><HtmlForm enctype="application/x-www-form-urlencoded" id="_id3" rendered="true" submitted="false" transient="false"><HtmlCommandLink action="wellness" actionListener="#{loginAction.logout}" disabled="false" id="_id4" immediate="false" rendered="false" transient="false" value="Logout"/></HtmlForm></li> </ul> </div> <div class="logoContainer"> <div class="logo"><img src="#{facesContext.externalContext.requestContextPath}/avivaDesign/images/layout/logo_aviva.gif" alt="Aviva logo" width="61" height="43" border="0" title="Aviva logo"/></div> <div class="tagline"><img src="#{facesContext.externalContext.requestContextPath}/avivaDesign/images/layout/tagline_anim.gif" width="224" height="50" alt="Aviva. Taking care of what's important" title="Aviva. Taking care of what's important" border="0"/></div> </div> </div> <div id="topMenuContainer"> <div class="topmenu"><HtmlForm enctype="application/x-www-form-urlencoded" id="_id6" rendered="true" submitted="false" transient="false"><ul><HtmlTag id="_id8" rendered="true" styleClass=" " transient="false" value="li"><HtmlCommandLink action="wellness" id="_id9" immediate="false" rendered="true" styleClass="menu2" transient="false">Wellness</HtmlCommandLink></HtmlTag><HtmlTag id="_id11" rendered="true" styleClass=" " transient="false" value="li"><HtmlCommandLink action="getCertified" id="_id12" immediate="false" rendered="true" styleClass="menu2" transient="false">Get Certified</HtmlCommandLink></HtmlTag><HtmlTag id="_id14" rendered="true" styleClass=" " transient="false" value="li"><HtmlCommandLink action="innovation" id="_id15" immediate="false" rendered="true" styleClass="menu2" transient="false">Innovation</HtmlCommandLink></HtmlTag><HtmlTag id="_id17" rendered="true" styleClass=" " transient="false" value="li"><HtmlCommandLink action="annuitymarketing" id="_id18" immediate="false" rendered="true" styleClass="menu2" transient="false">Marketing Tools</HtmlCommandLink></HtmlTag><HtmlTag id="_id20" rendered="false" styleClass="topMenuSelected" transient="false" value="li"><HtmlCommandLink action="examList" id="_id21" immediate="false" rendered="true" styleClass="menu2" transient="false">Certifications</HtmlCommandLink></HtmlTag></ul></HtmlForm></div> </div> <div id="mainContainer" class="mainContainerLeftMenuOpen"> <div id="leftContentContainer" class="leftContentContainerOpen"> <div class="leftContent"> <h1 class="sectionTitle"> <a href="#">#{navTitle}</a> </h1> <div class="leftmenu"><HtmlForm enctype="application/x-www-form-urlencoded" id="_id25" rendered="true" submitted="false" transient="false"><ul> <li><HtmlCommandLink action="examList" id="_id27" immediate="false" rendered="true" styleClass="menu3lit" transient="false">Exam List</HtmlCommandLink></li> </ul></HtmlForm></div> </div> <div class="leftContentFooter"><HtmlForm enctype="application/x-www-form-urlencoded" id="_id31" rendered="true" submitted="false" transient="false"><div class="localTime">Local time <span id="avivaLayoutCurrentTime"/></div> <div class="globalContacts">Your global contacts <br/> & products directory</div> <select id="avivaLayoutCountry" name="country" class="formInputSelect" onchange="return country_popup();"> <option selected="" value="https://www.aviva.com/avivaworld/index.htm">Select a country</option> <option value="https://www.aviva.com/avivaworld/index.asp?pageid=49">Asia</option> <option value="https://www.aviva.com/avivaworld/index.asp?pageid=53">Australia</option> <option value="https://www.aviva.com/avivaworld/index.asp?pageid=57">Belgium</option> <option value="https://www.aviva.com/avivaworld/index.asp?pageid=65">Canada</option> <option value="https://www.aviva.com/avivaworld/index.asp?pageid=69">China</option> <option value="https://www.aviva.com/avivaworld/index.asp?pageid=73">Cyprus</option> <option value="https://www.aviva.com/avivaworld/index.asp?pageid=77">Czech Republic</option> <option value="https://www.aviva.com/avivaworld/index.asp?pageid=81">France</option> <option value="https://www.aviva.com/avivaworld/index.asp?pageid=85">Germany</option> <option value="https://www.aviva.com/avivaworld/index.asp?pageid=93">Greece</option> <option value="https://www.aviva.com/avivaworld/index.asp?pageid=97">Hong Kong</option> <option value="https://www.aviva.com/avivaworld/index.asp?pageid=101">Hungary</option> <option value="https://www.aviva.com/avivaworld/index.asp?pageid=105">India</option> <option value="https://www.aviva.com/avivaworld/index.asp?pageid=109">Indonesia</option> <option value="https://www.aviva.com/avivaworld/index.asp?pageid=113">Ireland</option> <option value="https://www.aviva.com/avivaworld/index.asp?pageid=117">Italy</option> <option value="https://www.aviva.com/avivaworld/index.asp?pageid=121">Japan</option> <option value="https://www.aviva.com/avivaworld/index.asp?pageid=125">Lithuania</option> <option value="https://www.aviva.com/avivaworld/index.asp?pageid=129">Luxembourg</option> <option value="https://www.aviva.com/avivaworld/index.asp?pageid=137">Malta</option> <option value="https://www.aviva.com/avivaworld/index.asp?pageid=141">Netherlands</option> <option value="https://www.aviva.com/avivaworld/index.asp?pageid=145">Philippines</option> <option value="https://www.aviva.com/avivaworld/index.asp?pageid=149">Poland</option> <option value="https://www.aviva.com/avivaworld/index.asp?pageid=157">Romania</option> <option value="https://www.aviva.com/avivaworld/index.asp?pageid=217">Russia</option> <option value="https://www.aviva.com/avivaworld/index.asp?pageid=161">Singapore</option> <option value="https://www.aviva.com/avivaworld/index.asp?pageid=165">Spain</option> <option value="https://www.aviva.com/avivaworld/index.asp?pageid=212">Sri Lanka</option> <option value="https://www.aviva.com/avivaworld/index.asp?pageid=173">Turkey</option> <option value="https://www.aviva.com/avivaworld/index.asp?pageid=177">United Kingdom</option> <option value="https://www.aviva.com/avivaworld/index.asp?pageid=181">USA</option> </select> <input class="leftmenubtn" type="submit" name="Go" value="Go" onmouseout="this.className='leftmenubtn';" onfocus="this.className='leftmenubtnHover';" onmouseover="this.className='leftmenubtnHover';" onblur="this.className='leftmenubtn';" onkeypress="return country_popup();" onclick="return country_popup();"/></HtmlForm></div> </div> <div id="rightContentContainer" class="rightContentContainerLeftMenuOpen"> <div class="content"> <fieldset class="formFieldset"> <legend>#{contentTitle}</legend> <br/><HtmlForm enctype="application/x-www-form-urlencoded" id="_id34" rendered="true" submitted="false" transient="false"><HtmlDataTable border="0" cellpadding="0" cellspacing="0" expandedEmpty="true" first="0" footerClass="dataTableFooter" forceId="false" headerClass="dataTableHeader" id="_id35" newspaperColumns="1" preserveDataModel="false" preserveRowStates="false" preserveSort="true" renderedIfEmpty="true" rowClasses="odd_row, even_row" rowIndex="-1" rows="0" sortAscending="true" sortColumnIndex="-1" sortable="false" style="width:400px" styleClass="dataTable" transient="false" var="exam"><HtmlSimpleColumn defaultSorted="false" groupBy="false" header="Exam" id="_id36" rendered="true" sortable="false" transient="false">headerExam<HtmlOutputText escape="true" id="_id38" rendered="true" transient="false"/></HtmlSimpleColumn><HtmlSimpleColumn defaultSorted="false" groupBy="false" id="_id39" rendered="true" sortable="false" transient="false"><a href="#" onclick="window.open('#{facesContext.externalContext.requestContextPath}/pages/guides/#{exam.pdfFileName}.pdf', '');">Study</a><HtmlCommandLink action="#{examBean.startExam}" disabled="false" id="_id41" immediate="false" rendered="true" transient="false" value="Start"/></HtmlSimpleColumn></HtmlDataTable><HtmlOutputText escape="true" id="_id42" transient="false" value="There are no exams to be taken."/></HtmlForm></fieldset> </div> </div> </div> <div id="footerContainer" class="footerOpen"> <div class="bottombar"> <ul> <li>An Aviva Group Company</li> </ul> <p> Aviva Life Insurance Company 2008 <br/> Aviva Life Insurance Company is licensed and offers its products in the District of Columbia and all States except New York. Our subsidiary company, Aviva Life Insurance Company of New York, is licensed and offers products in New York. This web site contains products offered by Aviva Life Insurance Company only. If you are a New York resident and would like further information on Aviva Life Insurance Company of New York, please contact us at 800 551 5268. </p> </div> </div> </div> </body></html></UIViewRoot>