Novell Identity Manager 3.6
Novell eDirectory 8.8 SP3
_NOVELL_JDBC_DRIVER_(_TRIGGERLESS_PUBLISHING).._PU BLISHER_ONLY._
*4D Database v11*


Im trying to sync a table from the 4D database to IdM (Publisher only)
using available JDBC drivers from 4D. But they dont work with the new
version of Database server v11 (they didn't work for me for older
version of 4D Db either, since they do not Implement many of the JDBC
API that Novell IDM driver requires)

I then tried SUNs JDBC-ODBC bridge from SUN to sync the a table from
the 4D Database. This was little luck, but the Novell IDM jdbc driver
crashes when it Query for the PrimayKey.

The 4D Database has a way to define Primary Key in the table (Unique
Vaue, Not Null). but It seem like that the method
*-DatabaseMetaData.getPrimaryKeys(String catalog, String schema, String
table)-* does not understand this kind of Primary Keys in the table.

_THE_4D_DATABASE_DOES_NOT_SUPPORT_VIEWS!!!!._


Trace 3 Log :


DirXML: [06/02/09 23:41:58.05]: TRACE: CALLING
DatabaseMetaData.getPrimaryKeys(String catalog, String schema, String
table)
DirXML: [06/02/09 23:41:58.05]: TRACE: WITH PARAM 1: null
DirXML: [06/02/09 23:41:58.05]: TRACE: WITH PARAM 2: null
DirXML: [06/02/09 23:41:58.05]: TRACE: WITH PARAM 3: Customer
DirXML: [06/02/09 23:41:58.07]: TRACE: CALLED
DirXML: [06/02/09 23:41:58.07]: TRACE: RETURNED VALUE:
sun.jdbc.odbc.JdbcOdbcResultSet@1de9ac4
DirXML: [06/02/09 23:41:58.07]: TRACE: Allocated result set
1de9ac4.
DirXML: [06/02/09 23:41:58.07]: TRACE: CALLING boolean
ResultSet.next()
DirXML: [06/02/09 23:41:58.07]: TRACE: CALLED boolean
ResultSet.next()
DirXML: [06/02/09 23:41:58.07]: TRACE: RETURNED VALUE: false
DirXML: [06/02/09 23:41:58.07]: TRACE: CALLING ResultSet.close()
DirXML: [06/02/09 23:41:58.07]: TRACE: CALLED
DirXML: [06/02/09 23:41:58.07]: TRACE: Closed result set
1de9ac4.
DirXML: [06/02/09 23:41:58.07]: TRACE: END Get primary key
metadata for table 'Customer'.
DirXML: [06/02/09 23:41:58.07]: TRACE: BEGIN Close connection
'dedicated0'.
DirXML: [06/02/09 23:41:58.07]: TRACE: Connection implementation
and/or child statements need to be closed.
DirXML: [06/02/09 23:41:58.07]: TRACE: CALLING Connection.close()
DirXML: [06/02/09 23:41:58.10]: TRACE: CALLED
DirXML: [06/02/09 23:41:58.10]: TRACE: Closed connection
feb48.
DirXML: [06/02/09 23:41:58.10]: TRACE: END Close connection.
DirXML: [06/02/09 23:41:58.11]: TRACE: Remote Loader:
DriverShim.getSchema() returned:
DirXML: [06/02/09 23:41:58.11]: TRACE: <nds dtdversion="2.0"
ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">


and then finally happy ending:


<DESCRIPTION>TABLE 'CUSTOMER' IS NOT SYNCABLE. IT MUST
HAVE A PRIMARY KEY CONSTRAINT.</DESCRIPTION>





So I was wondering, is there any work around available from Novell JDBC
IdM driver in order to make it work ???... 4D database seem not a SQL
database.


_*I_do_not__have_option_to_to_switch_over_CSV_driv er.!!*_

Any help regards this, would be best!

Regards,

Maqsood.


--
love anything that talks binary!
------------------------------------------------------------------------
belaie's Profile: http://forums.novell.com/member.php?userid=4368
View this thread: http://forums.novell.com/showthread.php?t=374823