Sequoia should be able to return the datastore major/minor version information
for the datastore if all backend db in the same
------------------------------------------------------------------------------------------------------------------------------
Key: SEQUOIA-995
URL: https://forge.continuent.org/jira/browse/SEQUOIA-995
Project: Sequoia
Type: Improvement
Components: JDBC Driver
Versions: sequoia 2.10.10, Sequoia 3.0 beta3, Sequoia 2.10.9, Sequoia
2.10.8, Sequoia 2.10.7, Sequoia 2.10.6, Sequoia 2.10.5, Sequoia 3.0 beta2,
Sequoia 2.10.4, Sequoia 2.10.3, Sequoia 3.0 beta1, Sequoia 2.10.2, Sequoia
2.10.1, Sequoia 2.10, Sequoia 2.9
Environment: Windows 2003
Reporter: Ray Hu
A somehow dated question related to the use of JPOX with Sequoia.
https://forge.continuent.org/pipermail/sequoia/2007-February/004790.html
According to JPox developer's reponse is as follows:
http://www.jpox.org/servlet/forum/viewthread?thread=3884&offset=20
->The problem with sequoia driver is that it returns its version for
getDatabaseMajorVersion instead of the
->backend database.
->Sebastian,
->to add more info to this, JPOX has to know the version of the underlying
datastore because without
->that crucial information how do you expect JPOX to send correct SQL for
the version of the datastore ?
->If JPOX is to be used successfully and reliably with Sequoia then
Sequoias JDBC driver should return
->the datastore major/minor version information for the datastore. [For
example with Oracle, when the underlying
->datastore is Oracle v8 JPOX sends JOIN info using old style joins, and
when the datastore is Oracle v9 JPOX
->sends ANSI joins]. JPOX obtains this via JDBC DatabaseMetaData. This is
the prerequisite for JPOX to be
->used with Sequoia. This is the information the Sequoia people need to fix
in their JDBC driver.
The suggestion is if deployment environment enforced the consistency of all
backend databases.Can sequoia return the database's major/minor version by
some setting?
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://forge.continuent.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
