[JDBC] ? (question mark) characters

2001-08-30 Thread Ricardo Pardini
Ok, I tried all the drivers currently available at http://jdbc.fastcrypt.com. They all seem to correct the problem with long (>8k) SQL statements, but they're all broken considering Portuguese characters like áéíóú (aeiou with accent)... they are replaced by question marks (?)... any ideas? Sho

RE: [JDBC] ? (question mark) characters

2001-08-30 Thread Rene Pijlman
Ricardo Pardini wrote: > they're all broken considering Portuguese characters > like áéíóú (aeiou with accent)... they are replaced > by question marks (?)... any ideas? What's the character encoding of the database? See http://postgresql.demunnikservices.nl/users-lounge/docs/7.1/admi n/multibyte

Re: [JDBC] ? (question mark) characters

2001-08-30 Thread Ricardo Pardini
Thank you all for your help: Dia Thursday, 30 de August, 2001 10:42, Rene Pijlman wrote: > > like áéíóú (aeiou with accent)... they are replaced > > by question marks (?)... any ideas? > What's the character encoding of the database? It doesn't matter. I have tried it with SQL_ASCII, ISO-8859-1

[JDBC] Dúvida

2001-08-30 Thread alan
Bom, eu estou com milhões de dúvidas, mas vamos por partes Eu não sei como instalar o PostgreSQL Eu baixei o arquivo ZIP " postgresql-7.1.2.tar.zip " No site da Postgre, extraí o arquivo para uma pasta, mas não vejo Nenhum executável para instalar ou já começar a editar algo em SQL Como faço para

[JDBC] PostgreSQL/JDBC Test Suite Howto

2001-08-30 Thread Rene Pijlman
I've written a brief Howto document about the JDBC test suite that's in the source tree. Liam Stewart contributed a section on the standard JDBC 2 test suite from Sun. Hopefully, this will make it easier for developers working on the JDBC driver to use and extend the test suite(s) to improve the

Re: [JDBC] Patch for broken JDBC's getColumn()

2001-08-30 Thread Rene Pijlman
On Tue, 28 Aug 2001 23:32:43 +0200, you wrote: >Attached is a patch for JDBC's getColumn() function that was broken / >flawed in the following ways: > >1. Only returned columns that had a default value defined, rather than >all columns in a table Aha, so that's it! I noticed it returned a funny

Re: [JDBC] Status of JDBC test suite?

2001-08-30 Thread Rene Pijlman
On Wed, 29 Aug 2001 13:34:51 -0400, you wrote: >I assume that you're wondering about the JDBC 2 test suite from Sun. >I've attached a note that has some detailed instructions on getting the >suite to work with PostgreSQL. Rene, do you want to post this on your >PostgreSQL JDBC page? Thanks! I've

[JDBC] Patch for broken JDBC's getColumn()

2001-08-30 Thread Jeroen van Vianen
Hi, Attached is a patch for JDBC's getColumn() function that was broken / flawed in the following ways: 1. Only returned columns that had a default value defined, rather than all columns in a table 2. Used 2 * N + 1 queries to find out attributes, comments and typenames for N columns. By usi

[JDBC] RE: [JDBC] Dúvida

2001-08-30 Thread Kovács Péter
Na akkor ezt mindjárt meg is beszélhetjük. Én például nem beszélek portugálul, de a nyelv nagyon tetszik, és szívesen tanulnák portugálul, ha alkalma volna rá. A PostgreSQL-t nagyon szeretem, és elképeszt, hogy milyen gyorsan halad a fejlesztés. Kiváncsi vagyok, mennyire stabil és mennyire bírja a

[JDBC] Transaction Isolation - read uncommitted

2001-08-30 Thread Ralf Reissig
Hi all, i am trying to find a way reading uncommitted data within a single transaction, but it seems there is no way to do a "TRANSACTION_READ_UNCOMMITTED" on connections in Postgresql as it works for Oracle or Informix. I there any support in postgres for reading uncommited data without a read

