After doing some more tests I have discovered that the problem is most
likely being caused by the context (environment) of the application I am
calling. I have managed to access the problematic table from a bare Java
application. I will try to find out why I can't access it from a
JSP/servlet.
Thanks.
> -----Original Message-----
> From: Dave Cramer [SMTP:Dave@micro-automation.net]
> Sent: 11 March 2003 12:14
> To: J M Okomba
> Cc: 'pgsql-jdbc'
> Subject: Re: [JDBC] Problem with driver
>
> Can you send us a test case so we can replicate the problem here
>
> Dave
> On Tue, 2003-03-11 at 01:40, J M Okomba wrote:
> > I keep getting this error:
> >
> > Database error in EmbeddedData.fetchData Invalid character data was
> found.
> > This is most likely caused by stored data containing characters that are
> > invalid for the character set the database was created in. The most
> common
> > example of this is storing 8bit data in a SQL_ASCII database
> >
> > with current postgres drivers downloaded from
> > http://jdbc.postgresql.org/download/ (like pg73jdbc3.jar and others).
> The
> > error is only thrown when I try to access one table (other tables in the
> > database work fine).
> >
> > However I don't get this error with pgjdbc2.jar, which I downloaded
> about 8
> > months ago.
> >
> > I will appreciate any help to resolve the problem. I really need to use
> new
> > features in the updated drivers.
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo@postgresql.org so that your
> > message can get through to the mailing list cleanly
> --
> Dave Cramer <Dave@micro-automation.net>