Neha k Agrawal

Please see the code below. Basically I am populating the CachedRowSet from CachedRowSet Only instead of Result set. But I think that shouldn't matter.

So "rs" has all the rows from my query and I want to group all the rows with same key and copy them in a new CachedRowSet.

For ex:- In the below data, first 3 rows have same key[a1] , so I want to club them and put into a new cachedRowSet. So PageSize would be 3 and startIndex would be 1
but for a2 there is only one record so pageSize would be 1.

But my issue is , even if I set the startIndex as 1 , it is copying the data from 2nd row.


id , name , address
a1 name1 india
a1 name2 india
a1 name3 india
a2 name4 india
a2 name5 india
a3 name6 india




public void generateEvent(CachedRowSet rs) throws Exception { CachedRowSet aCachedRowSet = null; String Key = "Id"; String lastRowKey = ""; int parentcolIndex = getColIdByName(rs.getMetaData().getColumnCount() , rs , Key); int pageSize = 0; int startIndex = 0; aCachedRowSet = new OracleCachedRowSet(); aCachedRowSet.setReadOnly(false); aCachedRowSet.setType(ResultSet.TYPE_SCROLL_INSENSITIVE); aCachedRowSet.setConcurrency(ResultSet.CONCUR_UPDATABLE); boolean isNextRow = rs.next(); while(isNextRow) { lastRowKey = rs.getString(parentcolIndex); pageSize=0; startIndex = rs.getRow(); while(isNextRow!= false && lastRowKey!= null && lastRowKey.equals(rs.getString(parentcolIndex))) { isNextRow = rs.next(); pageSize ++; } //this is a temporary fix because I think populate method is calculating the index from 0 //I have also tried by commenting this line but it doesn't work startIndex = startIndex -1; aCachedRowSet.setPageSize(pageSize); aCachedRowSet.populate(rs, startIndex); } }

Thanks Krishna . But I have gone through this doc and I am setting the page size correctly. My issue is that populate method is not copying the rows from the startIndex which I am sending . If I am sending startIndex = 1 , it copies the data from row 2.

I have spent an entire day on this issue and I feel there is a bug with this method but I am surprised to see that no one has ever reported it .

Hi All,
Thank you for stopping here. I am facing some weird issue with CachedRowSet.populate(Resultset rs , int StartRow ) method. I am using OracleCachedRowSet.


Suppose the cursor is on 3rd row in the ResultSet and I want to copy the 2nd row .

CachedRowSet.setPageSize(1);
CachedRowSet.populate(rs , 2) ;

So it should actually copy the 2nd row but unfortunately , it is copying the 3rd row. Can anyone please tell me what am I doing wrong here.

Hi all,
I need solution to one of the problem that we are facing. I have a set of XSDs and I have generated Java Beans for those XSDs using Jaxb. Now I need to query the database[different query for every XSD] and populate these java beans using Resultset.

THis task is very simple if I want to harcode everything. In that case I need to know which query is for which XSD and populate the java beans by calling the setter for every fields in the Java Bean.

But I want to write a generic method , which just take the cachedRowset and Java Bean instance and start populating without any hard coding.

I got to know about Apache's BeanUtils.populate() method but I think it is good only for simple Java Beans[no hierarchy] not for the complex one where all the fields are not at the same level. Like the one generated from JAXB.


Can anyone please tell me what approach I should use to write a generic method?Any help would be highly appreciated.

Thanks in advance.

I just tried that & no luck same error. Do you suggest something else?

Hi All,
First of all sorry if this is very basic & has already been answered earlier on this forum but I couldn't find it & I am very new to Spring. I am getting the below error. I also see that this package is present in tiles-core-2.2.2.jar

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'tilesConfigurer' defined in ServletContext resource [/WEB-INF/dispatcher-servlet.xml]: Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundError: org/apache/tiles/startup/BasicTilesInitializer


I have added the following jars to WEB-INF/lib folder.

tiles-api-2.2.2.jar
tiles-core-2.2.2.jar
tiles-jsp-2.2.2.jar
tiles-servlet-2.2.2.jar
tiles-template-2.2.2.jar


Here goes my dispatcher-servlet.xml


<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p" xmlns:context="http://www.springframework.org/schema/context" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd"> <bean id="viewResolver" class="org.springframework.web.servlet.view.UrlBasedViewResolver"> <property name="viewClass"> <value> org.springframework.web.servlet.view.tiles2.TilesView </value> </property> </bean> <bean id="tilesConfigurer" class="org.springframework.web.servlet.view.tiles2.TilesConfigurer"> <property name="definitions"> <list> <value>/WEB-INF/tiles-defs.xml</value> </list> </property> </bean> </beans>

Can anyone please tell me what am I doing wrong here? Thanks in advance.

Hello Experts ,
I am a newbie in Java WebStart. I have been playing with deploying & updating desktop application using Java Webstart. But now I have a requirement that I don't want to deploy my application using Java WebStart. Image the application is already installed on my system from the last 1 year. At that time Java webstart was not used for deployment but now I want to use webstart just for automatic update. Is it possible to integrate this automatic update feature at later stage? By using plugin or smthing else? Please show some light.Many thanks in advance.

Hello Experts,
I am stuck with cross domain issue.I am using XmlHttpRequest object & I came to know that I can't call Cross Domain links using it.Then I started reading about it & came to know about 3 solutions:-

1)JSON
2)IFrames
3)Proxy

