Viswanathan Ramamoorthy

Kindly give Clarified information about your issue along With Code.
Visu

In case of report generation if its allowed or not. I am not all having any issues like this as of now . Just for a Clarification only.


Visu

How long the expected time of search will be. Kindly can you explain bit more about your query


Visu

hi guys,

I found the feasibility by adding one more \ inside the '\r'.
Escape Sequence character. That Bug is Fixed.

Thanks
Visu

Hi all,

For my assigned task i have to retrive the values from the DB and that should be written in file.
for the using the following code :

Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection( "jdbc:mysql://localhost:3306/test_server?", "root", "mysql");
stmt = connection.createStatement();
String Query7="SELECT concat(concat(concat("+ office_Id_List.get(i).toString() +" , LPAD(DAY(curdate()),2,0),LPAD(MONTH(curdate()),2,0),LPAD(YEAR(curdate()),4,0), '01.CU1:'),"
+" concat(min(c.customer_id), ':'),concat(max(c.customer_id), ':'),count(c.customer_id))," +
" '\n' concat(concat("+ office_Id_List.get(i).toString() +" , LPAD(DAY(curdate()),2,0),LPAD(MONTH(curdate()),2,0),LPAD(YEAR(curdate()),4,0), '01.CU2:'),"+
" concat(min(c.customer_id), ':'),concat(max(c.customer_id), ':'),count(c.customer_id))," +
" '\n' concat(concat("+ office_Id_List.get(i).toString() +" , LPAD(DAY(curdate()),2,0),LPAD(MONTH(curdate()),2,0),LPAD(YEAR(curdate()),4,0), '01.CU5:')," +
" concat(min(c.customer_id), ':'),concat(max(c.customer_id), ':'),count(c.customer_id))," +
" '\n' concat(concat("+ office_Id_List.get(i).toString() +" , LPAD(DAY(curdate()),2,0),LPAD(MONTH(curdate()),2,0),LPAD(YEAR(curdate()),4,0), '01.CU7:')," +
" concat(min(c.customer_id), ':'),concat(max(c.customer_id), ':'),count(c.customer_id))," +
" '\n' concat(concat("+ office_Id_List.get(i).toString() +" , LPAD(DAY(curdate()),2,0),LPAD(MONTH(curdate()),2,0),LPAD(YEAR(curdate()),4,0), '01.AC1:')," +
" concat(min(s.account_id), ':'),concat(max(s.account_id), ':'),count(s.account_id))," +
" '\n' concat(concat("+ office_Id_List.get(i).toString() +" , LPAD(DAY(curdate()),2,0),LPAD(MONTH(curdate()),2,0),LPAD(YEAR(curdate()),4,0), '01.AC4:')," +
" concat(min(s.account_id), ':'),concat(max(s.account_id), ':'),count(s.account_id)))" +
" INTO OUTFILE 'd://"+office_Id_List.get(i).toString()+"" + CurDate+"01.CTL' "+
" FROM center_group_customer_master c ," +
" saving_accounts s" +
" WHERE c.status = 'V' AND c.customer_id = s.customer_id" ;


