Re: [JDBC] UpdateableResultSet patch (not finished yet!)

2001-09-16 Thread Barry Lind
Ola, I don't think this logic should be coded into the JDBC driver. Instead I think it makes much more sence to have this logic coded into the backend and then exposed via JDBC and the other interfaces. I know that someone is working on doing the same thing in ODBC. Having the same code do

Re: [PATCHES] [JDBC] isNullable()

2001-09-16 Thread Barry Lind
Patch looks good. thanks, --Barry Rene Pijlman wrote: > Attached is a patch that fixes ResultSetMetaData.isNullable() in > the JDBC driver. > > This method is currently unimplemented and always returns > ResultSetMetaData.columnNullable. This is obviously incorrect > when a column is defined wi

Re: [JDBC] default fetch size

2001-09-16 Thread Barry Lind
Dave, The protocol for the clients to talk with the backend server doesn't support the concept of a fetch size. When a query is executed it's entire result is sent to the client. (You can explicitly work around this by using cursors see the DECLARE and FETCH sql commands). thanks, --Barry

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

[JDBC] jdbc newbie question

2001-09-16 Thread Russ McBride
Hi guys, I've got a postgreSQL database setup and installed with jdbc, but I'm having trouble getting WebObjects to make a connection to the database. I'm getting a "no driver detected" error message. I've tried to load up the driver using: java -Djdbc.drivers=org.postgeresql.Drver example.

Re: [JDBC] Need help with JDBC driver. Problem, - getExportedKeys =

2001-09-16 Thread Justin Clift
Hi René, Did you see my email to the JDBC mailing list earlier today, in response to someone question regarding finding out RI information from the PostgreSQL system catalogs? >From that email, the SQL needed to find out the RI triggers is : SELECT c.relname as "Trigger Table", substr(f.proname

Re: [JDBC] isNullable()

2001-09-16 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://candle.pha.pa.us/cgi-bin/pgpatches I will try to apply it within the next 48 hours. > Attached is a patch that fixes ResultSetMetaData.isNullable() in > the JDBC driver. > > This method is currently unimplem

Re: [JDBC] UpdateableResultSet patch (not finished yet!)

2001-09-16 Thread Bruce Momjian
Sorry, wrong message. This is not in the patch queue. > Hello, > > I have, for some time, now, been working on the updateable resultset > class. Please have a look at http://www.miranda.org/~ola/jdbcupr.diff, and > let me know what you think. It is only rudimentary at the moment. > > Things t

Re: [JDBC] UpdateableResultSet patch (not finished yet!)

2001-09-16 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://candle.pha.pa.us/cgi-bin/pgpatches I will try to apply it within the next 48 hours. > Hello, > > I have, for some time, now, been working on the updateable resultset > class. Please have a look at http://www