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/02 10:14:43 UTC

Graffito build failure with PostgreSQL 8.1

Hi,

I am trying to build Graffito on Jetspeed 2.0.1 Branch. Build fails with
following message:

==================Build error messages===========================
test:test:
test.dbsetup:
    [copy] Copying 1 file to
C:\Projects\graffito\components\target\test-classes

    [echo] driver path : C:/Program Files/PostgreSQL/8.1/jdbc/postgresql-
8.1-404
.jdbc3.jar

db.reinit.test:
db.test.properties:
    [echo] org.apache.portals.graffito.test.database.default.name : postgres
    [echo] org.apache.portals.graffito.test.database.url :
jdbc:postgres://local
host/portal
    [echo] org.apache.portals.graffito.test.database.driver :
org.postgresql.Dri
ver
    [echo] org.apache.portals.graffito.test.database.user : portal
    [echo] org.apache.portals.graffito.test.database.password : portal
    [echo] org.apache.portals.graffito.test.database.path : C:/Program
Files/Pos
tgreSQL/8.1/jdbc/postgresql-8.1-404.jdbc3.jar
    [echo] org.apache.portals.graffito.test.jetspeed : true

db.scripts.gen:
torque:init:

    [echo] Generating SQL schema creation scripts for postgres
    [torque-sql] Using classpath
    [torque-sql] Generating to file
C:\Projects\graffito\components\target\src\s
ql\postgres\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: 34 seconds


================== Relevent portion of
velocity.log======================================
2006-02-02 15:34:43,551 - Velocimacro : initialization starting.
2006-02-02 15:34:43,551 - Velocimacro : adding VMs from VM library template
: VM_global_library.vm
2006-02-02 15:34:43,551 - ResourceManager : unable to find resource
'VM_global_library.vm' in any resource loader.
2006-02-02 15:34:43,551 - 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-02 15:34:43,551 - Velocimacro :  VM library template macro
registration complete.
2006-02-02 15:34:43,551 - Velocimacro : allowInline = true : VMs can be
defined inline in templates
2006-02-02 15:34:43,551 - Velocimacro : allowInlineToOverride = false : VMs
defined inline may NOT replace previous VM definitions
2006-02-02 15:34:43,551 - Velocimacro : allowInlineLocal = false : VMs
defined inline will be  global in scope if allowed.
2006-02-02 15:34:43,551 - Velocimacro : messages on  : VM system will output
logging messages
2006-02-02 15:34:43,551 - Velocimacro : autoload off  : VM system will not
automatically reload global library macros
2006-02-02 15:34:43,551 - Velocimacro : initialization complete.
2006-02-02 15:34:43,551 - Velocity successfully started.
2006-02-02 15:34:43,786 - ResourceManager : found sql/base/Control.vm with
loader org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader
2006-02-02 15:34:43,801 - ResourceManager : unable to find resource
'sql/base/postgres/table.vm' in any resource loader.
2006-02-02 15:34:43,801 - Method parse threw exception for reference
$generator in template sql/base/Control.vm at  [35,7]


Can someone point me what wrong I am doing?

Regards,

Raj

Re: Graffito build failure with PostgreSQL 8.1

Posted by Raj Saini <ra...@gmail.com>.
I just wanted to know how the SQL is generated? Is there any xml schema for
SQL generation? Just point me to any pointers available for SQL generation.

I will look into it during weekend.

Regards,

Raj



On 2/3/06, Christophe Lombart <ch...@gmail.com> wrote:
>
> ok - thanks !
> what kind of information are you looking for :-) ?
> Did you already review the maven goals present in the components
> subproject ?
> In order to generate the SQL scripts, we use the Torque maven plugin.
> It seems this plugin gives the error - following your previous mail :
>
> 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: 34 seconds
>
> Torque uses some templates to generate the sql scripts. Maybe one of
> them is not correct. This just one idea.
>
>
>
>
> On 2/3/06, Raj Saini <ra...@gmail.com> wrote:
> > If you can give some guidelines, I can try to fix it and send the patch.
> >
> > Regards,
> >
> > Raj
> >
> > On 2/3/06, Christophe Lombart <ch...@gmail.com> wrote:
> > >
> > > Thanks for the feedback. It seems that is in the Postgesql support in
> > > Torque. I will add this issue in Jira. Sorry I have no time to work on
> > > it now.
> > >
> > >
> > > --
> > > Best regards,
> > >
> > > Christophe
> > >
> >
> >
>
>
> --
> Best regards,
>
> Christophe
>

