T
timorzrz
¡Usuario con pocos negocios! ¡Utiliza siempre saldo de Forobeta!
Tengo un tiempo tratando de conectar una Aplicacion Android con Sql Server 2008, he resuelto varios problemas que se presentan pero hay un error mas que no he podido.
Este es mi codigo para conectar
public class SismpleDAO {
String direccion ="jdbc:jtds:sqlserver://172.16.21.142:1433/Timo;encrypt=false;user=Aereo;password=Aereo6;";
String user = "USER";
String pass = "PASSWORD";
String driver = "net.sourceforge.jtds.jdbc.Driver";
public ResultSet construirLector(String query) {
ResultSet result = null;
try {
Class.forName(driver);
Connection conn = DriverManager.getConnection(direccion, user, pass);
Statement statement = conn.createStatement();
result = statement.executeQuery(query);
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e){
e.printStackTrace();
}
return result;
}
}
Esta es la consulta
public class NoticiasDAO extends SismpleDAO {
private static NoticiasDAO ourInstance = null;
private NoticiasDAO() {
}
public static NoticiasDAO getInstance() {
if(ourInstance == null)
ourInstance = new NoticiasDAO();
return ourInstance;
}
public String getNoticias(int id){
String result = "";
//String query = "SELECT TOP 1 titulo AS Titulo FROM articulos WHERE id_articulo="+id+"";
String query = "SELECT TOP 1 titulo AS Titulo FROM Articulos WHERE id_articulo="+id+"";
ResultSet rs = super.construirLector(query);
try{
if(rs!=null) {
while (rs.next())
result = rs.getString("Titulo");
}else
Log.v("msj","no hay consulta");
}catch (SQLException e){
e.printStackTrace();
}
return result;
}
}
Esta es la llamada de esas clases en el main principal.
public class Noticias extends Activity {
TextView t_noticia1;
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.noticias);
t_noticia1 = (TextView)findViewById(R.id.txt_descripcion_1_noticias);
new obtener_datos().execute(1);
}
private class obtener_datos extends AsyncTask<Integer, Void, String> {
[MENTION=42437]over[/MENTION]ride
protected String doInBackground(Integer... params) {
//FUNCIONA CON LAS CLASES SISMPLE Y NOTICIAS DAO
return NoticiasDAO.getInstance().getNoticias(params[0]);
}
[MENTION=42437]over[/MENTION]ride
protected void onPostExecute(String s) {
t_noticia1.setText(s.toString());
super.onPostExecute(s);
}
}
El ERROR que me manda es este:
I/dalvikvm﹕ Could not find method org.ietf.jgss.GSSManager.getInstance, referenced from method net.sourceforge.jtds.jdbc.TdsCore.createGssToken.
W/dalvikvm﹕ VFY: unable to resolve static method 12084: Lorg/ietf/jgss/GSSManager;.getInstance ()Lorg/ietf/jgss/GSSManager;
POR FAVOR ALGUIEN ME PUEDE AYUDAR
Este es mi codigo para conectar
public class SismpleDAO {
String direccion ="jdbc:jtds:sqlserver://172.16.21.142:1433/Timo;encrypt=false;user=Aereo;password=Aereo6;";
String user = "USER";
String pass = "PASSWORD";
String driver = "net.sourceforge.jtds.jdbc.Driver";
public ResultSet construirLector(String query) {
ResultSet result = null;
try {
Class.forName(driver);
Connection conn = DriverManager.getConnection(direccion, user, pass);
Statement statement = conn.createStatement();
result = statement.executeQuery(query);
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e){
e.printStackTrace();
}
return result;
}
}
Esta es la consulta
public class NoticiasDAO extends SismpleDAO {
private static NoticiasDAO ourInstance = null;
private NoticiasDAO() {
}
public static NoticiasDAO getInstance() {
if(ourInstance == null)
ourInstance = new NoticiasDAO();
return ourInstance;
}
public String getNoticias(int id){
String result = "";
//String query = "SELECT TOP 1 titulo AS Titulo FROM articulos WHERE id_articulo="+id+"";
String query = "SELECT TOP 1 titulo AS Titulo FROM Articulos WHERE id_articulo="+id+"";
ResultSet rs = super.construirLector(query);
try{
if(rs!=null) {
while (rs.next())
result = rs.getString("Titulo");
}else
Log.v("msj","no hay consulta");
}catch (SQLException e){
e.printStackTrace();
}
return result;
}
}
Esta es la llamada de esas clases en el main principal.
public class Noticias extends Activity {
TextView t_noticia1;
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.noticias);
t_noticia1 = (TextView)findViewById(R.id.txt_descripcion_1_noticias);
new obtener_datos().execute(1);
}
private class obtener_datos extends AsyncTask<Integer, Void, String> {
[MENTION=42437]over[/MENTION]ride
protected String doInBackground(Integer... params) {
//FUNCIONA CON LAS CLASES SISMPLE Y NOTICIAS DAO
return NoticiasDAO.getInstance().getNoticias(params[0]);
}
[MENTION=42437]over[/MENTION]ride
protected void onPostExecute(String s) {
t_noticia1.setText(s.toString());
super.onPostExecute(s);
}
}
El ERROR que me manda es este:
I/dalvikvm﹕ Could not find method org.ietf.jgss.GSSManager.getInstance, referenced from method net.sourceforge.jtds.jdbc.TdsCore.createGssToken.
W/dalvikvm﹕ VFY: unable to resolve static method 12084: Lorg/ietf/jgss/GSSManager;.getInstance ()Lorg/ietf/jgss/GSSManager;
POR FAVOR ALGUIEN ME PUEDE AYUDAR