Hello Mr.Stefano,
I logged into Jetspeed as "Admin" only ..but i am not able to find it.I am not sure
whether its related to security or datbase problem?.Can you please tell me ..what to
do to solve this problem?.
Thank you,
Maruthi.
Stefano Bianchi <[EMAIL PROTECTED]> wrote:
Are you sure is a problem related to database?
Could it be the security for the portlet is set to Admin only so that when you access
as anon user you don't see it?
Stefano
----- Original Message -----
From: Maruthi
To: [EMAIL PROTECTED]
Sent: Monday, June 21, 2004 3:52 PM
Subject: Not able to find JSP Portlet ...Problem with mysql database
Hello all,
I read somewhere in the mailing list as Torque will not support
"com.mysql.jdbc.Driver" ..is it true?.Now i am trying to connect mysql from JSP
Portlet by using "org.gjt.mm.mysql.Driver" then i could log-in into jetspeed but in
the cutomization pane when i pressed the button "Add Portlet" to add my JSP portlet
..and i selected my JSP Portlet and pressed apply button then i can see my JSP Portlet
in the Customization pane and then i pressed save and apply button then i am not able
to find my portlet in the front page (in the home page) as all other portlets are
displyaing as it is.What could be the problem for this ?.
I have MYSQL 3.51 Driver,mysql-connector-java-3.0.14-production drivers in my machine
to connect JDBC to mySQL.My DSN name is ravuri....and my
Database Name is "Thesiswork".I populated the SQL scripts in the source.
Please see the attachment for my configuration. Please help me in this regard ..as i
am trying to solve this problem since last friday.
Thanks in advance,
Regards,
Maruthi.
------------------------------------------------------------------------------
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
------------------------------------------------------------------------------
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fswiss\fcharset0
Arial;}{\f1\fnil Courier New;}{\f2\fnil\fcharset0 Courier New;}}
{\colortbl ;\red255\green255\blue255;}
{\*\generator Msftedit 5.41.21.2500;}\viewkind4\uc1\pard\f0\fs20
********************************************************************************************************************************************************************************************************\par
\b RegistrationJSPAction.java ....... I kept the .class file in
C:\\jakarta-tomcat-5.0.25\\webapps\\jetspeed\\WEB-INF\\classes\\org\\apache\\jetspeed\\modules\\actions\par
\b0\par
*********************************************************************************************************************************************************************************************************\par
\par
\par
\tab // Java Resources\par
\par
\tab import java.util.*;\par
\tab import java.sql.*;\par
\tab\par
\tab // Jetspeed Resources\par
\tab\par
\tab import org.apache.jetspeed.modules.actions.portlets.JspPortletAction;\par
\tab import org.apache.jetspeed.portal.Portlet;\par
\tab\par
\tab // Turbine Resources\par
\tab import org.apache.turbine.util.RunData;\par
\tab import org.apache.turbine.util.Log;\par
\tab\par
\tab public class RegistrationJSPAction extends JspPortletAction\par
\tab\{\par
\tab\par
\tab\tab\par
\tab /**************\par
\tab * Build the normal state content for this portlet.\par
\tab * @param portlet The jsp-based portlet that is being built.\par
\tab * @param rundata The turbine rundata context for this request.\par
\tab **************/\par
\tab\par
\tab\tab protected void buildNormalContext(Portlet portlet, RunData rundata)\par
\tab\tab\{\par
\tab\tab\tab\par
\tab\tab\}\par
\tab\tab\par
\tab\tab public void doUpdate(RunData rundata,Portlet portlet)\par
\tab\tab\{\par
\tab\tab Hashtable args = new Hashtable();\par
\tab\tab try\par
\tab\tab \{\par
\tab\tab \tab\tab // String address = rundata.getParameters().getString("address");\par
\tab\tab\tab \par
\tab \tab\par
\tab\tab\tab\tab String userid=\tab\tab
rundata.getParameters().getString("userid");\par
\tab\tab\tab String password=\tab rundata.getParameters().getString("password");\par
\tab\tab\tab String fname=\tab\tab rundata.getParameters().getString("fname");\par
\tab\tab\tab String lname=\tab\tab rundata.getParameters().getString("lname");\par
\tab\tab\tab String email=\tab\tab rundata.getParameters().getString("email");\par
\tab\tab\tab String dob=\tab\tab rundata.getParameters().getString("dob");\par
\tab\tab\tab String sex=\tab\tab rundata.getParameters().getString("sex");\par
\tab\tab\tab String education=\tab rundata.getParameters().getString("education");\par
\tab\tab\tab String telhome=\tab rundata.getParameters().getString("th");\par
\tab\tab\tab String telmob=\tab\tab rundata.getParameters().getString("tm");\par
\tab\tab\tab String street=\tab\tab
rundata.getParameters().getString("streetnhno");\par
\tab\tab\tab String city=\tab\tab rundata.getParameters().getString("city");\par
\tab\tab\tab String zip= \tab\tab rundata.getParameters().getString("zip");\par
\tab\tab\tab String country=\tab rundata.getParameters().getString("country"); \par
\tab\tab\tab \tab\par
\tab\tab\tab \par
\tab\tab\tab \par
\tab\tab\tab // Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");\par
\tab\tab\tab // Connection con = DriverManager.getConnection("Jdbc:odbc:ravuri");\par
\tab\tab\tab // Class.forName("com.mysql.jdbc.Driver");\par
\tab\tab\tab Class.forName("org.gjt.mm.mysql.Driver");\par
\tab\tab\tab Connection
con=DriverManager.getConnection("Jdbc:mysql://localhost:3306/Thesiswork","root","");\par
\tab\tab\tab Statement st=con.createStatement();\par
\tab\tab\tab String str="INSERT into registration
VALUES('"+userid+"','"+password+"','"+fname+"','"+lname+"','"+dob+"','"+education+"','"+sex+"','"+email+"',"+telhome+","+telmob+",'"+street+"','"+city+"',"+zip+",'"+country+"')";\par
\tab\tab\tab int i=st.executeUpdate(str);\par
\tab\tab\tab System.out.println("Number of Rows inserted:" +i+"
"); \par
\tab\tab \tab \tab\par
\tab\tab\tab // rundata.getRequest().setAttribute("address",address);\par
\tab\tab\tab \par
\tab\tab\tab st.close();\par
\tab\tab\tab con.close();\par
\tab\tab \}\par
\tab\tab catch(Exception e)\par
\tab\tab \{\par
\tab\tab \par
\tab\tab \tab\tab Log.error(e);\par
\tab\tab \par
\tab\tab \}//catch()\par
\tab\tab \par
\tab\tab\}//doUpdate\par
\tab\tab\par
\tab\}// class\par
\tab\par
\tab\par
****************************************************************************************************************************************************************************************\par
\b\tab RegistrationJSPAction.jsp ................... I kept the JSP in
C:\\jakarta-tomcat-5.0.25\\webapps\\jetspeed\\WEB-INF\\templates\\jsp\\portlets\\html\b0\par
****************************************************************************************************************************************************************************************\par
\par
\highlight1\f1\tab \highlight1 \tab language="java"
contentType="text/html"\highlight0\par
\highlight1 import = "java.io.*"\highlight0\par
\highlight1 import = "java.lang.*"\highlight0\par
\highlight1 import = "java.sql.*"\highlight0\par
\highlight1\tab %>\highlight0\par
\highlight1\tab\highlight0\par
\highlight1\tab \highlight0\par
\highlight1\tab \highlight0\par
\highlight1\tab \highlight0\par
\highlight1\tab\highlight0\par
\highlight1\tab\highlight0\par
\highlight1\tab\highlight0\par
\highlight1\tab \tab\tab\highlight0\par
\highlight1\tab \highlight0\par
\highlight1\tab \highlight0\par
\highlight1\tab \highlight0\par
\highlight1\tab \highlight0\par
\highlight1\tab\tab\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab
\highlight0\par
\highlight1\tab\tab\tab REGISTRATION FORM\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab
\highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab User-ID:\highlight0\par
\highlight1\tab\tab\tab [input] \highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab Password:\highlight0\par
\highlight1\tab\tab\tab [input] \highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab Re-Enter Password:\highlight0\par
\highlight1\tab\tab\tab [input] \highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab First Name:\highlight0\par
\highlight1\tab\tab\tab [input] \highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab Last Name:\highlight0\par
\highlight1\tab\tab\tab [input] \highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab E-Mail:\highlight0\par
\highlight1\tab\tab\tab [input] \highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab Date Of Birth (DD/MM/YY):\highlight0\par
\highlight1\tab\tab\tab [input] \highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab Sex:\highlight0\par
\highlight1\tab\tab\tab Male: [input] Female: [input] \highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab Education:\highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab \highlight0\par \highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab A&R(ET & IT)\highlight0\par
\highlight1\tab\tab\tabCE.\highlight0\par \highlight1\tab\tab\tabEE&IT\highlight0\par
\highlight1\tab\tab\tabME\highlight0\par \highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab Telephone Home:\highlight0\par
\highlight1\tab\tab\tab [input] \highlight0\par
\highlight1\tab\tab\tab \tab \highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab Telephone Mobile:\highlight0\par
\highlight1\tab\tab\tab [input] \highlight0\par
\highlight1\tab\tab\tab \tab\tab \highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab Street&H.NO:\highlight0\par
\highlight1\tab\tab\tab [input] \highlight0\par
\highlight1\tab\tab\tab \tab \highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab City:\highlight0\par
\highlight1\tab\tab\tab [input] \highlight0\par
\highlight1\tab\tab\tab \tab\tab \highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab ZIP :\highlight0\par
\highlight1\tab\tab\tab [input] \highlight0\par
\highlight1\tab\tab\tab \tab \highlight0\par
\highlight1\tab\tab\tab \tab \highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab Country:\highlight0\par
\highlight1\tab\tab\tab [input] \highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab \tab\tab\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab " method=post>\highlight0\par
\highlight1\tab\tab\tab [input] " name=js_peid>\highlight0\par
\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab [input] \highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\highlight0\par
\highlight1\tab\tab \highlight1\tab\tab try\tab\highlight0\par
\highlight1\tab\tab\{\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab // rundata contains seseeion data and data from Action
Class::\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab RunData
rundata=(RunData)request.getAttribute("rundata");\highlight0\par
\highlight1\tab\tab\tab String jspeid = (String)
request.getAttribute("js_peid");\highlight0\par
\highlight1\tab\tab\tab final String userid =
rundata.getUser().getUserName();\highlight0\par
\highlight1\tab\tab\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab \highlight1\tab\tab\tab\tab String address = (String)
request.getAttribute("address"); ??\highlight0\par
\highlight1\tab\tab\tab\tab\tab\tab\tab\tab\tab\tab\tab\tab\tab\tab\tab\tab\tab\tab
??\tab\highlight0\par
\highlight1\tab\tab\tab\tab ??\highlight0\par
\highlight1\tab\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab -->\highlight0\par
\highlight1\tab\tab\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab String
userid=(String)request.getAttribute("userid");\highlight0\par
\highlight1\tab\tab String
password=(String)request.getAttribute("password");\highlight0\par
\highlight1\tab\tab String fname=(String)request.getAttribute("fname");\highlight0\par
\highlight1\tab\tab String lname=(String)request.getAttribute("lname");\highlight0\par
\highlight1\tab\tab String email=(String)request.getAttribute("email");\highlight0\par
\highlight1\tab\tab String dob=(String)request.getAttribute("dob");\highlight0\par
\highlight1\tab\tab String sex=(String)request.getAttribute("sex");\highlight0\par
\highlight1\tab\tab String
education=(String)request.getAttribute("education");\highlight0\par
\highlight1\tab\tab String telhome=(String)request.getAttribute("th");\highlight0\par
\highlight1\tab\tab String telmob=(String)request.getAttribute("tm");\highlight0\par
\highlight1\tab\tab String
street=(String)request.getAttribute("streetnhno");\highlight0\par
\highlight1\tab\tab String city=(String)request.getAttribute("city");\highlight0\par
\highlight1\tab\tab String zip=(String)request.getAttribute("zip");\highlight0\par
\highlight1\tab\tab String country=(String)request.getAttribute("country");
\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\}\tab\highlight0\par
\highlight1\tab catch(Exception ex)\highlight0\par
\highlight1 \tab\{\highlight0\par
\highlight1\tab AppObjects.log("Error:error in RegistrationJSPTemplate.jsp
page",ex);\highlight0\par
\highlight1\tab return;\highlight0\par
\highlight1 \tab\}\highlight0\par
\highlight1 \highlight0\par
\highlight1 %>\highlight0\par
\highlight1 \highlight0\par
\highlight1 \par
\par
\par
\highlight0\f0
**********************************************************************************************************************************************************************************\par
\b\tab RegistrationJSPAction.xreg under
----C:\\jakarta-tomcat-5.0.25\\webapps\\jetspeed\\WEB-INF\\conf\b0\par
**********************************************************************************************************************************************************************************\par
\highlight1\f1\par
\par
\par
\par
\par
\par
\par
\tab \par
\par
\tab\tab \par
=== message truncated ===
---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
