Hi,
I have several graphs used on a project.
I need common database connections to be used for all the graphs.
This is because in case I need to change my database connections,I will have to edit in each and every graph.
Instead I want to do this just at one place.
Is there a way to achieve this?
Please find the attached screenshot error when I attempt to open a database connection in Navigator preview
for the whole project.
Thanks
Hello,
how do you try to open the connection?
See External (Shared) Database Connections part of manual for using the same connection with various graphs.
Hi ,
Creating External (Shared) Database Connections: I have followed the same steps as listed under this heading from the manual.
This is when I am faced with the error screen I had attached previosly.
Is there any other way I can handle this problem?
Thanks,
Evergreen
Hi,
try to create internal connection and then externalize it. If it doesn’t help, you can create the cfg file manually an then linked such connection to your graph.
name=shirisha
threadSafeConnection=true
dbDriver=oracle.jdbc.driver.OracleDriver
dbURL=jdbc:oracle:thin:@10.253.150.225:1521:luminis
user=system
driverLibrary=file:${your_path}/ojdbc14.jar
password=test
jdbcSpecific=ORACLE
Hi,
Creating a .cfg file and then linking the Externalized DB connection solved my problem.
Thanks very much for the suggestion.
Regards,
Vinutha