pljava on windows

2005-10-11
2013-05-02
  • Jesper Vels
    Jesper Vels
    2005-10-11

    Hi

    Does someone have a recipe how to install pljava on windows xp pro, and import the Kompiere db dumpe?

    Best Regrads
    Jesper Vels
    Denmark

     
    • Hi Jesper!

      You can restore backup this way:

      psql -U compiere kompiere < data/cmpcs.dmp

      You can see user guide to load pljava here:

      http://gborg.postgresql.org/project/pljava/genpage.php?userguide

      this is my example for install pljava:

      java -cp  $PG_HOME/jlib/deploy.jar:$PG_HOME/jdbc/lib/postgresql-8.0-311.j
      dbc3.jar  org.postgresql.pljava.deploy.Deployer -install -user compiere -databas
      e kompiere

      next:

      psql -U compiere kompiere

      Welcome to psql 8.0.3, the PostgreSQL interactive terminal.

      Type:  \copyright for distribution terms
             \h for help with SQL commands
             \? for help with psql commands
             \g or terminate with semicolon to execute query
             \q to quit

      kompiere=# SELECT sqlj.install_jar('file:///app/compiere/e-evolution/252d/sqlj/sqlj.jar', 'sqlj', true);
      SELECT sqlj.set_classpath('compiere', 'sqlj');

      Ready ;-)

      Cheers
      Victor Perez
      www.e-evolution.com

       
    • Jesper Vels
      Jesper Vels
      2005-10-11

      Do Kompiere need PLjava for running? or just for install sql dump?

      /Jesper Vels
      Denmark

       
    • Pljava is implementation of SQLJ all plsql of oracle function was migrated to java, for this reason you need pljava to kompiere work well.

      the dump restores pljava with the original environment,  you need to reinstall pljava to have your environment.

      Cheers
      Victor

       
    • Jesper Vels
      Jesper Vels
      2005-10-11

      Hi

      I would donate $50 to you (Victor Prez Jurez) if I get a step by step guide how to install Kompiere CMPCS on windows xp with postgres or on Fedora core 4 with postgres

      I have tryed the last 2 days to install Kompiere, and now give up, there for I want to pay you :-)

      Best Regrads
      Jesper Vels
      Denmark

       
    • Hi Jesper!!

      please contact me via msn vpj-cd@hotmail.com or skype vpj-cd, I will be glad to help you, to donate only make a transfer via paypal to our account oscar.gomez@e-evolution.com

      Cheers
      Victor