DB2, SQLState: 56038, Error Code -4743, -4700

Functions that this release of DB2 introduces cannot be used before new function mode has been enabled. An attempt was made to execute one of these functions. In addition, support for extending the length of a VARCHAR (supported in V7) is restricted in V8 until new function mode has been enabled.


This error you might get when your project was compiled, configured and deployed using webshpere version 7 and you are trying to compile and deploy in websphere 8.5

To solve the issue, create and map new jdbc connection from ear deployment descriptor.

Ear project->Deployment descriptor->deployment tab-> remove all the existing jdbc configuration and configure the jdbc and jndi mapping again with DB2.

A Resource reference binding could not be found for the jdbc/mydb resource CWNEN0044E

You need to add the binding in ibm-web-bnd.xml:

<resource-ref name="jdbc/mydb" binding-name="jdbc/jndi" />

jdbc/jndi: You will configure jndi in websphere admin console,
Reference name: resource-ref name should match with res-ref-name

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

You should also make sure that <web-app version of web.xml file should be 2.5 or up and use schema not dtd. If you use older version of J2EE you have to use ibm-web-bnd.xmi file instead of xml.