• Error - /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

    An Error Occurred:

    /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

    +- Stack Trace

    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
    

    +- Component Tree

    <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">
    header
    Exam
    <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>

    +- Scoped Variables

    Request Parameters
    NameValue
    None
    Request Attributes
    NameValue
    jsf_sequence1
    Session Attributes
    NameValue
    examBeancom.avivausa.wellness.exam.web.ExamBean@a065418
    examIdHolderIdHolder: null
    jsf_sequence1
    Application Attributes
    NameValue
    None
    Mar 10, 2010 2:16:11 PM - Generated by Facelets