Skip site navigation (1) Skip section navigation (2)

pljava I/O Error

From: Christian Maier <tomtailor(at)freesurf(dot)fr>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: pljava I/O Error
Date: 2008-02-10 09:23:39
Message-ID: (view raw or whole thread)
Lists: pgsql-jdbc

I am not sure if this is the right group, but I did not found a better
fitting one. So I hope you can help me. I have Ubuntu with Postgresql
8.2 running. I try to install pljava and have completed the Steps from sucessfully. But
I have trouble on installing the example.jar (

Welcome to psql 8.2.6, 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

postgres=# SELECT sqlj.install_jar('/usr/lib/postgresql/8.2/pljava/
examples.jar', 'samples',  true);
ERROR:  java.sql.SQLException: I/O exception reading jar file: no
protocol: /usr/lib/postgresql/8.2/pljava/examples.jar

But the file is there:
cikic(at)MrZylinder:~$ ll /usr/lib/postgresql/8.2/pljava/examples.jar
-rw-rw-rw- 1 postgres cikic 42246 2008-02-04 10:32 /usr/lib/postgresql/

My postgres.conf ends with:

#custom_variable_classes = ''           # list of custom variable
class names

dynamic_library_path ='$libdir:/usr/lib/postgresql/8.2/pljava'
custom_variable_classes = 'pljava'

What is the missing thing?

Thank you for help


pgsql-jdbc by date

Next:From: Kris JurkaDate: 2008-02-10 21:07:38
Subject: Re: pljava I/O Error
Previous:From: Oliver JowettDate: 2008-02-10 02:03:18
Subject: Re: proposal: setKeepAlive

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group