Versha Agarwal

Ranch Hand

+ Follow

news 43 Posts 11 Threads

since Oct 14, 2011

Merit badge: grant badges

For More

Cows and Likes

Cows

Total received

In last 30 days

Forums and Threads

Recent posts by Versha Agarwal

upgrade to Struts 6.3 or 6.6

It's been a long time since I developed a project with Struts 1.1. But due to some reason I want my project migrate to struts 6.3 or 6.6.
Is it feasible?
Should I choose some other plateform? Please suggest me.

5 months ago

Struts

Struts 1.1 Index properties: Not getting all values after page submit

My Environment is:
oracle Export: Release 11.2.0.1.0
Apache Tomcat/8.0.37
Struts 1.1
Java 1.8
JDBC driver version is 10.1.0.2.0

I am using indexed properties.When I submit the JSP page
I do not get all fields values. For few fields values are submitted but for few field it shows zero or blank in Action class after form is submitted.
Everything in code seems fine.

PcProForm.java
public class PcProForm extends ActionForm implements Serializable
{
private static final long serialVersionUID = 7936383401034076756L;
private ArrayList <PcProDTO> pcProDtl ;
public ArrayList<PcProDTO> getPcProDtl() {
return pcProDtl;
}
public void setPcProDtl(ArrayList<PcProDTO> pcProDtl) {
this.pcProDtl = pcProDtl;
}
public PcProDTO getPcProDtl(int index)
{
// make sure that pcProDtl is not null
if(this.pcProDtl == null)
{
this.pcProDtl = new ArrayList <PcProDTO> ();
}
// indexes do not come in order, populate empty spots
while(index >= this.pcProDtl.size())
{
this.pcProDtl.add(new PcProDTO());
}
// return the requested item
return (PcProDTO) pcProDtl.get(index);
}
public void setPcProDTO(int index, PcProDTO objPcPro)
{
if (index <  pcProDtl.size()){
pcProDtl.set(index, objPcPro);
} else {
pcProDtl.add(objPcPro);
}
}
public PcProDTO get (int index)
{
while (index >= pcProDtl.size()){
pcProDtl.add(new PcProDTO());
}
return (PcProDTO) pcProDtl.get(index);
}
public PcProDTO getPcProDTO(int index){
while(pcProDtl.size() <= index){
pcProDtl.add(new PcProDTO());
}
return (PcProDTO) pcProDtl.get(index);
}
}
PcProHdrDTO.java
public class PcProHdrDTO implements Serializable {
private static final long serialVersionUID = 3257722870804559459L;
private ArrayList <PcProDTO> pcProDtl ;//
public ArrayList<PcProDTO> getPcProDtl() {
return pcProDtl;
}
public void setPcProDtl(ArrayList<PcProDTO> pcProDtl) {
this.pcProDtl = pcProDtl;
}
public PcProDTO getPcProDtl(int index) {
// make sure that pcProDtl list is not null
if(this.pcProDtl == null)
{
this.pcProDtl = new ArrayList <PcProDTO> ();
}
// indexes do not come in order, populate empty spots
while(index >= this.pcProDtl.size())
{
this.pcProDtl.add(new PcProDTO());
}
// return the requested item
return (PcProDTO) pcProDtl.get(index);
}
public void setPcProDtlDTO(int index, PcProDTO objPcPro) {
if (index <  pcProDtl.size()){
pcProDtl.set(index, objPcPro);
} else {
pcProDtl.add(objPcPro);
}
}
public PcProDTO getPcProDtlLst(int index) {
// make sure that pkingCntrctrDtl is not null
if(this.pcProDtl == null) {
this.pcProDtl = new ArrayList <PcProDTO> ();
}
// indexes do not come in order, populate empty spots
while(index >= this.pcProDtl.size()){
this.pcProDtl.add(new PcProDTO());
}
// return the requested item
return (PcProDTO) pcProDtl.get(index);
}
public void populatePcProDtlLst(ArrayList  <PcProDTO> items) {        
this.pcProDtl.addAll(items);    
}
}
PcProDTO.java
public class PcProDTO implements Serializable {  //CctrPms CntrctrProMfgStgChrgForm //
private static final long serialVersionUID = 3156722870804559466L;
private int itmGrpId;
private String itmGrpNm;
private int manPower;
private float strRate1;
private float proAmt;
private float totCtnWt
// more fields and getter & setter mehods
}

