alternative subjects: (none possible in 2.2.0)
* universal SQL application code
* conversion between java.sql.Connection
and sdbc.XConnection
* Base linked tables
Dear Frank Schönheit (OO Base team):
This is a continuation of previous discussions in various OO forums [1, 2, 3].
Please redirect me if there is a more approriate forum for this kind of
discussion.
I have been working on the feasibility of the following integration in a medium
size business environment:
application (Java) +
GUI (local spreadsheet, OO Calc) + data 1 (local OO Base *.odb) +
data 2 (JDBC RDBMS) + data 3 (JDBC RDBMS) + etc.
Unfortunately OO (API, Base, Calc) cannot sufficiently support this integration
at present (see references). I am at a cross road now for the application
design. I need to decide a substitute approach before the OO Base API is
enhanced to support the need of medium size business environment. Some current
candidates are:
* wait for OO API to support Connection and XConnection conversion
Waiting period is uncertain.
Waiting time is not likely on my side.
* temporarily directly access the database content in *.odb
by circumventing sdbc.XConnection
not robust design
anticipate deployment obstacle due to potential financial liability
* eliminate OO Base *.odb from the integration list
MS Excel is the default in my business environment.
MS Excel (not OO Calc) will likely be the GUI
if OO Base is eliminated from the integration.
* switch to MS platform (MS Access, C#, etc.)
a path of almost impossible return to OO
* any other paths?
Your advice on the possible strategies of OO Base API design enhancement will
help me to make the decision. Thanks.
Ray
-----
[1] API document script access (programmatic)
private communication with Juergen Schmidt
regarding script deployment and management
for users in medium size business environment
on collaborative business application development
[2] Base linked tables
dba.openoffice.org/servlets/BrowseList?list=users&by=thread&from=1554208
[3] Base data source
api.openoffice.org/servlets/BrowseList?list=dev&by=thread&from=1786737
api.openoffice.org/servlets/BrowseList?list=dev&by=thread&from=1791719
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
