You are viewing a plain text version of this content. The canonical link for it is here.
Posted to graffito-dev@incubator.apache.org by Raj Saini <ra...@gmail.com> on 2006/02/06 08:19:57 UTC
Graffito build
Since last few days I have been trying to build Graffito with no sucess. I
have tried it building with PostgreSQL as well as HSQLDB. I get similar
error for PostgreSQL as well as HSQLDB. I am not sure what could be the
problem. I have deleted my maven plugin cache as well as maven repository
many time just in case the problem was due to some corrupt jar file.
Just wanted to know if someone has built graffito with HSQLDB or PostgreSQL.
I am copying the error as well as contnets of build.properties file. I am
not sure if I am missing any thing in my build.properties file.
===============================Maven error=================================
db.reinit.test:
db.test.properties:
[echo] org.apache.portals.graffito.test.database.default.name : hsql
[echo] org.apache.portals.graffito.test.database.url :
jdbc:hsqldb:hsql://12
7.0.0.1:9001
[echo] org.apache.portals.graffito.test.database.driver :
org.hsqldb.jdbcDri
ver
[echo] org.apache.portals.graffito.test.database.user : sa
[echo] org.apache.portals.graffito.test.database.password :
[echo] org.apache.portals.graffito.test.database.path : C:/Documents and
Set
tings/RajbirS/.maven/repository/hsqldb/jars/hsqldb-1.8.2.jar
[echo] org.apache.portals.graffito.test.jetspeed : true
db.scripts.gen:
torque:init:
[echo] Generating SQL schema creation scripts for hsql
[torque-sql] Using classpath
[torque-sql] Generating to file
C:\Projects\graffito\components\target\src\s
ql\hsql\report.components.sql.generation
BUILD FAILED
File...... C:\Projects\graffito\maven.xml
Element... maven:reactor
Line...... 88
Column.... 40
Unable to obtain goal [test:test] --
C:\Projects\graffito\components\maven.xml:1
70:28: <torque-sql> Exception thrown by 'generator.parse'. For more
information
consult the velocity log, or invoke ant with the -debug flag.
Total time: 48 seconds
Finished at: Mon Feb 06 13:40:07 GMT+05:30 2006
==============================================
velocity.log======================================================
2006-02-06 13:40:07,243 - Velocimacro : initialization starting.
2006-02-06 13:40:07,243 - Velocimacro : adding VMs from VM library template
: VM_global_library.vm
2006-02-06 13:40:07,243 - ResourceManager : unable to find resource
'VM_global_library.vm' in any resource loader.
2006-02-06 13:40:07,243 - Velocimacro : error using VM library template
VM_global_library.vm :
org.apache.velocity.exception.ResourceNotFoundException: Unable to find
resource 'VM_global_library.vm'
2006-02-06 13:40:07,243 - Velocimacro : VM library template macro
registration complete.
2006-02-06 13:40:07,243 - Velocimacro : allowInline = true : VMs can be
defined inline in templates
2006-02-06 13:40:07,243 - Velocimacro : allowInlineToOverride = false : VMs
defined inline may NOT replace previous VM definitions
2006-02-06 13:40:07,243 - Velocimacro : allowInlineLocal = false : VMs
defined inline will be global in scope if allowed.
2006-02-06 13:40:07,243 - Velocimacro : messages on : VM system will output
logging messages
2006-02-06 13:40:07,243 - Velocimacro : autoload off : VM system will not
automatically reload global library macros
2006-02-06 13:40:07,243 - Velocimacro : initialization complete.
2006-02-06 13:40:07,243 - Velocity successfully started.
2006-02-06 13:40:07,624 - ResourceManager : found sql/base/Control.vm with
loader org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader
2006-02-06 13:40:07,640 - ResourceManager : unable to find resource
'sql/base/hsql/table.vm' in any resource loader.
2006-02-06 13:40:07,640 - Method parse threw exception for reference
$generator in template sql/base/Control.vm at [35,7]
===============================================build.propertiesfile===================================================
org.apache.portals.graffito.test.database.default.name=hsql
org.apache.portals.graffito.test.jetspeed=false
org.apache.portals.graffito.test.database.url =
jdbc:hsqldb:hsql://127.0.0.1:9001
org.apache.portals.graffito.test.database.driver = org.hsqldb.jdbcDriver
org.apache.portals.graffito.test.database.user = sa
org.apache.portals.graffito.test.database.password =
org.apache.portals.graffito.test.jdbc.drivers.path=C:/Documents and
Settings/RajbirS/.maven/repository/hsqldb/jars/hsqldb-1.8.2.jar
# configure PRODUCTION DB
org.apache.portals.graffito.production.database.default.name=hsql
org.apache.portals.graffito.production.jetspeed=true
org.apache.portals.graffito.production.database.url =
jdbc:hsqldb:hsql://127.0.0.1:9001
org.apache.portals.graffito.production.database.driver =
org.hsqldb.jdbcDriver
org.apache.portals.graffito.production.database.user = sa
org.apache.portals.graffito.production.database.password =
org.apache.portals.graffito.production.jdbc.drivers.path=C:/Documents and
Settings/RajbirS/.maven/repository/jars/hsqldb/hsqldb-1.8.2.jar
#Configue the Graffito Master OJB Store - USED FOR THE UNIT TESTS
org.apache.portals.graffito.database.ojb.platform=Hsqldb
org.apache.portals.graffito.database.ojb.datasource=java:comp/env/jdbc/graffitotest
# required Jetspeed 2 portal configuration property for building from the
source
org.apache.jetspeed.project.home = C:/Projects/Jetspeed-2
org.apache.jetspeed.portal.home = ${org.apache.jetspeed.project.home}
# required application server properties
org.apache.jetspeed.server.home = C:/Program
Files/Apache/Tomcat 5.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 = admin
org.apache.jetspeed.services.autodeployment.password = admin
org.apache.jetspeed.catalina.version.major = 5.5
# configure Postgresql TEST DB
org.apache.jetspeed.test.database.default.name=postgres
org.apache.portals.graffito.test.jetspeed = true
org.apache.jetspeed.test.database.url = jdbc:postgres://localhost/portal
org.apache.jetspeed.test.database.driver = org.postgresql.Driver
org.apache.jetspeed.test.database.user = portal
org.apache.jetspeed.test.database.password = portal
org.apache.jetspeed.test.jdbc.drivers.path= C:/Program
Files/PostgreSQL/8.1/jdbc/postgresql-8.1-404.jdbc3.jar
# configure Postgresql Production DB
org.apache.jetspeed.production.database.default.name=postgres
org.apache.jetspeed.production.database.url =
jdbc:postgres://localhost/portal
org.apache.jetspeed.production.database.driver = org.postgresql.Driver
org.apache.jetspeed.production.database.user = portal
org.apache.jetspeed.production.database.password = portal
org.apache.jetspeed.production.jdbc.drivers.path= C:/Program
Files/PostgreSQL/8.1/jdbc/postgresql-8.1-404.jdbc3.jar
#configure Graffito test DB
#org.apache.portals.graffito.test.jetspeed = true
#org.apache.portals.graffito.test.database.default.name = postgres
#org.apache.portals.graffito.test.database.url =
jdbc:postgres://localhost/portal
#org.apache.portals.graffito.test.database.driver = org.postgresql.Driver
#org.apache.portals.graffito.test.database.user = portal
#org.apache.portals.graffito.test.database.password = portal
#org.apache.portals.graffito.test.jdbc.drivers.path= C:/Program
Files/PostgreSQL/8.1/jdbc/postgresql-8.1-404.jdbc3.jar
#org.apache.portals.graffito.production.jetspeed = true
#org.apache.portals.graffito.production.database.default.name = postgres
#org.apache.portals.graffito.production.database.url =
jdbc:postgres://localhost/portal
#org.apache.portals.graffito.production.database.driver =
org.postgresql.Driver
#org.apache.portals.graffito.production.database.user = portal
#org.apache.portals.graffito.production.database.password = portal
#org.apache.portals.graffito.production.jdbc.drivers.path = C:/Program
Files/PostgreSQL/8.1/jdbc/postgresql-8.1-404.jdbc3.jar
Regards,
Raj
Re: Graffito build
Posted by Oliver Kiessler <ki...@inceedo.com>.
On 2/7/06, Raj Saini <ra...@gmail.com> wrote:
> Christophe Lombart wrote:
>
> >OK, the scripts used to drop the db are missing for Postgres. You
> >should create a new folder similar to
> >"components/src/sql/GraffitoServer/mysql".
> >
> >
> >
> Yes I figured that out. Now problem is maven build fails it tries to
> drop a non existing table. Postgres does not have "if exists" like
> clause. Just trying to figure what could be an alternative.
You can find out if a table exists by querying the internal "pg_class" table:
SELECT relname FROM pg_class
WHERE relname = 'mytable';
Maybe a little function wrapper helps...
- Oliver
Re: Graffito build
Posted by Raj Saini <ra...@gmail.com>.
Christophe Lombart wrote:
>Drop the condition exist, use only "Drop ..." Maven will ignore errors
>on this sql scripts This is the only way to solve this kind of issues.
>
>
I modified the scripts and removed "IF EXISTS" clause from table drop
scripts. However, maven fails while executing the db.execute goal. On
further investigation I found that ${database.arg.onerror} variable is
defined for db.drop goal but not propogated to db.execute goal. I added
onerror="${database.arg.onerror}" to db.execute goal in maven.xml file
and db.drop goal executed successfully.
Further, sql generated by various schema have added DROP statements to
SQL scripts. Due to that table creation fails.
Is there a way not to include the DROP TABLE statments in CREATE tabale
DDL generated from schema files?
Thanks,
Raj
>
>
>On 2/7/06, Raj Saini <ra...@gmail.com> wrote:
>
>
>>Christophe Lombart wrote:
>>
>>
>>
>>>OK, the scripts used to drop the db are missing for Postgres. You
>>>should create a new folder similar to
>>>"components/src/sql/GraffitoServer/mysql".
>>>
>>>
>>>
>>>
>>>
>>Yes I figured that out. Now problem is maven build fails it tries to
>>drop a non existing table. Postgres does not have "if exists" like
>>clause. Just trying to figure what could be an alternative.
>>
>>Raj
>>
>>
>>
>>>On 2/7/06, Raj Saini <ra...@gmail.com> wrote:
>>>
>>>
>>>
>>>
>>
>>
>
>
>--
>Best regards,
>
>Christophe
>
>
>
Re: Graffito build
Posted by Christophe Lombart <ch...@gmail.com>.
Drop the condition exist, use only "Drop ..." Maven will ignore errors
on this sql scripts This is the only way to solve this kind of issues.
On 2/7/06, Raj Saini <ra...@gmail.com> wrote:
> Christophe Lombart wrote:
>
> >OK, the scripts used to drop the db are missing for Postgres. You
> >should create a new folder similar to
> >"components/src/sql/GraffitoServer/mysql".
> >
> >
> >
> Yes I figured that out. Now problem is maven build fails it tries to
> drop a non existing table. Postgres does not have "if exists" like
> clause. Just trying to figure what could be an alternative.
>
> Raj
>
> >On 2/7/06, Raj Saini <ra...@gmail.com> wrote:
> >
> >
>
>
--
Best regards,
Christophe
Re: Graffito build
Posted by Raj Saini <ra...@gmail.com>.
Christophe Lombart wrote:
>OK, the scripts used to drop the db are missing for Postgres. You
>should create a new folder similar to
>"components/src/sql/GraffitoServer/mysql".
>
>
>
Yes I figured that out. Now problem is maven build fails it tries to
drop a non existing table. Postgres does not have "if exists" like
clause. Just trying to figure what could be an alternative.
Raj
>On 2/7/06, Raj Saini <ra...@gmail.com> wrote:
>
>
Re: Graffito build
Posted by Christophe Lombart <ch...@gmail.com>.
OK, the scripts used to drop the db are missing for Postgres. You
should create a new folder similar to
"components/src/sql/GraffitoServer/mysql".
On 2/7/06, Raj Saini <ra...@gmail.com> wrote:
> Christophe,
>
> I could build Graffito with HSQL. I also tried on PostgreSQL and I passed
> through previous problem. For PostgreSQL torque database is postgresql
> instead of postgres.
>
> I will look into other problems later during day. Will keep you posted on my
> progress.
>
> Regards,
>
> Raj
>
> On 2/7/06, Christophe Lombart <ch...@gmail.com> wrote:
> >
> > Raj,
> >
> > I got the same issue here. So, I just committed some changes for the HSQL
> > DB.
> > The new torque plugin uses the key word hypersonic instead of hsql.
> >
> >
> > Can you check if it works you :
> >
> > 1/ review your build.properties like this :
> >
> > org.apache.portals.graffito.test.database.default.name=hypersonic
> > org.apache.portals.graffito.test.jetspeed=false
> > org.apache.portals.graffito.test.database.url =
> > jdbc:hsqldb:hsql://127.0.0.1:9001
> > org.apache.portals.graffito.test.database.driver = org.hsqldb.jdbcDriver
> > org.apache.portals.graffito.test.database.user = sa
> > org.apache.portals.graffito.test.database.password =
> >
> > org.apache.portals.graffito.test.jdbc.drivers.path=/home/christophe/.maven/repository/hsqldb/jars/hsqldb-1.8.0.2.jar
> >
> >
> > # configure PRODUCTION DB
> > [ No necessary to change the production db settings ]
> >
> > #Configue the Graffito Master OJB Store - USED FOR THE UNIT TESTS
> > org.apache.portals.graffito.database.ojb.platform=hsql
> >
> > org.apache.portals.graffito.database.ojb.datasource=java:comp/env/jdbc/graffitotest
> >
> >
> > 2/ Run the Hsql test server with : maven start.test.server
> > 3/ run the unit tests
> >
> > If it works for HSQL, we can try to fix your postgres issue.
> > Unfortunately, I have to install a new Postges db somewhere.
> >
> > On 2/6/06, Christophe Lombart <ch...@gmail.com> wrote:
> > > Ok I will review this issue today.
> > >
> > > Christophe
> > >
> > > On 2/6/06, Raj Saini <ra...@gmail.com> wrote:
> > > > Since last few days I have been trying to build Graffito with no
> > sucess. I
> > > > have tried it building with PostgreSQL as well as HSQLDB. I get
> > similar
> > > > error for PostgreSQL as well as HSQLDB. I am not sure what could be
> > the
> > > > problem. I have deleted my maven plugin cache as well as maven
> > repository
> > > > many time just in case the problem was due to some corrupt jar file.
> > > >
> > > > Just wanted to know if someone has built graffito with HSQLDB or
> > PostgreSQL.
> > > >
> > > > I am copying the error as well as contnets of build.properties file. I
> > am
> > > > not sure if I am missing any thing in my build.properties file.
> > > >
> > > > ===============================Maven
> > error=================================
> > > >
> > > > db.reinit.test:
> > > > db.test.properties:
> > > > [echo] org.apache.portals.graffito.test.database.default.name :
> > hsql
> > > > [echo] org.apache.portals.graffito.test.database.url :
> > > > jdbc:hsqldb:hsql://12
> > > > 7.0.0.1:9001
> > > > [echo] org.apache.portals.graffito.test.database.driver :
> > > > org.hsqldb.jdbcDri
> > > > ver
> > > > [echo] org.apache.portals.graffito.test.database.user : sa
> > > > [echo] org.apache.portals.graffito.test.database.password :
> > > > [echo] org.apache.portals.graffito.test.database.path :
> > C:/Documents and
> > > > Set
> > > > tings/RajbirS/.maven/repository/hsqldb/jars/hsqldb-1.8.2.jar
> > > > [echo] org.apache.portals.graffito.test.jetspeed : true
> > > >
> > > > db.scripts.gen:
> > > > torque:init:
> > > >
> > > > [echo] Generating SQL schema creation scripts for hsql
> > > > [torque-sql] Using classpath
> > > > [torque-sql] Generating to file
> > > > C:\Projects\graffito\components\target\src\s
> > > > ql\hsql\report.components.sql.generation
> > > >
> > > > BUILD FAILED
> > > > File...... C:\Projects\graffito\maven.xml
> > > > Element... maven:reactor
> > > > Line...... 88
> > > > Column.... 40
> > > > Unable to obtain goal [test:test] --
> > > > C:\Projects\graffito\components\maven.xml:1
> > > > 70:28: <torque-sql> Exception thrown by 'generator.parse'. For more
> > > > information
> > > > consult the velocity log, or invoke ant with the -debug flag.
> > > > Total time: 48 seconds
> > > > Finished at: Mon Feb 06 13:40:07 GMT+05:30 2006
> > > >
> > > >
> > > >
> > > > ==============================================
> > > > velocity.log======================================================
> > > > 2006-02-06 13:40:07,243 - Velocimacro : initialization starting.
> > > > 2006-02-06 13:40:07,243 - Velocimacro : adding VMs from VM library
> > template
> > > > : VM_global_library.vm
> > > > 2006-02-06 13:40:07,243 - ResourceManager : unable to find resource
> > > > 'VM_global_library.vm' in any resource loader.
> > > > 2006-02-06 13:40:07,243 - Velocimacro : error using VM library
> > template
> > > > VM_global_library.vm :
> > > > org.apache.velocity.exception.ResourceNotFoundException: Unable to
> > find
> > > > resource 'VM_global_library.vm'
> > > > 2006-02-06 13:40:07,243 - Velocimacro : VM library template macro
> > > > registration complete.
> > > > 2006-02-06 13:40:07,243 - Velocimacro : allowInline = true : VMs can
> > be
> > > > defined inline in templates
> > > > 2006-02-06 13:40:07,243 - Velocimacro : allowInlineToOverride = false
> > : VMs
> > > > defined inline may NOT replace previous VM definitions
> > > > 2006-02-06 13:40:07,243 - Velocimacro : allowInlineLocal = false : VMs
> > > > defined inline will be global in scope if allowed.
> > > > 2006-02-06 13:40:07,243 - Velocimacro : messages on : VM system will
> > output
> > > > logging messages
> > > > 2006-02-06 13:40:07,243 - Velocimacro : autoload off : VM system will
> > not
> > > > automatically reload global library macros
> > > > 2006-02-06 13:40:07,243 - Velocimacro : initialization complete.
> > > > 2006-02-06 13:40:07,243 - Velocity successfully started.
> > > > 2006-02-06 13:40:07,624 - ResourceManager : found sql/base/Control.vm
> > with
> > > > loader
> > org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader
> > > > 2006-02-06 13:40:07,640 - ResourceManager : unable to find resource
> > > > 'sql/base/hsql/table.vm' in any resource loader.
> > > > 2006-02-06 13:40:07,640 - Method parse threw exception for reference
> > > > $generator in template sql/base/Control.vm at [35,7]
> > > >
> > > >
> > > >
> > > >
> > > > ===============================================
> > build.propertiesfile===================================================
> > > > org.apache.portals.graffito.test.database.default.name=hsql
> > > > org.apache.portals.graffito.test.jetspeed=false
> > > > org.apache.portals.graffito.test.database.url =
> > > > jdbc:hsqldb:hsql://127.0.0.1:9001
> > > > org.apache.portals.graffito.test.database.driver =
> > org.hsqldb.jdbcDriver
> > > > org.apache.portals.graffito.test.database.user = sa
> > > > org.apache.portals.graffito.test.database.password =
> > > > org.apache.portals.graffito.test.jdbc.drivers.path=C:/Documents and
> > > > Settings/RajbirS/.maven/repository/hsqldb/jars/hsqldb-1.8.2.jar
> > > >
> > > > # configure PRODUCTION DB
> > > >
> > > > org.apache.portals.graffito.production.database.default.name=hsql
> > > > org.apache.portals.graffito.production.jetspeed=true
> > > > org.apache.portals.graffito.production.database.url =
> > > > jdbc:hsqldb:hsql://127.0.0.1:9001
> > > > org.apache.portals.graffito.production.database.driver =
> > > > org.hsqldb.jdbcDriver
> > > > org.apache.portals.graffito.production.database.user = sa
> > > > org.apache.portals.graffito.production.database.password =
> > > > org.apache.portals.graffito.production.jdbc.drivers.path=C:/Documentsand
> > > > Settings/RajbirS/.maven/repository/jars/hsqldb/hsqldb-1.8.2.jar
> > > >
> > > >
> > > > #Configue the Graffito Master OJB Store - USED FOR THE UNIT TESTS
> > > > org.apache.portals.graffito.database.ojb.platform=Hsqldb
> > > >
> > org.apache.portals.graffito.database.ojb.datasource=java:comp/env/jdbc/graffitotest
> > > >
> > > >
> > > > # required Jetspeed 2 portal configuration property for building from
> > the
> > > > source
> > > > org.apache.jetspeed.project.home = C:/Projects/Jetspeed-2
> > > > org.apache.jetspeed.portal.home = ${org.apache.jetspeed.project.home}
> > > >
> > > > # required application server properties
> > > > org.apache.jetspeed.server.home = C:/Program
> > > > Files/Apache/Tomcat 5.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 = admin
> > > > org.apache.jetspeed.services.autodeployment.password = admin
> > > > org.apache.jetspeed.catalina.version.major = 5.5
> > > >
> > > >
> > > > # configure Postgresql TEST DB
> > > >
> > > > org.apache.jetspeed.test.database.default.name=postgres
> > > > org.apache.portals.graffito.test.jetspeed = true
> > > > org.apache.jetspeed.test.database.url =
> > jdbc:postgres://localhost/portal
> > > > org.apache.jetspeed.test.database.driver = org.postgresql.Driver
> > > > org.apache.jetspeed.test.database.user = portal
> > > > org.apache.jetspeed.test.database.password = portal
> > > > org.apache.jetspeed.test.jdbc.drivers.path= C:/Program
> > > > Files/PostgreSQL/8.1/jdbc/postgresql-8.1-404.jdbc3.jar
> > > >
> > > > # configure Postgresql Production DB
> > > >
> > > > org.apache.jetspeed.production.database.default.name=postgres
> > > > org.apache.jetspeed.production.database.url =
> > > > jdbc:postgres://localhost/portal
> > > > org.apache.jetspeed.production.database.driver = org.postgresql.Driver
> > > > org.apache.jetspeed.production.database.user = portal
> > > > org.apache.jetspeed.production.database.password = portal
> > > > org.apache.jetspeed.production.jdbc.drivers.path= C:/Program
> > > > Files/PostgreSQL/8.1/jdbc/postgresql-8.1-404.jdbc3.jar
> > > >
> > > >
> > > > #configure Graffito test DB
> > > > #org.apache.portals.graffito.test.jetspeed = true
> > > > #org.apache.portals.graffito.test.database.default.name = postgres
> > > > #org.apache.portals.graffito.test.database.url =
> > > > jdbc:postgres://localhost/portal
> > > > #org.apache.portals.graffito.test.database.driver =
> > org.postgresql.Driver
> > > > #org.apache.portals.graffito.test.database.user = portal
> > > > #org.apache.portals.graffito.test.database.password = portal
> > > > #org.apache.portals.graffito.test.jdbc.drivers.path= C:/Program
> > > > Files/PostgreSQL/8.1/jdbc/postgresql-8.1-404.jdbc3.jar
> > > >
> > > >
> > > >
> > > > #org.apache.portals.graffito.production.jetspeed = true
> > > > #org.apache.portals.graffito.production.database.default.name =
> > postgres
> > > > #org.apache.portals.graffito.production.database.url =
> > > > jdbc:postgres://localhost/portal
> > > > #org.apache.portals.graffito.production.database.driver =
> > > > org.postgresql.Driver
> > > > #org.apache.portals.graffito.production.database.user = portal
> > > > #org.apache.portals.graffito.production.database.password = portal
> > > > #org.apache.portals.graffito.production.jdbc.drivers.path = C:/Program
> > > > Files/PostgreSQL/8.1/jdbc/postgresql-8.1-404.jdbc3.jar
> > > >
> > > > Regards,
> > > >
> > > > Raj
> > > >
> > > >
> > >
> > >
> > > --
> > > Best regards,
> > >
> > > Christophe
> > >
> >
> >
> > --
> > Best regards,
> >
> > Christophe
> >
>
>
--
Best regards,
Christophe
Re: Graffito build
Posted by Raj Saini <ra...@gmail.com>.
Christophe,
I could build Graffito with HSQL. I also tried on PostgreSQL and I passed
through previous problem. For PostgreSQL torque database is postgresql
instead of postgres.
I will look into other problems later during day. Will keep you posted on my
progress.
Regards,
Raj
On 2/7/06, Christophe Lombart <ch...@gmail.com> wrote:
>
> Raj,
>
> I got the same issue here. So, I just committed some changes for the HSQL
> DB.
> The new torque plugin uses the key word hypersonic instead of hsql.
>
>
> Can you check if it works you :
>
> 1/ review your build.properties like this :
>
> org.apache.portals.graffito.test.database.default.name=hypersonic
> org.apache.portals.graffito.test.jetspeed=false
> org.apache.portals.graffito.test.database.url =
> jdbc:hsqldb:hsql://127.0.0.1:9001
> org.apache.portals.graffito.test.database.driver = org.hsqldb.jdbcDriver
> org.apache.portals.graffito.test.database.user = sa
> org.apache.portals.graffito.test.database.password =
>
> org.apache.portals.graffito.test.jdbc.drivers.path=/home/christophe/.maven/repository/hsqldb/jars/hsqldb-1.8.0.2.jar
>
>
> # configure PRODUCTION DB
> [ No necessary to change the production db settings ]
>
> #Configue the Graffito Master OJB Store - USED FOR THE UNIT TESTS
> org.apache.portals.graffito.database.ojb.platform=hsql
>
> org.apache.portals.graffito.database.ojb.datasource=java:comp/env/jdbc/graffitotest
>
>
> 2/ Run the Hsql test server with : maven start.test.server
> 3/ run the unit tests
>
> If it works for HSQL, we can try to fix your postgres issue.
> Unfortunately, I have to install a new Postges db somewhere.
>
> On 2/6/06, Christophe Lombart <ch...@gmail.com> wrote:
> > Ok I will review this issue today.
> >
> > Christophe
> >
> > On 2/6/06, Raj Saini <ra...@gmail.com> wrote:
> > > Since last few days I have been trying to build Graffito with no
> sucess. I
> > > have tried it building with PostgreSQL as well as HSQLDB. I get
> similar
> > > error for PostgreSQL as well as HSQLDB. I am not sure what could be
> the
> > > problem. I have deleted my maven plugin cache as well as maven
> repository
> > > many time just in case the problem was due to some corrupt jar file.
> > >
> > > Just wanted to know if someone has built graffito with HSQLDB or
> PostgreSQL.
> > >
> > > I am copying the error as well as contnets of build.properties file. I
> am
> > > not sure if I am missing any thing in my build.properties file.
> > >
> > > ===============================Maven
> error=================================
> > >
> > > db.reinit.test:
> > > db.test.properties:
> > > [echo] org.apache.portals.graffito.test.database.default.name :
> hsql
> > > [echo] org.apache.portals.graffito.test.database.url :
> > > jdbc:hsqldb:hsql://12
> > > 7.0.0.1:9001
> > > [echo] org.apache.portals.graffito.test.database.driver :
> > > org.hsqldb.jdbcDri
> > > ver
> > > [echo] org.apache.portals.graffito.test.database.user : sa
> > > [echo] org.apache.portals.graffito.test.database.password :
> > > [echo] org.apache.portals.graffito.test.database.path :
> C:/Documents and
> > > Set
> > > tings/RajbirS/.maven/repository/hsqldb/jars/hsqldb-1.8.2.jar
> > > [echo] org.apache.portals.graffito.test.jetspeed : true
> > >
> > > db.scripts.gen:
> > > torque:init:
> > >
> > > [echo] Generating SQL schema creation scripts for hsql
> > > [torque-sql] Using classpath
> > > [torque-sql] Generating to file
> > > C:\Projects\graffito\components\target\src\s
> > > ql\hsql\report.components.sql.generation
> > >
> > > BUILD FAILED
> > > File...... C:\Projects\graffito\maven.xml
> > > Element... maven:reactor
> > > Line...... 88
> > > Column.... 40
> > > Unable to obtain goal [test:test] --
> > > C:\Projects\graffito\components\maven.xml:1
> > > 70:28: <torque-sql> Exception thrown by 'generator.parse'. For more
> > > information
> > > consult the velocity log, or invoke ant with the -debug flag.
> > > Total time: 48 seconds
> > > Finished at: Mon Feb 06 13:40:07 GMT+05:30 2006
> > >
> > >
> > >
> > > ==============================================
> > > velocity.log======================================================
> > > 2006-02-06 13:40:07,243 - Velocimacro : initialization starting.
> > > 2006-02-06 13:40:07,243 - Velocimacro : adding VMs from VM library
> template
> > > : VM_global_library.vm
> > > 2006-02-06 13:40:07,243 - ResourceManager : unable to find resource
> > > 'VM_global_library.vm' in any resource loader.
> > > 2006-02-06 13:40:07,243 - Velocimacro : error using VM library
> template
> > > VM_global_library.vm :
> > > org.apache.velocity.exception.ResourceNotFoundException: Unable to
> find
> > > resource 'VM_global_library.vm'
> > > 2006-02-06 13:40:07,243 - Velocimacro : VM library template macro
> > > registration complete.
> > > 2006-02-06 13:40:07,243 - Velocimacro : allowInline = true : VMs can
> be
> > > defined inline in templates
> > > 2006-02-06 13:40:07,243 - Velocimacro : allowInlineToOverride = false
> : VMs
> > > defined inline may NOT replace previous VM definitions
> > > 2006-02-06 13:40:07,243 - Velocimacro : allowInlineLocal = false : VMs
> > > defined inline will be global in scope if allowed.
> > > 2006-02-06 13:40:07,243 - Velocimacro : messages on : VM system will
> output
> > > logging messages
> > > 2006-02-06 13:40:07,243 - Velocimacro : autoload off : VM system will
> not
> > > automatically reload global library macros
> > > 2006-02-06 13:40:07,243 - Velocimacro : initialization complete.
> > > 2006-02-06 13:40:07,243 - Velocity successfully started.
> > > 2006-02-06 13:40:07,624 - ResourceManager : found sql/base/Control.vm
> with
> > > loader
> org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader
> > > 2006-02-06 13:40:07,640 - ResourceManager : unable to find resource
> > > 'sql/base/hsql/table.vm' in any resource loader.
> > > 2006-02-06 13:40:07,640 - Method parse threw exception for reference
> > > $generator in template sql/base/Control.vm at [35,7]
> > >
> > >
> > >
> > >
> > > ===============================================
> build.propertiesfile===================================================
> > > org.apache.portals.graffito.test.database.default.name=hsql
> > > org.apache.portals.graffito.test.jetspeed=false
> > > org.apache.portals.graffito.test.database.url =
> > > jdbc:hsqldb:hsql://127.0.0.1:9001
> > > org.apache.portals.graffito.test.database.driver =
> org.hsqldb.jdbcDriver
> > > org.apache.portals.graffito.test.database.user = sa
> > > org.apache.portals.graffito.test.database.password =
> > > org.apache.portals.graffito.test.jdbc.drivers.path=C:/Documents and
> > > Settings/RajbirS/.maven/repository/hsqldb/jars/hsqldb-1.8.2.jar
> > >
> > > # configure PRODUCTION DB
> > >
> > > org.apache.portals.graffito.production.database.default.name=hsql
> > > org.apache.portals.graffito.production.jetspeed=true
> > > org.apache.portals.graffito.production.database.url =
> > > jdbc:hsqldb:hsql://127.0.0.1:9001
> > > org.apache.portals.graffito.production.database.driver =
> > > org.hsqldb.jdbcDriver
> > > org.apache.portals.graffito.production.database.user = sa
> > > org.apache.portals.graffito.production.database.password =
> > > org.apache.portals.graffito.production.jdbc.drivers.path=C:/Documentsand
> > > Settings/RajbirS/.maven/repository/jars/hsqldb/hsqldb-1.8.2.jar
> > >
> > >
> > > #Configue the Graffito Master OJB Store - USED FOR THE UNIT TESTS
> > > org.apache.portals.graffito.database.ojb.platform=Hsqldb
> > >
> org.apache.portals.graffito.database.ojb.datasource=java:comp/env/jdbc/graffitotest
> > >
> > >
> > > # required Jetspeed 2 portal configuration property for building from
> the
> > > source
> > > org.apache.jetspeed.project.home = C:/Projects/Jetspeed-2
> > > org.apache.jetspeed.portal.home = ${org.apache.jetspeed.project.home}
> > >
> > > # required application server properties
> > > org.apache.jetspeed.server.home = C:/Program
> > > Files/Apache/Tomcat 5.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 = admin
> > > org.apache.jetspeed.services.autodeployment.password = admin
> > > org.apache.jetspeed.catalina.version.major = 5.5
> > >
> > >
> > > # configure Postgresql TEST DB
> > >
> > > org.apache.jetspeed.test.database.default.name=postgres
> > > org.apache.portals.graffito.test.jetspeed = true
> > > org.apache.jetspeed.test.database.url =
> jdbc:postgres://localhost/portal
> > > org.apache.jetspeed.test.database.driver = org.postgresql.Driver
> > > org.apache.jetspeed.test.database.user = portal
> > > org.apache.jetspeed.test.database.password = portal
> > > org.apache.jetspeed.test.jdbc.drivers.path= C:/Program
> > > Files/PostgreSQL/8.1/jdbc/postgresql-8.1-404.jdbc3.jar
> > >
> > > # configure Postgresql Production DB
> > >
> > > org.apache.jetspeed.production.database.default.name=postgres
> > > org.apache.jetspeed.production.database.url =
> > > jdbc:postgres://localhost/portal
> > > org.apache.jetspeed.production.database.driver = org.postgresql.Driver
> > > org.apache.jetspeed.production.database.user = portal
> > > org.apache.jetspeed.production.database.password = portal
> > > org.apache.jetspeed.production.jdbc.drivers.path= C:/Program
> > > Files/PostgreSQL/8.1/jdbc/postgresql-8.1-404.jdbc3.jar
> > >
> > >
> > > #configure Graffito test DB
> > > #org.apache.portals.graffito.test.jetspeed = true
> > > #org.apache.portals.graffito.test.database.default.name = postgres
> > > #org.apache.portals.graffito.test.database.url =
> > > jdbc:postgres://localhost/portal
> > > #org.apache.portals.graffito.test.database.driver =
> org.postgresql.Driver
> > > #org.apache.portals.graffito.test.database.user = portal
> > > #org.apache.portals.graffito.test.database.password = portal
> > > #org.apache.portals.graffito.test.jdbc.drivers.path= C:/Program
> > > Files/PostgreSQL/8.1/jdbc/postgresql-8.1-404.jdbc3.jar
> > >
> > >
> > >
> > > #org.apache.portals.graffito.production.jetspeed = true
> > > #org.apache.portals.graffito.production.database.default.name =
> postgres
> > > #org.apache.portals.graffito.production.database.url =
> > > jdbc:postgres://localhost/portal
> > > #org.apache.portals.graffito.production.database.driver =
> > > org.postgresql.Driver
> > > #org.apache.portals.graffito.production.database.user = portal
> > > #org.apache.portals.graffito.production.database.password = portal
> > > #org.apache.portals.graffito.production.jdbc.drivers.path = C:/Program
> > > Files/PostgreSQL/8.1/jdbc/postgresql-8.1-404.jdbc3.jar
> > >
> > > Regards,
> > >
> > > Raj
> > >
> > >
> >
> >
> > --
> > Best regards,
> >
> > Christophe
> >
>
>
> --
> Best regards,
>
> Christophe
>
Re: Graffito build
Posted by Christophe Lombart <ch...@gmail.com>.
Raj,
I got the same issue here. So, I just committed some changes for the HSQL DB.
The new torque plugin uses the key word hypersonic instead of hsql.
Can you check if it works you :
1/ review your build.properties like this :
org.apache.portals.graffito.test.database.default.name=hypersonic
org.apache.portals.graffito.test.jetspeed=false
org.apache.portals.graffito.test.database.url =
jdbc:hsqldb:hsql://127.0.0.1:9001
org.apache.portals.graffito.test.database.driver = org.hsqldb.jdbcDriver
org.apache.portals.graffito.test.database.user = sa
org.apache.portals.graffito.test.database.password =
org.apache.portals.graffito.test.jdbc.drivers.path=/home/christophe/.maven/repository/hsqldb/jars/hsqldb-1.8.0.2.jar
# configure PRODUCTION DB
[ No necessary to change the production db settings ]
#Configue the Graffito Master OJB Store - USED FOR THE UNIT TESTS
org.apache.portals.graffito.database.ojb.platform=hsql
org.apache.portals.graffito.database.ojb.datasource=java:comp/env/jdbc/graffitotest
2/ Run the Hsql test server with : maven start.test.server
3/ run the unit tests
If it works for HSQL, we can try to fix your postgres issue.
Unfortunately, I have to install a new Postges db somewhere.
On 2/6/06, Christophe Lombart <ch...@gmail.com> wrote:
> Ok I will review this issue today.
>
> Christophe
>
> On 2/6/06, Raj Saini <ra...@gmail.com> wrote:
> > Since last few days I have been trying to build Graffito with no sucess. I
> > have tried it building with PostgreSQL as well as HSQLDB. I get similar
> > error for PostgreSQL as well as HSQLDB. I am not sure what could be the
> > problem. I have deleted my maven plugin cache as well as maven repository
> > many time just in case the problem was due to some corrupt jar file.
> >
> > Just wanted to know if someone has built graffito with HSQLDB or PostgreSQL.
> >
> > I am copying the error as well as contnets of build.properties file. I am
> > not sure if I am missing any thing in my build.properties file.
> >
> > ===============================Maven error=================================
> >
> > db.reinit.test:
> > db.test.properties:
> > [echo] org.apache.portals.graffito.test.database.default.name : hsql
> > [echo] org.apache.portals.graffito.test.database.url :
> > jdbc:hsqldb:hsql://12
> > 7.0.0.1:9001
> > [echo] org.apache.portals.graffito.test.database.driver :
> > org.hsqldb.jdbcDri
> > ver
> > [echo] org.apache.portals.graffito.test.database.user : sa
> > [echo] org.apache.portals.graffito.test.database.password :
> > [echo] org.apache.portals.graffito.test.database.path : C:/Documents and
> > Set
> > tings/RajbirS/.maven/repository/hsqldb/jars/hsqldb-1.8.2.jar
> > [echo] org.apache.portals.graffito.test.jetspeed : true
> >
> > db.scripts.gen:
> > torque:init:
> >
> > [echo] Generating SQL schema creation scripts for hsql
> > [torque-sql] Using classpath
> > [torque-sql] Generating to file
> > C:\Projects\graffito\components\target\src\s
> > ql\hsql\report.components.sql.generation
> >
> > BUILD FAILED
> > File...... C:\Projects\graffito\maven.xml
> > Element... maven:reactor
> > Line...... 88
> > Column.... 40
> > Unable to obtain goal [test:test] --
> > C:\Projects\graffito\components\maven.xml:1
> > 70:28: <torque-sql> Exception thrown by 'generator.parse'. For more
> > information
> > consult the velocity log, or invoke ant with the -debug flag.
> > Total time: 48 seconds
> > Finished at: Mon Feb 06 13:40:07 GMT+05:30 2006
> >
> >
> >
> > ==============================================
> > velocity.log======================================================
> > 2006-02-06 13:40:07,243 - Velocimacro : initialization starting.
> > 2006-02-06 13:40:07,243 - Velocimacro : adding VMs from VM library template
> > : VM_global_library.vm
> > 2006-02-06 13:40:07,243 - ResourceManager : unable to find resource
> > 'VM_global_library.vm' in any resource loader.
> > 2006-02-06 13:40:07,243 - Velocimacro : error using VM library template
> > VM_global_library.vm :
> > org.apache.velocity.exception.ResourceNotFoundException: Unable to find
> > resource 'VM_global_library.vm'
> > 2006-02-06 13:40:07,243 - Velocimacro : VM library template macro
> > registration complete.
> > 2006-02-06 13:40:07,243 - Velocimacro : allowInline = true : VMs can be
> > defined inline in templates
> > 2006-02-06 13:40:07,243 - Velocimacro : allowInlineToOverride = false : VMs
> > defined inline may NOT replace previous VM definitions
> > 2006-02-06 13:40:07,243 - Velocimacro : allowInlineLocal = false : VMs
> > defined inline will be global in scope if allowed.
> > 2006-02-06 13:40:07,243 - Velocimacro : messages on : VM system will output
> > logging messages
> > 2006-02-06 13:40:07,243 - Velocimacro : autoload off : VM system will not
> > automatically reload global library macros
> > 2006-02-06 13:40:07,243 - Velocimacro : initialization complete.
> > 2006-02-06 13:40:07,243 - Velocity successfully started.
> > 2006-02-06 13:40:07,624 - ResourceManager : found sql/base/Control.vm with
> > loader org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader
> > 2006-02-06 13:40:07,640 - ResourceManager : unable to find resource
> > 'sql/base/hsql/table.vm' in any resource loader.
> > 2006-02-06 13:40:07,640 - Method parse threw exception for reference
> > $generator in template sql/base/Control.vm at [35,7]
> >
> >
> >
> >
> > ===============================================build.propertiesfile===================================================
> > org.apache.portals.graffito.test.database.default.name=hsql
> > org.apache.portals.graffito.test.jetspeed=false
> > org.apache.portals.graffito.test.database.url =
> > jdbc:hsqldb:hsql://127.0.0.1:9001
> > org.apache.portals.graffito.test.database.driver = org.hsqldb.jdbcDriver
> > org.apache.portals.graffito.test.database.user = sa
> > org.apache.portals.graffito.test.database.password =
> > org.apache.portals.graffito.test.jdbc.drivers.path=C:/Documents and
> > Settings/RajbirS/.maven/repository/hsqldb/jars/hsqldb-1.8.2.jar
> >
> > # configure PRODUCTION DB
> >
> > org.apache.portals.graffito.production.database.default.name=hsql
> > org.apache.portals.graffito.production.jetspeed=true
> > org.apache.portals.graffito.production.database.url =
> > jdbc:hsqldb:hsql://127.0.0.1:9001
> > org.apache.portals.graffito.production.database.driver =
> > org.hsqldb.jdbcDriver
> > org.apache.portals.graffito.production.database.user = sa
> > org.apache.portals.graffito.production.database.password =
> > org.apache.portals.graffito.production.jdbc.drivers.path=C:/Documents and
> > Settings/RajbirS/.maven/repository/jars/hsqldb/hsqldb-1.8.2.jar
> >
> >
> > #Configue the Graffito Master OJB Store - USED FOR THE UNIT TESTS
> > org.apache.portals.graffito.database.ojb.platform=Hsqldb
> > org.apache.portals.graffito.database.ojb.datasource=java:comp/env/jdbc/graffitotest
> >
> >
> > # required Jetspeed 2 portal configuration property for building from the
> > source
> > org.apache.jetspeed.project.home = C:/Projects/Jetspeed-2
> > org.apache.jetspeed.portal.home = ${org.apache.jetspeed.project.home}
> >
> > # required application server properties
> > org.apache.jetspeed.server.home = C:/Program
> > Files/Apache/Tomcat 5.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 = admin
> > org.apache.jetspeed.services.autodeployment.password = admin
> > org.apache.jetspeed.catalina.version.major = 5.5
> >
> >
> > # configure Postgresql TEST DB
> >
> > org.apache.jetspeed.test.database.default.name=postgres
> > org.apache.portals.graffito.test.jetspeed = true
> > org.apache.jetspeed.test.database.url = jdbc:postgres://localhost/portal
> > org.apache.jetspeed.test.database.driver = org.postgresql.Driver
> > org.apache.jetspeed.test.database.user = portal
> > org.apache.jetspeed.test.database.password = portal
> > org.apache.jetspeed.test.jdbc.drivers.path= C:/Program
> > Files/PostgreSQL/8.1/jdbc/postgresql-8.1-404.jdbc3.jar
> >
> > # configure Postgresql Production DB
> >
> > org.apache.jetspeed.production.database.default.name=postgres
> > org.apache.jetspeed.production.database.url =
> > jdbc:postgres://localhost/portal
> > org.apache.jetspeed.production.database.driver = org.postgresql.Driver
> > org.apache.jetspeed.production.database.user = portal
> > org.apache.jetspeed.production.database.password = portal
> > org.apache.jetspeed.production.jdbc.drivers.path= C:/Program
> > Files/PostgreSQL/8.1/jdbc/postgresql-8.1-404.jdbc3.jar
> >
> >
> > #configure Graffito test DB
> > #org.apache.portals.graffito.test.jetspeed = true
> > #org.apache.portals.graffito.test.database.default.name = postgres
> > #org.apache.portals.graffito.test.database.url =
> > jdbc:postgres://localhost/portal
> > #org.apache.portals.graffito.test.database.driver = org.postgresql.Driver
> > #org.apache.portals.graffito.test.database.user = portal
> > #org.apache.portals.graffito.test.database.password = portal
> > #org.apache.portals.graffito.test.jdbc.drivers.path= C:/Program
> > Files/PostgreSQL/8.1/jdbc/postgresql-8.1-404.jdbc3.jar
> >
> >
> >
> > #org.apache.portals.graffito.production.jetspeed = true
> > #org.apache.portals.graffito.production.database.default.name = postgres
> > #org.apache.portals.graffito.production.database.url =
> > jdbc:postgres://localhost/portal
> > #org.apache.portals.graffito.production.database.driver =
> > org.postgresql.Driver
> > #org.apache.portals.graffito.production.database.user = portal
> > #org.apache.portals.graffito.production.database.password = portal
> > #org.apache.portals.graffito.production.jdbc.drivers.path = C:/Program
> > Files/PostgreSQL/8.1/jdbc/postgresql-8.1-404.jdbc3.jar
> >
> > Regards,
> >
> > Raj
> >
> >
>
>
> --
> Best regards,
>
> Christophe
>
--
Best regards,
Christophe
Re: Graffito build
Posted by Christophe Lombart <ch...@gmail.com>.
Ok I will review this issue today.
Christophe
On 2/6/06, Raj Saini <ra...@gmail.com> wrote:
> Since last few days I have been trying to build Graffito with no sucess. I
> have tried it building with PostgreSQL as well as HSQLDB. I get similar
> error for PostgreSQL as well as HSQLDB. I am not sure what could be the
> problem. I have deleted my maven plugin cache as well as maven repository
> many time just in case the problem was due to some corrupt jar file.
>
> Just wanted to know if someone has built graffito with HSQLDB or PostgreSQL.
>
> I am copying the error as well as contnets of build.properties file. I am
> not sure if I am missing any thing in my build.properties file.
>
> ===============================Maven error=================================
>
> db.reinit.test:
> db.test.properties:
> [echo] org.apache.portals.graffito.test.database.default.name : hsql
> [echo] org.apache.portals.graffito.test.database.url :
> jdbc:hsqldb:hsql://12
> 7.0.0.1:9001
> [echo] org.apache.portals.graffito.test.database.driver :
> org.hsqldb.jdbcDri
> ver
> [echo] org.apache.portals.graffito.test.database.user : sa
> [echo] org.apache.portals.graffito.test.database.password :
> [echo] org.apache.portals.graffito.test.database.path : C:/Documents and
> Set
> tings/RajbirS/.maven/repository/hsqldb/jars/hsqldb-1.8.2.jar
> [echo] org.apache.portals.graffito.test.jetspeed : true
>
> db.scripts.gen:
> torque:init:
>
> [echo] Generating SQL schema creation scripts for hsql
> [torque-sql] Using classpath
> [torque-sql] Generating to file
> C:\Projects\graffito\components\target\src\s
> ql\hsql\report.components.sql.generation
>
> BUILD FAILED
> File...... C:\Projects\graffito\maven.xml
> Element... maven:reactor
> Line...... 88
> Column.... 40
> Unable to obtain goal [test:test] --
> C:\Projects\graffito\components\maven.xml:1
> 70:28: <torque-sql> Exception thrown by 'generator.parse'. For more
> information
> consult the velocity log, or invoke ant with the -debug flag.
> Total time: 48 seconds
> Finished at: Mon Feb 06 13:40:07 GMT+05:30 2006
>
>
>
> ==============================================
> velocity.log======================================================
> 2006-02-06 13:40:07,243 - Velocimacro : initialization starting.
> 2006-02-06 13:40:07,243 - Velocimacro : adding VMs from VM library template
> : VM_global_library.vm
> 2006-02-06 13:40:07,243 - ResourceManager : unable to find resource
> 'VM_global_library.vm' in any resource loader.
> 2006-02-06 13:40:07,243 - Velocimacro : error using VM library template
> VM_global_library.vm :
> org.apache.velocity.exception.ResourceNotFoundException: Unable to find
> resource 'VM_global_library.vm'
> 2006-02-06 13:40:07,243 - Velocimacro : VM library template macro
> registration complete.
> 2006-02-06 13:40:07,243 - Velocimacro : allowInline = true : VMs can be
> defined inline in templates
> 2006-02-06 13:40:07,243 - Velocimacro : allowInlineToOverride = false : VMs
> defined inline may NOT replace previous VM definitions
> 2006-02-06 13:40:07,243 - Velocimacro : allowInlineLocal = false : VMs
> defined inline will be global in scope if allowed.
> 2006-02-06 13:40:07,243 - Velocimacro : messages on : VM system will output
> logging messages
> 2006-02-06 13:40:07,243 - Velocimacro : autoload off : VM system will not
> automatically reload global library macros
> 2006-02-06 13:40:07,243 - Velocimacro : initialization complete.
> 2006-02-06 13:40:07,243 - Velocity successfully started.
> 2006-02-06 13:40:07,624 - ResourceManager : found sql/base/Control.vm with
> loader org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader
> 2006-02-06 13:40:07,640 - ResourceManager : unable to find resource
> 'sql/base/hsql/table.vm' in any resource loader.
> 2006-02-06 13:40:07,640 - Method parse threw exception for reference
> $generator in template sql/base/Control.vm at [35,7]
>
>
>
>
> ===============================================build.propertiesfile===================================================
> org.apache.portals.graffito.test.database.default.name=hsql
> org.apache.portals.graffito.test.jetspeed=false
> org.apache.portals.graffito.test.database.url =
> jdbc:hsqldb:hsql://127.0.0.1:9001
> org.apache.portals.graffito.test.database.driver = org.hsqldb.jdbcDriver
> org.apache.portals.graffito.test.database.user = sa
> org.apache.portals.graffito.test.database.password =
> org.apache.portals.graffito.test.jdbc.drivers.path=C:/Documents and
> Settings/RajbirS/.maven/repository/hsqldb/jars/hsqldb-1.8.2.jar
>
> # configure PRODUCTION DB
>
> org.apache.portals.graffito.production.database.default.name=hsql
> org.apache.portals.graffito.production.jetspeed=true
> org.apache.portals.graffito.production.database.url =
> jdbc:hsqldb:hsql://127.0.0.1:9001
> org.apache.portals.graffito.production.database.driver =
> org.hsqldb.jdbcDriver
> org.apache.portals.graffito.production.database.user = sa
> org.apache.portals.graffito.production.database.password =
> org.apache.portals.graffito.production.jdbc.drivers.path=C:/Documents and
> Settings/RajbirS/.maven/repository/jars/hsqldb/hsqldb-1.8.2.jar
>
>
> #Configue the Graffito Master OJB Store - USED FOR THE UNIT TESTS
> org.apache.portals.graffito.database.ojb.platform=Hsqldb
> org.apache.portals.graffito.database.ojb.datasource=java:comp/env/jdbc/graffitotest
>
>
> # required Jetspeed 2 portal configuration property for building from the
> source
> org.apache.jetspeed.project.home = C:/Projects/Jetspeed-2
> org.apache.jetspeed.portal.home = ${org.apache.jetspeed.project.home}
>
> # required application server properties
> org.apache.jetspeed.server.home = C:/Program
> Files/Apache/Tomcat 5.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 = admin
> org.apache.jetspeed.services.autodeployment.password = admin
> org.apache.jetspeed.catalina.version.major = 5.5
>
>
> # configure Postgresql TEST DB
>
> org.apache.jetspeed.test.database.default.name=postgres
> org.apache.portals.graffito.test.jetspeed = true
> org.apache.jetspeed.test.database.url = jdbc:postgres://localhost/portal
> org.apache.jetspeed.test.database.driver = org.postgresql.Driver
> org.apache.jetspeed.test.database.user = portal
> org.apache.jetspeed.test.database.password = portal
> org.apache.jetspeed.test.jdbc.drivers.path= C:/Program
> Files/PostgreSQL/8.1/jdbc/postgresql-8.1-404.jdbc3.jar
>
> # configure Postgresql Production DB
>
> org.apache.jetspeed.production.database.default.name=postgres
> org.apache.jetspeed.production.database.url =
> jdbc:postgres://localhost/portal
> org.apache.jetspeed.production.database.driver = org.postgresql.Driver
> org.apache.jetspeed.production.database.user = portal
> org.apache.jetspeed.production.database.password = portal
> org.apache.jetspeed.production.jdbc.drivers.path= C:/Program
> Files/PostgreSQL/8.1/jdbc/postgresql-8.1-404.jdbc3.jar
>
>
> #configure Graffito test DB
> #org.apache.portals.graffito.test.jetspeed = true
> #org.apache.portals.graffito.test.database.default.name = postgres
> #org.apache.portals.graffito.test.database.url =
> jdbc:postgres://localhost/portal
> #org.apache.portals.graffito.test.database.driver = org.postgresql.Driver
> #org.apache.portals.graffito.test.database.user = portal
> #org.apache.portals.graffito.test.database.password = portal
> #org.apache.portals.graffito.test.jdbc.drivers.path= C:/Program
> Files/PostgreSQL/8.1/jdbc/postgresql-8.1-404.jdbc3.jar
>
>
>
> #org.apache.portals.graffito.production.jetspeed = true
> #org.apache.portals.graffito.production.database.default.name = postgres
> #org.apache.portals.graffito.production.database.url =
> jdbc:postgres://localhost/portal
> #org.apache.portals.graffito.production.database.driver =
> org.postgresql.Driver
> #org.apache.portals.graffito.production.database.user = portal
> #org.apache.portals.graffito.production.database.password = portal
> #org.apache.portals.graffito.production.jdbc.drivers.path = C:/Program
> Files/PostgreSQL/8.1/jdbc/postgresql-8.1-404.jdbc3.jar
>
> Regards,
>
> Raj
>
>
--
Best regards,
Christophe