phanimca / force-metadata-jdbc-driver Goto Github PK
View Code? Open in Web Editor NEWAutomatically exported from code.google.com/p/force-metadata-jdbc-driver
Automatically exported from code.google.com/p/force-metadata-jdbc-driver
I seem unable to change the connection to the sandbox. Sorry if this has been
discussed before I've read all the notes and cannot seem to find a solution.
Drive Class Name: com.claimvantage.force.jdbc.ForceMetaDataDriver
URL :
jdbc:claimvantage:force;url=https://test.salesforce.com/services/Soap/u/22.0/
Returns
INVALID_LOGIN
at.sun.reflect.NativeConstructorAssessorImpl.newInstance(Unknown Source)
Unknown Source is the theme of the rest of the error message(s) to.
What version of the product are you using? On what operating system?
Using 2.2 version
Please provide any additional information below.
Works great with SchemaSpy from the command line.
Any help would be appreciated
Many thanks
Paul Gale
Original issue reported on code.google.com by [email protected]
on 25 Jul 2014 at 10:06
When reading this page:
http://code.google.com/p/force-metadata-jdbc-driver/wiki/Useage
...there is an implication that only release 1.2 and lower are dependent on
Axis and it's dependencies. However, I found that even with the latest
release, 1.4, the Service.java is still implemented with Axis and stuff from
javax.xml.rpc.
I re-implemented Service.java to use the new web service client:
http://code.google.com/p/sfdc-wsc
This gets rid of Axis and it's dependencies as well as any references to
javax.xml.rpc. Also since WSC uses pull-parsing, it may be faster.
The code is here:
http://chriswolf.heroku.com/page_attachments/0000/0022/force-metadata-jdbc-drive
r-1.4.cw-sources.jar
Original issue reported on code.google.com by [email protected]
on 31 Jan 2011 at 4:27
What steps will reproduce the problem?
1. Using SchemaSpy (current / beta - same behaviour) via ant
2. Connecting to Salesforce MetaData API - with administrator privileges
3.
What is the expected output? What do you see instead?
In schemaspy column "Nulls" should have a value (yes / no)
What version of the product are you using? On what operating system?
Windows 7 - Microsoft Windows [Version 6.1.7601]
Please provide any additional information below.
Not using any specific features - here is a build.xml that runs ant over the
entire java .jar set
<project default="document">
<property name="sf.username" value="[[[UserName]]]"/>
<property name="sf.password" value="[[[Pasword]]][[[Token]]]"/>
<target name="document">
<echo message="Generating SchemaSpy documentation (requires Graphviz to be
installed to produce diagrams)"/>
<java classname="net.sourceforge.schemaspy.Main" fork="true" failonerror="true">
<arg line="-connprops
url\=https://test.salesforce.com/services/Soap/u/21.0;standard\=false;custom\=fa
lse;excludes\=User;includes\=Account,Task"/>
<arg line="-t schemaspy/force"/>
<arg line="-db MyLocalSFOrg"/>
<arg line="-un ${sf.username}"/>
<arg line="-pw ${sf.password}"/>
<arg line="-o mydoc"/>
<arg line="-font Arial"/>
<arg line="-fontsize 8"/>
<arg line="-hq"/>
<arg line="-norows"/>
<arg line='-desc "Extracted from MyLocalSFOrg on Force.com - Date by Folder"'/>
<arg line="-u fake"/>
<arg line="-p fake"/>
<arg line="-host fake"/>
<classpath>
<fileset dir="SchemaSpy" includes="*.jar"/>
</classpath>
</java>
</target>
</project>
Original issue reported on code.google.com by [email protected]
on 5 Aug 2014 at 11:22
What steps will reproduce the problem?
1. Connect to Sales Force using the JDBC
2. You will be able to see the database structure but you can't see tables data
3. The issue comes from the implementation that is returning nulls:
JDBC driver issue: it is not fully implemented:
ResultSet rs = databaseMetaData.getProcedures(...) returns null
connection.createStatement() returns null
The standard JDBC metadata can be found here:
http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html
Original issue reported on code.google.com by [email protected]
on 14 Nov 2013 at 8:56
What steps will reproduce the problem?
1. Generation of any schema
What is the expected output? What do you see instead?
I expect to see Standard SFDC objects along with my Custom Objects. It
seems I only get the metadata extracted for the Custom Objects.
Original issue reported on code.google.com by [email protected]
on 22 Apr 2010 at 11:04
Quick feature request: Would it be possible to extract the formula for formula
fields into the Comments column?
Based on the fact that you do this for Picklist options and that there is a
metadata API field that can output the formula, I'd think this would be
possible, but I'm no expert.
I'll need to brush up on my Java, but I'll see if I can write this myself and
(if so) send you a patch.
Original issue reported on code.google.com by [email protected]
on 24 Mar 2011 at 9:12
What steps will reproduce the problem?
1. Try to use this behind a proxied firewall.
What is the expected output? What do you see instead?
Failure on "could not connect to [endpoint]"
Please provide any additional information below.
Per oscarmack's comments on the wiki, I simply pulled down the source, modified
WscService to pull in properties, and rebuilt and it worked great (using
-Dhttp.proxyHost and -Dhttp.proxyPort options).
Patch attached, which supports http.proxyHost, http.proxyPort, http.proxyUser,
http.proxyPassword and http.auth.ntlm.domain.
Original issue reported on code.google.com by [email protected]
on 11 Aug 2011 at 1:37
Attachments:
What steps will reproduce the problem?
Hooked up to an org with 60+ custom objects and tried to run an extract.
What is the expected output? What do you see instead?
Expected some HTML files to be built (or whatever).
Actual result was:
<code>
ForceMetaDataDriver: Force.com connection url
https://test.salesforce.com/services/Soap/u/30.0
ForceMetaDataDriver: Filter [exclusionNames=[user], inclusionNames=[],
keepCustom=true, keepStandard=false]
</code>
Java quickly jumped to eating up 100% of my CPU.
I let it run overnight (16 hours), and upon return in the morning was still
consuming 100% of CPU, with no additional output and no files created in doc/
What version of the product are you using? On what operating system?
force jdbc 2.2
schemaspy 5.0.0
java 1.6.0_65
osx 10.8
any help much appreciated!
Original issue reported on code.google.com by [email protected]
on 26 Aug 2014 at 2:54
I tried to use the driver with http://ermodeller.tigris.org/ however, it would
not connect and just printed, "No suitable driver found". According to section
9.3 of the JDBC Spec: http://java.cnam.fr/iagl/biblio/spec/jdbc-3_0-fr-spec.pdf
1. The driver should register itself with the driver manager via static
initialization. I added this code to ForceMetaDataDriver.java:
static {
try {
DriverManager.registerDriver(new ForceMetaDataDriver());
} catch (Exception e) {
e.printStackTrace();
}
}
2. Some applications use the DataSource API, which expect the driver to
recognize the standard properties "user" and "password". I added code for the
driver to work with these properties, while still maintaining backward
compatibility with "jdbc:claimvantage:force:someuser:somepassword" way of
configuring user/password.
The source code is here:
http://chriswolf.heroku.com/page_attachments/0000/0022/force-metadata-jdbc-drive
r-1.4.cw-sources.jar
Original issue reported on code.google.com by [email protected]
on 31 Jan 2011 at 4:20
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%[email protected]
on 6 Apr 2011 at 11:51
It would be helpful to be able to have a means to indicate that the target
schema/org is located on "test.salesforce.com", rather than assuming
production.
Original issue reported on code.google.com by [email protected]
on 22 Apr 2010 at 11:02
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.