vavkkishore

Hi All, We are planning to build a product where the product users can develope their own JRXML using iReport and upload the JRXML into our product. My product users will NOT be provided with the database access and users will be using iReport in internet disconnect mode While developing the JasperReport we need a way iReport can show my DB tables schema to our users and let them build the DB query without connecting to the database. Is there any way to do this. Thanks, Kishore Veleti A.V.K.

Hi All, I just downloaded the JasperServer ETL latest version, imported the demo project. Now trying to connect to the MySQL database running on my desktop. Getting following error always, please help me in resolving the issue Unhandled event loop exception java.lang.NullPointerException at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm.setPropertiesFormEditable(DatabaseForm.java:1490) at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm.access$2(DatabaseForm.java:1440) at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$4.handleEvent(DatabaseForm.java:801) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1043) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1067) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1048) at org.eclipse.swt.widgets.Control.sendFocusEvent(Control.java:2358) at org.eclipse.swt.widgets.Control.HandlePreviewGotKeyboardFocus(Control.java:1379) at org.eclipse.swt.internal.wpf.OS.DispatcherOperation_Wait(Native Method) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2204) at org.eclipse.jface.window.Window.runEventLoop(Window.java:825) at org.eclipse.jface.window.Window.open(Window.java:801) at org.talend.repository.ui.actions.metadata.CreateConnectionAction.run(CreateConnectionAction.java:163) at org.eclipse.jface.action.Action.runWithEvent(Action.java:498) at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:583) at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:500) at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:411) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1043) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:2458) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2209) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2382) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2346) at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2198) at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:493) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:288) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:488) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149) at org.talend.rcp.intro.Application.start(Application.java:67) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:193) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:382) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179) 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:597) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:549) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:504) at org.eclipse.equinox.launcher.Main.run(Main.java:1236) eclipse.buildId=unknown java.version=1.6.0_04 java.vendor=Sun Microsystems Inc. BootLoader constants: OS=win32, ARCH=x86, WS=wpf, NL=en_US Command-line arguments: -os win32 -ws wpf -arch x86 Thanks, Kishore Veleti A.V.K.

One more thing after above IP address change, you need to make web service calls using the IP address not localhost. With these changes I am able to overcome the above 401 error

I am able to resolve this problem by specifying my maching IP address in "applicationContext-security.xml" located at Tomcat_Home\webapps\jasperserver\WEB-INF Check below my maching IP address (192.168.1.2) <bean id="portletAuthenticationProcessingFilter" <property name="trustedIpAddress"> <list> <!-- uncomment this if both portal server and web server are running on the same machine --> <!-- <value>127.0.0.1</value> --> <value>192.168.1.2</value> </list> </property> <property name="userService"> <ref bean="internalUserAuthorityService"/> </property> </bean> AFter

Hi All, I downloaded "jasperserver-3.5.0-bin" on Win XP Using WAR file Followed the steps defined in "JasperServer-Install-Guide.pdf" for WAR file deployment Developed a Web Service client program to access the JasperServer through its web services API Using jasperadmin/jasperadmin credentials in my web services client program I am getting "401 UnAuthorized" error always. Please help me how I can resolve this issue. Thanks, Kishore Veleti A.V.K. Code:import net.sf.jasperreports.engine.JasperPrint;import com.jaspersoft.jasperserver.irplugin.JServer;import com.jaspersoft.jasperserver.api.metadata.xml.domain.impl.*;import java.io.*;import java.net.URL;import java.util.*;public class ReportServerWSClient{ final String CONFIG_PROPERTY_JASPER_SERVER_USER_NAME = "username"; final String CONFIG_PROPERTY_JASPER_SERVER_PASSWORD = "password"; final String CONFIG_PROPERTY_JASPER_SERVER_WS_URL = "jasper_server_web_service_url"; final String CONFIG_PROPERTY_JASPER_SERVER_SECURITY_DOMAIN_BASE_URI = "jasper_server_sec_domain_base_uri"; // this properties file contains configuration required for this POC program private Properties wsclientProperties = null; // this instance represents the JasperServer private JServer server = null; private List securityDomainsList = null; private String webservicesUri = "/"; // "http://127.0.0.1:8080/axis2/services/repository-ws-1.0"; public static void main(String args[]) { ReportServerWSClient reportServerWSClient = new ReportServerWSClient(); if(args == null || args.length == 0 ) { displayUsageMessage(); } else { try { if("show_all_sd".equals(args[0])) { reportServerWSClient.loadAllSecurityDomains(true); } else if("show_all_sd_reports".equals(args[0])) { reportServerWSClient.listReportsOfASecurityDomain(""); } else if("show_a_sd_reports".equals(args[0])) { reportServerWSClient.listReportsOfASecurityDomain(args[1]); } else { displayUsageMessage(); } } catch(Throwable exception) { System.out.println(""); System.out.println(""); System.out.println(""); System.out.println("Exception occured !!! - " + exception); System.out.println(""); System.out.println(""); exception.printStackTrace(); } } } private static void displayUsageMessage() { System.out.println(""); System.out.println(""); System.out.println(""); System.out.println("Invalid Command line values entered!!!"); System.out.println(""); System.out.println("##########################################"); System.out.println(""); System.out.println("Possible values are :"); System.out.println(""); System.out.println(" (*). show_all_sd"); System.out.println(" (*). show_all_sd_reports"); System.out.println(" (*). show_a_sd_reports <security_domain_name>"); System.out.println(""); System.out.println(""); System.out.println("syntax: runPOC <one_of_the_above_value>"); System.out.println(""); System.out.println(""); System.out.println("##########################################"); } public ReportServerWSClient() { try { loadConfiguration(); validateConfiguration(); instantiateJSServer(); } catch(Exception exception) { // exception.printStackTrace(); } } private void loadConfiguration() throws Exception { InputStream configStream = this.getClass().getClassLoader().getResourceAsStream ("config.properties"); if(configStream == null) { throw new Exception("config.properties file not found"); } wsclientProperties = new Properties(); wsclientProperties.load(configStream); } private void validateConfiguration() throws Exception { } private void instantiateJSServer() throws Exception { server = new JServer(); server.setUsername(wsclientProperties.getProperty(CONFIG_PROPERTY_JASPER_SERVER_USER_NAME)); server.setPassword(wsclientProperties.getProperty(CONFIG_PROPERTY_JASPER_SERVER_PASSWORD)); server.setUrl(wsclientProperties.getProperty(CONFIG_PROPERTY_JASPER_SERVER_WS_URL)); URL url = new URL(server.getUrl()); this.webservicesUri = url.toString(); } private void loadAllSecurityDomains(boolean alsoPrintSecurityDomains) throws Exception { ResourceDescriptor rd = new ResourceDescriptor(); rd.setWsType( ResourceDescriptor.TYPE_FOLDER); rd.setUriString(CONFIG_PROPERTY_JASPER_SERVER_SECURITY_DOMAIN_BASE_URI); securityDomainsList = server.getWSClient().list(rd); if(alsoPrintSecurityDomains) { Iterator secDomainsItr = securityDomainsList.iterator(); while(secDomainsItr.hasNext()) { System.out.println("Security Domain Name - " + secDomainsItr.next()); } } } private void listReportsOfASecurityDomain(String securityDomainName) { }#####################config.properties#####################username=jasperadminpassowrd=jasperadminjasper_server_sec_domain_base_uri=/jasper_server_web_service_url=http://localhost:8080/jasperserver/services/repository