Java class in DB

Question

Can someone explain why the idea of ​​storing a Java class in Db? What is this good for? How to create a stored procedure with a Java class?

Yours faithfully!

Answer 1

Oracle introduced stored procedures to its database in release 8i. I stood for Internet, as in Internet ready, which was mostly a bit of marketing. But Java stored procedures allowed Oracle to significantly expand the range of functionality available in the database through the use of a large number of available Java libraries. Many of the new database features in Oracle 8i were shells for PL / SQL Java libraries, in particular XML materials.

Significantly, Oracle has re-released a lot of this functionality in native C in Oracle 9 because it worked much faster than Java wrapped stuff. I know I like it.

, Java? , Java, . , JSP java ICE Syslog, PL/SQL syslog. Java - . , JSP host, PL/SQL .

, JSP, Java PL/SQL. :

• , .
• , Java , .

, , , - Java . , (T-SQL vs PL/SQL ..), , SQL.

JSP Oracle, -, . , , Oracle, , .

Answer 2

, ... , , , Java, . : http://www.oracle.com/technology/tech/java/jsp/index.html

Answer 3

, .

, , Oracle Java .

Answer 4

, . Java . , JDBC, , ..

http://en.wikipedia.org/wiki/Object-relational_mapping

Answer 5

Sybase ASE Java, Java 1.2 ASE 15, IIRC. - . .

Answer 6

Debuger,

, .

:

• Java ?
• Java ?
• Java ?

1 , Java SQL

For point 2, there are object-relational structures that will map a Java object (instance) to relational tables for read and write access. (Example: see Hibernate)

For point 3, you can hypothetically write a ClassLoader that will load classes from a database record containing the BLOB of the class in question.

Hope this helps.