Testing a JDBC connection



Hello,

Running an app that uses jdbc to connect to my sql 2005 database. I
am getting a error:

javax.servlet.ServletException: Error initializing BEA ALI Studio
- Error starting database connection pooling.
- SQLException occurred in JDBCPool: com.inet.tds.SQLException:
java.net.UnknownHostException: TESTDB\SQL2K5
params: com.inet.tds.TdsDriver, jdbc:inetdae7:TESTDB\SQL2K5:1433?
database=studiodb. Please check your username, password and other
connectivity info.

I tested the connection useing a MS Datalink object (.udl), it
connects fine.

How can I test the JDBC connection?

Thanks,

Tmuld.

.



Relevant Pages

  • RE: BUG: JDBC connection disconnected, cant reconnect
    ... we've replaced the MS JDBC driver with jTDS JDBC driver, ... There is really nothing the driver can do that will take down SQL Server. ... Our problem is that the JDBC connection running on the localhost ... and then we can't reconnect to the database ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Using Java EE Connection Pools
    ... database with JDBC. ... Problem is, as this bean does work and calls out, opening and closing ... connections via straight JDBC is slow. ... The obvious solution is to use connection pooling; ...
    (comp.lang.java.databases)
  • Re: batch update is sporadically incomplete
    ... the last few entries of a batch are not written. ... > writing to a mysql database using JDBC. ... connection will cause it to use a snapshot that is more current and can ...
    (comp.lang.java.databases)
  • RE: BUG: JDBC connection disconnected, cant reconnect
    ... Are you seeing the same symptoms (connect fine, lose connectivity, have to restart SQL Server to recover)? ... Subject: BUG: JDBC connection disconnected, ... Our problem is that the JDBC connection running on the localhost ... and then we can't reconnect to the database ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)