User:Tspc

From AdempiereWiki

Jump to: navigation, search
Tony's User Boxes
Name This user real name is : Tony Snook
This user has a Sourceforge account.


Contents

[edit]

Introduction

  • My name is Tony Snook and I am from Melbourne, Australia.
  • For the last 14 years I have been employed as the IT Manager for a company that manufactures scientific equipment. Before this I mainly worked as a C Programmer, writing software for embedded systems, Windows and DOS.
  • I have been following the development of Compiere/Adempiere over the last few years and had hoped to implement it at our organization. But due to a lack of resources, the project had to be postponed.
  • I have some experience with Java, Oracle, Postgresql, Redhat Enterprise Server, Fedora, WinXP, Kettle(Pentaho). In the past 12 months I have posted several bugs/solutions and answered questions in forums.
  • My involvement with Adempiere is both as a hobby and some self-education, as I would like to gradually venture back into a programming/developer career.
[edit]

Applying Migration Scripts

The appears to be a number of issues with the current methods of applying migration scripts.

  • Current methods
    • Manually applying each script using tools like
      • (for Oracle) sqlplus, toad, sqldeveloper, ....
      • (for PostgreSQL) psql, pgAdmin, ....
    • Using the ant build scripts which make use of sqlplus for Oracle and psql for PostgreSQL

Problems Include:

  • large number of migration scripts and their size 
 makes it difficult to notice that an error has occured
  • error handling varies depending on the tool and database used 
 SQLPLUS does not return an error code for any SQLPLUS (SP2-xxx) errors
  • rolling back after errors 
 need to ensure that only completely successful scripts are applied and the partially completed script is rolled back.
  • reporting errors 
 person applying the script must be notified that an error has occurred
  • keeping track of which scripts have been applied 
 records need to be kept of which scripts have been applied to the current installation
  • how migration scripts are corrected 
 -correcting a script once it has been committed to trunk can cause problems if someone has already applied the script
 -in some cases it is necessary to apply a script to undo the change and then apply the correct script


[edit]

PL/Java

[edit]

PL/Java Info

(Tested on Fedora 7 (Linux), and Postgresql 8.2.6, PL/Java 1.3.0)

Recent security releases, of Postgresql, have altered the API for SetUserId to include an additional parameter indicating if we're in a security definer context.

  • If you are running any of the following postgresql releases, then you need to upgrade PL/Java
    • 8.0.x where x >= 15
    • 8.1.x where x >= 11
    • 8.2.x where x >= 6 (I needed it and I am running 8.2.5-11) Joseph.brower 11:52, 18 January 2008 (EST)
    • 8.3.x where x >= 0
  • Goto PL/Java CVS Information and check out the latest CVS of PL/Java.
    • Once you have the source, simply build the source with the 'make' comand.
  • If you are upgrading from pljava 1.3.0, then this is a minor upgrade.
  • I simply copied the binaries over the top of the existing installation. 
 cp /build/pljava.jar /usr/var/lib/pljava/
 cp /build/deployer.jar /usr/var/lib/pljava/
 cp /build/objs/pljava.so /usr/var/lib/pljava/
  • su to postgres and restart postgresql 
 su - postgres
 pg_ctl stop
 pg_ctl start
 exit
  • Your PL/Java should now be updated.
[edit]

PL/Java Problems

  • If you are having problems with PL/Java, please check the following: 
 Your postgresql.conf should contain the following lines:
 dynamic_library_path = '\$libdir:/usr/lib/pljava' 
 custom_variable_classes = 'pljava' 
 pljava.classpath = '/usr/lib/pljava/pljava.jar'
 
 Where /usr/lib/pljava is the path to your PL/Java installation (on some systems /opt/pljava ) and contains the following files: 
 deploy.jar
 install.sql
 pljava.jar
 pljava.so
 uninstall.sql
[edit]

PL/Java Links

[edit]

Adempiere-Libero Branch

[edit]

Tasks, Issues And Observations

  • Libero Manufacturing installation documentation out of date and needs to be revised.
    • Wiki needs to be updated to reflect new structure. Libero is now an extension.
  • Libero Manufacturing Manual is out of date and needs to be revised.
[edit]

Adempiere Related Interests

  • Manufacturing Module (Victor's contribution)
  • Data Transformation (Pentaho/Kettle)
  • Bazaar / Community


[edit]

Steps Toward Creating More Contributors and How To Keep Them

Disagreements +1 / Arguments -1
Disagreements are expected in any team environment.
Arguments only make us look unprofessional and turn contributors and clients away.
Remember that we all make mistakes
Even "experts" are not infallible.
It is all part of the learning process and there is always more to learn.
Patience is a virtue
Try to assist 'newbies' in their learning process and encourage them to keep contributing.
We so easily forget we were all beginners at one point in time.
Feedback, Feedback, Feedback
When someone makes a contribution, give them feed back.
  • 'good job'
  • 'perhaps it would be better if you looked at it this way'
  • 'This article in the Wiki might help .....'
Nothing discourages a newcomer more than silence.
Constructive feedback will keep them coming back.
All contributions are priceless
Everyone comes here with different levels of experience and areas of expertise.
We also have various amounts of time available.
If we only value major contributors from the most experienced developers, then the community will slowly fade away.
Firstly because newcomers will not feel welcome and secondly because the same developers are always being left with the bulk of the workload.
Even one solitary contribution is infinitely more than no contribution at all.
[edit]

Interesting Links 

 Database Independence
Retrieved from "http://www.adempiere.com/index.php/User:Tspc"
Personal tools