.
The results of the vacuum are available in Statement.getWarnings().
Kris Jurka
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
once rather than a half dozen times.
Kris Jurka
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
a firewall
(or ssh tunnel) that did port forwarding. What PG binds to and what a
client connects to may not be the same thing.
Kris Jurka
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
be run with a 1.6
JVM, just not built with it.
Kris Jurka
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
.
Kris Jurka
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Grzegorz Jaśkiewicz wrote:
On Fri, May 29, 2009 at 1:19 AM, Kris Jurka bo...@ejurka.com wrote:
To build against 8.4 you need pljava from CVS. Also pljava can only be
built with the 1.4 or 1.5 JDK, not with the 1.6 version you are using.
is it a lot of work to make it 1.6 friendly ?
can I
API and can't be built with JDK 1.6. It
will run under a 1.6 JVM as long as you don't use methods that are new
in JDBC 4.
Kris Jurka
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
conditionally compile entire classes
which is easy to do with ant rather than trying to implement something
like #ifdef which is ugly to do with ant's copy with filtering task.
Unfortunately pljava currently has no such infrastructure.
Kris Jurka
--
Sent via pgsql-general mailing list (pgsql
version you are using.
Kris Jurka
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
, it won't be doing that.
The JDBC API has a SQLWarning that we map notice messages to and are
understood by client tools.
http://java.sun.com/javase/6/docs/api/java/sql/SQLWarning.html
Kris Jurka
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
via Statement.execute.
Kris Jurka
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
, but this is a very good question and one
that does prompt further investigation about what can be done in the JDBC
driver to make this better.
Kris Jurka
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wed, 2 Jul 2008, Tom Lane wrote:
Matt Magoffin [EMAIL PROTECTED] writes:
Below is a test case that simulates the use of xpath() within a plpgsql
function in my application.
I'm able to duplicate the memory leak in this function with the current
Fedora 8 libxml2 (2.6.32). The leak is
ResultSet you have.
Kris Jurka
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
one at a time?
The JDBC driver's batch processing is more efficient than regular
execution because it requires fewer network roundtrips so there's less
waiting. The JDBC batch is broken into an internal batch size of 256
statement and all of these are sent over to the server at once.
Kris
, so people
can upgrade to get bug fixes without new features/behavior changes. So if
you're starting a new application with a 8.1 server, there's no reason not
to use the 8.3 driver, but if you're already using the 8.1 driver,
upgrading to the 8.3 driver without testing is not a good idea.
Kris
.
Kris Jurka
[1]
http://jdbc.postgresql.org/documentation/83/connect.html#connection-parameters
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes
which gets it from
windows. So pljava is at least two steps removed from it, so we're in no
position to improve it. Perhaps the server guys can coax some more
details out of windows.
Kris Jurka
---(end of broadcast)---
TIP 6: explain analyze
On Fri, 1 Feb 2008, Guy Rouillier wrote:
Kris Jurka wrote:
Unfortunately this error message comes from the server which gets it from
windows. So pljava is at least two steps removed from it, so we're in no
position to improve it. Perhaps the server guys can coax some more details
out
implementation and docs suggested using ?ssl
alone. At various times we've discussed changing this to be more like
libpq's try/require options, but that's how it is now. So it's not ideal,
but it is working as designed. If you don't want ssl, don't set the
property at all.
Kris Jurka
analyzes
changes and a better execution plan could be found?
Data and stats changes do not trigger a replan.
Kris Jurka
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
statements. What
does it mean?
Unnamed statements are what the driver uses before it hits the
prepareThreshold limit. Once it has determined the statement will be
reused many times it changes to a named statement that has a longer
lifespan.
Kris Jurka
---(end
://www.postgresql.org/docs/8.2/static/largeobjects.html
The JDBC documentation describes some of the tradeoffs between oid and
bytea data types, but doesn't describe the getBlob/setBlob API, only a PG
specific version.
http://jdbc.postgresql.org/documentation/82/binary-data.html
Kris Jurka
pg_catalog.
Kris Jurka
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
(...), using myfunc to
determine the table name at runtime. The planner needs to know all the
tables/columns/other database parts up front before executing anything.
Kris Jurka
---(end of broadcast)---
TIP 4: Have you searched our list archives
driver does not implement that yet.
Kris Jurka
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
actually specified the
columns in creates the result.
Kris Jurka
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
driver was made an external project
instead of bundled with the server source code. The JDBC driver is
available from http://jdbc.postgresql.org/download.html
Kris Jurka
---(end of broadcast)---
TIP 4: Have you searched our list archives
code -1073741502
This is likely a server bug. If you can isolate the failing test and
extract a self contained example someone can probably fix it.
Kris Jurka
---(end of broadcast)---
TIP 6: explain analyze is your friend
be valuable.
Kris Jurka
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Sun, 20 May 2007, madhtr wrote:
How do use hex numbers in psql? I.E.
instead of:
select 16
I want to do
select 0x10
See 4.1.2.3: SELECT x'1FF'::int
http://www.postgresql.org/docs/8.2/static/sql-syntax-lexical.html#SQL-SYNTAX-CONSTANTS
Kris Jurka
---(end
patch broke the
ability for clients to set the encoding they wish to converse in.
Kris Jurka
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
what documentation you're reading:
http://jdbc.postgresql.org/documentation/82/query.html#query-with-cursor
and it works as adverstised.
Kris Jurka
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
it with, my original driver,
postgresql-8.1-405.jdbc3 and all works fine again!
I am using Java 1.5.0_06 on Window XP SP2
JDBC4 is only available with the 1.6 JDK.
Kris Jurka
---(end of broadcast)---
TIP 5: don't forget to increase your free space
don't need multiple months of beta so as long as the patch isn't terribly
complicated we'll accept it close to the release.
Kris Jurka
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
release date, but the latest version is always OK to use.
Kris Jurka
---(end of broadcast)---
TIP 6: explain analyze is your friend
.
Kris Jurka
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
#callproc-resultset
Kris Jurka
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
()); //return a String
cs.execute();
...
public static final String INSERT_CONGRESSO = {SELECT ins_congressoa(?)};
You're mixing your calling syntax. You need to write either:
conn.prepareCall({ ? = call ins_congressoa(?)});
or
conn.prepareStatement(SELECT ins_congressoa(?));
Kris Jurka
On Sat, 13 May 2006, Jerry LeVan wrote:
channel 3: open failed: administratively prohibited: open failed
This is the standard error you'll see when /etc/ssh/sshd_config (or local
equivalent) has AllowTcpForwarding no.
Kris Jurka
---(end of broadcast
On Thu, 27 Apr 2006, Chris Velevitch wrote:
In addition, it's not the norm. I subscribe to lots of mailing lists
and postgresql.org lists are the only ones that I've seem do that.
So what's the reasoning behind this choice?
http://www.unicom.com/pw/reply-to-harmful.html
Kris Jurka
= ...
CallableStatement cs = conn.prepareCall({? = call nextval('seq_nm')});
cs.registerOutParameter(1, Types.BIGINT);
cs.execute();
long nextval = cs.getLong(1);
cs.close();
Kris Jurka
---(end of broadcast)---
TIP 4: Have you searched our list archives
://www.postgresql.org/docs/8.1/static/libpq-exec.html
Kris Jurka
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
of transaction.
If you are going to post to multiple lists, please cross-post instead of
sending two separate messages. This is a JDBC question, so I'll follow up
there.
Kris Jurka
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ
On Mon, 17 Apr 2006, surabhi.ahuja wrote:
The question is that is from this SQLException can i detect if it is a
foreign key violation,
You should check the value of SQLException.getSQLState() against this
table:
http://www.postgresql.org/docs/8.1/static/errcodes-appendix.html
Kris
On Thu, 30 Mar 2006, kurt _ wrote:
I am having a problem with Sun Java Studio Creator because the latest version
of the JDBC driver returns a field length of -1 for text fields.
You should try the latest development driver, 8.2dev-501.
Kris Jurka
---(end
generate comments in sql option turned on.
Is the problem in the JDBC driver, in Hibernate, or in the JDBC spec?
This is the JDBC driver's fault. There are a number of places it does not
correctly detect placeholders vs. comments/text, for example dollar
quoting is another one.
Kris Jurka
how it's supposed to work.
Kris Jurka
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
in the right direction.
http://jdbc.postgresql.org/documentation/publicapi/org/postgresql/util/PGobject.html
Kris Jurka
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On Thu, 8 Dec 2005, Dan Armbrust wrote:
Is there any way to specify which schema I want to use (or have at the front
of the search path) within the jdbc connection string?
No. It is still an open todo open.
http://jdbc.postgresql.org/todo.html
Kris Jurka
---(end
an 8.0 jdbc driver against an
8.1 server. You need the 8.1 driver.
Kris Jurka
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message
usage is two serverside resources held
open the time it takes to service a single request, not wait for user
input. A random webapp leaving suspended or prepared transactions around
is going to lock things up in a hurry.
Kris Jurka
[1] http://archives.postgresql.org/pgsql-jdbc/2005-06/msg00165
('/path/on/client/machine/ks.jpg'))
-d mydb
ERROR: must be superuser to use server-side lo_import()
HINT: Anyone can use the client-side lo_import() provided by libpq.
It is one of psql's backslash commands. See \? and \lo_import.
Kris Jurka
---(end of broadcast
have to change what it returns
it cannot be dropped because of dependencies etc.. In some other
databases you can simpley write a stored proc to return whatever the
query inside returns and this is handled dynamically)
Have you considered returing refcursors instead of setof some type.
Kris
On Wed, 18 May 2005, Hengki Suhartoyo wrote:
I have problem with my jdbc program, I need Sensitive scrollable result.
Postgresql only supports insensitive cursors and ResultSets. Your only
option is to reissue the query to pick up any changes.
Kris Jurka
---(end
transactions, so it does not
have XA JDBC support.
Kris Jurka
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
fetched in this method, but that was just an implementation artifact
at best and a bug at worst.
Kris Jurka
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere
doesn't automatically start a new one immediately. The
difference is that the server doesn't log it for the 8.0 driver because
it prepares the begin/commit/rollback statements just once and executes
them from then on.
Kris Jurka
---(end of broadcast
only be used for
compatibility which makes it a low priority for people who are mostly
PostgreSQL users. Also, it'll certainly decrease performance.
Kris Jurka
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Tue, 12 Apr 2005, [UTF-8] Poul Møller Hansen wrote:
I have rewritten the application so every client thread is opening a new
database connection, and yesterday it happened again.
---
2005-04-11 12:27:54 ERROR: invalid string enlargement request size
1358954492
2005-04-11 12:27:54
synchronization necessary for multiple
threads. Could you be more clear what you are doing? What driver
version? Any chance you've got a reproducible example?
Kris Jurka
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
how you would copy a Connection object. Does that establish a
new connection? The underlying tcp/ip connection can't be copied.
Kris Jurka
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http
problem.
Kris Jurka
import java.sql.*;
public class MultRefCursor {
public static void main(String args[]) throws Exception {
Class.forName(org.postgresql.Driver);
Connection conn =
DriverManager.getConnection(jdbc:postgresql://localhost:5432/jurka,jurka
On Tue, 15 Mar 2005, Suma Bhat wrote:
I'm need to be able to insert a byte[] of size upto 25MB.
With Heap size upto 512m this is failing, with a java.lang.OutOfMemoryError
You need to use an 8.0 JDBC driver and a 7.4 or 8.0 server.
Kris Jurka
---(end of broadcast
and Statement or ResultSet .getWarnings() on the Java side to
retrieve that info. There really isn't any other out of band data path.
Kris Jurka
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
by not fetching all the rows at once. Also
please check the list of restrictions for the JDBC driver to actually use
a portal/cursor backed ResultSet:
http://jdbc.postgresql.org/documentation/80/query.html#query-with-cursor
Kris Jurka
---(end of broadcast
patch update that the issues will
be resolved. We'll keep you up to date.
Any more details on the problem? A link to Sun's bug database? If you
suspect the postgresql jdbc driver I'd be happy to take a look at a
testcase.
Kris Jurka
---(end of broadcast
problems.
Further the 8.0 JDBC driver can create SSL connnections without doing
authentication by adding using an additional url parameter:
sslfactory=org.postgresql.ssl.NonValidatingFactory
You should try to get it to authenticate correctly, but this is another
useful test point.
Kris Jurka
a certificate if I can do it like mentioned above?
It leaves you open to man in the middle attacks. You are no longer
verifying that the server is who they say they are.
Kris Jurka
---(end of broadcast)---
TIP 6: Have you searched our list archives
. The whole JDBC
and SSL setup worked fine for me last time I tested it (mid-October) and I
have little reason to believe it is broken now. What bug are you
seeing?
Kris Jurka
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go
is something the
database really doesn't know what to do with.
SELECT pkcolumn, hashighbit(columna), hashighbit(columnb) FROM mytable;
Kris Jurka
CREATE OR REPLACE FUNCTION hashighbit(text) RETURNS boolean AS '
DECLARE
i int;
BEGIN
i := LENGTH($1);
WHILE i 0 LOOP
the 7.3 driver
was actually doing, but this error is the expected behavior of the driver,
unless of course you are doing something else you haven't shown us.
Kris Jurka
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister
client_encoding of it's
own at connection startup to make sure it gets unicode data. Changing
this to another encoding will break the driver and in the cvs version a
check has been added to error out if it detects you doing this.
Kris Jurka
---(end of broadcast
are there in both
tables. how to create this view?
You need to use aliases in your SELECT...
SELECT sales.customerkey AS salescustomerkey, customer.customerkey AS
customercustomerkey, ... FROM sales, customer WHERE ...
Kris Jurka
---(end of broadcast
On Thu, 7 Oct 2004, Johann Robette wrote:
I use EJB to create a record in a table containing a Boolean field
answered.
The EJB method expects a Boolean object so I pass new Boolean(false) in
order to create it as false.
But I get the following error :
java.sql.SQLException: ERROR:
/static/jdbc-query.html#JDBC-QUERY-WITH-CURSOR
Kris Jurka
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
unlikely to make any performance difference.
Kris Jurka
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through
sample code that demonstrates the problem?
Kris Jurka
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
that are angled, but
there should be no problem with plain ' and . When doing the dump /
restore you may need to actually convert the data from whatever encoding
you were using with something like iconv. If you are just struggling with
the quotes perhaps a simple search and replace would be fine.
Kris
. This can be
accomplished in a number of ways, for example set globally via the
file.encoding system property or on per page basis via methods in
javax.servlet.ServletResponse such as setCharacterEncoding,
setContentType, and setLocale.
Kris Jurka
---(end of broadcast
, but often makes the most sense.
Kris Jurka
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
files are no different
than what you would build yourself so it's fine to use them.
Kris Jurka
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
or
completely undocumented. Combining my example with a brief look at the
source code for PGConnection and PGNotification should hopefully get you
going.
Kris Jurka
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose
wildly different amounts of time.
Kris Jurka
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
();
PGConnection pgconn = (PGConnection)conn;
PGNotification notif[] = conn.getNotifications();
for (int i=0; inotif.length; i++) {
System.out.println(notif[i].getName());
}
Thread.sleep(3000);
}
Kris Jurka
---(end of broadcast
environment. Also what is WSAD?
Kris Jurka
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
query plan? What other activity is going on
at this time? How much memory do you have?
Kris Jurka
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
.
Kris Jurka
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
On Thu, 29 Apr 2004, Andrew Rawnsley wrote:
I find that some clients (DBVisualizer for one) do exactly that -
execute the COMMIT;BEGIN sequence, and leaves idle
transactions on a consistent basis.
The 7.5 JDBC driver has been fixed to avoid this problem.
Kris Jurka
series.
This capability was only added in the 7.4 series. You can work around
this problem by creating a wrapper function that calls the real function
with the constants and creating the index on the wrapper function.
Kris Jurka
---(end of broadcast
file. If it did not specify
this then the bug is with CAR, but not with postgres, client support often
lags new backend functionality.
Kris Jurka
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
archives to find the patch you need to apply.
Kris Jurka
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through
on the same connection? The only code (other
than your own) that could generate that ResultSet would be calling
Connection.getTransactionIsolation() do you have any of these calls in
your code?
What version of the driver are you using?
Kris Jurka
---(end of broadcast
because then multibyte was not
compiled in by default. This will require a dump and reload.
Kris Jurka
---(end of broadcast)---
TIP 8: explain analyze is your friend
and immediately find for all packages the
correct version of the package to distribute.
Lamar, Oliver, interface maintainers, and others would that be useful?
Kris Jurka
---(end of broadcast)---
TIP 8: explain analyze is your friend
such kind of problems which are solved automatically
after some hours/days.
Is there any options in config files or other settings to shorten this time?
See the statement_timeout config parameter.
http://www.postgresql.org/docs/7.3/static/runtime-config.html
Kris Jurka
On Mon, 2 Feb 2004, John Sidney-Woollett wrote:
Kris, thanks for you feedback. Can you give me any further info on the
questions below?
Kris Jurka said:
3) If I want accented characters to sort correctly, must I select
UNICODE
(or the appropriate ISO 8859 char set) over SQL_ASCII
in a single byte encoding (not
unicode)
If using binary data (bytea) via JDBC you may need to use a unicode
db. I don't know if this has been fixed, but the server would attempt to
do an encoding conversion on the binary data:
http://archives.postgresql.org/pgsql-jdbc/2004-01/msg00045.php
Kris Jurka
one at some later point in time when no one is
connected. This has the additional benefit of the old db being available
while the new one is being built.
Kris Jurka
---(end of broadcast)---
TIP 6: Have you searched our list archives
and reopens the connection to the database, so the query in the
procedure gets replanned to use the new index and things run smoothly.
Kris Jurka
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send
1 - 100 of 111 matches
Mail list logo