JDBC Triggerless State files directory not working
Pervasive Database 9.x / Windows Server 2003
Novell Identity Manager 3.5.1 (Identity Manager 3.5.12.17187) Engine
Patch3
JDBC driver configuration version : Driver version: 3.5.2
Driver is setup as Remote Loader on the Database server.



SORRY GUYS I'M CREATING THIS POST ONCE AGIAN..

Hi

We are using JDBC IDM driver with Pervassive Database using thirdy
party JDBCD drivers in Triggerless mode. we have created own database
descriptor files. The driver is setup using Remote Loader : This is
working good..

One thing is not working that is State Directory Path on the IDM
driver. We have defined path "C:\Novell\RemoteLoader", but the driver
does not create .db and .log files there, but creating these files on
the database server under C:\Windows\System32 folder.. Which is actually
bugging the Database administrator.


HAVE TRIED DEFINING PATH NOVELL\REMOTELOADER BUT THAT DOES NOT WORK
EITHER

My remote loader trace 3 log:






<driver-options>
<pub-state-dir display-name="State
directory:">C:\Novell\RemoteLoader</pub-state-dir>
<minimal-metadata display-name="Retrieve minimal
metadata?">1</minimal-metadata>

</driver-options>




DirXML: [04/21/09 13:44:49.43]: TRACE: Loading descriptors.
DirXML: [04/21/09 13:44:49.57]: TRACE: Loaded.
DirXML: [04/21/09 13:44:49.59]: TRACE: Parameter: 'jdbc-class' Value:
'com.pervasive.jdbc.v2.Driver'
DirXML: [04/21/09 13:44:49.59]: TRACE: Parameter:
'jdbc-driver-descriptor' Value: 'custom_jdbc_ddisc.xml'
DirXML: [04/21/09 13:44:49.59]: TRACE: Parameter: 'database-descriptor'
Value: 'custom_jdbc_disc.xml'
DirXML: [04/21/09 13:44:49.59]: TRACE: Loading driver descriptor file
'custom_jdbc_ddisc.xml'.
DirXML: [04/21/09 13:44:49.61]: TRACE: Descriptor file
'custom_jdbc_ddisc.xml' successfully loaded.
DirXML: [04/21/09 13:44:49.61]: TRACE: Third-Party JDBC Driver is
"Pervasive.SQL"
DirXML: [04/21/09 13:44:49.62]: TRACE: Applying declared imports to
driver descriptor 'custom_jdbc_ddisc.xml'.
DirXML: [04/21/09 13:44:49.62]: TRACE: Applying import
'custom_codes.xml'.
DirXML: [04/21/09 13:44:49.62]: TRACE: Parameter: 'sync-filter' Value:
null
DirXML: [04/21/09 13:44:49.62]: TRACE: Parameter: 'sync-schema' Value:
null
DirXML: [04/21/09 13:44:49.62]: TRACE: Parameter: 'sync-tables' Value:
[MYTABLE]
DirXML: [04/21/09 13:44:49.64]: TRACE: Driver is schema-aware.
DirXML: [04/21/09 13:44:49.64]: TRACE: Parameter: 'force-username-case'
Value: null
DirXML: [04/21/09 13:44:49.64]: TRACE: Parameter: 'server' Value:
'jdbcervasive://IPort/DB;encoding=cp850'
DirXML: [04/21/09 13:44:49.64]: TRACE: Parameter: 'user' Value: 'USER'
DirXML: [04/21/09 13:44:49.64]: TRACE: Parameter:
'connection-properties' Value: ''
DirXML: [04/21/09 13:44:49.64]: TRACE: Parameter: 'reuse-statements'
Value: [descriptor-dependent]
DirXML: [04/21/09 13:44:49.64]: TRACE: Parameter:
'use-manual-transactions' Value: [descriptor or metadata-dependent]
DirXML: [04/21/09 13:44:49.64]: TRACE: Parameter:
'transaction-isolation-level' Value: [descriptor-dependent]
DirXML: [04/21/09 13:44:49.64]: TRACE: Parameter:
'use-single-connection' Value: [descriptor-dependent]
DirXML: [04/21/09 13:44:49.64]: TRACE: Parameter: 'minimal-metadata'
Value: [descriptor-dependent]
DirXML: [04/21/09 13:44:49.65]: TRACE: Parameter: 'handle-stmt-results'
Value: [descriptor-dependent]
DirXML: [04/21/09 13:44:49.65]: TRACE: Parameter:
'connection-tester-class' Value:
'com.novell.nds.dirxml.driver.jdbc.util.connect.JD BCConnectionTester'
DirXML: [04/21/09 13:44:49.65]: TRACE: Parameter: 'enable-refs' Value:
true
DirXML: [04/21/09 13:44:49.65]: TRACE: Parameter:
'enable-meta-identifiers' Value: true
DirXML: [04/21/09 13:44:49.65]: TRACE: Parameter:
'left-outer-join-operator' Value: [descriptor-dependent]
DirXML: [04/21/09 13:44:49.65]: TRACE: Parameter:
'include-table-filter' Value: [descriptor-dependent]
DirXML: [04/21/09 13:44:49.65]: TRACE: Parameter:
'exclude-table-filter' Value: [descriptor-dependent]
DirXML: [04/21/09 13:44:49.65]: TRACE: Parameter:
'function-return-method' Value: [descriptor-dependent]
DirXML: [04/21/09 13:44:49.65]: TRACE: Parameter: 'state-dir' Value:
'.'
DirXML: [04/21/09 13:44:49.65]: TRACE: Parameter:
'supports-schemas-in-metadata-retrieval' Value: [descriptor-dependent]
DirXML: [04/21/09 13:44:49.65]: TRACE: Parameter:
'column-position-comparator' Value:
'com.novell.nds.dirxml.driver.jdbc.util.config.com
p.StringByteComparator'
DirXML: [04/21/09 13:44:49.67]: TRACE: Parameter: 'time-syntax' Value:
'2'
DirXML: [04/21/09 13:44:49.67]: TRACE: Parameter: 'enable-locking'
Value: false
DirXML: [04/21/09 13:44:49.75]: TRACE: Remote Loader: DriverShim.init()
returned:
DirXML: [04/21/09 13:44:49.76]: TRACE: <nds dtdversion="2.0"
ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>


--
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=370158