Nandana,
MySQL does not currently support stored procedures or triggers.
The solution is to code the logic in the application. If Java allows
the use of interpreted code, you could maybe store some Java procedures
in TEXT fields in your database. Then your applications could fetch
them from the database and execute them locally. In this way you would
at least get some maintenance relief: you do not need to update your
client programs if you change the "stored procedures" in the server.
Just an idea, though.
Generally, since different databases have different stored procedure
syntax, writing portable stored procedures is hard anyway.
Does anyone know how standardized is Java as a stored procedure language?
I think several databases today allow writing stored procedures also in
Java, in addition to some proprietary language.
Regards,
Heikki Tuuri
Innobase Oy
....................................
Hi,
we have some our groupware products,written in java using 3 tier archi.
front end -jsps running on tomcat/apachebissiness logic- ejb running on ias
back end - oraclewe have written some stored procedures,trigers for oracle.
Now we want to use Mysql as the database as well as the oracle.Actually
we want to make the database independent product.
is Mysql support SPs and Trigeers??
if not, what is the solution for
achieving our target with minimal changes..Please reply me soon.Thank you..
nandana dassanayake.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
