Tyrex / Discussion / Help: Tyrex Datasource config using Oracle 9i

mou - 2003-05-22

Hi,

may anybody give me a Tyrex Datasource config sample for using Oracle 9i?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous - 2003-05-22
  
  try something like this in your domain.xml
  
  <dataSource>
        <name>testDB</name>
        <jar>/path/to/ojdbc14.jar</jar>
       <class>oracle.jdbc.xa.client.OracleXADataSource</class>
        <config>
          <serverName>servername</serverName>
          <portNumber>1521</portNumber>
          <databaseName>dbname-aka-sid</databaseName>
          <user>scott</user>
          <password>tiger</password>
          <driverType>thin</driverType>
        </config>
        <limits>
          <maximum>50</maximum>
          <minimum>5</minimum>
          <initial>5</initial>
          <maxRetain>300</maxRetain>
          <timeout>10</timeout>
        </limits>
      </dataSource>
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- mou - 2003-05-23
  
  Hi,
  
  Thank you for your reply. In fact I made the domain.xml like this.
  
  but the following Exception occured.
  javax.naming.NamingException: Exception creating Tyrex Resource: java.sql.SQLException: I/O例外です。: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092352)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
      at org.apache.naming.factory.TyrexResourceFactory.getObjectInstance(TyrexResourceFactory.java:150)
      at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:186)
      at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:301)
      at org.apache.naming.NamingContext.lookup(NamingContext.java:834)
      at org.apache.naming.NamingContext.lookup(NamingContext.java:181)
      at org.apache.naming.NamingContext.lookup(NamingContext.java:822)
      at org.apache.naming.NamingContext.lookup(NamingContext.java:181)
      at org.apache.naming.NamingContext.lookup(NamingContext.java:822)
      at org.apache.naming.NamingContext.lookup(NamingContext.java:181)
      at org.apache.naming.NamingContext.lookup(NamingContext.java:822)
      at org.apache.naming.NamingContext.lookup(NamingContext.java:194)
      at org.apache.naming.SelectorContext.lookup(SelectorContext.java:183)
      at javax.naming.InitialContext.lookup(InitialContext.java:347)
      at jp.co.toshiba.atom.services.util.BloUtil.getDBConnection(Unknown Source)
  
  do you know the reason?
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous - 2003-05-23
  
  double check your config and oracle-listner. This looks like a connection problem (Can't find SID)
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- mou - 2003-05-26
  
  But I use the same DB and config with no problem by using Tomcat DBCP.
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- rm - 2003-05-28
  
  Can you post the config that you use?
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Tyrex Datasource config using Oracle 9i

Forums

Help

Tyrex Datasource config using Oracle 9i document.SUBSCRIPTION_OPTIONS = { "thing": "topic", "subscribed": false, "url": "subscribe", "icon": { "css": "fa fa-envelope-o" } };

Tyrex Datasource config using Oracle 9i