I'll try it.
Thanks for your help.
Bob
- Original Message -
From:
Daniel
Blaisdell
To: Bob Pawley
Cc: Postgresql
Sent: Thursday, March 09, 2006 11:58
AM
Subject: Re: [GENERAL] JDBC
-BEGIN PGP SIGNED MESSAGE-Hash: SHA1I'm
assuming that your real
On Sat, 7 Jan 2006, Assad Jarrahian wrote:
I am quite confused (PLEASE PLEASE Help), I cannot find anything on
the web). I read that you can declare a class that implements SQLData
(in this case I set up a class called Complex from the /src/tutorial
datatype that mimics the user-defined
Hi there,
I am getting an error when I try to update or delete
rows in my postgreSQL table. I am using:
Eclipse
WO5.2
Postgres8.0 JDBC3
Hexdreams 1.2 plugin
The error message is horribly vauge:
com.webobjects.eoaccess.EOGeneralAdaptorException:
updateValuesInRowDescribedByQualifier --
On Thu, Aug 18, 2005 at 03:55:43PM +1200, Oliver Jowett wrote:
Joseph Shraibman wrote:
The column's type is 'xid' which the driver doesn't currently handle,
so it gets put into the wrap it in PGobject bucket.
Is xid a type of number?
It's an internal backend type; I'm not familiar with
Joseph Shraibman wrote:
Is it a jdbc bug that
is returning the answer as org.postgresql.util.PGobject instead of some
kind of Number?
The column's type is 'xid' which the driver doesn't currently handle, so
it gets put into the wrap it in PGobject bucket.
I'm not sure what's changed
Oliver Jowett wrote:
Joseph Shraibman wrote:
Is it a jdbc bug that is returning the answer as
org.postgresql.util.PGobject instead of some kind of Number?
The column's type is 'xid' which the driver doesn't currently handle, so
it gets put into the wrap it in PGobject bucket.
Is xid a
Joseph Shraibman wrote:
The column's type is 'xid' which the driver doesn't currently handle,
so it gets put into the wrap it in PGobject bucket.
Is xid a type of number?
It's an internal backend type; I'm not familiar with the details.
Perhaps your server should convert instances of
So basically what needs to be changed is TypeInfoCache.java Oid.java
Alvaro Herrera wrote:
On Thu, Aug 18, 2005 at 03:55:43PM +1200, Oliver Jowett wrote:
Joseph Shraibman wrote:
The column's type is 'xid' which the driver doesn't currently handle,
so it gets put into the wrap it in
Csaba Nagy wrote:
However, some of the queries still take the sequential scan route. The
most puzzling in all this is that I've tried to prepare the same query
in psql, and then explain execute the prepared query, and it gave me
an index scan plan... so now I'm clueless, and have no idea why
OK, found the source of the problem: our code is setting nulls via:
PreparedStatement.setNull(int parameterIndex, int sqlType)
using Types.NUMERIC as the type, but the data base type is actually
BIGINT. Using Types.BIGINT in this method makes the problem go away.
Hopefully there are no more bad
On Wed, 2005-05-18 at 05:36, William Shatner wrote:
Hello,
I am using PostgreSQL 8.0 as a data repository for a Java based system
and I now want to add users to my java program with usernames and
passwords. Is their an encrypted password field I can use in a User
Table to store passwords
On Thu, 24 Mar 2005, David Gagnon wrote:
I'm already able to get Refcursor from a stored procedure. But now I
need to get a SETOF refcursor and I can't make it work... Is that
possible to do this via JDBC?
He is the code I did. The rsTmp.next() throws a Connection is
closed.
Hi Kris,
I don't get error with the rsTmp.close() statement but with
(rsTmp.next()) . The arraycopy is because I want to shrink the
original array (size 50) to it real size. It's not intended to be a
deep copy.
Plpgsql function can return multiple refcursor .. so the question is how
I
On Thu, 24 Mar 2005, David Gagnon wrote:
Hi Kris,
I don't get error with the rsTmp.close() statement but with
(rsTmp.next()) . The arraycopy is because I want to shrink the
original array (size 50) to it real size. It's not intended to be a
deep copy.
Right, my bad. I see
Hi Kris,
I use this the code found here.
http://www.postgresql.org/docs/7.4/interactive/jdbc-callproc.html But I
don't think there is a way to make it work with SETOF RefCursor.
I will try your code wich seem to work.
SQL STRING: ? = call usp_Comptabilite_JournalVentes (?, ?, ?, ?, ?
Please post to the list too when replying...
On Wed, 2005-03-09 at 17:29, Mican Bican wrote:
Thank you for your answer. The reason of so long transactions is that
I first Insert a row than get the last ID (primary key) and select it
for update from the database and wait for user to commit it..
Whoops, posted to the wrong mailing list... but it might fit anyway.
---(end of broadcast)---
TIP 8: explain analyze is your friend
On Fri, 25 Feb 2005, Dave Smith wrote:
Is a portal using the V3 protocol the same as a cursor? I am trying to
debug a slow query and I want the JDBC driver to use the cursor syntax.
It says it is using a portal but the performance seems like just a
regular sql statement.
Yes, portals
On Fri, 26 Nov 2004, Hunter Hillegas wrote:
When I SELECT from a certain table, I see this JDBC exception:
Invalid character data was found. This is most likely caused by stored
data containing characters that are invalid for the character set the
database was created in. The most
I got this going with a dump/reload.
Beware however, 8.0b5 and the JDBC driver don't seem to work with UNICODE
encoding for the database. You have to use b4 or HEAD.
Hunter
From: Kris Jurka [EMAIL PROTECTED]
Date: Tue, 30 Nov 2004 01:34:46 -0500 (EST)
To: Hunter Hillegas [EMAIL PROTECTED]
On Mon, 8 Nov 2004, J. Michael Crawford wrote:
Even in Java, where you can do all sorts of character-encoding
translation, it can be impossible to translate data retrieved from Postgres
if it's in the wrong encoding. We've tried changing the JVM encoding,
altering the jdbc driver,
This is bad advice for a Java client and does not work.
Well then, perhaps we shouldn't share the procedure with other folks. I
apologize if I'm introducing some misinformation.
However, this has been the only way to get our system to work on more
than one JVM. People from this group
J. Michael Crawford wrote:
Encoding translations that didn't work:
a) Getting encoded bytes from the result set. We tried the following
block five times, once for each different encoding we were trying to
test with the database:
b) Getting a string, turning it bytes, and then translating.
The right way is to just use getString() and not do any translation
yourself.
That was the first thing we tried. Sorry I didn't mention it.
The next step was getting a string, turning it into bytes, and
translating the bytes. The third step was getting bytes. Nothing worked
in our Java
On Sun, 17 Oct 2004, Simon Moses wrote:
dear sir,
i am trying to create view with following query
This has nothing to do with JDBC or Java, so it should not be sent to the
JDBC list.
create view salesQ as
select * from sales, customer where sales.customerkey
= customer.customerkey;
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:
Denis,
You'd get better results if you posted this to the jdbc list.
Dave
On Mon, 2004-06-21 at 11:49, Sailer, Denis (YBUSA-CDR) wrote:
There was a posting in the mailing list archives that I can't find
anymore. The web site right now is presenting a list of items from a
search in a
AFAIK, every database uses some sort of 'large object interface'. Surely
you could still move between DBs even using BLOB fields?
Sailer, Denis (YBUSA-CDR) [EMAIL PROTECTED] wrote:
quote
---
There was a posting
Vikas Rana wrote:
Hi all,
I am a bit confused about the method
java.sql.DatabaseMetaData.nullsAreSortedHigh(). What exactly does this
return? If this returns true, are nulls considered as the highest
value? Or does this mean that nulls comes first when sorted in
ascending order
Hi,
...I'm getting error like this from the java side and the
application stops working (and wont come back unless I restart...
How is the application invoked? Is it a service (servlet instance, RMI
object-mediated, etc.), i.e. does a core-component run forever and spawn
helpers to handle
Wrong list. Please post this to the [EMAIL PROTECTED] list.
I am sure there are people there that can help you with this.
Regards,
Fernando
Aleksey wrote:
Hello,
I have the following problem working with DatabaseMetaData. There is a
database with table and attribute names in Russian.
be the problem with the url?
Please do reply.It is urgent.
Thanks and Regards,
Kallol.
-Original Message-
From: Dmitry Tkach [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 21, 2003 2:18 AM
To: Kallol Nandi
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] JDBC in PostgreSql for Linux
You've got
Kallol Nandi schrieb:
I am not able to get the mistake.What might be the problem with the url?
Please do reply.It is urgent.
Thanks and Regards,
Kallol.
Did you try to use Sun's JDK?
---(end of broadcast)---
TIP 5: Have you checked our extensive
According to Sun, http://jcp.org/en/jsr/detail?id=221, it is not yet
available:
2.11 Please describe the anticipated schedule for the development of
this specification.
This specification will be available towards the end of the calendar
year, 2004.
So I wonder why you expect a Postgresql JDBC4
Arjen van der Meijden schrieb:
According to Sun, http://jcp.org/en/jsr/detail?id=221, it is not yet
available:
2.11 Please describe the anticipated schedule for the development of
this specification.
This specification will be available towards the end of the calendar
year, 2004.
So I wonder why
: Friday, June 20, 2003 4:12 PM
To: [EMAIL PROTECTED]
Subject: Re: [GENERAL] JDBC in PostgreSql for Linux
Kallol Nandi schrieb:
I am running a Java application on Linux which connects to the Postgresql
on Linux using jdbcodbc bridge.
But this is the error I am getting :
I have also
Vic,
Can you post the errors you are getting for both the build problem and
the runtime problem you originally reported?
Without the exact errors you are getting, I can only guess at the
problems you are encountering. But my guess as to your original problem
is that your code is trying to
On Mon, 16 Jul 2001, stefan wrote:
Hi:
Are there JDBC drivers for PostGresSQL?
http://jdbc.postgresql.org
Vince.
--
==
Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net
56K
Yes,
Binaries can be found at
http://jdbc.fastcrypt.com
Source is in postgres cvs
Dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of stefan
Sent: July 16, 2001 1:06 PM
To: [EMAIL PROTECTED]
Subject: [GENERAL] JDBC 2.0 support?
Hi:
Are there
PROTECTED]
To: Clayton Vernon [EMAIL PROTECTED]
Cc: John Oakes [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Thursday, April 26, 2001 6:19 PM
Subject: Re: [GENERAL] JDBC speed question.
Clayton Vernon [EMAIL PROTECTED] writes:
Related question: how do you run postgreSQL to simultaneously
On Fri, Apr 27, 2001 at 02:36:21PM +0200, Loïc Courtois wrote:
On Fri, Apr 27, 2001 at 01:56:38AM +0200, Loïc Courtois wrote:
Hello,
I have some problems to display the accents in my db, using the JDBC and
postgres 7.1.
Apparently, all accents are replaced by a '?'.
What
John Oakes [EMAIL PROTECTED] writes:
Anyone have any ideas how to speed up performance using the JDBC driver? A
query that takes me 20 seconds to execute from command line takes 1 full
minute with the jdbc driver. Thanks.
Since you don't guve any details of your query or network setup,
Clayton Vernon [EMAIL PROTECTED] writes:
Related question: how do you run postgreSQL to simultaneously support a Unix
socket and TCP/IP?
Just add '-i' to the postmaster startup options. The Unix socket will
still be available.
-Doug
--
The rain man gave me two cures; he said jump right
Clayton Vernon [EMAIL PROTECTED] writes:
Thanks, but can I specify each port? I've only seen the one documented
command option -p which I assume was for the TCP/IP port.
Well, Unix sockets don't have a port. The port number you specify
is appended to the name of the socket in the filesystem
On 10 Apr 2001 16:38:28 -0700, Homayoun Yousefi'zadeh wrote:
For those of you looking for the compiled jar file
go to the bottom of following page
...
Well thanks for that!!! Dreamweaver now sees the driver (placed in
:Config:JDBC) and doesn't get upset when I test anymore using "Using
Tony Grant wrote:
Can someone please point me to a precompiled jdbc driver for 7.1RC4 and
JDK1.3
I just don't have the patience to figure out what is going wrong here.
/usr/share/ant
Ant install made a /usr/share/java withe the jar files in it.
Java is installed on the machine
On Mon, Apr 09, 2001 at 03:33:19PM -0700, Homayoun Yousefi'zadeh wrote:
I first ran configure with the following options
./configure --with-perl --with-tcl --enable-odbc --with-java
--enable-syslog --enable-debug
and then compiled postgresql-7.1rc4 on Redhat 7.0 successfully
with
Thought that I share this with the group. Thanks Marco.
The problem was gone once I created a soft link to
JAVA_HOME/lib/tools.jar in the default directory
JAVA_HOME/jre/lib/ext/. I have not set specific CLASSPATH
variable and I could understand the problem better if
I had seen the problem when
Quoting Culley Harrelson [EMAIL PROTECTED]:
I'm in the process of implementing connection pooling
and the setup I'm using (http://www.javaexchange.com -
really slick!) has settings for min # connections and
max # connection. Any suggestions on where I should
set these values? min=2,
it depends on what kind of concurrent connections u will be getting..
For admin interfaces the kind of settingu mentioned might be OK but in
case it is a heavily loaded site then u need to think..
Anand
On Mon, Feb 12, 2001 at 02:55:08PM -0800, Culley Harrelson wrote:
I'm in the process of
Quoting elein [EMAIL PROTECTED]:
Redirecting to the jdbc list...
I'm a Java novice and I would like to be able to
use JDBC to get Points and Paths into a Java
program as native Java objects. Note that the
binary form of Paths is more than a simple array.
I know how to do this in C,
Quoting "[EMAIL PROTECTED]" [EMAIL PROTECTED]:
A few days ago I posted a query regarding a problem I had with errors I
was
incurring doing some nested queries with the jdbc driver. (having
recently
done a re-install my email history is in limbo for the moment)
Found some of my problems
Due to me moving home and my day job taking
precedence, I've not had chance to do anything since 7.0, so there is no
difference between 7.0, and 7.0.2.
I'm working though the backlog of patches bug
fixes at the moment. I had hoped to have something online last night, but I'm
still having
The problem could be in incorrectly implemented getTables.
PostgreSQL JDBC returns null. It's not defined that this column may be null,
like TABLE_CAT and TABLE_SCHEM. Actually, it returns just names, null for
everything else and "no remarks" for remarks.
From JDBC documentation:
4.
--
Peter T Mount [EMAIL PROTECTED], [EMAIL PROTECTED]
Homepage: http://www.retep.org.uk Contact details: http://petermount.com
PostgreSQL JDBC: http://www.retep.org.uk/postgres/
Java PDF Generator: http://www.retep.org.uk/pdf/
- Original Message -
From: "Jackson Ching" [EMAIL PROTECTED]
Chris Gokey writes:
Funny though, I can't figure out what the purpose of CREATE USER from
the psql prompt is used for anymore? It seems all user creation is done
from the unix prompt.
Actually createuser is a script that essentially calls psql -c "CREATE
USER ...".
--
Peter Eisentraut
Chris Gokey writes:
I am trying to connect via JDBC to the database. The database requires
authentification in the form of userid/password. Using psql, I
typed CREATE USER XXX IDENTIFIED BY YYY. But, the postmaster is till denying
access to the database. How do I create userid/password
From: [EMAIL PROTECTED] (Micheal H.)
Here's the code.It compiles but never gets past "Failed to load
postgresql driver"
your classpath setting might be wrong, it must includes the jar filename as
well, such as :
CLASSPATH = /usr/local/lib/postgresql.jar
you might also want to try :
On Fri, 15 Oct 1999, soundar rajan wrote:
Hi,
I'm using postgresql under Linux with jdk1.2. When I
try to 'make' under /src/interfaces/jdbc to get the
jdbc driver, I get the java.version to be 1.0b4. But,
this output doesn't generate any driver, or in fact
the postgresql.jar file
I am using postgresql under linux. Now that I need to
build up the jdbc driver for postgresql, when I make
under the directory /src/interfaces/jdbc.. I get an
error stating '(u' unexpected syntax...
The version returned by the make is 1.0b4. The
makeVersion.java file returns jdbc0 as the
On Tue, 20 Oct 1998, Peter T Mount wrote:
Message:Connection failed: java.net.ConnectException: Connection refused
This seems to be the most common problem ;-)
You are not running the backend with the -i arg, which turns on tcp/ip.
Thank you. Two characters more and everything works
201 - 261 of 261 matches
Mail list logo