Joydeep Bhattacharjee

Hello I am having some problem while running this . I am getting the following exception . I am trying out the following example CrudRepository for Spring Data, and I face the following


Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'helloCntrl': Unsatisfied dependency expressed through field 'test'; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifying bean of type 'com.joydeep.springboot.Test1' available: expected at least 1 bean which qualifies as autowire candidate. Dependency annotations:{@org.springframework.beans.factory.annotation.Autowired(required=true)}


  package com.joydeep.springboot;        import org.springframework.data.repository.CrudRepository;        import com.joydeep.springboot.vo.Message;        public interface Test1 extends CrudRepository<Message, String> { }  

package com.joydeep.springboot.vo; import java.util.Date; import javax.persistence.Entity; import javax.persistence.Id; @Entity public class Message {    @Id    private String id;    private String text;    private String author;    private Date created;    public Message() {        super();        // TODO Auto-generated constructor stub    }    public Message(String id, String text, String author, Date created) {        super();        this.id = id;        this.text = text;        this.author = author;        this.created = created;    }    public String getId() {        return id;    }    public void setId(String id) {        this.id = id;    }    public String getText() {        return text;    }    public void setText(String text) {        this.text = text;    }    public String getAuthor() {        return author;    }    public void setAuthor(String author) {        this.author = author;    }    public Date getCreated() {        return created;    }    public void setCreated(Date created) {        this.created = created;    }    }

       package com.joydeep.springboot;        import org.springframework.beans.factory.annotation.Autowired;        import org.springframework.web.bind.annotation.RequestMapping;        import org.springframework.web.bind.annotation.RestController;          @RestController public class HelloCntrl {             @Autowired Test1 test;             @RequestMapping("/hello") public String sayHi(){ return "Hi"; }         }


       package com.joydeep.springboot;         import org.springframework.boot.SpringApplication;         import org.springframework.boot.autoconfigure.SpringBootApplication;         @SpringBootApplication         public class CourseAPIStarter {              public static void main(String[] args) {                   // TODO Auto-generated method stub                                  SpringApplication.run(CourseAPIStarter.class); }         }

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>io.springboot</groupId> <artifactId>rest-course-api</artifactId> <version>0.0.1-SNAPSHOT</version> <name>Rest service course API</name> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>1.4.2.RELEASE</version> </parent> <properties> <java.version>1.8</java.version> </properties> <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-jpa</artifactId> </dependency> <!-- dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> </dependency --> <dependency> <groupId>org.apache.derby</groupId> <artifactId>derby</artifactId> <scope>runtime</scope> </dependency> </dependencies> </project>

Hi All,
I am getting a very unusual exception in my production servers.

Production Server Details:
OS- Red Hat Enterprise Linux Server release 6.3 (Santiago)
JBOSS Server - jboss-5.0.1.GA
JBOSS Memory Settings - -Xms1536m -Xmx1536m -XX:PermSize=512m -XX:MaxPermSize=512m -XX:NewSize=512m -XX:MaxNewSize=512m -XX:SurvivorRatio=32
Application - Struts 1.2 web application

Problem Details - Sometimes (Sporadically) the web application gets hanged and gives a very bizarre exception when submitting orders as follows
2012-11-27 17:05:01,482 ERROR [jsp.nested.orderProcessing.OrderProcessingController] (Thread-519) -1 2012-11-27 17:05:01,482 ERROR [jsp.nested.orderProcessing.OrderProcessingController] (Thread-519) ************************ 2012-11-27 17:05:01,482 ERROR [com.teliasonera.paha.util.queue.WorkQueue] (Thread-519) Execute failed for jsp.nested.orderProcessing.OrderProcessingController$OrderProcessingTask@5d367cc3 java.lang.IllegalStateException: getRequest was called outside of a valid context. at org.apache.beehive.netui.pageflow.FlowController.getRequest(FlowController.java:925) at jsp.nested.orderProcessing.OrderProcessingController.access$100(OrderProcessingController.java:24) at jsp.nested.orderProcessing.OrderProcessingController$OrderProcessingTask.execute(OrderProcessingController.java:199) at com.teliasonera.paha.util.queue.WorkQueue$1.run(WorkQueue.java:124) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:756) at java.lang.Thread.run(Thread.java:662) 2012-11-27 17:05:01,482 ERROR [com.teliasonera.paha.util.queue.WorkQueue] (Thread-519) java.lang.IllegalStateException: getRequest was called outside of a valid context. at org.apache.beehive.netui.pageflow.FlowController.getRequest(FlowController.java:925) at jsp.nested.orderProcessing.OrderProcessingController.access$100(OrderProcessingController.java:24) at jsp.nested.orderProcessing.OrderProcessingController$OrderProcessingTask.execute(OrderProcessingController.java:199) at com.teliasonera.paha.util.queue.WorkQueue$1.run(WorkQueue.java:124) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:756) at java.lang.Thread.run(Thread.java:662) 2012-11-27 17:05:01,482 ERROR [STDERR] (Thread-519) Exception in thread "Thread-519" 2012-11-27 17:05:01,482 ERROR [STDERR] (Thread-519) java.lang.RuntimeException: getRequest was called outside of a valid context. 2012-11-27 17:05:01,482 ERROR [STDERR] (Thread-519) at com.teliasonera.paha.util.queue.WorkQueue$1.run(WorkQueue.java:133) 2012-11-27 17:05:01,482 ERROR [STDERR] (Thread-519) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:756) 2012-11-27 17:05:01,482 ERROR [STDERR] (Thread-519) at java.lang.Thread.run(Thread.java:662) 2012-11-27 17:05:08,126 INFO [org.apache.beehive.netui.pageflow.PageFlowRequestProcessor] (http-0.0.0.0-29602-157) Attempting to instantiate SharedFlowControllers for request /internet2/jsp/frontpage/begin.do.
The relevant Classes where the exception is thorown are as follows
OrderProcessingController
public class OrderProcessingController extends PageFlowController { private transient WorkQueue queue; /** * @common:control */ @Control() public com.teliasonera.paha.integration.jcs.ServicesManagerJcs servicesManager; private static final Logger logger = Logger.getLogger(OrderProcessingController.class); /** * This method represents the point of entry into the pageflow * @jpf:action * @jpf:forward name="success" path="orderProcessing.jsp" */ @Jpf.Action(forwards = { @Jpf.Forward(name = "success", path = "orderProcessing.jsp") }) protected Forward begin() throws TechnicalException, JspException { Cookie[] cookies = this.getRequest().getCookies(); for(int i = 0 ;i<cookies.length ;i++) { logger.error("************************"); logger.error(cookies[i].getDomain()); logger.error(cookies[i].getName()); logger.error(cookies[i].getPath()); logger.error(cookies[i].getValue()); logger.error(cookies[i].getMaxAge()); logger.error("************************"); } SessionContext sc = SessionContext.getInstance(this.getRequest()); PahaTask task = sc.getTask(); // check that there are no concurrent orders if ((task == null) || task.isPending()) { if (!(sc.getPrimaryCustomer().getPendingOrders() || sc.getProcessStatus() == SessionContext.PROCESS_STATUS_ORDER_IN_PROGRESS)) { sc.getPrimaryCustomer().setPendingOrders(true); } else { // Concurrent orders, return right away. This is buzzling that // the return value is "success" in this case, but actually the // execution should never come here anyway. return new Forward("success"); } } try { queue = WorkQueue.getInstance(); sc.setProcessStatus(SessionContext.PROCESS_STATUS_ORDER_IN_PROGRESS); this.queue.execute(new OrderProcessingTask(this.getRequest()) ); } catch (Exception e) { sc.setProcessStatus(SessionContext.PROCESS_STATUS_ERROR); throw new TechnicalException("Exception", e); } return new Forward("success"); } /** * @jpf:action * @jpf:forward name="continue" path="orderProcessing.jsp" * @jpf:forward name="exit" return-action="orderProcessingDone" * @jpf:forward name="errorPage" path="/jsp/errorFlow/index.jsp" */ @Jpf.Action(forwards = { @Jpf.Forward(name = "continue", path = "orderProcessing.jsp"), @Jpf.Forward(name = "exit", returnAction = "orderProcessingDone"), @Jpf.Forward(name = "errorPage", path = "/jsp/errorFlow/index.jsp") }) public Forward checkStatus() throws TechnicalException, JspException { int status = SessionContext.getInstance(this.getRequest()).getProcessStatus(); if (status == SessionContext.PROCESS_STATUS_FINISHED) { return new Forward("exit"); } else if (status == SessionContext.PROCESS_STATUS_ERROR) { Forward f = new Forward("errorPage"); f.addActionOutput("exception", new JspException("Error processing order")); return f; } else if (status == SessionContext.PROCESS_STATUS_ORDER_IN_PROGRESS) { return new Forward("continue"); } throw new JspException("Unknown process status: " + status); } /** * @jpf:action * @jpf:forward name="exit" return-action="orderProcessingDone" */ @Jpf.Action( forwards = { @Jpf.Forward(name = "exit", returnAction = "orderProcessingDone") } ) public Forward orderProcessingDone() { return new Forward("exit"); } private class OrderProcessingTask implements Executable { private HttpServletRequest req; public OrderProcessingTask( HttpServletRequest r ) throws TechnicalException{ this.req = r; Cookie[] cookies = this.req.getCookies(); logger.error("In OrderProcessingTask->constr"); for(int i = 0 ;i<cookies.length ;i++) { logger.error("************************"); logger.error(cookies[i].getDomain()); logger.error(cookies[i].getName()); logger.error(cookies[i].getPath()); logger.error(cookies[i].getValue()); logger.error(cookies[i].getMaxAge()); logger.error("************************"); } } /** Executes the operation. Unlike {@link Runnable#run()}, this method may * throw any exception. * */ [b] public void execute() throws TechnicalException { [/b] Cookie[] cookies = this.req.getCookies(); logger.error("In OrderProcessingTask->execute"); for(int i = 0 ;i<cookies.length ;i++) { logger.error("************************"); logger.error(cookies[i].getDomain()); logger.error(cookies[i].getName()); logger.error(cookies[i].getPath()); logger.error(cookies[i].getValue()); logger.error(cookies[i].getMaxAge()); logger.error("************************"); } HttpSession sess = getRequest().getSession(false); logger.error("session here:"+sess); Cookie[] cookies1 = getRequest().getCookies(); for(int i = 0 ;i<cookies1.length ;i++) { logger.error("************************"); logger.error(cookies1[i].getDomain()); logger.error(cookies1[i].getName()); logger.error(cookies1[i].getPath()); logger.error(cookies1[i].getValue()); logger.error(cookies1[i].getMaxAge()); logger.error("************************"); } SessionContext sc = SessionContext.getInstance(this.req); boolean success = false; try { PahaTask task = sc.getTask(); if(task != null) { success = task.execute(sc); sc.setTask(null); } else{ success = servicesManager.processOrders(sc); } } catch(SocketTimeoutException ste) { // Ignore timeouts. This is HTTP 1.0 vs. Apache proxy bug. success = true; // Must be until PaHa uses HTTP 1.1 ... } catch (Exception e) { //logger.debug("Setting session context process status to error",psfCtxt,null); sc.setProcessStatus(SessionContext.PROCESS_STATUS_ERROR); return; } if (success) { sc.setProcessStatus(SessionContext.PROCESS_STATUS_FINISHED); } else { sc.setProcessStatus(SessionContext.PROCESS_STATUS_UNDEFINED); } return; } } }
WorkQueue

public class WorkQueue implements Executor, Serializable { /** * Singleton instance. */ private static WorkQueue instance; /** * Takes care of actually executing the tasks. */ private PooledExecutor executor; /** * Number of operations waiting for execution. */ private int tasksWaiting; /** * Creates a new instance of WorkQueue with the default settings * (minThreads = 1, maxThreads = 10, maxQueueSize = 128). */ public WorkQueue() { this( 1, 10, 128 ); } /** * Creates a new instance of WorkQueue with the specified settings. * * @param minThreads Minimum number of threads used for executing the tasks. * @param maxThreads Maximum number of threads that may be created for * executing the tasks. * @param maxQueueSize Maximum number of operations that may be queued * before creating a new thread. */ public WorkQueue( int minThreads, int maxThreads, int maxQueueSize ) { BoundedBuffer channel = new BoundedBuffer(maxQueueSize); this.executor = new PooledExecutor( channel, maxThreads ); this.executor.setMinimumPoolSize(minThreads); } /** * Executes the specified task. * * @param task The task to be executed. * @param listener The error listener. */ public void execute( Executable task ) { try { tasksWaiting++; this.executor.execute( getRunnable(task) ); } catch (InterruptedException ie) { } } /** * Returns the approximate number of tasks currently waiting for execution. * This is only a snapshot value that may change immediately after returning. */ public int size() { return this.tasksWaiting; } /** * Reports an error to the associated ErrorListener, if any. */ protected void handleError( Throwable t ) { } /** * Returns a new Runnable for executing the task. */ private Runnable getRunnable( final Executable task ) { return new Runnable() { public void run() { try { task.execute(); } catch (Exception e) { } finally { tasksWaiting--; } } }; } }

Any help in this regard would be highly appreciated.Thanks in advance.

Best Regards,
Joydeep

Hi Ivan,
I downloaded Exam-Objectives-SCDJWS5.pdf for the Oracle Certified Professional, Java EE 5 Web Services exam. I was going through the excellent note that you have put together , however I think I have noticed one printing mistake may be, on page 15 (XML Schemas). In this page you have explained the use of elementFormDefault . The first portion explains it's use when elementFormDefault is set to qualified . However I guess in the second portion you have tried to explain when elementFormDefault is set to unqualified, here I guess the printing mistake happened , it is printed as qualified instead of unqualified. Please can you clarify if I am correct.

Hi Ivan,
I downloaded Exam-Objectives-SCDJWS5.pdf for the Oracle Certified Professional, Java EE 5 Web Services exam. I was going through the excellent note that you have put together , however I think I have noticed one printing mistake may be, on page 15 (XML Schemas). In this page you have explained the use of elementFormDefault . The first portion explains it's use when elementFormDefault is set to qualified . However I guess in the second portion you have tried to explain when elementFormDefault is set to unqualified, here I guess the printing mistake happened , it is printed as qualified instead of unqualified. Please can you clarify if I am correct.

Hi Ivan,
I downloaded Exam-Objectives-SCDJWS5.pdf for the Oracle Certified Professional, Java EE 5 Web Services exam. I was going through the excellent note that you have put together , however I think I have noticed one printing mistake may be, on page 15 (XML Schemas). In this page you have explained the use of elementFormDefault . The first portion explais it's use when elementFormDefault is set to qualified . However I guess in the second portion you have tried to explain when elementFormDefault is set to unqualified, here I guess the printing mistake happened , it is printed as qualified instead of unqualified. Please can you clarify if I am correct.

Thanks for your explanation , it was helpful indeed . But there seems to be some restriction on the length of name createDescriptor(String name, java.sql.Connection conn). It seems maximum allowed length is 30 . When I use the fully qualified name which has length 41 I get the following exception ...

xception in thread "main" java.sql.SQLException: ORA-01948: identifier's name length (41) exceeds maximum (30)
ORA-06512: at "SYS.DBMS_PICKLER", line 18
ORA-06512: at "SYS.DBMS_PICKLER", line 58
ORA-06512: at line 1

However I think we will create SQL types as you have suggested and try to access it .

Can you please tell where the package should be defined , is it that it can be accessed if it is under the schema and not in any packages



I have used the fully qualified name of the type in Java APPS.HZ_CUSTOMER_ACCOUNTS_PUB.account_rec_type but the exception occours.

Exception in thread "main" java.sql.SQLException: ORA-01948: identifier's name length (41) exceeds maximum (30)
ORA-06512: at "SYS.DBMS_PICKLER", line 18
ORA-06512: at "SYS.DBMS_PICKLER", line 58
ORA-06512: at line 1

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:184)
at oracle.jdbc.driver.T4CCallableStatement.execute_for_rows(T4CCallableStatement.java:873)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1086)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2984)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3076)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4273)
at oracle.jdbc.oracore.OracleTypeADT.initMetadata(OracleTypeADT.java:404)
at oracle.jdbc.oracore.OracleTypeADT.init(OracleTypeADT.java:327)
at oracle.sql.StructDescriptor.initPickler(StructDescriptor.java:206)
at oracle.sql.StructDescriptor.<init>(StructDescriptor.java:179)
at oracle.sql.StructDescriptor.createDescriptor(StructDescriptor.java:142)
at com.teliasonera.fi.ebshla.cust.impl.StoreHzCommand.main(StoreHzCommand.java:250)


