This
is definitely Oracle speaking to you - Is the actual
name of your Oracle instance "instance"? The Oracle 12505 error tells
you the instance string is bad
TNS-12505 TNS:listener could not resolve SID given in connect descriptor
Cause: The SID in CONNECT_DATA was not found in the listener's tables.
Action: Check to make sure that the SID specified is correct. The SIDs that are currently registered with the listener can be obtained by typing "LSNRCTL SERVICES listener_name". These SIDs correspond to SID_NAMEs in TNSNAMES.ORA, or DB_NAMES in the INIT.ORA file.
It
also looks like you've got the username/password backwards, isn't it usually
scott/tiger not the other way around.
Cheers
-----Original Message-----I still have problem creating oracle pool.
From: Darius Davidavicius [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 13, 2000 10:53 AM
To: jBoss
Subject: Re: [jBoss-User] Oracle pool
Now error looks like:
[XADataSource] Starting
[XADataSource] XA Connection pool OraclePool bound to OraclePool
[XADataSource] java.sql.SQLException: Io exception: Connection refused(DESCRIPTI
ON=(TMP=)(VSNNUM=135290880)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))
)
[XADataSource] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:1
14)
[XADataSource] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:1
56)
in my jboss.conf:
<MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar,classes12.zip" CODEBASE="../lib/ext/">
<ARG TYPE="java.lang.String" VALUE="OraclePool">
<ARG TYPE="java.lang.String" VALUE="org.jboss.minerva.xa.XADataSourceImpl">
</MLET>
classes12.zip is in ClassPath - %JBOSS_HOME%\lib\ext
in my jboss.jcml
<mbean name="DefaultDomain:service=XADataSource,name=OraclePool">
<attribute name="Properties"></attribute>
<attribute name="URL">jdbc:oracle:thin:@DARIUS:1521:instance</attribute>
<attribute name="Password">scott</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser">tiger</attribute>
<attribute name="MaxSize">0</attribute>
<attribute name="Blocking">false</attribute>
<attribute name="IdleTimeoutEnabled">false</attribute>
<attribute name="LoggingEnabled">false</attribute>
<attribute name="GCEnabled">false</attribute>
<attribute name="GCInterval">120000</attribute>
<attribute name="IdleTimeout">1800000</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
<attribute name="MinSize">0</attribute>
<attribute name="TimestampUsed">false</attribute>
</mbean>
Thanks in advance for sugestions
D&D
