Re: Intermedia Annotator

There is a bug in class
oracle.ord.media.annotator.handlers.db.JDBCAdapter. This is class is bundled in annotator.jar file. This class has a method named initiParams() and the last line of that method reads as:

 m_szURL = m_szJDBCProt + ":" + ":@" + s;

You can note that it is adding an extra colon(:). That is, before @ there should be only one colon and not two. You are getting "No suitable driver" problem because of this. Suppose you use kishori as service name for JDBC OCI driver then it is using

jdbc:oracle:oci8::@kishori as connection URL as opposed to

using jdbc:oracle:oci8:@teja

There is same problem if you use JDBC this driver.

To fix this problem, you can create a class decompile the class file

oracle.ord.media.annotator.handlers.db.JDBCAdapter and remove the extra colon from initParams() method, compile it. If you don't want to place it back in annotator.jar file then just place this first in your classpath so that annotator gui will pick up this corrected class.

I have used it with JDK 1.4.2 on windows XP pro , Oracle 9i. It took me 5 days (about 40 hours) to figure out the problem. I have reported this bug to oracle. Let me (kishori_sharan_at_yahoo.com) know if you need help running it.

--
Posted via http://dbforums.com