hi everyone,
I'm trying to set a differnt db eingine (PostgreSQL) and i would like
to know if there are already some docs i can follow to set a third
party db engine?
i have changed the .m2/settings.xml to the following :
- - - - - - - - -
...
<!-- Jetspeed-2 deployment properties -->
<org.apache.jetspeed.server.home>/home/tomcat/www</org.apache.jetspeed.server.home>
<org.apache.jetspeed.catalina.version.major>5.5</org.apache.jetspeed.catalina.version.major>
<org.apache.jetspeed.services.autodeployment.server>localhost</org.apache.jetspeed.services.autodeployment.server>
<org.apache.jetspeed.services.autodeployment.port>8080</org.apache.jetspeed.services.autodeployment.port>
<org.apache.jetspeed.services.autodeployment.user>j2deployer</org.apache.jetspeed.services.autodeployment.user>
<org.apache.jetspeed.services.autodeployment.password>j2deployer</org.apache.jetspeed.services.autodeployment.password>
<!-- postgreslq database properties -->
<org.apache.jetspeed.test.jdbc.drivers.path>/home/tomcat/www/common/lib/postgresql-8.1-407.jdbc3.jar</org.apache.jetspeed.test.jdbc.drivers.path>
<org.apache.jetspeed.test.database.default.name>j2test</org.apache.jetspeed.test.database.default.name>
<org.apache.jetspeed.test.database.url>jdbc:postgresql://localhost:5432/j2test</org.apache.jetspeed.test.database.url>
<org.apache.jetspeed.test.database.driver>org.postgresql.Driver</org.apache.jetspeed.test.database.driver>
<org.apache.jetspeed.test.database.user>dbuser1</org.apache.jetspeed.test.database.user>
<org.apache.jetspeed.test.database.password>dbuser1password</org.apache.jetspeed.test.database.password>
<org.apache.jetspeed.production.jdbc.drivers.path>/home/tomcat/www/common/lib/postgresql-8.1-407.jdbc3.jar</org.apache.jetspeed.production.jdbc.drivers.path>
<org.apache.jetspeed.production.database.default.name>j2</org.apache.jetspeed.production.database.default.name>
<org.apache.jetspeed.production.database.url>jdbc:postgresql://localhost:5432/j2</org.apache.jetspeed.production.database.url>
<org.apache.jetspeed.production.database.driver>org.postgresql.Driver</org.apache.jetspeed.production.database.driver>
<org.apache.jetspeed.production.database.user>dbuser2</org.apache.jetspeed.production.database.user>
<org.apache.jetspeed.production.database.password>dbuser2password</org.apache.jetspeed.production.database.password>
...
- - - - - - - - -
I created both users dbuser1 and dbuser2 and tested both accounts and
they are working so far.
my next step was to try a rebuild :
mvn clean :
[INFO] ------------------------------------------------------------------------
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESSFUL
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 53 seconds
[INFO] Finished at: Tue Oct 31 13:41:26 CET 2006
[INFO] Final Memory: 7M/16M
[INFO] ------------------------------------------------------------------------
[EMAIL PROTECTED]:~/J2$ mvn -P tomcat,dbpsml
which unfortunately ends up with these errors :
[INFO] Scanning for projects...
ยด...
sql-test-database-classpath:
sql-execute-drivers-path:
[sql] Executing file: /home/tomcat/J2/etc/target/sql/j2/drop.sql
[sql] Failed to execute: drop table CLUBS
[sql] org.postgresql.util.PSQLException: ERROR: table "clubs"
does not exist
[sql] Failed to execute: drop table OJB_HL_SEQ
[sql] org.postgresql.util.PSQLException: ERROR: current
transaction is aborted, commands ignored until end of transaction
block
...
[sql] org.postgresql.util.PSQLException: ERROR: current
transaction is aborted, commands ignored until end of transaction
block
[sql] 0 of 83 SQL statements executed successfully
sql-execute-derby:
sql-execute-hsql:
sql-execute:
sql-test-database-classpath:
sql-execute-drivers-path:
[INFO] ------------------------------------------------------------------------
[ERROR] BUILD ERROR
[INFO] ------------------------------------------------------------------------
[INFO] Error executing ant tasks
Embedded error: The following error occurred while executing this line:
/home/tomcat/J2/etc/build.xml:284: The following error occurred while
executing this line:
/home/tomcat/J2/etc/build.xml:340:
/home/tomcat/J2/etc/target/sql/j2/schema not found.
- - - - - - - - -
I'm sure that I'm missing something.
I just don't know where i have to tell maven which schema to use and
assume that's why its not being generated, and not found.
i have been through the docs and could not find anything related to
third party database integration
--
Yassine ELassad
JEE Freelance Developer
Cologne, Germany.
Fon : +49 221 800 8961
Mobile : +49 160 9223 9000
PEACE :
( P ) Positive ( E ) Energy ( A ) Always ( C ) Correct ( E ) Errors.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
