• MONICA JARAMILLO FUENTES
  • NEWBIE
  • 0 Points
  • Member since 2015

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 3
    Questions
  • 3
    Replies
Hi, 

Is there any tool that can help me to get the use of my developments with Visualforce pages an apex classes? So I can get the track of how much the users use the developments, could you help me please? , thank you. 

Regards, 
Mónica Jaramillo
Hi Everyone, 

I will like to upgrade my version of data loader from v36 to v38, I had allready installed the new version, but for the batch process I have the following error: 

Database error encountered during connecting for database configuration: Account_BicomToSF_PRODUCCION.  Sql error: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'.
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
    at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1429)
    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
    at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
    at com.salesforce.dataloader.dao.database.DatabaseContext.initConnection(DatabaseContext.java:80)
    at com.salesforce.dataloader.dao.database.DatabaseContext.checkConnection(DatabaseContext.java:72)
    at com.salesforce.dataloader.dao.database.DatabaseReader.checkConnection(DatabaseReader.java:244)
    at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:134)
    at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:100)
    at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:253)
Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
    at java.net.URLClassLoader.findClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1420)
    ... 8 more
2017-01-23 08:52:11,989 FATAL [main] process.ProcessRunner topLevelError (ProcessRunner.java:238) - Unable to run process Account
java.lang.RuntimeException: com.salesforce.dataloader.exception.DataAccessObjectInitializationException: Database error encountered during connecting for database configuration: Account_BicomToSF_PRODUCCION.  Sql error: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'.
    at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:162)
    at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:100)
    at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:253)
Caused by: com.salesforce.dataloader.exception.DataAccessObjectInitializationException: Database error encountered during connecting for database configuration: Account_BicomToSF_PRODUCCION.  Sql error: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'.
    at com.salesforce.dataloader.dao.database.DatabaseContext.initConnection(DatabaseContext.java:88)
    at com.salesforce.dataloader.dao.database.DatabaseContext.checkConnection(DatabaseContext.java:72)
    at com.salesforce.dataloader.dao.database.DatabaseReader.checkConnection(DatabaseReader.java:244)
    at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:134)
    ... 2 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
    at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1429)
    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
    at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
    at com.salesforce.dataloader.dao.database.DatabaseContext.initConnection(DatabaseContext.java:80)
    ... 5 more
Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
    at java.net.URLClassLoader.findClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1420)
    ... 8 more

I have all ready download the ojdbc6.jar and add it to the path java/bin, but I still with the error, can you please help me?

Thank you. 

Mónica Jaramillo 
Hi, 

I will like to know, who is using the visualforce and custom objects in my organization, also when was the last time they used it?
So I can get an stadistic of which deployments are in use and which aren´t, my organization works in Salesforce Classic. 
Can someone help me please? 

Thank you,
Hi, 

Is there any tool that can help me to get the use of my developments with Visualforce pages an apex classes? So I can get the track of how much the users use the developments, could you help me please? , thank you. 

Regards, 
Mónica Jaramillo
Hi Everyone, 

I will like to upgrade my version of data loader from v36 to v38, I had allready installed the new version, but for the batch process I have the following error: 

Database error encountered during connecting for database configuration: Account_BicomToSF_PRODUCCION.  Sql error: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'.
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
    at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1429)
    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
    at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
    at com.salesforce.dataloader.dao.database.DatabaseContext.initConnection(DatabaseContext.java:80)
    at com.salesforce.dataloader.dao.database.DatabaseContext.checkConnection(DatabaseContext.java:72)
    at com.salesforce.dataloader.dao.database.DatabaseReader.checkConnection(DatabaseReader.java:244)
    at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:134)
    at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:100)
    at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:253)
Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
    at java.net.URLClassLoader.findClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1420)
    ... 8 more
2017-01-23 08:52:11,989 FATAL [main] process.ProcessRunner topLevelError (ProcessRunner.java:238) - Unable to run process Account
java.lang.RuntimeException: com.salesforce.dataloader.exception.DataAccessObjectInitializationException: Database error encountered during connecting for database configuration: Account_BicomToSF_PRODUCCION.  Sql error: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'.
    at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:162)
    at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:100)
    at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:253)
Caused by: com.salesforce.dataloader.exception.DataAccessObjectInitializationException: Database error encountered during connecting for database configuration: Account_BicomToSF_PRODUCCION.  Sql error: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'.
    at com.salesforce.dataloader.dao.database.DatabaseContext.initConnection(DatabaseContext.java:88)
    at com.salesforce.dataloader.dao.database.DatabaseContext.checkConnection(DatabaseContext.java:72)
    at com.salesforce.dataloader.dao.database.DatabaseReader.checkConnection(DatabaseReader.java:244)
    at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:134)
    ... 2 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
    at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1429)
    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
    at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
    at com.salesforce.dataloader.dao.database.DatabaseContext.initConnection(DatabaseContext.java:80)
    ... 5 more
Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
    at java.net.URLClassLoader.findClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1420)
    ... 8 more

I have all ready download the ojdbc6.jar and add it to the path java/bin, but I still with the error, can you please help me?

Thank you. 

Mónica Jaramillo 
I'm doing the simple lightning components challenge and have hit this problem in my existing trailhead org and a brand new dev org that I've just created:

Challenge not yet complete... here's what's wrong: 
There was an unexpected error while verifying this challenge. Usually this is due to some pre-existing configuration or code in the challenge Org. We recommend using a new Developer Edition (DE) to check this challenge. If you're using a new DE and seeing this error, please post to the developer forums and reference error id: QVWBQHAG