Hi All,

I am having problems with the JDBC Driver (patched to the latest
version 3.5.8, running on IDM 4.0.1). The problem we are facing, I have
never seen before! We are getting a java.lang.StackOverflow error during
driver startup. The JDBC driver is configured to look at 4 views in a
Microsoft SQL 2008 server.
When I remove one of the views, leaving only 3 views left for the
driver to look at, the java.lang.StackOverflow is gone! So we thought
this is a memory issue. Although it is not giving a OutOfMemory error
which I have resolved in the past by increasing heapsize and stack size,
we tried to play around with the JAVA memory settings, with no luck.
:-(
Also we have tried to remove the JDBC drivers state files and try to
start the driver again, but this results in the same error as before.

I was hoping someone on the Novell forums has encountered the same
error, and has a solution to solve this issue. But I am afraid this is a
bug, so a colleague has submitted a bug in bugzilla.

Any suggestions or other information related to the above issue, is
very much appreciated!

TRACE FRAGMENT:


Code:
--------------------

[02/22/12 12:19:53.404]:PROGRESS PT:Connecting to database...
[02/22/12 12:19:53.404]:PROGRESS PT:BEGIN Open connection 'dedicated0'.
[02/22/12 12:19:53.424]:PROGRESS PT:END Open connection.
[02/22/12 12:19:53.424]:PROGRESS PT:Connected to database.
[02/22/12 12:19:53.424]:PROGRESS PT:Retrieving database metadata
[02/22/12 12:19:53.425]:PROGRESS PT:BEGIN Get database properties.
[02/22/12 12:19:53.425]:PROGRESS PT: Database name: Microsoft SQL Server
[02/22/12 12:19:53.425]:PROGRESS PT: Database version: 10.50.1600
[02/22/12 12:19:53.426]:PROGRESS PT: JDBC driver name: Microsoft SQL Server JDBC Driver 3.0
[02/22/12 12:19:53.426]:PROGRESS PT: JDBC driver version: 3.0.1301.101
[02/22/12 12:19:53.427]:PROGRESS PT: JDBC driver major version: 3
[02/22/12 12:19:53.427]:PROGRESS PT: JDBC driver minor version: 0
[02/22/12 12:19:53.427]:PROGRESS PT: Case sensitive: false
[02/22/12 12:19:53.428]:PROGRESS PT: Stored case: mixed
[02/22/12 12:19:53.428]:PROGRESS PT: Association case: upper
[02/22/12 12:19:53.429]:PROGRESS PT: Username: 'idm_user'
[02/22/12 12:19:53.431]:PROGRESS PT: Supported table types: ["TABLE"]
[02/22/12 12:19:53.431]:PROGRESS PT: Supported view types: ["VIEW"]
[02/22/12 12:19:53.431]:PROGRESS PT: Supports views: true
[02/22/12 12:19:53.432]:PROGRESS PT: Maximum number of columns in select statement: 4096
[02/22/12 12:19:53.432]:PROGRESS PT: Maximum number of connections: unknown/unlimited
[02/22/12 12:19:53.433]:PROGRESS PT: Maximum number of open statements: unknown/unlimited
[02/22/12 12:19:53.433]:PROGRESS PT: Supports transactions: true
[02/22/12 12:19:53.433]:PROGRESS PT: Supports multiple transactions over multiple connections: true
[02/22/12 12:19:53.434]:PROGRESS PT: Supports mixed DML And DDL transactions: true
[02/22/12 12:19:53.434]:PROGRESS PT: Supports only DML transactions: false
[02/22/12 12:19:53.434]:PROGRESS PT: DDL statement in transaction forces commit: false
[02/22/12 12:19:53.434]:PROGRESS PT: DDL statement ignored in transactions: false
[02/22/12 12:19:53.434]:PROGRESS PT: Supports schema qualifiers in DML statements: true
[02/22/12 12:19:53.435]:PROGRESS PT: Supports schema qualifiers in procedure calls: true
[02/22/12 12:19:53.435]:PROGRESS PT: Supports LIKE escape clauses: true
[02/22/12 12:19:53.436]:PROGRESS PT: Wildcard escape character: \
[02/22/12 12:19:53.436]:PROGRESS PT: Supports batch updates: true
[02/22/12 12:19:53.436]:PROGRESS PT: Supports retrieval of auto-generated keys: true
[02/22/12 12:19:53.437]:PROGRESS PT: Supports limited outer joins: true
[02/22/12 12:19:53.437]:PROGRESS PT: Supports column aliasing: true
[02/22/12 12:19:53.437]:PROGRESS PT: Database major version: 10
[02/22/12 12:19:53.438]:PROGRESS PT: Database minor version: 50
[02/22/12 12:19:53.438]:PROGRESS PT: Searching for database descriptor file matching the runtime database.
[02/22/12 12:19:53.439]:PROGRESS PT: Loading database descriptor file '_ms_sqlserver_2005.xml'.
[02/22/12 12:19:53.439]:PROGRESS PT: Applying imports to driver descriptor '_ms_sqlserver_2005_jdbc.xml'.
[02/22/12 12:19:53.440]:PROGRESS PT: Applying import '_ms_sqlserver_2005.xml'.
[02/22/12 12:19:53.441]:PROGRESS PT: Parameter: 'reuse-statements' Value: true
[02/22/12 12:19:53.441]:PROGRESS PT: Parameter: 'left-outer-join-operator' Value: 'LEFT OUTER JOIN'
[02/22/12 12:19:53.442]:PROGRESS PT: Parameter: 'add-default-values-on-view-insert' Value: true
[02/22/12 12:19:53.442]:PROGRESS PT: Parameter: 'current-timestamp-stmt' Value: 'SELECT (CURRENT_TIMESTAMP)'
[02/22/12 12:19:53.443]:PROGRESS PT: Parameter: 'include-table-filter' Value: '.*'
[02/22/12 12:19:53.443]:PROGRESS PT: Parameter: 'exclude-table-filter' Value: null
[02/22/12 12:19:53.444]:PROGRESS PT: Parameter: 'function-return-method' Value: 'dynamic'
[02/22/12 12:19:53.444]:PROGRESS PT: Parameter: 'use-manual-transactions' Value: true
[02/22/12 12:19:53.445]:PROGRESS PT: Parameter: 'minimal-metadata' Value: false
[02/22/12 12:19:53.445]:PROGRESS PT: Parameter: 'handle-stmt-results' Value: 'multiple'
[02/22/12 12:19:53.446]:PROGRESS PT: Parameter: 'transaction-isolation-level' Value: 'read committed'
[02/22/12 12:19:53.446]:PROGRESS PT: Parameter: 'use-single-connection' Value: false
[02/22/12 12:19:53.447]:PROGRESS PT: Parameter: 'time-translator-class' Value: 'public com.novell.nds.dirxml.driver.jdbc.db.DBTimestamp(j ava.lang.String,java.lang.String,java.lang.String, java.lang.String)'
[02/22/12 12:19:53.448]:PROGRESS PT: Parameter: 'supports-schemas-in-metadata-retrieval' Value: true
[02/22/12 12:19:53.448]:PROGRESS PT: Parameter: 'lock-generator-class' Value: 'class com.novell.nds.dirxml.driver.jdbc.db.lock.DBLockGe nerator'
[02/22/12 12:19:53.449]:PROGRESS PT: Parameter: 'connection-properties' Value: ''
[02/22/12 12:19:53.450]:PROGRESS PT:END Get database properties.
[02/22/12 12:19:53.450]:PROGRESS PT:BEGIN Get table metadata.
[02/22/12 12:19:53.450]:PROGRESS PT: Searching for table/view 'dbo.idm_student' using type filter ["TABLE"].
[02/22/12 12:19:53.457]:PROGRESS PT: No match.
[02/22/12 12:19:53.457]:PROGRESS PT: Searching for table/view 'dbo.idm_student' using type filter ["VIEW"].
[02/22/12 12:19:53.461]:PROGRESS PT: Match found.
[02/22/12 12:19:53.562]:PROGRESS PT: Searching for table/view 'dbo.idm_groep' using type filter ["TABLE"].
[02/22/12 12:19:53.566]:PROGRESS PT: No match.
[02/22/12 12:19:53.566]:PROGRESS PT: Searching for table/view 'dbo.idm_groep' using type filter ["VIEW"].
[02/22/12 12:19:53.572]:PROGRESS PT: Match found.
[02/22/12 12:19:53.605]:PROGRESS PT: Searching for table/view 'dbo.idm_organisatie' using type filter ["TABLE"].
[02/22/12 12:19:53.609]:PROGRESS PT: No match.
[02/22/12 12:19:53.609]:PROGRESS PT: Searching for table/view 'dbo.idm_organisatie' using type filter ["VIEW"].
[02/22/12 12:19:53.613]:PROGRESS PT: Match found.
[02/22/12 12:19:53.669]:PROGRESS PT: Searching for table/view 'dbo.idm_opleiding' using type filter ["TABLE"].
[02/22/12 12:19:53.672]:PROGRESS PT: No match.
[02/22/12 12:19:53.672]:PROGRESS PT: Searching for table/view 'dbo.idm_opleiding' using type filter ["VIEW"].
[02/22/12 12:19:53.675]:PROGRESS PT: Match found.
[02/22/12 12:19:53.712]:PROGRESS ST:Received state change event.
[02/22/12 12:19:53.713]:PROGRESS ST:Transitioned from state '%+C%14CStarting%-C' to state '%+C%14CRunning%-C'.
[02/22/12 12:19:53.713]:PROGRESS ST:Successfully processed state change event.
[02/22/12 12:19:53.753]:PROGRESS PT: Number of table/view definitions cached from schema: 4
[02/22/12 12:19:53.754]:PROGRESS PT: Number of syncable classes in schema: 4
[02/22/12 12:19:53.754]:PROGRESS PT: Cached tables/views:
[02/22/12 12:19:53.754]:PROGRESS PT: dbo.idm_groep
[02/22/12 12:19:53.755]:PROGRESS PT: dbo.idm_opleiding
[02/22/12 12:19:53.755]:PROGRESS PT: dbo.idm_organisatie
[02/22/12 12:19:53.755]:PROGRESS PT: dbo.idm_student
[02/22/12 12:19:53.755]:PROGRESS PT:END Get table metadata.
[02/22/12 12:19:53.756]:PROGRESS PT:Retrieved database metadata.
[02/22/12 12:19:53.756]:PROGRESS PT:BEGIN Set transaction isolation level.
[02/22/12 12:19:53.756]:PROGRESS PT:END Set transaction isolation level.
[02/22/12 12:19:53.757]:PROGRESS PT:Connecting to database...
[02/22/12 12:19:53.757]:PROGRESS PT:BEGIN Open connection 'dedicated1'.
[02/22/12 12:19:53.771]:PROGRESS PT:END Open connection.
[02/22/12 12:19:53.771]:PROGRESS PT:Connected to database.
[02/22/12 12:19:53.772]:PROGRESS PT:BEGIN Set transaction isolation level.
[02/22/12 12:19:53.772]:PROGRESS PT:END Set transaction isolation level.
[02/22/12 12:19:53.780]:PROGRESS PT:Unhandled Exception: java.lang.StackOverflowError
[02/22/12 12:19:53.797]:PROGRESS PT:java.lang.StackOverflowError
at java.util.LinkedList.listIterator(Unknown Source)
at java.util.AbstractList.listIterator(Unknown Source)
...
at com.novell.nds.dirxml.driver.jdbc.util.table.JDBCP arentTable.setDepth(Unknown Source)
at com.novell.nds.dirxml.driver.jdbc.util.table.JDBCP arentTable.setDepth(Unknown Source)
at com.novell.nds.dirxml.driver.jdbc.util.table.JDBCP arentTable.setDepth(Unknown Source)
at com.novell.nds.dirxml.driver.jdbc.util.table.JDBCP arentTable.setDepth(Unknown Source)
at com.novell.nds.dirxml.driver.jdbc.util.table.JDBCP arentTable.setDepth(Unknown Source)
...
[02/22/12 12:19:54.338]:PROGRESS PT:Shutting down...
[02/22/12 12:19:54.338]:PROGRESS PT:BEGIN Close connection 'dedicated0'.
[02/22/12 12:19:54.339]:PROGRESS PT:END Close connection.
[02/22/12 12:19:54.339]:PROGRESS PT:BEGIN Close connection 'dedicated1'.
[02/22/12 12:19:54.340]:PROGRESS PT:END Close connection.
[02/22/12 12:19:54.361]:PROGRESS PT:Shut down.

--------------------


--
ttimmers
------------------------------------------------------------------------
ttimmers's Profile: http://forums.novell.com/member.php?userid=26810
View this thread: http://forums.novell.com/showthread.php?t=452515