How to INSERT a newline character?

#1 01-10-2006, 10:45 AM

Hi,

I want to insert a multiline character string. Is there a special
escape sequence for the newline charcters? (When I just stick in a new
line character, my jdbc driver barks at me.)

Many thanks in advance!

Aaron

#2 01-10-2006, 11:14 AM

aaronfude wrote:

> Hi,
>
> I want to insert a multiline character string. Is there a special
> escape sequence for the newline charcters? (When I just stick in a new
> line character, my jdbc driver barks at me.)
>
> Many thanks in advance!
>
> Aaron
>

String foo = "blah, blah\nnew line...\n nother wefwefwef";

p = c.prepareStatement("insert into mytable values(?)");
p.setString(1, foo);
p.executeUpdate();

#3 01-11-2006, 11:03 PM

Joe Weinstein wrote:
> aaronfude wrote:
>
> > Hi,
> >
> > I want to insert a multiline character string. Is there a special
> > escape sequence for the newline charcters? (When I just stick in a new
> > line character, my jdbc driver barks at me.)
> >
> > Many thanks in advance!
> >
> > Aaron
> >
>
> String foo = "blah, blah\nnew line...\n nother wefwefwef";
>
> p = c.prepareStatement("insert into mytable values(?)");
> p.setString(1, foo);
> p.executeUpdate();

Apparently my "driver does not support this functionality". Is there
anything else I can do?

Thanks!

#4 01-11-2006, 11:09 PM

aaronfude wrote:

> Joe Weinstein wrote:
>
>>aaronfude wrote:
>>
>>>Hi,
>>>
>>>I want to insert a multiline character string. Is there a special
>>>escape sequence for the newline charcters? (When I just stick in a new
>>>line character, my jdbc driver barks at me.)
>>>
>>>Many thanks in advance!
>>>Aaron
>>
>>String foo = "blah, blah\nnew line...\n nother wefwefwef";
>>
>>p = c.prepareStatement("insert into mytable values(?)");
>>p.setString(1, foo);
>>p.executeUpdate();
>
> Apparently my "driver does not support this functionality". Is there
> anything else I can do?
> Thanks!

Yow! What sort of failed-high-school-project of a JDBC driver
are you using? Sorry, I'm fresh out of ideas in that sort of
environment.
Joe Weinstein at BEA Systems

#5 01-12-2006, 09:40 AM

I'm using RmiJdbc.jar

I thought it was supposed to pretty good.

Can you recommend another for accessing and ODBC database (Access and
Excel).

Aaron

#6 01-12-2006, 11:55 AM

aaronfude wrote:
> I'm using RmiJdbc.jar
>
> I thought it was supposed to pretty good.

I have been doing professional JDBC driver
development and support since '96. I have never
seen a driver that had not implemented simple
JDBC 1.0 prepared statements.

> Can you recommend another for accessing and ODBC database (Access and
> Excel).
> Aaron

I wish I could, but I don't no of any high-quality JDBC-ODBC bridge.
Sun's also sucks, but nowhere near as bad as that one...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode