Nancy, the jdbc/odbc bridge is a toy and used a lot for connecting to an Acesss database. You should be using Sybases' JDBC driver if you are connecting to that brand of database.
T.K. -----Original Message----- From: A mailing list for discussion about Sun Microsystem's Java Servlet API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of Susan Sent: Friday, November 22, 2002 4:47 PM To: [EMAIL PROTECTED] Subject: No exception trying to connect to stopped database ? We are connecting to database in standard fashion, using either JDBC driver, or JDBC:ODBC bridge. Here is the problem: if we try to connect to a running database but cannot connect(e.g. due to incorrect password), exception is thrown and we trap the error. This is good. However, if the database is stopped and we attempt connection, the connection is not made ('natch), but it does not throw any type of exception. The code in the calling servlet continues to merrily execute as if nothing is amiss. Is this normal? I am using code found in various books for my connection operation. Example of one of our methods for connecting: public void makeOdbcConn() throws ClassNotFoundException, SQLException { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); conn = DriverManager.getConnection("jdbc:odbc:" + dsn, name, passwd); } this method would then be called inside a try block, with catch(Exception e). It does not go into the catch when database is not running. Does anyone else have this problem, or thoughts on this? We are using Sybase database, and JRun 3.1 for servlet container from which we make these database calls. Thanks in advance for advice. ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
