Win a copy of TDD for a Shopping Website LiveProject this week in the Testing forum!

Balachandran Vijayarajan

Greenhorn
+ Follow
since Jun 23, 2005
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
1
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Balachandran Vijayarajan

Hi All,


I am trying to call a oracle storeprocedure by passing object as parameter(tablename%rowtype) using spring template. When I am doing so, getting below exception

[code=DB]
Exception in thread "main" org.springframework.jdbc.BadSqlGrammarException: CallableStatementCallback; bad SQL grammar [{call group_selection_store1(?, ?)}]; nested exception is java.sql.SQLException: ORA-06550: line 1, column 7:

PLS-00306: wrong number or types of arguments in call to 'GROUP_SELECTION_STORE1'

ORA-06550: line 1, column 7:

PL/SQL: Statement ignored


[b]Storeprocedure[/b]
create or replace procedure group_store1(group_sel in group_selection%rowtype,

group_selection_out out group_selection.RENEWAL_ID%type

)

is

begin

insert into group_selection(RENEWAL_ID, CATEGORY )

values(group_sel.RENEWAL_ID, group_sel.CATEGORY )

returning RENEWAL_ID into group_selection_out;

end group_selection_store1;


[b]Table [/b]

CREATE TABLE "GROUP_SELECTION"

( "RENEWAL_ID" INTEGER NOT NULL ENABLE,

"CATEGORY" VARCHAR2(50) NOT NULL ENABLE,

PRIMARY KEY ("RENEWAL_ID") ENABLE

)

[b]Type[/b]

CREATE OR REPLACE TYPE "ITEMTYPE" AS OBJECT(id INTEGER, descr VARCHAR2(50))[/code]

[b]Code Snippet [/b]
[code=java]
declareParameter(new SqlParameter("group_sel", OracleTypes.STRUCT, "ITEMTYPE"));

declareParameter(new SqlOutParameter("group_selection_id_out", OracleTypes.NUMBER));

public Integer execute(final TestItem testItem) throws SQLException{

SqlTypeValue value = new AbstractSqlTypeValue() {



protected Object createTypeValue( Connection conn, int sqlType, String typeName) throws SQLException {

conn = DriverManager.getConnection("jdbc:oracle:thin:system/password-1@localhost:1521:instance");

StructDescriptor itemDescriptor = new StructDescriptor(typeName, conn);

Struct item = new STRUCT(itemDescriptor, conn,

new Object[] {

testItem.getId(),

testItem.getDescription(),



});

return item;

}

};

Map inParam = new HashMap(1);

inParam.put("group_sel", value);


Map outValues = execute(inParam);

return (Integer)outValues.get("group_selection_out");

}[/code]
Please let me know, where I am going wrong

Thanks
Bala


Hi All,

If any one is having model question for this exam, can you please share it with me. Thanks in advance.

Cheers,
Bala
------------------------------------
A rapidly growing retail company recently outsourced their package delivery to a very reputable package delivery company. The two companies are integrated using SOA and Web services. However, the retail company is having customer satisfaction issues as the call center is not reliably calculating delivery dates. Which portion of the SOA Foundation is the
focus to resolve this issue?

A. Information Services
B. Process Services
C. Partner Services
D. Interaction Services

I think Answer - Partner Services
---------------------------------------------------------------

Question:
Several design considerations have to be taken into account when designing services in an SOA. Which statement, as applied to those design considerations, is true?

A. Stateless implies that service operation parameters should be allied to the operation semantics.
B. Loose coupling implies that services should be designed using standardized interfaces and with the adoption of open standards.
C. Service granularity implies the service consumer does not hard-code the specific location of the service.
D. Encapsulation implies that services should hide the implementation details from their interface design.

I think Answer - B
--------------------------------------------------------

Question:
A mortgage loan provider currently has legacy applications utilized by a network of branches and franchised agents. They want to expand by adding a new channel to allow independent mortgage brokers to submit mortgage loan applications. They realize they must provide a differentiating offering to the independent mortgage brokers to attract participants and grow the new channel. How can SOA benefit their requirement?

A. By building an SOA with a secure connectivity layer, they could quickly enable the mortgage broker channel to use their applications without any changes to the legacy system.
B. They could reduce the cost to develop new applications needed for each independent broker by reusing services as integration code that is written for each broker's system to expedite development.
C. By service enabling the legacy applications and offering a Web-based portal for independent brokers, they can minimize
the impact to existing channels, minimize changes to existing code, and quickly create an offering for the new channel.
D. By implementing security and governance as part of an SOA deployment, they can control access to the current system to determine which brokers are using the system and personalize their marketing to the high usage brokers.

I think Answer A and D

If any one is having query regarding the answer, we can have a discussion.

Cheers,
Bala
Native service interface solution enables a core system (CICS) for SOA by using its features. So CICS exposed using Web Services.

This link might help you

http://www.ibm.com/developerworks/library/ar-datapow/index.html#IMS-SOAP-Gateway

Cheers,
Bala
All can be used for both "Asynchronous and Synchronous" Communication. Mainly used at the integration layer.
This class is not there in the classpath - org.asteriskjava.fastagi.AgiScript. make sure that class is there in the path before running the server.

Cheers,
Bala
13 years ago
Hi All,

From the document, I came to know DataPower support XML <--> binary text message conversion. I need to do this for my project. Can do that using XSLT. But I am not sure, XLST will support the binary conversion (using functions).

so, please show me a sample conversion configuration in datapower, that will be great.

Cheers,
Bala
13 years ago
Peer, thanks a lot..was very useful.
14 years ago
There are lots of XML Data Binding tools are available as open source. I was trying to do a comparison between all these tools (XMLBeans, JiBX, JaxMe, JaxBRI, JAXB, Castor and etc) with respect to the following points like performance, code generation and complex data type support.

In the internet I can able to get the similar type of comparison between the data binding tools, but very old (2003). If any one has done a similar type of comparison between the Data Binding tools please share it with me or tell me which one will be the best (with reason) in the open source.

Advance Thanks.

Cheers,
Bala
14 years ago
Thanks a lot for reply. I have not selected better wording I believe. This is my requirement,Having lots of webservice. Need to know the best practice and patterns to follow to the environment better. Like more scalable, performace, maintainable and etc

Cheers,
Bala
14 years ago
Thanks, Then you are trying to say better to use Axis2 instead of WSIF. Better can I have comparsion of different tools or framework available. Like SOAP protocal means Axis2 is better, JMS means?

Cheers,
Bala
14 years ago
We want to integrate lots of services (web services). I want to know the best practice and good design pattern on this front. So, can you please given me some idea or point me to the good links/material on this. Thanks a lot in advance.

Cheers,

Bala
14 years ago
I want to write web service client, we are having lots of web service in this project. Currently we are trying to compare Axis2 and WSIF (Web service integration framework). Any one already compared both of this or can we consider any other framework/tools for this requirement. Thanks a lot in advance

Cheers,

Bala
14 years ago
I have taken taken the part III exam on 19/1/2008. Yesterday I got the result.

Class Diagram (44 maximum) 39
Component Diagram (44 maximum) 35
Sequence/Colloboration Diagrams (12 maximum) 12

Thanks a lot for all the javarancher, who helped me in getting this certificate.

Cheers,

Bala