[ https://issues.apache.org/jira/browse/DBUTILS-96?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13423859#comment-13423859 ]
Simone Tripodi commented on DBUTILS-96: --------------------------------------- Could you please attach a zip/tar/whatever program that reproduces the issue, rather than pasting the code? TIA! > dynamic load jdbc jars use Dbutils,it say No suitable driver found for jdbc > ---------------------------------------------------------------------------- > > Key: DBUTILS-96 > URL: https://issues.apache.org/jira/browse/DBUTILS-96 > Project: Commons DbUtils > Issue Type: Bug > Environment: jdk 1.6 > Reporter: yuyf > > By this way(use Dbutil get connect),it will say:No suitable driver found for > jdbc:mysql://127.0.0.1:3306/xxx > urls = new URL[1]; > urls[0] = new File("d:\mysql_connector_5.1.15_bin.jar").toURL(); > URLClassLoader urlClassLoader= new > URLClassLoader(urls,ClassLoader.getSystemClassLoader()) > DbUtils.loadDriver(urlClassLoader,driver); > Properties conProps = new Properties(); > conProps.put("user", user); > conProps.put("password", pwd); > conProps.put("defaultRowPrefetch", "20"); > scanedConnection = DriverManager.getConnection(url, conProps); > but by this way (use jdbc's api get connect),it's ok > try { > URL jdbcDriverURL = new File("d:\\mysql_connector_5.1.15_bin.jar").toURL(); > URL[] urls = new URL[1]; > urls[0] = jdbcDriverURL; > URLClassLoader urlclassLoader = new > URLClassLoader(urls,ClassLoader.getSystemClassLoader()); > try { > java.sql.Driver driverd = (java.sql.Driver) > urlclassLoader.loadClass(driver).newInstance(); > System.out.println(driverd.toString()); > Properties props = new Properties(); > props.setProperty("user", theUser); > props.setProperty("password", thePw); > try { > c = driverd.connect(dbUrl, props); > } catch (SQLException e) { > // TODO Auto-generated catch block > e.printStackTrace(); > } > } catch (InstantiationException e) { > // TODO Auto-generated catch block > e.printStackTrace(); > } catch (IllegalAccessException e) { > // TODO Auto-generated catch block > e.printStackTrace(); > }// > } catch (MalformedURLException e1) { > // TODO Auto-generated catch block > e1.printStackTrace(); > } > is this a bug or my useing falut? -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira