Dear staff
we are porting a complex j2ee/Oracle enterprise application to a MaxDb database,
but we have found several problems.
We started using 7.5.00.12 installed on a linux machine, then we have updated to
7.5.00.14.
It seems that database is very unstable: it crashes for a lot of reasons: calling
query statements, calling user defined functions inside sql queries, and so on...
We have a complex package in Oracle environment, used to check users permissions on
documents, activities, etc.: it is made of lot of nested functions.
We are trying to translate it into internal maxdb syntax, but we have been founding
several troubles; for example:
1) we call a function with 3 params, the function calls onother one passing two of
them; when the second function returns, parameters are not valid (they are
re-initialized)
2) even if functions are succesfully compiled, db crashes at run time (we have to
manually restart db!!) if they contain type mismatch (like: int to number)
3) recursion seems to be not possible
On the other hand, we are trying to use existing sql (that runs on Oracle db): we see
that maxdb has the "oracle mode", but we often encounter problems with types: maxdb
seems to be less flexible than oracle. The main issue is that calling such a query
causes the database to crash.
Moreover, we often have to use workaround (swapng parameters in decodes, using dummy
substr(), etc,...)
We don't undertstand what's wrong with our approach, and we would like to know if the
present release of maxdb is stable. Our goal is to develop a fully open source
solution, but considering all of these problems, we aren't sure that maxdb is the
right choice for our purpose.
Thanks in advance
Best regards
Fabio Pinotti
