helifort

Thanks for your help If I want to automaticlly add a datasource during the jasper server first installation, I add the datasouce info into context.xml file is it works.

Hi I created a jdbc datasource on the JasperReport server repository, I want to know where those informaiton had been stored, I want to modified it from command line or scripting. I checked file /jasperreports-server-4.5/apache-tomcat/webapps/jasperserver-pro/META-INF/context.xml, it didn't contained the new JDBC datasource. any one know how. Thanks Rosso

any one had experiences

Hi I want to using Ireport desginer connect to Vertica db when I create data source got the following errors but I set up the same Data source on the JasperReport Server it is work, the connection passed. Vertica DB is a distributed DB, I had copy Vertica Jdbc driver into Classpath. url is jdbc:vertica://192.85.180.xxx:5433/vmartdb DB is online Any one can help Thanks Rosso Exception Message: com.vertica.util.PSQLException: The connection attempt failed. Level: SEVERE Stack Trace: The connection attempt failed. com.vertica.core.v3.ConnectionFactoryImpl.openConnectionImpl(Unknown Source) com.vertica.core.ConnectionFactory.openConnection(Unknown Source) com.vertica.jdbc2.AbstractJdbc2Connection.<init>(Unknown Source) com.vertica.jdbc3.AbstractJdbc3Connection.<init>(Unknown Source) com.vertica.jdbc3g.Jdbc3gConnection.<init>(Unknown Source) com.vertica.Driver.makeConnection(Unknown Source) com.vertica.Driver.connect(Unknown Source) com.jaspersoft.ireport.designer.connection.JDBCConnection.getConnection(JDBCConnection.java:140) com.jaspersoft.ireport.designer.connection.JDBCConnection.test(JDBCConnection.java:447) com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog.jButtonTestActionPerformed(ConnectionDialog.java:335) com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog.access$300(ConnectionDialog.java:43) com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog$4.actionPerformed(ConnectionDialog.java:290) javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995) javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318) javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387) javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242) javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) java.awt.Component.processMouseEvent(Component.java:6263) javax.swing.JComponent.processMouseEvent(JComponent.java:3267) java.awt.Component.processEvent(Component.java:6028) java.awt.Container.processEvent(Container.java:2041) java.awt.Component.dispatchEventImpl(Component.java:4630) java.awt.Container.dispatchEventImpl(Container.java:2099) java.awt.Component.dispatchEvent(Component.java:4460) java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574) java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238) java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168) java.awt.Container.dispatchEventImpl(Container.java:2085) java.awt.Window.dispatchEventImpl(Window.java:2478) java.awt.Component.dispatchEvent(Component.java:4460) java.awt.EventQueue.dispatchEvent(EventQueue.java:599) org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104) java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178) java.awt.Dialog$1.run(Dialog.java:1046) java.awt.Dialog$3.run(Dialog.java:1098) java.security.AccessController.doPrivileged(Native Method) java.awt.Dialog.show(Dialog.java:1096) java.awt.Component.show(Component.java:1563) java.awt.Component.setVisible(Component.java:1515) java.awt.Window.setVisible(Window.java:842) java.awt.Dialog.setVisible(Dialog.java:986) com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog.jButtonModifyParameterActionPerformed(ConnectionsDialog.java:540) com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog.access$500(ConnectionsDialog.java:47) com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog$8.actionPerformed(ConnectionsDialog.java:236) javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995) javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318) javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387) javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242) javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) java.awt.Component.processMouseEvent(Component.java:6263) javax.swing.JComponent.processMouseEvent(JComponent.java:3267) java.awt.Component.processEvent(Component.java:6028) java.awt.Container.processEvent(Container.java:2041) java.awt.Component.dispatchEventImpl(Component.java:4630) java.awt.Container.dispatchEventImpl(Container.java:2099) java.awt.Component.dispatchEvent(Component.java:4460) java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574) java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238) java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168) java.awt.Container.dispatchEventImpl(Container.java:2085) java.awt.Window.dispatchEventImpl(Window.java:2478) java.awt.Component.dispatchEvent(Component.java:4460) java.awt.EventQueue.dispatchEvent(EventQueue.java:599) org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104) java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178) java.awt.Dialog$1.run(Dialog.java:1046) java.awt.Dialog$3.run(Dialog.java:1098) java.security.AccessController.doPrivileged(Native Method) java.awt.Dialog.show(Dialog.java:1096) java.awt.Component.show(Component.java:1563) java.awt.Component.setVisible(Component.java:1515) java.awt.Window.setVisible(Window.java:842) java.awt.Dialog.setVisible(Dialog.java:986) com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog.setVisible(ConnectionsDialog.java:651) com.jaspersoft.ireport.designer.menu.DatasourcesAction.performAction(DatasourcesAction.java:46) org.openide.util.actions.CallableSystemAction$1.run(CallableSystemAction.java:118) org.netbeans.modules.openide.util.ActionsBridge.doPerformAction(ActionsBridge.java:77) org.openide.util.actions.CallableSystemAction.actionPerformed(CallableSystemAction.java:114) javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995) javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318) javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387) javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242) javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272) java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272) java.awt.Component.processMouseEvent(Component.java:6263) javax.swing.JComponent.processMouseEvent(JComponent.java:3267) org.openide.awt.ToolbarButton.processMouseEvent(ToolbarButton.java:61) java.awt.Component.processEvent(Component.java:6028) java.awt.Container.processEvent(Container.java:2041) java.awt.Component.dispatchEventImpl(Component.java:4630) java.awt.Container.dispatchEventImpl(Container.java:2099) java.awt.Component.dispatchEvent(Component.java:4460) java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574) java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238) java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168) java.awt.Container.dispatchEventImpl(Container.java:2085) java.awt.Window.dispatchEventImpl(Window.java:2478) java.awt.Component.dispatchEvent(Component.java:4460) java.awt.EventQueue.dispatchEvent(EventQueue.java:599) org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104) java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174) java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169) java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161) java.awt.EventDispatchThread.run(EventDispatchThread.java:122) Malformed reply from SOCKS server java.net.SocksSocketImpl.readSocksReply(SocksSocketImpl.java:90) java.net.SocksSocketImpl.connect(SocksSocketImpl.java:429) java.net.Socket.connect(Socket.java:525) java.net.Socket.connect(Socket.java:475) java.net.Socket.<init>(Socket.java:372) java.net.Socket.<init>(Socket.java:186) com.vertica.core.PGStream.<init>(Unknown Source) com.vertica.core.v3.ConnectionFactoryImpl.openConnectionImpl(Unknown Source) com.vertica.core.ConnectionFactory.openConnection(Unknown Source) com.vertica.jdbc2.AbstractJdbc2Connection.<init>(Unknown Source) com.vertica.jdbc3.AbstractJdbc3Connection.<init>(Unknown Source) com.vertica.jdbc3g.Jdbc3gConnection.<init>(Unknown Source) com.vertica.Driver.makeConnection(Unknown Source) com.vertica.Driver.connect(Unknown Source) com.jaspersoft.ireport.designer.connection.JDBCConnection.getConnection(JDBCConnection.java:140) com.jaspersoft.ireport.designer.connection.JDBCConnection.test(JDBCConnection.java:447) com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog.jButtonTestActionPerformed(ConnectionDialog.java:335) com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog.access$300(ConnectionDialog.java:43) com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog$4.actionPerformed(ConnectionDialog.java:290) javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995) javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318) javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387) javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242) javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) java.awt.Component.processMouseEvent(Component.java:6263) javax.swing.JComponent.processMouseEvent(JComponent.java:3267) java.awt.Component.processEvent(Component.java:6028) java.awt.Container.processEvent(Container.java:2041) java.awt.Component.dispatchEventImpl(Component.java:4630) java.awt.Container.dispatchEventImpl(Container.java:2099) java.awt.Component.dispatchEvent(Component.java:4460) java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574) java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238) java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168) java.awt.Container.dispatchEventImpl(Container.java:2085) java.awt.Window.dispatchEventImpl(Window.java:2478) java.awt.Component.dispatchEvent(Component.java:4460) java.awt.EventQueue.dispatchEvent(EventQueue.java:599) org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104) java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178) java.awt.Dialog$1.run(Dialog.java:1046) java.awt.Dialog$3.run(Dialog.java:1098) java.security.AccessController.doPrivileged(Native Method) java.awt.Dialog.show(Dialog.java:1096) java.awt.Component.show(Component.java:1563) java.awt.Component.setVisible(Component.java:1515) java.awt.Window.setVisible(Window.java:842) java.awt.Dialog.setVisible(Dialog.java:986) com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog.jButtonModifyParameterActionPerformed(ConnectionsDialog.java:540) com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog.access$500(ConnectionsDialog.java:47) com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog$8.actionPerformed(ConnectionsDialog.java:236) javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995) javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318) javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387) javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242) javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) java.awt.Component.processMouseEvent(Component.java:6263) javax.swing.JComponent.processMouseEvent(JComponent.java:3267) java.awt.Component.processEvent(Component.java:6028) java.awt.Container.processEvent(Container.java:2041) java.awt.Component.dispatchEventImpl(Component.java:4630) java.awt.Container.dispatchEventImpl(Container.java:2099) java.awt.Component.dispatchEvent(Component.java:4460) java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574) java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238) java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168) java.awt.Container.dispatchEventImpl(Container.java:2085) java.awt.Window.dispatchEventImpl(Window.java:2478) java.awt.Component.dispatchEvent(Component.java:4460) java.awt.EventQueue.dispatchEvent(EventQueue.java:599) org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104) java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178) java.awt.Dialog$1.run(Dialog.java:1046) java.awt.Dialog$3.run(Dialog.java:1098) java.security.AccessController.doPrivileged(Native Method) java.awt.Dialog.show(Dialog.java:1096) java.awt.Component.show(Component.java:1563) java.awt.Component.setVisible(Component.java:1515) java.awt.Window.setVisible(Window.java:842) java.awt.Dialog.setVisible(Dialog.java:986) com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog.setVisible(ConnectionsDialog.java:651) com.jaspersoft.ireport.designer.menu.DatasourcesAction.performAction(DatasourcesAction.java:46) org.openide.util.actions.CallableSystemAction$1.run(CallableSystemAction.java:118) org.netbeans.modules.openide.util.ActionsBridge.doPerformAction(ActionsBridge.java:77) org.openide.util.actions.CallableSystemAction.actionPerformed(CallableSystemAction.java:114) javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995) javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318) javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387) javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242) javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272) java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272) java.awt.Component.processMouseEvent(Component.java:6263) javax.swing.JComponent.processMouseEvent(JComponent.java:3267) org.openide.awt.ToolbarButton.processMouseEvent(ToolbarButton.java:61) java.awt.Component.processEvent(Component.java:6028) java.awt.Container.processEvent(Container.java:2041) java.awt.Component.dispatchEventImpl(Component.java:4630) java.awt.Container.dispatchEventImpl(Container.java:2099) java.awt.Component.dispatchEvent(Component.java:4460) java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574) java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238) java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168) java.awt.Container.dispatchEventImpl(Container.java:2085) java.awt.Window.dispatchEventImpl(Window.java:2478) java.awt.Component.dispatchEvent(Component.java:4460) java.awt.EventQueue.dispatchEvent(EventQueue.java:599) org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104) java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174) java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169) java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161) java.awt.EventDispatchThread.run(EventDispatchThread.java:122)