Hi Wallace, This is a cross-database rather than cross-schema query. (MySQL does not have a notion of schema that is separate from database.)
Sequoia replicates servers one database at a time. This approach has some plusses and minuses but one of the minuses is that queries of the type shown below do not work. You must connect to and work with a specific database. Incidentally, please post further emails on the sequoia mailing list. The community list is for general announcements. Thanks, Robert On 8/7/08 4:48 AM, "living liquid | Christian Meisinger" <[EMAIL PROTECTED]> wrote: Wallace Wadge wrote: > Hi, > > 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 > > 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/" connectionTestStatement="select 1"> > > > Is this possible under sequoia ? no that doesn't work. i evaluated sequoia too but we can't use it... _______________________________________________ Community mailing list [EMAIL PROTECTED] https://forge.continuent.org/mailman/listinfo/community -- Robert Hodges, CTO, Continuent, Inc. Email: [EMAIL PROTECTED] Mobile: +1-510-501-3728 Skype: hodgesrm
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