Re: Graffito build failure with PostgreSQL 8.1

Posted by Raj Saini <ra...@gmail.com>.
Hi Christophe,

I thought of building with known db before I try on postgress and there 
for I was building graffito using HSQL db. I am facing exactly same 
problem what I reported before. Is Graffito known to build on HSQL?

Regards,

Raj


Christophe Lombart wrote:

>Raj,
>
>The xml files used to defined the db structure are in components/src/schema.
>The vm use by torque should be in the torque plugin jars (/[your maven
>repo folder ]/repository/torque/jars/torque-gen-templates-3.2.jar).
>
>I found more informantion on the Torque site for Postgres. Maybe it can help :
>http://db.apache.org/torque/runtime/postgres-howto.html
>
>Thanks for your contribution !
>
>On 2/3/06, Raj Saini <ra...@gmail.com> wrote:
>  
>
>>Christophe,
>>
>>I had a look on the maven goal in the components subproject. It looks to me
>>torque:init goal is failing for want of table.vm file. I dont see any
>>sql/base folder in the source tree. Any idea where it could be?
>>
>>Regards,
>>
>>Raj
>>
>>On 2/3/06, Christophe Lombart <ch...@gmail.com> wrote:
>>    
>>
>>>ok - thanks !
>>>what kind of information are you looking for :-) ?
>>>Did you already review the maven goals present in the components
>>>subproject ?
>>>In order to generate the SQL scripts, we use the Torque maven plugin.
>>>It seems this plugin gives the error - following your previous mail :
>>>
>>>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: 34 seconds
>>>
>>>Torque uses some templates to generate the sql scripts. Maybe one of
>>>them is not correct. This just one idea.
>>>
>>>
>>>
>>>
>>>On 2/3/06, Raj Saini <ra...@gmail.com> wrote:
>>>      
>>>
>>>>If you can give some guidelines, I can try to fix it and send the patch.
>>>>
>>>>Regards,
>>>>
>>>>Raj
>>>>
>>>>On 2/3/06, Christophe Lombart <ch...@gmail.com> wrote:
>>>>        
>>>>
>>>>>Thanks for the feedback. It seems that is in the Postgesql support in
>>>>>Torque. I will add this issue in Jira. Sorry I have no time to work on
>>>>>it now.
>>>>>
>>>>>
>>>>>--
>>>>>Best regards,
>>>>>
>>>>>Christophe
>>>>>
>>>>>          
>>>>>
>>>>        
>>>>
>>>--
>>>Best regards,
>>>
>>>Christophe
>>>
>>>      
>>>
>>    
>>
>
>
>--
>Best regards,
>
>Christophe
>
>  
>


Re: Graffito build failure with PostgreSQL 8.1

Posted by Christophe Lombart <ch...@gmail.com>.
Raj,

The xml files used to defined the db structure are in components/src/schema.
The vm use by torque should be in the torque plugin jars (/[your maven
repo folder ]/repository/torque/jars/torque-gen-templates-3.2.jar).

I found more informantion on the Torque site for Postgres. Maybe it can help :
http://db.apache.org/torque/runtime/postgres-howto.html

Thanks for your contribution !