pcProEntry.jsp
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN" "http://www.w3.org/TR/html4/frameset.dtd">
<%@ page contentType="text/html;charset=UTF-8" language="java"%>
<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html"%>
<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean"%>
<%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic"%>
<%@ taglib uri="/WEB-INF/struts-nested.tld" prefix="nested"%>
<body >
<html:form name="PcProForm" method="post" styleId="PcProForm" type="com.mmm.form.PcProForm" action="addPcProEntry.do?method=addPcProEntry">
<table>
<logic:present name="PcProForm" property="pcProDtl" >
<logic:empty name="PcProForm" property="pcProDtl" >
<tr>
<td  >NO data found</td> </tr>
</logic:empty>
<logic:notEmpty  name="PcProForm" property="pcProDtl"  >
<thead>
<TR >
<th  >Item group Id</th>
<th  >Item group name</th>
<th  >Total Ctn</th>
<th >Manpower</th>
<th  >Total Ctn Wt</th>
<th  >Paking rate</th>
<th  >Amount</th>
</TR> </thead>
<tbody>
<logic:iterate id="pcProDtl"  name="PcProForm" property="pcProDtl" type="com.mmm.dto.PcProDTO" indexId="index" scope="session" >
<TR>
<td >
<html:text name="pcProDtl"  property="itmGrpId"    indexed="true" />
<html:text name="pcProDtl" property="itmGrpNm"   indexed="true" />
</td>
<td >
<html:text name="pcProDtl"  property="totCtn"   indexed="true" />
</td>
<td >
<html:text name="pcProDtl"  property="manPower"       indexed="true" />
</td>
<td >
<html:text name="pcProDtl"  property="totCtnWt"     indexed="true" />
</td>
<td >
<html:text name="pcProDtl"  property="strRate1"      indexed="true" />
</td>
<td >
<html:text name="pcProDtl"  property="proAmt"      indexed="true" />
</td>
</TR>
</logic:iterate>
</tbody>
</logic:notEmpty>
</logic:present>
</table>
</html:form>
</body>
</html>

5 years ago

Struts

java.sql.SQLException: Not a wrapper of oracle.jdbc.driver.OracleConnection

trying to use OracleConnection.createOracleArray()

6 years ago

Other JSE/JEE APIs

java.sql.SQLException: Not a wrapper of oracle.jdbc.driver.OracleConnection

Finally Removing 'classes12.jar' from classpathh solved the issue.
But now ArrayDescriptor.createDescriptor () is deprecated. I have to struggle with that.
Thank You all for your support.

6 years ago

Other JSE/JEE APIs

java.sql.SQLException: Not a wrapper of oracle.jdbc.driver.OracleConnection

Still I am trying ....

6 years ago

Other JSE/JEE APIs

java.sql.SQLException: Not a wrapper of oracle.jdbc.driver.OracleConnection

I understand your view. But it is difficult to change ConnectionPooler class at the moment.
and the solution given again require to convert

'OracleConnection spConn' from 'Connection conn'
(
)

So the problem remains same.

6 years ago

Other JSE/JEE APIs

java.sql.SQLException: Not a wrapper of oracle.jdbc.driver.OracleConnection

At this line it gives exception 'java.lang.ClassCastException: com.sun.proxy.$Proxy9 cannot be cast to oracle.jdbc.OracleConnection' that means OracleConnection is needed

and when I inspect

it returns
oracle.jdbc.driver.T4CConnection@12299890

and
prototype and explanation of unwrap is :

