Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

JServer - Java In The Database - The first steps along the route to placing java code in an Oracle 8i database.



Ben Thoma said...

Another good page to find out about stored procedures is Oracle's page: http://www.oracle.com/technology/sample_code/tech/java/jsp/oracle9ijsp.html

That, and to get a better understanding of IN/OUT/INOUT procedures, do a quick read at:

http://www-db.stanford.edu/~ullman/fcdb/oracle/or-plsql.html

Ben Thoma said...

By the way, this page is very helpful.

Arindam Mukherjee said...

In Oracle 10g, connection and type casting of the existing program can be written in easy format like below.

// Connect to the database
Connection conn = DriverManager.getConnection("jdbc:default:connection:");


iReturn = resultSet.getInt(1);

I am sorry, I did not try the above snippet in Oracle 8i

Tim... said...

Hi.

Your quite correct. I checked the Java 1.2 ResultSet class and it did support the getInt method. It just goes to show how little I knew about Java then. :)

Thanks for the heads-up.

Cheers

Tim...
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired