public inbox for [email protected]
help / color / mirror / Atom feed[Pljava-dev] problem deploying pljava
6+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] problem deploying pljava
@ 2010-05-31 14:20
0 siblings, 2 replies; 6+ messages in thread
From: @ 2010-05-31 14:20 UTC (permalink / raw)
Hi all,
this is the system that I'm using:
Linux fluca-laptop 2.6.31-19-generic #56-Ubuntu SMP Thu Jan 28 02:39:34 UTC
2010 x86_64 GNU/Linux
select version();
version
-------------------------------------------------------------------------------------------------------------
PostgreSQL 8.4.3 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.4.real (Ubuntu
4.4.1-4ubuntu9) 4.4.1, 64-bit
(1 row)
I've downloaded the pljava1.4 64 bit version, I've uncompressed and checked
that the pljava.so library is ready to work:
$ ldd pljava.so
linux-vdso.so.1 => (0x00007fff180bf000)
libjvm.so => /usr/lib/jvm/java-6-
sun-1.6.0.20/jre/lib/amd64/server/libjvm.so (0x00007f0b46a34000)
libc.so.6 => /lib/libc.so.6 (0x00007f0b466c5000)
libm.so.6 => /lib/libm.so.6 (0x00007f0b46440000)
libdl.so.2 => /lib/libdl.so.2 (0x00007f0b4623c000)
libpthread.so.0 => /lib/libpthread.so.0 (0x00007f0b46020000)
/lib64/ld-linux-x86-64.so.2 (0x00007f0b47707000)
Since I'm using the java vm provided by my Ubuntu distro, I've placed the
following lines in the ld.conf.so:
/usr/lib/jvm/java-6-sun-1.6.0.20/jre/lib/amd64/server/
/usr/lib/jvm/java-6-sun-1.6.0.20/jre/lib/amd64/native_threads/
and restarted the postmaster.
Now I believe I've configured everything, but when I try to run the deploy
program I get an PSQLException that pljava.so cannot be loaded:
org.postgresql.util.PSQLException: ERROR: could not load library
"/sviluppo/java/pljava/pljava.so": /sviluppo/java/pljava/pljava.so: undefined
symbol: global_timezone
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:328)
at
org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:474)
at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:269)
and in the server logs I found the following that is the same error:
ERROR: could not load library "/sviluppo/java/pljava/pljava.so":
/sviluppo/java/pljava/pljava.so: undefined symbol: global_timezone
Any idea about how to configure pljava on the system?
Thanks,
Luca
^ permalink raw reply [nested|flat] 6+ messages in thread
* [Pljava-dev] problem deploying pljava
@ 2010-05-31 23:30
parent:
1 sibling, 0 replies; 6+ messages in thread
From: @ 2010-05-31 23:30 UTC (permalink / raw)
On 5/31/2010 7:20 AM, Luca Ferrari wrote:
> Hi all,
> PostgreSQL 8.4.3 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.4.real (Ubuntu
> 4.4.1-4ubuntu9) 4.4.1, 64-bit
> (1 row)
>
> I've downloaded the pljava1.4 64 bit version
>
The pljava binaries need to be built for specific postgresql versions,
so you've downloaded a version for something other than 8.4 because the
1.4 release doesn't work with the 8.4 version. To get a pljava that
works for 8.4 you need to build it yourself from CVS.
Kris Jurka
^ permalink raw reply [nested|flat] 6+ messages in thread
* [Pljava-dev] problem deploying pljava
@ 2010-06-01 03:28
parent:
1 sibling, 0 replies; 6+ messages in thread
From: @ 2010-06-01 03:28 UTC (permalink / raw)
Hi all,
I think u've already installed the postgresql previous version.so that's
postgres instance is removed
from registry.
Thanks and regards
On Mon, May 31, 2010 at 7:50 PM, Luca Ferrari <fluca1978 at infinito.it> wrote:
> Hi all,
> this is the system that I'm using:
>
>
> Linux fluca-laptop 2.6.31-19-generic #56-Ubuntu SMP Thu Jan 28 02:39:34 UTC
> 2010 x86_64 GNU/Linux
>
> select version();
> version
>
> -------------------------------------------------------------------------------------------------------------
> PostgreSQL 8.4.3 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.4.real
> (Ubuntu
> 4.4.1-4ubuntu9) 4.4.1, 64-bit
> (1 row)
>
> I've downloaded the pljava1.4 64 bit version, I've uncompressed and checked
> that the pljava.so library is ready to work:
>
> $ ldd pljava.so
> linux-vdso.so.1 => (0x00007fff180bf000)
> libjvm.so => /usr/lib/jvm/java-6-
> sun-1.6.0.20/jre/lib/amd64/server/libjvm.so (0x00007f0b46a34000)
> libc.so.6 => /lib/libc.so.6 (0x00007f0b466c5000)
> libm.so.6 => /lib/libm.so.6 (0x00007f0b46440000)
> libdl.so.2 => /lib/libdl.so.2 (0x00007f0b4623c000)
> libpthread.so.0 => /lib/libpthread.so.0 (0x00007f0b46020000)
> /lib64/ld-linux-x86-64.so.2 (0x00007f0b47707000)
>
>
> Since I'm using the java vm provided by my Ubuntu distro, I've placed the
> following lines in the ld.conf.so:
>
> /usr/lib/jvm/java-6-sun-1.6.0.20/jre/lib/amd64/server/
> /usr/lib/jvm/java-6-sun-1.6.0.20/jre/lib/amd64/native_threads/
>
> and restarted the postmaster.
> Now I believe I've configured everything, but when I try to run the deploy
> program I get an PSQLException that pljava.so cannot be loaded:
>
> org.postgresql.util.PSQLException: ERROR: could not load library
> "/sviluppo/java/pljava/pljava.so": /sviluppo/java/pljava/pljava.so:
> undefined
> symbol: global_timezone
> at
>
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
> at
>
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
> at
>
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
> at
>
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
> at
>
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336)
> at
>
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:328)
> at
> org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:474)
> at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:269)
>
> and in the server logs I found the following that is the same error:
>
> ERROR: could not load library "/sviluppo/java/pljava/pljava.so":
> /sviluppo/java/pljava/pljava.so: undefined symbol: global_timezone
>
>
> Any idea about how to configure pljava on the system?
>
> Thanks,
> Luca
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev
>
--
Chnvv Raghavendra
Mobile:9908898985
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20100601/e43c4512/attachment.html;
^ permalink raw reply [nested|flat] 6+ messages in thread
* [Pljava-dev] problem deploying pljava
@ 2010-06-01 07:06
0 siblings, 1 reply; 6+ messages in thread
From: @ 2010-06-01 07:06 UTC (permalink / raw)
On Tuesday 01 June 2010 01:30:55 am your cat, walking on the keyboard, wrote:
> The pljava binaries need to be built for specific postgresql versions,
> so you've downloaded a version for something other than 8.4 because the
> 1.4 release doesn't work with the 8.4 version. To get a pljava that
> works for 8.4 you need to build it yourself from CVS.
Uhm...I'm getting the following list of errors (all referred to the jdbc
subpackage), any idea?
$ make all
make[1]: Entering directory
`/sviluppo/java/pljava/org.postgresql.pljava/build/classes/pljava'
javac -source 1.4 -target 1.4 -d . <java sources>
/sviluppo/java/pljava/org.postgresql.pljava/src/java/pljava/org/postgresql/pljava/jdbc/ObjectResultSet.java:290:
reference to updateBlob is ambiguous, both method
updateBlob(int,java.sql.Blob) in java.sql.ResultSet and method
updateBlob(int,java.io.InputStream) in java.sql.ResultSet match
this.updateBlob(columnIndex, new BlobValue(x, length));
^
/sviluppo/java/pljava/org.postgresql.pljava/src/java/pljava/org/postgresql/pljava/jdbc/ObjectResultSet.java:320:
reference to updateClob is ambiguous, both method
updateClob(int,java.sql.Clob) in java.sql.ResultSet and method
updateClob(int,java.io.Reader) in java.sql.ResultSet match
this.updateClob(columnIndex, new ClobValue(x, length));
^
/sviluppo/java/pljava/org.postgresql.pljava/src/java/pljava/org/postgresql/pljava/jdbc/TriggerResultSet.java:22:
org.postgresql.pljava.jdbc.TriggerResultSet is not abstract and does not
override abstract method updateNClob(java.lang.String,java.io.Reader) in
java.sql.ResultSet
public class TriggerResultSet extends SingleRowResultSet
^
/sviluppo/java/pljava/org.postgresql.pljava/src/java/pljava/org/postgresql/pljava/jdbc/SyntheticResultSetMetaData.java:20:
org.postgresql.pljava.jdbc.SyntheticResultSetMetaData is not abstract and does
not override abstract method isWrapperFor(java.lang.Class) in java.sql.Wrapper
public class SyntheticResultSetMetaData extends AbstractResultSetMetaData
^
/sviluppo/java/pljava/org.postgresql.pljava/src/java/pljava/org/postgresql/pljava/jdbc/SPIResultSetMetaData.java:21:
org.postgresql.pljava.jdbc.SPIResultSetMetaData is not abstract and does not
override abstract method isWrapperFor(java.lang.Class) in java.sql.Wrapper
public class SPIResultSetMetaData extends AbstractResultSetMetaData
^
/sviluppo/java/pljava/org.postgresql.pljava/src/java/pljava/org/postgresql/pljava/jdbc/SPIConnection.java:42:
org.postgresql.pljava.jdbc.SPIConnection is not abstract and does not override
abstract method createStruct(java.lang.String,java.lang.Object[]) in
java.sql.Connection
public class SPIConnection implements Connection
^
/sviluppo/java/pljava/org.postgresql.pljava/src/java/pljava/org/postgresql/pljava/jdbc/SPIResultSet.java:27:
org.postgresql.pljava.jdbc.SPIResultSet is not abstract and does not override
abstract method updateNClob(java.lang.String,java.io.Reader) in
java.sql.ResultSet
public class SPIResultSet extends ResultSetBase
^
/sviluppo/java/pljava/org.postgresql.pljava/src/java/pljava/org/postgresql/pljava/jdbc/SPIStatement.java:25:
org.postgresql.pljava.jdbc.SPIStatement is not abstract and does not override
abstract method isPoolable() in java.sql.Statement
public class SPIStatement implements Statement
^
/sviluppo/java/pljava/org.postgresql.pljava/src/java/pljava/org/postgresql/pljava/jdbc/SPIDatabaseMetaData.java:19:
org.postgresql.pljava.jdbc.SPIDatabaseMetaData is not abstract and does not
override abstract method
getFunctionColumns(java.lang.String,java.lang.String,java.lang.String,java.lang.String)
in java.sql.DatabaseMetaData
public class SPIDatabaseMetaData implements DatabaseMetaData
^
/sviluppo/java/pljava/org.postgresql.pljava/src/java/pljava/org/postgresql/pljava/jdbc/SQLInputFromTuple.java:34:
org.postgresql.pljava.jdbc.SQLInputFromTuple is not abstract and does not
override abstract method readRowId() in java.sql.SQLInput
public class SQLInputFromTuple extends JavaWrapper implements SQLInput
^
/sviluppo/java/pljava/org.postgresql.pljava/src/java/pljava/org/postgresql/pljava/jdbc/BlobValue.java:20:
org.postgresql.pljava.jdbc.BlobValue is not abstract and does not override
abstract method getBinaryStream(long,long) in java.sql.Blob
public class BlobValue extends InputStream implements Blob
^
/sviluppo/java/pljava/org.postgresql.pljava/src/java/pljava/org/postgresql/pljava/jdbc/SPIParameterMetaData.java:16:
org.postgresql.pljava.jdbc.SPIParameterMetaData is not abstract and does not
override abstract method isWrapperFor(java.lang.Class) in java.sql.Wrapper
public class SPIParameterMetaData implements ParameterMetaData
^
/sviluppo/java/pljava/org.postgresql.pljava/src/java/pljava/org/postgresql/pljava/jdbc/SingleRowReader.java:22:
org.postgresql.pljava.jdbc.SingleRowReader is not abstract and does not
override abstract method updateNClob(java.lang.String,java.io.Reader) in
java.sql.ResultSet
public class SingleRowReader extends SingleRowResultSet
^
/sviluppo/java/pljava/org.postgresql.pljava/src/java/pljava/org/postgresql/pljava/jdbc/SPIPreparedStatement.java:38:
org.postgresql.pljava.jdbc.SPIPreparedStatement is not abstract and does not
override abstract method setNClob(int,java.io.Reader) in
java.sql.PreparedStatement
public class SPIPreparedStatement extends SPIStatement implements
PreparedStatement
^
/sviluppo/java/pljava/org.postgresql.pljava/src/java/pljava/org/postgresql/pljava/jdbc/SQLInputFromChunk.java:40:
org.postgresql.pljava.jdbc.SQLInputFromChunk is not abstract and does not
override abstract method readRowId() in java.sql.SQLInput
public class SQLInputFromChunk implements SQLInput
^
/sviluppo/java/pljava/org.postgresql.pljava/src/java/pljava/org/postgresql/pljava/jdbc/SQLOutputToTuple.java:35:
org.postgresql.pljava.jdbc.SQLOutputToTuple is not abstract and does not
override abstract method writeSQLXML(java.sql.SQLXML) in java.sql.SQLOutput
public class SQLOutputToTuple implements SQLOutput
^
/sviluppo/java/pljava/org.postgresql.pljava/src/java/pljava/org/postgresql/pljava/jdbc/SingleRowWriter.java:26:
org.postgresql.pljava.jdbc.SingleRowWriter is not abstract and does not
override abstract method updateNClob(java.lang.String,java.io.Reader) in
java.sql.ResultSet
public class SingleRowWriter extends SingleRowResultSet
^
/sviluppo/java/pljava/org.postgresql.pljava/src/java/pljava/org/postgresql/pljava/jdbc/ClobValue.java:23:
org.postgresql.pljava.jdbc.ClobValue is not abstract and does not override
abstract method getCharacterStream(long,long) in java.sql.Clob
public class ClobValue extends Reader implements Clob
^
/sviluppo/java/pljava/org.postgresql.pljava/src/java/pljava/org/postgresql/pljava/jdbc/SyntheticResultSet.java:21:
org.postgresql.pljava.jdbc.SyntheticResultSet is not abstract and does not
override abstract method updateNClob(java.lang.String,java.io.Reader) in
java.sql.ResultSet
public class SyntheticResultSet extends ResultSetBase
^
/sviluppo/java/pljava/org.postgresql.pljava/src/java/pljava/org/postgresql/pljava/jdbc/SQLOutputToChunk.java:42:
org.postgresql.pljava.jdbc.SQLOutputToChunk is not abstract and does not
override abstract method writeSQLXML(java.sql.SQLXML) in java.sql.SQLOutput
public class SQLOutputToChunk implements SQLOutput
^
20 errors
make[1]: *** [.timestamp] Error 1
make[1]: Leaving directory
`/sviluppo/java/pljava/org.postgresql.pljava/build/classes/pljava'
make: *** [pljava_all] Error 2
^ permalink raw reply [nested|flat] 6+ messages in thread
* [Pljava-dev] problem deploying pljava
@ 2010-06-01 15:31
parent:
0 siblings, 0 replies; 6+ messages in thread
From: @ 2010-06-01 15:31 UTC (permalink / raw)
On 6/1/2010 12:06 AM, Luca Ferrari wrote:
> On Tuesday 01 June 2010 01:30:55 am your cat, walking on the keyboard, wrote:
>> The pljava binaries need to be built for specific postgresql versions,
>> so you've downloaded a version for something other than 8.4 because the
>> 1.4 release doesn't work with the 8.4 version. To get a pljava that
>> works for 8.4 you need to build it yourself from CVS.
>
>
> Uhm...I'm getting the following list of errors (all referred to the jdbc
> subpackage), any idea?
>
You must build with a 1.4 or 1.5 JDK. It does not support JDK 1.6 at
the present.
Kris Jurka
^ permalink raw reply [nested|flat] 6+ messages in thread
* [Pljava-dev] problem deploying pljava
@ 2010-06-03 06:41
0 siblings, 0 replies; 6+ messages in thread
From: @ 2010-06-03 06:41 UTC (permalink / raw)
On Tuesday 01 June 2010 05:31:46 pm your cat, walking on the keyboard, wrote:
> You must build with a 1.4 or 1.5 JDK. It does not support JDK 1.6 at
> the present.
Thanks, I've downloaded a 1.5 jdk and compiled, now it works!
Thank you guys for this great piece of code.
Luca
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2010-06-03 06:41 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-05-31 14:20 [Pljava-dev] problem deploying pljava
2010-05-31 23:30 `
2010-06-01 03:28 `
2010-06-01 07:06 [Pljava-dev] problem deploying pljava
2010-06-01 15:31 `
2010-06-03 06:41 [Pljava-dev] problem deploying pljava
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox