portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From nick the mytilian <athan...@csd.uoc.gr>
Subject Re: postgres and ant import
Date Mon, 01 Dec 2003 08:14:26 GMT

What are all the files that must someone run, in order to store all the
necessary data to get postgres run with jetspeed?

I mean, turbine-postgres.sql, populate-postgres.sql are the two of them.
What about the security-schema.sql?

What about this IDENTITY in the dbpsml-schema.sql file Is this a bug or
what?

Nik.


On Sun, 30 Nov 2003, Tao Wang wrote:

> I have doubt with the "IDENTITY" in sql script myself. At 1.4-b4, the sql
> code is fine.
> Do a search on google, you may find that the IDENTITY is used for SQL
> server,  it is the same as sequency and equal to serial.
>
> Good luck,
>
> Tao Wang
>
> ----- Original Message -----
> From: "nick the mytilian" <athanasi@csd.uoc.gr>
> To: "Jetspeed Users List" <jetspeed-user@jakarta.apache.org>
> Sent: Friday, November 28, 2003 4:03 PM
> Subject: Re: postgres and ant import
>
>
> > 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
> >
>
>
>
> ---------------------------------------------------------------------
> 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-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org


Mime
View raw message