I got the Error:
java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(concat(827600 , LPAD(DAY(curdate()),2,0),LPAD(MONTH(curdate()),2,0),LPAD(YEAR(c' at line 1


I printed my Query in console
Its output is :

SELECT concat(concat(concat(827600 , LPAD(DAY(curdate()),2,0),LPAD(MONTH(curdate()),2,0),LPAD(YEAR(curdate()),4,0), '01.CU1:'), concat(min(c.customer_id), ':'),concat(max(c.customer_id), ':'),count(c.customer_id)), '
' concat(concat(827600 , LPAD(DAY(curdate()),2,0),LPAD(MONTH(curdate()),2,0),LPAD(YEAR(curdate()),4,0), '01.CU2:'), concat(min(c.customer_id), ':'),concat(max(c.customer_id), ':'),count(c.customer_id)), '
' concat(concat(827600 , LPAD(DAY(curdate()),2,0),LPAD(MONTH(curdate()),2,0),LPAD(YEAR(curdate()),4,0), '01.CU5:'), concat(min(c.customer_id), ':'),concat(max(c.customer_id), ':'),count(c.customer_id)), '
' concat(concat(827600 , LPAD(DAY(curdate()),2,0),LPAD(MONTH(curdate()),2,0),LPAD(YEAR(curdate()),4,0), '01.CU7:'), concat(min(c.customer_id), ':'),concat(max(c.customer_id), ':'),count(c.customer_id)), '
' concat(concat(827600 , LPAD(DAY(curdate()),2,0),LPAD(MONTH(curdate()),2,0),LPAD(YEAR(curdate()),4,0), '01.AC1:'), concat(min(s.account_id), ':'),concat(max(s.account_id), ':'),count(s.account_id)), '
' concat(concat(827600 , LPAD(DAY(curdate()),2,0),LPAD(MONTH(curdate()),2,0),LPAD(YEAR(curdate()),4,0), '01.AC4:'), concat(min(s.account_id), ':'),concat(max(s.account_id), ':'),count(s.account_id))) INTO OUTFILE 'd://827600111201101.CTL' FROM center_group_customer_master c , saving_accounts s WHERE c.status = 'V' AND c.customer_id = s.customer_id;

Here while at the Execution the '\n' - command is converted to ' '. So this the problem
If i Removed that '\n' its working fine but am not getting the desire output. all the datas were written in single line.

Looking forward for your help

Thanks in Advance

Viswanathan.R

<display:table id="CustId" name="CustAgingList" class="com.smartconnect.reports.dto.CustAgingReportDTO"cellspacing="10" requestURI="/CustagingReportSpecific.do" pagesize="20"
export="true" class="txthead2" varTotals="TDPI">


<logic:present name="prin360" scope="request">
<display:column property="prin360" title="prin360"total="true"></display:column>
<display:column property="int360" title="int360"></display:column></logic:present> <display:footer><tr> <td>
<c:out value="${TDPI.coulmn1}"/>[/color] </td></tr></display:footer>


for that COUT tags I followed the previous steps

after this
<%@ taglib uri="http://java.sun.com/jstl/core_rt" prefix="c"%>

my page showing that error i stated above.

Thanks in advance

Visu

hi all,

I tried to retrieve a result in a EXCEL format. I used display tag, I got the expected result. Its a list of numerical values.
After that they require total for that Retrieved numerical Value. I used Var total Option in the display tag. In that i used

<c:out value="${TDPI.coulmn1}"/>

where TDPI is the attribute value for Vartotal in Display Tag.

For the <c:out tag i gone with JSTL.TLD.
I added JSTL & Standard jar. in lib folder and JSTL.TLD in WEB-INF folder. and

<taglib>
<taglib-uri>http://java.sun.com/jstl/core_rt</taglib-uri>;
<taglib-location>/WEB-INF/c.tld</taglib-location>
</taglib>

in my web.xml

after these steps i am getting

ERROR=org.apache.jasper.JasperException: <h3>Validation error messages from TagLibraryValidator for c</h3><p>null: org.xml.sax.SAXParseException: Attribute "class" was already specified for element "display:table".</p>

that page is not at loading.

the field which am retrieving total is double data type.

I am using JSP2 and jboss-4.0.3SP1.

I need your guidance

Thanks in advance

Visu

Thanks Santhosh , Kindly go through my query, I am requesting is there any option without thrid party certificate or self certification/Duplicate Certificate.

Regards

VisuR

Thanks for your reply.
You are right its most secure way.
But, by using this i am not sure it will change from Http to Https. that is requirement specified for me.

Regards
VisuR

I wish to convert my request from Http to Https.
I dont have Certificate Issued by a Certificate Authority or Self-Signed Certificate.
Is there any other choice to go with.

Kindly Ignore if i scripted anything wrongly by mistake.