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+"<br>"); \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 <%@ page \highlight0\par
\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 <%@ taglib \tab uri='/WEB-INF/templates/jsp/tld/template.tld'
prefix='jetspeed' %>\highlight0\par
\highlight1\tab <%@ page \tab import = "org.apache.turbine.util.RunData" %>
\highlight0\par
\highlight1\tab <%@ page \tab import = "org.apache.turbine.util.Log" %>
\highlight0\par
\highlight1\tab\highlight0\par
\highlight1\tab\highlight0\par
\highlight1\tab\highlight0\par
\highlight1\tab <HTML> \tab\tab\highlight0\par
\highlight1\tab <HEAD>\highlight0\par
\highlight1\tab <TITLE>JSP REGISTRATION FORM</TITLE>\highlight0\par
\highlight1\tab </HEAD>\highlight0\par
\highlight1\tab <BODY>\highlight0\par
\highlight1\tab\tab\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab <FONT face=Verdana,Geneva,Arial color=#FFFAFA
size=1>\highlight0\par
\highlight1\tab\tab\tab <br><br>\highlight0\par
\highlight1\tab\tab\tab <h3 align="center"><font color=black><b>REGISTRATION
FORM</b></font></h3>\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab <br><br>\highlight0\par
\highlight1\tab\tab\tab <center>\highlight0\par
\highlight1\tab\tab\tab <table bgcolor=#CDC673 align="center">\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab <tr>\highlight0\par
\highlight1\tab\tab\tab <td><b>User-ID:<b></td>\highlight0\par
\highlight1\tab\tab\tab <td><input type="text" name="userid" value=""
size="20"></td>\highlight0\par
\highlight1\tab\tab\tab </tr>\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab <tr>\highlight0\par
\highlight1\tab\tab\tab <td>Password:</td>\highlight0\par
\highlight1\tab\tab\tab <td><input type="password" name="password"
size="20"></td>\highlight0\par
\highlight1\tab\tab\tab </tr>\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab <tr>\highlight0\par
\highlight1\tab\tab\tab <td>Re-Enter Password:</td>\highlight0\par
\highlight1\tab\tab\tab <td><input type="password" name="rpassword"
size="20"></td>\highlight0\par
\highlight1\tab\tab\tab </tr>\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab <tr>\highlight0\par
\highlight1\tab\tab\tab <td>First Name:</td> \highlight0\par
\highlight1\tab\tab\tab <td><input type="text" name="fname" value=""
size="20" align='right'></td>\highlight0\par
\highlight1\tab\tab\tab </tr>\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab <tr>\highlight0\par
\highlight1\tab\tab\tab <td>Last Name:</td>\highlight0\par
\highlight1\tab\tab\tab <td><input type="text" name="lname" value=""
size="20" /></td>\highlight0\par
\highlight1\tab\tab\tab </tr>\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab <tr>\highlight0\par
\highlight1\tab\tab\tab <td>E-Mail:</td>\highlight0\par
\highlight1\tab\tab\tab <td><input type="text" name="email" value=""
size="20"></td>\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab </tr>\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab <tr>\highlight0\par
\highlight1\tab\tab\tab <td>Date Of Birth (DD/MM/YY):</td>\highlight0\par
\highlight1\tab\tab\tab <td><input type="text" name="dob" value=""
size="20"></td>\highlight0\par
\highlight1\tab\tab\tab </tr>\highlight0\par
\highlight1\tab\tab\tab <tr>\highlight0\par
\highlight1\tab\tab\tab <td>Sex:</td>\highlight0\par
\highlight1\tab\tab\tab <td >Male:<input type="radio" name="sex"
value="Male" checked> Female:<input type="radio" name="sex"
value="Female"></td>\highlight0\par
\highlight1\tab\tab\tab </tr>\highlight0\par
\highlight1\tab\tab\tab <tr>\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab <td>Education:</td>\highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab <td>\highlight0\par
\highlight1\tab\tab\tab <select name="education">\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab <option value="ar"> A&R(ET &
IT)\highlight0\par
\highlight1\tab\tab\tab <option value="ce">CE.\highlight0\par
\highlight1\tab\tab\tab <option value="eeit">EE&IT\highlight0\par
\highlight1\tab\tab\tab <option value="me">ME\highlight0\par
\highlight1\tab\tab\tab </select> \highlight0\par
\highlight1\tab\tab\tab </td>\highlight0\par
\highlight1\tab\tab\tab </tr>\highlight0\par
\highlight1\tab\tab\tab <tr>\highlight0\par
\highlight1\tab\tab\tab <td>Telephone Home:</td>\highlight0\par
\highlight1\tab\tab\tab <td><input type="text" name="th" value=""
size="20">\highlight0\par
\highlight1\tab\tab\tab \tab </td>\highlight0\par
\highlight1\tab\tab\tab </tr>\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab <tr>\highlight0\par
\highlight1\tab\tab\tab <td>Telephone Mobile:</td>\highlight0\par
\highlight1\tab\tab\tab <td><input type="text" name="tm" value=""
size="20">\highlight0\par
\highlight1\tab\tab\tab \tab\tab </td> \highlight0\par
\highlight1\tab\tab\tab </tr>\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab <tr>\highlight0\par
\highlight1\tab\tab\tab <td>Street&H.NO:</td>\highlight0\par
\highlight1\tab\tab\tab <td><input type="text" name="streetnhno"
value="" size="20">\highlight0\par
\highlight1\tab\tab\tab \tab </td>\highlight0\par
\highlight1\tab\tab\tab </tr>\highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab <tr>\highlight0\par
\highlight1\tab\tab\tab <td>City:</td>\highlight0\par
\highlight1\tab\tab\tab <td><input type="text" name="city" value=""
size="20">\highlight0\par
\highlight1\tab\tab\tab \tab\tab </td>\highlight0\par
\highlight1\tab\tab\tab </tr>\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab <tr>\highlight0\par
\highlight1\tab\tab\tab <td>ZIP :</td>\highlight0\par
\highlight1\tab\tab\tab <td><input type="text" name="zip" value=""
size="20">\highlight0\par
\highlight1\tab\tab\tab \tab </td>\highlight0\par
\highlight1\tab\tab\tab \tab \highlight0\par
\highlight1\tab\tab\tab </tr> \highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab <tr>\highlight0\par
\highlight1\tab\tab\tab <td>Country:</td>\highlight0\par
\highlight1\tab\tab\tab <td><input type="text" name="country"
value="" size="20"></td>\highlight0\par
\highlight1\tab\tab\tab </tr>\highlight0\par
\highlight1\tab\highlight0\par
\highlight1\tab\tab\tab </table>\highlight0\par
\highlight1\tab\tab\tab </center> \highlight0\par
\highlight1\tab\tab\tab </font>\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab <!\emdash ***********************The Matter Starts from
here ********************* -->\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab <!\emdash action URL is provided by the taglibs of Jetspeed
-->\tab\tab\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab <FORM NAME="RegistrationJSPFRM" METHOD="POST"
action="<jetspeed:dynamicUri/>">\highlight0\par
\highlight1\tab\tab\tab <INPUT TYPE="hidden" NAME="js_peid"
VALUE="<%=jspeid%>">\highlight0\par
\par
\highlight1\tab\tab\tab <!\emdash Submit button name must start with "eventSubmit_"
-->\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab <INPUT TYPE="SUBMIT" NAME="eventSubmit_doUpdate"
value="SUBMIT" />\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\tab \highlight0\par
\highlight1\tab\tab\tab </FORM>\highlight0\par
\highlight1\tab\tab\tab </body>\highlight0\par
\highlight1\tab\tab\tab\highlight0\par
\highlight1\tab\tab\highlight0\par
\highlight1\tab\tab <%\tab\highlight0\par
\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 <!-\highlight0\par
\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 <textarea name="address"><%= address %></textarea>
??\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 </html>\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
<?xml version="1.0" encoding="UTF-8"?>\par
<registry>\par
<portlet-entry name="Registration JSP Template and Action" hidden="false"
type="ref" parent="JSP" application="false">\par
\tab <meta-info>\par
\par
\tab\tab <title>Registration JSP Template and Action</title>\par
<description>Registration JSP Template and Action</description>\par
\par
</meta-info>\par
\par
<classname>RegistrationJSPAction</classname>\par
\par
<parameter name="template" value="RegistrationJSPTemplate.jsp" hidden="true"
cachedOnName="true" cachedOnValue="true"/>\par
<parameter name="action"
value="org\\apache\\jetspeed\\modules\\actions\\portlets\\RegistrationJSPAction"
hidden="true" cachedOnName="true" cachedOnValue="true"/>\par
\par
<media-type ref="html"/>\par
<url cachedOnURL="true"/>\par
\par
<category group="Jetspeed">demo</category>\par
<category group="Jetspeed">jsp.demo</category>\par
\par
</portlet-entry>\par
\par
</registry>\par
\highlight0\par
\f0\par
************************************************************************************************************************************************************************************************\par
\b\tab Torque.Properties under
C:\\jakarta-tomcat-5.0.25\\webapps\\jetspeed\\WEB-INF\\conf\b0\par
************************************************************************************************************************************************************************************************\par
\par
\f2 # Copyright 2004 The Apache Software Foundation\par
# Licensed under the Apache License, Version 2.0 (the "License");\par
# you may not use this file except in compliance with the License.\par
# You may obtain a copy of the License at\par
# \par
# http://www.apache.org/licenses/LICENSE-2.0\par
# \par
# Unless required by applicable law or agreed to in writing, software\par
# distributed under the License is distributed on an "AS IS" BASIS,\par
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\par
# See the License for the specific language governing permissions and\par
# limitations under the License.\par
\par
# -------------------------------------------------------------------\par
# $Id: Torque.properties,v 1.9 2004/03/17 19:10:26 jford Exp $\par
#\par
# This is the configuration file for Torque.\par
#\par
# Note that strings containing "," (comma) characters must backslash\par
# escape the comma (i.e. '\\,')\par
#\par
# -------------------------------------------------------------------\par
\par
# NOTE NO torque. prefix on properties - this is a kluge to make it also include the
TR.properties\par
\par
torque.applicationRoot = .\par
\par
# -------------------------------------------------------------------\par
#\par
# L O G G I N G\par
#\par
# -------------------------------------------------------------------\par
# We use Log4J for all Torque logging and we embed the log4j\par
# properties within our application configuration.\par
# -------------------------------------------------------------------\par
\par
# THIS SEEMS TO BE IGNORED - HENCE IT IS DUPLICATED IN log4j.properties\par
\par
#log4j.category.org.apache.torque = ALL, org.apache.torque\par
#log4j.appender.org.apache.torque = org.apache.log4j.FileAppender\par
#log4j.appender.org.apache.file = $\{applicationRoot\}/logs/log\par
#log4j.appender.org.apache.layout = org.apache.log4j.PatternLayout\par
#log4j.appender.org.apache.layout.conversionPattern = %d [%t] %-5p %c - %m%n\par
#log4j.appender.org.apache.append = false\par
\par
# -------------------------------------------------------------------\par
#\par
# T O R Q U E P R O P E R T I E S\par
#\par
# -------------------------------------------------------------------\par
# These are your database settings. Look in the\par
# org.apache.pool.* packages for more information.\par
#\par
# The parameters to connect to the default database. You MUST\par
# configure these properly.\par
# -------------------------------------------------------------------\par
\par
\par
torque.database.default=default\par
###torque.database.default.adapter=hypersonic\par
torque.database.default.adapter=mysql\par
### torque.database.default.adapter=oracle\par
### torque.database.default.adapter=mssql\par
\par
##\par
## Using torque's old pool\par
##\par
\par
### torque.dsfactory.default.connection.driver = org.hsqldb.jdbcDriver\par
### torque.dsfactory.default.connection.url =
jdbc:hsqldb:$\{webappRoot\}/WEB-INF/db/jetspeed\par
### torque.dsfactory.default.connection.user = sa \par
### torque.dsfactory.default.connection.password = \par
\par
torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDataSourceFactory\par
# The number of database connections to cache per ConnectionPool instance (specified
per database)\par
torque.dsfactory.default.pool.defaultMaxConnections=10\par
torque.dsfactory.default.pool.maxExpiryTime=3600\par
torque.dsfactory.default.pool.connectionWaitTimeout=10\par
\par
### MySQL\par
\par
torque.dsfactory.default.connection.driver = org.gjt.mm.mysql.Driver\par
torque.dsfactory.default.connection.url =Jdbc:mysql://localhost:3306/Thesiswork\par
torque.dsfactory.default.connection.user =root\par
torque.dsfactory.default.connection.password = \par
\par
### Oracle\par
### torque.dsfactory.default.connection.driver = oracle.jdbc.driver.OracleDriver\par
### torque.dsfactory.default.connection.url =
jdbc:oracle:thin:@nirvana:1521:bluesun3\par
### torque.dsfactory.default.connection.user = jetspeed\par
### torque.dsfactory.default.connection.password = jetspeed\par
\par
### Microsoft SQL\par
### torque.dsfactory.default.connection.driver = net.avenir.jdbc3.Driver\par
### torque.dsfactory.default.connection.url = jdbc:
AvenirDriver://localhost:1433/jetspeed\par
### torque.dsfactory.default.connection.user = jetspeed\par
### torque.dsfactory.default.connection.password = jetspeed\par
### SAP DB\par
### torque.database=sapdb \par
### torque.database.url = jdbc:sapdb:///tst\par
### torque.database.driver=com.sap.dbtech.jdbc.DriverSapDB \par
\par
\par
\par
# The interval (in milliseconds) between which the PoolBrokerService logs\par
# the status of it's ConnectionPools.\par
#\par
# Default: No logging = 0 = 0 * 1000\par
torque.database.logInterval=0\par
\par
\par
# Determines if the quantity column of the IDBroker's id_table should\par
# be increased automatically if requests for ids reaches a high\par
# volume.\par
\par
torque.idbroker.cleverquantity=true\par
\par
# Determines whether the managers cache instances of the business objects.\par
# And also whether the MethodResultCache will really cache results.\par
\par
torque.manager.useCache = true\par
\par
\par
## Using Jdbc2Pool\par
#torque.dsfactory.default.factory=\\\par
# org.apache.torque.dsfactory.Jdbc2PoolDataSourceFactory\par
#torque.dsfactory.default.pool.defaultMaxActive=10\par
#torque.dsfactory.default.pool.testOnBorrow=true\par
#torque.dsfactory.default.pool.validationQuery=SELECT 1\par
#torque.dsfactory.default.connection.driver = org.gjt.mm.mysql.Driver\par
#torque.dsfactory.default.connection.url = jdbc:mysql://localhost:3306/torque\par
#torque.dsfactory.default.connection.user = user\par
#torque.dsfactory.default.connection.password = password\par
\par
\par
## Using jndi\par
#torque.dsfactory.default.factory=org.apache.torque.dsfactory.JndiDataSourceFactory\par
#torque.dsfactory.default.jndi.path=jdbc/Thesiswork\par
#torque.dsfactory.default.jndi.java.naming.factory.initial =
org.apache.naming.java.javaURLContextFactory\par
#torque.dsfactory.default.jndi.java.naming.factory.url.pkgs = org.apache.naming\par
\par
#torque.dsfactory.default.datasource.classname=org.apache.torque.pool.TorqueClassicDataSource\par
#torque.dsfactory.default.datasource.dataSourceName=jdbc/DBdefault\par
#torque.dsfactory.default.datasource.jndiEnvironment.java.naming.factory.initial =
org.apache.naming.java.javaURLContextFactory\par
#torque.dsfactory.default.datasource.jndiEnvironment.java.naming.factory.url.pkgs =
org.apache.naming\par
#torque.dsfactory.default.datasource.defaultMaxConnections=10\par
\par
## ConnectionPoolDataSource\par
#torque.dsfactory.default.factory=org.apache.torque.dsfactory.JndiDataSourceFactory\par
#torque.dsfactory.default.jndi.path=jdbc/DBdefault\par
#torque.dsfactory.default.jndi.java.naming.factory.initial =
org.apache.naming.java.javaURLContextFactory\par
#torque.dsfactory.default.jndi.java.naming.factory.url.pkgs = org.apache.naming\par
#torque.dsfactory.default.datasource.classname=org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS\par
#torque.dsfactory.default.datasource.driver = org.gjt.mm.mysql.Driver\par
#torque.dsfactory.default.datasource.url = jdbc:mysql://localhost:3306/torque\par
#torque.dsfactory.default.datasource.user = user\par
#torque.dsfactory.default.datasource.password = password\par
\par
\par
\f0\par
\par
\f2\par
\f0 **************************************************************************\par
\b\tab Project.Properties in C:\\jetspeed-1.5-src\b0\par
*************************************************************************\par
\f2 # Copyright 2004 The Apache Software Foundation\par
#\par
# Licensed under the Apache License, Version 2.0 (the "License");\par
# you may not use this file except in compliance with the License.\par
# You may obtain a copy of the License at\par
# \par
# http://www.apache.org/licenses/LICENSE-2.0\par
# \par
# Unless required by applicable law or agreed to in writing, software\par
# distributed under the License is distributed on an "AS IS" BASIS,\par
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\par
# See the License for the specific language governing permissions and\par
# limitations under the License.\par
\par
# -------------------------------------------------------------------\par
# P R O J E C T P R O P E R T I E S\par
# -------------------------------------------------------------------\par
\par
#set this in your $\{user.home\}/build.properties rather than here\par
#maven.home = $\{user.home\}/maven\par
\par
#This is needed to make the old build.xml files use the new directories, if called
via maven\par
build.dir = target\par
lib.dir = $\{lib.repo\}\par
\par
compile.debug = on\par
compile.optimize = off\par
compile.deprecation = off\par
\par
src.dir = src\par
\par
\par
announcement = 1.4-b4-dev\par
\par
maven.war.src = $\{basedir\}/webapp\par
\par
maven.compile.fork=yes\par
maven.junit.fork=true\par
\par
# This is a "hack" because POM in maven-1.8 doesn't allow to configure this via
includes\par
maven.jarResources.basedir = $\{basedir\}/src/java\par
\par
maven.repo.remote = http://www.bluesunrise.com/maven/,
http://www.ibiblio.org/maven/\par
\par
# -------------------------------------------------------------------\par
# UI Color Preferences\par
# -------------------------------------------------------------------\par
maven.ui.banner.background = #fff\par
maven.ui.banner.foreground = #fff\par
maven.ui.banner.border.top = #36c\par
maven.ui.banner.border.bottom = #36c\par
\par
# -------------------------------------------------------------------\par
#\par
# Torque Preferences\par
#\par
# -------------------------------------------------------------------\par
\par
schemaDirectory = $\{maven.src.dir\}/torque-schema\par
torque.useClasspath = true\par
torque.basePrefix = Base\par
torque.addSaveMethod = true\par
torque.addGetByNameMethod = true\par
torque.complexObjectModel = true\par
torque.addTimeStamp = true\par
torque.addIntakeRetrievable = false\par
torque.saveException = Exception\par
\par
project = jetspeed\par
\par
# -------------------------------------------------------------------\par
# \par
# T A R G E T D A T A B A S E\par
#\par
# -------------------------------------------------------------------\par
# db2\par
# hypersonic\par
# mysql\par
# oracle\par
# postgresql\par
# mssql\par
# sybase\par
# -------------------------------------------------------------------\par
database = mysql\par
\par
#targetPackage = org.apache.jetspeed.om.torque\par
\par
torque.retrievableInterface=org.apache.fulcrum.intake.Retrievable\par
\par
torque.database.url=Jdbc:mysql://localhost:3306/Thesiswork \par
torque.database.driver=org.gjt.mm.mysql.Driver\par
torque.database.user = root\par
torque.database.password =\par
\par
\par
\par
\par
\par
\par
\f0\par
}
------------------------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]