[prev in list] [next in list] [prev in thread] [next in thread] 

List:       jetspeed-user
Subject:    Re: postgres and ant import
From:       nick the mytilian <athanasi () csd ! uoc ! gr>
Date:       2003-11-28 21:03:23
[Download RAW message or body]

It seems that if you try to populate (psql -d jetspeed < dbpsml-schema.sql)
an error occurs:
ERROR:  parser: parse error at or near "IDENTITY" at character 58


What could be wrong?

Nikos.

On Fri, 28 Nov 2003, Tony(Tao) Wang wrote:

> You have to run
> create the database manully,
> run in postgresql,
>
> src/dbpsml-schema.sql
>
> Then you have the schema to import from ant. After that you should able
> to import.
>
> --
> Tony(Tao) Wang
>
>
> Henrik W. Hansen wrote:
> > Hi
> > I have followed the instuctions on:
> > http://jakarta.apache.org/jetspeed/site/psml_db.html in order to convert
> > to postgresql.
> > Everything seem to work fine. But I am having problems storing the PSML
> > in postgreql.
> > What sould I do after running "ant import".
> > Output is:
> > import:
> >     [java] ***** PSML Importer *****
> >     [java] log4j:WARN No appenders could be found for logger
> > (org.apache.stratu
> > m.component.ComponentLoader).
> >     [java] log4j:WARN Please initialize the log4j system properly.
> >     [java] 250 [main] INFO component.ComponentLoader  - loading
> > component: name
> > =fulcrum class=org.apache.fulcrum.Fulcrum
> > config=.\webapp\WEB-INF\conf\Fulcrum.p
> > roperties
> >     [java] 281 [main] INFO fulcrum.TurbineServices  - Finished
> > initializing all
> > services!
> >     [java] Running with Importer Service: class
> > org.apache.jetspeed.services.ps
> > mlmanager.db.DatabasePsmlManagerService
> >     [java] Running with Exporter Service: class
> > org.apache.jetspeed.services.ps
> > mlmanager.CastorPsmlManagerService
> >     [java] PSMLImporter completed. Exported 24 profiles
> >     [java] **** PSML Importer - completed
> >     [java] Java Result: 1
> >
> > BUILD SUCCESSFUL
> >
> > Should there be any generated SQL files that I have to import into
> > postgresql or what? If ant is supposed to publish the data directly, it
> > seems to fail.
> > I am stuck. Please advice.
> > Best regards Henrik
> >
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
> >
> >
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org

[prev in list] [next in list] [prev in thread] [next in thread]