Personally, I can't wait for SQL/J to come back and get the respect it
deserved -- it was AWESOME.
public void showEmployeeWithJob(String vJob, Java.sql.Timestamp vDate) {
String vName; int vSalary;
#sql { SELECT Ename, Sal
INTO :vName, :vSalary
FROM Emp
WHERE Job = :vJob and HireDate = :vDate };
System.out.println(vName + " has the job of " + vJob + " with a
Salary of " + vSalary);
}
Cheers
Kerry
PS: Sample stolen from the internet -- no idea why all variables are
prefixed with "v"!
PPS: I'm kidding about the AWESOMEness
On Thu, May 13, 2010 at 7:37 AM, opinali <opin...@gmail.com> wrote:
> Many years ago (2001) I was writing my "Java Performance Reports", and
> I received this email. I never disclosed this (although it's not that
> a big deal), but it's never too late -
>
> "Hi Osvaldo, I was cruising the web when I encountered your article on
> JavaLobby. I noticed that you referred to Oracle JServer. I just
> wanted to let you know that we now have a new J2EE environment that we
> believe is more suited for multi-tier application development and
> deployment. It no longer uses the custom JVM (Oracle JServer). Instead
> it runs on any standard JVM available for your platform.
>
> Although we still maintain and enhance Oracle JServer, we recommend to
> use it when running your Java in the database.
>
> I invite you to review the content in the following URL and would
> appreciate it if you could take out the reference to Oracle JServer in
> your article.
>
> http://otn.oracle.com/tech/java/oc4j/content.html
>
> Regards,
>
> <name snipped>
> Oracle9iAS
> Oracle Corporation"
>
> For that reason I've never invested on the Java-inside-Oracle feature
> although I'm a heavy Oracle user (most of my enterprise projects,
> since I started my professional career in 1996, use Oracle). It's
> worth noticed that Microsoft's .NET-inside-SQLServer (stored
> procedures written in C#, VB etc.) didn't seem to gain any traction
> either.
>
> On the other hand, now that Oracle owns Java, perhaps they can change
> their mind.
>
> A+
> Osvaldo
>
> On 12 maio, 14:21, Alexey Zinger <inline_f...@yahoo.com> wrote:
> > Not sure how many of the Posse listeners deal with Oracle databases on a
> regular basis, but I remember coding against an Oracle back-end at my very
> first Java job (almost my first job, period) and have been coming into
> contact with those databases periodically ever since, including my current
> work.
> >
> > I remember when Oracle 8i introduced JVM running inside the database,
> which allowed you to write stored procedures in Java, instead of PL-SQL.
> And it just dawned on me now, years later, that as a Java developer,
> knee-deep in enterprise projects most of the time, never gave that feature
> much more than a fleeting glance. The recent Sun acquisition has made me
> wonder if Oracle doesn't have some plans to fortify this angle -- to open
> their RDBMS to other, less traditional techniques. I looked around and
> found some documentation regarding writing Java stored procedures, as things
> stand, and to my disappointment, it appears there is still no way to marshal
> custom objects in or out of Oracle using this technology. At least, it
> doesn't appear to be its intended use. But suppose we could do it? I'm
> already using GWT, which allows me to write a Java "bean" that can go
> seamlessly between a servlet container and Javascript on the client.
> Wouldn't it be neat
> > to be able to extend that language interoperability all the way to the
> relational store?
> >
> > Anyone know anything about Oracle's plans or lack thereof regarding
> DB-embedded Java?
> >
> > Alexey
> > 2001 Honda CBR600F4i (CCS)
> > 2002 Suzuki Bandit 1200S
> > 1992 Kawasaki EX500http:/
> /azinger.blogspot.comhttp://bsheet.sourceforge.nethttp://
> wcollage.sourceforge.net
> >
> > --
> > You received this message because you are subscribed to the Google Groups
> "The Java Posse" group.
> > To post to this group, send email to javapo...@googlegroups.com.
> > To unsubscribe from this group, send email to
> javaposse+unsubscr...@googlegroups.com<javaposse%2bunsubscr...@googlegroups.com>
> .
> > For more options, visit this group athttp://
> groups.google.com/group/javaposse?hl=en.
>
> --
> You received this message because you are subscribed to the Google Groups
> "The Java Posse" group.
> To post to this group, send email to javapo...@googlegroups.com.
> To unsubscribe from this group, send email to
> javaposse+unsubscr...@googlegroups.com<javaposse%2bunsubscr...@googlegroups.com>
> .
> For more options, visit this group at
> http://groups.google.com/group/javaposse?hl=en.
>
>
--
You received this message because you are subscribed to the Google Groups "The
Java Posse" group.
To post to this group, send email to javapo...@googlegroups.com.
To unsubscribe from this group, send email to
javaposse+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/javaposse?hl=en.
