SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Hybrid View

  1. #1
    SitePoint Member
    Join Date
    Jan 2005
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Connection verification failed . . . why is this?

    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

  2. #2
    SitePoint Addict danfran's Avatar
    Join Date
    Jan 2005
    Location
    New York City
    Posts
    244
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •