I am trying to view the code to the professional C...
# adobe
j
I am trying to view the code to the professional ColdFusion code, but I get an error for chapter 9 the database. I am running commandBox and I have derby installed, but I get the error - Error Executing Database Query. Timed out trying to establish connection How can fix this error? Thanks in advanced for any help.
p
Not sure what "professional coldfusion code" is but it sounds like your datasource isnt connecting to your DB successfully. Check it in your CF Admin.
j
thanks so much for your comment. It's for the Adobe certified professional exam code. I tried to add the datasource in the cf Admin, but I get the error - Connection verification failed for data source: CFTrainingDSN java.sql.SQLException: Timed out trying to establish connection
p
Well just means it cant make a connection to your sql server wherever that is.
j
thanks so much for your comment, and your help! It is the Apache derby database and I have no idea where that is on my system.
p
I have never used Derby, so no clue about the connection config. But I would guess you need to know the port, username, password etc and how to connect to it.