NEOHAPSIS - Peace of Mind Through Integrity and Insight

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com

Neohapsis > Archives > SAP DB/MAXDB Discussion> 2003-q3

Re: Oracle ROWID in SAPDB

From: David Billard (David.Billardadm.unige.ch)
Date: Thu Sep 04 2003 - 07:09:25 CDT

Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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:David.Billardadm.unige.ch]
>>Sent: Thursday, September 04, 2003 11:57 AM
>>To: sapdb.generallistserv.sap.com
>>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 |
>>David.Billardadm.unige.ch
>>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
>>sapdb.generallistserv.sap.com
>>http://listserv.sap.com/mailman/listinfo/sapdb.general
>
>

--
Responsable des développements informatiques | David.Billardadm.unige.ch
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 com.sap.dbtech.rte.comm.SocketComm1d93 on Socket[addr=localhost/127.0.0.1,port=7210,localport=3621]
=> com.sap.dbtech.jdbc.ConnectionSapDB1d94
com.sap.dbtech.jdbc.ConnectionSapDB1d94.getMetaData ()
=> com.sap.dbtech.jdbc.DatabaseMetaDataSapDB1d95
com.sap.dbtech.jdbc.DatabaseMetaDataSapDB1d95.getDatabaseProductName ()
=> SAP DB
com.sap.dbtech.jdbc.ConnectionSapDB1d94.getCatalog ()
=> null
com.sap.dbtech.jdbc.ConnectionSapDB1d94.getMetaData ()
=> com.sap.dbtech.jdbc.DatabaseMetaDataSapDB1d95
com.sap.dbtech.jdbc.DatabaseMetaDataSapDB1d95.getSchemas ()
=> com.sap.dbtech.jdbc.ResultSetSapDB1d96
com.sap.dbtech.jdbc.ResultSetSapDB1d96.next ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB1d96.getString (1)
=> BILLARD
com.sap.dbtech.jdbc.ResultSetSapDB1d96.next ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB1d96.getString (1)
=> DBA
com.sap.dbtech.jdbc.ResultSetSapDB1d96.next ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB1d96.getString (1)
=> DBM
com.sap.dbtech.jdbc.ResultSetSapDB1d96.next ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB1d96.getString (1)
=> DOMAIN
com.sap.dbtech.jdbc.ResultSetSapDB1d96.next ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB1d96.getString (1)
=> SYS
com.sap.dbtech.jdbc.ResultSetSapDB1d96.next ()
=> false
com.sap.dbtech.jdbc.ResultSetSapDB1d96.close ()
com.sap.dbtech.jdbc.ConnectionSapDB1d94.getMetaData ()
=> com.sap.dbtech.jdbc.DatabaseMetaDataSapDB1d95
com.sap.dbtech.jdbc.DatabaseMetaDataSapDB1d95.getSchemas ()
=> com.sap.dbtech.jdbc.ResultSetSapDB1d97
com.sap.dbtech.jdbc.ResultSetSapDB1d97.next ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB1d97.getString (1)
=> BILLARD
com.sap.dbtech.jdbc.ResultSetSapDB1d97.next ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB1d97.getString (1)
=> DBA
com.sap.dbtech.jdbc.ResultSetSapDB1d97.next ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB1d97.getString (1)
=> DBM
com.sap.dbtech.jdbc.ResultSetSapDB1d97.next ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB1d97.getString (1)
=> DOMAIN
com.sap.dbtech.jdbc.ResultSetSapDB1d97.next ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB1d97.getString (1)
=> SYS
com.sap.dbtech.jdbc.ResultSetSapDB1d97.next ()
=> false
com.sap.dbtech.jdbc.ConnectionSapDB1d94.getMetaData ()
=> com.sap.dbtech.jdbc.DatabaseMetaDataSapDB1d95
com.sap.dbtech.jdbc.DatabaseMetaDataSapDB1d95.getTables (null, , %, null)
=> com.sap.dbtech.jdbc.ResultSetSapDB1d98
com.sap.dbtech.jdbc.ResultSetSapDB1d98.next ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB1d98.close ()
com.sap.dbtech.jdbc.ResultSetSapDB1d97.close ()

