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