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 > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
