1 2 Previous Next 24 Replies Latest reply: Feb 10, 2012 4:07 PM by Ramazan YILDIRIM Go to original post RSS
  • 15. Re: How to configure Oracle with my application in jboss 5.0
    Peter Johnson Master

    Please post the code that is attempting to establish a connection to the datbase and is writing to stdout.

  • 16. Re: How to configure Oracle with my application in jboss 5.0
    Anand Kumar Novice

    Here is the Code for database Connection

     

    package beans;
    
    import java.sql.*;
    import javax.sql.*;
    import javax.naming.*;
    
    public class OracleDatasource {
        private Connection con;
        
        public Connection getDbConnection() {
            try{
                Context initCtx = new InitialContext();
                Context envCtx = (Context) initCtx.lookup("java:comp/env");
                DataSource ds = (DataSource)envCtx.lookup("jdbc/datanet);
                if (ds == null)
                    System.out.println("datasource not obtained..");
                con= ds.getConnection();
                if (con == null)
                    System.out.println("connection not obtained..");
            } catch( NamingException ne ) {
                throw new RuntimeException( "Unable to aquire data source", ne );
            } catch (SQLException se) {
                System.out.println("Exception occured while obtaining connection...");
                se.printStackTrace();
            }
            return con;
        }//end getDbConnection()
    }//end class
    
  • 18. Re: How to configure Oracle with my application in jboss 5.0
    Anand Kumar Novice

    Still unable to connect even after changing the jboss-web.xml and connection file as said in the above link.

     

    It is giving the same error message:

     

    Unable to connect to the database

     

    Now what to do ???

  • 19. Re: How to configure Oracle with my application in jboss 5.0
    Peter Johnson Master
    Please post the jboss-web.xml file, the portion of the web.xml file that contains the resource-ref, and the oracle-ds.xml file.
  • 20. Re: How to configure Oracle with my application in jboss 5.0
    Anand Kumar Novice

    Thanks once again for your reply

     

    Here are the files which u have requested for...

     

    The contents of jboss-web.xml is

     

    <jboss-web>
         <resource-ref>
              <res-ref-name>jdbc/OracleDS</res-ref-name>
              <jndi-name>java:jdbc/OracleDS</jndi-name>
         </resource-ref>
    </jboss-web>
    

    and the contents of web.xml is:

     

    <resource-ref>
              <res-ref-name>jdbc/OracleDS</res-ref-name>
              <res-type>javax.sql.DataSource</res-type>
              <res-auth>Container</res-auth>
              <res-sharing-scope>Shareable</res-sharing-scope>
         </resource-ref>
    
    
    

     

    There are some more security-constraint also which i have already specified previously in the post here.

     

    The contents of OracleDS.xm file are:

    <?xml version="1.0" encoding="UTF-8"?>
    
    <!-- ===================================================================== -->
    <!--                                                                       -->
    <!--  JBoss Server Configuration                                           -->
    <!--                                                                       -->
    <!-- ===================================================================== -->
    
    <!-- $Id: oracle-ds.xml,v 1.6 2004/09/15 14:37:40 loubyansky Exp $ -->
    <!-- ==================================================================== -->
    <!--  Datasource config for Oracle originally from Steven Coy             -->
    <!-- ==================================================================== -->
    
    
    <datasources>
      <local-tx-datasource>
        <jndi-name>jdbc/OracleDS</jndi-name>
        <connection-url>jdbc:oracle:thin:@xxx.yyy.zzz.www:1521:dbatest</connection-url>
         <!--
              See on WIKI page below how to use Oracle's thin JDBC driver to connect with enterprise RAC.
          -->
         <!--
              Here are a couple of the possible OCI configurations.
              For more information, see http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/java.920/a96654/toc.htm
    
         <connection-url>jdbc:oracle:oci:@youroracle-tns-name</connection-url>
              or
         <connection-url>jdbc:oracle:oci:@(description=(address=(host=youroraclehost)(protocol=tcp)(port=1521))(connect_data=(SERVICE_NAME=yourservicename)))</connection-url>
    
              Clearly, its better to have TNS set up properly.
          -->
        <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
        <user-name>xxxxx</user-name>
        <password>yyyyy</password>
     
        <min-pool-size>5</min-pool-size>
        <max-pool-size>100</max-pool-size>
    
        <!-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool -->
        <!--valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name-->
        <!-- Checks the Oracle error codes and messages for fatal errors -->
        <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
            <!-- sql to call when connection is created
            <new-connection-sql>some arbitrary sql</new-connection-sql>
            -->
    
            <!-- sql to call on an existing pooled connection when it is obtained from pool - the OracleValidConnectionChecker is prefered
            <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
            -->
    
          <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
          <metadata>
             <type-mapping>Oracle9i</type-mapping>
          </metadata>
      </local-tx-datasource>
    
    </datasources>
    

     

    Now what should i have to do further ???

  • 21. Re: How to configure Oracle with my application in jboss 5.0
    jaikiran pai Master
    All your configs are refering to jdbc/OracleDS, so why is your code looking up jdbc/datanet
  • 22. Re: How to configure Oracle with my application in jboss 5.0
    Anand Kumar Novice

    Previously i used jdbc/datanet but after you have specified some changes in the previous post  so that i have changed that thing in the code with new name. Here is Connection Code file:

     

    package beans;
    
    import java.sql.*;
    import javax.sql.*;
    import javax.naming.*;
    
    public class OracleDatasource {
        private Connection con;
        
        public Connection getDbConnection() {
            try{
                Context initCtx = new InitialContext();
                //Context envCtx = (Context) initCtx.lookup("java:comp/env");
                DataSource ds = (DataSource)initCtx.lookup("java:comp/env/jdbc/OracleDS");
                if (ds == null)
                    System.out.println("datasource not obtained..");
                con= ds.getConnection();
                if (con == null)
                    System.out.println("connection not obtained..");
            } catch( NamingException ne ) {
                throw new RuntimeException( "Unable to aquire data source", ne );
            } catch (SQLException se) {
                System.out.println("Exception occured while obtaining connection...");
                se.printStackTrace();
            }
            return con;
        }//end getDbConnection()
    }//end class
    
  • 23. Re: How to configure Oracle with my application in jboss 5.0
    Peter Johnson Master

    I do not see anything wrong offhand. Use JNDIView to get a list of names in JNDI and post that.

    http://community.jboss.org/click.jspa?searchID=504038&objectType=102&objectID=9584

     

    Just to double-check, the datasource lookup code that you posted is in a class in the WAR file, correct?

  • 24. Re: How to configure Oracle with my application in jboss 5.0
    Ramazan YILDIRIM Newbie

    [JmsActivation] Unable to reconnect org.jboss.resource.adapter.jms.inflow.JmsActivationSpec@7b682f(ra=org.jboss.resource.adapter.jms.JmsResourceAdapter@185cb87 destination=queue/JbpmCommandQueue destinationType=javax.jms.Queue tx=true durable=false reconnect=10 provider=DefaultJMSProvider user=null maxMessages=1 minSession=1 maxSession=15 keepAlive=30000 useDLQ=true DLQHandler=org.jboss.resource.adapter.jms.inflow.dlq.GenericDLQHandler DLQJndiName=queue/DLQ DLQUser=null DLQMaxResent=10)
    javax.naming.NameNotFoundException: queue not bound

     

    This is due to default oracle-persistence-service.xml . jboss.messaging:service=PostOffice bean can not be deployed. You have to remove the jgroups properties if you are not using it as clustered or deploy jgroups ChannelFactory...

     

    <attribute name="Clustered">false</attribute> remove the lines below this line....

1 2 Previous Next