agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] (no subject)
8+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] (no subject)
@ 2005-02-19 11:23
0 siblings, 0 replies; 8+ messages in thread
From: @ 2005-02-19 11:23 UTC (permalink / raw)
>Lot of words. It all boils down to two things:
[the rest deleted]
If you are trying to convince me that calling a method 1000s of times
passing two parameters at each call is more efficient (both memory- and
performance- wise) than having a single call building the entire result set
which is then processed internally row by row, if desired, by PostgreSQL -
well, you can't.
I will take the necessary steps to bring alterations to the code as I see
fit so to make sure it suits our needs and requirements (at the end of the
day we a running a business, not a charity).
For me, personnally, this is the end of the matter and I consider the
entire issue closed.
Regards,
George
--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web.com/ .
^ permalink raw reply [nested|flat] 8+ messages in thread
* [Pljava-dev] (no subject)
@ 2005-03-28 21:59
0 siblings, 0 replies; 8+ messages in thread
From: @ 2005-03-28 21:59 UTC (permalink / raw)
Thomas Hallgren wrote:
>
>Only one method needs to be rewritten AFAICS, and that's the
>constructor. Try this:
>
>public OWDBConnection() throws SQLException{
> db = DriverManager.getConnection("jdbc:default:connection");
>}
>
>That should do it. You will still use JDBC (that's just the interfaces)
>but now you'll use the PL/Java jdbc implementation. The connection used
>by PL/Java is implicit since it reflects the session of the caller of
>the function, hence there's need to "login".
>
>If you got your code working on a windows system you probably have an
>older version of PL/Java then yor setup must be slightly different
>there. PL/Java somehow finds the jar file of the client driver. Perhaps
>you had that jar file in your classpath in combination with a sligthly
>older version of PL/Java where security was not as tight as it is now?
>Eihter that, or you loaded the actual PostgreSQL client driver .jar
file
>into the database using sqlj.install_jar. As I explained earlier, such
a
>setup might seem to work although what really happens is that your
>function will behave like a client for yet another backend. I have a
>hard time thinking of a case when that would be desirable.
>
>Regards,
>Thomas Hallgren
>
Thank you once again. I have one (hopefully last) problem.
LOG: Exception
LOG: in thread "main"
java.lang.NoClassDefFoundError: org/apache/xerces/dom/DocumentImpl
at PGtoXML.OWDBtoXML.<init>(OWDBtoXML.java:19)
at PGtoXML.PGtoXML.getXmlString(PGtoXML.java:7)
ERROR: java.lang.NoClassDefFoundError:
org/apache/xerces/dom/DocumentImpl
I have installed the xerces xml parser the same way I installed the
PGtoXML jar file. Is there something else I need to do in order to have
PGtoXML see xerces? How do I set the classpath to be seen? I've
already entered:
SELECT sqlj.set_classpath('public', 'xercesImpl');
SELECT sqlj.set_classpath('public', 'xml_apis');
SELECT sqlj.set_classpath('public', 'PGtoXML');
Also, you were right; I was running pljava 1.0.0 on the windows box. I
have replaced it with the latest version, and now both servers are
broken. But I am sure that once I get this to work it'll be better than
what I used to have.
Once again thank you for you help.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20050328/a3be4bd2/attachment.html;
^ permalink raw reply [nested|flat] 8+ messages in thread
* [Pljava-dev] (no subject)
@ 2005-06-24 17:08
0 siblings, 0 replies; 8+ messages in thread
From: @ 2005-06-24 17:08 UTC (permalink / raw)
Hi,
When I try execute any function "select sqlj.function(..)" I am
getting the follow error :
select sqlj.get_classpath('sqlj');
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
What can I do
I am using postgresql 8.0.3
java 1.4 and
\d sqlj.*
Table "sqlj.classpath_entry"
Column | Type | Modifiers
------------+-----------------------+-----------
schemaname | character varying(30) | not null
ordinal | smallint | not null
jarid | integer | not null
Indexes:
"classpath_entry_pkey" PRIMARY KEY, btree (schemaname, ordinal)
Foreign-key constraints:
"classpath_entry_jarid_fkey" FOREIGN KEY (jarid) REFERENCES
jar_repository(j arid) ON DELETE CASCADE
Index "sqlj.classpath_entry_pkey"
Column | Type
------------+-----------------------
schemaname | character varying(30)
ordinal | smallint
primary key, btree, for table "sqlj.classpath_entry"
Table "sqlj.jar_entry"
Column | Type |
Modifiers
------------+------------------------+------------------------------------------ --------------------
entryid | integer | not null default
nextval('sqlj.jar_entry_ entryid_seq'::text)
entryname | character varying(200) | not null
jarid | integer | not null
entryimage | bytea | not null
Indexes:
"jar_entry_pkey" PRIMARY KEY, btree (entryid)
"jar_entry_jarid_key" UNIQUE, btree (jarid, entryname)
Foreign-key constraints:
"jar_entry_jarid_fkey" FOREIGN KEY (jarid) REFERENCES
jar_repository(jarid) ON DELETE CASCADE
Sequence "sqlj.jar_entry_entryid_seq"
Column | Type
---------------+---------
sequence_name | name
last_value | bigint
increment_by | bigint
max_value | bigint
min_value | bigint
cache_value | bigint
log_cnt | bigint
is_cycled | boolean
is_called | boolean
Index "sqlj.jar_entry_jarid_key"
Column | Type
-----------+------------------------
jarid | integer
entryname | character varying(200)
unique, btree, for table "sqlj.jar_entry"
Index "sqlj.jar_entry_pkey"
Column | Type
---------+---------
entryid | integer
primary key, btree, for table "sqlj.jar_entry"
Table "sqlj.jar_repository"
Column | Type |
Modifiers
----------------+------------------------+-------------------------------------- ---------------------------
jarid | integer | not null default
nextval('sqlj.jar_re pository_jarid_seq'::text)
jarname | character varying(100) | not null
jarorigin | character varying(500) | not null
jarowner | integer | not null
deploymentdesc | integer |
Indexes:
"jar_repository_pkey" PRIMARY KEY, btree (jarid)
"jar_repository_jarname_key" UNIQUE, btree (jarname)
Foreign-key constraints:
"jar_repository_deploymentdesc_fkey" FOREIGN KEY (deploymentdesc)
REFERENCES jar_entry(entryid) ON DELETE SET NULL
Sequence "sqlj.jar_repository_jarid_seq"
Column | Type
---------------+---------
sequence_name | name
last_value | bigint
increment_by | bigint
max_value | bigint
min_value | bigint
cache_value | bigint
log_cnt | bigint
is_cycled | boolean
is_called | boolean
Index "sqlj.jar_repository_jarname_key"
Column | Type
---------+------------------------
jarname | character varying(100)
unique, btree, for table "sqlj.jar_repository"
Index "sqlj.jar_repository_pkey"
Column | Type
--------+---------
jarid | integer
primary key, btree, for table "sqlj.jar_repository"
Thank advance
Mario
^ permalink raw reply [nested|flat] 8+ messages in thread
* [Pljava-dev] (no subject)
@ 2005-06-28 20:55
2005-06-29 08:33 ` [Pljava-dev] (no subject)
0 siblings, 1 reply; 8+ messages in thread
From: @ 2005-06-28 20:55 UTC (permalink / raw)
Hi,
I am trying execute
select sqlj.install_jar('file://opt/pljava-1.1.0/build/examples.jar','sqlj',true);
and I am getting
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
any idea ?
Mario
^ permalink raw reply [nested|flat] 8+ messages in thread
* [Pljava-dev] (no subject)
2005-06-28 20:55 [Pljava-dev] (no subject)
@ 2005-06-29 08:33 `
0 siblings, 0 replies; 8+ messages in thread
From: @ 2005-06-29 08:33 UTC (permalink / raw)
mfernand wrote:
>Hi,
>
>I am trying execute
>
> select sqlj.install_jar('file://opt/pljava-1.1.0/build/examples.jar','sqlj',true);
>
>and I am getting
>
>server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
>The connection to the server was lost. Attempting reset: Failed.
>
>
>any idea ?
>
>
The first thing you should do is check the server log. It's the most
likely place where you'll find some clue to why the server terminated.
Regards,
Thomas Hallgren
^ permalink raw reply [nested|flat] 8+ messages in thread
* [Pljava-dev] (no subject)
@ 2006-03-24 09:10
2006-03-24 10:21 ` [Pljava-dev] (no subject)
0 siblings, 1 reply; 8+ messages in thread
From: @ 2006-03-24 09:10 UTC (permalink / raw)
Hello.
I am facing with the problem when I deploy pljava.
Please tell me how to solve the problem.
java -cp:postgresql-8.1-405-jdbc3.jar:deploy.jar
org.postgresql.pljava.deploy.Deployer -install -user sss -database template
-password sss
After I execute,the message is displayed.
Aborted
My environment
Postgresql 8.1.3
postgresql.conf
listen_address='*'
dynamic_library_path='$libdir;/usr/local/pgsql/pljava'
custom_variable_classes='pljava'
pljava.classpath='/usr/local/pgsql/pljava.jar'
pg_hba.conf
host all all localhost trust
jdk1.4.2_06
pljava1.0.0
^ permalink raw reply [nested|flat] 8+ messages in thread
* [Pljava-dev] (no subject)
2006-03-24 09:10 [Pljava-dev] (no subject)
@ 2006-03-24 10:21 `
0 siblings, 0 replies; 8+ messages in thread
From: @ 2006-03-24 10:21 UTC (permalink / raw)
PL/Java 1.0.0 cannot be used with PostgreSQL 8.1.3. Please use PL/Java
1.2.0.
Regards,
Thomas Hallgren
kitaeda at infoeye.net wrote:
> Hello.
>
> I am facing with the problem when I deploy pljava.
> Please tell me how to solve the problem.
>
> java -cp:postgresql-8.1-405-jdbc3.jar:deploy.jar
> org.postgresql.pljava.deploy.Deployer -install -user sss -database template
> -password sss
>
> After I execute,the message is displayed.
>
> Aborted
>
>
> My environment
>
> Postgresql 8.1.3
> postgresql.conf
> listen_address='*'
> dynamic_library_path='$libdir;/usr/local/pgsql/pljava'
> custom_variable_classes='pljava'
> pljava.classpath='/usr/local/pgsql/pljava.jar'
> pg_hba.conf
> host all all localhost trust
> jdk1.4.2_06
> pljava1.0.0
>
>
>
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* [Pljava-dev] (no subject)
@ 2007-12-12 19:52
0 siblings, 0 replies; 8+ messages in thread
From: @ 2007-12-12 19:52 UTC (permalink / raw)
I am running psql 8.1.10, and javac 1.5.0_13 on Centos5 and have compiled pljava-1.3.0 from source. I am able to run the deployer successfully(it seems) The functions in the sqlj schema are as follows:
\df sqlj.*
List of functions
Schema | Name | Result data type | Argument data types
--------+--------------------+-------------------+-----------------------------------------------
sqlj | add_type_mapping | void | character varying, character varying
sqlj | drop_type_mapping | void | character varying
sqlj | get_classpath | character varying | character varying
sqlj | install_jar | void | bytea, character varying, boolean
sqlj | install_jar | void | character varying, character varying, boolean
sqlj | java_call_handler | language_handler |
sqlj | javau_call_handler | language_handler |
sqlj | remove_jar | void | character varying, boolean
sqlj | replace_jar | void | bytea, character varying, boolean
sqlj | replace_jar | void | character varying, character varying, boolean
sqlj | set_classpath | void | character varying, character varying
(11 rows)
However when I run select sqlj.install_jar statement in psql I get
ERROR: Failed to create Java VM
The posgress server adds to it as follows:
libgcj: unknown option: -Xrs
ERROR: Failed to create Java VM
Has anyone seen this? What is the solution?
Any help would be appreciated.
Alice Galinat
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2007-12-12 19:52 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-02-19 11:23 [Pljava-dev] (no subject)
2005-03-28 21:59 [Pljava-dev] (no subject)
2005-06-24 17:08 [Pljava-dev] (no subject)
2005-06-28 20:55 [Pljava-dev] (no subject)
2005-06-29 08:33 `
2006-03-24 09:10 [Pljava-dev] (no subject)
2006-03-24 10:21 `
2007-12-12 19:52 [Pljava-dev] (no subject)
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox