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]
