Re: The problem to compile Java stored function in Oracle
On May 31, 9:10 pm, Lew <no...@lewscanon.com> wrote:
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' argum=
ents.
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 y=
et.
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 me=
ssage
or triggering a change somewhere, then ending.
Figure out what those steps are in detail.
Then write instructions in Java to do that.
--
Lew- Hide quoted text -
- Show quoted text -
Thanks Lew for your explaning,
I thought that Java and JavaScript are enough compatible, therefore
before I decided to do java stored function. But Today I used source
JavaScript for the purpose in loop to write necessery information to
text file. Then I loaded this file into Oracle database by using
SQL*Loader, and then I read this information by PL/SQL. The cost of it
is many less than to develop java stored function as I understood with
your help.
Thanks a lot,
Boris