Hola de nuevo, gracias por tu atención. Ya revise y tengo el archivo pljava.so en la ruta adecuada pero me sigue saliendo un error similar al anterior:
[postgres@localhost lib]$ psql -d postgres -f install.sql
ERROR: schema “sqlj” already exists
STATEMENT: CREATE SCHEMA sqlj;
psql:install.sql:1: ERROR: schema “sqlj” already exists
GRANT
ERROR: could not load library “/usr/local/pgsql/lib/pljava.so”: libjvm.so: no se puede abrir el fichero del objeto compartido: No existe el fichero o el directorio
STATEMENT: CREATE FUNCTION sqlj.java_call_handler()
RETURNS language_handler AS ‘pljava’
LANGUAGE C;
psql:install.sql:6: ERROR: could not load library “/usr/local/pgsql/lib/pljava.so”: libjvm.so: no se puede abrir el fichero del objeto compartido: No existe el fichero o el directorio
ERROR: function sqlj.java_call_handler() does not exist
STATEMENT: CREATE TRUSTED LANGUAGE java HANDLER sqlj.java_call_handler;
psql:install.sql:8: ERROR: function sqlj.java_call_handler() does not exist
ERROR: could not load library “/usr/local/pgsql/lib/pljava.so”: libjvm.so: no se puede abrir el fichero del objeto compartido: No existe el fichero o el directorio
STATEMENT: CREATE FUNCTION sqlj.javau_call_handler()
RETURNS language_handler AS ‘pljava’
LANGUAGE C;
psql:install.sql:12: ERROR: could not load library “/usr/local/pgsql/lib/pljava.so”: libjvm.so: no se puede abrir el fichero del objeto compartido: No existe el fichero o el directorio
ERROR: function sqlj.javau_call_handler() does not exist
STATEMENT: CREATE LANGUAGE javaU HANDLER sqlj.javau_call_handler;
psql:install.sql:14: ERROR: function sqlj.javau_call_handler() does not exist
NOTICE: CREATE TABLE will create implicit sequence “jar_repository_jarid_seq1” for serial column “jar_repository.jarid”
psql:install.sql:23: NOTICE: CREATE TABLE will create implicit sequence “jar_repository_jarid_seq1” for serial column “jar_repository.jarid”
ERROR: relation “jar_repository” already exists
STATEMENT: CREATE TABLE sqlj.jar_repository(
jarId SERIAL PRIMARY KEY,
jarName VARCHAR(100) UNIQUE NOT NULL,
jarOrigin VARCHAR(500) NOT NULL,
jarOwner NAME NOT NULL,
jarManifest TEXT,
deploymentDesc INT
);
psql:install.sql:23: ERROR: relation “jar_repository” already exists
GRANT
NOTICE: CREATE TABLE will create implicit sequence “jar_entry_entryid_seq1” for serial column “jar_entry.entryid”
psql:install.sql:32: NOTICE: CREATE TABLE will create implicit sequence “jar_entry_entryid_seq1” for serial column “jar_entry.entryid”
ERROR: relation “jar_entry” already exists
STATEMENT: CREATE TABLE sqlj.jar_entry(
entryId SERIAL PRIMARY KEY,
entryName VARCHAR(200) NOT NULL,
jarId INT NOT NULL REFERENCES sqlj.jar_repository ON DELETE CASCADE,
entryImage BYTEA NOT NULL,
UNIQUE(jarId, entryName)
);
psql:install.sql:32: ERROR: relation “jar_entry” already exists
GRANT
ALTER TABLE
ERROR: relation “classpath_entry” already exists
STATEMENT: CREATE TABLE sqlj.classpath_entry(
schemaName VARCHAR(30) NOT NULL,
ordinal INT2 NOT NULL,
jarId INT NOT NULL REFERENCES sqlj.jar_repository ON DELETE CASCADE,
PRIMARY KEY(schemaName, ordinal)
);
psql:install.sql:43: ERROR: relation “classpath_entry” already exists
GRANT
NOTICE: CREATE TABLE will create implicit sequence “typemap_entry_mapid_seq1” for serial column “typemap_entry.mapid”
psql:install.sql:50: NOTICE: CREATE TABLE will create implicit sequence “typemap_entry_mapid_seq1” for serial column “typemap_entry.mapid”
ERROR: relation “typemap_entry” already exists
STATEMENT: CREATE TABLE sqlj.typemap_entry(
mapId SERIAL PRIMARY KEY,
javaName VARCHAR(200) NOT NULL,
sqlName NAME NOT NULL
);
psql:install.sql:50: ERROR: relation “typemap_entry” already exists
GRANT
ERROR: language “java” does not exist
STATEMENT: CREATE FUNCTION sqlj.install_jar(VARCHAR, VARCHAR, BOOLEAN) RETURNS void
AS ‘org.postgresql.pljava.management.Commands.installJar’
LANGUAGE java SECURITY DEFINER;
psql:install.sql:55: ERROR: language “java” does not exist
ERROR: language “java” does not exist
STATEMENT: CREATE FUNCTION sqlj.install_jar(BYTEA, VARCHAR, BOOLEAN) RETURNS void
AS ‘org.postgresql.pljava.management.Commands.installJar’
LANGUAGE java SECURITY DEFINER;
psql:install.sql:59: ERROR: language “java” does not exist
ERROR: language “java” does not exist
STATEMENT: CREATE FUNCTION sqlj.replace_jar(VARCHAR, VARCHAR, BOOLEAN) RETURNS void
AS ‘org.postgresql.pljava.management.Commands.replaceJar’
LANGUAGE java SECURITY DEFINER;
psql:install.sql:63: ERROR: language “java” does not exist
ERROR: language “java” does not exist
STATEMENT: CREATE FUNCTION sqlj.replace_jar(BYTEA, VARCHAR, BOOLEAN) RETURNS void
AS ‘org.postgresql.pljava.management.Commands.replaceJar’
LANGUAGE java SECURITY DEFINER;
psql:install.sql:67: ERROR: language “java” does not exist
ERROR: language “java” does not exist
STATEMENT: CREATE FUNCTION sqlj.remove_jar(VARCHAR, BOOLEAN) RETURNS void
AS ‘org.postgresql.pljava.management.Commands.removeJar’
LANGUAGE java SECURITY DEFINER;
psql:install.sql:71: ERROR: language “java” does not exist
ERROR: language “java” does not exist
STATEMENT: CREATE FUNCTION sqlj.set_classpath(VARCHAR, VARCHAR) RETURNS void
AS ‘org.postgresql.pljava.management.Commands.setClassPath’
LANGUAGE java SECURITY DEFINER;
psql:install.sql:75: ERROR: language “java” does not exist
ERROR: language “java” does not exist
STATEMENT: CREATE FUNCTION sqlj.get_classpath(VARCHAR) RETURNS VARCHAR
AS ‘org.postgresql.pljava.management.Commands.getClassPath’
LANGUAGE java STABLE SECURITY DEFINER;
psql:install.sql:79: ERROR: language “java” does not exist
ERROR: language “java” does not exist
STATEMENT: CREATE FUNCTION sqlj.add_type_mapping(VARCHAR, VARCHAR) RETURNS void
AS ‘org.postgresql.pljava.management.Commands.addTypeMapping’
LANGUAGE java SECURITY DEFINER;
psql:install.sql:83: ERROR: language “java” does not exist
ERROR: language “java” does not exist
STATEMENT: CREATE FUNCTION sqlj.drop_type_mapping(VARCHAR) RETURNS void
AS ‘org.postgresql.pljava.management.Commands.dropTypeMapping’
LANGUAGE java SECURITY DEFINER;
psql:install.sql:87: ERROR: language “java” does not exist
la libreria “libjvm.so” ya la tengo en /var/lib/pgsql/pljava, ruta a la que apunta mi variable LD_LIBRARY_PATH. Mis variables las tengo en un archivo llamado java.sh en /etc/profile.d/ con lo siguiente:
JAVA_HOME=/usr/lib/jvm/java-1.6.0.0.x86_64
JRE_HOME=/usr/lib/jvm/java-1.6.0.0.x86_64/jre/lib/amd64
LD_LIBRARY_PATH=/var/lib/pgsql/pljava
OXP_HOME=/ServidorOXP
PATH=/var/lib/pgsql:$JAVA_HOME:$PATH
PGDATA=/var/lib/pgsql/data
export JAVA_HOME JRE_HOME OXP_HOME PATH PGDATA
y es que en mi carpeta /usr/lib/jvm tengo los siguientes directorios:
java-1.4.2-gcj-1.4.2.0
java-1.6.0-openjdk-1.6.0.0.x86_64
jre
jre-1.4.2
jre-1.4.2-gcj
jre-1.6.0
jre-1.6.0-openjdk.x86_64
jre-gcj
jre-openjdk
asi que no se si tengo correctas mis rutas, MUCHAS GRACIAS nos vemos!!
