Yes, I specified the URL this way:
jdbc:sapdb://localhost/basex?sqlmode=oracle&trace=jdbc_trace.log
The trace file is in attachment.
Thank you for your answer,
David.
Schroeder, Alexander wrote:
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
-- 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
---- Thread 1d92 Thread-62 Timestamp: 2003-09-04 13:58:38.821 ================================== 7.4.4 Build 000-000-000-000 on Java 1.3.1_02 new Connection 'jdbc:sapdb://localhost/basex' using [EMAIL PROTECTED] on Socket[addr=localhost/127.0.0.1,port=7210,localport=3621] => [EMAIL PROTECTED] [EMAIL PROTECTED] () => [EMAIL PROTECTED] [EMAIL PROTECTED] () => SAP DB [EMAIL PROTECTED] () => null [EMAIL PROTECTED] () => [EMAIL PROTECTED] [EMAIL PROTECTED] () => [EMAIL PROTECTED] [EMAIL PROTECTED] () => true [EMAIL PROTECTED] (1) => BILLARD [EMAIL PROTECTED] () => true [EMAIL PROTECTED] (1) => DBA [EMAIL PROTECTED] () => true [EMAIL PROTECTED] (1) => DBM [EMAIL PROTECTED] () => true [EMAIL PROTECTED] (1) => DOMAIN [EMAIL PROTECTED] () => true [EMAIL PROTECTED] (1) => SYS [EMAIL PROTECTED] () => false [EMAIL PROTECTED] () [EMAIL PROTECTED] () => [EMAIL PROTECTED] [EMAIL PROTECTED] () => [EMAIL PROTECTED] [EMAIL PROTECTED] () => true [EMAIL PROTECTED] (1) => BILLARD [EMAIL PROTECTED] () => true [EMAIL PROTECTED] (1) => DBA [EMAIL PROTECTED] () => true [EMAIL PROTECTED] (1) => DBM [EMAIL PROTECTED] () => true [EMAIL PROTECTED] (1) => DOMAIN [EMAIL PROTECTED] () => true [EMAIL PROTECTED] (1) => SYS [EMAIL PROTECTED] () => false [EMAIL PROTECTED] () => [EMAIL PROTECTED] [EMAIL PROTECTED] (null, , %, null) => [EMAIL PROTECTED] [EMAIL PROTECTED] () => true [EMAIL PROTECTED] () [EMAIL PROTECTED] ()
---- Thread 15b6 AWT-EventQueue-0 Timestamp: 2003-09-04 13:58:44.83
[EMAIL PROTECTED] ()
=> [EMAIL PROTECTED]
[EMAIL PROTECTED] (null, BILLARD, %, [Ljava.lang.String;@1dae)
=> [EMAIL PROTECTED]
[EMAIL PROTECTED] ()
=> true
[EMAIL PROTECTED] (3)
=> AFFAIRE
[EMAIL PROTECTED] ()
=> true
[EMAIL PROTECTED] (3)
=> DECISION
[EMAIL PROTECTED] ()
=> true
[EMAIL PROTECTED] (3)
=> INDIVIDU
[EMAIL PROTECTED] ()
=> true
[EMAIL PROTECTED] (3)
=> JURIDICTION
[EMAIL PROTECTED] ()
=> true
[EMAIL PROTECTED] (3)
=> QUALITE
[EMAIL PROTECTED] ()
=> true
[EMAIL PROTECTED] (3)
=> STATJURI
[EMAIL PROTECTED] ()
=> true
[EMAIL PROTECTED] (3)
=> TYPE
[EMAIL PROTECTED] ()
=> false
[EMAIL PROTECTED] ()
[EMAIL PROTECTED] ()
=> [EMAIL PROTECTED]
[EMAIL PROTECTED] (null, BILLARD, DECISION, %)
<-!
Timestamp: 2003-09-04 13:58:48.015
com.sap.dbtech.jdbc.exceptions.InternalJDBCError: [getColumns][-8006] (at 204): Data
types must be compatible
java.sql.ResultSet
com.sap.dbtech.jdbc.DatabaseMetaDataSapDB.internalQuery(java.lang.String,
java.lang.String)
DatabaseMetaDataSapDB.java:1027
java.sql.ResultSet
com.sap.dbtech.jdbc.DatabaseMetaDataSapDB.getColumns(java.lang.String,
java.lang.String, java.lang.String, java.lang.String)
DatabaseMetaDataSapDB.java:299
java.sql.ResultSet
com.sap.dbtech.jdbc.trace.DatabaseMetaData.getColumns(java.lang.String,
java.lang.String, java.lang.String, java.lang.String)
DatabaseMetaData.java:2863
java.util.List
oracle.jdeveloper.cm.ds.db.JdbcDatabase._getColumns(java.lang.String, java.lang.String)
JdbcDatabase.java:711
oracle.jdeveloper.cm.ds.db.Table
oracle.jdeveloper.cm.ds.db.JdbcDatabase.getTable(java.lang.String, java.lang.String)
JdbcDatabase.java:687
oracle.jdeveloper.cm.ds.db.Table
oracle.jdeveloper.cm.dt.browser.jdbc.TableNode.getTable()
TableNode.java:65
void oracle.jdevimpl.cm.dt.editor.table.TableExplorer._createTree()
TableExplorer.java:67
java.awt.Component oracle.jdevimpl.cm.dt.editor.table.TableExplorer.getGUI()
TableExplorer.java:49
void
oracle.ideimpl.explorer.ExplorerWindowImpl.setExplorer(oracle.ide.explorer.Explorer)
ExplorerWindowImpl.java:245
void
oracle.ideimpl.explorer.ExplorerWindowImpl.viewSelectionChanged(oracle.ide.addin.Context)
ExplorerWindowImpl.java:222
void
oracle.ide.addin.AbstractPinnable.viewSelectionChanged(oracle.ide.addin.ViewSelectionEvent)
AbstractPinnable.java:179
void
oracle.ideimpl.explorer.ExplorerWindowImpl.viewSelectionChanged(oracle.ide.addin.ViewSelectionEvent)
ExplorerWindowImpl.java:207
void
oracle.ide.addin.AbstractView.fireViewSelectionChanged(oracle.ide.addin.ViewSelectionEvent)
AbstractView.java:413
void
oracle.ideimpl.navigator.NavigatorWindowImpl.fireViewSelectionChanged(oracle.ide.addin.ViewSelectionEvent)
NavigatorWindowImpl.java:717
void
oracle.ideimpl.navigator.NavigatorWindowImpl$3.viewSelectionChanged(oracle.ide.addin.ViewSelectionEvent)
NavigatorWindowImpl.java:997
void
oracle.ide.addin.AbstractView.fireViewSelectionChanged(oracle.ide.addin.ViewSelectionEvent)
AbstractView.java:413
void
oracle.ideimpl.explorer.BaseTreeExplorer.actionPerformed(java.awt.event.ActionEvent)
BaseTreeExplorer.java:1677
void javax.swing.Timer.fireActionPerformed(java.awt.event.ActionEvent)
Timer.java:150
void javax.swing.Timer$DoPostEvent.run()
Timer.java:108
void java.awt.event.InvocationEvent.dispatch()
InvocationEvent.java:154
void java.awt.EventQueue.dispatchEvent(java.awt.AWTEvent)
EventQueue.java:337
boolean
java.awt.EventDispatchThread.pumpOneEventForHierarchy(java.awt.Component)
EventDispatchThread.java:131
void java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Conditional,
java.awt.Component)
EventDispatchThread.java:98
void java.awt.EventDispatchThread.pumpEvents(java.awt.Conditional)
EventDispatchThread.java:93
void java.awt.EventDispatchThread.run()
EventDispatchThread.java:85
[EMAIL PROTECTED] ()
=> [EMAIL PROTECTED]
[EMAIL PROTECTED] (null, BILLARD, DECISION)
=> [EMAIL PROTECTED]
[EMAIL PROTECTED] ()
=> false
[EMAIL PROTECTED] ()
[EMAIL PROTECTED] (null, BILLARD, DECISION)
=> [EMAIL PROTECTED]
[EMAIL PROTECTED] ()
=> true
[EMAIL PROTECTED] (1)
=> null
[EMAIL PROTECTED] (2)
=> BILLARD
[EMAIL PROTECTED] (3)
=> STATJURI
[EMAIL PROTECTED] (13)
=> null
[EMAIL PROTECTED] (12)
=> FK_STATJURI_ID
[EMAIL PROTECTED] (8)
=> FK_STATJURI_ID
[EMAIL PROTECTED] (4)
=> ID
[EMAIL PROTECTED] (11)
=> 1
[EMAIL PROTECTED] ()
=> false
[EMAIL PROTECTED] ()
[EMAIL PROTECTED] ()
=> [EMAIL PROTECTED]
[EMAIL PROTECTED] (null, BILLARD, DECISION, false, false)
=> [EMAIL PROTECTED]
[EMAIL PROTECTED] ()
=> true
[EMAIL PROTECTED] (7)
=> 3
[EMAIL PROTECTED] (1)
=> null
[EMAIL PROTECTED] (2)
=> BILLARD
[EMAIL PROTECTED] (3)
=> DECISION
[EMAIL PROTECTED] (4)
=> false
[EMAIL PROTECTED] (6)
=> ??????��������������������������
[EMAIL PROTECTED] (9)
=> ID
[EMAIL PROTECTED] ()
=> false
[EMAIL PROTECTED] ()
[EMAIL PROTECTED] ()
