riesvantwisk

Be aware, the one shown in the link is buggy and is taken from the MySQL plugin. I am working on a better version on it. Ries

found it on the talend forums : http://www.talendforge.org/ext/extension_view.php?eid=41

Hey All, I need to execute a Store Procedure when a job finishes in PostgreSQL. Now I see that Oracle, MySQL, and other have Stored Procedure Execution. Is there any reason why that is not available for PostgreSQL?? Ries

Martin Schumacher Wrote: Is JasperETL suitable for this tasks? Am I right with ETL for this tasks? Where can I find a tutorial which helps me for the first steps? Hey Martin, JasperETL can help you with this task. If it's a one timer this can also be written in plain SQL of course... But if you do it multiple times then Jasper ETL might be more helpfull and for other people to understand the process of migration. Ries

As an attachment can you post your schema? That would help understand what you are doing.. Ries

Alright, I found a better way to do this, there are a couple of steps to take: 1) find the file with the name : db_output_bulk.skeleton 2) Modify the function getSqlStmt into the one below: public String getSqlStmt() { // RVT Add cast if needed for special types that is not available in JDBC String cast=""; if (this.column.getType() != null) { if (this.column.getType().equals("UUID")) { cast = "::uuid"; } } return this.sqlStmt + cast; } 3) replace the file mapping_Postgres.xml with the one below attached 4) Fine the directory JasperETL-macosx-carbon.app/Contents/MacOS/workspace/.JETEmitters/runtime/org/talend/designer/codegen/translators/database and remove the postgresql directory within (it contains a lot of class files) Now restart JasperETL and UUID can be selected and used. Ries PS: Forget about my above post... that was plain wrong

To answer my own question here is my temporal sulation: CREATE OR REPLACE FUNCTION public.equaluuidtext(a uuid, b text) RETURNS boolean AS $BODY$ DECLARE output boolean; BEGIN SELECT a=b::uuid into output; return output; END $BODY$ LANGUAGE 'plpgsql' VOLATILE COST 100; CREATE OPERATOR = (PROCEDURE = public.equaluuidtext, LEFTARG = uuid, RIGHTARG = text);

Hey All, I added the UUID datatype to mapping_Postgres.xml by adding this line: <dbType type="UUID" ignoreLen="true" ignorePre="true" /> However what I am looking for is that JasperETL generates a prepared statement something in the line of : java.sql.PreparedStatement pstmtInsert_tPostgresqlOutput_1 = conn_tPostgresqlOutput_1.prepareStatement("INSERT INTO "" + tableName_tPostgresqlOutput_1 + "" ("year","group","sub_group","num","image","descr","inst","uuid","lang_id") VALUES (?,?,?,?,?,?,?,?::uuid,?)"); As you can see I need to cast a String to a UUID type, How can I set this up?? regards, Ries van Twisk

I add the same but could get it working by adding the execute bit to the JasperETL-macosx-carbon file. this did the trick for me : chmod 0775 JasperETL-All-r12707-V2.3.2/JasperETL-macosx-carbon I forgot if I also hadd to do teh same for : JasperETL-All-r12707-V2.3.2/JasperETL-macosx-carbon.app/Contents/MacOS/JasperETL-macosx-carbon But it works here now, Ries van Twisk

Hey All, I managed to get past the whole log problem but getting this error now: Exception sending context initialized event to listener instance of class com.jaspersoft.jasperserver.war.util.SpringBeanServletContextPlublisher com.jaspersoft.jasperserver.api.JSException: jsexception.cant.append at com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater.append(GenericBeanUpdater.java:90) at com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater.getProcessedPropertyValue(GenericBeanUpdater.java:50) at com.jaspersoft.jasperserver.api.common.util.spring.AbstractBeanPropertyProcessor.postProcessBeanFactory(AbstractBeanPropertyProcessor.java:62) at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:554) at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:537) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:363) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:255) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:199) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:45) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4523) at org.apache.catalina.core.StandardContext.start(StandardContext.java:5184) at com.sun.enterprise.web.WebModule.start(WebModule.java:326) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:973) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:957) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:688) at com.sun.enterprise.web.WebContainer.loadWebModule(WebContainer.java:1584) at com.sun.enterprise.web.WebContainer.loadWebModule(WebContainer.java:1222) at com.sun.enterprise.server.WebModuleDeployEventListener.moduleDeployed(WebModuleDeployEventListener.java:182) at com.sun.enterprise.server.WebModuleDeployEventListener.moduleDeployed(WebModuleDeployEventListener.java:278) at com.sun.enterprise.admin.event.AdminEventMulticaster.invokeModuleDeployEventListener(AdminEventMulticaster.java:974) at com.sun.enterprise.admin.event.AdminEventMulticaster.handleModuleDeployEvent(AdminEventMulticaster.java:961) at com.sun.enterprise.admin.event.AdminEventMulticaster.processEvent(AdminEventMulticaster.java:464) at com.sun.enterprise.admin.event.AdminEventMulticaster.multicastEvent(AdminEventMulticaster.java:176) at com.sun.enterprise.admin.server.core.DeploymentNotificationHelper.multicastEvent(DeploymentNotificationHelper.java:308) at com.sun.enterprise.deployment.phasing.DeploymentServiceUtils.multicastEvent(DeploymentServiceUtils.java:226) at com.sun.enterprise.deployment.phasing.ServerDeploymentTarget.sendStartEvent(ServerDeploymentTarget.java:298) at com.sun.enterprise.deployment.phasing.ApplicationStartPhase.runPhase(ApplicationStartPhase.java:132) at com.sun.enterprise.deployment.phasing.DeploymentPhase.executePhase(DeploymentPhase.java:108) at com.sun.enterprise.deployment.phasing.PEDeploymentService.executePhases(PEDeploymentService.java:919) at com.sun.enterprise.deployment.phasing.PEDeploymentService.deploy(PEDeploymentService.java:276) at com.sun.enterprise.deployment.phasing.PEDeploymentService.deploy(PEDeploymentService.java:294) at com.sun.enterprise.admin.mbeans.ApplicationsConfigMBean.deploy(ApplicationsConfigMBean.java:555) 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 com.sun.enterprise.admin.MBeanHelper.invokeOperationInBean(MBeanHelper.java:375) at com.sun.enterprise.admin.MBeanHelper.invokeOperationInBean(MBeanHelper.java:358) at com.sun.enterprise.admin.config.BaseConfigMBean.invoke(BaseConfigMBean.java:464) at com.sun.jmx.mbeanserver.DynamicMetaDataImpl.invoke(DynamicMetaDataImpl.java:213) at com.sun.jmx.mbeanserver.MetaDataImpl.invoke(MetaDataImpl.java:220) at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:815) at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:784) at sun.reflect.GeneratedMethodAccessor14.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at com.sun.enterprise.admin.util.proxy.ProxyClass.invoke(ProxyClass.java:90) at $Proxy1.invoke(Unknown Source) at com.sun.enterprise.admin.server.core.jmx.SunoneInterceptor.invoke(SunoneInterceptor.java:304) at com.sun.enterprise.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.java:174) at com.sun.enterprise.deployment.autodeploy.AutoDeployer.invokeDeploymentService(AutoDeployer.java:564) at com.sun.enterprise.deployment.autodeploy.AutoDeployer.deployJavaEEArchive(AutoDeployer.java:545) at com.sun.enterprise.deployment.autodeploy.AutoDeployer.deploy(AutoDeployer.java:492) at com.sun.enterprise.deployment.autodeploy.AutoDeployer.deployAll(AutoDeployer.java:267) at com.sun.enterprise.deployment.autodeploy.AutoDeployControllerImpl$AutoDeployTask.run(AutoDeployControllerImpl.java:374) at java.util.TimerThread.mainLoop(Timer.java:512) at java.util.TimerThread.run(Timer.java:462) Anybody an idea why it cannot append and thus get this error?? Ries

