You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by Z B <zo...@hotmail.com> on 2005/02/21 19:49:01 UTC
Jetspeed2 and Tomcat5.0 errors...please help!!!
Hello All,
Any help on this is really really appreciated.
This is what I've done so far:
Downloaded from:
1. Ant 1.6.2
http://mirror.poundhost.com/www.apache.org/ant/binaries/apache-ant-1.6.2-bin.zip
2. Jetspeed2
http://www.axint.net/apache/portals/jetspeed-2/jetspeed-2.0-M1.zip
3. Tomcat5.0.28
http://www.mirrorservice.org/sites/ftp.apache.org/jakarta/tomcat-5/v5.0.28/bin/jakarta-tomcat-5.0.28.exe
4. JSDK http://dlc.sun.com/jdk/j2sdk-1_4_2_07-windows-i586-p.exe
Platform:
Windows XP Professional
Database:
Oracle 8i
Database drivers:
classes12.jar and nls_charset12.jar
Enviornment Variables set:
ANT_HOME AND JAVA_HOME
Unzipped Jetspeed2 in C:\Tomcat5.0\webapps directory. Then modified the
jetspeed-database\build.properties file
which looks like the following:
--------------------------------------------------------------------------------------------------
#org.apache.jetspeed.production.database.default.name=hsql
#org.apache.jetspeed.production.database.url =
jdbc:hsqldb:hsql://127.0.0.1:9001
#org.apache.jetspeed.production.database.driver = org.hsqldb.jdbcDriver
#org.apache.jetspeed.production.database.user = sa
#org.apache.jetspeed.production.database.password =
#org.apache.jetspeed.production.jdbc.drivers.path=./jdbc/hsqldb-1.7.1.jar
org.apache.jetspeed.production.database.default.name=oracle
org.apache.jetspeed.production.database.url =
jdbc:oracle:thin:@localhost:1521:MYDB
org.apache.jetspeed.production.database.driver =
oracle.jdbc.driver.OracleDriver
org.apache.jetspeed.production.database.user = j2pdev
org.apache.jetspeed.production.database.password = j2pdev
org.apache.jetspeed.production.jdbc.drivers.path=C:\\Tomcat
5.0\\shared\\lib\\classes12.jar;C:\\Tomcat
5.0\\shared\\lib\\nls_charset12.jar;
org.apache.jetspeed.services.autodeployment.user = admin
org.apache.jetspeed.services.autodeployment.password = admin
--------------------------------------------------------------------------------------------------
My jetspeed.xml file is in C:\Tomcat5.0\conf\Catalina\localhost
directory. It has the following entries
--------------------------------------------------------------------------------------------------
<parameter>
<name>username</name>
<value>j2pdev</value>
</parameter>
<parameter>
<name>password</name>
<value>j2pdev</value>
</parameter>
<!-- Class name for ORACLE JDBC driver -->
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<!-- The JDBC connection url for connecting to your Oracle dB. -->
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@localhost:1521:MYDB</value>
</parameter>
--------------------------------------------------------------------------------------------------
I also copied all the jar files from
C:\Tomcat5.0\webapps\jetspeed\WEB-INF\lib\ to
C:\Tomcat5.0\shared\lib\ directory and also to C:\Tomcat5.0\common\lib
directory.
(Do I need to copy all these jar files in both the places??)
jetspeed.properties file looks like the following..actually havent
changed anything within the file:
--------------------------------------------------------------------------------------------------
autodeployment.catalina.version.major=5
autodeployment.catalina.base=${applicationRoot}/../../
autodeployment.catalina.engine=Catalina
autodeployment.server=localhost
autodeployment.port=8080
autodeployment.user=admin
autodeployment.password=admin
autodeployment.staging.dir=${applicationRoot}/WEB-INF/deploy
autodeployment.target.dir=${applicationRoot}/../
autodeployment.delay=10000
autodeployment.earlyInit = true
--------------------------------------------------------------------------------------------------
I've also run the database scripts for oracle by using ant. It has
created the tables in oracle and looks
ok to me. Do I have to change anything within the tables?
Also changed the autoDeploy value to false in Tomcat's server.xml file.
After doing all these changes, I'm getting the following error when I
try to access Jetspeed page by
http://localhost:8080/jetspeed/
----------------------------------------------------------------------------------------------------
StandardWrapperValve[jsp]: Servlet.service() for servlet jsp threw
exception
org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [] in
task 'OJB operation'; nested
exception is java.sql.SQLException: ORA-00933: SQL command not properly
ended
java.sql.SQLException: ORA-00933: SQL command not properly ended
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:643)
at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1674)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1870)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:314)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java
:92)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:283)
at
org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:74)
at
org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:183)
at
org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.jav
a:1808)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:
1333)
at
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:11
1)
at
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:23
3)
at
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:25
3)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:
1217)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistence
Broker.java:338)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistence
Broker.java:338)
at
org.springframework.orm.ojb.PersistenceBrokerTemplate$2.doInPersistenceBroker(PersistenceBrokerTe
mplate.java:188)
at
org.springframework.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:152)
at
org.springframework.orm.ojb.PersistenceBrokerTemplate.executeFind(PersistenceBrokerTemplate.java:
173)
at
org.springframework.orm.ojb.PersistenceBrokerTemplate.getCollectionByQuery(PersistenceBrokerTempl
ate.java:186)
at
org.apache.jetspeed.capabilities.impl.JetspeedCapabilities.getMediaTypesForMimeTypes(JetspeedCapa
bilities.java:332)
at
org.apache.jetspeed.capabilities.impl.JetspeedCapabilities.getCapabilityMap(JetspeedCapabilities.
java:185)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java
:61)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvo
cation.java:149)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.j
ava:116)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.
java:56)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.j
ava:138)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:152)
at $Proxy6.getCapabilityMap(Unknown Source)
at
org.apache.jetspeed.capabilities.impl.CapabilityValveImpl.invoke(CapabilityValveImpl.java:63)
at
org.apache.jetspeed.pipeline.JetspeedPipeline.invokeNext(JetspeedPipeline.java:209)
at
org.apache.jetspeed.localization.impl.LocalizationValveImpl.invoke(LocalizationValveImpl.java:73)
at
org.apache.jetspeed.pipeline.JetspeedPipeline.invokeNext(JetspeedPipeline.java:209)
at
org.apache.jetspeed.pipeline.JetspeedPipeline.invoke(JetspeedPipeline.java:191)
at
org.apache.jetspeed.engine.AbstractEngine.service(AbstractEngine.java:259)
at
org.apache.jetspeed.engine.JetspeedServlet.doGet(JetspeedServlet.java:225)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:696)
at
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:474)
at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:409)
at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312)
at
org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:691)
at
org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:658)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:45)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.
java:705)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:534)
----------------------------------------------------------------------------------------------------
Also, when I start Tomcat I get the following messages:
----------------------------------------------------------------------------------------------------
JetspeedContainerServlet: Initialization complete for context
Jetspeed-2 Enterpr
ise Portal
log4j:WARN No appenders could be found for logger
(org.apache.catalina.session.M
anagerBase).
log4j:WARN Please initialize the log4j system properly.
----------------------------------------------------------------------------------------------------
It also gives messages like:
----------------------------------------------------------------------------------------------------
INFO: Adding file:/C:/Tomcat
5.0/webapps/jetspeed/../jsf-demo/WEB-INF/classes/
to class path.
INFO: Adding file:/C:/Tomcat
5.0/webapps/jetspeed/../jsf-demo/WEB-INF/lib/commo
ns-beanutils-1.6.1.jar to class path.
INFO: Adding file:/C:/Tomcat
5.0/webapps/jetspeed/../jsf-demo/WEB-INF/lib/commo
ns-codec-1.2.jar to class path.
----------------------------------------------------------------------------------------------------
and stops at INFO: Adding file:/C:/Tomcat
5.0/webapps/jetspeed/../struts-demo/WEB-INF/lib/struts-1.2.1.jar to class
path.
Can someone please tell me where I'm going wrong? I've already spent
one whole day on this. I've tried
searching the forums for the errors, but wasn't very successfull.
I've been following the steps mentioned in the readme.txt file from
http://www.axint.net/apache/portals/jetspeed-2/JETSPEED-2.0-M1-README.txt
Thanks for the help in advance.
Regards,
ZB
P.S.: I'm really new to this and I apologize for the long message.
_________________________________________________________________
Stay in touch with absent friends - get MSN Messenger
http://www.msn.co.uk/messenger
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org