ERROR: schema "sqlj" does not exist

View: New views
3 Messages — Rating Filter:   Alert me  

ERROR: schema "sqlj" does not exist

by Nelli Vanan :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi there,

This is my first time installing pljava.  I unziped the
"pljava-i686-pc-linux-gnu-pg8.1-1.4.0.tar" to /usr/pljava directory.
I modified
the postgresql.conf file and added the following lines

dynamic_library_path ='$libdir:/usr/pljava'

custom_variable_classes = 'pljava'
pljava.classpath='/usr/pljava/pljava.jar'

And restarted the postgres service.  After that I tried to run the
sample tests given in the wiki.   But, I am getting the following
error message
ERROR:  schema "sqlj" does not exist in the postgres log file.  What is wrong?

Thank you.
_______________________________________________
Pljava-dev mailing list
Pljava-dev@...
http://pgfoundry.org/mailman/listinfo/pljava-dev

Re: ERROR: schema "sqlj" does not exist

by Nelli Vanan :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi there,

I tried to install using the deploy.jar and now I am getting the
following error.

java.sql.SQLException: You must be a superuser to deploy/undeploy pl/Java.
        at org.postgresql.pljava.deploy.Deployer.checkIfConnectedAsSuperuser(Deployer.java:303)
        at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:257)

I am logged in as root.




On Fri, Oct 17, 2008 at 10:08 AM, Nelli Vanan <ambulimama@...> wrote:

> Hi there,
>
> This is my first time installing pljava.  I unziped the
> "pljava-i686-pc-linux-gnu-pg8.1-1.4.0.tar" to /usr/pljava directory.
> I modified
> the postgresql.conf file and added the following lines
>
> dynamic_library_path ='$libdir:/usr/pljava'
>
> custom_variable_classes = 'pljava'
> pljava.classpath='/usr/pljava/pljava.jar'
>
> And restarted the postgres service.  After that I tried to run the
> sample tests given in the wiki.   But, I am getting the following
> error message
> ERROR:  schema "sqlj" does not exist in the postgres log file.  What is wrong?
>
> Thank you.
>
_______________________________________________
Pljava-dev mailing list
Pljava-dev@...
http://pgfoundry.org/mailman/listinfo/pljava-dev

Re: ERROR: schema "sqlj" does not exist

by Kris Jurka :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Nelli Vanan wrote:
>
> java.sql.SQLException: You must be a superuser to deploy/undeploy pl/Java.
>         at org.postgresql.pljava.deploy.Deployer.checkIfConnectedAsSuperuser(Deployer.java:303)
>         at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:257)
>
> I am logged in as root.
>

You need to connect to the database as a database superuser.  The shell
user the deployer is run from is not relevent.

Kris Jurka

_______________________________________________
Pljava-dev mailing list
Pljava-dev@...
http://pgfoundry.org/mailman/listinfo/pljava-dev