----- Original Message -----
From: "Maruthi" <[EMAIL PROTECTED]>
To: "Jetspeed Users List" <[EMAIL PROTECTED]>
Sent: Monday, June 21, 2004 5:24 PM
Subject: Re: Not able to find JSP Portlet ...Problem with mysql database
> Hello Stijn....The home page i was telling is after logging as "Admin"
only.Here i am pasting my JSP and Action class.
>
> Thanks for your patience.
> Maruthi.
>
> =========================================
> JSP:: RegistrationJSPTemplate.jsp
> =========================================
> <%@ page
> language="java" contentType="text/html"
> import = "java.io.*"
> import = "java.lang.*"
> import = "java.sql.*"
> %>
>
> <%@ taglib uri='/WEB-INF/templates/jsp/tld/template.tld'
prefix='jetspeed' %>
> <%@ page import = "org.apache.turbine.util.RunData" %>
> <%@ page import = "org.apache.turbine.util.Log" %>
>
>
>
> <HTML>
> <HEAD>
Tip: Don't render the head of the document, Jetspeed already does that,
you'll end up with two...
> <TITLE>JSP REGISTRATION FORM</TITLE>
> </HEAD>
> <BODY>
>
> <FONT face=Verdana,Geneva,Arial color=#FFFAFA size=1>
> <br><br>
> <h3 align="center"><font color=black><b>REGISTRATION
FORM</b></font></h3>
>
>
> <br><br>
> <center>
> <table bgcolor=#CDC673 align="center">
>
> <tr>
> <td><b>User-ID:<b></td>
> <td><input type="text" name="userid" value="" size="20"></td>
> </tr>
>
> <tr>
> <td>Password:</td>
> <td><input type="password" name="password" size="20"></td>
> </tr>
>
> <tr>
> <td>Re-Enter Password:</td>
> <td><input type="password" name="rpassword" size="20"></td>
> </tr>
>
>
> <tr>
> <td>First Name:</td>
> <td><input type="text" name="fname" value="" size="20"
align='right'></td>
> </tr>
>
> <tr>
> <td>Last Name:</td>
> <td><input type="text" name="lname" value="" size="20"
/></td>
> </tr>
>
>
> <tr>
> <td>E-Mail:</td>
> <td><input type="text" name="email" value="" size="20"></td>
>
> </tr>
>
>
> <tr>
> <td>Date Of Birth (DD/MM/YY):</td>
> <td><input type="text" name="dob" value="" size="20"></td>
> </tr>
> <tr>
> <td>Sex:</td>
> <td >Male:<input type="radio" name="sex" value="Male"
checked> Female:<input type="radio" name="sex" value="Female"></td>
> </tr>
> <tr>
>
> <td>Education:</td>
>
> <td>
> <select name="education">
>
> <option value="ar"> A&R(ET & IT)
> <option value="ce">CE.
> <option value="eeit">EE&IT
> <option value="me">ME
> </select>
> </td>
> </tr>
> <tr>
> <td>Telephone Home:</td>
> <td><input type="text" name="th" value="" size="20">
> </td>
> </tr>
>
> <tr>
> <td>Telephone Mobile:</td>
> <td><input type="text" name="tm" value="" size="20">
> </td>
> </tr>
>
> <tr>
> <td>Street&H.NO:</td>
> <td><input type="text" name="streetnhno" value=""
size="20">
> </td>
> </tr>
>
> <tr>
> <td>City:</td>
> <td><input type="text" name="city" value="" size="20">
> </td>
> </tr>
>
> <tr>
> <td>ZIP :</td>
> <td><input type="text" name="zip" value="" size="20">
> </td>
>
> </tr>
>
>
> <tr>
> <td>Country:</td>
> <td><input type="text" name="country" value=""
size="20"></td>
> </tr>
>
> </table>
> </center>
> </font>
>
>
> <!- ***********************The Matter Starts from here
********************* -->
>
> <!-action URL is provided by the taglibs of Jetspeed -->
>
> <FORM NAME="RegistrationJSPFRM" METHOD="POST"
action="<jetspeed:dynamicUri/>">
> <INPUT TYPE="hidden" NAME="js_peid" VALUE="<%=jspeid%>">
> <!-Submit button name must start with "eventSubmit_" -->
>
> <INPUT TYPE="SUBMIT" NAME="eventSubmit_doUpdate" value="SUBMIT" />
>
>
> </FORM>
> </body>
>
>
> <%
> try
> {
>
> // rundata contains seseeion data and data from Action Class::
>
> RunData rundata=(RunData)request.getAttribute("rundata");
> String jspeid = (String) request.getAttribute("js_peid");
> final String userid = rundata.getUser().getUserName();
>
> <!-
> String address = (String) request.getAttribute("address"); ??
> ??
> <textarea name="address"><%= address %></textarea> ??
>
> -->
>
> String userid=(String)request.getAttribute("userid");
> String password=(String)request.getAttribute("password");
> String fname=(String)request.getAttribute("fname");
> String lname=(String)request.getAttribute("lname");
> String email=(String)request.getAttribute("email");
> String dob=(String)request.getAttribute("dob");
> String sex=(String)request.getAttribute("sex");
> String education=(String)request.getAttribute("education");
> String telhome=(String)request.getAttribute("th");
> String telmob=(String)request.getAttribute("tm");
> String street=(String)request.getAttribute("streetnhno");
> String city=(String)request.getAttribute("city");
> String zip=(String)request.getAttribute("zip");
> String country=(String)request.getAttribute("country");
>
> }
> catch(Exception ex)
> {
> AppObjects.log("Error:error in RegistrationJSPTemplate.jsp
page",ex);
> return;
> }
>
> %>
>
> </html>
>
This all looks ok on first glance...
> ========================================
> Action Class ::RegistrationJSPAction.java
> ========================================
>
> // Java Resources
> import java.util.*;
> import java.sql.*;
>
> // Jetspeed Resources
>
> import org.apache.jetspeed.modules.actions.portlets.JspPortletAction;
> import org.apache.jetspeed.portal.Portlet;
>
Put here:
import org.apache.jetspeed.services.logging.JetspeedLogFactoryService;
import org.apache.jetspeed.services.logging.JetspeedLogger;
> // Turbine Resources
> import org.apache.turbine.util.RunData;
> import org.apache.turbine.util.Log;
>
>
>
> public class RegistrationJSPAction extends JspPortletAction
> {
Put here:
private static final JetspeedLogger logger = JetspeedLogFactoryService.
getLogger(RegistrationJSPAction.class.getName());
// Default constructor. Creates a RegistrationJspAction.
public RegistrationJspAction()
{
// Call superclass' constructor and log a message
super();
logger.info("Created a RegistrationJspAction.");
}
> /**************
> * Build the normal state content for this portlet.
> * @param portlet The jsp-based portlet that is being built.
> * @param rundata The turbine rundata context for this request.
> **************/
>
> protected void buildNormalContext(Portlet portlet, RunData rundata)
> {
put this here:
logger.info("buildNormalContext: Starting...");
// Write code here
logger.info("buildNormalContext: Starting...");
> }
> public void doUpdate(RunData rundata,Portlet portlet)
> {
put this here:
logger.info("doUpdate: Starting...");
> Hashtable args = new Hashtable();
> try
> {
> // String address = rundata.getParameters().getString("address");
>
>
>
> String userid= rundata.getParameters().getString("userid");
> String password= rundata.getParameters().getString("password");
> String fname= rundata.getParameters().getString("fname");
> String lname= rundata.getParameters().getString("lname");
> String email= rundata.getParameters().getString("email");
> String dob= rundata.getParameters().getString("dob");
> String sex= rundata.getParameters().getString("sex");
> String education= rundata.getParameters().getString("education");
> String telhome= rundata.getParameters().getString("th");
> String telmob= rundata.getParameters().getString("tm");
> String street= rundata.getParameters().getString("streetnhno");
> String city= rundata.getParameters().getString("city");
> String zip= rundata.getParameters().getString("zip");
> String country= rundata.getParameters().getString("country");
>
>
>
> // Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> // Connection con =
DriverManager.getConnection("Jdbc:odbc:ravuri");
> // Class.forName("com.mysql.jdbc.Driver");
> Class.forName("org.gjt.mm.mysql.Driver");
> Connection
con=DriverManager.getConnection("Jdbc:mysql://localhost:3306/Thesiswork","ro
ot","");
> Statement st=con.createStatement();
> String str="INSERT into registration
VALUES('"+userid+"','"+password+"','"+fname+"','"+lname+"','"+dob+"','"+educ
ation+"','"+sex+"','"+email+"',"+telhome+","+telmob+",'"+street+"','"+city+"
',"+zip+",'"+country+"')";
> int i=st.executeUpdate(str);
> System.out.println("Number of Rows inserted:" +i+"<br>");
>
> // rundata.getRequest().setAttribute("address",address);
>
> st.close();
> con.close();
> }
> catch(Exception e)
> {
> Log.error(e);
>
> }//catch()
>
> }//doUpdate
>
> } // class
>
> =======================================
> RegistrationJSPAction.xreg
> =======================================
>
>
> <?xml version="1.0" encoding="UTF-8"?>
> <registry>
> <portlet-entry name="Registration JSP Template and Action"
hidden="false" type="ref" parent="JSP" application="false">
> <meta-info>
>
> <title>Registration JSP Template and Action</title>
> <description>Registration JSP Template and
Action</description>
> </meta-info>
> <classname>RegistrationJSPAction</classname>
> <parameter name="template" value="RegistrationJSPTemplate.jsp"
hidden="true" cachedOnName="true" cachedOnValue="true"/>
> <parameter name="action"
value="org\apache\jetspeed\modules\actions\portlets\RegistrationJSPAction"
hidden="true" cachedOnName="true" cachedOnValue="true"/>
This looks a bit strange...But you said you could select your portlet in the
customizer right?
For me this looks more like this:
<parameter name="action" value="portlets.MyAction" />
I don't specify a path for the action. Instead, I regiser my module path
with Turbine in webapp/WEB-INF/TurbineResources.properties. But apparently
this works fine too.
> <media-type ref="html"/>
> <url cachedOnURL="true"/>
> <category group="Jetspeed">demo</category>
<category group="Jetspeed">myPortlets</category>
Make your own category so you can easily find your own portlets...
> <category group="Jetspeed">jsp.demo</category>
> </portlet-entry>
> </registry>
Just some general tips I'm afraid. But if you put in that logging, you can
at least see what's happening.
-Stijn
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
