RE: Oracle ROWID in SAPDB

Hello David,

did you specify the sqlmode=oracle connect property in the JDBC URL?

Has the user that you use to access the database the RESOURCE or DBA rights
(necessary to see system table information ...)?

If yes, please run the application with the JDBC trace enabled, and send
a trace for further diagnosis of the problem 
(see http://sapdb.2scale.net/moin.cgi/JdbcTrace).

Anyway, the Oracle SQL mode of SAP DB pretends to be compatible with 
Oracle 7.x, so I fear that any tool designed to work with a more recent
version of Oracle (and using its features) may not work.

Regards

Alexander Schröder
SAP DB, SAP Labs Berlin 

> -----Original Message-----
> From: David Billard [mailto:[email protected]]
> Sent: Thursday, September 04, 2003 11:57 AM
> To: [email protected]
> Subject: Oracle ROWID in SAPDB
> 
> 
> 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
> 
> _______________________________________________
> sapdb.general mailing list
> [email protected]
> http://listserv.sap.com/mailman/listinfo/sapdb.general
>