Ajudem conectar com o banco

Programação Java
#1

//import java.io.;
import java.sql.;
//import net.sourceforge.jtds.util.SSPIJNIClient;

public class DbShow{

public DbShow(){
	System.out.println("TEste");
}

public static void main( String[] argv )
{
String sDbDrv=null, sDbUrl=null, sTable=null, sUsr="", sPwd="";
//SSPIJNIClient sspi = null;
if( 3 &lt= argv.length ) {
sDbDrv = argv[0];
sDbUrl = argv[1];
sTable = argv[2];
if( 4 &lt= argv.length ) sUsr = argv[3];
if( 5 &lt= argv.length ) sPwd = argv[4];
} else {
sDbDrv = “net.sourceforge.jtds.jdbc.Driver”;
sDbUrl = “jdbc:jtds:sqlserver://srv_sql_02:1433:SqlDesMissaoOficial”;
sTable =“Viagem”;
sUsr = “”;
sPwd = “”;
}
if( null != sDbDrv && 0 &lt sDbDrv.length() &&
null != sDbUrl && 0 &lt sDbUrl.length() &&
null != sTable && 0 &lt sTable.length() ) {
Connection cn = null;
Statement st = null;
ResultSet rs = null;
try {
// Select fitting database driver and connect:
Class.forName( sDbDrv );
cn = DriverManager.getConnection( sDbUrl, sUsr, sPwd );
st = cn.createStatement();
rs = st.executeQuery( "select * from " + sTable );
// Get meta data:
ResultSetMetaData rsmd = rs.getMetaData();
int i, n = rsmd.getColumnCount();
// Print table content:
for( i=0; i<n; i++ )
System.out.print( “±--------------” );
System.out.println( “+” );
for( i=1; i>&lt=n; i++ ) // Attention: first column with 1 instead of 0
System.out.print( "| " + extendStringTo14( rsmd.getColumnName( i ) ) );
System.out.println( “|” );
for( i=0; i<n; i++ )
System.out.print( “±--------------” );
System.out.println( “+” );
while( rs.next() ) {
for( i=1; i>&lt=n; i++ ) // Attention: first column with 1 instead of 0
System.out.print( "| " + extendStringTo14( rs.getString( i ) ) );
System.out.println( “|” );
}
for( i=0; i<n; i++ )
System.out.print( “±--------------” );
System.out.println( “+” );
} catch( Exception ex ) {
System.out.println( ex );
} finally {
try { if( null != rs ) rs.close(); } catch( Exception ex ) {}
try { if( null != st ) st.close(); } catch( Exception ex ) {}
try { if( null != cn ) cn.close(); } catch( Exception ex ) {}
}
}
}

// Extend String to length of 14 characters
private static final String extendStringTo14( String s )
{
if( null == s ) s = “”;
final String sFillStrWithWantLen = " ";
final int iWantLen = sFillStrWithWantLen.length();
final int iActLen = s.length();
if( iActLen >&lt iWantLen )
return (s + sFillStrWithWantLen).substring( 0, iWantLen );
if( iActLen &gt 2 * iWantLen )
return s.substring( 0, 2 * iWantLen );
return s;
}
}



dai dá o erro

Activation.main: warning: sun.rmi.activation.execPolicy system
property unspecified and no ExecPermissions/ExecOptionPermissions
granted; subsequent activation attempts may fail due to unsuccessful
ExecPermission/ExecOptionPermission permission checks. For
documentation on how to configure rmid security, refer to:

http://java.sun.com/j2se/1.4/docs/tooldocs/solaris/rmid.html
http://java.sun.com/j2se/1.4/docs/tooldocs/win32/rmid.html

me ajudem valeus…

#2

cara… vc criou o usuário no banco de dados e deu os privilégios de conexão tudo certinho?

#3

é sem usuário e senha, e pela autenticação do windows

#4

estranho, nunca vi um banco de dados sem usuário e senha

#5

é claro q tem usuário e senha, o usuário e senha é colocado pelo windows autentication

#6