Witam,
środowisko: NetBeans,
system: Linux (OpenSuse)
mam sobie taki kawałek kodu - output:
Connection conn = null;
String url = "jdbc//localhost:3306/";
String dbName = "car_databases";
String driver = "com.mysql.jdbc.Driver";
String userName = "root";
String UserPassword = "mrrr";
try {
Class.forName(driver).newInstance();
}catch(Exception e) {
System.err.println("Blad wczytywania sterownika");
}
try{
conn = DriverManager.getConnection(url+dbName,userName,UserPassword);
System.out.println("Connected to the database");
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("SELECT * FROM CAR");
while (rs.next()) {
System.out.println(rs.getString(1) + " " + rs.getString(2));
}
conn.close();
}catch(Exception e) {
e.printStackTrace();
}
debug -output:
Blad wczytywania sterownika
java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/car_databases
at java.sql.DriverManager.getConnection(DriverManager.java:640)
at java.sql.DriverManager.getConnection(DriverManager.java:200)
at simplyapp_wsinf_databases.SimplyApp_WSINF_databasesView.logon(SimplyApp_WSINF_databasesView.java:245)
at simplyapp_wsinf_databases.SimplyApp_WSINF_databasesView.jButton1ActionPerformed(SimplyApp_WSINF_databasesView.java:229)
at simplyapp_wsinf_databases.SimplyApp_WSINF_databasesView.access$800(SimplyApp_WSINF_databasesView.java:29)
at simplyapp_wsinf_databases.SimplyApp_WSINF_databasesView$4.actionPerformed(SimplyApp_WSINF_databasesView.java:141)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2012)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2335)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:404)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:253)
at java.awt.Component.processMouseEvent(Component.java:6108)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
at java.awt.Component.processEvent(Component.java:5873)
at java.awt.Container.processEvent(Container.java:2105)
at java.awt.Component.dispatchEventImpl(Component.java:4469)
at java.awt.Container.dispatchEventImpl(Container.java:2163)
at java.awt.Component.dispatchEvent(Component.java:4295)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4461)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4125)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4055)
at java.awt.Container.dispatchEventImpl(Container.java:2149)
at java.awt.Window.dispatchEventImpl(Window.java:2478)
at java.awt.Component.dispatchEvent(Component.java:4295)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:604)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:275)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:200)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:190)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:185)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:177)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:138)
BUILD SUCCESSFUL (total time: 9 seconds)
Jak widać nie mogę załadować sterownika JDBC pytanie czemu? Co dziwniejsze w zakładce 'Services' (ctrl+5) połączenie 'wykonuje' się bez najmniejszego problemu. Prosiłbym o jakiekolwiek wskazówki. Wujek google podpowiadał o zmiennej %path% aczkolwiek odnosiło się to do Windowsa (którego nie posiadam i nie mogę przetestować).
pozdrawiam.