agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] Deployment problem
5+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] Deployment problem
@ 2005-03-16 14:38
2005-03-16 14:45 ` [Pljava-dev] Deployment problem
0 siblings, 1 reply; 5+ messages in thread
From: @ 2005-03-16 14:38 UTC (permalink / raw)
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.
Thanks
^ permalink raw reply [nested|flat] 5+ messages in thread
* [Pljava-dev] Deployment problem
2005-03-16 14:38 [Pljava-dev] Deployment problem
@ 2005-03-16 14:45 `
2005-03-16 15:02 ` [Pljava-dev] Re: Deployment problem
0 siblings, 1 reply; 5+ messages in thread
From: @ 2005-03-16 14:45 UTC (permalink / raw)
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* [Pljava-dev] Re: Deployment problem
2005-03-16 14:38 [Pljava-dev] Deployment problem
2005-03-16 14:45 ` [Pljava-dev] Deployment problem
@ 2005-03-16 15:02 `
2005-03-16 16:01 ` [Pljava-dev] Re: Deployment problem
0 siblings, 1 reply; 5+ messages in thread
From: @ 2005-03-16 15:02 UTC (permalink / raw)
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 ?
^ permalink raw reply [nested|flat] 5+ messages in thread
* [Pljava-dev] Re: Deployment problem
2005-03-16 14:38 [Pljava-dev] Deployment problem
2005-03-16 14:45 ` [Pljava-dev] Deployment problem
2005-03-16 15:02 ` [Pljava-dev] Re: Deployment problem
@ 2005-03-16 16:01 `
2005-03-16 16:27 ` [Pljava-dev] Re: Deployment problem
0 siblings, 1 reply; 5+ messages in thread
From: @ 2005-03-16 16:01 UTC (permalink / raw)
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* [Pljava-dev] Re: Deployment problem
2005-03-16 14:38 [Pljava-dev] Deployment problem
2005-03-16 14:45 ` [Pljava-dev] Deployment problem
2005-03-16 15:02 ` [Pljava-dev] Re: Deployment problem
2005-03-16 16:01 ` [Pljava-dev] Re: Deployment problem
@ 2005-03-16 16:27 `
0 siblings, 0 replies; 5+ messages in thread
From: @ 2005-03-16 16:27 UTC (permalink / raw)
No I do not have any error. The examples.ddr in the jar file is the same.
I run SELECT
sqlj.replace_jar('file:///home/olive/_devj/pljava/examp.jar','exa',true);
And get
replace_jar
-------------
(1 row)
And no new lines in the logfile but still the javatest is not present and tables
are not created.
Thanks
Olivier
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2005-03-16 16:27 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-16 14:38 [Pljava-dev] Deployment problem
2005-03-16 14:45 `
2005-03-16 15:02 `
2005-03-16 16:01 `
2005-03-16 16:27 `
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox