Hi Charles, we also checked the Opta2000 jdbc driver. No enhancement. OJB tells the jdbc driver to generate a parameterized sql statement instead of an 'simple' sql statement. These parameterized sql statement cause the long duration of the execution in my opinion. It is not an spezial problem of jdbc or ojb but maybe a ms sqlserver problem.
Has anyone experience with huge tables and sql server in this matter? Is this an problem of my environmet or does such things also occur for example in an oracle environment. with kind regards Markus Denkinger --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
