Hi
I'm trying to import the sql server jdbc driver into my project.
I right clicked my project and clicked import selected the sqljdbc4.jar file
and imported it into the src directory.
My code is below but when it gets to Class.forName(driver).newInstance(); it
gives an error
java.lang.ClassNotFoundException:
com.microsoft.sqlserver.jdbc.SQLServerDriver.class
What am i doing wrong? did I import it wrong?
if i type com.microsoft.sqlserver.jdbc.SQLServerDriver.class into the ide it
doesnt complain so the file is there.
Any help would be great.
Thanks
package com.boozel.mobiletrend;
import java.sql.Connection;
import java.sql.DriverManager;
import android.app.Activity;
import android.content.Intent;
import android.content.SharedPreferences;
import android.os.Bundle;
import android.util.Log;
import android.view.Menu;
import android.view.MenuInflater;
import android.view.MenuItem;
import android.widget.TextView;
//import com.microsoft.sqlserver.jdbc.*;
public class MobileTrendActivity extends Activity {
SharedPreferences sharedPreferences;
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
sharedPreferences = getSharedPreferences("MobileTrend", 0);
}
@Override
public boolean onCreateOptionsMenu(Menu menu) {
MenuInflater inflater = getMenuInflater();
inflater.inflate(R.xml.mainmenu, menu);
return true;
}
@Override
public boolean onOptionsItemSelected(MenuItem item) {
// Handle item selection
switch (item.getItemId()) {
case R.id.settings:
Intent myIntent = new Intent(MobileTrendActivity.this,
Settings.class);
MobileTrendActivity.this.startActivity(myIntent);
return true;
case R.id.connect:
query();
return true;
default:
return super.onOptionsItemSelected(item);
}
}
public void query()
{
Log.i("MobileTrend","MySQL Connect Example.");
Connection conn = null;
String url =
sharedPreferences.getString("url","jdbc:microsoft:sqlserver://localhost:1433");
outputToConsole("Using URL: "+url);
String dbName = sharedPreferences.getString("dbname","jdbctutorial");
outputToConsole("Using DB Name: "+dbName);
String driver =
sharedPreferences.getString("driver","com.microsoft.sqlserver.jdbc.SQLServerDriver");
outputToConsole("Using Driver: "+driver);
String userName = sharedPreferences.getString("username","root");
outputToConsole("Using UserName: "+userName);
String password = sharedPreferences.getString("password","root");
outputToConsole("Using Password: "+password);
try {
outputToConsole("Attempting to connect...");
Class.forName(driver).newInstance();
//test = com.microsoft.sqlserver.jdbc.SQLServerDriver.class;
outputToConsole("Driver Instance Created");
String connString = url +
";databaseName="+dbName+";user="+userName+";password="+password+";";
outputToConsole("Connection String: "+connString);
conn = DriverManager.getConnection(connString);
//conn = DriverManager.getConnection(url+dbName,userName,password);
outputToConsole("Connected to the database");
conn.close();
outputToConsole("Disconnected from database");
} catch (Exception e)
{ outputToConsole("ERROR: "+e);
e.printStackTrace();
}
}
public void outputToConsole(String message)
{
TextView tv = (TextView)findViewById(R.id.output);
tv.append(message+"\n");
Log.i("MobileTrend",message);
}
}
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
