praveen shinde

Hello,
I am working on BIRT report. and I am getting an error :

org.eclipse.birt.report.engine.api.EngineException: Column binding "EMP_CODE" has referred to a data set column "EMP_CODE" which does not exist.

But I am not using any emo_code in the stored procedure which i am calling.

please help.

i have given the xsd path as follows:

<xsd:schema>
<xsd:import namespace="http://ccc.cc.ccc.com/" schemaLocation="f://praveen//docs//ppp.xsd"></xsd:import>
</xsd:schema>

in the wsdl file imported in the client web project in eclips

regards,
Praveen

I downloaded the wsdl and have given the path of the xsd in my mcahine. even then it gives the same error.

reagrds,
Praveen

Hello,
i am creating a web service client for a secure web service (requiring user name , password for access). but while generating the client in eclipse by right clicking the wsdl i am getting the error

"schema_reference.4: Failed to read schema document 'http://xyz.com:80/cvb/abc?xsd=1', because 1) could not find the document; 2) the
document could not be read; 3) the root element of the document is not <xsd:schema>."

So I cannot create the client (in an eclipse web project) to access the web service.

Kindly help
Praveen

Thanks Dittmer,
I am getting the zip file (with a name which I am giving in the code).

Regards,
Praveen.

hi Ulf Dittmer,
Ok, I will try that out.
Thanks & regards,
Praveen

Hello friends,
I am creating a zip file from a string.In the code below zipOS is creating a zip file with an entry of rama.txt. But I am not understanding how to give a name to the resulting zip file. Any help is most welcome.

Thanks



