Hi,
I'm now configuring a third-party JDBC driver to connect e.d with
oracle.
But there always exists some problems with the driver. I am sure all
parameters which I give to the driver's configuation are right.

I use java program to test the ojdbc14.jar from the server with
e.d to the server with oracle and its connection is all right.

But while I am using IDM to set connection, it seems that it
doesn't communicate with the server with oracle.

Our enviroument is :

Suse10 with e.d8.8
IDM 3.5

And ideas? . Thanks in advance!



Here's a piece of the driver's log.
------------------------------------------------------------------------
[08/08/08 16:40:56.046]:SESDriver ST:Loading descriptors.
[08/08/08 16:40:56.060]:SESDriver ST:Loaded.
[08/08/08 16:40:56.061]:SESDriver ST:Parameter: 'jdbc-class'
Value: 'oracle.jdbc.driver.OracleDriver'
[08/08/08 16:40:56.061]:SESDriver ST:Parameter:
'jdbc-driver-descriptor' Value: null
[08/08/08 16:40:56.062]:SESDriver ST:Parameter: 'database-descriptor'
Value: null
[08/08/08 16:40:56.062]:SESDriver ST:Searching for driver descriptor
file matching 'oracle.jdbc.driver.OracleDriver'.
[08/08/08 16:40:56.069]:SESDriver STescriptor file '_oracle_jdbc.xml'
successfully loaded.
[08/08/08 16:40:56.069]:SESDriver ST:Third-Party JDBC Driver is "Oracle
JDBC"
[08/08/08 16:40:56.069]:SESDriver ST:Applying declared imports to
driver descriptor '_oracle_jdbc.xml'.
[08/08/08 16:40:56.070]:SESDriver ST:Applying import
'_oracle_codes.xml'.
[08/08/08 16:40:56.070]:SESDriver ST:

<!--
Please send suggestions for improving this descriptor file to
idm@lists.novell.com with the keywords "jdbc" and "descriptor"
somewhere in the subject line.
-->
<jdbc-driver>
<errors>
<connectivity>
<error-code description="connection lost contact">
<value>3135</value>
</error-code>
<error-code description="connection refused | could not
establish connection | database serer not started | connection
timed-out">
<!-- connection refused = SID is incorrect -->
<!-- could not establish a connection = wrong IP
address -->
<!-- database server is not started = start
database-->
<!-- connection timed-out = adjust firewall TCP timeout
settings -->
<value>17002</value>
</error-code>
<error-code description="must be logged on to server">
<value>17430</value>
</error-code>
</connectivity>
<retry>
<!--error-code description="resource busy">
<value>54</value>
</error-code -->
</retry>
<authentication>
<error-code description="login denied; invalid
username/password">
<!-- sql state: 72000 -->
<value>1017</value>
</error-code>
<error-code description="login denied; no CREATE SESSION
privilege">
<value>1045</value>
</error-code>
<error-code description="invalid arguments in call">
<!-- null username or null password -->
<value>17433</value>
</error-code>
</authentication>
<fatal>
<error-code description="maximum open cursors exceeded">
<!-- sql-state = 72000 -->
<value>1000</value>
</error-code>
<error-code description="invalid batch command">
<value>17080</value>
</error-code>
</fatal>
</errors>
</jdbc-driver>
[08/08/08 16:40:56.078]:SESDriver ST:Applying import '_std_err.xml'.
[08/08/08 16:40:56.078]:SESDriver ST:

