Re: Help With the JDBC driver

Dan,

Are you running with the latest version of the drivers from the
jdbc.postgresql.org site?

On the surface this looks like a character encoding issue. What
charcter encoding is the database you are connecting to using? (use the
\l command in psql to see). Are you storing/trying to store data that
is incompatible with that character encoding? (for example is your
database SQL_ASCII, but you are trying to store LATIN1 characters?).

thanks,
--Barry

Marsh, Dan wrote:
> Hello I am on a SCO UNIXWARE 7.1.1 box using java version 1.1.7b with the
> jdk being 1.2. I am trying to connect to an Postgres database which is in
> my network. I am using the pg73jdbc1.jar and have also tried to use the
> pg73jdbc2.jar to connect. The following line of code works.
> <<...OLE_Obj...>> Then I try to run the next line and I get an error.
> <<...OLE_Obj...>>
> The error is as follows
> Something unusual has occured to cause the driver to fail. Please report
> this exception: Exception: java.lang.IllegalArgumentException:
> sun.io.CharToByteUTF-8
> Stack Trace:
>
> java.lang.IllegalArgumentException: sun.io.CharToByteUTF-8
> at sun.io.CharToByteConverter.getConverterClass(Compiled Code)
> at sun.io.CharToByteConverter.getConverter(Compiled Code)
> at java.lang.String.getBytes(Compiled Code)
> at org.postgresql.core.Encoding.isAvailable(Compiled Code)
> at org.postgresql.core.Encoding.encodingForDatabaseEncoding(Compiled
> Code)
> at org.postgresql.core.Encoding.getEncoding(Compiled Code)
> at
> org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(Compiled Code)
> at org.postgresql.Driver.connect(Compiled Code)
> at java.sql.DriverManager.getConnection(Compiled Code)
> at java.sql.DriverManager.getConnection(Compiled Code)
> at CfsOppFill.main(Compiled Code)
> End of Stack Trace
>
> at java.lang.Throwable.<init>(Compiled Code)
> at java.lang.Exception.<init>(Compiled Code)
> at java.sql.SQLException.<init>(Compiled Code)
> at org.postgresql.util.PSQLException.<init>(Compiled Code)
> at org.postgresql.Driver.connect(Compiled Code)
> at java.sql.DriverManager.getConnection(Compiled Code)
> at java.sql.DriverManager.getConnection(Compiled Code)
> at CfsOppFill.main(Compiled Code)
> Please help!
>
> Thank You,
> Dan P. Marsh
> Database Administrator OCIAP, OCDBA
> dmarsh(at)spiritcruises(dot)com
>
> If at first you don't succeed blame it on the computer!
>
>
>
>