package org; import java.io.BufferedInputStream; import java.io.ByteArrayInputStream; import java.io.ByteArrayOutputStream; import java.io.File; import java.io.FileOutputStream; import java.io.StringReader; import java.io.StringWriter; import java.util.zip.ZipEntry; import java.util.zip.ZipOutputStream; import javax.xml.parsers.DocumentBuilder; import javax.xml.parsers.DocumentBuilderFactory; import javax.xml.transform.TransformerFactory; import javax.xml.transform.dom.DOMSource; import javax.xml.transform.stream.StreamResult; import org.w3c.dom.DOMException; import org.w3c.dom.Document; import org.w3c.dom.NamedNodeMap; import org.w3c.dom.Node; import org.w3c.dom.NodeList; import org.w3c.dom.UserDataHandler; import org.xml.sax.InputSource; public class CreateXml { public static Document loadXML(String xml) throws Exception { DocumentBuilderFactory fctr = DocumentBuilderFactory.newInstance(); DocumentBuilder bldr = fctr.newDocumentBuilder(); InputSource insrc = new InputSource(new StringReader(xml)); return bldr.parse(insrc); } public static void main(String [] args) { Document doc ; String str = "<?xml version=\"1.0\" encoding=\"utf-8\"?><a><b></b><c></c></a>"; try { doc = loadXML(str); //System.out.println("str = " + str); StringWriter output = new StringWriter(); TransformerFactory.newInstance().newTransformer().transform(new DOMSource(doc), new StreamResult(output)); String gbStr = output.toString(); System.out.println("gbStr = " + gbStr); ByteArrayOutputStream baos = new ByteArrayOutputStream(); byte buf[] = gbStr.getBytes(); ByteArrayInputStream in = new ByteArrayInputStream(buf); BufferedInputStream bis = new BufferedInputStream(in); ZipOutputStream zipOS = new ZipOutputStream(baos); byte bytes[] = new byte[4096]; zipOS.putNextEntry(new ZipEntry("rama.txt")); int bytesRead; while ((bytesRead = bis.read(bytes)) != -1) { zipOS.write(bytes, 0, bytesRead); } zipOS.closeEntry(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } }

The error is at the following line.
JasperPrintManager.printReport("build/reports/report5.jrprint", true);

Hello friends,
When I run a simple application for crating a jasper report with jasper apis getting following error.

net.sf.jasperreports.engine.JRException: Invalid page index range : 0 - -1 of 0

Any help is welcome.

code is given below:
public class Report5 { public static void main(String [] args) { //JasperDesign JasperDesign jasperDesign = new JasperDesign(); jasperDesign.setName("Report5"); jasperDesign.setPageWidth(595); jasperDesign.setPageHeight(842); jasperDesign.setColumnWidth(515); jasperDesign.setColumnSpacing(0); jasperDesign.setLeftMargin(40); jasperDesign.setRightMargin(40); jasperDesign.setTopMargin(50); jasperDesign.setBottomMargin(50); //Fonts JRDesignStyle normalStyle = new JRDesignStyle(); normalStyle.setName("Sans_Normal"); normalStyle.setDefault(true); normalStyle.setFontName("DejaVu Sans"); normalStyle.setFontSize(12); normalStyle.setPdfFontName("Helvetica"); normalStyle.setPdfEncoding("Cp1252"); normalStyle.setPdfEmbedded(false); try { jasperDesign.addStyle(normalStyle); JRDesignStyle boldStyle = new JRDesignStyle(); boldStyle.setName("Sans_Bold"); boldStyle.setFontName("DejaVu Sans"); boldStyle.setFontSize(12); boldStyle.setBold(true); boldStyle.setPdfFontName("Helvetica-Bold"); boldStyle.setPdfEncoding("Cp1252"); boldStyle.setPdfEmbedded(false); jasperDesign.addStyle(boldStyle); JRDesignStyle italicStyle = new JRDesignStyle(); italicStyle.setName("Sans_Italic"); italicStyle.setFontName("DejaVu Sans"); italicStyle.setFontSize(12); italicStyle.setItalic(true); italicStyle.setPdfFontName("Helvetica-Oblique"); italicStyle.setPdfEncoding("Cp1252"); italicStyle.setPdfEmbedded(false); jasperDesign.addStyle(italicStyle); //Parameters JRDesignParameter parameter = new JRDesignParameter(); parameter.setName("ReportTitle"); parameter.setValueClass(java.lang.String.class); jasperDesign.addParameter(parameter); /* parameter = new JRDesignParameter(); parameter.setName("OrderByClause"); parameter.setValueClass(java.lang.String.class); jasperDesign.addParameter(parameter); */ //Query JRDesignQuery query = new JRDesignQuery(); //query.setText("SELECT * FROM Address $P!{OrderByClause}"); //query.setText("SELECT * FROM customer"); //jasperDesign.setQuery(query); //Fields JRDesignField field = new JRDesignField(); field.setName("Id"); field.setValueClass(java.lang.Integer.class); jasperDesign.addField(field); field = new JRDesignField(); field.setName("FirstName"); field.setValueClass(java.lang.String.class); jasperDesign.addField(field); field = new JRDesignField(); field.setName("LastName"); field.setValueClass(java.lang.String.class); jasperDesign.addField(field); field = new JRDesignField(); field.setName("Street"); field.setValueClass(java.lang.String.class); jasperDesign.addField(field); field = new JRDesignField(); field.setName("City"); field.setValueClass(java.lang.String.class); jasperDesign.addField(field); //Variables JRDesignVariable variable = new JRDesignVariable(); variable.setName("CityNumber"); variable.setValueClass(java.lang.Integer.class); variable.setResetType(ResetTypeEnum.GROUP); JRDesignGroup group = new JRDesignGroup(); group.setName("CityGroup"); variable.setResetGroup(group); variable.setCalculation(CalculationEnum.SYSTEM); JRDesignExpression expression = new JRDesignExpression(); expression.setValueClass(java.lang.Integer.class); expression.setText("($V{CityNumber} != null)?(new Integer($V{CityNumber}.intValue() + 1)):(new Integer(1))"); variable.setInitialValueExpression(expression); jasperDesign.addVariable(variable); variable = new JRDesignVariable(); variable.setName("AllCities"); variable.setValueClass(java.lang.String.class); variable.setResetType(ResetTypeEnum.REPORT); variable.setCalculation(CalculationEnum.SYSTEM); jasperDesign.addVariable(variable); //Groups group.setMinHeightToStartNewPage(60); expression = new JRDesignExpression(); expression.setValueClass(java.lang.String.class); expression.setText("$F{City}"); group.setExpression(expression); JRDesignBand band = new JRDesignBand(); band.setHeight(20); JRDesignTextField textField = new JRDesignTextField(); textField.setX(0); textField.setY(4); textField.setWidth(515); textField.setHeight(15); textField.setBackcolor(new Color(0xC0, 0xC0, 0xC0)); textField.setMode(ModeEnum.OPAQUE); textField.setHorizontalAlignment(HorizontalAlignEnum.LEFT); textField.setStyle(boldStyle); expression = new JRDesignExpression(); expression.setValueClass(java.lang.String.class); expression.setText("\" \" + String.valueOf($V{CityNumber}) + \". \" + String.valueOf($F{City})"); textField.setExpression(expression); band.addElement(textField); JRDesignLine line = new JRDesignLine(); line.setX(0); line.setY(19); line.setWidth(515); line.setHeight(0); band.addElement(line); ((JRDesignSection)group.getGroupHeaderSection()).addBand(band); band = new JRDesignBand(); band.setHeight(20); line = new JRDesignLine(); line.setX(0); line.setY(-1); line.setWidth(515); line.setHeight(0); band.addElement(line); JRDesignStaticText staticText = new JRDesignStaticText(); staticText.setX(400); staticText.setY(0); staticText.setWidth(60); staticText.setHeight(15); staticText.setHorizontalAlignment(HorizontalAlignEnum.RIGHT); staticText.setStyle(boldStyle); staticText.setText("Count : "); band.addElement(staticText); textField = new JRDesignTextField(); textField.setX(460); textField.setY(0); textField.setWidth(30); textField.setHeight(15); textField.setHorizontalAlignment(HorizontalAlignEnum.RIGHT); textField.setStyle(boldStyle); expression = new JRDesignExpression(); expression.setValueClass(java.lang.Integer.class); expression.setText("$V{CityGroup_COUNT}"); textField.setExpression(expression); band.addElement(textField); ((JRDesignSection)group.getGroupFooterSection()).addBand(band); jasperDesign.addGroup(group); //Title band = new JRDesignBand(); band.setHeight(50); line = new JRDesignLine(); line.setX(0); line.setY(0); line.setWidth(515); line.setHeight(0); band.addElement(line); textField = new JRDesignTextField(); textField.setBlankWhenNull(true); textField.setX(0); textField.setY(10); textField.setWidth(515); textField.setHeight(30); textField.setHorizontalAlignment(HorizontalAlignEnum.CENTER); textField.setStyle(normalStyle); textField.setFontSize(22); expression = new JRDesignExpression(); expression.setValueClass(java.lang.String.class); expression.setText("$P{ReportTitle}"); textField.setExpression(expression); band.addElement(textField); jasperDesign.setTitle(band); //Page header band = new JRDesignBand(); band.setHeight(20); JRDesignFrame frame = new JRDesignFrame(); frame.setX(0); frame.setY(5); frame.setWidth(515); frame.setHeight(15); frame.setForecolor(new Color(0x33, 0x33, 0x33)); frame.setBackcolor(new Color(0x33, 0x33, 0x33)); frame.setMode(ModeEnum.OPAQUE); band.addElement(frame); staticText = new JRDesignStaticText(); staticText.setX(0); staticText.setY(0); staticText.setWidth(55); staticText.setHeight(15); staticText.setForecolor(Color.white); staticText.setBackcolor(new Color(0x33, 0x33, 0x33)); staticText.setMode(ModeEnum.OPAQUE); staticText.setHorizontalAlignment(HorizontalAlignEnum.CENTER); staticText.setStyle(boldStyle); staticText.setText("ID"); frame.addElement(staticText); staticText = new JRDesignStaticText(); staticText.setX(55); staticText.setY(0); staticText.setWidth(205); staticText.setHeight(15); staticText.setForecolor(Color.white); staticText.setBackcolor(new Color(0x33, 0x33, 0x33)); staticText.setMode(ModeEnum.OPAQUE); staticText.setStyle(boldStyle); staticText.setText("Name"); frame.addElement(staticText); staticText = new JRDesignStaticText(); staticText.setX(260); staticText.setY(0); staticText.setWidth(255); staticText.setHeight(15); staticText.setForecolor(Color.white); staticText.setBackcolor(new Color(0x33, 0x33, 0x33)); staticText.setMode(ModeEnum.OPAQUE); staticText.setStyle(boldStyle); staticText.setText("Street"); frame.addElement(staticText); jasperDesign.setPageHeader(band); //Column header band = new JRDesignBand(); jasperDesign.setColumnHeader(band); //Detail band = new JRDesignBand(); band.setHeight(20); textField = new JRDesignTextField(); textField.setX(0); textField.setY(4); textField.setWidth(50); textField.setHeight(15); textField.setHorizontalAlignment(HorizontalAlignEnum.RIGHT); textField.setStyle(normalStyle); expression = new JRDesignExpression(); expression.setValueClass(java.lang.Integer.class); expression.setText("$F{Id}"); textField.setExpression(expression); band.addElement(textField); textField = new JRDesignTextField(); textField.setStretchWithOverflow(true); textField.setX(55); textField.setY(4); textField.setWidth(200); textField.setHeight(15); textField.setPositionType(PositionTypeEnum.FLOAT); textField.setStyle(normalStyle); expression = new JRDesignExpression(); expression.setValueClass(java.lang.String.class); expression.setText("$F{FirstName} + \" \" + $F{LastName}"); textField.setExpression(expression); band.addElement(textField); textField = new JRDesignTextField(); textField.setStretchWithOverflow(true); textField.setX(260); textField.setY(4); textField.setWidth(255); textField.setHeight(15); textField.setPositionType(PositionTypeEnum.FLOAT); textField.setStyle(normalStyle); expression = new JRDesignExpression(); expression.setValueClass(java.lang.String.class); expression.setText("$F{Street}"); textField.setExpression(expression); band.addElement(textField); line = new JRDesignLine(); line.setX(0); line.setY(19); line.setWidth(515); line.setHeight(0); line.setForecolor(new Color(0x80, 0x80, 0x80)); line.setPositionType(PositionTypeEnum.FLOAT); band.addElement(line); ((JRDesignSection)jasperDesign.getDetailSection()).addBand(band); //Column footer band = new JRDesignBand(); jasperDesign.setColumnFooter(band); //Page footer band = new JRDesignBand(); jasperDesign.setPageFooter(band); //Summary band = new JRDesignBand(); jasperDesign.setSummary(band); JasperCompileManager.compileReportToFile(jasperDesign, "build/reports/report5.jasper"); Map parameters = new HashMap(); parameters.put("ReportTitle", "Address Report"); parameters.put("OrderByClause", "ORDER BY City"); Report5 r5 = new Report5(); JasperFillManager.fillReportToFile("build/reports/report5.jasper", parameters, r5.getDemoHsqldbConnection()); JasperPrintManager.printReport("build/reports/report5.jrprint", true); JasperExportManager.exportReportToPdfFile("build/reports/report5.jrprint"); } catch (JRException e) { // TODO Auto-generated catch block e.printStackTrace(); } } protected Connection getDemoHsqldbConnection() throws JRException { Connection conn; try { //Change these settings according to your local configuration String driver = "org.hsqldb.jdbcDriver"; String connectString = "jdbc:hsqldb:hsql://localhost"; String user = "sa"; String password = ""; Class.forName(driver); conn = DriverManager.getConnection(connectString, user, password); } catch (ClassNotFoundException e) { throw new JRException(e); } catch (SQLException e) { throw new JRException(e); } return conn; } }

Hello ,
I have one jsp in which I am using html form.
I am using submit button to give the values from the form.
but when i run the application it is not showing any result what could be the error. Please help.

The jsp part for submit is given here.

<div> <input id="submit1" name="submit" type="button" value="Register Account" onclick="regUser(frm)"/> </div>

Hello ,
Sorry about the missing subject line,
I forgot to put the subject.
Yes i found tutorials when i googled.
thanks,

Hello,

I want info on a good tutorial for JSTL and EL.
Any help is most welcome
Regards,
Praveen

Hi,
I am getting the following error
" Exception in thread "main" java.lang.ClassCastException: $Proxy0 cannot be cast to com.test.Remote1
at com.test.TestBean.main(TestBean.java:17)"

I have a client in the same directory as the ejb java files. The ejb is deployed on JBOSS. The jndi name of the EJB is 'Bean1-test'.
I have not added the jboss-common.jar file in classpath.
Is this the problem. I have jboss 5.1
Any help is most welcome
Praveen

Hello,
i will post my updates shortly.
Praveen