Click on Windows - Database - Databases
Create new IDE connection
Select the Connection Type as Java DB/Apache Derby
Username - soainftra
Driver Class - org.apache.derby.jdbc.ClientDriver
HostName - localhost (or enter the IP address)
JDBC Port - 1527
Database Name - soinfra
Password - Leave blank
Click on Test Connection - the result will display as success
The tables can be accessed now - Open the SQL Worksheet and execute the required SQL queries
e.g - select * from soainfra.cube_instance
Create new IDE connection
Select the Connection Type as Java DB/Apache Derby
Username - soainftra
Driver Class - org.apache.derby.jdbc.ClientDriver
HostName - localhost (or enter the IP address)
JDBC Port - 1527
Database Name - soinfra
Password - Leave blank
Click on Test Connection - the result will display as success
The tables can be accessed now - Open the SQL Worksheet and execute the required SQL queries
e.g - select * from soainfra.cube_instance
No comments:
Post a Comment