|
I have a few questions about accessing
HypersonicSQL when acting as the data source for Orion. I am assuming the HSQL
is running in the same JVM as Orion (the default configuration.)
How do I access the HypersonicSQL data source from Java using JDBC, but outside the JVM of Orion ? Is there a dirver and URL to use ?
How do I access the HypersonicSQL data source from Excel running on a desktop ? (i.e. Is there "native" ODBC access to HypersonicSQL when the client is running on a Windows desktop ?)
A question on best practice; when updating a J2EE data source in “batch” (perhaps posting information at night) do I write a program that runs in the Orion JVM (how do I invoke it ?) or do I write a program that updates outside of Orion ? In both cases I would use EJBs (right ?) |
