[JDBC] JDBC setObject

2001-04-17 Thread Dave Cramer
Hi all, I have reported a problem with the PreparedStatement.setObject method on the general list, and using the bug database. I haven't received any replies yet. I am prepared to fix the problem myself, how do I go about this? Regards, Dave Cramer ---(e

Re: [JDBC] Still having trouble getting JDBC working

2001-04-19 Thread Dave Cramer
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. At

Re: [JDBC] Re: help mail about JDBC

2001-04-29 Thread Dave Cramer
Hi, The jar file is not version specific, however there are a few things about the 7.1 jar which could be useful. In otherwords the 7.0 jar will work fine for most things on the 7.1 version of postgres. However AFAIK the 8k rowlimit inside the jdbc driver has been removed in the 7.1 version of t

Re: [JDBC] multiple resource sets

2001-05-03 Thread Dave Cramer
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 A

[JDBC] Another patch

2001-05-09 Thread Dave Cramer
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){ >

[JDBC] Latest Binaries

2001-05-18 Thread Dave Cramer
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 unregis

Re: [JDBC] Ant ???

2001-05-28 Thread Dave Cramer
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 1

Re: [JDBC] Contributing fixes to Serilize.java

2001-05-28 Thread Dave Cramer
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

Re: [JDBC] Making the jar...

2001-06-05 Thread Dave Cramer
Title: Making the jar... No simply type make from the jdbc directory - Original Message - From: Skidmore, Walt To: '[EMAIL PROTECTED]' Sent: Friday, June 01, 2001 12:30 PM Subject: [JDBC] Making the jar... I know I've seen this on the list before, but I can'

[JDBC] setXXX patches

2001-07-11 Thread Dave Cramer
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, su

RE: [JDBC] [PATCH] setTimestamp(int, Timestamp) fails on null timestamp

2001-07-11 Thread Dave Cramer
Dejan, This has already been done in cvs, please get the binaries from http://jdbc.fastcrypt.com Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Dejan Vucinic Sent: July 11, 2001 5:43 PM To: [EMAIL PROTECTED] Subject: [JDBC] [PATCH] setTimestamp

RE: [JDBC] JDBC and stored procedures

2001-07-11 Thread Dave Cramer
bject: Re: [JDBC] JDBC and stored procedures On 11 Jul 2001 10:20:29 -0400, Dave Cramer wrote: > The GetProcedures function in the driver does not work. OK. I bet it is on the todo list =:-D > You should be able to a simple select of the stored proc however Yes! thank you very much

RE: [JDBC] alternative jdbc

2001-07-13 Thread Dave Cramer
, Dave Cramer wrote: > Can you send links, I wasn't aware there were any others? https://sourceforge.net/projects/jxdbcon/ seems to have files https://sourceforge.net/projects/jpsql/ Can't get at the docs for the moment Cheers Tony Grant -- RedHat Linux on Sony Vai

RE: [JDBC] alternative jdbc

2001-07-13 Thread Dave Cramer
Tony, Can you send links, I wasn't aware there were any others? Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Tony Grant Sent: July 13, 2001 10:10 AM To: [EMAIL PROTECTED] Subject: [JDBC] alternative jdbc Hello, I've been intrigued by the var

Re: [JDBC] JDBC and stored procedures

2001-07-11 Thread Dave Cramer
Tony, The GetProcedures function in the driver does not work. You should be able to a simple select of the stored proc however Dave On July 11, 2001 09:06 am, Tony Grant wrote: > Hello, > > I am trying to use a stored procedure via JDBC. The objective is to be > able to get data from more than

RE: [JDBC] unexpected error.

2001-07-17 Thread Dave Cramer
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: [

RE: [JDBC] [PATCH] setTimestamp(int, Timestamp) fails on null timestamp

2001-07-17 Thread Dave Cramer
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 Dave

RE: [JDBC] Methode is not yet implemented.

2001-07-20 Thread Dave Cramer
PM 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&

RE: [JDBC] Help! Driver cannot be loaded.

2001-07-23 Thread Dave Cramer
Brian, Make sure the jar is in the classpath on the server Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Yaochiu Huang Sent: July 17, 2001 9:46 PM To: [EMAIL PROTECTED] Subject: [JDBC] Help! Driver cannot be loaded. Dear Sir or Madam, I got a

RE: [JDBC] problem with serialization

2001-07-26 Thread Dave Cramer
u fix it. I had some problems with compiling , I would be very happy if could send me a new jar.   chris     Dave Cramer wrote:  That is definately a bug. Chris; do you have a way to compile the source? I can fix it and provide you with a driver to test if you need ?Dave

RE: [JDBC] problem with serialization

2001-07-25 Thread Dave Cramer
Chris, Can you send us your code. Or a snippet? Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of candreol Sent: July 25, 2001 10:22 AM To: [EMAIL PROTECTED] Subject: [JDBC] problem with serialization Hi! I am new here. I did a small test to try

RE: [JDBC] Large Objects

2001-07-29 Thread Dave Cramer
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

RE: [JDBC] Re: What needs to be done?

2001-08-01 Thread Dave Cramer
Bruce, I am willing to make my site the "official" site. For now we could just repoint the dns to jdbc.fastcrypt.com, or I could build them on my site, and ftp them into the postgres site? I think we do need to address it. A lot of people go there for answers. Dave -Original Message- F

RE: [JDBC] What needs to be done?

2001-08-01 Thread Dave Cramer
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, I

RE: [JDBC] no suitable driver

2001-08-03 Thread Dave Cramer
Matthieu Can you send us the code which causes the problem. It is very difficult to diagnose with this much information Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Matthieu Guyonnet-Duluc Sent: August 3, 2001 5:38 AM To: [EMAIL PROTECTED] Subj

[JDBC] Patch for jdbc1 compile

2001-08-03 Thread Dave Cramer
Index: Connection.java === RCS file: /home/projects/pgsql/cvsroot/pgsql/src/interfaces/jdbc/org/postgresql/Co nnection.java,v retrieving revision 1.21 diff -f -r1.21 Connection.java c1039 1040 info.put("user", PG_USER);

RE: [JDBC] Bug found in the driver

2001-08-08 Thread Dave Cramer
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

RE: [JDBC] Bug found in the driver

2001-08-08 Thread Dave Cramer
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 PRO

RE: [JDBC] NullPointerException on next()

2001-08-09 Thread Dave Cramer
Joseph, Can you post some code to reproduce the error please? Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Joseph Shraibman Sent: August 9, 2001 9:27 PM To: [EMAIL PROTECTED] Subject: [JDBC] NullPointerException on next() Using the jdbc 7.1.2

RE: [JDBC] BIGINT vs Java's long

2001-08-14 Thread Dave Cramer
This looks like a postgres problem, since I get the same problem in psql test=# update testbigint set fp0 = -9223372036854775808 where id = 1; ERROR: int8 value out of range: "-9223372036854775808" Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Be

RE: [JDBC] Postgresql 7.1.2 and StarOffice 5.2

2001-08-15 Thread Dave Cramer
Hi All, This is due to the current incompleteness of the jdbc driver; specifically the metadata functionality. Rene; a better piece of software to test for completeness is druid, which is a database design tool; it makes heavy use of the metadata features Dave -Original Message- From:

RE: [JDBC] hangs while getting large objects...

2001-08-15 Thread Dave Cramer
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] hang

RE: [JDBC] "No results" exception on executeQuery()

2001-08-16 Thread Dave Cramer
Chris, executeQuery will not return a resultset from an insert query. If you use execute instead it will work ok Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of chris markiewicz Sent: August 16, 2001 12:47 PM To: [EMAIL PROTECTED] Subject: [JDBC]

RE: [JDBC] Unable to connect to database

2001-08-17 Thread Dave Cramer
Peter, Do you have any other problems running java on this machine. The only reason you should ever get a segmentation fault with java is if the jvm is buggy. What jvm are you using. I know there are issues running sun's jvm on newer distributions. Dave -Original Message- From: [EMAIL

RE: [JDBC] Problem while using result set

2001-08-20 Thread Dave Cramer
Title: Message Ravi,   In order to help you; we will require more information;   The absolute best is a small snippet of code which reproduces the problem; but at the very least the code leading up to the rs.next, and following it   What version of postgres are you running? What version of

RE: [JDBC] select on multiple tables

2001-08-20 Thread Dave Cramer
Unfortunately id doesn't return A.c and B.c. Try it in psql... One way to solve this is to fix the backend to return fully qualified column names. Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rene Pijlman Sent: August 20, 2001 3:49 PM To: Carte

RE: [JDBC] Current CVS will not compile

2001-08-21 Thread Dave Cramer
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 an

RE: [JDBC] Re: [PATCHES] Array Support Fix

2001-08-21 Thread Dave Cramer
The jdbc1 driver is another story. The problem is that jdbc1 does not define Types.ARRAY so this constant isn't available during compile time. The two solutions I have been able to come up with are 1) make two Field.java files and place them in jdbc1, jdbc2 directories 2) use ants filtering fe

RE: [JDBC] Re: Couple of patches for jdbc driver

2001-08-22 Thread Dave Cramer
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] [mailto:[EMAI

RE: [JDBC] Re: Couple of patches for jdbc driver

2001-08-23 Thread Dave Cramer
Bruce, I can try to fill in whatever I can. Where is it? Can you fill in as much as you can? Dave -Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED]] Sent: August 23, 2001 10:46 AM To: Peter T Mount Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [JDBC] Re: Couple o

