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" <[EMAIL PROTECTED]> > To: "Jetspeed Users List" <[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] > > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
