No suitable driver found for jdbc:log4jdbc:sqlserver = 6.2.3

User 0f1e393145

10-06-2014 21:08:42

Hey Guys,


We are currently migrating to a SQL Server instance on 6.2.3. Everything is going fine on most systems, however, we are receiving the following error:


Could not get JDBC Connection; nested exception is java.sql.SQLException: No suitable driver found for jdbc:log4jdbc:sqlserver://(ip address);database_name=(DB name);


We've installed the appropriate drivers and added them to the class path though are still receiving the error. I was wondering if you had any insight to the issue or if you have seen it before?


We plan on upgrading to 6.3 shortly, though I don't believe that is the issue as all functionality and driver connectivity is present on some of our systems running the same specs pasted below.


Thank you in advance!


Adam


 


Instant JChem Version: 6.2.0 (build: 201401301625-423edd2c3d45)


JChem Version: 6.2.0


JChem Table Version: 6200000


Marvin Version: 6.2.0 (build date: 2014-01-20)


Java: 1.7.0_25; Java HotSpot(TM) 64-Bit Server VM 23.25-b01


System: Windows 7 version 6.1 running on amd64; Cp1252; en_US (instantjchem)


NetBeans build: a903faa1d680-ijc-patched-9


Userdir: C:\Users\aidone\AppData\Roaming\.instantjchem\6.2


Java Web Start: No


