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]
