le.
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
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
an 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
ResultSet
instance we'll return a Jdbc4ResultSet.
By using this inheritance we can 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 cu
l of the JDBC 4 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
Grzegorz Jaśkiewicz wrote:
On Fri, May 29, 2009 at 1:19 AM, Kris Jurka 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 help?
It
the moment.
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
e 1.6 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
y, 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 chang
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
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
ch concurrently open 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
essed 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
rsion, 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
you can see where it got built from.
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
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
s 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 of windows.
Kris Jurka
---(end of broadcast)---
TIP 6:
ssl, as the original 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
ast forever. What if the table 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
thing about preparing "unnamed" 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 J
pg_catalog.
Kris Jurka
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
...
http://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.h
he pg driver does not implement that yet.
Kris Jurka
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
uot;INSERT INTO (SELECT myfunc()) VALUES (...)", 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)-
27;ve 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
that it actually executed would 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-C
he server in CVS. A recent 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
teration.)
I'm not sure 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
ce 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
. We
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
ead or behind of the server
release date, but the latest version is always OK to use.
Kris Jurka
---(end of broadcast)---
TIP 6: explain analyze is your friend
the pgsql-jdbc list.
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 in
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 broa
ill
support something like the following:
Connection conn = ...
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
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.h
://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
olation level in the middle 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)---
T
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 of
ument much easier to
navigate.
The 7.4 and 8.0 manuals are missing the bookmarks/TOC, but the 8.1 manual
does have them.
Kris Jurka
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
hat's 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
x27;s
"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 anoth
you 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
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
s(lo_import('/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
-
asking for trouble. Normal XA 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.o
ad of setof some type.
Kris Jurka
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
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
ot support distributed 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
Older drivers used to report the number of
rows 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
est driver will do that as well, but in two statements now that
transaction end 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
the
hind the scenes.
Then any error would rollback to the savepoint and you could continue on
with your transaction. This option would 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
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
the db class ?
>
The JDBC driver should be doing any 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
the test code I've used to verify
that this is not a driver problem.
Kris Jurka
import java.sql.*;
public class MultRefCursor {
public static void main(String args[]) throws Exception {
Class.forName("org.postgresql.Driver");
Connection conn =
eally can't copy resources around like that.
Consider 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: Hav
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
NOTICE in your plpgsql
function 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
sumption on the client 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
---(e
ng. We hope that in a future 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
-
arch with us. 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 an
adache of
> creating 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
e java command will help debugging
ssl 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 anoth
below will determine if a
particular field has data with the high bit set which 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
oned before the first row. I don't know what 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)---
ing + "'");
> statement.execute();
>
This is bad advice for a Java client and does not work. The JDBC driver
always expects data in unicode and issues a SET client_encoding of it's
own at connection startup to make sure it gets unicode data.
ge field names or specify field names in
> view definition because many fields 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 W
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: ERR
rg/docs/7.4/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
ample is pointing to
a database query in which case so many other things are going on it's
unlikely to make any performance difference.
Kris Jurka
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
BC? Could you show us some sample code that demonstrates the problem?
Kris Jurka
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
quotes perhaps a simple search and replace would be fine.
Kris Jurka
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
doesn't necessarily have to be unicode, 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
r converting Java Strings into bytes. 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
onal java tools, but these were
removed before the 7.4 release. The provided jar 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
are either poorly documented 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
d on the first row or never which will take
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
On Tue, 11 May 2004, Glenn Sullivan wrote:
> Hi,
>
> I have been trying to get LISTEN/NOTIFY working in with JDBC. I cannot seem
> to get notified. I looked in the e-mail archive and saw a lot of similiar
> questions a couple of years ago. I never could find any answers in the
> e-mail nor i
your runtime 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])
o check would be the actual query being
run. Is it using a bad plan 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
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 probl
d
like to try it out.
Kris Jurka
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
ify its runtime requirements,
which in this case include an updated jar 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)---
ou cannot create functional indexes with a constant in the 7.3 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.
Kr
of a thread safety problem in the driver. Are
you using multiple threads 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 a
d will go out in the 7.4.3
release. For no your best bet is to checkout the 7.4 branch from cvs, or
search the pgsql-committers archives to find the patch you need to apply.
Kris Jurka
---(end of broadcast)---
TIP 3: if posting/reading throug
driver needs the data encoded correctly, the ?charSet= option
only works on 7.2 and earlier databases 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
n if necessary and register
it on a website somewhere. Then when a packager is ready to produce a
package he can check the website and immediately find for all packages the
correct version of the package to distribute.
Lamar, Oliver, interface maintainers, and others would that be useful?
Kri
dy
> occured?
>
The JDBC driver will not do any casting for you. The cross type indexing
problem is is a backend issue and has been addressed in the cvs version,
but this has long been a problem for JDBC users.
Kris Jurka
---(end of broadcast)--
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
ar.
> Time to time I face 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
coding conversion on the binary data:
http://archives.postgresql.org/pgsql-jdbc/2004-01/msg00045.php
Kris Jurka
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
1 - 100 of 114 matches
Mail list logo