We have only one schema and I am sure that there is only one Type defined with account_rec_type.

I have to call a stored procedure in oracle from java for which some of the parameters are oracle custom objects.

The stored procedure :-

procedure update_account( p_api_version IN NUMBER, p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE, p_commit IN VARCHAR2 :=FND_API.G_FALSE, p_account_rec IN ACCOUNT_REC_TYPE, p_acct_last_update_date IN OUT DATE, p_prof_last_update_date IN OUT DATE, x_return_status OUT VARCHAR2, x_msg_count OUT NUMBER, x_msg_data OUT VARCHAR2, p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL );
where p_account_rec is a oracle custom type ACCOUNT_REC_TYPE


ACCOUNT_REC_TYPE is defined in package HZ_CUSTOMER_ACCOUNTS_PUB as

TYPE account_rec_type IS RECORD ( cust_account_id NUMBER := FND_API.G_MISS_NUM, account_number VARCHAR2(30) := FND_API.G_MISS_CHAR, wh_update_date DATE := FND_API.G_MISS_DATE, attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR, attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR, attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR, attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR, attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR, npa_number VARCHAR2(60) := FND_API.G_MISS_CHAR, pin_number NUMBER := FND_API.G_MISS_NUM, suspension_date DATE := FND_API.G_MISS_DATE, ... under_return_tolerance NUMBER := FND_API.G_MISS_NUM, item_cross_ref_pref VARCHAR2(30) := FND_API.G_MISS_CHAR, ship_sets_include_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR, arrivalsets_include_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR, sched_date_push_flag VARCHAR2(1) := FND_API.G_MISS_CHAR, invoice_quantity_rule VARCHAR2(30) := FND_API.G_MISS_CHAR, pricing_event VARCHAR2(30) := FND_API.G_MISS_CHAR, account_replication_key NUMBER := FND_API.G_MISS_NUM, status_update_date DATE := FND_API.G_MISS_DATE, autopay_flag VARCHAR2(1) := FND_API.G_MISS_CHAR, notify_flag VARCHAR2(1) := FND_API.G_MISS_CHAR, last_batch_id NUMBER := FND_API.G_MISS_NUM );

