[jboss-user] [Installation, Configuration & DEPLOYMENT] - Re: Unauthenticated caller null N sqlException

[ravirachannavar]

Hi Peter

Hey........it worked....:-) 

No error messages.....Only I made changes in the db2-ds.xml(bold letters). This is my xml file
-------------------

<?xml version="1.0" encoding="UTF-8"?>

<!-- ===================================================================== -->
<!--                                                                       -->
<!--  JBoss Server Configuration                                           -->
<!--                                                                       -->
<!-- ===================================================================== -->

<!-- See http://www.jboss.org/community/wiki/Multiple1PC for information about local-tx-datasource -->
<!-- $Id: db2-ds.xml 88948 2009-05-15 14:09:08Z jesper.pedersen $ -->



  <local-tx-datasource>
    <jndi-name>V320MCLDEV</jndi-name>
    <connection-url>jdbc:db2://172.20.1.196:50000:V320MCLDEV</connection-url>
    
    <!-- DB2 Universal Driver Note connection URL is in form of
         jdbc:db2://host:port:dbname
         
         Default port for Type 4 driver is 50000
         
         Note, host and port must be specified if using Type 4 driver. And be forewarned, no native
         XA support is provided with Type 4; you must set a DB property calling for Type 2 to get XA
         
      <driver-class>com.ibm.db2.jcc.DB2Driver</driver-class>
      <connection-url>jdbc:db2://[hostname]:[port]/databasename"</connection-url>
      
      Please see http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0512kokkat/
      or the DB2 JDBC application developers manual.
    -->  
    
    <driver-class>com.ibm.db2.jcc.DB2Driver</driver-class>
    <user-name>Mydb2username</user-name>
    Password
    <min-pool-size>0</min-pool-size>
    
    <!-- New org.jboss.resource.adapter.jdbc.vendor.DB2ExceptionSorter
    
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.DB2ExceptionSorter</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 
    <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
    -->

  <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
 
     
      
         <type-mapping>DB2</type-mapping>
      
  </local-tx-datasource>



----------------------------------------------------------

and I want to check for the deployment...I have deploy.ear folder in the server/default/deploy/ which has ear(jar+war). 

1. shall I place one jsp file in ear and restart the server ?and I should get   it wen I give the appropriate url. Is it how I should check for the deployment..?

2. changes in the db2.ds.xml are enough to connect to db2 database
or any other changes have to be done..?

Peter...Please help...

View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4244469#4244469

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4244469