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]> 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
--
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