Re: [JDBC] next() and PreparedStatement

2001-08-30 Thread Dave Cramer
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

[JDBC] Read transactions don't work on 7.0.x db's

2001-08-30 Thread Dave Cramer
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; impo

Re: [JDBC] Read transactions don't work on 7.0.x db's

2001-08-31 Thread Dave Cramer
, the patch you have sent reports the entire file as being changed. That is not useful to review. Can you send a followup to the list with a better explaination and a patch that can be more easily be reviewed. thanks, --Barry Dave Cramer wrote: > Here's a patch to fix the problem b

Re: [JDBC] Read transactions don't work on 7.0.x db's Disregard my other patch

2001-08-31 Thread Dave Cramer
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]

Re: [JDBC] Read transactions don't work on 7.0.x db's

2001-09-03 Thread Dave Cramer
>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 sup

Re: [JDBC] Troubles using German Umlauts with JDBC

2001-09-04 Thread Dave Cramer
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 you

Re: [JDBC] Read transactions don't work on 7.0.x db's 2nd patch

2001-09-04 Thread Dave Cramer
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 -r1.26

Re: [JDBC] Why JDBC 1?

2001-09-04 Thread Dave Cramer
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

Re: [JDBC] Read transactions don't work on 7.0.x db's 3rd attempt

