Lists: | pgsql-jdbc |
---|
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: | 43113e0a-2e9b-4262-ae27-217b76351f65@d4g2000prg.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-jdbc |
Hi
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
http://wiki.tada.se/display/pljava/Posix+Installation sucessfully. But
I have trouble on installing the example.jar ( http://wiki.tada.se/display/pljava/Sample+Tests
)
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/
8.2/pljava/examples.jar
My postgres.conf ends with:
#---------------------------------------------------------------------------
# CUSTOMIZED OPTIONS
#---------------------------------------------------------------------------
#custom_variable_classes = '' # list of custom variable
class names
#pljava
dynamic_library_path ='$libdir:/usr/lib/postgresql/8.2/pljava'
pljava.classpath='/usr/lib/postgresql/8.2/pljava/pljava.jar'
custom_variable_classes = 'pljava'
What is the missing thing?
Thank you for help
Christian
From: | Kris Jurka <books(at)ejurka(dot)com> |
---|---|
To: | Christian Maier <tomtailor(at)freesurf(dot)fr> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: pljava I/O Error |
Date: | 2008-02-10 21:07:38 |
Message-ID: | Pine.BSO.4.64.0802101605480.12270@leary.csoft.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-jdbc |
On Sun, 10 Feb 2008, Christian Maier wrote:
> I am not sure if this is the right group, but I did not found a better
> fitting one.
The correct list is pljava-dev(at)pgfoundry(dot)org(dot) This list is for the client
JDBC driver only.
> I have trouble on installing the example.jar (
> http://wiki.tada.se/display/pljava/Sample+Tests )
>
> 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
>
The page you reference uses the prefix 'file://' to indicate the protocol
used to retrieve the desired jar file. You're missing this in your
version.
Kris Jurka