Yea, I am using the Sequoia/Myosotis combo... The tables open fine
now, and there is no errors in the logs for both Sequoia or Myosotis.
that message I get is a warning that since there is no promary key it
will perform updates using a "UPDATE table SET newdata where olddata
limit 1". Is there additional data returned with the regular mysql
protocol when running a SELECT that contains info about keys in the table?
and 1 last question... :)
Is it possible to be able to open multiple tables on the same server
with a single virtualserver config file? as it stands now, I can see
all the tables on the mysql server. but I can only open the 1 I setup in
the xml file....
Robert Hodges wrote:
Hi Brian,
It looks as if Navicat works through native API calls. If so, I
assume you are using myosotis as well as Sequoia? I would try
connecting with myosotis directly to the server to see if the problem
is due to myosotis dropping something.
Another thing is to check the Sequoia logs to see if any error
messages are showing up. It's possible the queries issued by Navicat
are hitting something Sequoia does not support.
Cheers, Robert
On 1/22/08 9:53 PM, "Brian Taber" <[EMAIL PROTECTED]> wrote:
Excellent.... that was easy...
I have another one, I use Navicat to manage my databases. When I
open the table, it yells at me that the table does not have a
primary key, but if I open the table in the designer, it
definately does have a primary key...
Robert Hodges wrote:
Hi Brian,
In your backend definition try adding the Connector/J JDBC URL
option as
shown in the following example:
<DatabaseBackend
name="db1"
url="jdbc:mysql://myhost/mydb?tinyInt1isBit=false">
Cheers, Robert
P.s., I think you meant to post this on the Sequoia general
mailing list.
On 1/22/08 8:52 PM, "Brian" <[EMAIL PROTECTED]>
<mailto:[EMAIL PROTECTED]> wrote:
I use mysql for backend database servers. I have a few
databases that
use a tinyint field with a length of 1 to store a 1 or 0
as a yes or
no. It would be very difficult to change it to another
type, and alter
all tables. when I try to open the tables I get:
[23:17:22] ERROR
[org.continuent.myosotis.protocol.mysql.MySQLProtocolHandler]
- Error
processing query: select active from users limit 1
org.continuent.sequoia.common.exceptions.NotImplementedException:
in
getBytes(1), don't know how to convert type
java.lang.Boolean into a
byte array not implemented
at
org.continuent.sequoia.driver.DriverResultSet.getBytes(DriverResultSet.java:11
24)
at
org.continuent.myosotis.protocol.mysql.MySQLProtocolHandler.sendResultSetRowMe
ssage(MySQLProtocolHandler.java:1245)
at
org.continuent.myosotis.protocol.mysql.MySQLProtocolHandler.sendResultSet(MySQ
LProtocolHandler.java:502)
at
org.continuent.myosotis.protocol.mysql.MySQLProtocolHandler.processQuery(MySQL
ProtocolHandler.java:390)
at
org.continuent.myosotis.protocol.mysql.MySQLProtocolHandler.processCommand(MyS
QLProtocolHandler.java:207)
at
org.continuent.myosotis.protocol.mysql.MySQLProtocolHandler.processClientPacke
t(MySQLProtocolHandler.java:163)
at
org.continuent.myosotis.protocol.mysql.MySQLConnectionHandler.run(MySQLConnect
ionHandler.java:85)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java
:885)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907>
)
at java.lang.Thread.run(Thread.java:619)
[23:17:22] ERROR
[org.continuent.myosotis.protocol.mysql.MySQLConnectionHandler]
-
Reading from socket.
java.io.EOFException
at
java.io.DataInputStream.readByte(DataInputStream.java:250)
at
org.continuent.myosotis.protocol.mysql.MySQLConnectionHandler.readPacket(MySQL
ConnectionHandler.java:129)
at
org.continuent.myosotis.protocol.mysql.MySQLConnectionHandler.run(MySQLConnect
ionHandler.java:84)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java
:885)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907>
)
at java.lang.Thread.run(Thread.java:619)
Is there a easy fix for this?
I have the current SVN version...
_______________________________________________
Hedera mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/hedera
--
Robert Hodges, CTO, Continuent, Inc.
Email: [EMAIL PROTECTED]
Mobile: +1-510-501-3728 Skype: hodgesrm
------------------------------------------------------------------------
_______________________________________________
Hedera mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/hedera
--
Brian Taber
Owner/IT Specialist
Diverse Computer Group
Office: 774-206-5592
Cell: 508-496-9221
[EMAIL PROTECTED]
begin:vcard
fn:Brian Taber
n:Taber;Brian
org:Diverse Computer Group
adr:;;PO Box 601;Fairhaven;MA;02719;USA
email;internet:[EMAIL PROTECTED]
title:Owner
tel;work:774-206-5592
tel;cell:508-496-9221
note;quoted-printable:Our office is located at:=0D=0A=
=0D=0A=
562 Russells Mills Rd=0D=0A=
South Dartmouth, MA 02748=0D=0A=
=0D=0A=
Get Directions=0D=0A=
http://maps.google.com/maps?f=3Dq&hl=3Den&geocode=3D&time=3D&date=3D&ttyp=
e=3D&q=3D562+Russells+Mills+Rd.,+South+Dartmouth,+MA&sll=3D37.0625,-95.67=
7068&sspn=3D42.03917,95.800781&ie=3DUTF8&z=3D16&iwloc=3Daddr&om=3D1&iwsta=
te1=3Ddir
url:http://www.diversecg.com
version:2.1
end:vcard
_______________________________________________
Hedera mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/hedera
