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

[JDBC] "No Suitable Driver"

2001-10-24 Thread Guy McArthur
Hi, I'm trying to get a small test program going. I have built PostgreSQL 7.1.3 on RedHat 6.2 with --java, installed and created databases, verified with psql. The postgresql.jar is on my classpath. My pg_hba.conf has: localall password host

Re: [JDBC] [PATCHES] DatabaseMetadata patch

2001-10-24 Thread Bruce Momjian
> The patch is missing the corresponding fix for > jdbc1/DatabaseMetaData.java. Can you resubmit the patch with a fix for > both occurances of the problem? Otherwise the fix looks fine. I have applied the jdbc2 version. It would be nice to have a jdbc1 version too. Thanks. -- Bruce Momj

Re: [JDBC] [PATCHES] DatabaseMetadata patch

2001-10-24 Thread Barry Lind
The patch is missing the corresponding fix for jdbc1/DatabaseMetaData.java. Can you resubmit the patch with a fix for both occurances of the problem? Otherwise the fix looks fine. thanks, --Barry Bruce Momjian wrote: > Here is a patch for DatabaseMetaData to show precision properly. It is

Re: [JDBC] [PATCHES] DatabaseMetadata patch

2001-10-24 Thread Bruce Momjian
Patch applied. Thanks. If you can send a jdbc1 version, that would be great. --- > Here is a patch for DatabaseMetaData to show precision properly. It is > from Mark Lillywhite. I am adding to the patch queue. > > --

Re: [JDBC] [PATCHES] DatabaseMetadata patch

2001-10-24 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > + tuple[8] = > +Integer.toString((attypmod & 0x) - VARHDRSZ).getBytes(); In the backend sources, we subtract VARHDRSZ *first* and then AND with . Not sure if this will ever yield a different result, but I'd say it should be

Re: [JDBC] Accents bug ?

2001-10-24 Thread Denis Bucher
At 16:15 04.10.01 -0700, you wrote: Hello ! Not reading the mailing-list very often I only answer now. I suppose I started the thread about this bug... >This is a follow-up to my post a few days ago about the JDBC driver >chopping of strings at non-ASCII characters. First a brief summary of >t

Re: [JDBC] StarOffice question

2001-10-24 Thread tony
On Wed, 2001-10-24 at 12:53, Dave Cramer wrote: > 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 The message says "una

Re: [JDBC] StarOffice question

2001-10-24 Thread Antonio Fiol Bonnín
I'm afraid you should use ODBC instead of JDBC with StarOffice. See http://odbc.postgresql.org I have just checked it out, and have been unable to find what I had found about StarOffice. Hope that helps. Antonio tony wrote: > where do I put the postgresql.jar to connect StarOffice to Postgre

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]]

[JDBC] alternative driver jxDBCon

2001-10-24 Thread Chantal Ackermann
dear all, has anyone made some experience using the jdbc driver jxDBCon for PostgreSQL? it is an alternative to the driver released by PostgreSQL. (http://jxdbcon.sourceforge.net) chantal ---(end of broadcast)--- TIP 3: if posting/reading throug

[JDBC] StarOffice question

2001-10-24 Thread tony
where do I put the postgresql.jar to connect StarOffice to Postgres? I have it in the /usr/java/jdk1.3/lib directory on the client machine (the one running staroffice) Cheers Tony Grant -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html Macromedia UltraDev with Po

Re: [JDBC] Compliance? Plans?

2001-10-24 Thread Barry Lind
Per-Olof, Thanks for the constructive feedback. Let me try to answer your questions: > 1. How is the driver compliance tests carried out? The test harness from > sun? The sun test harness has been run. However the sun test harness is only for jdbc2 + the enterprise extensions. As far as I

Re: [JDBC] JDBC issues for JDK1.4

2001-10-24 Thread Barry Lind
Mark, Any help on moving the jdbc code base forward is more than welcome. In briefly looking over your suggestions below they all seem fine to me. (Of course the devil is in the details). I would also suggest looking at http://lab.applinet.nl/postgresql-jdbc for a list of where we are lacki

Re: [JDBC] [PATCHES] Ant configuration

2001-10-24 Thread Ned Wolpert
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 23-Oct-2001 Peter Eisentraut wrote: > Gunnar Rønning writes: >> | * In numerous attempts I have failed to convince Ant to place the built >> | files in a tree different from the source tree. This really makes it a >> | pain to build for multiple

Re: [JDBC] [PATCHES] DatabaseMetadata patch

2001-10-24 Thread Bruce Momjian
Here is a patch for DatabaseMetaData to show precision properly. It is from Mark Lillywhite. I am adding to the patch queue. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Bl