Hello list,
I am new to Jetspeed 2 and I am building it from source (trunk) with maven
1.0.2.
I notised that defaults (in project.properties) use derby so I added hsql
database properties to the build.properties so that I can run it like the
tutorial.
First I start the db but when I do quickstart, I get the following error:
Is there something wrong with the drivers or url or something else?
Please help
[sql] [ERROR] Failed to execute: drop table USER_STATISTICS
[sql] [ERROR] java.sql.SQLException: Table not found: USER_STATISTICS in sta
tement [drop table USER_STATISTICS]
[sql] 0 of 83 SQL statements executed successfully
j2:_db.create:
j2:_process.all.scripts.in.path:
[echo] Checking for SQL scripts at path C:jetspeedsource/target/portal-sql/h
sql/schema...
j2:_db.execute:
[sql] Executing file: C:\jetspeedsource\target\portal-sql\populate-db-defaul
t.sql
[sql] [ERROR] Failed to execute: INSERT INTO CAPABILITY (CAPABILITY_ID, CAPA
BILITY) VALUES(1,'HTML_3_2')
BUILD FAILED
File...... C:\Documents and Settings\Erik.SEVENSTARS\.maven\cache\maven-jetspeed
2-plugin-2.1-dev\plugin.jelly
Element... sql
Line...... 881
Column.... 44
java.sql.SQLException: Table not found in statement [INSERT INTO CAPABILITY]
Total time: 7 seconds
Finished at: Wed Nov 22 15:56:36 CET 2006
C:\jetspeedsource>
build.properties:
# required Jetspeed 2 portal configuration property for building from the source
org.apache.jetspeed.project.home = C:/jetspeedsource
# required portal configuration properties
org.apache.jetspeed.portal.home = C:/jetspeedsource
org.apache.jetspeed.portal.groupId = myprojects
org.apache.jetspeed.portal.artifactId = myportal
org.apache.jetspeed.portal.name = My Test Portal
# org.apache.jetspeed.portal.currentVersion = 1.0
# required application server properties
org.apache.jetspeed.server.home = C:\Tomcat5.5
org.apache.jetspeed.server.shared =
${org.apache.jetspeed.server.home}/shared/lib
org.apache.jetspeed.deploy.war.dir =
${org.apache.jetspeed.server.home}/webapps
org.apache.jetspeed.services.autodeployment.user = j2deployer
org.apache.jetspeed.services.autodeployment.password = xxxxx
org.apache.jetspeed.catalina.version.major = 5.5
org.apache.jetspeed.test.database.url = jdbc:hsqldb:hsql://localhost:9001
org.apache.jetspeed.test.database.driver = org.hsqldb.jdbcDriver
org.apache.jetspeed.test.database.user = sa
org.apache.jetspeed.test.database.password =
org.apache.jetspeed.test.jdbc.drivers.path = C:/Tomcat5.5/shared/lib/hsqldb.jar
org.apache.jetspeed.test.database.default.name=hsql
org.apache.jetspeed.production.database.url = jdbc:hsqldb:hsql://localhost: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 =
C:/Tomcat5.5/shared/lib/hsqldb.jar
org.apache.jetspeed.production.database.default.name=hsql
________________________________
Van: Nikko Gaerlan [mailto:[EMAIL PROTECTED]
Verzonden: wo 22-11-2006 10:52
Aan: Jetspeed Users List
Onderwerp: Re: Moving Jetspeed to another server?
thank you sir..
how can i redeploy my jetspeed to another tomcat?
do i have to recompile jetspeed2 on that server?
then ill just update the sql tables and psml files?
thanks again...
On 11/22/06, David Sean Taylor <[EMAIL PROTECTED]> wrote:
>
> Nikko Gaerlan wrote:
> > hi list
> >
> > is it possible to move the whole jetspeed app to a new server?
> > what are the steps?
> > I backed up the sql tables..
> >
> > how about the psml files of registered users?
> >
> > will jetspeed run if ill only copy all the psml files?
> >
> Be careful not to overwrite your PSML files
> You can place the PSML files outside of your web app
> But yes, of course its possible to move to another server
> Just make sure to get the database connection setup correctly
> With Tomcat, that is done by modifying the JNDI data source in Tomcat's
> configuration directory (jetspeed.xml)
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
