Connection verification failed . . . why is this?

[jydeda]

Having recently found out what a runtime environment is and installled it attempts to connect to to the database under Datasources come up with the following error message

Connection verification failed for data source: OWS
[]java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check
your username, password, URL, and other connectivity info.
The root cause was that: java.sql.SQLException: SQLException occurred in
JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info

can any one suggest what I need to tweak to fix this

[danfran]

Without really knowing much about that particular message, I can tell you that it would be wise to do a couple of quick tests..

Try logging-in to your database system directly, without using JDBC. If the name & pwd you are trying to use works, then you can safely say that you have a JDBC issue and not a database permission issue. If you are using SQL Server, for example, you can use Query Analyzer or Enterprise manager to log in, directly.

In an attempt to rule out another layer, here, why don't you try pinging the database server from the machine in which you are trying to establish a database connection. This would tell you whether or not two machines have network connectivity.

Does anyone know of a command line tool for JDBC?


Dan