unwrap(Class <T> iface): T - Wrapper

Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.
If the receiver implements the interface then the result is the receiver or a proxy fo
eceiver. If the receiver is a wrapper and the wrapped object implements the interface then the result is the wrapped object or a proxy for the wrapped object.
Otherwise return the the result of calling unwrap recursively on the wrapped object or a proxy for that result.
If the receiver is not a wrapper and does not implement the interface, then an SQLException is thrown.
Parameters:<T> the type of the class modeled by this Class objectiface A Class defining an interface that the result must implement
.Returns:an object that implements the interface. May be a proxy for the actual implementing object.Throws:java.sql.SQLException - If no object found that implements the interfaceSince:1.6

6 years ago

Other JSE/JEE APIs

java.sql.SQLException: Not a wrapper of oracle.jdbc.driver.OracleConnection

Here is code for ConnectionPooler.java

/*Title: Connection Pooling
* Description:
* This process is used to provide connection pooling mechanism
* in the database.
*/
package com.hris.so;
import java.sql.Connection;
import java.sql.SQLException;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
import org.apache.log4j.Logger;
import com.hris.common.AppLogger;
import com.hris.common.Constants;
/**
* ConnectionPooler will initially create some dbconnections,which will be used
* for processing requests. incase more than certain request are to be processed
* than another pool of new connections will be created and allocated to the new
* incoming requests.The size of data-base connection Pool will increase and
* decrease as per the number of requests.
*
*/
public final class ConnectionPooler extends Object {
private static ConnectionPooler connectionPoolerObj = null; //Object of
// ConnectionPooler
// class
//private static Logger logger = null; //Logger for class logs
private static Context initContext ; // InitialContext
private static Context envContext; //Context
private static DataSource ds; // DataSource
private static Logger logger =  null; //Object for logger
/**
* ConnectionPooler() is a Default constructor of the class which
* create a DataSource
*
* @exception :Exception
*/
private ConnectionPooler() throws Exception {
logger = AppLogger.getLogger();
logger.debug("ConnectionPooler - Constructor Starts");
try {
initContext = new InitialContext();
envContext  = (Context)initContext.lookup("java:/comp/env");
//Create the Datasource
ds = (DataSource)envContext.lookup(Constants.DB_RESOURCE_NAME);
logger.debug("ConnectionPooler - Constructor DataSource Created");
} catch (Exception e) {
e.printStackTrace();
logger.fatal("ConnectionPooler - Constructor Exception raised. Message = "+ e.getMessage());
throw e;
}
logger.debug("ConnectionPooler - Constructor End");
}//End of Constructor
/**
* getInstance() This method creates an instance of ConnectionPooler class
*
* @parameter :None
* @return ConnectionPooler Connection Pooler object
* @exception :
*  Exception
*/
public static ConnectionPooler getInstance() throws Exception {
//Create Logger
logger = AppLogger.getLogger();
logger.debug("ConnectionPooler - getInstance Starts");
//Check the ConnectionPooler object
if (connectionPoolerObj == null) {
//Create New object
connectionPoolerObj = new ConnectionPooler();
}
logger.debug("ConnectionPooler - getInstance End");
//Return the Connection pooler object
return connectionPoolerObj;
}//End of getInstance method
/**
* getConnection() This method returns the existing java.sql.Connection
* connection <b>Note : </b> Never nullify & close the Connection objects
* retrieved from this method, At the time of method end, Connection Objects
* should be returned back to the Pool class by implementing method <br>
* <u>returnConnection(java.sql.Connection dbConnectionReturn) </u>.
*
* @return java.sql.Connection Connection Object
*/
public synchronized Connection getConnection() {
logger.debug("ConnectionPooler - getConnection Starts");
Connection conn = null;
try{
conn = ds.getConnection();
} catch (SQLException e) {
e.printStackTrace();
logger.fatal("ConnectionPooler - getConnection Exception Raised. Message = "+ e.getMessage());
logger.debug("ConnectionPooler - getConnection NULL returned. Method End");
return null;
}
logger.debug("ConnectionPooler - getConnection Ends");
//return the connection to the requesting user
return conn;
}//End of getConnection method
/**
* getConnectionWithTransaction() This returns the existing
* java.sql.Connection connection by starting the transaction <b>Note : </b>
* Never nullify & close the Connection objects retrieved from this method,
* At the time of method end, Connection Objects should be returned back to
* the Pool class by implementing method <br>
* <u>returnConnectionWithTransaction(java.sql.Connection
* dbConnectionReturn) </u>.
*
* @return java.sql.Connection Connection Object
*/
public synchronized Connection getConnectionWithTransaction() {
logger.debug("ConnectionPooler - getConnectionWithTransaction Starts");
Connection conn = null;
try {
conn = ds.getConnection();
//Set AutoCommit for the connection to false
conn.setAutoCommit(false);
logger.debug("ConnectionPooler - getConnectionWithTransaction End");
return conn;
} catch (SQLException e) {
logger.fatal("ConnectionPooler - getConnectionWithTransaction Exception Raised. Message = "
+ e.getMessage());
}
logger.debug("ConnectionPooler - getConnectionWithTransaction Ends");
//return the connection to the requesting user
return conn;
}//End of getConnectionWithTransaction method
/**
* returnConnection() All the data base connections retieved from
* getConnection() method should always be returned back by calling this
* returnConnection() method.
*
* @parameter java.sql.Connection Connection Object
* @return void
*/
public synchronized void returnConnection(Connection cnReturned) {
logger.debug("ConnectionPooler - returnConnection Starts");
try {
cnReturned.close();
} catch (Exception e) {
logger.fatal("ConnectionPooler - returnConnection Exception Raised. Message = "
+ e.getMessage());
}
logger.debug("ConnectionPooler - returnConnection End");
}//End of returnConnection method
/**
* returnConnectionWithTransaction() All the data base connections retieved
* from getConnectionWithTransaction() method should always be returned back
* by calling this returnConnectionWithTransaction() method.
*
* @param java.sql.Connection
*            Connection Object
* @param isException
*            boolean value true in case of exception else false
* @return void
*/
public synchronized void returnConnectionWithTransaction(
Connection cnReturned, boolean isException) {
logger.debug("ConnectionPooler - returnConnectionWithTransaction Starts");
try {
if (isException) {
//roll back any incomplete transactions if done
//by this connection
cnReturned.rollback();
} else {
//If no excepton then commit the transaction
cnReturned.commit();
}
//Set AutoCommit for the connection to true
cnReturned.setAutoCommit(true);
cnReturned.close();
} catch (Exception e) {
logger.fatal("ConnectionPooler - returnConnectionWithTransaction Exception Raised. Message = "
+ e.getMessage());
}
logger.debug("ConnectionPooler - returnConnectionWithTransaction End");
}//End of returnConnectionWithTransaction method
} //End of ConnectionPooler class

6 years ago

Other JSE/JEE APIs

java.sql.SQLException: Not a wrapper of oracle.jdbc.driver.OracleConnection

When I use Connection conn from ConnectionPooler I get erroe nessage as below

and when I try to convert it to OracleConnection

it gives 'not a wrapper class'

I have tried with ojdbc7.jar & ojdbc8.jar in C:\Program Files\Apache Software Foundation\Tomcat 8.0\lib folder

6 years ago

Other JSE/JEE APIs

java.sql.SQLException: Not a wrapper of oracle.jdbc.driver.OracleConnection

I get same error message

6 years ago

Other JSE/JEE APIs

java.sql.SQLException: Not a wrapper of oracle.jdbc.driver.OracleConnection

Thank you all for quick reply. But I have already tried above solutions. Nothing worked

6 years ago

Other JSE/JEE APIs

java.sql.SQLException: Not a wrapper of oracle.jdbc.driver.OracleConnection

I am using ConnectionPooler.

6 years ago

Other JSE/JEE APIs

java.sql.SQLException: Not a wrapper of oracle.jdbc.driver.OracleConnection

This code works fine if I run it directly from public static void main() method using

Class.forName("oracle.jdbc.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:url ","DB","DB");

6 years ago

Other JSE/JEE APIs

java.sql.SQLException: Not a wrapper of oracle.jdbc.driver.OracleConnection

