Not able to establish Connection to Database through VisualAdministrator

[Former Member]

Hi All,

In VisualAdministrator I went to JDBC Connector.

I did the following steps.

In Main:

I created Datasource called "ORACLEDS".

DriverName:Oracle_Driver

JDBCVersion:2.0(with XA support)

ObjectFactory:oracle.jdbc.pool.OracleDataSourceFactory

DataSourceType:ConnectionPoolDataSource

CPDS ClassName:oracle.jdbc.pool.OracleComnnectionPoolDatasouce

In Additional:

HostName:mapd11

Password:****

PortNumber:1521

ServerName:10.10.10.234

URL:jdbc:oracle:thin:@xx:1521:alias

user:mapord11

SqlEngine

I selected VendorSQL

In DBInitialization

If i execute desc tab;

Its throwing an error

java.rmi.RemoteException:SQL Statements cannot be executed Over Datasource "OracleDS".If u r using an open sql Datasource you must register your tables using JDDI before u request them.

ResourceException in method ConnectionFactoryImpl.getConnection() baseResourceException SQLException thrown.

ALong with this lots of stack is printed.

Can u plz suggest me how to establish the connection.It's very urgent.I appreciate if anyone can help me out to solve the Issue.

Regards

Ragahva

[Former Member]

Hi,

It seems that you're in the wrong forum: this one is about Visual Composer (not Visual Administrator).

Regards,

Yaniv.