CODEWITHSUNDEEP
coldfusion
stopkillinggames.com
stopkillinggames.com

Reputation: 1426

ColdFusion Administrator: adding data source returns "java.sql.SQLException: General error" error

I am trying to add a data source in ColdFusion Administrator. After I fill out fields and click "Submit" I get this error:

Connection verification failed for data source: <connection name>
java.sql.SQLException: General error
The root cause was that: java.sql.SQLException: General error

Here is screenshot for more clarity:

enter image description here

I am not sure what could be the problem. All data appears to be entered correctly.

I have 2 questions:

  1. Anybody knows what could cause this error?
  2. How can I farther debug this error message? Are there some logs I can look at with more details, like a stack trace or something?

Upvotes: 1

Views: 597

Answers (1)

stopkillinggames.com
stopkillinggames.com

Reputation: 1426

The problem was outdated .jar driver file. My database administrator provided me with new, updated version of .jar driver file and that solved the problem.

Driver in question was InterSystems Caché JDBC driver. I am not sure what versions they were (filename was the same - just CacheDB.jar). However, my "bad" .jar was 704 KB, and my "good" .jar is 2,019 KB.

I am also not sure what version of hotfix I am on, but I doubt it's the latest one at the moment of writing this.

Upvotes: 4

Related Questions