Has anybody successfully used hibernate in a oracle server-side application?

Since Oracle 8.1.5 you can deploy non-gui java code directly on the db server
to improve the performance of your business logic (by reducing the network overhead).

There are only some limitations on that code, so I am wondering if hibernate can be used for this.

The limitations of the server-side code are (as far as I know):
- no GUI (only business logic)
- forced to use one of two oracle jdbc driver (jdbc.oracle.thin or jdbc.oracle.oci8)
- the connection is implicit (no explicit init possible)
- the connection cannot be closed
- the conneciton must be to the db in which the code is running

Is this a problem for hibernate?

Thx,
Juergen

Seems not. Check the JVM version too.

What does that mean
the connection is implicit

Note that this architecture is not really recommanded, since it's not scalable at all. And it's very expensive: a DB CPU license is more expensive than others

>> what does that mean the connection is implicit?

oracle provides an instance of the connection object which is ready to use...

>> this architecture is not really recommanded, since it's not scalable at all. And it's very expensive: a DB CPU license is more expensive than others

that's right, that's why it is only useful for business logic with heavy db i/o to improve the performance and to be able to use java (instead of pl/sql) if pl/sql is to complicated to implement logic (like difficult calculations)

My first try was not successful:

There seems to be a problem with the jar files:

Archives may NOT be compressed...

Furthermore I hope that the byte code manipulation for the proxies
doesn't make problems...

The connection provided by Oracle should be given to Hibernate as a user tx