File:Image1.jpg

From ADempiere ERP Wiki

Jump to: navigation, search

PL/JAVA - SQLJ in PostgreSQL

SQLJ - is used to implement methods java inside the sql corp


  • Create new class in sqlj/src

Image: 640 pixels


  • insert the new method in the new class (the method must be static)

Image: 640 pixels


  • create a new function in PostgreSQL

Image: 640 pixels

Image:Image4.png

  • insert type and name of arguments in the parameters and click in add
  • in definition, insert path of method and type of argument

Image:Image5.png


  • modify sqlj.ddr in …adempiere_stable\sqlj\postgresql

Image: 640 pixels

  • run_build.bat or run_build.sh

  • replace or install the sqlj.jar
    • Example: select sqlj.replace_jar('file:/c:/workspace/adempiere_stable/sqlj/sqlj.jar','sqlj',true);
  • if necessary use set_classpath

Image: 640 pixels

Image: 640 pixels

File history

Click on a date/time to view the file as it appeared at that time.

(Latest | Earliest) View (newer 50) (older 50) (20 | 50 | 100 | 250 | 500)
Date/TimeThumbnailDimensionsUserComment
current11:51, 9 April 2008Thumbnail for version as of 11:51, 9 April 20081,024×768 (172 KB)Esc (Talk | contribs)
(Latest | Earliest) View (newer 50) (older 50) (20 | 50 | 100 | 250 | 500)

There are no pages that link to this file.

Personal tools