Data source name not found, and no default driver specified

On Thu, 03 Jul 2008 00:46:28 +0000, thufir wrote:


I changed to ODBC to be more in line with the Sun tutorial.

as per https://help.ubuntu.com/community/ODBC I configured ODBC for Java
(correctly, I think).

I didn't find much informatin on this error, so I'll probably revisit the
MySQL approach, which looked to be a classpath problem.

thufir@arrakis:~/NetBeansProjects/ubuntu-jdbc/src$
thufir@arrakis:~/NetBeansProjects/ubuntu-jdbc/src$ javac a00720398/
DBDemo.java
thufir@arrakis:~/NetBeansProjects/ubuntu-jdbc/src$
thufir@arrakis:~/NetBeansProjects/ubuntu-jdbc/src$ java a00720398.DBDemo
Exception in thread "main" java.sql.SQLException: [unixODBC][Driver
Manager]Data source name not found, and no default driver specified
    at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
    at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
    at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3073)
    at sun.jdbc.odbc.JdbcOdbcConnection.initialize
(JdbcOdbcConnection.java:323)
    at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)
    at java.sql.DriverManager.getConnection(DriverManager.java:582)
    at java.sql.DriverManager.getConnection(DriverManager.java:154)
    at a00720398.DBDemo.main(DBDemo.java:20)
thufir@arrakis:~/NetBeansProjects/ubuntu-jdbc/src$
thufir@arrakis:~/NetBeansProjects/ubuntu-jdbc/src$ cat a00720398/
DBDemo.java
package a00720398;

import java.sql.*;
import java.util.Properties;

public class DBDemo {

    private static final String CONNECTION =
"sun.jdbc.odbc.JdbcOdbcDriver";
    private static final String URL = "jdbc:odbc:COFFEEBREAK";

    public static void main(String[] args) throws ClassNotFoundException,
SQLException {

        Class.forName(CONNECTION);

        Properties p = new Properties();
        p.put("user", "java");
        p.put("password", "password");

        //[unixODBC][Driver Manager]Data source name not found, and no
default driver specified
        Connection c = DriverManager.getConnection(URL, p);

        c.close();

        System.out.println("It works !");
        c.close();
    }
}
thufir@arrakis:~/NetBeansProjects/ubuntu-jdbc/src$
thufir@arrakis:~/NetBeansProjects/ubuntu-jdbc/src$ cat /etc/odbc.ini
[ODBC Data Sources]
odbcname = MyODBC 3.51 Driver DSN

[odbcname]
Driver = /usr/lib/odbc/libmyodbc.so
Description = MyODBC 3.51 Driver DSN
SERVER = localhost
PORT =
USER = java
Password = password
Database = COFFEEBREAK
OPTION = 3
SOCKET =

[Default]
Driver = /usr/local/lib/libmyodbc3.so
Description = MyODBC 3.51 Driver DSN
SERVER = localhost
PORT =
USER = java
Password = password
Database = COFFEEBREAK
OPTION = 3
SOCKET =
thufir@arrakis:~/NetBeansProjects/ubuntu-jdbc/src$
thufir@arrakis:~/NetBeansProjects/ubuntu-jdbc/src$ mysql -u java -
ppassword
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 5.0.51a-3ubuntu5.1 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use COFFEEBREAK;
Database changed
mysql>
mysql> quit
Bye
thufir@arrakis:~/NetBeansProjects/ubuntu-jdbc/src$

thanks,

Thufir