[jboss-user] [Installation, Configuration & DEPLOYMENT] - Re: Unauthenticated caller null N sqlException
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#...
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...