NOVELL FORUMS

preycor · #1 03-Nov-2009, 07:50 AM

Has anyone worked with a firebird database with IDM's JDBC connector - or perhaps someone who's worked with the more obscure databases can help?

I am able to connect to the database, get the schema, etc. I'm also able to start the connector successfully.

However, when I do an add event from the IDV, when it hits the matching rule it tries to query the database, resulting in the following exception:

Code:

[11/03/09 13:26:08.287]:IT Access Control System ST:        Submitting document to subscriber shim:
[11/03/09 13:26:08.287]:IT Access Control System ST:
<nds dtdversion="3.5" ndsversion="8.x">
  <source>
    <product version="3.6.10.4747">DirXML</product>
    <contact>Novell, Inc.</contact>
  </source>
  <input>
    <query class-name="MASTER" event-id="0" scope="subtree">
      <search-class class-name="MASTER"/>
      <search-attr attr-name="MST_LAST_NAME">
        <value timestamp="1255528129#12" type="string">Consultant</value>
      </search-attr>
      <search-attr attr-name="MST_FIRST_NAME">
        <value timestamp="1255528129#5" type="string">Test</value>
      </search-attr>
      <read-attr/>
    </query>
  </input>
</nds>
[11/03/09 13:26:08.290]:IT Access Control System ST:        SELECT MST_SQ FROM MASTER WHERE MST_LAST_NAME = ? AND MST_FIRST_NAME = ? ORDER BY MST_SQ
[11/03/09 13:26:08.341]:IT Access Control System ST:        ROLLBACK
[11/03/09 13:26:08.342]:IT Access Control System ST:        SubscriptionShim.execute() returned:
[11/03/09 13:26:08.342]:IT Access Control System ST:
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
  <source>
    <product build="20090520_1228" instance="IT Access Control System" version="3.5.4">DirXML Driver for JDBC</product>
    <contact>Novell, Inc.</contact>
  </source>
  <output>
    <status event-id="0" level="retry" type="app-connection">
      <description>Unable to process query.  Unable to select row(s) from table/view 'MASTER'.  There is a connectivity-related problem.</description>
      <jdbc:exception jdbc:class="org.firebirdsql.jdbc.FBSQLException" jdbc:error-code="335544726" jdbc:sql-state="HY000">
        <jdbc:message>GDS Exception. 335544726. Error reading data from the connection.
null
Reason: Error reading data from the connection.
null</jdbc:message>
      </jdbc:exception>
    </status>
  </output>
</nds>

Does anyone have the slightest clue regarding how I can get this working?