According to my requirement IFrames & Proxy are of no use for me.I can only think of JSON from the above 3.I started reading about it but didn't get any good example which can help me in solving my problem.Every body is saying to use <script> Tag but how ?? Can anyone please give me a light by giving some example on how exactly helps is solving cross domain issues.Or rather an example which shows how JSON replaces XmlHttpRequest object.Because finally I need to change my existing code which is written using XmlHttpRequest object.Please Help.I will really really APPRECIATE any HELP.Thanks a ton in advance.

Hello everyone,
I have integrated Jasper Reports with Struts 1.2.9.At runtime I am getting this error.

ApplicationDispatcher[/TGMC_DB1-2009] PWC1231: Servlet.service() for servlet jsp threw exception
java.lang.IllegalStateException: PWC3991: getOutputStream() has already been called for this response

at org.apache.coyote.tomcat5.CoyoteResponse.getWriter(CoyoteResponse.java:700)
at org.apache.coyote.tomcat5.CoyoteResponseFacade.getWriter(CoyoteResponseFacade.java:210)
at javax.servlet.ServletResponseWrapper.getWriter(ServletResponseWrapper.java:135)
at org.apache.jasper.runtime.JspWriterImpl.initOut(JspWriterImpl.java:171)
at org.apache.jasper.runtime.JspWriterImpl.flushBuffer(JspWriterImpl.java:164)
at org.apache.jasper.runtime.PageContextImpl.release(PageContextImpl.java:221)
at org.apache.jasper.runtime.JspFactoryImpl.internalReleasePageContext(JspFactoryImpl.java:157)
at org.apache.jasper.runtime.JspFactoryImpl.releasePageContext(JspFactoryImpl.java:108)
at org.apache.jsp.LeftMenu_jsp._jspService(LeftMenu_jsp.java from :152)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:93)


I read that "It is just that we open a output stream in the action and when we forward to any jsp, the container tries to open an output stream to write the JSP contents".So I have tried returning null instead if any action in my action class.Still it is giving same error.Please help me experts.Any help will be Highly Appreciated.

This is my code in action class.The line which is generating error is in bold... one more thing after exception it is going in 2nd catch block & not in first catch block where ex.getMessage() is printing null.

