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.sendResultSetRow >>> Me >>> ssage(MySQLProtocolHandler.java:1245) >>> at >>> org.continuent.myosotis.protocol.mysql.MySQLProtocolHandler.sendResultSet(My >>> SQ >>> LProtocolHandler.java:502) >>> at >>> org.continuent.myosotis.protocol.mysql.MySQLProtocolHandler.processQuery(MyS >>> QL >>> ProtocolHandler.java:390) >>> at >>> org.continuent.myosotis.protocol.mysql.MySQLProtocolHandler.processCommand(M >>> yS >>> QLProtocolHandler.java:207) >>> at >>> org.continuent.myosotis.protocol.mysql.MySQLProtocolHandler.processClientPac >>> ke >>> t(MySQLProtocolHandler.java:163) >>> at >>> org.continuent.myosotis.protocol.mysql.MySQLConnectionHandler.run(MySQLConne >>> ct >>> ionHandler.java:85) >>> at >>> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.ja >>> va >>> :885) >>> at >>> >>> >>> >> >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:90 >> 7> >> ) >> >> >>> >>> 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(MyS >>> QL >>> ConnectionHandler.java:129) >>> at >>> org.continuent.myosotis.protocol.mysql.MySQLConnectionHandler.run(MySQLConne >>> ct >>> ionHandler.java:84) >>> at >>> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.ja >>> va >>> :885) >>> at >>> >>> >>> >> >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:90 >> 7> >> ) >> >> >>> >>> 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
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
