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