Plugins (1067)


Training and Consulting (40)



EPIC Poll

What is your favourite developer portal?

[ Results | Polls ]

Votes: 539
Comments: 0

Post new topic   Reply to topic
View previous topic Printable version Log in to check your private messages View next topic
Author Message
choney
Post subject: use external oracle jars at runtime  PostPosted: Jan 17, 2005 - 05:48 AM
Guest





Hi!

I see no way out. I am trying to create a plugin that updates blob fields in a oracle 9i database.
Therefore I need a cast to oracle types (it does not work with java.sql types) as follows:

dbConn.setAutoCommit(false);

BLOB ablob = null;

Statement stm = dbConn.createStatement(ResultSet.
TYPE_FORWARD_ONLY ,ResultSet.CONCUR_UPDATABLE);


x OracleResultSet rs = (OracleResultSet)stm.executeQuery("select *
from VR_RULET_FILES where (filename = 'threeblob') FOR UPDATE");


At x some strange Exception occurs: Unhandled exc. in event loop. Reason oracle/jdbc/driver/OracleResultSet

Although the import of oracle.jdbc.driver.OracleResultSet works at build time it seems not to be resolved at runtime. I also specified oin the plugins xml to export the oracle jar file containing these classes (it's ojdbc14.jar).
The jar is added to the build path of the plugin as well so it is resolved at build time.

Has anybody got an idea how to tell a plugin what its classes are at runtime besides what I have already tried out?

Please help me!

thanx in advanve

choney
 
   
Reply with quote Back to top
Guest
Post subject: RE: use external oracle jars at runtime  PostPosted: Apr 06, 2005 - 11:03 AM






Am using this statement to import oracle.jdbc.driver.*; I have already added oracle14.jar to my lib dir, and also reference it to my project. When I compile am still getting and "error.java.lang.ExceptionInInitializerError
java.lang.Class.forName0(Native Method)" Any ideas?
 
   
Reply with quote Back to top
Display posts from previous:     
Jump to:  
All times are GMT - 6 Hours
Post new topic   Reply to topic
View previous topic Printable version Log in to check your private messages View next topic
Powered by PNphpBB2 © 2003-2004 The PNphpBB Group
Credits