I want to send array of integer and retrieve array of sturct from Oracle Procedure.
but I get Error: "java.sql.SQLException: Not a wrapper of oracle.jdbc.driver.OracleConnection"
Environment is:
oracle Export: Release 11.2.0.1.0
Apache Tomcat/8.0.37
Struts 1.1
Java 1.8
JDBC driver version is 10.1.0.2.0
SERVER.XML
<Resource name="jdbc/db" auth="Container" type="oracle.jdbc.pool.OracleDataSource" accessToUnderlyingConnectionAllowed="true"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
username="USER" password="password" maxTotal="20" maxIdle="10" maxWaitMillis="-1"
driverClassName="oracle.jdbc.OracleDriver" url="URL" />
My Code is
public SalryHdrDTO getFacWrkingDays(SalryHdrDTO objSalryHdr ) throws HrisException{
this.logger.info(SalryDAO.class.getName() + " --->> getFacWrkingDays() Starts");
Connection conn = null;
try {
conn = this.connectionPoolerObj.getConnection(); //from JNDI
if (conn != null){

if (objSalryHdr != null){
int[] multiFacId = objSalryHdr.getMultiFacId();
final String typeName = "HRIS.FAC_OBJ"; //created in database
final String typeTableName = "HRIS.ARR_FAC_OBJ"; //created in database
OracleConnection oConn=null;
//if (conn.isWrapperFor(OracleConnection.class)) {
//ERROR : java.sql.SQLException: Not a wrapper of oracle.jdbc.driver.OracleConnection
// if I use "oracle.jdbc.OracleConnection.class" it gives compilation error
oConn = conn.unwrap(OracleConnection.class);
//}
ArrayDescriptor des = ArrayDescriptor.createDescriptor("HRIS.ARR_FAC_ID", oConn);
ARRAY arr_fac = new ARRAY(des,conn,multiFacId);

final StructDescriptor structDescriptor = StructDescriptor.createDescriptor(typeName.toUpperCase(), oConn);
final ResultSetMetaData metaData = structDescriptor.getMetaData();

CallableStatement st = conn.prepareCall("call HRIS.EMP_SAL_CALC.get_fac_wrking_days(?,?,?)");
// Passing an array to the procedure -
st.setArray(1, arr_fac);
st.registerOutParameter(2, Types.INTEGER);
st.registerOutParameter(3,Types.ARRAY,typeTableName);
st.execute();

System.out.println("size : "+st.getInt(2));
Object[] data = (Object[]) ((Array) st.getObject(3)).getArray();
for(Object tmp : data) {
Struct row = (Struct) tmp;
// Attributes are index 1 based...
int idx = 1;
for(Object attribute : row.getAttributes()) {
System.out.println(metaData.getColumnName(idx) + " = " + attribute);
++idx;
}
System.out.println("---");
}
st.close();
}
}
}
catch (Exception ex) {
this.logger.debug(SalryDAO.class.getName() + " getFacWrkingDays() Exception Raised --->> " + ex.getMessage());
throw new HrisException(ex.getMessage());
} finally {
this.connectionPoolerObj.returnConnection(conn);
}
this.logger.info(SalryDAO.class.getName() + " --->> getFacWrkingDays() Starts");
return objSalryHdr;
}

6 years ago

Other JSE/JEE APIs

memory leak

Versha Agarwal wrote:I have web application with following configuration;

Tomcat 8.0.37
Java "1.8.0_25"
Struts 1.1
oracle 11g

The web application [mmmPms] created a ThreadLocal with key of type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@4a3a56ec])
and a value of type [java.lang.Class] (value [class supLedgerDateWise_1477563207590_674836]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.

I already checked it for Connection, resultset, Preparedstatement

7 years ago

Other JSE/JEE APIs