Rithanya Laxmi

Thanks you so much Dave, really appreciated all the inputs you have provided.

Thanks a lot Dave, so in this case it is better to use Check constraint than Trigger? also as you mentioned the check constraint usage wont impact any of the existing user type values for other user_ids, i think it is better to use this approach than trigger? please clarify as the client is asking us to make use of Trigger? not entirely sure the reason if we can do the same via simple SQL statement? please advise.

Thanks Dave, so i can do something like this :-


ALTER TABLE CUSTOMER
ADD CONSTRAINT CUSTOMER_USER_TYPE
 CHECK (user_id = 1003 AND user_type = 200);

In this case for the user id 1003 if the user_type is getting updated to any other value other than 200 , then it will thrown an constraint error? and this constraint check wont have any impact for other users "user_types" where there should not be any impact on those user types? please clarify.

Thanks Tim, so we can write a after update trigger to handle this?  we cant cancel this UPDATE getting executed as we are not sure from which app this is getting triggered as this is a common table used by multiple applications.

CREATE OR REPLACE TRIGGER CUST_ID_TRIGGER AFTER UPDATE ON CUSTOMER BEGIN SET USER_TYPE = '200' END;

Hi,


I have a requirement , where when the user_type is set as 100 (from 200) for a user_id = 1003 I need update the user_type back to 200. I need to create a trigger which monitor this record (only single user whos id is 1003) and see whether the user_type is 100 if so immediately update it to 200. Please let me know how we can create a trigger with update table so that immediately when this user_type is set as 100 through trigger we need to update it to 200 for the user_id 1003.


update customer set user_type = 200 where user_id = 1003;


we need to add this in trigger,  so thinking to go with a "before update trigger"  to make sure the user_type is set as 200 something like this . There is a push to implement this through trigger. Please let me know whether the below is correct?



CREATE OR REPLACE TRIGGER CUST_ID_TRIGGER BEFORE UPDATE ON CUSTOMER BEGIN SET USER_TYPE = '200' END;

Thanks

Hi Stephan,

   Whether having CDATA in the CXML dsecription will have any issue while parsing the CXML and retrieve the description value? whether any of the XML parser will have an issue in parsing the description enclosed in CDATA? I hope it is not.

Thanks.

Hi Stephan,

PFB the CXML we are generating with the description for which the value is coming from DB , we also have the xml:lang code as zh_CN for China description with utf8 char encoding, here when we generate the CXML by appending the description in chinese , automatically CDATA section is generated with numeric char references through the API we use as you can see below, but instead of the numeric char reference (encoded) we need to set the actual chinese characters (decoded) , if we escape the below numeric char references then we will get the real china char in decoded form , whether we need use that decoded form by setting that in the description element and pass back ? or is there a better way of handling it? since CDATA section is generated automatically based on the demand basis we dont have control over the CDATA section. This CXML we are passing to another punchout application.

Please clarify.

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE cXML SYSTEM "http://xml.cXML.org/schemas/cXML/1.2.038/cXML.dtd"><cXML payloadID="HSP!6dd843e" xml:lang="zh_CN" timestamp="01 August 2018 20:22:17 PM"><Header><From><Credential domain="NetworkId"><Identity>TEST</Identity></Credential></From>


<Description xml:lang="zh_CN"><![CDATA[气相色谱柱安装工具包]]></Description>
..


</Message>
</cXML>


Thanks

Hi,

I am using CXML generated through the cxmlbeans.jar, i need to pass the description in chinese characters in CXML for which i have use utf8 character encoding set. When there is a chinese spl characters in the desc , the CData is getting generated automatically from the API for description, whether I need to just unescape the HTML to get the real chinese char and set it to the description and pass back? or after setting this decoded value also we will get any issue while passing to 3rd party system?

Thanks

Experts any update on this?

I am using Akamai CDN, but I can handle the first hit cache for the faster loading pages at the first time itself, also if there is a race condition b/w 2 Javascript files how we can handle it in a better way? Thanks

Hi,

I want to cache the resources and object during the first hit from the cache server, how we can handle first hit cache ? whether only CDN supports it or we have any other mechanism to handle it from Java itself. If so how we can use CDN to handle the first hit cache? any inputs on this is really appreciated.

Thanks

Experts any update on this?

Hi ,

I am producing a webservice using JAXWS and in the sunjaxws.xml I have the below configuration for the service


<?xml version="1.0" encoding="UTF-8"?>
<endpoints
   xmlns="http://java.sun.com/xml/ns/jax-ws/ri/runtime"
   version="2.0">
   <endpoint
   name="TestDesign"
   implementation="com.xxx.test.services.TestDesignSoapImpl"  
   url-pattern="/TestDesign.asmx"/>
</endpoints>

Fore this WSDL URL is created as below as :-

http://www.xxx.com/TestDesign/TestDesign.asmx?wsdl

But when we invoke the above URL we are not getting any response it is not throwing any error and we are getting a blank screen? the same config was working fine earlier. There is no errors in logs. Why the WSDL is not generated? is there any issue with the config. Please shed some light into this.

Thanks