JDBC Data adapter password issue

[fdarcangelo]

Hi,

I downloaded Jaspersoft studio and started to try and make some reports with it. I'm already stuck, though, with an issue.

I have a DB2 database to connecto to, I created a meta data with as follows:
- Driver JDBC: com.ibm.db2.jcc.DB2Driver

- URL: jdbc:db2://localhost:50000/database (where database is the correct name of my database)

- Username: theuser

- Password: well, the password

I also added on "driver classpath" the right jar file (db2jcc.jar).

If I click "Test" everything works well and the message is "Succeeded" (or well, the relative in my original language).

If I click "done" (or it's relative english value) I get a "no password provided" error.

Here's the full log:

org.eclipse.equinox.security.storage.StorageException: No password provided.
    at org.eclipse.equinox.internal.security.storage.SecurePreferences.put(SecurePreferences.java:237)
    at org.eclipse.equinox.internal.security.storage.SecurePreferencesWrapper.put(SecurePreferencesWrapper.java:110)
    at net.sf.jasperreports.eclipse.util.SecureStorageUtils.saveToDefaultSecurePreferences(SecureStorageUtils.java:126)
    at com.jaspersoft.studio.swt.widgets.WSecretText.persistSecret(WSecretText.java:78)
    at com.jaspersoft.studio.data.jdbc.JDBCDataAdapterComposite.performAdditionalUpdates(JDBCDataAdapterComposite.java:466)
    at com.jaspersoft.studio.data.wizard.pages.DataAdapterEditorPage.performFinishInvoked(DataAdapterEditorPage.java:266)
    at com.jaspersoft.studio.data.wizard.DataAdapterWizard.performFinish(DataAdapterWizard.java:86)
    at org.eclipse.jface.wizard.WizardDialog.finishPressed(WizardDialog.java:827)
    at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:432)
    at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:624)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4169)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3758)
    at org.eclipse.jface.window.Window.runEventLoop(Window.java:825)
    at org.eclipse.jface.window.Window.open(Window.java:801)
    at com.jaspersoft.studio.data.actions.CreateDataAdapterAction.run(CreateDataAdapterAction.java:82)
    at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)
    at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)
    at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)
    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:1053)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4169)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3758)
    at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2701)
    at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2665)
    at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2499)
    at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:679)
    at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
    at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:668)
    at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
    at com.jaspersoft.studio.rcp.intro.Application.start(Application.java:97)
    at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
    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:353)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:180)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:629)
    at org.eclipse.equinox.launcher.Main.basicRun(Main.java:584)
    at org.eclipse.equinox.launcher.Main.run(Main.java:1438)
 

Any idea?? I'm evaluating the product but, well, that's not a good start ^^

My O.S. is Win 8.1 and the db2 server is a 9.7 express-c on localhost

[mlopez_1]

Same problem as me:

http://community.jaspersoft.com/questions/825220/jaspersoft-studio-551-does-not-save-password-data-adapters-neither-servers

No solution yet

 

[jasperreportsuser]

I had a similar problem when I first downloaded Jaspersoft Studio.  I resolved the issue by doing the following,

Setup master key encryption in Eclipse

   Go to  Window >Preferences > General > Security > Secure Storage
   Click Change Password.  If it complains about a problem and asks if you want to cancel press no.  Provide recovery Q/A

Hope this helps.

[mlopez_1]

Doesn't work for me

[jasperreportsuser]

After the above steps, try this. Shutdown Jaspersoft Studio (and all Eclipse instances), go to C:Users (in windows 7) and delete the directory .eclipse. Then restart Jaspersoft Studio. A new .eclipse file will be generated.

[wangmin2001]

yes, It works, although I do not know why.