Connection Problem

Maruthi Thu, 17 Jun 2004 10:09:59 -0700

Hello Everybody,

I want to connect to JSP portlet to mysql database.......when i deployed i am getting the following error.I am using mysql database and the driver is mysql Odbc 3.51 driver to connect to mysql from Java..My database name is "Thesiswork".

_____________________________________________

Error::

_____________________________________________

17.06.2004 18:26:44 org.apache.torque.util.BasePeer initTableSchema
SCHWERWIEGEND: java.sql.SQLException: [MySQL][ODBC 3.51 Driver][mysqld-4.0.18-max-nt]Table 'thesiswork.turbine_user' doesn't exist
17.06.2004 18:26:44 org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer initClass
SCHWERWIEGEND: A FATAL ERROR has occurred which should not have happened under any circumstance. Please notify the Torque developers <[EMAIL PROTECTED]
che.org> and give as many details as possible (including the error stack trace).
java.lang.Error: Error in BasePeer.initTableSchema(TURBINE_USER): [MySQL][ODBC 3.51 Driver][mysqld-4.0.18-max-nt]Table 'thesiswork.turbine_user' doesn't exist
_______________________________________________________________________

I am attaching my source code,registry file,Property files ....i tried all the options that i know to solve the problem ...but i couldn't.Any help in this regard will be greatly appreciated.

Thanks a lot for your time and patience,

