semicolon (";") problem of sapdb

[Paul Verreth <Pa...@sos.be>]

Hello hello.


sapdb doesn't use a semicolon (";" ) to terminate an sql-statement.

And for using an sql-script one has to seperate the statements like this:
    select * from ...
    //
    insert into ...
    //
    create table ...

I saw remarks of someone succesfully using sapdb, but I wonder how this 
is done using torque and peer?
Because the velocity templates are designed without ";" problems in mind 
I guess.

One can probably create the tables, etc manually with the sapdb tools 
(dbmcli) but what about the peer classes? How sure can you be about these?

Can someone clear this out?

Thank you.

-- 
Paul Verreth
mailto:Paul.Verreth@sos.be

Het verschil tussen theorie en praktijk is in theorie niet
zo groot, maar in praktijk daarentegen ... 



--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

Re: semicolon (";") problem of sapdb

[David Polito <da...@polito.com>]

Set the database url to;

jdbc:sapdb://$DB_HOST$/$DB_SID$?sqlmode=oracle

The sapdb support was "copied" from oracle, because sapdb has Oracle syntax
support.


David Polito

----- Original Message -----
From: "Paul Verreth" <Pa...@sos.be>
To: <tu...@jakarta.apache.org>
Sent: Thursday, January 24, 2002 5:54 PM
Subject: semicolon (";") problem of sapdb


> Hello hello.
>
>
> sapdb doesn't use a semicolon (";" ) to terminate an sql-statement.
>
> And for using an sql-script one has to seperate the statements like this:
>     select * from ...
>     //
>     insert into ...
>     //
>     create table ...
>
> I saw remarks of someone succesfully using sapdb, but I wonder how this
> is done using torque and peer?
> Because the velocity templates are designed without ";" problems in mind
> I guess.
>
> One can probably create the tables, etc manually with the sapdb tools
> (dbmcli) but what about the peer classes? How sure can you be about these?
>
> Can someone clear this out?
>
> Thank you.
>
> --
> Paul Verreth
> mailto:Paul.Verreth@sos.be
>
> Het verschil tussen theorie en praktijk is in theorie niet
> zo groot, maar in praktijk daarentegen ...
>
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
>



--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>