[JDBC] Re: ? (question mark) characters

2001-08-30 Thread Michael Stephenson
> Ok, I tried all the drivers currently available at http://jdbc.fastcrypt.com. > They all seem to correct the problem with long (>8k) SQL statements, but > they're all broken considering Portuguese characters like áéíóú (aeiou with > accent)... they are replaced by question marks (?)... any ideas

[JDBC] Re: [PATCHES] patch for JDBC1 build problems

2001-08-30 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 to fix the current issues with building under jdbc1. > This patch moves the logic that looks up

[JDBC] Re: [PATCHES] patch for JDBC1 build problems

2001-08-30 Thread Bruce Momjian
Thanks. Patch applied. > > Attached is a patch to fix the current issues with building under jdbc1. > This patch moves the logic that looks up TypeOid, PGTypeName, and > SQLTypeName from Field to Connection. It is moved to connection since > it needs to differ from the jdbc1 to jdbc2 ve

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

Re: [JDBC] Transaction Isolation - read uncommitted

2001-08-30 Thread Rene Pijlman
On Mon, 27 Aug 2001 15:25:23 -0700, Ralf Reissig wrote: >I there any support in postgres for reading uncommited data >without a read lock ? No, there isn't. A dirty read is not possible with PostgreSQL. This is not JDBC specific. See http://www.postgresql.org/idocs/index.php?sql-set-transaction.

[JDBC] Re: [BUGS] Bug #428: Another security issue with the JDBC driver.

2001-08-30 Thread David Daney
I am sorry to keep going back and forth on this, but: The original patch is correct and does the proper thing.  I should have tested this before sounding the alarm. AccessController.doPrivileged()Propagates SecurityExceptions without wrapping them in a PrivilegedActionException so it appears th

Re: [JDBC] Re: [BUGS] Bug #428: Another security issue with the JDBC driver.

2001-08-30 Thread David Daney
Sorry about that, things are never as easy as they seem.  The answer appears to be to filter PG_Stream.java in a similar manner as is done to Driver.java Attached please find two files. 1) diffs for build.xml. 2) PG_Stream.java.in I hope this can now be put to bed. David Daney. Bruce Mom

[JDBC] Re: [BUGS] Bug #428: Another security issue with the JDBC driver.

2001-08-30 Thread David Daney
It is now unclear to me the the catch(PrivilegedActionException pae) part of the patch is correct.  If a SecurityException is thrown in Socket() (as might happen if the policy file did not give the proper permissions), then it might be converted into a ClassCastException, which is probably the w

Re: [JDBC] [PATCHES] Patch for broken JDBC's getColumn()

2001-08-30 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. > Hi, > > Attached is a patch for JDBC's getColumn() function that was broken / > flawed in the following ways: > > 1. On

[JDBC] Re: ? (question mark) characters

2001-08-30 Thread Barry Lind
Ricardo, Is your database compiled for multibyte support? And what character set is the database you are connecting to created with? (to get the database character set do a 'psql -l'). If the answer to the first question is no or the answer to the second question is 'SQL_ASCII', then only

[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

[JDBC] Regarding Vacuumdb

2001-08-30 Thread Bhuvaneswari
hi, I am getting the following error while doing vacuumdb, ERROR: mdopen: couldn't open test1: No such file or directory vacuumdb: database vacuum failed on db1. Here 'db1' is the database and 'test1' is a table. When, displaying the structure of the table 'test1', it comes correctly. But I can'

[JDBC] Majordomo being upgraded ...

2001-08-30 Thread Marc G. Fournier
Its been much much too long since I've upgraded Majordomo2 on the server, so this is the last email I'm sending out prior to upgrading her today ... if anyone notices the lists go suddenly quiet, or the way it works changing, please let me know ... My main worry is that in the past 6+ months, so