Access

nogono · #1 (**permalink**) 11-17-2007, 06:45 PM

When i am tryin to connect my java program to MySql database...it is showing following error:

Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial

...............................................
See the following code and let me know if anything is incomplete or any error

Context initCtx =

new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
DataSource ds = (DataSource) envCtx.lookup("jdbc/Authentication");
conn = ds.getConnection();

System.out.println ("Database connection established");

HelloWorld · #2 (**permalink**) 11-17-2007, 06:51 PM

I'm not sure with what you're doing, but you need to have something like this:

PHP Code:

  private String bnDbDriver = "org.gjt.mm.mysql.Driver"; //Driver for your database
private String bnDbId = "jdbc:mysql://localhost/dbname"; //database name
private String bnDbUser = "username"; // your username
private String bnDbPassword = "password" //your password

//******************
//GET THE CONNECTION
//******************
Class.forName(bnDbDriver);
Connection myConnection = DriverManager.getConnection(bnDbId, bnDbUser, bnDbPassword);

//YOU SQL STATEMENT
Statement myStatement = myConnection.createStatement();
String sqlQuery = "YOR SQL STATEMENT";
myStatement.executeQuery(sqlQuery);

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

The Following User Says Thank You to HelloWorld For This Useful Post:
ccoonen (11-18-2007)