[JDBC] JDBC Connection Pooling

2001-09-26 Thread jcooney
Does the 7.1-1.3 driver availalble on fastcrypt support JDBC 2.0 driver based connection pooling? I'm more than willing to look up the answer to this myself if someone can point be towards some technical documentation. Thanks, jc Jack Cooney Senior Consultant MONTAGE.DMC eBusiness Services A

[JDBC] OS version for driver

2001-09-26 Thread Mihai Gheorghiu
The most recent driver on jdbc.fastcrypt.com is 9/24; it is compiled on RH7.0 The most recent rpm for PG is 8/17, compiled on RH7.1. Is there a location where I can find it compiled on RH7.1 (and Sun jdk1.3)? ---(end of broadcast)--- TIP 4: Don't '

Re: [JDBC] OS version for driver

2001-09-26 Thread Mihai Gheorghiu
Thanks, everybody! -Original Message- From: Barry Lind <[EMAIL PROTECTED]> To: Mihai Gheorghiu <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Wednesday, September 26, 2001 2:38 PM Subject: Re: OS version for driver >The jdbc driver is OS independent. It doesn't mat

[JDBC] sequences in JDBC

2001-09-26 Thread Nick Fankhauser
I'm trying to use a sequence via JDBC, but I'm having a problem. The prepared statement I'm using looks like this: final String address_lineInsert = "insert into address_line( address_id, address_line_id, address_line_text) values (?,?,?)"; I set the values like so: insertAddressLine.setString

[JDBC] connection error

2001-09-26 Thread Russ McBride
Hi, I've registered by driver with the drive manager, but I can't get a connection. Does anyone know what this error means: No pg-hba.conf entry for host 169.254.23.69 user: postgres database: testdb best, Russ ---(end of broadcast)--- TIP

Re: [JDBC] connection error

2001-09-26 Thread Nick Fankhauser
Russ- JDBC connects using TCP/IP and this indicates that your host machine doesn't have a line in /etc/postgresql/pg_hba.conf allowing the requested connection. This is necessary even if you are connecting to localhost. Here's what our pg_hba.conf looks like: localall

[JDBC] blobs in a client/server environment

2001-09-26 Thread Matt Fair
Hello, I have been playing around with storing images with setBinaryStream and getBinaryStream for a couple of days now, but I am continually running into a problem. I don't know if I am getting the data in the right format or not, but I am not able to get my image from the database. I have a

[JDBC] Re. conection error

2001-09-26 Thread Russ McBride
Thanks Nick, The first line in my pg_hba.conf file is: local alltrust which should be all that is needed to allow a jdbc connection over ip from 'postgres' on a local machine (and it shouldn't be a problem that the connection program sends the password as

Re: [JDBC] sequences in JDBC

2001-09-26 Thread Dave Harkness
At 01:47 PM 9/26/2001, Nick Fankhauser wrote: >I'm trying to use a sequence via JDBC, but I'm having a problem. > >The prepared statement I'm using looks like this: > >final String address_lineInsert = "insert into address_line( address_id, >address_line_id, address_line_text) values (?,?,?)"; Th

Re: [JDBC] sequences in JDBC

2001-09-26 Thread Nick Fankhauser
Thanks Dave! That's exactly what I needed to know. -Nick > The problem is that it is treating "nextval..." as a literal string and > then trying to convert it to a number (as that is the column's type). You > need to change it to this: > > final String address_lineInsert = "insert into address_li

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] [GENERAL] JDBC update wont, plz help.

2001-09-26 Thread Barry Lind
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 us

Re: [JDBC] JDBC Connection Pooling

2001-09-26 Thread Barry Lind
No it does not. thanks, --Barry jcooney wrote: > Does the 7.1-1.3 driver availalble on fastcrypt support JDBC 2.0 driver based > connection pooling? > > I'm more than willing to look up the answer to this myself if someone can > point be towards some technical documentation. > > Thanks, >

Re: [JDBC] OS version for driver

2001-09-26 Thread Barry Lind
The jdbc driver is OS independent. It doesn't matter which platform the driver is compiled on, it will run on any platform that supports a java runtime. As far as jdk1.2 vs jdk1.3 goes, a driver compiled by a 1.2 jdk will work fine under jdk1.3. The code is identical for these two jdk relea