Oracle ROWID in SAPDB
David Billard <[email protected]> Thu, 04 Sep 2003 11:57:03 +0200
| Newsgroups | gmane.comp.db.sapdb.general |
|---|---|
| Message-ID | <[email protected]> |
Dear all,
I'm trying to use Jdeveloper for developing and SAPDB as the dbms. When I
create a "Business Component Entity Object" from a SAPDB table in
Jdeveloper, I got the following error message:
----
oracle.jbo.dt.objects.JboException: Entity creation failed for the following
Database Object. No primary key attributes and does not support ROWID. Use
the Entity Wizard to create the Entity Object.
----
I created the table with SQL Studio, in Oracle mode, using:
CREATE TABLE "BILLARD"."DECISION"
(
"ID" Integer NOT NULL,
"NOM" Varchar (255) UNICODE NOT NULL,
"FK_STATJURI_ID" Char (1) UNICODE NOT NULL,
PRIMARY KEY ("ID"),
CONSTRAINT "FK_STATJURI_ID" FOREIGN KEY ("FK_STATJURI_ID") REFERENCES
"BILLARD"."STATJURI" ("ID")
) ROWID
I use the following software:
Operating system:
- Windows XP SP1
Development tools:
- Jdeveloper 9.0.3.1 (build 1107)
- Java 1.3.1 02
- Oracle JVM 9.0.3.744 o
I'm using the last SAPDB and JDBC driver.
It seems to me that the jdbc driver does not deliver a correct information
to Jdeveloper.
If someone can help, I will be very happy :-)
David.
--
Responsable des développements informatiques | [email protected]
Division Informatique, Université de Genève | Tel : (+41 22) 705 7977
24, Rue du Général Dufour, CH-1211 Genève 4 | Fax : (+41 22) 705 7986