Plugins:


    au.com.bytecode.opencsv [2.3 201401301625-423edd2c3d45]


    chemaxon.ijc.export.api [6.2 201401301625-423edd2c3d45]


    chemaxon.ijc.updatecenter [6.2 201401301625-423edd2c3d45]


    chemaxon.ijc.webbrowser [6.2 201401301625-423edd2c3d45]


    chemaxon.ijc.wrappers.datarequest/0 [6.2 201401301625-423edd2c3d45]


    chemaxon.jchem/1 [6.2.0 201401301625-423edd2c3d45]


    com.chemaxon.ijc.data.convertors [6.2 201401301625-423edd2c3d45]


    com.chemaxon.ijc.db.sqlserver/0 [6.2 201401301625-423edd2c3d45]


    com.chemaxon.ijc.db.ui [6.2 201401301625-423edd2c3d45]


    com.chemaxon.ijc.export.api.config [6.2 201401301625-423edd2c3d45]


    com.chemaxon.ijc.mdif/0 [6.2 201401301625-423edd2c3d45]


    com.chemaxon.ijc.progress [6.2 201401301625-423edd2c3d45]


    com.chemaxon.ijc.wrappers.formsmodel/0 [6.2 201401301625-423edd2c3d45]


    com.chemaxon.ijc.wrappers.ijcbase [6.2 201401301625-423edd2c3d45]


    com.chemaxon.ijc.wrappers.ijcunit/0 [6.2 201401301625-423edd2c3d45]


    com.codehaus.groovy [2.1.2 201401301625-423edd2c3d45]


    com.compositesw.jdbc/1 [5.1.0 201401301625-423edd2c3d45]


    com.google.common.guava [13.0.1 201401301625-423edd2c3d45]


    com.im.commons [6.2 201401301625-423edd2c3d45]


    com.im.commons.db [6.2 201401301625-423edd2c3d45]


    com.im.commons.db.test [6.2 201401301625-423edd2c3d45]


    com.im.commons.nbcommons [6.2 201401301625-423edd2c3d45]


    com.im.commons.ui [6.2 201401301625-423edd2c3d45]


    com.im.db.composite/1 [6.2 201401301625-423edd2c3d45]


    com.im.df.api [6.2 201401301625-423edd2c3d45]


    com.im.df.api.friend [6.2 201401301625-423edd2c3d45]


    com.im.df.core.derby/1 [6.2 201401301625-423edd2c3d45]


    com.im.df.core.oracle/1 [6.2 201401301625-423edd2c3d45]


    com.im.df.db.mysql/1 [6.2 201401301625-423edd2c3d45]


    com.im.df.exportimport [6.2 201401301625-423edd2c3d45]


    com.im.df.localdb/1 [6.2 201401301625-423edd2c3d45]


    com.im.df.server.local [6.2 201401301625-423edd2c3d45]


    com.im.df/1 [6.2 201401301625-423edd2c3d45]


    com.im.ijc.autoupdate/1 [6.2 201401301625-423edd2c3d45]


    com.im.ijc.branding/1 [6.2 201401301625-423edd2c3d45]


    com.im.ijc.cf [6.2 201401301625-423edd2c3d45]


    com.im.ijc.cf.api [6.2 201401301625-423edd2c3d45]


    com.im.ijc.cf.difbridge [6.2 201401301625-423edd2c3d45]


    com.im.ijc.chem.overlap/1 [6.2 201401301625-423edd2c3d45]


    com.im.ijc.core/1 [6.2 201401301625-423edd2c3d45]


    com.im.ijc.etl.datamigrator.wrapper/0 [6.2 201401301625-423edd2c3d45]


    com.im.ijc.extensions.spotfire [6.2 201401301625-423edd2c3d45]


    com.im.ijc.extraloaders [6.2 201401301625-423edd2c3d45]


    com.im.ijc.formview/1 [6.2 201401301625-423edd2c3d45]


    com.im.ijc.gridview/1 [6.2 201401301625-423edd2c3d45]


    com.im.ijc.groovy [6.2 201401301625-423edd2c3d45]


    com.im.ijc.io [6.2 201401301625-423edd2c3d45]


    com.im.ijc.jrprinting [6.2 201401301625-423edd2c3d45]


    com.im.ijc.logviewer [6.2 201401301625-423edd2c3d45]


    com.im.ijc.performance.probes [6.2 201401301625-423edd2c3d45]


    com.im.ijc.project/1 [6.2 201401301625-423edd2c3d45]


    com.im.ijc.querytextpanel [6.2 201401301625-423edd2c3d45]


    com.im.ijc.reactor/1 [6.2 201401301625-423edd2c3d45]


    com.im.ijc.renderers/1 [6.2 201401301625-423edd2c3d45]


    com.im.ijc.scripting [6.2 201401301625-423edd2c3d45]


    com.im.ijc.security/1 [6.2 201401301625-423edd2c3d45]


    com.im.ijc.server.api [6.2 201401301625-423edd2c3d45]


    com.im.ijc.server.impl [6.2 201401301625-423edd2c3d45]


    com.im.ijc.sfs [6.2 201401301625-423edd2c3d45]


    com.im.ijc.sketchreg [6.2 201401301625-423edd2c3d45]


    com.im.ijc.sketchreg.chemdraw [6.2 201401301625-423edd2c3d45]


    com.im.ijc.standardizer/1 [6.2 201401301625-423edd2c3d45]


    com.im.ijc.structurefiles/1 [6.2 201401301625-423edd2c3d45]


    com.im.ijc.training [6.2 201401301625-423edd2c3d45]


    com.im.ijc.uitesting [6.2 201401301625-423edd2c3d45]


    com.im.ijc.update.pack [6.2 201401301625-423edd2c3d45]


    com.im.ijc.versionprovider [6.2 201401301625-423edd2c3d45]


    com.im.ijc.welcome/1 [6.2 201401301625-423edd2c3d45]


    com.im.ijc.widgets/1 [6.2 201401301625-423edd2c3d45]


    com.im.ijcs.impl.odata/1 [6.2 201401301625-423edd2c3d45]


    com.im.ijcs.server.personal [6.2 201401301625-423edd2c3d45]


    com.im.uiutil [6.2 201401301625-423edd2c3d45]


    com.jacob.com [1.0 201401301625-423edd2c3d45]


    com.jamesmurty.util [0.6 201401301625-423edd2c3d45]


    com.l2fprod.common.swing.outlookbar [1.0 201401301625-423edd2c3d45]


    com.lowagie.iia [2.1.7 201401301625-423edd2c3d45]


    com.michaelbaranov.microba/1 [0.4.4.3 201401301625-423edd2c3d45]


    com.microsoft.sqlserver.jdbc [4.0.2206.100 201401301625-423edd2c3d45]


    com.mysql.jdbc/1 [5.1.13 201401301625-423edd2c3d45]


    it.tidalwave.image [0.9.6.1.1 201401301625-423edd2c3d45]


    net.jcip.annotations [1.0 201401301625-423edd2c3d45]


    net.sf.cglib/1 [2.1.3 201401301625-423edd2c3d45]


    net.sf.jasperreports/1 [5.1.2 201401301625-423edd2c3d45]


    net.sf.jsqlparser/0 [0.7.0.1 201401301625-423edd2c3d45]


    net.sf.log4jdbc [1.2 201401301625-423edd2c3d45]


    oracle.jdbc/1 [11.2.0.3 201401301625-423edd2c3d45]


    org.acegisecurity/1 [3.1.4 201401301625-423edd2c3d45]


    org.aopalliance [1.0 201401301625-423edd2c3d45]


    org.apache.commons.beanutils/1 [1.8.3 201401301625-423edd2c3d45]


    org.apache.commons.codec [1.3.0 1.3.0]


    org.apache.commons.collections/1 [3.2.1 201401301625-423edd2c3d45]


    org.apache.commons.configuration/1 [1.9 201401301625-423edd2c3d45]


    org.apache.commons.dbcp/1 [1.4 201401301625-423edd2c3d45]


    org.apache.commons.digester/1 [2.1 201401301625-423edd2c3d45]


    org.apache.commons.lang [2.4.0 2.4.0]


    org.apache.commons.logging [1.1.0 1.1.0]


    org.apache.commons.pool/1 [1.6 201401301625-423edd2c3d45]


    org.apache.derby/1 [10.10.1.1 201401301625-423edd2c3d45]


    org.apache.http.clinet [1.0 4.1.2 201401301625-423edd2c3d45]


    org.apache.tools.ant/1 [1.8.2 201401301625-423edd2c3d45]


    org.apache.xml.resolver [1.17.1.12 12 a903faa1d680-ijc-patched-9]


    org.ccil.cowan.tagsoup [1.2 201401301625-423edd2c3d45]


    org.codehaus.gpars [1.0.0 201401301625-423edd2c3d45]


    org.custommonkey.xmlunit [1.4 201401301625-423edd2c3d45]


    org.dom4j/1 [1.6.1 201401301625-423edd2c3d45]


    org.eclipse.jdt.core.compiler [5.3.1 201401301625-423edd2c3d45]


    org.fest [1.2 201401301625-423edd2c3d45]


    org.freehep/1 [6.1 201401301625-423edd2c3d45]


    org.jdesktop.layout/1 [1.19.1 a903faa1d680-ijc-patched-9]


    org.jfree.chart [1.0.13.2 201401301625-423edd2c3d45]


    org.mockito [1.8.5 201401301625-423edd2c3d45]


    org.netbeans.api.annotations.common/1 [1.11.1 a903faa1d680-ijc-patched-9]


    org.netbeans.api.java.classpath/1 [1.31.1 a903faa1d680-ijc-patched-9]


    org.netbeans.api.progress/1 [1.26.1 a903faa1d680-ijc-patched-9]


    org.netbeans.api.visual [2.30.1 a903faa1d680-ijc-patched-9]


    org.netbeans.api.xml/1 [1.28.1 a903faa1d680-ijc-patched-9]


    org.netbeans.bootstrap/1 [2.44.5 a903faa1d680-ijc-patched-9]


    org.netbeans.core.execution/1 [1.26.1 a903faa1d680-ijc-patched-9]


    org.netbeans.core.ide/1 [1.26.1 a903faa1d680-ijc-patched-9]


    org.netbeans.core.io.ui/1 [1.14.1 a903faa1d680-ijc-patched-9]


    org.netbeans.core.multiview/1 [1.26.2 a903faa1d680-ijc-patched-9]


    org.netbeans.core.nativeaccess/1 [1.14.1 a903faa1d680-ijc-patched-9]


    org.netbeans.core.netigso [1.12.3 a903faa1d680-ijc-patched-9]


    org.netbeans.core.osgi [1.7.1 a903faa1d680-ijc-patched-9]


    org.netbeans.core.output2/1 [1.24.2 a903faa1d680-ijc-patched-9]


    org.netbeans.core.startup/1 [1.36.1 a903faa1d680-ijc-patched-9]


    org.netbeans.core.ui/1 [1.29.1 a903faa1d680-ijc-patched-9]


    org.netbeans.core.windows/2 [2.41.2 a903faa1d680-ijc-patched-9]


    org.netbeans.core/2 [3.28.1.1 a903faa1d680-ijc-patched-9]


    org.netbeans.insane/1 [1.15.1.1 1 a903faa1d680-ijc-patched-9]


    org.netbeans.libs.felix [2.1.1 a903faa1d680-ijc-patched-9]


    org.netbeans.libs.freemarker/1 [2.17.1.238 238 a903faa1d680-ijc-patched-9]


    org.netbeans.libs.jna/1 [1.16.1 a903faa1d680-ijc-patched-9]


    org.netbeans.libs.junit4 [1.14 a903faa1d680-ijc-patched-9]


    org.netbeans.libs.nbi.ant [1.8.1 a903faa1d680-ijc-patched-9]


    org.netbeans.libs.nbi.engine [1.7.1 a903faa1d680-ijc-patched-9]


    org.netbeans.libs.osgi [1.7.1 a903faa1d680-ijc-patched-9]


    org.netbeans.libs.swingx/1 [1.12.1 a903faa1d680-ijc-patched-9]


    org.netbeans.libs.xerces/1 [1.24.1.280 280 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.apisupport.harness [1.28.1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.applemenu/1 [1.22.2 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.autoupdate.services [1.28.2 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.autoupdate.ui [1.25.1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.db.core [1.21.1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.db.dataview [1.13.1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.db.metadata.model/0 [0.15.1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.db.sql.editor [1.21.1.30 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.db/1 [1.46.1.30 30 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.dbapi [1.19.1.30 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.defaults/1 [1.17.1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.editor.actions/1 [1.13.1.25 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.editor.completion/1 [1.28.1.1 1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.editor.deprecated.pre65formatting/0 [1.6.1.1.5.19.25 1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.editor.fold/1 [1.27.1.25 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.editor.indent/2 [1.26.1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.editor.lib/3 [3.17.1.19.25 19 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.editor.lib2/1 [1.53.2.25 25 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.editor.mimelookup.impl/1 [1.16.1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.editor.mimelookup/1 [1.24.1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.editor.plain.lib/1 [1.19.1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.editor.plain/2 [1.20.1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.editor.settings.storage/1 [1.31.1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.editor.settings/1 [1.38.1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.editor.util/1 [1.45.2 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.editor/3 [1.59.2.5.19.25 5 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.extbrowser/1 [1.26.1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.favorites/1 [1.27.1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.javahelp/1 [2.24.1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.jellytools.platform/3 [3.11.1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.jemmy/3 [3.12.1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.keyring [1.8.1.1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.keyring.impl [1.5.2 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.lexer/2 [1.42.2.1 1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.masterfs/2 [2.34.2 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.nbjunit/1 [1.72.2 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.netbinox [1.24.1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.options.api/1 [1.24.1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.options.keymap [1.16.1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.progress.ui [1.18.1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.project.ant/1 [1.45.1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.project.libraries/1 [1.32.1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.projectapi/1 [1.40.1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.projectui [1.30.1.8 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.projectuiapi/1 [1.53.1.8 8 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.queries/1 [1.25.1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.sendopts/2 [2.15.1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.settings/1 [1.33.1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.spi.actions/1 [1.13.1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.timers/1 [1.16.1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.usersguide/1 [1.34.1 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.utilities/1 [1.42.2 a903faa1d680-ijc-patched-9]


    org.netbeans.modules.xml.catalog/2 [1.26.1.4 4 a903faa1d680-ijc-patched-9]


    org.netbeans.spi.navigator/1 [1.20.1 a903faa1d680-ijc-patched-9]


    org.netbeans.spi.palette/1 [1.29.1 a903faa1d680-ijc-patched-9]


    org.netbeans.spi.quicksearch [1.12.1 a903faa1d680-ijc-patched-9]


    org.netbeans.swing.outline [1.17.2 a903faa1d680-ijc-patched-9]


    org.netbeans.swing.plaf [1.23.1 a903faa1d680-ijc-patched-9]


    org.netbeans.swing.tabcontrol [1.29.1 a903faa1d680-ijc-patched-9]


    org.odata4j [0.7 201401301625-423edd2c3d45]


    org.opends.server [2.4.6 201401301625-423edd2c3d45]


    org.openide.actions [6.24.1 a903faa1d680-ijc-patched-9]


    org.openide.awt [7.39.1 a903faa1d680-ijc-patched-9]


    org.openide.dialogs [7.23.1 a903faa1d680-ijc-patched-9]


    org.openide.execution [1.24.1 a903faa1d680-ijc-patched-9]


    org.openide.explorer [6.40.1 a903faa1d680-ijc-patched-9]


    org.openide.filesystems [7.53.2 a903faa1d680-ijc-patched-9]


    org.openide.io [1.29.1 a903faa1d680-ijc-patched-9]


    org.openide.loaders [7.32.1 a903faa1d680-ijc-patched-9]


    org.openide.modules [7.27.1 a903faa1d680-ijc-patched-9]


    org.openide.nodes [7.25.1 a903faa1d680-ijc-patched-9]


    org.openide.text [6.43.2 a903faa1d680-ijc-patched-9]


    org.openide.util [8.19.1.1 a903faa1d680-ijc-patched-9]


    org.openide.util.lookup [8.11.1 a903faa1d680-ijc-patched-9]


    org.openide.windows [6.48.2 a903faa1d680-ijc-patched-9]


    org.openidex.util/3 [3.32.1 a903faa1d680-ijc-patched-9]


    org.quartz/1 [1.8.4.2 201401301625-423edd2c3d45]


    org.samba.jcifs [1.3.17 201401301625-423edd2c3d45]


    org.slf4j [1.0 201401301625-423edd2c3d45]


    org.springframework.ldap [1.3.1 201401301625-423edd2c3d45]


    org.springframework/1 [3.2.3 201401301625-423edd2c3d45]


    org.xhtmlrenderer [8.0 201401301625-423edd2c3d45]


    swingx/1 [1.6 201401301625-423edd2c3d45]

ChemAxon 2bdd02d1e5

11-06-2014 12:49:14

Hi Adam,


I'm not sure about it. But maybe turning off sql logging helps?


https://docs.chemaxon.com/display/instantjchem063/Reporting+a+Problem#ReportingaProblem-sql


Please let me know the result.


Thanks,
Filip 

ChemAxon 37bb34e128

11-06-2014 13:57:57

Hi Adam,


what exactly do you mean when you say that: "We've installed the appropriate drivers and added them to the class path..."?


There is no need to install the JDBC driver for SQLServer, because IJC already bundles this driver. On the contrary providing this driver on the system wide classpath or anywere on the application classpath will almost certainly lead to a classloader problem. From you description I suspect that "No suitable driver found..." problem is in fact some sort of a classloader issue. Could you please attach here a log file from IJC session where you tried to connect and got the "No suitable driver found..." problem?


Thanks,
-vita