Skip to content

some issues #5

Open
Open
@wuyongfei

Description

@wuyongfei

I am working on a project with your node-odp. there are some issues I have met so far.

1, scalar and reader

sql1 = select count() from a_table where xxx
sql2 = select count(
) as amount from a_table where xxx
when use scalar to run sql1, get nothing. if use reader to run sql2, you always get amount

2, catch error

my app loads records from oracle into mongodb. reader is used. problem is when error occurs (for instance, ora - xxxxxx, say SELECT TO_DATE("Column", 'mm/dd/yyyy') as ADATE FROM a_table but actually '2013-01-01' in the "Column", this causes a conversion error), this error can not be caught. In this case, what my app wants is just ignores the error and works on next row. BUT there is no way from crashing the app.

3, charset

Any other tools I use to get data from Oracle correctly deal with UTF8 chars such as Chinese characters, but node-odp does not. Is there a way to deal with charset?

I may do something wrong??? Need help! Thanks!

Gavin

Activity

bomsy

bomsy commented on Jun 19, 2013

@bomsy
Owner
  1. scalar : nothing is returned because of an error that occurs when your result is converted to a json object. This is due to the asterisk (*) in the column name (which is not valid as a json object). working on fixing that.

reader: the reader returns rows or rowsets so to get your count value use

rows[0]["COUNT(*)"]
  1. i'm working on getting errors to be thrown through the error, update soon.

  2. I'm not consiously dealing with charsets at the moment, but i'm looking into it based on your issue. Update soon.

Thanks

wuyongfei

wuyongfei commented on Jun 19, 2013

@wuyongfei
Author

Thanks a lot Bomsy!

fmatosinhos

fmatosinhos commented on Feb 19, 2014

@fmatosinhos

Hi guys,

Did you solve the problem: "2, catch error"?
Could you give me the solution?

Thanks a lot

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

      Development

      No branches or pull requests

        Participants

        @bomsy@wuyongfei@fmatosinhos

        Issue actions

          some issues · Issue #5 · bomsy/node-odp