Hi,
Are you using myosotis?
If so, you may want to comment this setting in myosotis.conf :
# JDBC driver URL options
# Must begin with a question mark ("?" character)
# Multiple options must be separated by an ampersand ("&" character)
# Example: to enable persistent connections and SQL warnings
# jdbc.driver.options =?persistentConnection=true&retrieveSQLWarnings=true
# alwaysGetGeneratedKeys=true is recommended for use with sequoia/MySQL to
# get last insert ids properly
jdbc.driver.options = ?alwaysGetGeneratedKeys=true
This will avoid trying to get generated keys when it is not possible.
Cheers
Stephane
On 06/02/09 15:49, "Dan McFadyen" <[email protected]> wrote:
> Hello again,
>
> So I think I got around all the trouble I was having with the binary
> data, but regardless..
>
> Some code I have tries to run the insert statement that is listed in the
> message below (annonymized of course) and complains that it can't return
> autogenerated keys. Well... I don't have auto generated keys, the table
> only has 4 columns and I am giving values to all of them. What exactly
> is autogenerated about this and why?
>
> 2009-02-05 12:41:10,984 DEBUG controller.virtualdatabase.seqbs
> handleMessageMultiThreaded (class
> org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedSt
> atementExecuteUpdateWithKeys): W 281474976710725 0 INSERT INTO table
> (col1, col2, col3, col4) VALUES( '1'::int4, 0, 'string', 1)
> 2009-02-05 12:41:11,000 DEBUG controller.virtualdatabase.seqdb
> 192.168.5.105:25322: Executing distributedRequest 281474976710725 from
> Member(address=/192.168.5.105:1048, uid=seqdb)
> 2009-02-05 12:41:11,031 INFO controller.loadbalancer.RAIDb1 write
> request 281474976710725 failed:
> Backend seqdb - BackendWorkerThread for backend 'localhost1' with RAIDb
> level:1 failed (Returning autogenerated keys is not supported.)
>
> Thanks,
>
> Dan McFadyen
>
>
> The information transmitted is intended only for the person or entity to which
> it is addressed and may contain confidential and/or privileged material.
> Statements and opinions expressed in this e-mail may not represent those of
> the company. Any review, retransmission, dissemination or other use of, or
> taking of any action in reliance upon, this information by persons or entities
> other than the intended recipient is prohibited. If you received this in
> error, please contact the sender immediately and delete the material from any
> computer. Please see our legal details at http://www.cryptocard.com
>
>
> CRYPTOCard Inc. is registered in the province of Ontario, Canada with Business
> number 80531 6478. CRYPTOCard Europe is limited liability company registered
> in England and Wales (with registered number 05728808 and VAT number 869 3979
> 41); its registered office is Eden Park, Ham Green, Bristol, BS20 0EB
>
>
> _______________________________________________
> Sequoia mailing list
> [email protected]
> https://forge.continuent.org/mailman/listinfo/sequoia
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
