Mark Matthews wrote:
> Setu Garg wrote:
> > On request of Edwin the thread
> >
>
http://forums.mysql.com/read.php?104,13077,page=1
> > will be continued here.
> >
> > We are trying to find solutions to problems
> faced
> > while migrating complex real world schemas
> from
> > Oracle 9i to MySQL 5.0 using the Migration
> > Toolkit.
> >
> > Please go through the above mentioned link to
> read
> > the previous threads.
> >
> > ~Setu.
> >
>
>
> Setu,
>
> There is no SQLJ translator for MySQL available,
> nor planned, since the technology is effectively
> dead. Last time I tried, Oracle's SQL/J runtime
> worked with MySQL.
>
> -Mark
>
It looks like Compiere also depends on Java stored procedures, which won't likely be available until MySQL-5.1 ships, however looking at the sources at
http://cvs.sourceforge.net/viewcvs.py/compiere/sqlj/src/org/compiere/sqlj/ they all look relatively straightforward and could be done as SQL-only stored procedures, as far as I can tell.
-Mark
Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html