Yes it does. Gilles, should we expect this feature to be added in myosotis
in future times?
Thanks for all the help.
Owais
From: Gilles Rayrat [mailto:gilles.rayrat-***@public.gmane.org]
Sent: Monday, January 12, 2009 4:38 PM
To: owais
Cc: 'doug chan'; myosotis-RyYwo1q5J+pm4DMUGMHt/jIQnlzKTOB+***@public.gmane.org
Subject: Re: [Myosotis] Problem using Sequoia and Myosotis
Owais,
I understand your point but myosotis is originally aimed to be used with
mysql backends, this is the original assumption and it is mandatory to be as
transparent as possible to native client applications
Now, it is still possible to extend myosotis to support any database. This
requires to:
- catch all mysql specific calls
- create new configuration variables for each above call in
myosotis.properties
- return these variables instead of forwarding to the backend.
Does it sound fair?
Gilles.
owais wrote:
I have done the exact same thing as you suggested. But I thing that this
solution is not comprehensive. The reason I am not saying this solution a
comprehensive one is when we are talking about sequoia this means we can
have as many backend databases of different types we want.
From the abstract point of view, Myosotis is behaving as a Database for any
MySQL native clients. So, Myosotis should contain its own properties and it
shouldn't pass these commands to database or sequoia (in my case). What do
you suggest?
Owais
From: Gilles Rayrat [mailto:gilles.rayrat-***@public.gmane.org]
Sent: Monday, January 12, 2009 3:31 PM
To: owais
Cc: myosotis-RyYwo1q5J+pm4DMUGMHt/jIQnlzKTOB+***@public.gmane.org
Subject: Re: [Myosotis] Problem using Sequoia and Myosotis
OK, I understand your issue now: some mysql-specific commands like "SHOW
VARIABLES" won't work on MSSQL.
In order to fix this, you will have to catch this commands in myosotis.
First off, I suggest you download latest (0.6.4) code from the svn trunk.
Here, your playground will be MySQLProtocolHandler.java. The
preprocessQuery() function is your friend, it will allow you to catch
statements you don't want to forward to backends, just return hard coded
value to your mysql client and this should do the trick.
Don't hesitate to keep us informed with your progress.
Cheers,
Gilles.
owais wrote:
Giller, as a matter of fact I am plugging a MySQL native Client to myosotis
and have MSSQL backend running with Sequoia.
From: Gilles Rayrat [mailto:gilles.rayrat-***@public.gmane.org]
Sent: Monday, January 12, 2009 3:05 PM
To: owais
Cc: myosotis-RyYwo1q5J+pm4DMUGMHt/jIQnlzKTOB+***@public.gmane.org
Subject: Re: [Myosotis] Problem using Sequoia and Myosotis
Owais,
I'm not sure to fully follow you here, so let me recap what we have and what
we can do:
Myosotis is a native protocol proxy to jdbc. It translates mysql or postgres
native calls into jdbc call.
So if you have a mysql .net client, you can use myosotis as-is, because your
.net client will talk mysql native protocol.
Now, if you want to plug a native MSSql client to myosotis, you will have to
implement the whole MSSql native protocol in myosotis...
Alternatively, you still can plug a MySQL native client to myosotis and have
MSSql backend running with sequoia...
Is there anything I missed? Can you describe exactly what you would like to
do?
Thanks,
Gilles.
owais wrote:
Gilles, thanks for the reply, I am fixing this bug myself as I have to give
support of non-JDBC clients to sequoia (that's why I am using Myosotis with
Sequoia). Is there any other better way for supporting non-JDBC clients like
.NET clients to sequoia ?
Secondly, the main reason of this error is when Mysql client connects with
Myosotis, in order to give the database settings (character set, size blah
blah) it calls following statements
SHOW VARIABLES
SHOW COLLATION
SET charset ..
In order to do quick fix, I have mapped these calls to MSSQL compatible
calls. So far its works but I havn't thoroughly tested
thou. I would love to contribute on support of mssql given any opportunity.
-Owais
From: Gilles Rayrat [mailto:gilles.rayrat-***@public.gmane.org]
Sent: Monday, January 12, 2009 1:51 PM
To: owais
Cc: myosotis-RyYwo1q5J+pm4DMUGMHt/jIQnlzKTOB+***@public.gmane.org
Subject: Re: [Myosotis] Problem using Sequoia and Myosotis
Hi Owais,
Myosotis only supports MySQL and PostgreSQL databases.
There is currently no plan for implementing MSSql protocol, but we will of
course offer enthusiastic support to open source collaboration (provided
there is no copyright issues with it)
Thanks for using Myosotis!
Gilles.
owais wrote:
I am using Myosotis 6.2 and Sequoia 2.10. I have a scenario in which i am
connecting mysql client to sequoia via Myosotis. This thing works if i am
using MySQL backend databases on Sequoia. Now, when i used MSSQL backend
databases on sequoia it is giving me the following error "SHOW VARIABLE
failed on backend mssql1".
Kindly help:
Following is the forum post i made earlier:
http://www.continuent.com/community/sequoia/forum?func=view
<http://www.continuent.com/community/sequoia/forum?func=view&id=67&catid=4>
&id=67&catid=4
-Owais