Cool. Also I just thought of a brute force solution that we may send
to Bryan to test without going into patch level details. Cris, could
you check that connection.getMetadata().getDriverMajorVersion() (or
"getDriverVersion()") works on your Oracle 8.*, and if it does what
it returns for OCI driver?
Andrus
> I just thought of a dumb and straightforward way to fix it. The
> problem in comparison with older versions of Cayenne is that
> generic Statement.execute(..) is used instead of "executeUpdate"
> and "executeQuery" for update and select respectively.
>
> (1) Cayenne can automatically install a specific flavor of
> OracleAdapter inside OracleSniffer that can check the db version in
> the metadata
>
> (2) We'll introduce an adapter flavor that uses a subclass of
> SQLTemplateAction that checks the SQL string and if it starts with
> "SELECT ..", replaces "execute" with "executeQuery", and otherwise
> - with "executeUpdate".
>
> This is a hack, but it shouod work. If we don't find test
> environment, I can probably code such adapter flavor and send to
> Bryan for testing.
On Feb 22, 2006, at 8:41 PM, Cris Daniluk wrote:
> I probably still have access to an Oracle 8.1.6 install, but... there
> are numerous bugs in Oracle 8.1.6. I added a comment asking for the
> specific version, but odds are its not the latest (on both the client
> side and server side).
>
> We still may want to fix, but it may make it more difficult to
> reproduce if we have to find a specific patch. Meanwhile, I will see
> what I can do.
>
> On 2/22/06, Andrus Adamchik <andru..bjectstyle.org> wrote:
>> Anyone has access to a test instance of Oracle 8.1.6? We have a bug
>> that is specific to that old Oracle (it works on new versions):
>>
>> http://objectstyle.org/jira/secure/ViewIssue.jspa?key=CAY-464
>>
>> The only way to address it is to try different strategies at JDBC
>> level, until one works.
>>
>> Andrus
>>
>
This archive was generated by hypermail 2.0.0 : Wed Feb 22 2006 - 21:05:17 EST