Cloey Tan

Hi there Paul, thanks for your reply. It was not easy to generate the diagram, and ive reverse generated one sample - removing lots of other details. Hope it helps a bit. Ive attached together with this post.
Hrmstaff is the workers table, while the rest are tables which would be used to identify the working hours of staff. For example, each of those tables (other than hrmstaff) have fields like 'worker' (pfmjobcard), harvestName (pfmharvestdetail)..etc

Note: Having some problem attaching the file at the moment

I need some help in constructing an advanced sql select statement for report generation. This is my case:
I need to produce a report for workers without wages for a period of time from certain department.
My print report screen would have 2 dropdown fields - period and department. In order to identify those workers without wages, i need to search from a few tables, for example, harvesting , jobcard, transport to make sure that the worker name/id doesn't appear inside the record and the total working hour is 0 if his record exist within the selected date.

This seems to involve lots of selection, where shouldi start from. First select all the active users from the vallid department, then only filter based on whether his record exist in those other tables. Please advice. Thanks in advance.

I came across a situation like this, I retrieve an instance of EJB3 entity from the database, pass it to the front end to be updated on its values, then merge it using the EntityManager, entityManager.merge(entityObject), But it doesnt seem to work that way. Does it mean that the entity object is detached? Is there a way to attach it back such that the updated entity object can be merged straight away?

So far, in EJB3, when it comes to many to many relationship joining 2 tables, we could do something like this
@ManyToMany @JoinTable(name="USERS_ROLES", joinColumns= @JoinColumn(name="userroleUserId", referencedColumnName="id"), inverseJoinColumns= @JoinColumn(name="userroleRoleId", referencedColumnName="id")) protected List<role> userRoles;

But now i have a situation whereby i need to join 3 tables together, for example I have a User entity, and would need a bridge/join table consisting of 3 keys, userId, roleId, companyId, whereby it links each of them to user's Id, role's Id and company's Id respectively.
So many to many relationship in the above case doesn't seem to work too well for this i assume?
What kind of table relationship mapping should i be using such that i could retrieve a list of role based on a given user Id and company Id?

Working on a project where people can create a hierarchy of data and store into the database. When retrieved, it would be displayed in a treeview with a checkbox next to it. Was wondering whether some useful resources can be shared here? Thanks in advance.

Using apache cxf to write a web service client are there any good examples to look at?

Im trying out the axis1 example thats given inside the documentation but eneded up with the connection refused.


String endpoint = "http://ws.apache.org:5049/axis/services/echo"; Service service = new Service(); Call call = (Call)service.createCall(); call.setTargetEndpointAddress(new java.net.URL(endpoint)); call.setOperationName(new QName("http://soapinterop.org/", "echoString")); String ret = (String) call.invoke( new Object[] { "Hello!" } ); System.out.println("Sent 'Hello!', got '" + ret + "'");


10:53:45,406 ERROR [STDERR] AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException faultSubcode: faultString: java.net.ConnectException: Connection refused: connect faultActor: faultNode: faultDetail: {http://xml.apache.org/axis/}stackTrace:java.net.ConnectException: Connection refused: connect at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:520) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.axis.components.net.DefaultSocketFactory.create(DefaultSocketFactory.java:153) at org.apache.axis.components.net.DefaultSocketFactory.create(DefaultSocketFactory.java:120) at org.apache.axis.transport.http.HTTPSender.getSocket(HTTPSender.java:191) at org.apache.axis.transport.http.HTTPSender.writeToSocket(HTTPSender.java:404) at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:138) 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)

I was wondering whether working with ejb3 and axis2 to write a web service client would need any extra configuration? As It gives me an runtime exception saying java.lang.RuntimeException: java.lang.NoClassDefFoundError: javax/xml/namespace/QName, with just an invoke of ServiceClient sender = new ServiceClient();

Any idea why this happens. Thanks in advance.

While trying out with Axis2, i discovered that when i include this line of code
ServiceClient sender = new ServiceClient();
everything goes fine, until i invoke a method on my application which will then invoke that line of code, i get error message like this:
Caused by: java.lang.RuntimeException: java.lang.NoClassDefFoundError: javax/xml/namespace/QName

What does the QName have to do with the service client anywya? It happens too when i tried with Axis's Service.

Thanks for the help, it has been of great help to me.
Just started off with the Axis2 wsdl2Java tool and now i have a few more questions to ask here:

1) I followed the link as given on the axis2 website, and it generates quite a number of classes, i assume the clientxxstub being generated is an example of client, and the rest of the classes generated are the web service api which need to exist together with the client class as well. please correct if im wrong.
Im using the xmlbeans method, because i got some error previously using the ADB. Part of the error are like below:
Any idea why this happens with the ADB?


Exception in thread "main" org.apache.axis2.wsdl.codegen.CodeGenerationException : java.lang.RuntimeException: java.lang.reflect.InvocationTargetException at org.apache.axis2.wsdl.codegen.CodeGenerationEngine.generate(CodeGener ationEngine.java:271) at org.apache.axis2.wsdl.WSDL2Code.main(WSDL2Code.java:35) at org.apache.axis2.wsdl.WSDL2Java.main(WSDL2Java.java:24) Caused by: java.lang.RuntimeException: java.lang.reflect.InvocationTargetExcepti on at org.apache.axis2.wsdl.codegen.extension.SimpleDBExtension.engage(Simp leDBExtension.java:53) at org.apache.axis2.wsdl.codegen.CodeGenerationEngine.generate(CodeGener ationEngine.java:224) ... 2 more Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces


2) I tried to generate client with another wsdl using xmlbeans, the exactly same method that i used for the previous example, but it ended up with an error.

Retrieving document at 'smsworld.wsdl'. [Fatal Error] smsworld.wsdl:1:8: The processing instruction target matching "[xX ][mM][lL]" is not allowed. Exception in thread "main" org.apache.axis2.wsdl.codegen.CodeGenerationException : Error parsing WSDL at org.apache.axis2.wsdl.codegen.CodeGenerationEngine.<init>(CodeGenerat ionEngine.java:156) at org.apache.axis2.wsdl.WSDL2Code.main(WSDL2Code.java:35) at org.apache.axis2.wsdl.WSDL2Java.main(WSDL2Java.java:24) Caused by: javax.wsdl.WSDLException: WSDLException: faultCode=PARSER_ERROR: Prob lem parsing 'file:/C:/applications/axis2-1.5/samples/smsworld/smsworld.wsdl'.: o rg.xml.sax.SAXParseException: The processing instruction target matching "[xX][m M][lL]" is not allowed. at com.ibm.wsdl.xml.WSDLReaderImpl.getDocument(Unknown Source) at com.ibm.wsdl.xml.WSDLReaderImpl.readWSDL(Unknown Source)

I'm using ejb3 and jboss for my web application, and plan to try out the Axis2 feature, and i have a few questions here:

1)Inside my axis2-1.5\lib, there're so many jar files, which are the relevant lib for me to get Service Client?
2)i came across the WSDL2Java tool, its for generating the java classes which are related to consuming some WSDL?
3)For example, i need to consume a web service online http://~.php?WSDL, how would the WSDL2Java come into place?
4)Can i work with axis2 for the web service client without using the wsdl2java?

i managed to solve the previous error but now getting the QName error, even if i import javax.xml.namespace.QName in the class, im still getting this same error. Has anyone hre encountered this before?

javax.ejb.EJBException: java.lang.RuntimeException: java.lang.NoClassDefFoundError: javax/xml/namespace/QName at org.jboss.ejb3.tx.Ejb3TxPolicy.handleExceptionInOurTx(Ejb3TxPolicy.java:63) at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:83)

has anyone here encountered this issue while working with the apache axis?
After referring to axis website, i discover some other jar besides axis.jar have to be there also, how should i modify my maven dependencies?

Currently it refers to axis.jar, what if i have several other jars, like common-discovery etc.. ?
<dependency>
<groupId>org.apache.axis</groupId>
<artifactId>axis</artifactId>
<type>jar</type>
<version>1.4</version>
</dependency>


javax.ejb.EJBException: java.lang.RuntimeException: java.lang.NoClassDefFoundError: org/apache/commons/discovery/tools/DiscoverSingleton at org.jboss.ejb3.tx.Ejb3TxPolicy.handleExceptionInOurTx(Ejb3TxPolicy.java:63) at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:83) at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:191) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:95) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77) at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:110) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:46) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:240) at org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:210) at org.jboss.ejb3.stateless.StatelessLocalProxy.invoke(StatelessLocalProxy.java:84) at $Proxy434.authenticate(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.granite.messaging.service.ServiceInvocationContext.invoke(ServiceInvocationContext.java:71) at org.granite.messaging.service.security.AbstractSecurityService.endAuthorization(AbstractSecurityService.java:42) at org.granite.messaging.service.security.TomcatSecurityService.authorize(TomcatSecurityService.java:151) at org.granite.messaging.service.ServiceInvoker.invoke(ServiceInvoker.java:144) at org.granite.messaging.amf.process.AMF3MessageProcessor.processRemotingMessage(AMF3MessageProcessor.java:136) at org.granite.messaging.amf.process.AMF3MessageProcessor.process(AMF3MessageProcessor.java:59) at org.granite.messaging.amf.process.AMF0MessageProcessor.process(AMF0MessageProcessor.java:71) at org.granite.messaging.webapp.AMFMessageServlet.doPost(AMFMessageServlet.java:59) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.is.core.filter.EntryPointFilter.doFilter(EntryPointFilter.java:166) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.granite.messaging.webapp.AMFMessageFilter.doFilter(AMFMessageFilter.java:87) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.RuntimeException: java.lang.NoClassDefFoundError: org/apache/commons/discovery/tools/DiscoverSingleton at com.is.core.ejb3.interceptors.CommonInterceptor.intercept(CommonInterceptor.java:40) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:118) at com.is.core.ejb3.interceptors.LoggingInterceptor.log(LoggingInterceptor.java:33) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:118) at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79) ... 55 more

First off, i would like to thank you both on the replies. Here i have another doubt.

I can see there're some examples on the net on how to use axis to write client to invoke web service, one of them is http://192.87.31.188/docs/easws/easws103.htm Well, i have a question here since i have not started trying out the examples, yet, that whether it is possible to to use axis to list out the available web methods to invoke? and we need to know the return value type as well, so that we can do something like this int value= ((Integer)call.invoke(inParams)).intValue(); it means we need to know /understand the web service before proceed with writing the client? Would that be possible that i write a generic web service client that could cater for different web services?
Please advice and thanks in advance.

Regards

Hi thanks for the reply, ill take a look at the links provided. While i was in the process of researching, i came across , apache axis, axis2 and apache soap. Can i use them to write the client soap?