2001-09-05 Thread Dave Cramer
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Dave Cramer Sent: September 4, 2001 1:21 PM To: [EMAIL PROTECTED] Subject: Re: [JDBC] Read transactions don't work on 7.0.x db's 2nd patch Here is a revised patch with Barry's suggesti

Re: [JDBC] driver source code indentation

2001-09-05 Thread Dave Cramer
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 > > spac

Re: [JDBC] driver source code indentation

2001-09-06 Thread Dave Cramer
This does look good, I personally prefer more whitespace After ( and , as well as moving the opening brace to the next line. Public int foo(int x,int y){ x=y; } Turns into Public int foo( int x, int y ) { x = y; } I find this easier to read. Comments? Dave -Origina

Re: [JDBC] JDBC patch procedures (Re: [PATCHES] Patch for jdbc2 ResultSet.java)

2001-09-06 Thread Dave Cramer
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 (Re:

Re: [JDBC] error - NOTICE: current transaction...MORE DETAIL...

2001-09-06 Thread Dave Cramer
in the ability for the list to grow and shrink dynamically based on need. So if all connections are in use I will create more and after a specified period of time I delete the ones that haven't been used. This seems to be working quite nicely now. t.r. -Original Message----- From: Dave C

Re: [JDBC] error - NOTICE: current transaction...MORE DETAIL...

2001-09-06 Thread Dave Cramer
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 probl

Re: [JDBC] JDBC patch procedures (Re: [PATCHES] Patch for jdbc2 ResultSet.java)

2001-09-13 Thread Dave Cramer
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 (R

Re: [JDBC] jdbc newbie question

2001-09-16 Thread Dave Cramer
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 Russ

Re: [JDBC] getObject()

2001-09-24 Thread Dave Cramer
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 PROTECTED]

Re: [JDBC] Updated jdbc.postgresql.org website now in place ooops

2001-10-01 Thread Dave Cramer
Oops, I guess I should read the rest of the page, my apologies DAve -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Barry Lind Sent: October 1, 2001 2:46 PM To: [EMAIL PROTECTED] Subject: [JDBC] Updated jdbc.postgresql.org website now in place The su

Re: [JDBC] Updated jdbc.postgresql.org website now in place

2001-10-01 Thread Dave Cramer
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 Be

Re: [JDBC] Accents bug ?

2001-10-01 Thread Dave Cramer
Denis, It sounds like an encoding problem. You can check the encoding of the db by using \encoding in psql. There is a section in the docs on this http://www.postgresql.org/idocs/index.php?multibyte.html Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Beha

Re: [JDBC] why would an update only work if done twice?

2001-10-02 Thread Dave Cramer
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

Re: [JDBC] driver fails to handle strings in query statements properly

2001-10-02 Thread Dave Cramer
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 PROTECTE

Re: [JDBC] Updated jdbc.postgresql.org website now in place

2001-10-01 Thread Dave Cramer
Apparently it is, I read a post on the tomcat list that talked about it being deprecated. It really is a better idea. Dave -Original Message- From: Rene Pijlman [mailto:[EMAIL PROTECTED]] Sent: October 1, 2001 3:35 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [JDBC] Updat

[JDBC] Serialize

2001-10-05 Thread Dave Cramer
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 there are actually using it? Do we need/want it? My thoughts are: 1) There are plenty of p

Re: [JDBC] Serialize

2001-10-05 Thread Dave Cramer
rtom Rudoy's persistence layer www.sourceforge.net/projects/player The following code is an example of how to use Serialize in the postgres database package postgrestest; /** * Title:Postgres Tests * Description: * Copyright:Copyright (c) 2001 * Company: Ebox Inc * @author Dave Crame

Re: [JDBC] J2SE 1.4 and other patches

2001-10-18 Thread Dave Cramer
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

Re: [JDBC] [PATCHES] Ant configuration

2001-10-18 Thread Dave Cramer
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] [mailto:[EMAIL

Re: [JDBC] Please help me Urgent

2001-10-19 Thread Dave Cramer
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 ha

Re: [JDBC] J2SE 1.4 and other patches

2001-10-19 Thread Dave Cramer
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:

Re: [JDBC] [PATCHES] Ant configuration

2001-10-20 Thread Dave Cramer
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 p

Re: [JDBC] Does PG's JDBC support prepared statements at all?

2001-10-22 Thread Dave Cramer
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 i

Re: [JDBC] Code Fixes

2001-10-25 Thread Dave Cramer
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

[JDBC] Logging in the driver

2001-10-25 Thread Dave Cramer
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 t

[JDBC] Logging in the driver

2001-10-25 Thread Dave Cramer
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 to

Re: [JDBC] "No Suitable Driver"

2001-10-25 Thread Dave Cramer
Guy, Send me the pertinent code where you are loading the driver Dave -Original Message- From: Guy McArthur [mailto:[EMAIL PROTECTED]] Sent: October 25, 2001 6:28 PM To: Dave Cramer Cc: [EMAIL PROTECTED] Subject: RE: [JDBC] "No Suitable Driver" Huh. Well I have set up J

Re: [JDBC] PostgreSQL, JDBC, and Druid

2001-10-26 Thread Dave Cramer
State : null Any idea of what's going on? Thanks -- Dado Feigenblatt Wild Brain, Inc. Technical Director (415) 216-2053 [EMAIL PROTECTED] San Francisco, CA. Dave Cramer wrote: >Hi All,

[JDBC] Proposal to remove Serialize from the JDBC driver

2001-10-25 Thread Dave Cramer
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. http://www.amb

Re: [JDBC] StarOffice question

2001-10-24 Thread Dave Cramer
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 PROTECTED]]

Re: [JDBC] "No Suitable Driver"

2001-10-24 Thread Dave Cramer
You need to load the driver first and then get the connection, also the url for the connection s/b jdbc:postgresql://hostname/test&user=test&password=test" Assuming your database name is test So your code needs to execute Class.forName("org.postgresql.Driver") And then Connection db = Driver

Re: [JDBC] DatabaseMetaData.getTables()

2001-10-28 Thread Dave Cramer
Yes, I had a look at this, and it is confirmed to be broken in the CVS tip. You can try the driver from jdbc.postgresql.org. It may be more stable. This did work recently ;( Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Jason Davies Sent: October

Re: [JDBC] DatabaseMetaData.getTables()

2001-10-28 Thread Dave Cramer
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 h

Re: [JDBC] DatabaseMetaData.getTables()

2001-10-28 Thread Dave Cramer
: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

Re: [JDBC] OS version for driver

2001-09-26 Thread Dave Cramer
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 o

Re: [JDBC] JDBC Connection Pooling

2001-09-26 Thread Dave Cramer
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] JDB

Re: [JDBC] [Fwd: Re: Serialize]

2001-10-08 Thread Dave Cramer
major >>non-backwardly compatible ways in the future. >> >>thanks, >>--Barry There are two areas in the current code that I am uncomfortable with. This serialize code and the code in org/postgresql/xa. Have you looked at the xa code? thanks, --Barry Dave C

