error msg about stored procedures and relations not existing... - Mailing list pgsql-jdbc

From Bill Thomason
Subject error msg about stored procedures and relations not existing...
Date
Msg-id 002e01c30d9b$99f5ca60$b701a8c0@Hazelnut
Whole thread Raw
Responses Re: error msg about stored procedures and relations not existing...
List pgsql-jdbc

Hi,

 

I have Postgres 7.3.2 running on a Mandrake Linux 9.0 box.  I have a series a defined tables and two stored procedures defined in a database.

 

I have some java code that makes a remote connection and will call the stored procedures and insert the returned values along with data through the jdbc connection.

 

Whenever I do an insert I will get messages such as:

 

ERROR:  Relation "image" does not exist

 

where image is one of several tables.

 

I get the following message concerning the stored procedures:

 

ERROR:  Function get_next_local_id(integer) does not exist

        Unable to identify a function that satisfies the given argument types

        You may need to add explicit typecasts

 

This is but one of two stored procedures.  This one is called before the other one so I will suspect that even if the first one is called correctly the second one will suffer the same fate.

 

If I manually connect to the database using psql, all of the tables and the stored procedures exist.  All table have the proper permissions for the connecting user from my java app to select,insert,append,delete row entries from the tables.

 

I have granted executable privileges for the connecting user on the stored procedure.

 

Is there anything else I am missing or should be checking for?

 

I did have all of this running on a SPARC system running 7.1.2, for what it’s worth.

 

Thanks in advance,

-Bill Thomason

pgsql-jdbc by date:

Previous
From: J M Okomba
Date:
Subject: Re: "Invalid character data was found"
Next
From: "SVGK, Raju (Raju)"
Date:
Subject: jdeveloper postgresql 7.2