Now the java code for calling the stored procedure :


EbsDataSource ds = new EbsDataSource(); Properties dbProps = new Properties(); dbProps.load(StoreHzCommand.class.getResourceAsStream("db.properties")); Parameters param = Parameters.fromProperties(dbProps); ds.parameterize(param); OracleConnection conn = (OracleConnection) ds.getConnection(); conn.setAutoCommit(false); HzCustomerProfileV2Pub.CustomerProfileRec profile = null; CallableStatement updtStmt = conn.prepareCall("{call HZ_CUSTOMER_ACCOUNTS_PUB.update_account ( "+API_VERSION+ ", FND_API.G_FALSE, FND_API.G_TRUE, ?, ?,?,?,?,?,FND_API.G_VALID_LEVEL_FULL)}"); //acctRec.payment_term_id [b]StructDescriptor structdesc = StructDescriptor.createDescriptor ("HZ_CUSTOMER_ACCOUNTS_PUB.account_rec_type".toUpperCase(), conn);[/b] --> This gives an exception


Exception in thread "main" java.sql.SQLException: invalid name pattern: HZ_CUSTOMER_ACCOUNTS_PUB.ACCOUNT_REC_TYPE
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
at oracle.jdbc.oracore.OracleTypeADT.initMetadata(OracleTypeADT.java:412)
at oracle.jdbc.oracore.OracleTypeADT.init(OracleTypeADT.java:327)
at oracle.sql.StructDescriptor.initPickler(StructDescriptor.java:206)
at oracle.sql.StructDescriptor.<init>(StructDescriptor.java:179)
at oracle.sql.StructDescriptor.createDescriptor(StructDescriptor.java:142)
at com.teliasonera.fi.ebshla.cust.impl.StoreHzCommand.main(StoreHzCommand.java:250)







Please can you suggest where I am going wrong ...