Re: Oracle ROWID in SAPDB

David Billard <[email protected]> Thu, 04 Sep 2003 14:09:25 +0200
Newsgroups gmane.comp.db.sapdb.general
Message-ID <[email protected]> 
Dear Alexander,

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
jdbc_trace.log (text/plain, 9.2 KB) 
---- 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 com.sap.dbtech.rte.comm.SocketComm@1d93 on Socket[addr=localhost/127.0.0.1,port=7210,localport=3621]
=> com.sap.dbtech.jdbc.ConnectionSapDB@1d94
[email protected] ()
=> com.sap.dbtech.jdbc.DatabaseMetaDataSapDB@1d95
com.sap.dbtech.jdbc.DatabaseMetaDataSapDB@1d95.getDatabaseProductName ()
=> SAP DB
[email protected] ()
=> null
[email protected] ()
=> com.sap.dbtech.jdbc.DatabaseMetaDataSapDB@1d95
[email protected] ()
=> com.sap.dbtech.jdbc.ResultSetSapDB@1d96
[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] ()
=> com.sap.dbtech.jdbc.DatabaseMetaDataSapDB@1d95
[email protected] ()
=> com.sap.dbtech.jdbc.ResultSetSapDB@1d97
[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] ()
=> com.sap.dbtech.jdbc.DatabaseMetaDataSapDB@1d95
[email protected] (null, , %, null)
=> com.sap.dbtech.jdbc.ResultSetSapDB@1d98
[email protected] ()
=> true
[email protected] ()
[email protected] ()

---- Thread 15b6 AWT-EventQueue-0 Timestamp: 2003-09-04 13:58:44.83
[email protected] ()
=> com.sap.dbtech.jdbc.DatabaseMetaDataSapDB@1d95
[email protected] (null, BILLARD, %, [Ljava.lang.String;@1dae)
=> com.sap.dbtech.jdbc.ResultSetSapDB@1daf
[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] ()
=> com.sap.dbtech.jdbc.DatabaseMetaDataSapDB@1d95
[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] ()
=> com.sap.dbtech.jdbc.DatabaseMetaDataSapDB@1d95
[email protected] (null, BILLARD, DECISION)
=> com.sap.dbtech.jdbc.ResultSetSapDB@1dbf
[email protected] ()
=> false
[email protected] ()
[email protected] (null, BILLARD, DECISION)
=> com.sap.dbtech.jdbc.ResultSetSapDB@1dc0
[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] ()
=> com.sap.dbtech.jdbc.DatabaseMetaDataSapDB@1d95
[email protected] (null, BILLARD, DECISION, false, false)
=> com.sap.dbtech.jdbc.ResultSetSapDB@1dc1
[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] ()