Cannot have Database Connection for a project

evergreen

• December 22, 2009 00:00

• Answered

Follow

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

• databaseConn_error.JPG

• 

  avackova

  • December 22, 2009 10:28

  0

  Comment actions Permalink

  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.
• 

  evergreen

  • December 22, 2009 12:47

  0

  Comment actions Permalink

  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
• 

  avackova

  • December 22, 2009 14:27

  0

  Comment actions Permalink

  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
  

• 

  evergreen

  • December 23, 2009 06:15

  0

  Comment actions Permalink

  Hi,
  
  Creating a .cfg file and then linking the Externalized DB connection solved my problem.
  Thanks very much for the suggestion.
  Regards,
  Vinutha

Please sign in to leave a comment.