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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
