Re: probleme de connection java oracle

semsouma wrote:
bonjor tout le monde

j'essaye de me connecter à une base de données oracle installée sur
un serveur solaris à traver un programme
java et bien sur le jdbc aprés exécussion du programme le message
suivant est affiché:

com.borland.dx.dataset.DataSetException: Exception d'E/S: Connection
refused
(DESCRIPTION=(TMP=)(VSNNUM=153093888)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))


sachant qu' à travers le même programme j'ai pu me connecter à une
base de données oracle installée
sur un serveur windows.

pouvez vous m'aider à régler ce problème svp?

I have a strange feeling of déja vu. We had a similar question in this newsgroup about a month ago :-)

Oracle error code 12505 means "TNS:listener could not resolve SID given in connect descriptor".

Apparently, this means that the TNS listener service does not recognise the service ID which you specified in your JDBC connection URL. Perhaps you gave the wrong service ID? Or perhaps the Oracle instance has not registered that service ID with the TNS listener?

Caveat: I'm *not* an Oracle expert!

David Harper
Cambridge, England
.

Relevant Pages

  • Re: Oracle JDBC connection class (10.1 vs 10.2)
    ... Totally different recommendations for sharing connection object ... "The Oracle JDBC drivers provide full support for, ...
    (comp.databases.oracle.misc)
  • Oracle JDBC connection class (10.1 vs 10.2)
    ... We have come across rather puzzling difference in JDBC documentation ... Totally different recommendations for sharing connection object ... Oracle strongly discourages sharing a database connection ...
    (comp.databases.oracle.misc)
  • sending a CLOB to oracle via Websphere problem
    ... I'm attempting to perform two different things with a Websphere 5.1 ... application connecting to an Oracle 9i database via JDBC. ... works is to create our own connection pool, and then create the CLOB via the ... This appears to be a problem between JDBC and Oracle. ...
    (comp.lang.java.databases)
  • Re: Oracle specific jdbc and J2EE application server
    ... We need to use the Oracle specific jdbc features such as mapping an Java object to a Oracle Type and for that reason we need to cast the connection and statements returned from the jndi datasource to Oracle ... Typically these objects come from a pooled JDBC connection, and the application server needs to be able to guarantee that no two threads/users will be operating on a given pooled connection at the same time. ...
    (comp.lang.java.databases)
  • Re: Memory shooting up when using Oracle JDBC drivers
    ... I have a JDBC program connecting to Oracle 9i Database using ... memory stabiliases around 110MB. ... Do you store the PreparedStatement with the Connection? ...
    (comp.lang.java.databases)