search

rationaldev / force-metadata-jdbc-driver

Automatically exported from code.google.com/p/force-metadata-jdbc-driver
0 stars 0 forks source link

Cannot access Sandboxes #6

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
1.
java -cp %CP% net.sourceforge.schemaspy.Main -t force -u USERNAME -p 
PASSWORDANDSECKEY -font Arial -fontsize 8 -hq  -norows -o %OUTDIR% -connprops 
custom\=true;standard\=false
2.
add -connprops URL\=https://test.salesforce.com/services/Soap/u/18.0 to the 
Command line   = 
java -cp %CP% net.sourceforge.schemaspy.Main -t force -u USERNAME -p 
PASSWORDANDSECKEY -font Arial -fontsize 8 -hq  -norows -o %OUTDIR% -connprops 
custom\=true;standard\=false;URL\=https://test.salesforce.com/services/Soap/u/20
.0
3.
Change Username and Password-SecToken to the required sandbox login.
4.
Run Command
5.
I am not using a -db parameter and using version 20 of the URL
This works fine for a Production Instance.

What is the expected output? What do you see instead?
The same as for production, but instead cannot login.
Failed to connect to database URL [jdbc:claimvantage:force]

java.sql.SQLException: [LoginFault [ApiFault  exceptionCode='INVALID_LOGIN'
 exceptionMessage='Invalid username, password, security token; or user locked out.'

What version of the product are you using? On what operating system?
Windows XP, Tablet PC Edition 2005, Version 2002, Service Pack 3

Please provide any additional information below.

It has not worked on a number of different ORG's (Sandbox Only) from varying 
locations.

Original issue reported on code.google.com by jamie%qw...@gtempaccount.com on 6 Apr 2011 at 11:51

GoogleCodeExporter commented 8 years ago 
I used your command-line with the sandbox of a free edition org and it failed 
because the code is looking for "url" not "URL". With the property in lower 
case it worked.

This is a poor choice on my part. For now, I've just emphasised this more in 
the wiki pages.

Original comment by keith.clarke.claimvantage@gmail.com on 7 Apr 2011 at 8:50