On 2/3/06, Raj Saini <ra...@gmail.com> wrote:
> Christophe,
>
> I had a look on the maven goal in the components subproject. It looks to me
> torque:init goal is failing for want of table.vm file. I dont see any
> sql/base folder in the source tree. Any idea where it could be?
>
> Regards,
>
> Raj
>
> On 2/3/06, Christophe Lombart <ch...@gmail.com> wrote:
> >
> > ok - thanks !
> > what kind of information are you looking for :-) ?
> > Did you already review the maven goals present in the components
> > subproject ?
> > In order to generate the SQL scripts, we use the Torque maven plugin.
> > It seems this plugin gives the error - following your previous mail :
> >
> > 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: 34 seconds
> >
> > Torque uses some templates to generate the sql scripts. Maybe one of
> > them is not correct. This just one idea.
> >
> >
> >
> >
> > On 2/3/06, Raj Saini <ra...@gmail.com> wrote:
> > > If you can give some guidelines, I can try to fix it and send the patch.
> > >
> > > Regards,
> > >
> > > Raj
> > >
> > > On 2/3/06, Christophe Lombart <ch...@gmail.com> wrote:
> > > >
> > > > Thanks for the feedback. It seems that is in the Postgesql support in
> > > > Torque. I will add this issue in Jira. Sorry I have no time to work on
> > > > it now.
> > > >
> > > >
> > > > --
> > > > Best regards,
> > > >
> > > > Christophe
> > > >
> > >
> > >
> >
> >
> > --
> > Best regards,
> >
> > Christophe
> >
>
>


--
Best regards,

Christophe

Re: Graffito build failure with PostgreSQL 8.1

Posted by Raj Saini <ra...@gmail.com>.
Christophe,

I had a look on the maven goal in the components subproject. It looks to me
torque:init goal is failing for want of table.vm file. I dont see any
sql/base folder in the source tree. Any idea where it could be?

Regards,

Raj

On 2/3/06, Christophe Lombart <ch...@gmail.com> wrote:
>
> ok - thanks !
> what kind of information are you looking for :-) ?
> Did you already review the maven goals present in the components
> subproject ?
> In order to generate the SQL scripts, we use the Torque maven plugin.
> It seems this plugin gives the error - following your previous mail :
>
> 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: 34 seconds
>
> Torque uses some templates to generate the sql scripts. Maybe one of
> them is not correct. This just one idea.
>
>
>
>
> On 2/3/06, Raj Saini <ra...@gmail.com> wrote:
> > If you can give some guidelines, I can try to fix it and send the patch.
> >
> > Regards,
> >
> > Raj
> >
> > On 2/3/06, Christophe Lombart <ch...@gmail.com> wrote:
> > >
> > > Thanks for the feedback. It seems that is in the Postgesql support in
> > > Torque. I will add this issue in Jira. Sorry I have no time to work on
> > > it now.
> > >
> > >
> > > --
> > > Best regards,
> > >
> > > Christophe
> > >
> >
> >
>
>
> --
> Best regards,
>
> Christophe
>

Re: Graffito build failure with PostgreSQL 8.1

Posted by Christophe Lombart <ch...@gmail.com>.
ok - thanks !
what kind of information are you looking for :-) ?
Did you already review the maven goals present in the components subproject ?
In order to generate the SQL scripts, we use the Torque maven plugin.
It seems this plugin gives the error - following your previous mail :

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: 34 seconds

Torque uses some templates to generate the sql scripts. Maybe one of
them is not correct. This just one idea.




On 2/3/06, Raj Saini <ra...@gmail.com> wrote:
> If you can give some guidelines, I can try to fix it and send the patch.
>
> Regards,
>
> Raj
>
> On 2/3/06, Christophe Lombart <ch...@gmail.com> wrote:
> >
> > Thanks for the feedback. It seems that is in the Postgesql support in
> > Torque. I will add this issue in Jira. Sorry I have no time to work on
> > it now.
> >
> >
> > --
> > Best regards,
> >
> > Christophe
> >
>
>


--
Best regards,

Christophe

Re: Graffito build failure with PostgreSQL 8.1

Posted by Raj Saini <ra...@gmail.com>.
If you can give some guidelines, I can try to fix it and send the patch.

Regards,

Raj

On 2/3/06, Christophe Lombart <ch...@gmail.com> wrote:
>
> Thanks for the feedback. It seems that is in the Postgesql support in
> Torque. I will add this issue in Jira. Sorry I have no time to work on
> it now.
>
>
> --
> Best regards,
>
> Christophe
>

Re: Graffito build failure with PostgreSQL 8.1

Posted by Christophe Lombart <ch...@gmail.com>.
Thanks for the feedback. It seems that is in the Postgesql support in
Torque. I will add this issue in Jira. Sorry I have no time to work on
it now.


--
Best regards,

Christophe