---- Thread 15b6 AWT-EventQueue-0 Timestamp: 2003-09-04 13:58:44.83
com.sap.dbtech.jdbc.ConnectionSapDB1d94.getMetaData ()
=> com.sap.dbtech.jdbc.DatabaseMetaDataSapDB1d95
com.sap.dbtech.jdbc.DatabaseMetaDataSapDB1d95.getTables (null, BILLARD, %, [Ljava.lang.String;1dae)
=> com.sap.dbtech.jdbc.ResultSetSapDB1daf
com.sap.dbtech.jdbc.ResultSetSapDB1daf.next ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB1daf.getString (3)
=> AFFAIRE
com.sap.dbtech.jdbc.ResultSetSapDB1daf.next ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB1daf.getString (3)
=> DECISION
com.sap.dbtech.jdbc.ResultSetSapDB1daf.next ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB1daf.getString (3)
=> INDIVIDU
com.sap.dbtech.jdbc.ResultSetSapDB1daf.next ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB1daf.getString (3)
=> JURIDICTION
com.sap.dbtech.jdbc.ResultSetSapDB1daf.next ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB1daf.getString (3)
=> QUALITE
com.sap.dbtech.jdbc.ResultSetSapDB1daf.next ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB1daf.getString (3)
=> STATJURI
com.sap.dbtech.jdbc.ResultSetSapDB1daf.next ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB1daf.getString (3)
=> TYPE
com.sap.dbtech.jdbc.ResultSetSapDB1daf.next ()
=> false
com.sap.dbtech.jdbc.ResultSetSapDB1daf.close ()
com.sap.dbtech.jdbc.ConnectionSapDB1d94.getMetaData ()
=> com.sap.dbtech.jdbc.DatabaseMetaDataSapDB1d95
com.sap.dbtech.jdbc.DatabaseMetaDataSapDB1d95.getColumns (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
com.sap.dbtech.jdbc.ConnectionSapDB1d94.getMetaData ()
=> com.sap.dbtech.jdbc.DatabaseMetaDataSapDB1d95
com.sap.dbtech.jdbc.DatabaseMetaDataSapDB1d95.getPrimaryKeys (null, BILLARD, DECISION)
=> com.sap.dbtech.jdbc.ResultSetSapDB1dbf
com.sap.dbtech.jdbc.ResultSetSapDB1dbf.next ()
=> false
com.sap.dbtech.jdbc.ResultSetSapDB1dbf.close ()
com.sap.dbtech.jdbc.DatabaseMetaDataSapDB1d95.getImportedKeys (null, BILLARD, DECISION)
=> com.sap.dbtech.jdbc.ResultSetSapDB1dc0
com.sap.dbtech.jdbc.ResultSetSapDB1dc0.next ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB1dc0.getString (1)
=> null
com.sap.dbtech.jdbc.ResultSetSapDB1dc0.getString (2)
=> BILLARD
com.sap.dbtech.jdbc.ResultSetSapDB1dc0.getString (3)
=> STATJURI
com.sap.dbtech.jdbc.ResultSetSapDB1dc0.getString (13)
=> null
com.sap.dbtech.jdbc.ResultSetSapDB1dc0.getString (12)
=> FK_STATJURI_ID
com.sap.dbtech.jdbc.ResultSetSapDB1dc0.getString (8)
=> FK_STATJURI_ID
com.sap.dbtech.jdbc.ResultSetSapDB1dc0.getString (4)
=> ID
com.sap.dbtech.jdbc.ResultSetSapDB1dc0.getShort (11)
=> 1
com.sap.dbtech.jdbc.ResultSetSapDB1dc0.next ()
=> false
com.sap.dbtech.jdbc.ResultSetSapDB1dc0.close ()
com.sap.dbtech.jdbc.ConnectionSapDB1d94.getMetaData ()
=> com.sap.dbtech.jdbc.DatabaseMetaDataSapDB1d95
com.sap.dbtech.jdbc.DatabaseMetaDataSapDB1d95.getIndexInfo (null, BILLARD, DECISION, false, false)
=> com.sap.dbtech.jdbc.ResultSetSapDB1dc1
com.sap.dbtech.jdbc.ResultSetSapDB1dc1.next ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB1dc1.getInt (7)
=> 3
com.sap.dbtech.jdbc.ResultSetSapDB1dc1.getString (1)
=> null
com.sap.dbtech.jdbc.ResultSetSapDB1dc1.getString (2)
=> BILLARD
com.sap.dbtech.jdbc.ResultSetSapDB1dc1.getString (3)
=> DECISION
com.sap.dbtech.jdbc.ResultSetSapDB1dc1.getBoolean (4)
=> false
com.sap.dbtech.jdbc.ResultSetSapDB1dc1.getString (6)
=> ??????††††††††††††††††††††††††††
com.sap.dbtech.jdbc.ResultSetSapDB1dc1.getString (9)
=> ID
com.sap.dbtech.jdbc.ResultSetSapDB1dc1.next ()
=> false
com.sap.dbtech.jdbc.ResultSetSapDB1dc1.close ()
com.sap.dbtech.jdbc.ConnectionSapDB1d94.close ()

_______________________________________________
sapdb.general mailing list
sapdb.generallistserv.sap.com
http://listserv.sap.com/mailman/listinfo/sapdb.general

Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]