Re: Servlet has problem to connect to Oracale database.

From: Aaron M. Renn <arenn_at_urbanophile.com>
Date: 1998/04/29
Message-ID: <6i79ll$69q$1@news.megsinet.net>#1/1

albert.liu_at_webnex.com wrote in message <35465DA6.3E5D_at_webnex.com>...
>java.sql.SQLException: Error while trying to retrieve text for
>error ORA-12154
>SQLState:
>Message: Error while trying to retrieve text for error ORA-12154
>Vendor code: 12154

Your JDBC driver is having trouble accessing the message catalog to decode the error. Go a command prompt suitable for running Oracle and type "oerr ora 12154" to the real error. (I'd do this myself if I had an Oracle box handy). I seem to recall that this is a fairly common SQL Net error. (Maybe it's even just "cannot connect", which is pretty generic. If that's the case, check out your JDBC's SQLNet config and make sure it's hitting the right host/port/sid).

Aaron.
http://www.urbanophile.com/arenn/ Received on Wed Apr 29 1998 - 00:00:00 CDT