MQSeries.net :: View topic - JDBC ODA connecting to the Oracle SQLPlus Database

keniav

Hi all,
I am trying to connect to the database(oracle SQLPlus) using JDBC ODA.
Initially when i used the Database URL from the config file, i get an error saying that my driver path is not valid.
I then changed the Databse URL to the new one and it worked but with an error. The exception is Error in call "core.getTreeNodes:An error occured in getTreeNodes();

I'm giving the info below:
-------------------------------------------------------------------------------------
Old Info with which i got error saying that my driver was not valid

DatabaseDriver=oracle.jdbc.driver.OracleDriver

Database URL=jdbc:ibm-crossworlds:oracle://INEKVA2:1521;SID=ineksrv
____________________________________________________________

Changed Info with which it is able to connect but throwing getTreeNodes() error:

Database URL=jdbc:oracle:thin:@INEKVA2:1521:ineksrv

DatabaseDriver=oracle.jdbc.driver.OracleDriver

Can anyone please tell me why it is throwing failed to get Tree Nodes.
One of my friend, told me that this might be because the database username and password(which is scott and tiger) should be given additional privileges. If this is the error, then how should i change the privileges.

I appreciate if anyone can help me solve this problem.
Thanks