This can be fixed with the attatched primarykey.vm, which goes
<torque-src>/templates/sql/base/sapdb/
I have been holding this change/fix untill I could run the tests, which
at this point will not run for me. However, this change, and one I made
similar to the previous post for the db.props file, are necessary to use
torque with sapdb.
also, I belive the following are more accurate for db.props
VARBINARY = LONG RAW
LONGVARBINARY = LONG RAW
DISTINCT = DISTINCT
The first two are from an email list message from one of the sapdb team
members.
Russell
On Sun, 2002-09-01 at 13:31, Thomas Mahler wrote:
> Hi,
>
> here is a Bug report from an OJB / SAPDB user.
>
> The schema.xml contains the following entry:
>
> <table name="PERSON_PROJECT">
> <column name="PERSON_ID"
> required="true" primaryKey="true" type="INTEGER"/>
> <column name="PROJECT_ID"
> required="true" primaryKey="true" type="INTEGER"/>
> <column name="ROLENAME" type="VARCHAR" size="20"/>
> </table>
>
> During excecution of the generated DDL the following error occurs:
> [torque-insert-sql] Failed to execute: ALTER TABLE PERSON_PROJECT ADD
> PRIMARY KEY ("PERSON_ID,PROJECT_ID")
> [torque-insert-sql] com.sap.dbtech.jdbc.exceptions.DatabaseException:
> SAP DBTech SQL: [-4005] (at 46) Unknown column name:PERSON_ID,PROJECT_ID
>
> The quotes around PERSON_ID,PROJECT_ID seem to be the troublemakers...
>
> Is this a known problem?
> Or must compund PKs be defined in a different way?
>
> cheers,
> Thomas
>
>
>
> -------- Original Message --------
> Subject: ALTER error
> Date: Sun, 1 Sep 2002 15:08:51 -0500
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
>
> Here's the problem I'm having with the SQL that Torque has generated. The
> quotes are causing Sapdb to not read the table name right. I've attached
> the output file. It's way down at the end of the file. If you look you will
> see all the errors to do with the ALTER statement.
>
> Example:
>
> [torque-insert-sql] Failed to execute: ALTER TABLE PERSON_PROJECT ADD
> PRIMARY KEY ("PERSON_ID,PROJECT_ID")
> [torque-insert-sql] com.sap.dbtech.jdbc.exceptions.DatabaseException:
> SAP DBTech SQL: [-4005] (at 46) Unknown column name:PERSON_ID,PROJECT_ID
>
> As you can see it doesn't under stand the column names. If you remove the
> quotes around the PERSON_ID and PROJECT_ID this statement will execute
> fine. Or you can put single quotes around each name and it will work. You
> will also see in the output there's errors about the drop table. That's all
> ok, because the tables weren't created yet. I think you already knew that
> though. So you can see it's not a big problem, but I'm not sure how easy it
> is to make Torques stop using quotes. On this example there's two
> parameters in the ALTER statement and both are within the same quotes. I
> would think that would be wrong for a lot of databases. So there's the
> problem. I've sent it to the developer list, but everyone was to busy to
> reply. I'm running OJB now in a project and everything works great. This
> just seems to apply to the generation of tables through Torque, but I'm
> sure this will cause a lot of confusion for people trying to setup OJB on
> Sapdb. Hope we can get this fixed. Let me know what else I can do to help
> solve this problem.
>
> (See attached file: ojb-sapdb-errors.txt)
>
>
> Thank You,
>
> Justin A. Stanczak
> Web Manager
> Shake Learning Resource Center
> Vincennes University
> (812)888-5813
>
> ----
>
> --
> 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]>