Hey All, I am trying to run JasperServer V3 tigether with PostgreSQL 8.3. I changed the mysqldll file (isn't there a PostgreSQL version???) to PostgreSQL and loaded that in my database. I created some resources with the name jdbc/jasperserver. Now I am hitting a couple of error messages I don't understand why they are there. dom4j is found in WEB-INF/lib and even if I put it in domain1/lib it still doesn't work. Any help is appriciated.. (or a link to a install guide for glassfish). Ries Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.orm.hibernate3.LocalSessionFactoryBean]: Constructor threw exception; nested exception is java.lang.NoClassDefFoundError: org/dom4j/DocumentException Caused by: org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.orm.hibernate3.LocalSessionFactoryBean]: Constructor threw exception; nested exception is java.lang.NoClassDefFoundError: org/dom4j/DocumentException Caused by: java.lang.NoClassDefFoundError: org/dom4j/DocumentException at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:164) at org.springframework.orm.hibernate3.LocalSessionFactoryBean.class$(LocalSessionFactoryBean.java:157) at org.springframework.orm.hibernate3.LocalSessionFactoryBean.<init>(LocalSessionFactoryBean.java:157) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at

lshannon wrote: I think if you look in the bin directory of the iReport install directory and look at startup.bat, you can configure the memory available here. I added JAVA_OPTS="-Xms2048M -Xmx2048M" to startup.sh But that didn't change anything. Was that JAVA_OPTS good to start off with?? Ries

Hey All, is it possible to create a download link for a specific report using JasperServer? The idea is that we will have a Adobe Flex application to show report data in , among a full management tool. And with a click of a button we send option parameters to JasperServer. Options parameters can be: - What report type to create PF, CSV, Excel etc... - What data set to retrieve (mostly filters). From the documentation JS-Ultimate Guide I couldn't make this clear yet. Ries

Hey All, when using a relative small XML source (7.4MB) I get out of memory errors with simple reports like CSV or PDF. I bought the book iReport-2.0.pdf but there is no mentioning of how to solve memory issues. Except about the report visualizer which I set to File and some settings from 100 to 1000. I did see a lot of people mentioning this on the forum, and it looks like that using a XML datasource is a bad idea??? Is there a option to increase memory for iReport or let iReport handle XML sources better? If XML is a bad idea, what can be also a good data source rather then using direct DB connections. The reason I don't want to have a direct DB connection is because we have an outside DB server and the report are created by inside people behind a firewall. XML using web-services would be a good option for us but this needs to work reliable ofcourse... Of 7.4Mb is considered large then what can I do?? (7.4Mb is considered really small for us). thanks, Ries

thanks for the Help so far... iReport by itself is not really hard, there are just some gotchas and 'nice to know' sort of items. Actually I was trying to create my reports from a WSDL datasource, but this doesn't seems to be possible but will check the book if I am right or not. I am downloading the book right now... 30 minutes till I can read it :) I will post here since this is the more buzy forum then using the ireport forum. Ries

Hey Great! That worked for me to. Apparently in the description you HAVE to fill in the path to the field on interest. I think I need to buy the books, without it seems to be impossible to figure out iReport. Ries

Hey All, I am starting to feel pretty stupid right now!!! I followed a outdated manual of iReport that only showed a local XML datasource. (http://ireport.sourceforge.net/cap7.html) What I am trying to do is for example take this XML : http://www.cafeconleche.org/books/bible/examples/06/6-1.xml And make a simple report. When I add that datasource and try to ping it it it all ok. But when I go to report query and select xpath2 then I get 'no file found'. May be I am missing something here, I am not sure but should I beable to generate a report using remote XML? Data sources based on SQL (we use PostgreSQL) works just fine, however when w finally deploy the report we don't have access to PostgreSQL and only XML or WSDL datasources will be available. Ries

Hey All, I wrote a webservice that I want to use as a datasource for iReport so I can simply give my client a URI rather then a complex SQL to work against. When trying to add a datasource I don't see a option for wsdl, how would I be-able to let iReport get data from a remote server and use that to generate reports? Or is the only option I have available currently simple remote XML?? Kind regards, Ries van Twisk Post edited by: riesvantwisk, at: 2008/07/01 23:43

to answer my own question.... I had a invalid combination of jar files downloaded. What I did was downloaded jasperreports-2.0.4. biuld it... took the jar's in the lib directory and the generated jasperreports-2.0.4.jarfile. Now it all works fine. thanks, Ries van Twisk

@all, first post here... I am trying to create a report in a remote object using WebORB. When I create a report using JasperExportManager like this : JasperExportManager.exportReportToXmlFile(jasperPrint, "/tmp/Simple_Report.xml",true); I am perfectly beable to generate a report. However when I want to create a XLS using the JRXlsExporter class, then I get a exception directly on this line : JRXlsExporter exporterXLS = new JRXlsExporter(); Unfortunately I cannot figure out the exact exception because from WebORB I get something else back. I use the folloing jar file which I put in my JBoss lib folder. commons-collections-testframework-3.2.jar commons-logging-adapters-1.1.1.jar commons-beanutils-bean-collections.jar commons-digester-1.8.jar commons-logging-api-1.1.1.jar jasperreports-2.0.4.jar commons-beanutils-core.jar commons-logging-1.1.1-javadoc.jar commons-logging-tests.jar commons-beanutils.jar commons-logging-1.1.1-sources.jar commons-collections-3.2.jar commons-logging-1.1.1.jar iText-2.0.8.jar I found some where that in JBoss I had to use jasperreports-2.0.4-javaflow.jar, but then I couldn't generate a report at all... do I need to do anything special under JBoss to use the class JRXlsExporter ??? thanks, Ries van Twisk