Ravi Venkar Vaithianathan

Greenhorn

+ Follow

6 Posts 2 Threads 0 Cows

since Sep 20, 2007

Merit badge: grant badges

For More

Cows and Likes

Cows

Total received

In last 30 days

Total given

Likes

Total received

Received in last 30 days

Total given

Given in last 30 days

Forums and Threads

Scavenger Hunt

Ranch Hand Scavenger Hunt

Greenhorn Scavenger Hunt

Recent posts by Ravi Venkar Vaithianathan

How to split a Array value

Hi All,
I have this piece of code where I am getting the database values in a string array by delimeter ",", then trying to split and store in data base
Code is as follows,
----------------------------------------------------------------------------

<%@ page language="java" import="java.sql.*"%>
<%@ page language="java" import="java.util.*"%>
<html>
<head><title>Business Process Addition</title>
</head>
<body>
<form action="BPAdd.jsp">
<Input Type="Text" Name="BpName">
<p align="center"><b>Following are Records of Activities for Business PRocess.</b><br> </p>
<div align="center" width="85%">
<center>
<table border="1" borderColor="#ffe9bf" cellPadding="0" cellSpacing="0" width="658" height="63">
<tbody>
<td bgColor="#008080" width="47" align="center" height="19"><font color="#ffffff"><b>Sr.
No.</b></font></td>
<td bgColor="#008080" width="107" height="19"><font color="#ffffff"><b>Activityr ID</b></font></td>
<td bgColor="#008080" width="224" height="19"><font color="#ffffff"><b>Activity Name</b></font></td>
<td bgColor="#008080" width="270" height="19"><font color="#ffffff"><b>Activity Descriptions</b></font></td>
<td bgColor="#008080" width="270" height="19"><font color="#ffffff"><b>Select Activties to BP</b></font></td>
<%
String DRIVER = "org.gjt.mm.mysql.Driver";
Class.forName(DRIVER).newInstance();
Connection con=null;
ResultSet rst=null;
Statement stmt=null;
try
{
String url="jdbc:mysql://localhost/MyNewDatabase?user=root&password=123456";
int i=1;
con=DriverManager.getConnection(url);
stmt=con.createStatement();
rst=stmt.executeQuery("select * from activity");
while(rst.next()){
if (i==(i/2)*2){
%>
<tr>
<td bgColor="#ffff98" vAlign="top" width="47" align="center" height="19"><%=i%>.</td>
<td bgColor="#ffff98" vAlign="top" width="107" height="19"><%=rst.getString(1)%></td>
<td bgColor="#ffff98" vAlign="top" width="224" height="19"><Input type="hidden"name="rsta"><%=rst.getString(2)%> </td>
<td bgColor="#ffff98" vAlign="top" width="270" height="19"><%=rst.getString(3)%></td>
<td bgColor="#ffff98" vAlign="top" width="270" height="19"><Input Type="Checkbox" Name ="Activity"
value="<%=rst.getString(1)%>, <%=rst.getString(2)%>"></td>
</tr>
<%
}else{
%>
<tr>
<td bgColor="#ffff98" vAlign="top" width="47" align="center" height="19"><%=i%>.</td>
<td bgColor="#ffff98" vAlign="top" width="107" height="19"><%=rst.getString(1)%></td>
<td bgColor="#ffff98" vAlign="top" width="224" height="19"><Input type="hidden" name="rsta"><%=rst.getString(2)%> </td>
<td bgColor="#ffff98" vAlign="top" width="270" height="19"><%=rst.getString(3)%></td>
<td bgColor="#ffff98" vAlign="top" width="270" height="19"><Input Type="Checkbox" Name ="Activity"
value="<%=rst.getString(1)%>, <%=rst.getString(2)%>"></td>
</tr>
<% }
i++;
}
rst.close();
stmt.close();
con.close();
}catch(Exception e){
System.out.println(e.getMessage());
}
%>
</tbody>
</table>
</center>
</div>
</body>
<p>
<a href="AActivityAdd.jsp"> Click to Add Activity</a>
</p
<p>
<a href="BPAdd.jsp"> Click to Add Business Process</a>
</p
<p>
<a href="SysAdminHome.jsp"> Click to System Admin Page</a>
</p
<Input Type="Submit" name="Submit" Value="Submit to Add Business Process">
</form>
<%
String BpName= request.getParameter("BpName");
String[] selected = request.getParameterValues("Activity");
String[] selected1 = request.getParameterValues("rsta");
if (selected != null && selected.length != 0) {
%>
<UL>
<%
for (int i = 0; i < selected.length; i++) {
String sid = selected[i];
String aid = selected1[i];
%>
<%=sid%>
</br>
<% } %>
<UL>
<% } %>
</html>

16 years ago

JSP

Error compiling JSP

Thanks Friends, Got it working but the Drop down is not showing the values but displays as + rs.getString()+ , any help on this.

16 years ago

JSP

Error compiling JSP

Hi, No other information , I have cut & pasted the browser output as it is shown.

16 years ago

JSP

Error compiling JSP

Hi , This is the log from Apache\logs folder.

Sep 20, 2007 4:37:00 PM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet jsp threw exception
org.apache.jasper.JasperException: Unable to compile class for JSP:

Stacktrace:
at org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:85)
at org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
at org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:415)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:308)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:286)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:273)
at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:566)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:308)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:228)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:216)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:634)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:445)
at java.lang.Thread.run(Thread.java:619)

16 years ago

JSP

Error compiling JSP

Hi, Will this help to resolve this, Or should I look some other logs details.Thanks in Advance.

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: Unable to compile class for JSP:

Stacktrace:
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:85)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:415)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:308)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:286)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:273)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:566)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:308)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.10 logs.

--------------------------------------------------------------------------------

Apache Tomcat/6.0.10

16 years ago

JSP

Error compiling JSP

I have this piece of code to retreive from database and display in Drop Down, Used code script from this site but when I compile getting
org.apache.jasper.JasperException: Unable to compile class for JSP:
Tomcat Apache 6.0 / JDK - 1.6 +/ Database: MySql
What is wrong with the code / Any help appreciated
--------------------------------------------------------

[BPSouther: Added a meaningful subject line]
[ September 20, 2007: Message edited by: Ben Souther ]

16 years ago

JSP