How to Load Java Object into Oracle Database

Hi All ,

I want to load java object into Oracle. As of now i m able to load java object to oracel by using java Program like getting runtime Object and execute that(Runtime.getRuntime().exec("cmd /c start loadjava -user usename/password hostname -f -v -resolve javaObjectName). But the problem with this is additionallly Cmd prompt window will open while program is running i dont want like that. Is there any solution to Loadjava object into Oracle let me know pls

thanks in Advance

I'm not sure what you mean by a Java object; it could either mean the values currently in an instance of a class or a .class file in the file system.

If you mean the first, look into serialization. This allows you to take the values in an instance and store them in a binary or XML format in your database and then retrieve them into a new instance later on.

If you mean the second, you can open the file as a binary stream and write the stream to the database.

Either way, you would use JDBC to access your database.

Hi,

I mean to say java Object in the sense either .class or .java file.

and one more thing

After loading java object to Database. I must
able to call the any method within the class in oracle.

Sounds to me like you want to create some sort of Java stored procedure in Oracle, or you want to make an external program call from Oracle to a Java class.

First, find out what you want to do. I suggest talking to an Oracle system architect about your business goals. Regardless, this sound more like an Oracle question than a Java one.