This night, I am still in our office. While most of our company employee starting to enjoy their Lebaran Holiday, we (IT guys at our company) are still here waiting for our annual task. This task was backup our company data. Personally, I have already finished our own backup task, but not for our teammates. To filling up this spare time, I think it will better if I fill this time with practicing Adempiere ERP.

Times going on and I have excited with this weird things, I could not show list of our product within Adempiere Product Info windows (previously this task was run normally). Oh dear, we are facing problem with our PostgreSQL’s pljava installation.

Running PGAdmin to check pljava functionality with

Select * from rv_openitem

returning this error messages

Could not load library “C:/Program Files/PostgreSQL/8.2/lib/pljava.dll”

It’s time to recheck all of things, why such kind of errors produced within our Adempiere installation. (Imagine that we have live Adempiere installation with our client, and they shouted us with this problem)

I don’t know if this experience applicable to your “could not load library pljava.dll” problem. But with this task, I already fixed this problem within our Windows XP Home with PostgreSQL 8.2.9 installation.

To successfully load PLJAVA.dll library, Windows will check all of dependent modules (most of all is dll also). There are a free tools to check what kind of library which used by our pljava.dll. This tools was dependency walker . Within our installation, this is our dependency list

With this information, pljava requires JVM.dll to working properly.

Emmmm…. Where is our JVM.dll ? Previously, this pljava works but broken recently .

Later, we found this JVM.dll. This is our searching results:

Directory of C:\Java\jdk1.6.0_06\jre\bin\client

03/25/2008 04:28 AM 2,334,720 jvm.dll

1 File(s) 2,334,720 bytes

Directory of C:\Java\jdk1.6.0_06\jre\bin\server

03/25/2008 04:28 AM 3,813,376 jvm.dll

1 File(s) 3,813,376 bytes

With this info, we use jvm.dll from jre\bin\client.

That is the problem. Recently, I have reorganized our windows PATH, and I drop this path by mistake unfortunately.

Luckily, I just add C:\Java\jdk1.6.0_06\jre\bin\client to our windows PATH and re-started our machine. Now, our PostgreSQL could load our pljava.dll successfully. And I have continued my Adempiere journey.

Special thanks to Steve P Miller for his free dependency walker tools.