Forum Discussion

skillsoft's avatar
skillsoft
Frequent Contributor
15 years ago

[SOLVED]Error-executing JDBC query-password starts with $

Hi,

I'm having an issue with using a datasource that I believe to be because the password begins with $ (I don't wish to publish the password here, but can send it to you). I can connect to this DB through SQL Server Management Studio just fine. The only other character in the password is % (5th character), the rest are letters and numbers. Unfortunately I have no control over the password. I am using SoapUI v3.6 (released version). Even if I define the password as a property and use a property expansion in the password field, I get the same results. Is there any workaround to this?

Thanks,

Mary

The error I get is:

Tue Oct 12 10:47:48 EDT 2010:ERROR:java.lang.IllegalArgumentException: Illegal group reference
java.lang.IllegalArgumentException: Illegal group reference
at java.util.regex.Matcher.appendReplacement(Unknown Source)
at java.util.regex.Matcher.replaceFirst(Unknown Source)
at java.lang.String.replaceFirst(Unknown Source)
at com.eviware.soapui.support.jdbc.JdbcUtils.initConnection(JdbcUtils.java:44)
at com.eviware.soapui.impl.wsdl.teststeps.datasource.DBDataSource.getDatabaseConnection(SourceFile:416)
at com.eviware.soapui.impl.wsdl.teststeps.datasource.DBDataSource.prepare(SourceFile:170)
at com.eviware.soapui.impl.wsdl.teststeps.WsdlDataSourceTestStep.prepare(SourceFile:458)
at com.eviware.soapui.impl.wsdl.panels.teststeps.DataSourceDesktopPanel$TestAction.actionPerformed(SourceFile:363)
at com.eviware.soapui.impl.wsdl.panels.teststeps.DataSourceDesktopPanel$TestAction.actionPerformed(SourceFile:320)
at com.eviware.soapui.impl.wsdl.actions.iface.AbstractSwingAction.actionPerformed(AbstractSwingAction.java:73)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)

2 Replies

  • skillsoft's avatar
    skillsoft
    Frequent Contributor
    15 years ago
    Hi,

    Awesome, that makes sense, but never occured to me that was needed or would work in the password field. That worked great, with or without the property expansion in the password field. It worked for both JDBC or Data Connection Datasource types.

    Thanks,

    Mary