How to Load Java Object into Oracle Database

[dorairaj]

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

[Steve11235]

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.

[dorairaj]

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.

[Steve11235]

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.