Search...
FAQs
Subscribe
Pie
FAQs
Recent topics
Flagged topics
Hot topics
Best topics
Search...
Search within JDBC and Relational Databases
Search Coderanch
Advance search
Google search
Register / Login
Post Reply
Bookmark Topic
Watch Topic
New Topic
programming forums
Java
Mobile
Certification
Databases
Caching
Books
Engineering
Micro Controllers
OS
Languages
Paradigms
IDEs
Build Tools
Frameworks
Application Servers
Open Source
This Site
Careers
Other
Pie Elite
all forums
this forum made possible by our volunteer staff, including ...
Marshals:
Tim Cooke
Campbell Ritchie
paul wheaton
Ron McLeod
Devaka Cooray
Sheriffs:
Jeanne Boyarsky
Liutauras Vilda
Paul Clapham
Saloon Keepers:
Tim Holloway
Carey Brown
Piet Souris
Bartenders:
Forum:
JDBC and Relational Databases
Data source name not found
Nicholas Lefebvre
Greenhorn
Posts: 23
posted 11 years ago
Number of slices to send:
Optional 'thank-you' note:
Send
I am making a database to store information on people who are competing in a competition. I have created my database in access. When i run my code i get this error
Oct 29, 2013 8:37:18 PM DBConnect <init> SEVERE: null java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6956) at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7113) at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3072) 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:579) at java.sql.DriverManager.getConnection(DriverManager.java:221) at DBConnect.<init>(DBConnect.java:38) at DBConnect.main(DBConnect.java:89) Exception in thread "main" java.lang.NullPointerException at DBConnect.<init>(DBConnect.java:43) at DBConnect.main(DBConnect.java:89) Java Result: 1 BUILD SUCCESSFUL (total time: 0 seconds)
This is my code.
import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.SQLException; import java.sql.Statement; import java.util.logging.Level; import java.util.logging.Logger; /* * To change this template, choose Tools | Templates * and open the template in the editor. */ /** * * @author Thinus.bothma */ public class DBConnect { private Connection connection; private Statement masterStatement; private ResultSet masterResultSet; private String[] masterColumnData; public DBConnect() { try { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); } catch ( InstantiationException | IllegalAccessException ex) { Logger.getLogger(DBConnect.class.getName()).log(Level.SEVERE, null, ex); } } catch (ClassNotFoundException ex) { Logger.getLogger(DBConnect.class.getName()).log(Level.SEVERE, null, ex); } String database = "jdbc:odbc:Driver={Microsoft Access Driver (.mdb)};DBQ=Database41.mdb"; try { connection = DriverManager.getConnection( database ,"",""); } catch (SQLException ex) { Logger.getLogger(DBConnect.class.getName()).log(Level.SEVERE, null, ex); } try { masterStatement = connection.createStatement(); } catch (SQLException ex) { Logger.getLogger(DBConnect.class.getName()).log(Level.SEVERE, null, ex); } try { boolean foundResults = masterStatement.execute("SELECT * FROM Table12"); if(foundResults==true){ masterResultSet = masterStatement.getResultSet(); }else { connection.close(); } } catch (SQLException ex) { Logger.getLogger(DBConnect.class.getName()).log(Level.SEVERE, null, ex); } try { ResultSetMetaData metaData = masterResultSet.getMetaData(); int columns=metaData.getColumnCount(); masterColumnData= new String[columns]; for(int i=0;i<columns;++i){ masterColumnData[i]=metaData.getColumnName(i+1); }//end of for String text=""; int countRows=0; while(masterResultSet.next()){ countRows++; for(int i=0;i<columns;++i) { String txt=masterResultSet.getString(i+1); text+=txt+" "; } //end of for text+="\n"; text=text+"\n"; } //end of while } catch (SQLException ex) { Logger.getLogger(DBConnect.class.getName()).log(Level.SEVERE, null, ex); } try { connection.close(); } catch (SQLException ex) { Logger.getLogger(DBConnect.class.getName()).log(Level.SEVERE, null, ex); } }//DBConnect() public static void main(String[] args){ new DBConnect(); }//main() }//DBConnect
reply
reply
Bookmark Topic
Watch Topic
New Topic
Boost this thread!
Similar Threads
java.lang.StringIndexOutOfBoundsException: String index out of range: -1
jdbc with as400
Please Help:Access to Sql Server from servlet
exception while running my first jdbc code
Connecting to DB Error
More...