Re: [JDBC] JSP and PostgreSQL

2001-10-09 Thread Dave Cramer
Benjamin, Can you give us more of a hint as to how you are trying to use it. Perhaps a snippet of the relevant code. I presume you have added it to the CLASSPATH, or put it in the webapp lib? Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Benj

Re: [JDBC] [Q] Can't get simple JDBC connection to work: "no suitable driver"

2001-10-12 Thread Dave Cramer
Change "jdbc:postgres:test", To "jdbc:postgresql:test" Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Amandeep Jawa Sent: October 11, 2001 7:28 PM To: [EMAIL PROTECTED] Subject: [JDBC] [Q] Can't get simple JDBC connection to work: "no suitable

Re: [JDBC] driver fails to handle strings in query statements properly

2001-10-02 Thread Dave Cramer
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 sin

Re: [JDBC] driver fails to handle strings in query statements properly

2001-10-02 Thread Dave Cramer
16 PM 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&#

Re: [JDBC] driver fails to handle strings in query statements properly (ignore my last post)

2001-10-02 Thread Dave Cramer
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

Re: [JDBC] Question of JDBC Driver

2001-10-16 Thread Dave Cramer
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 Postg

Re: [JDBC] Function calls via JDBC

2001-10-16 Thread Dave Cramer
Just do a select with the function in the select Ie Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Oleg Lebedev Sent: October 12, 2001 6:29 PM To: Postgres SQL Mailing List Subject: [JDBC] Function calls via JDBC Hi, I created a PL/pgSQL funct

Re: [JDBC] J2SE 1.4 and other patches

2001-10-16 Thread Dave Cramer
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] Subjec

Re: [JDBC] J2SE 1.4 and other patches

2001-10-17 Thread Dave Cramer
; the > ant 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 P

Re: [JDBC] [PATCHES] Ant configuration

2001-10-17 Thread Dave Cramer
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

Re: [JDBC] driver fails to handle strings in query statements properly

2001-10-02 Thread Dave Cramer
;WAQJAA' thanks, --Barry Dave Cramer wrote: > 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 ot