Re: The problem to compile Java stored function in Oracle
Boris Poliakovsky wrote:
/*
* Add integers, wrapping at 2^32. This uses 16-bit operations
internally
* to work around bugs in some JS interpreters.
*/
private static int safe_add(byte x, byte y)
{
int rc0 = -1;
try
{
int lsw;
int msw;
lsw = (x& 0xFFFF) + (y& 0xFFFF);
msw = (x>> 16) + (y>> 16) + (lsw>> 16);
rc0 = (msw<< 16) | (lsw& 0xFFFF);
}
catch (Exception e)
{
e.printStackTrace();
rc0 = -1;
}
finally
{
return rc0;
}
}
}
Lew wrote:
What the hell is this routine? This method is a WTF top to bottom.
...
Really, WTF?
Boris Poliakovsky wrote:
I have never been working with Java and JavaScript before (I am PL/SQL
developer), but right now I have to translate one JavaScript as Java
That is not much different from popping COBOL source into a Java program.
They're completely different languages and things don't just pop into one from
another, especially not low-level things.
Storted Function into Oracle. For begining I took three functions from
this script and translated as I understood.
Could you please explain me haw I can do it properly ?
Don't.
The entire JavaScript 'function safe_add(x, y)' has no purpose or utility or
even sense in a Java program. Even if you hadn't given it 'byte' arguments.
Instead of the "throw enough shit at the wall and see what sticks" style of
programming, start with an idea of what you want to do.
If you have no idea of what you want to do, it isn't time to write code yet.
Get an idea of what you want to do.
Write down your idea.
Your idea most likely will involve some change occurring in some data
somewhere, or some data arriving at your routine, and your routine doing
something with that or about that, then returning a value or sending a message
or triggering a change somewhere, then ending.
Figure out what those steps are in detail.
Then write instructions in Java to do that.
--
Lew