agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feedSubject: [Pljava-dev] Re: Deployment problem
Date: Wed, 16 Mar 2005 17:01:11 +0100
Message-ID: <42385847.3000903@mailblocks.com> (raw)
In-Reply-To: <loom.20050316T155633-86@post.gmane.org>
References: <423844CD.9080309@univ-mlv.fr>
<4238469E.30006@mailblocks.com>
<loom.20050316T155633-86@post.gmane.org>
ocure wrote:
>Thomas Hallgren <thhal <at> mailblocks.com> writes:
>
>
>
>>ocure wrote:
>>
>>
>>
>>>Hi
>>>I'm having a hard time at deployment time.
>>>The javatest schema is not created after the following query :
>>>SELECT
>>>sqlj.install_jar('file:///home/olive/_devj/pljava/examp.jar','exa',True);
>>>I copied the examples.ddr in the examp.jar
>>>
>>>After struggling with the system, I also obtained the following error :
>>>ERROR: relation with OID 150594 does not exist
>>>
>>>Where can I get some information on schema and deployment.
>>>
>>>
>>You can ask specific questions in this forum.
>>
>>You stand a better chance of accurate advice if you provide some more
>>info such as the backend error-log, exactly when you encounter what
>>problem, platform in use, Java version, PostgreSQL version, and PL/Java
>>version, etc.
>>
>>Regards,
>>Thomas Hallgren
>>
>>
>>
>
>Platform : Linux Slackware 10
>Java 1.5
>Postgresql 8.0
>PLjava : 1.1.0b1
>For the schema problem, I'm doing the following things from a state where the
>schema sqlj is present :
>create a new DB mydb4
>java org.postgresql.pljava.deploy.Deployer -install -database mydb4
>sqlj.install_jar('file:///home/olive/_devj/pljava/examp.jar','exa',True);
>
>Am i right to thin k that the javatest schema (supposed to be created via the
>examp.jar) should be visible now with \dn ?
>
>
I'm not sure what the "examp.jar" is supposed to be here. The java
distro comes with an "examples.jar" that contains a manifest that
appoints a deployment descriptor that in turn will create the javatest
schema. That schema will be visible using \dn.
Do you get an error when you run the sqlj.install_jar? If not, can you
see that tables are created by watching the backend log? Typically you
should see "CREATE TABLE javatest.employees1" ... in the log.
Regards,
Thomas Hallgren
view thread (5+ messages) latest in thread
Message-ID: <42385847.3000903@mailblocks.com>
Permalink: ../42385847.3000903@mailblocks.com/
Also on: postgresql.org/message-id/42385847.3000903@mailblocks.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pljava-dev@postgresql.org
Subject: Re: [Pljava-dev] Re: Deployment problem
In-Reply-To: <42385847.3000903@mailblocks.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox