Hello,
Yes, the errors are missing identifiers. I'm relying on the "create-db" target
to do this. There are some query that the turbine can't process to sapdb, these
queries are the ones that have a UNIQUE field on its schema. SAPDB seems that
doesn't work with UNIQUE fields, instence of this it must be used INDEX fields,
i think, but doing this there ara also queries that continue not working.
I'm only doing ant init on the example aplication of turbine (newapp). I think
that it's a bug of torque with SAPDB, it seems to to work fine.
A lot of thanks,
Marcial Atienzar
Missatge citat per: Rodney Schneider <[EMAIL PROTECTED]>:
> On Wed, 18 Dec 2002 05:54, you wrote:
> > Hello,
> >
> > I have this database settings:
> >
> > database.name = inmo
> > database = sapdb
> > createDatabaseUrl = jdbc:sapdb://localhost/inmo
> > buildDatabaseUrl = jdbc:sapdb://localhost/inmo
> > databaseUrl = jdbc:sapdb://localhost/inmo
> > databaseDriver = com.sap.dbtech.jdbc.DriverSapDB
> > databaseUser = xxx
> > databasePassword = xxx
> > databaseHost = localhost
> >
> > When I do ant init I have this errors. To solve some of them I have
> > to edit the .schema to change the unique identifier by index
> > identifier. Have I doind something wrong? or is it a bug?
>
> I don't know anything about SapDB, but if you look at you errors they
> are either "Missing identifier" which probably means that the SQL being
>
> executed is invalid or "Unknown table name" which probably means that
> the tables have not been created. Did you manually create the tables
> in your database or are you relying on the "create-db" target to do
> this for you?
>
> -- Rodney
>
>
> > A lot of thanks,
> >
> > Marcial Atienzar
> >
> > Error:
> >
> > [torque-sql-exec] Executing file:
> > C:\tdk\webapps\inmo\WEB-INF\src\sql\id-table-s chema.sql
> > [torque-sql-exec] Failed to execute: CREATE TABLE ID_TABLE (
> > ID_TABLE_ID INTEGER NOT NULL, TABLE_NAME VARCHAR (255) NOT NULL,
> > NEXT_ID INTEGER, QUANTITY INTEGER, UNIQUE (TABLE_NAME) )
> > [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException:
> > [-5006] (at 132): Missing identifier
> > [torque-sql-exec] Failed to execute: ALTER TABLE ID_TABLE ADD
> PRIMARY
> > KEY (ID_TA BLE_ID)
> > [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException:
> > [-4004] (at 13): Unknown table name:ID_TABLE
>
> --
> To unsubscribe, e-mail:
> <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
> <mailto:[EMAIL PROTECTED]>
>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