<!--
Please send suggestions for improving this descriptor file to
idm@lists.novell.com with the keywords "jdbc" and "descriptor"
somewhere in the subject line.
-->
<jdbc-driver>
<errors>
<connectivity>
<sql-state-class description="connectivity-related">
<value>08</value>
</sql-state-class>
<actions>
<check-for-closed-connection/>
<rollback/>
<fetch-metadata/>
</actions>
</connectivity>
</errors>
</jdbc-driver>
[08/08/08 16:40:56.081]:SESDriver ST:Temporary runtime descriptor:
[08/08/08 16:40:56.082]:SESDriver ST:
<jdbc-driver>
<identity>
<name>Oracle JDBC</name>
<jdbc-class>oracle.jdbc.driver.OracleDriver</jdbc-class>
</identity>
<connection-properties/>
<sql-type-map>
<type>
<from>91</from>
<to>93</to>
</type>
</sql-type-map>
<options>
<handle-stmt-results>single</handle-stmt-results>
</options>
<errors>
<connectivity>
<sql-state-class>
<value>08</value>
</sql-state-class>
<error-code>
<value>3135</value>
</error-code>
<error-code>
<value>17002</value>
</error-code>
<error-code>
<value>17430</value>
</error-code>
<actions>
<check-for-closed-connection/>
<rollback/>
<fetch-metadata/>
</actions>
</connectivity>
<retry/>
<authentication>
<error-code>
<value>1017</value>
</error-code>
<error-code>
<value>1045</value>
</error-code>
<error-code>
<value>17433</value>
</error-code>
</authentication>
<fatal>
<error-code>
<value>1000</value>
</error-code>
<error-code>
<value>17080</value>
</error-code>
</fatal>
</errors>
</jdbc-driver>
[08/08/08 16:40:56.086]:SESDriver ST:Parameter: 'sync-filter'
Value: 'list'
[08/08/08 16:40:56.087]:SESDriver ST:Parameter: 'sync-schema'
Value: null
[08/08/08 16:40:56.087]:SESDriver ST:Parameter: 'sync-tables'
Value: [XBDWSES.SYS_T_USER]
[08/08/08 16:40:56.087]:SESDriver STriver is schema-aware.
[08/08/08 16:40:56.088]:SESDriver ST:Parameter: 'force-username-case'
Value: null
[08/08/08 16:40:56.088]:SESDriver ST:Parameter: 'server'
Value: 'jdbcracle:thin:@10.209.32.211:1521:ERP'
[08/08/08 16:40:56.088]:SESDriver ST:Parameter: 'user'
Value: 'XBDWSES'
[08/08/08 16:40:56.089]:SESDriver ST:Parameter:
'connection-properties' Value: ''
[08/08/08 16:40:56.089]:SESDriver ST:Parameter: 'reuse-statements'
Value: [descriptor-dependent]
[08/08/08 16:40:56.089]:SESDriver ST:Parameter:
'use-manual-transactions' Value: [descriptor or
metadata-dependent]
[08/08/08 16:40:56.090]:SESDriver ST:Parameter:
'transaction-isolation-level' Value:
[descriptor-dependent]
[08/08/08 16:40:56.090]:SESDriver ST:Parameter:
'use-single-connection' Value:
[descriptor-dependent]
[08/08/08 16:40:56.091]:SESDriver ST:Parameter: 'minimal-metadata'
Value: [descriptor-dependent]
[08/08/08 16:40:56.091]:SESDriver ST:Parameter: 'handle-stmt-results'
Value: [descriptor-dependent]
[08/08/08 16:40:56.092]:SESDriver ST:Instantiating connection tester
from jdbc driver descriptor file '_oracle_jdbc.xml'.
[08/08/08 16:40:56.092]:SESDriver ST:Parameter:
'connection-tester-class' Value:
'com.novell.nds.dirxml.driver.jdbc.util.connect.JD BCConnectionTester'
[08/08/08 16:40:56.092]:SESDriver ST:Parameter: 'enable-refs'
Value: true
[08/08/08 16:40:56.093]:SESDriver ST:Parameter:
'enable-meta-identifiers' Value: true
[08/08/08 16:40:56.093]:SESDriver ST:Parameter:
'left-outer-join-operator' Value:
[descriptor-dependent]
[08/08/08 16:40:56.094]:SESDriver ST:Parameter: 'include-table-filter'
Value: [descriptor-dependent]
[08/08/08 16:40:56.094]:SESDriver ST:Parameter: 'exclude-table-filter'
Value: [descriptor-dependent]
[08/08/08 16:40:56.094]:SESDriver ST:Parameter:
'function-return-method' Value:
[descriptor-dependent]
[08/08/08 16:40:56.095]:SESDriver ST:Parameter: 'state-dir'
Value: '.'
[08/08/08 16:40:56.095]:SESDriver ST:Parameter:
'supports-schemas-in-metadata-retrieval' Value:
[descriptor-dependent]
[08/08/08 16:40:56.095]:SESDriver ST:Parameter:
'column-position-comparator' Value:
'com.novell.nds.dirxml.driver.jdbc.util.config.com p.StringByteComparator'
[08/08/08 16:40:56.096]:SESDriver ST:Parameter: 'time-syntax'
Value: '1'
[08/08/08 16:40:56.096]:SESDriver ST:Parameter: 'enable-locking'
Value: false
[08/08/08 16:40:56.126]:SESDriver STriverShim.init() returned:


--
hanxiaojt
------------------------------------------------------------------------
hanxiaojt's Profile: http://forums.novell.com/member.php?userid=14251
View this thread: http://forums.novell.com/showthread.php?t=339413