My first thought is that JDBC has an array of connections indexed by a byte-sized index. Let me paraphrase Marie Antoinette, lady famous for her shrewd dietary advice. Let them use DBI.
Marie Antoinette's dietary advice came back to haunt her and gave her a huge albeit very short pain in the neck. Hopefully, I will be better off. On 12/16/2003 02:59:33 PM, "Bobak, Mark" wrote: > Hmm...my first thought is that this could be an OS/network configuration limitation > on the client side? Though it does seem odd to raise an ORA-12154, after many > successful connections.... > > What OS is the client? > > -----Original Message----- > Sent: Tuesday, December 16, 2003 2:39 PM > To: Multiple recipients of list ORACLE-L > > > Dear Gurus, > > We are getting the following error if we try to create more than 256 connections > from the same client. The problem is easily reproducible bt writing simple java > program and keep creating connections(do not close it). > > Did anyone encounter this kind of issue and how did you solve it? > > Exception in thread "main" java.sql.SQLException: ORA-12154: TNS:could not resolve > service name > > at java.lang.Throwable.fillInStackTrace(Native Method) > at java.lang.Throwable.fillInStackTrace(Compiled Code) > at java.lang.Throwable.<init>(Compiled Code) > at java.lang.Exception.<init>(Compiled Code) > at java.sql.SQLException.<init>(SQLException.java:43) > at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168) > at oracle.jdbc.oci8.OCIDBAccess.check_error(Compiled Code) > at oracle.jdbc.oci8.OCIDBAccess.logon(Compiled Code) > at oracle.jdbc.driver.OracleConnection.<init>(Compiled Code) > at oracle.jdbc.driver.OracleDriver.getConnectionInstance(Compiled Code) > at oracle.jdbc.driver.OracleDriver.connect(Compiled Code) > at java.sql.DriverManager.getConnection(Compiled Code) > at java.sql.DriverManager.getConnection(Compiled Code) > at j1.main(Compiled Code) > > Thanks in advance > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Bobak, Mark > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).