Maruthi.

Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.{\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 \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 \par \par \par \tab\par \tab public class RegistrationJSPAction extends JspPortletAction\par \tab\{\par \tab\par \tab\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 \tab\par \tab\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 Statement st=con.createStatement();\par \tab\tab\tab String str="INSERT into Thesiswork.registration VALUES\tab\tab\tab\tab\tab\tab\tab\tab ('"+userid+"','"+password+"','"+fname+"','"+lname+"','"+dob+"','"+education+"','"+sex+"','"+email+"',"+telhome+","+telmob+",'"+street\tab\tab\tab\tab\tab\tab\tab\tab\tab\tab\tab +"','"+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\par \tab\tab \tab\par \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 \par \par \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\tablanguage="java"contenttype="text/html"\highlight0\par\highlight1import="java.io.*"\highlight0\par\highlight1import="java.lang.*"\highlight0\par\highlight1import="java.sql.*"\highlight0\par\highlight1\tab%>\highlight0\par \highlight1\tab\highlight0\par \highlight1\tab <%@taglib\taburi='/web-inf/templates/jsp/tld/template.tld'prefix='jetspeed'%>\highlight0\par \highlight1\tab <%@page\tabimport="org.apache.turbine.util.rundata"%> \highlight0\par \highlight1\tab <%@page\tabimport="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 <fontface=verdana,geneva,arialcolor=#fffafasize=1>\highlight0\par \highlight1\tab\tab\tab <br><br>\highlight0\par \highlight1\tab\tab\tab <h3align="center"><fontcolor=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

\highlight0\par \highlight1\tab\tab\tab <tablebgcolor=#cdc673align="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><inputtype="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><inputtype="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><inputtype="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><inputtype="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><inputtype="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><inputtype="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><inputtype="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:<inputtype="radio"name="sex"value="male"checked> Female:<inputtype="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 <selectname="education">\highlight0\par \highlight1\tab\tab\tab\highlight0\par \highlight1\tab\tab\tab <optionvalue="ar"> A&R(ET & IT)\highlight0\par \highlight1\tab\tab\tab <optionvalue="ce">CE.\highlight0\par \highlight1\tab\tab\tab <optionvalue="eeit">EE&IT\highlight0\par \highlight1\tab\tab\tab <optionvalue="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><inputtype="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><inputtype="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><inputtype="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><inputtype="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><inputtype="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><inputtype="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

\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***********************thematterstartsfromhere*********************-->\highlight0\par \highlight1\tab\tab\tab\highlight0\par \highlight1\tab\tab\tab <!\emdashactionurlisprovidedbythetaglibsofjetspeed-->\tab\tab\highlight0\par \highlight1\tab\tab\tab\highlight0\par \highlight1\tab\tab\tab <formname="registrationjspfrm"method="post"action="\highlight0\par \highlight1\tab\tab\tab <inputtype="hidden"name="js_peid"value="<%=jspeid%>">\highlight0\par \par \highlight1\tab\tab\tab <!\emdashsubmitbuttonnamemuststartwith"eventsubmit_"-->\highlight0\par \highlight1\tab\tab\tab\highlight0\par \highlight1\tab\tab\tab <inputtype="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\tabtry\tab\highlight0\par\highlight1\tab\tab\{\highlight0\par\highlight1\tab\tab\tab\highlight0\par\highlight1\tab\tab\tab//rundatacontainsseseeiondataanddatafromactionclass::\highlight0\par\highlight1\tab\tab\tab\highlight0\par\highlight1\tab\tab\tabrundatarundata=(rundata)request.getattribute("rundata");\highlight0\par\highlight1\tab\tab\tabstringjspeid=(string)request.getattribute("js_peid");\highlight0\par\highlight1\tab\tab\tabfinalstringuserid=rundata.getuser().getusername();\highlight0\par\highlight1\tab\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 <?xmlversion="1.0"encoding="utf-8"?>\par <registry>\par <portlet-entryname="registrationjsptemplateandaction"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 <parametername="template"value="registrationjsptemplate.jsp"hidden="true"cachedonname="true"cachedonvalue="true"/>\par <parametername="action"value="org\\apache\\jetspeed\\modules\\actions\\portlets\\registrationjspaction"hidden="true"cachedonname="true"cachedonvalue="true"/>\par \par <media-typeref="html"/>\par <urlcachedonurl="true"/>\par \par <categorygroup="jetspeed">demo</category>\par <categorygroup="jetspeed">jsp.demo</category>\par \par </portlet-entry>\par \par </registry>\par \par \par \par \par \par \par \par \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 \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 \tab 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 = sun.jdbc.odbc.JdbcOdbcDriver\par torque.dsfactory.default.connection.url = Jdbc:odbc:ravuri\par torque.dsfactory.default.connection.user =\par torque.dsfactory.default.connection.password = \par \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 \f0 **************************************************************************\par \b\tab Project.Properties in C:\\jetspeed-1.5-src\b0\par *************************************************************************\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 \par database = mysql\par \par #targetPackage = org.apache.jetspeed.om.torque\par torque.retrievableInterface = org.apache.fulcrum.intake.Retrievable\par \par torque.database.url = sun.jdbc.odbc.JdbcOdbcDriver\par torque.database.driver = Jdbc:odbc:ravuri\par torque.database.user = \par torque.database.password =\par \par **************************************************\par \b Error Messages when Deployed ::\b0\par *************************************************\par \par \f0 17.06.2004 18:26:44 org.apache.torque.util.BasePeer initTableSchema\par SCHWERWIEGEND: java.sql.SQLException: [MySQL][ODBC 3.51 Driver][mysqld-4.0.18-max-nt]Table 'thesiswork.turbine_user' doesn't exist\par 17.06.2004 18:26:44 org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer initClass\par SCHWERWIEGEND: A FATAL ERROR has occurred which should not have happened under any circumstance. Please notify the Torque developers <[emailprotected]che.org> and give as many details as possible (including the error stack trace).\par java.lang.Error: Error in BasePeer.initTableSchema(TURBINE_USER): [MySQL][ODBC 3.51 Driver][mysqld-4.0.18-max-nt]Table 'thesiswork.turbine_user' doesn't exist\par at org.apache.torque.util.BasePeer.initTableSchema(BasePeer.java:274)\par at org.apache.torque.util.BasePeer.initTableSchema(BasePeer.java:249)\par at org.apache.jetspeed.om.security.turbine.TurbineUserPeer.<clinit>(TurbineUserPeer.java:49)\par at org.apache.jetspeed.om.security.turbine.BaseTurbineUser.<clinit>(BaseTurbineUser.java:36)\par at java.lang.Class.forName0(Native Method)\par at java.lang.Class.forName(Class.java:141)\par at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.initClass(BaseTurbineUserPeer.java:141)\par at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.<clinit>(BaseTurbineUserPeer.java:128)\par at org.apache.jetspeed.services.security.turbine.TurbineUserManagement.getUser(TurbineUserManagement.java:136)\par at org.apache.jetspeed.services.JetspeedUserManagement.getUser(JetspeedUserManagement.java:59)\par at org.apache.jetspeed.services.security.turbine.TurbineAuthentication.getAnonymousUser(TurbineAuthentication.java:188)\par at org.apache.jetspeed.services.JetspeedAuthentication.getAnonymousUser(JetspeedAuthentication.java:64)\par at org.apache.jetspeed.services.JetspeedSecurity.getAnonymousUser(JetspeedSecurity.java:134)\par at org.apache.jetspeed.modules.actions.TemplateSessionValidator.doPerform(TemplateSessionValidator.java:59)\par at org.apache.jetspeed.modules.actions.JetspeedSessionValidator.doPerform(JetspeedSessionValidator.java:76)\par at org.apache.turbine.modules.Action.perform(Action.java:87)\par at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)\par at org.apache.turbine.Turbine.doGet(Turbine.java:521)\par at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)\par at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)\par at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)\par at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)\par at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:703)\par at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463)\par at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398)\par at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312)\par at org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:670)\par at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:637)\par at org.apache.jsp.index_jsp._jspService(index_jsp.java:45)\par at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)\par at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)\par at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:298)\par at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)\par at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)\par at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)\par at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)\par at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)\par at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)\par at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)\par at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)\par at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)\par at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)\par at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)\par at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)\par at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)\par at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)\par at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)\par at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)\par at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)\par at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)\par at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)\par at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)\par at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)\par at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)\par at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:793)\par at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:702)\par at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:571)\par at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:644)\par at java.lang.Thread.run(Thread.java:534)\par \f2\par \par \f0\par \par \tab\par }

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

JSP Portlet ->Mysql ->Connection Problem

Reply via email to