Monday, October 1, 2012

Datasource configuration for DB2 in Jboss 7.1

 <datasource jta="true" jndi-name="java:jboss/datasources/DataSource" pool-name="DataSource" enabled="true" use-java-context="true" use-ccm="true">
                    <connection-url>url</connection-url>
                    <driver>db2jdbc</driver>
                    <pool>
                        <min-pool-size>10</min-pool-size>
                        <max-pool-size>100</max-pool-size>
                        <prefill>true</prefill>
                    </pool>
                    <security>
                        <user-name>user</user-name>
                        <password>pw</password>
                    </security>
                </datasource>
                <drivers>
                 
                    <driver name="db2jdbc" module="com.ibm.db2">
                        <driver-class>com.ibm.db2.jcc.DB2Driver</driver-class>
                        <xa-datasource-class>com.ibm.db2.jcc.DB2XADataSource</xa-datasource-class>
                    </driver>

 </drivers>


Create Folder Structure:jboss-as-7.1.1.Final\modules\com\ibm\db2\main
place Module,xml file and related jar files
<module xmlns="urn:jboss:module:1.1" name="com.ibm.db2">
<resources>
<resource-root path="db2jcc.jar"/>
<resource-root path="db2jcc_license_cu.jar"/>
</resources>
<dependencies>
<module name="javax.api"/>
<module name="javax.transaction.api"/>
<module name="javax.servlet.api" optional="true"/>
</dependencies>
</module>


and invoke from java code
..................................

InitialContext context = new InitialContext();
 DataSource dataSource = (DataSource) context.lookup("java:jboss/datasources/SampleDS");
Connection connection = dataSource.getConnection();

Default radio button & Dropdown values selected using spring mvc in jsp

<form:radiobutton path="rBusiness"
value='rnmName' id="rnmName" checked="checked"/>
<
form:select path="recordsPerPage"
>
<form:option value="10" label="10"/>
<form:option value="15" label="15"/>
<form:option value="20" label="20"/>
<form:option value="25" label="25" selected="selected"/>
<form:option value="30" label="30"/>
<form:option value="40" label="40"/>
<form:option value="50" label="50" /></form:select>