Unable to access array values using EL

Updated my Thread..to add code tag.....

hi,

This is my first post.



I have a class that returns an Arraylist of string arrays..



I am accessing this bean from my JSP as follows :

---When i run this code i am getting an error as follows:

Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:505)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:416)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:968)
org.apache.jsp.accountHome_jsp._jspService(accountHome_jsp.java:75)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
javamodels.ValidateLogin.doPost(ValidateLogin.java:66)
javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause

javax.el.PropertyNotFoundException: Property '0' not found on type java.lang.String
javax.el.BeanELResolver$BeanProperties.get(BeanELResolver.java:193)
javax.el.BeanELResolver$BeanProperties.access$400(BeanELResolver.java:170)
javax.el.BeanELResolver.property(BeanELResolver.java:279)
javax.el.BeanELResolver.getValue(BeanELResolver.java:60)
javax.el.CompositeELResolver.getValue(CompositeELResolver.java:53)
org.apache.el.parser.AstValue.getValue(AstValue.java:118)
org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate(PageContextImpl.java:925)
org.apache.jsp.mytasks_jsp._jspx_meth_c_005fforEach_005f1(mytasks_jsp.java:179)
org.apache.jsp.mytasks_jsp._jspService(mytasks_jsp.java:123)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:968)
org.apache.jsp.accountHome_jsp._jspService(accountHome_jsp.java:75)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
javamodels.ValidateLogin.doPost(ValidateLogin.java:66)
javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)


---
My question is that i am not able to access the array at a given index using EL.
I am able to print the array and i get the expected result but i end up in this exception only when i try to access an array at a given index.

Please help me on this

Please be sure to use code tags when posting code to the forums. Unformatted code is extremely hard to read and many people that might be able to help you will just move along to posts that are easier to read. Please read this for more information.

You can go back and change your post to add code tags by clicking the button on your post.

Hi Bear Bibeault,

I have updated my thread by adding code tags..

First of all, you are mixing the EL and scriptlets? Why? Using both is a mess and bound to lead to problems.

Either choose to use the JSTL and EL, or choose to use scriptlets (not recommended), but not both.

And why are you doing this in a bean rather than under the control of a page controller servlet? Are you not using a Model 2 web application structure?

This error:

javax.el.PropertyNotFoundException: Property '0' not found on type java.lang.String

means that what you think is an array is actually a string.

Also, are you keeping an open connection in the application context?!

I guess yes.. I thought i would have to initialize the DB connection every time.. Would keeping an open connection hit on the performance of the application ?

What else can i do that would enable me to create a reusable DB connection object ?

Use a connection pool. By keeping an open connection you're basically putting a hard limit on the number of users.