Re: Newlines in String inserts with JDBC

From: Ken Kachnowich <khkachn(at)toad(dot)net>
To: Postgres interfaces <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: Newlines in String inserts with JDBC
Date: 2000-09-28 22:07:52
Message-ID: 39D3C138.86C1FDDB@toad.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Sorry, I did not give enough information.
I am using the Serialize class. It builds an SQL insert statement in
a String and the back end seems to fail if there is a newline in
a text fields value.
If the PreparedStatement and setString work with newlines then I can
look into using that. I need to get a resultSet back, though, so I can
figure out what the record OID is of the record I just inserted.

Ken

Ken Kachnowich wrote:
>
> Is there a method that could be used to insert Strings containing
> newline charaters using the JDBC interface? I could replace them
> with some character before the insert but what would be a good
> character to use?
>
> Thanks,
>
> Ken

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Dnesbitt 2000-09-29 02:20:55 RE: JDBC and LO - invalid large object descriptor
Previous Message Peter Mount 2000-09-28 16:00:14 Re: SQLException from Postgres JDBC