palla jayakrishna

Greenhorn
+ Follow
since Oct 01, 2008
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
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 palla jayakrishna

HI Jeanne,

Thanks for the reply
1)in our existing application we already have some of the stored procedures written in oracle and we are planning to write some more stored procedure to parse large xml files and insert data in the oracle database which enhances the existing functionality of our core application.Also need the flexibility to migrate to mysql or db2.
i dont know may be we have to write complex queries in using JDBC and remain database independent as suggested by you avoiding stored procedure.

2)Do you have any idea about any R and D developments in progress to come up with common api which will be same syntax and same queries for all for any database.

3)As per my understanding hibernate will generate the sql queries based on the back end database so will it change the sql queries while generating queries based on the back end database.
i know how to call a stored procedure by using hibernate but i am not sure if we develop stored procedure in hibernate by using session createSQLQuery or named query and can we see the difference of generated queries by changing the database names?
Hi Guys,

can please write the steps we have to take care for writing complex stored procedures in oracle but it should work even if we change the database to MySQL .
I think if future there will be a common api for all databases which can have same syntax for all sql queries..
Hi,
My client code for accessing web service:

internetID = new PersonalDemographicsRequestType();
String endpointURL = "https://csdevib.psoft-oit.umn.edu/PSIGW/PeopleSoftServiceListeningConnector";
UM_SIRC_PERSDEMO_BindingStub stub = null;
stub = new UM_SIRC_PERSDEMO_BindingStub();
PersDemoLocator locator = new PersDemoLocator();
stub = new UM_SIRC_PERSDEMO_BindingStub(new URL(endpointURL), locator);
//stub.createCall();
PersonalDemographicsResponseType fileContent = null;
internetID.setInternetID("irrth002");

//stub.setHeader("cshr.umn.edu/PersDemo.1", "Security:Username", "UMWSSIRC");
//stub.setHeader("cshr.umn.edu/PersDemo.1", "Security:Password", "Hiper2012Zer0409");

/* SOAPHeaderElement header = new SOAPHeaderElement(
"cshr.umn.edu/PersDemo.1", "Security");
SOAPElement node = header.addChildElement("Username");
node.addTextNode("UMWSSIRC");
SOAPElement node2 = header.addChildElement("Password");
node2.addTextNode("Hiper2012Zer0409");
stub.setHeader(header) ;*/
//HttpTransportProperties.Authenticator basicAuthentication = new HttpTransportProperties.Authenticator();
//basicAuthentication.setUsername("UMWSSIRC");
// basicAuthentication.setPassword("Hiper2012Zer0409");
//stub._setProperty(org.apache.axis2.transport.http.HTTPConstants.AUTHENTICATE, basicAuthentication);
stub._setProperty(stub.USERNAME_PROPERTY, "UMWSSIRC");
stub._setProperty(stub.PASSWORD_PROPERTY, "Hiper2012Zer0409");

//stub.setUsername("UMWSSIRC");
//stub.setPassword("Hiper2012Zer0409");
fileContent=stub.persDemo(internetID);


After running error coming as


{{http://xml.apache.org/axis/}HttpErrorCode:401

(401)Unauthorized
at org.apache.axis.transport.http.HTTPSender.readFromSocket(HTTPSender.java:744)
at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:144)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165)
at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
at org.apache.axis.client.Call.invoke(Call.java:2767)
at org.apache.axis.client.Call.invoke(Call.java:2443)
at org.apache.axis.client.Call.invoke(Call.java:2366)
at org.apache.axis.client.Call.invoke(Call.java:1812)
at _1.edu.PersDemo.umn.cshr.UM_SIRC_PERSDEMO_BindingStub.persDemo(UM_SIRC_PERSDEMO_BindingStub.java:190)
at _1.edu.PersDemo.umn.cshr.PersDemoclient.main(PersDemoclient.java:51)


But when i try to run in SOAPUI its working fine so credentials are correct please help
6 years ago
Hi friends ,
I am getting this exception while trying to access web service please help:
client code:
stub._setProperty(stub.USERNAME_PROPERTY, "UMWSSIRC");
stub._setProperty(stub.PASSWORD_PROPERTY, "Hiper2012Zer0409");

after running error:
{http://xml.apache.org/axis/}HttpErrorCode:401

(401)Unauthorized
at org.apache.axis.transport.http.HTTPSender.readFromSocket(HTTPSender.java:744)

but the same credentials working fine when i test in SOAP UI.

does any one phased this problem please help
6 years ago
Hi Greenhorn ,
I also had this kind of issue like

"Publishing failed with multiple errors Resource is out of sync with the file system"

after doing this worked fine

Eclipse produces this message when a file in an Eclipse project is changed outside of Eclipse. To avoid it:

a) Don't change files outside of Eclipse
b) Refresh the workspace/project after changing files outside of Eclipse F5 or
c) Enable Window > Preferences > General > Workspace > Refresh Automatically
Possible reason include:
IDE timeout: refresh the server node to see if it's running now.
- Port conflicts. (use netstat -a to detect possible port numbers already used by the operating system.)
- Incorrect server configuration (domain.xml to be corrected manually)
- Corrupted Deployed Applications preventing the server to start.(This can be seen in the server.log file. In this case, domain.xml needs to be modified).
- Invalid installation location.
IDE timeout: refresh the server node to see if it's running now.
- Port conflicts. (use netstat -a to detect possible port numbers already used by the operating system.)
- Incorrect server configuration (domain.xml to be corrected manually)
- Corrupted Deployed Applications preventing the server to start.(This can be seen in the server.log file. In this case, domain.xml needs to be modified).
- Invalid installation location.