Hi,
I am trying to see if it's possible to use H2 to create a temporary
database in memory to simulate a Sybase database for testing.
I would create an in-memory h2 database like the following: (set
compatibility mode to MSSQLServer as I found somewhere in the group that
it's very similar to Sybase)
conn = DriverManager.getConnection("jdbc:h2:mem:test;MODE=MSSQLServer");
Then use "linked tables" to link to a Sybase database table so I can get
some test data.
I would then use "create table as select" from the linked tables to create
a local copy so my test application can modify the data without affecting
the underlying Sybase database table.
Next I would drop the linked table.
So in my test application, it uses Sybase syntax for selecting such as
"SELECT * FROM <database>.<owner>.<table>;". However in my case, the
<owner> or schema is not provided in the query since it uses the default
one so the query would look like "SELECT * FROM <database>..<table>;"
Is it possible to make something like "SELECT * FROM test..product;" query
work in H2?
Thanks,
Xavier
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
