#553 db copy from hsqldb to mysql fails

closed-works-for-me
Rob Manning
5
2010-11-17
2007-09-24
Anonymous
No

hsql has another time format, so i have 2007-09-23 14:34:00,131 instead of a timestamp in mysql.
how can i get around to get to copy a table with hsql-timestamps to mysql?
regards,
Jacob
(lahr at d-labs dot com)

Discussion

  • Rob Manning
    Rob Manning
    2007-09-26

    Logged In: YES
    user_id=1287991
    Originator: NO

    I tried sending this to your email but I'm getting failure to deliver bounce messages. Here is what I sent a couple of days ago (if you want to submit the script(s) you may attach them as files to this ticket):

    Hello Jacob,

    That sure looks like a timestamp to me (2007-09-23 14:34:00,131).
    When I copy a table with TIMESTAMP column in HSQLDB to MySQL, the data
    copies just fine. It would be helpful if you could send me a script
    that has :

    1) Create table for HSQLDB
    2) Create table for MySQL (unless DBCopy is creating the table for you)
    3) At least one insert statement for the HSQLDB database.

    Also, before you send me the script, please run it and verify that you
    still see the behavior where the timestamp isn't copied correctly.
    What version of MySQL and HSQLDB are you using (Server and JDBC
    driver)?

    Rob

     
  • Rob Manning
    Rob Manning
    2010-11-17

    • status: open --> closed-works-for-me
     
  • Rob Manning
    Rob Manning
    2010-11-17

    Tried to get more info a while back on this but the reporter was unreachable. Since I couldn't reproduce the issue, it is now closed.

    Rob