From: Ken Kachnowich <khkachn@toad.net>
To: Postgres interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: Newlines in String inserts with JDBC
Date: Thu, 28 Sep 2000 18:07:52 -0400
Message-ID: <39D3C138.86C1FDDB@toad.net> (raw)
References: <39D28E41.B22FFB7C@toad.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: khkachn@toad.net
Subject: Re: Newlines in String inserts with JDBC
In-Reply-To: <39D3C138.86C1FDDB@toad.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox