Your windows box has a configured tnsnames.ora file somewhere,
probably somewhere like
\Oracle\product\10.1.0\Client_1\network\ADMIN\tnsnames.ora.
You probably need to configure the same file on your Solaris box.
Either that or use the fully-qualified domain name to your server (and
you still might have issues).
On 8/20/07, Michael Lepine <mikelepin..mail.com> wrote:
> Hello all, I am running into a perplexing issue. I am trying to run an
> application I've written (using Cayenne) on a Solaris 10 box and keep
> getting connection errors. During development, I modified the Cayenne
> driver.xml file many times with different database connection parameters and
> have never had a problem until now. The app was tested on Windows and this
> is the first time it's being run on Solaris. The database version is Oracle
> 10g and the error is:
>
> ORA-12505, TNS:listener does not currently know of SID given in connect
> descriptor
>
> (I've pasted a more detailed stacktrace with the error below.)
>
> This is odd because I am using the same service_name/sid, host and port data
> to connect to the database via TOAD. I have also tested the connection by
> creating another (Java) connection pool with the same connection parameters.
> I even changed the connection parameters to reference another database that
> I've connected to as well and get the same error.
>
> So, I'm at a loss and hope that somebody out there has some ideas. Thanks
> for any help.
>
>
>
> The error I'm seeing is:
>
> [java] ERROR [Thread-3] - [v.2.0.3 May 6 2007] Error detecting database
> type
> [java] org.apache.cayenne.CayenneRuntimeException: [v.2.0.3 May 6 2007]
> Error detecting database type
> [java] at org.apache.cayenne.dba.AutoAdapter.loadAdapter(
> AutoAdapter.java:159)
> [java] at org.apache.cayenne.dba.AutoAdapter.getAdapter(
> AutoAdapter.java:129)
> [java] at org.apache.cayenne.dba.AutoAdapter.getExtendedTypes(
> AutoAdapter.java:239)
> [java] at org.apache.cayenne.access.DataNode.performQueries(
> DataNode.java:246)
> [java] at org.apache.cayenne.access.DataDomainQueryAction.runQuery(
> DataDomainQueryAction.java:301)
> [java] at
> org.apache.cayenne.access.DataDomainQueryAction.access$000(
> DataDomainQueryAction.java:60)
> [java] at
> org.apache.cayenne.access.DataDomainQueryAction$1.transform(
> DataDomainQueryAction.java:273)
> [java] at org.apache.cayenne.access.DataDomain.runInTransaction(
> DataDomain.java:836)
> [java] at
> org.apache.cayenne.access.DataDomainQueryAction.runQueryInTransaction(
> DataDomainQueryAction.java:270)
> [java] at
> org.apache.cayenne.access.DataDomainQueryAction.interceptOIDQuery(
> DataDomainQueryAction.java:138)
> [java] at org.apache.cayenne.access.DataDomainQueryAction.execute(
> DataDomainQueryAction.java:107)
> [java] at org.apache.cayenne.access.DataDomain.onQuery(
> DataDomain.java:746)
> [java] at org.apache.cayenne.util.ObjectContextQueryAction.runQuery
> (ObjectContextQueryAction.java:217)
> [java] at org.apache.cayenne.access.DataContextQueryAction.execute(
> DataContextQueryAction.java:54)
> [java] at org.apache.cayenne.access.DataContext.onQuery(
> DataContext.java:1387)
> [java] at org.apache.cayenne.access.DataContext.performQuery(
> DataContext.java:1376)
> [java] at org.apache.cayenne.DataObjectUtils.objectForQuery(
> DataObjectUtils.java:254)
> [java] at org.apache.cayenne.DataObjectUtils.objectForPK(
> DataObjectUtils.java:240)
> [java] at org.apache.cayenne.DataObjectUtils.objectForPK(
> DataObjectUtils.java:149)
> [java] at
> com.goperiscope.dataaccess.cayenne.CayennePersistenceManager.findObject(
> CayennePersistenceManager.java:26)
> [java] at com.goperiscope.dao.ProcessStatusCodes.getInstance(
> ProcessStatusCodes.java:65)
> [java] at
> com.goperiscope.alaska.SynchronizationProcess.createSynchJob(
> SynchronizationProcess.java:540)
> [java] at com.goperiscope.alaska.SynchronizationProcess.execute(
> SynchronizationProcess.java:144)
> [java] at com.wsc.process.Process.runProcess(Process.java:176)
> [java] at com.wsc.process.Process$1.run(Process.java:343)
> [java] at java.util.TimerThread.mainLoop(Timer.java:432)
> [java] at java.util.TimerThread.run(Timer.java:382)
> Caused by: java.sql.SQLException: Listener refused the connection with the
> following error:
> [java] ORA-12505, TNS:listener does not currently know of SID given in
> connect descriptor
>
This archive was generated by hypermail 2.0.0 : Mon Aug 20 2007 - 17:17:47 EDT