ColdFusion 管理员：添加数据源返回“java.sql.SQLException：一般错误”错误
我正在尝试在 ColdFusion Administrator 中添加数据源。填写字段并单击“提交”后，我收到此错误：
Connection verification failed for data source: <connection name>
java.sql.SQLException: General error
The root cause was that: java.sql.SQLException: General 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:
I am not sure what could be the problem. All data appears to be entered correctly.
I have 2 questions:
- Anybody knows what could cause this error?
- 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?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
问题是过时的 .jar 驱动程序文件。我的数据库管理员向我提供了新的更新版本的 .jar 驱动程序文件，这解决了问题。
有问题的驱动程序是 InterSystems Caché JDBC 驱动程序。我不确定它们是什么版本（文件名相同 - 只是 CacheDB.jar）。但是，我的“坏”.jar 为 704 KB，而我的“好”.jar 为 2,019 KB。
我也不确定我使用的是哪个版本的修补程序，但我怀疑它是撰写本文时的最新版本。
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.