Hi Wallace,
I'm currently reviewing Sequoia for use with MySQL. I have a basic
test running fine but one thing I cannot manage is supporting multiple
schemas (in one DB server). I'm currently using Hibernate which
generates queries like:
select * from schema1.table1
and
select * from schema2.table7
The problem is that MySQL does not support schemas. What you call
schemas here are actually different database instances in MySQL. This is
why in the JDBC URL you have to give a database name and actually in the
requests what you are really referring to is 'select from
database1.table1' and 'select * from database2.table7'.
The virtualization in Sequoia is only per database (you have a virtual
database and not a virtual RDBMS). Cross-database queries are not
supported, this means that you are not allowed to connect to db1 and
select from database2 tables (locking will not work).
Under the JDBC world, the schema parsing allows me to direct the query
to the appropriate catalog but under sequoia I cannot get this to work
even if I define the connection string like:
<DatabaseBackend name="node1" driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://10.239.10.46/ <http://10.239.10.46/>"
connectionTestStatement="select 1">
Is this possible under sequoia ?
If you use a RDBMS that has real support for schemas (not fake schemas
on top of databases like MySQL does) then Sequoia fetches the tables in
every schema and support fully qualified table names with schema
information.
Hope this clarifies things,
Emmanuel
--
Emmanuel Cecchet
FTO @ Frog Thinker
Open Source Development & Consulting
--
Web: http://www.frogthinker.org
email: [EMAIL PROTECTED]
Skype: emmanuel_cecchet
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