package com.myapp.struts; import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.struts.action.Action; import org.apache.struts.action.ActionForm; import org.apache.struts.action.ActionForward; import org.apache.struts.action.ActionMapping; import java.io.InputStream; import javax.servlet.ServletOutputStream; import javax.servlet.http.*; import net.sf.jasperreports.engine.JasperRunManager; import net.sf.jasperreports.engine.JRResultSetDataSource; import java.util.HashMap; import java.sql.ResultSet; import net.sf.jasperreports.engine.JRException; import java.io.PrintWriter; import java.io.StringWriter; public class ViewReportAction extends Action { public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { String target = new String("success"); try { ServletOutputStream servletOutputStream = response.getOutputStream(); ResultSet rs = null; InputStream reportStream = getServlet().getServletConfig().getServletContext().getResourceAsStream("F:\\project\\dynamicjasper\\src\\java\\test\\report1.jrxml"); rs = Reports.View_Ementor_list(getDataSource(request)); JRResultSetDataSource resultSetDataSource = new JRResultSetDataSource(rs); *//THIS LINE IS GENERATING ERROR aftter this it is going in 2nd catch block* *JasperRunManager.runReportToPdfStream(reportStream, servletOutputStream, new HashMap(), resultSetDataSource);* response.setContentType("application/pdf"); servletOutputStream.flush(); servletOutputStream.close(); } catch (JRException e) { StringWriter stringWriter = new StringWriter(); PrintWriter printWriter = new PrintWriter(stringWriter); e.printStackTrace(printWriter); response.setContentType("text/plain"); response.getOutputStream().print(stringWriter.toString()); } catch (Exception ex) { System.out.println(ex.getMessage()); } return mapping.getInputForward(); } }

Hello Experts,
I am facing some problem in integration of struts 1.2.9 with EJB 3.0.I am using Netbeans 6.0.I have Deployed & undeployed the EJB module.I have also added the EJB module project as a jar file in my client project.I have already googled this error but didn't find anything useful.Please help.Many Thanks in advance.


This is my stateless bean


package IMS_EJB; import javax.ejb.Stateless; @Stateless public class LoginSessionBean implements LoginSessionLocal { public LoginSessionBean() { } public boolean authenticateUser(String userName, String password) { return true; } }

This is my local interface


package IMS_EJB; import javax.ejb.Local; @Local public interface LoginSessionLocal { public boolean authenticateUser(String userName, String password); }


This is my client(Struts's Action class)

package com.myapp.struts; import org.apache.struts.action.*; import javax.servlet.*; import javax.servlet.http.*; import java.io.*; import java.sql.*; import javax.ejb.EJB; import IMS_EJB.LoginSessionLocal; public class LoginAction extends Action { @EJB private LoginSessionLocal loginSessionLocal; public LoginAction() { } public ActionForward execute( ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { LoginForm loginform = (LoginForm)form; try { boolean temp = loginSessionLocal. authenticateUser(loginform.getUsername(),loginform.getPassword()); if(temp == true) { HttpSession session = request.getSession(); session.setAttribute("USER", loginform.getUsername()); return mapping.findForward("success"); } else { return mapping.findForward("failure"); } } catch(SQLException e) { System.out.println("error" + e.getMessage()); return mapping.findForward("failure"); } } }

This is the error I am getting
Deploying application in domain failed; Error loading deployment descriptors for module [IMS_1] -- Cannot resolve reference Unresolved Ejb-Ref com.myapp.struts.LoginAction/loginSessionLocal@jndi: @null@IMS_EJB.LoginSessionLocal@Session@null
Deployment error:
The module has not been deployed.
See the server log for details.
at org.netbeans.modules.j2ee.deployment.devmodules.api.Deployment.deploy(Deployment.java:163)
at org.netbeans.modules.j2ee.ant.Deploy.execute(Deploy.java:104)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
at sun.reflect.GeneratedMethodAccessor335.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.Target.execute(Target.java:357)
at org.apache.tools.ant.Target.performTasks(Target.java:385)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
at org.apache.tools.ant.Project.executeTarget(Project.java:1298)
at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
at org.apache.tools.ant.Project.executeTargets(Project.java:1181)
at org.apache.tools.ant.module.bridge.impl.BridgeImpl.run(BridgeImpl.java:277)
at org.apache.tools.ant.module.run.TargetExecutor.run(TargetExecutor.java:460)
at org.netbeans.core.execution.RunClassThread.run(RunClassThread.java:151)
Caused by: The module has not been deployed.
at org.netbeans.modules.j2ee.deployment.devmodules.api.Deployment.deploy(Deployment.java:157)
... 16 more

Hello All ,
I am doing one project in that I want to insert checkbox inside table according to the data fetch from database.There will be 3 check boxes in my table on JSP page.There is one field in my table called "Status".
If Status field value is 1 , first check box (Enable ) should get checked.
If Status field value is 2 , first check box (Disable ) should get checked.
If Status field value is 3 , first check box (Deleted ) should get checked.

I am not getting how to do it.I have tried one grid tld.But it is not working.I am new to this language.Please help me.Any sample code or idea of how to do it will be really helpful.Thanks in advance.

Hello all,
I have many dropdowns in my forms like designation , department , state etc.I know how to populate dropdown from database but for some dropdowns I need not maintain tables.I am thinking whether it will be good to populate these dropdowns from XML file.Any suggestions if it is a good idea & how to do it.Any help will be highly appreciated.Thanks in advance.

Thanks a lot Mohan.I got solution.My JSTL was not configured properly.So now I am closing this post.Thanks to all who have helped me by replying.

Thanks Ben for replying.As I told you that I am very new to this technology.I was going through different articles & forums on net.I found that people have talked about passing an arraylist from action class & printing that arraylist in jsp using JSTL.I don't know the Struts way of doing it.Please explain it by giving some example that will be really helpful.

Hello all ,
I am facing a problem in printing the arraylist in JSP using JSTL.Please help as I am new to this technology.

code in action class
request.setAttribute("org_list", resultlist);

where resultlist is my arraylist. I am getting value in action class.I have checked by printing it.

code in JSP
<c:forEach var="org" begin="0" items="${org_list}"> <html:option value="1" > <c:out value="${org}" /> </html:option> </c:forEach>

In jsp I am getting the DropDown as empty.Now values are coming.Can anyone tell what is wrong?Thanks a ton in advance.