My assumption was that this had been created, but I am trying to verify this. I do not have full control over this Solaris environment which adds to the fun.
The issue I'm having a hard time understanding is why a connection is made successfully in my Java test code (via a homegrown connection polling mechanism), but Cayenne cannot connect to the same database. It seems like these should either both work or both fail. On 8/20/07, Mike Kienenberger <[EMAIL PROTECTED]> wrote: > > 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 > > >
