dushkin dushkin - 1 year ago 95
SQL Question

Mapping SQL NUMERIC[10,0] to java type

I need to map NUMERIC[0,10] parameter type of a sybase stored procedure to a java type.

What would be this type?

Also, if you can help me define a regular expression for this NUMERIC[0,10] type I'll be greatful.


The original question is with NUMERIC[0,10] which is ofcourse illogical. The real type is NUMERIC[10,0].

Thank you.

Kai Kai
Answer Source

Use Long as Integer is to short to map all possible values. Have a look at MAX_VALUE of both types.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download