Re: [JDBC] Accents bug ?

2001-10-25 Thread Jean-Christophe ARNU

On 24 Oct 2001 17:51:56 +0200, Denis Bucher wrote:
 You exactely have the same problem as I have.
 And my base is also UNICODE...

 Well, are you sure ? With *all* tools, that can be psql or pgdump_all, 
 everything seems
 right, look at an extract of a dump :
 6   6   PPN Nigiri mixtet   t
 7   7   PNS Nigiri saké t   t
 8   8   PNT Nigiri maguro   t   t
 9   9   PNM Nigiri saké maguro  t   t
 43  43  PSM Petit Nigiri maguro t   t
 44  44  PSS Petit Nigiri saké   t   t

Maybe you'll just have to force charset at connexion opening just like
this : 
Connection conn =
DriverManager.getConnection(jdbc:postgresql://myDataBase?charSet=iso-8859-1,uid,pw);



You can force charSet to different values. There's a complete paragraph
on Postgresql doc on supported charsets.

Hope it would help.
-- 
Jean-Christophe ARNU
s/w developer 
Paratronic France
 
  Dans un premier temps, ayons l'esprit large et naviguons à la voile et
  à la vapeur. Si la promiscuité entre les deux communautés devient
  insupportable, il sera toujours temps d'organiser l'apartheid.
  -+- PM in: Guide du Cabaliste Usenet - Bien séparer les enfilades -+-


---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org



[JDBC] Code Fixes

2001-10-25 Thread Paul

Hi,

I have been working with your driver along with Forte for Java and it's not
so Transparent Persistence.

In trying to use your driver along with PostgreSQl 7.1 I have found some
problems and fixed them in the DatabaseMetaData class.

I am not an expert on Postgres, JDBC drivers or open source but I have been
around the coding block a few times. Anyway Transparent Persistence now
works with your driver and these fixes. So if I can assume Sun has
implemented there end correctly my fixes should be correct.

Anyway if you are interested in this code I can send it.

Or you can explain how I can put it into your code base or send a link with
an explanation.

Thanks,
Paul Vickerman
Technical Architect
Higher Ground Software Inc.

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



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 Java and it's
not so Transparent Persistence.

In trying to use your driver along with PostgreSQl 7.1 I have found some
problems and fixed them in the DatabaseMetaData class.

I am not an expert on Postgres, JDBC drivers or open source but I have
been around the coding block a few times. Anyway Transparent Persistence
now works with your driver and these fixes. So if I can assume Sun has
implemented there end correctly my fixes should be correct.

Anyway if you are interested in this code I can send it.

Or you can explain how I can put it into your code base or send a link
with an explanation.

Thanks,
Paul Vickerman
Technical Architect
Higher Ground Software Inc.

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



[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 use something like log4j, but given the recent
distaste for adding binaries to the download I am reluctant to add a
library.

At this point I will probably add for my own purposes a simple logging
system that can be controlled by level.

A while ago someone posted a message which suggested that they had added
instrumentation to the driver. If this person is still on the list,
please contact me. 

Cheers,

Dave


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



Re: [JDBC] Logging in the driver

2001-10-25 Thread Gunnar Rønning

* Dave Cramer [EMAIL PROTECTED] wrote:
|
| This is ok, but it doesn't provide for various levels of debugging.
| 
| One possibility is to use something like log4j, but given the recent
| distaste for adding binaries to the download I am reluctant to add a
| library.

log4j support would have been cool, has we then would have much better 
mechanism for controlling logging.

Have you had a look at log4j micro edition ? The API is drop in replacement 
for the real thing and the jar file only 25,281 bytes. The size shouldn't 
scare anybody, but it would be a required runtime component and that warrants
some discussion...

Check :

http://qos.ch/


-- 
Gunnar Rønning - [EMAIL PROTECTED]
Senior Consultant, Polygnosis AS, http://www.polygnosis.com/

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org



[JDBC] j2ee compatiable jdbc driver on jdbc.postgresql.org?

2001-10-25 Thread Ned Wolpert

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Folks-

  I checked out the jdbc driver for 7.2b1 on the jdbc.postgresql.org website
(http://jdbc.postgresql.org/download/jdbc7.2b1-1.2.jar) and I was going to
submit it for testing with the castor project.  One problem... it's only the
default driver.  I think the website should have the default one, and the j2ee
(jdk1.2e+) one available.  Thoughts?


Virtually, 
Ned Wolpert [EMAIL PROTECTED]

D08C2F45:  28E7 56CB 58AC C622 5A51  3C42 8B2B 2739 D08C 2F45 
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE72J4xiysnOdCML0URAvl6AJ90aNX33co+5BH23/kgeK2YX/OlvwCdHbMV
voujwk16eZ04pJvH5iTCJTQ=
=36ME
-END PGP SIGNATURE-

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])



Re: [JDBC] j2ee compatiable jdbc driver on jdbc.postgresql.org?

2001-10-25 Thread Barry Lind

Ned,

There really isn't a j2ee driver for postgres.  If you build the j2ee 
driver it is essentially the same as the j2se driver.  So I don't see 
any reason to confuse people by letting them think there really is a 
difference by having two different java2 drivers to choose from on the 
web site.

The only difference is some code that I consider questionable, and I 
don't think even works.

thanks,
--Barry



Ned Wolpert wrote:

 -BEGIN PGP SIGNED MESSAGE-
 Hash: SHA1
 
 Folks-
 
   I checked out the jdbc driver for 7.2b1 on the jdbc.postgresql.org website
 (http://jdbc.postgresql.org/download/jdbc7.2b1-1.2.jar) and I was going to
 submit it for testing with the castor project.  One problem... it's only the
 default driver.  I think the website should have the default one, and the j2ee
 (jdk1.2e+) one available.  Thoughts?
 
 
 Virtually, 
 Ned Wolpert [EMAIL PROTECTED]
 
 D08C2F45:  28E7 56CB 58AC C622 5A51  3C42 8B2B 2739 D08C 2F45 
 -BEGIN PGP SIGNATURE-
 Version: GnuPG v1.0.6 (GNU/Linux)
 Comment: For info see http://www.gnupg.org
 
 iD8DBQE72J4xiysnOdCML0URAvl6AJ90aNX33co+5BH23/kgeK2YX/OlvwCdHbMV
 voujwk16eZ04pJvH5iTCJTQ=
 =36ME
 -END PGP SIGNATURE-
 
 ---(end of broadcast)---
 TIP 2: you can get off all lists at once with the unregister command
 (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
 
 



---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org



[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.ambysoft.com/persistenceLayer.html

If anyone has any objections, or comments please let them be known

Dave 


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])