Corey,
This looks like it should work.
The only thing I can think of is that you need to export the classpath so
that it is visible outside of the .cshrc file?
what to you get when you execute
echo $CLASSPATH
The only other possibility is that you are using a real old version of the
driver.
Rolf,
Try this
ResultSet orderlines = _st.executeQuery();
while(orderlines.next()){
println(orderlines.get(1));
}
orderlines.close();
_st.close();
Dave
- Original Message -
From: Rolf Schillinger [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, May 02, 2001 10:12 AM
Hopefully we can slip this in before 7.1.1
This patch fixes a bug which occurs when setObject(1,obj) is called and obj
is of type Object, and is null
Regards,
Dave
[root@ebox2 jdbc2]# diff PreparedStatement.java.orig PreparedStatement.java
517a518,521
if (null == x){
For anyone looking for latest jar files; I have built the jars from the
latest code snapshot and they are available for download at
http://jdbc.fastcrypt.com
Dave
---(end of broadcast)---
TIP 2: you can get off all lists at once with the
If you want to avoid compiling the driver you can get the binaries for
postgres at
http://jdbc.fastcrypt.com
Dave
- Original Message -
From: rjtalbo [EMAIL PROTECTED]
To: Bruce Momjian [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, May 26, 2001 12:07 PM
Changes have been made to the code just recently, and just submit your
patches to the list
Dave
- Original Message -
From: Ken K [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, May 19, 2001 4:13 PM
Subject: [JDBC] Contributing fixes to Serilize.java
Hi,
I just used CVS to
Bruce,
Here are the patches. I haven't tested them personally, but I did build a jar
for the guy who asked for it. He downloaded it, and said it worked. The jdbc1
patch is completely untested.
They are simple enough that they should work (The little guy on my left
shoulder is saying sure,
Title: Message
It's
likely not the jdbc driver, but the postgres setup. do you have the ip address
setup in pg_hba.conf?
Dave
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On
Behalf Of jpSent: July 17, 2001 11:39 AMTo:
[EMAIL PROTECTED]Subject:
Dejan,
Yes you are correct, I will submit a patch shortly.
Dave
-Original Message-
From: Dejan Vucinic [mailto:[EMAIL PROTECTED]]
Sent: July 11, 2001 7:20 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: [JDBC] [PATCH] setTimestamp(int, Timestamp) fails on null
timestamp
To: [EMAIL PROTECTED]
Subject: Re: [JDBC] Methode is not yet implemented.
Dave Cramer schrieb:
Joerg,
Have you received a satisfactory answer to this problem yet?
Dave
Hi Dave and the rest :)
I do many tests in the moment an I think I made a mistake (i'm not
sure). Perhaps, I misunderstand
Yes, you have to commit the transaction at the end
Con.commit(), or con.rollback() I think.
Dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Tom Lane
Sent: July 29, 2001 4:20 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [JDBC] Large
Rene,
Certainly the blob support needs to be done. That seems to be high on
the list
Dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Rene Pijlman
Sent: August 1, 2001 3:52 PM
To: [EMAIL PROTECTED]
Subject: [JDBC] What needs to be done?
Hello,
Denis,
Do you get this error with current binaries from
http://jdbc.fastcrypt.com
Regards,
Dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Denis Bucher
Sent: August 8, 2001 7:44 AM
To: Steve Wampler
Cc: PGSQL-JDBC
Subject: Re: [JDBC] Bug found
Denis,
Can you do me a favour, and post a small program which can reproduce
your results.
If you have already done so, let me know and I will go and find it.
Dave
-Original Message-
From: Denis Bucher [mailto:[EMAIL PROTECTED]]
Sent: August 8, 2001 9:56 AM
To: PGSQL-JDBC
Cc: [EMAIL
Chris,
Try using the latest jar files from http://jdbc.fastcrypt.com
DAve
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of chris markiewicz
Sent: August 15, 2001 3:04 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: [JDBC]
I can try to have a look at this later tonight.
Dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Bruce Momjian
Sent: August 21, 2001 11:35 AM
To: PostgreSQL jdbc list
Subject: [JDBC] Current CVS will not compile
Can someone look at current CVS
The other reason for telling people who are experiencing problems with
the driver to get the latest version is that their bug has probably
already been fixed.
However a certain degree of caution should probably be exercised here.
-Original Message-
From: [EMAIL PROTECTED]
Hi Mano,
No the problem is not with jdbc.
I do see a couple of things though
1) the semi-colon isn't necessary, but shouldn't break the code? try
removing it.
2) returning the row that way looks a little dangerous. It is possible
that the statement associated with the row would be gone after
The following code fails on a 7.0 db, but works on a 7.1 db
It works fine with the 7.0 jar, but not with the latest code
I had a quick look and everything looks ok. I am going to keep looking
but I thought I would throw this out and see if anyone knows what is
going on
Dave
package test;
The first one considered everything changed ?
I also fixed the rollback method in this one, assuming it was broken the
same way
Dave
Connection.patch
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
From my POV there are two costs here:
1) The speed degradation by supporting multiple versions of postgres.
I tend not to be too concerned by speed, and more concerned with ease of
use. If speed really becomes an issue I can go into the code and remove
the offending inefficiency caused by
Alexander,
You have to set the encoding when you make the connection.
Properties props = new Properties();
props.put(user,user);
props.put(password,password);
props.put(charSet,encoding);
Connection con = DriverManager.getConnection(url,props);
where encoding is the proper encoding for your
Here is a revised patch with Barry's suggestions implemented
Dave
Index: Connection.java
===
RCS file:
/home/projects/pgsql/cvsroot/pgsql/src/interfaces/jdbc/org/postgresql/Connection.java,v
retrieving revision 1.26
diff -c
Yes, it is, but many of the libraries, and methods which are used in
version 2 of the driver aren't available in jdk1 so it won't compile or
run.
Dave
On Tue, 2001-09-04 at 12:50, Rene Pijlman wrote:
Perhaps this is a silly question, but why do we have separate
JDBC 1 and 2 drivers?
Isn't
Well, my vote would be for a 2 space indent.
Dave
On Tue, 2001-09-04 at 16:59, Tom Lane wrote:
Barry Lind [EMAIL PROTECTED] writes:
I am OK with the style used for the C code. However I would like the
following additional step done for the java code: replace all tabs with
spaces.
I
I am willing to lend a hand if required
Dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Bruce Momjian
Sent: September 6, 2001 4:08 PM
To: Rene Pijlman
Cc: Tom Lane; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [JDBC] JDBC patch procedures
Chris,
I'm curious; why are you using a hashtable for available connections,
and how do you use it?
I have been using a connection pool that uses a linked list, in LIFO
mode to store available connections.
I can donate the pool code if need be, it has been running for over a
year with no
Presuming that the spelling mistakes in the command line below are just
that, I would suggest
Putting the driver jar file into the $JAVA_HOME/jre/lib/ext directory,
or adding it to the classpath
Dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of
Sorry, they were until this morning probably older than Aug 24, I
rebuilt them from source last evening
Dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Antonio Fiol
Bonnín
Sent: September 24, 2001 11:43 AM
To: Antonio Fiol Bonnín; [EMAIL
Looks good! Great work,
One thing that isn't urgent but should be addressed in the future is now
that CLASSPATH is deprecated, we should add instructions for placing the
jar into the jre/lib/ext directory.
Dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On
Caoilte,
One thing that would be useful here is the logs from the postgres
backend to see what postgres is actually seeing. Is it possible to get a
look at the logs. I run code like yours in my applications with no
problems
Dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
This is coming back from the backend as type unknown. If the single
quotes are removed it works ok?
I suppose we could return it as a string when we are in doubt? Is this
reasonable since there are many other types it should be returned as?
Dave
-Original Message-
From: [EMAIL
Peter,
Yes, that makes a lot of sense. One problem might exist with the
sql.Types
Jdk 1.4 probably defines extra types which won't be defined in jdk 1.3.
Dave
-Original Message-
From: Peter Eisentraut [mailto:[EMAIL PROTECTED]]
Sent: October 18, 2001 1:41 PM
To: Joseph Shraibman
The one issue I have with a non ant based build system is that it makes
it difficult to build the driver on a windows machine.
Currently I can build the driver on windows without using cygwin
What problems does ant present?
Dave
-Original Message-
From: [EMAIL PROTECTED]
You need to edit the pg_hba.conf file and add your host 199.9.200.199 to
the file
Dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of dario silva
Sent: October 15, 2001 3:12 PM
To: [EMAIL PROTECTED]
Subject: [JDBC] Please help me Urgent
Hello.
I
Peter,
Yes, that makes a lot of sense. One problem might exist with the
sql.Types
Jdk 1.4 probably defines extra types which won't be defined in jdk 1.3.
Dave
-Original Message-
From: Peter Eisentraut [mailto:[EMAIL PROTECTED]]
Sent: October 18, 2001 1:41 PM
To: Joseph Shraibman
Cc:
Dave Cramer writes:
The one issue I have with a non ant based build system is that it
makes it difficult to build the driver on a windows machine.
That is a valid concern that we're going to have to think about before
we move to another method.
What problems does ant present?
* Ant
Remove the single quotes from '?' there is no need for them.
Dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Dr. Evil
Sent: October 20, 2001 7:14 PM
To: [EMAIL PROTECTED]
Subject: [JDBC] Does PG's JDBC support prepared statements at all?
There
Paul,
Please send a patch to this list
Thanks,
Dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Paul
Sent: October 24, 2001 8:47 PM
To: [EMAIL PROTECTED]
Subject: [JDBC] Code Fixes
Hi,
I have been working with your driver along with Forte for
I am looking at trying to debug the driver for staroffice.
Unless someone can tell me otherwise, this requires logging. Currently
the driver has a rudimentary mechanism for logging
DriverManager.println()
This is ok, but it doesn't provide for various levels of debugging.
One possibility is
Hi folks
I would like to propose removing the Serialize code from the driver.
My reasons for doing so include:
1) It adds unnecessary complexity to the driver
2) I don't think this is the correct place for this code
3) There are much better ways to achieve persistence available.
It has to go into the staroffice/lib directory if you are using
staroffice6.
I quickly tried it and it fails due to a nullpointer exception. It is on
my todo list to figure out.
If you get it working let me know
Dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
You need to load the driver first and then get the connection, also the
url for the connection s/b
jdbc:postgresql://hostname/testuser=testpassword=test
Assuming your database name is test
So your code needs to execute
Class.forName(org.postgresql.Driver)
And then
Connection db =
It appears the getBytes was previously being used to return a byte array
of any arbitrary column.
Fixes for blobs seem to have broken this. The question is as Jason
pointed out which do we fix.
It doesn't seem unreasonable to be able to return a byte array for any
arbitray column. On the other
:34 AM
To: Dave Cramer
Cc: [EMAIL PROTECTED]
Subject: Re: [JDBC] DatabaseMetaData.getTables()
On Sun, Oct 28, 2001 at 07:14:42AM -0500, Dave Cramer wrote:
It appears the getBytes was previously being used to return a byte
array of any arbitrary column.
Fixes for blobs seem to have broken
Mihai,
The jdk is sun's jdk, and it should work on any platform
Dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Mihai Gheorghiu
Sent: September 26, 2001 12:45 PM
To: [EMAIL PROTECTED]
Subject: [JDBC] OS version for driver
The most recent driver
Jack,
No, it does not include connection pooling, there are quite a few
readily availble connection pools out there
Dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of jcooney
Sent: September 26, 2001 10:55 AM
To: [EMAIL PROTECTED]
Subject: [JDBC]
/xa. Have you looked
at the xa code?
thanks,
--Barry
Dave Cramer wrote:
While fixing the handling of unknown data type in the result set I
was faced with wading through the Serialize code. I am
wondering if this is really a required/desireable feature? How
many people out
I tried it on a table which id was an int
Using select 'id' as xxx from ... Returns xxx as an unknown type
Using select id as xxx from... returns xxx as an int
I have no idea how the backend handles this, but if it can figure it out
in one instance why can't it figure it out when I put single
To: [EMAIL PROTECTED]
Cc: 'Barry Lind'; [EMAIL PROTECTED]
Subject: Re: [JDBC] driver fails to handle strings in query statements
properly
Dave Cramer [EMAIL PROTECTED] writes:
I tried it on a table which id was an int
Using select 'id' as xxx from ... Returns xxx as an unknown type
Using
Ok, I need some sleep, now I see what it does, which is probably not
what the user wanted, but I have fixed the driver to it doesn't throw an
exception.
Dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Dave Cramer
Sent: October 2, 2001 9:12 PM
The updateable result set functionality has not been implemented.
Dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Adile Abbadi
Sent: October 12, 2001 9:57 PM
To: [EMAIL PROTECTED]
Subject: [JDBC] Question of JDBC Driver
Hi there,
I'm using
What do you see wrong with the build process?
Ant is used to build the driver!
Dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Joseph Shraibman
Sent: October 16, 2001 5:45 PM
To: Rene Pijlman
Cc: Mark Lillywhite (pg-jdbc); [EMAIL PROTECTED]
files to use it when it detects a jdk of 1.4+
Dave Cramer wrote:
What do you see wrong with the build process?
Ant is used to build the driver!
Dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Joseph
Shraibman
Sent: October 16, 2001 5:45
Given that ant is (or is becoming) the defacto standard for building
java apps I am reluctant to remove it. A number of projects simply
include the ant jar in the download.
Dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Barry Lind
Sent: October
55 matches
Mail list logo