Re: Newlines in String inserts with JDBC - Mailing list pgsql-interfaces

From Ken Kachnowich
Subject Re: Newlines in String inserts with JDBC
Date
Msg-id 39D3C138.86C1FDDB@toad.net
Whole thread Raw
In response to Newlines in String inserts with JDBC  (Ken Kachnowich <khkachn@toad.net>)
List 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


pgsql-interfaces by date:

Previous
From: "Daniel Gayo Avello"
Date:
Subject: RE: SQLException from Postgres JDBC
Next
From: Dnesbitt@encryptix.com
Date:
Subject: RE: JDBC and LO - invalid large object descriptor