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
