LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  writing to database table

    Employee
    Posted 01-16-2015 04:47

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: dhrobertson

    hi all,

    I'm doing a test to see if I can get a graph to write results to an access database to test the process.
    a couple of things I've run into that might have an easy solution.

    first issue is around data type conversions. lava uses things like double, Unicode and MS Access doesn't like these data types and errors. if I change the data types in lava to types that Access likes then the DB node seems to be happier. is there a way around this without have to change the data types in lava before pushing out to a database table or is that a standard practice - that you need to convert all fields into a database-readable format first?

    secondly, I have my connection set up and working from what I can tell, however, when I run the node it hangs for a while and then errors. I can see the database lock file being created when the node runs and then removed once it errors. the error I get is as below and no data is transfers..... again it could be an issue with data type?:

    WARN: statement is already locked
    Line: 1
    Operator: 'dbloaderOutput'
    Error Code: brain.node.OdbcStatement.cpp.445

    WARN: Error while commiting row: statement is already locked
    Line: 1
    Operator: 'dbloaderOutput'
    Error Code: brain.node.DBInsertLoader.cpp.394

    WARN: conversion exception
    Line: 1
    Operator: 'dbloaderOutput'
    Error Code: brain.node.DBTableOutput.cpp.217



    this is repeated over and over.

    thanks in advance

    douglas


  • 2.  RE: writing to database table

    Employee
    Posted 01-16-2015 07:39

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: dhrobertson

    update on this....
    I seem to have been able to insert the records into the database with a bit of playing around. as far as the data types are concerned I tried using the currency data type in Access as the conversion type for double and that seemed to work ok.
    think I'm good on this but if anyone has any pearls of wisdom with regards data types from lava to various DB types..... please let me know.

    thanks

    doug