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 <[EMAIL PROTECTED]> 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 >
