Oracle resource adapter issues
Here is the scenario, I am trying to set up a resource adapter to an Oracle view. First I tried without specifying the schema. This allowed me to create the resource and map all the attributes, but when I tried to assign the resource I got 揙RA-00942: table or view does not exist. ?So I then tried to specify the schema in the JDBC URL template, but when I try to continue to specify the db type and view name I get 揦PRESS exception: Can't call method getTableData on class com.waveset.ui.web.resources.wizard.DBTableUtil ==> com.waveset.util.WavesetException: ==> java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:MIW_IDM_362@<host>:1521:<SID>? (Host and SID removed for obvious reasons.)
Here are some configuration details. I have tried all possible combinations of what is listed.
IDM6
Oracle 9i using thin driver ojdbc14
jdk1.5 / jdk1.6
Tomcat 5.5 / Tomcat 6.0
Can someone please shed some light on where I am going wrong.
Thanks in advance,
Joseph
