Meine Application stelle über die JDBC - ODBC Bridge eine Verbindung zu einem SQL Server 7.0 her.<BR> Danach versuche ich mit meiner SQL Anweisung Daten herauszulesen, was mir jedoch eine Fehlermeldung (Invalid object name ...) bringt!<BR>Hat jemand eine Idee, was falsch ist.
***** Hier ist der Programm Code **************************************
<PRE>
import java.sql.*;
class GetNikuInfos
{
public void getInfos()
{
try
{
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ).newInstance();
DriverManager.setLogStream(System.out);
}
catch ( Exception e ) {
System.out.println(e.toString());
System.out.println( "ODBC- JDBC- Bridge failure!" );
return;
}
Connection dbConn;
Statement sqlStmt;
ResultSet rSet1;
ResultSet rSet2;
// Connecting to the database
try
{
String URL = "jdbcdbc:NikuABT";
dbConn = DriverManager.getConnection( URL, "ABTReporter", "ABTReporter" );
sqlStmt = dbConn.createStatement();
String strSQL1 = "SELECT Count([dbo_PRResource.prID].[prID]) AS ResourceCount FROM (dbo_PRTeam INNER JOIN dbo_PRProject ON dbo_PRTeam.prProjectID = dbo_PRProject.prID) INNER JOIN dbo_PRResource ON dbo_PRTeam.prResourceID = dbo_PRResource.prID WHERE (((dbo_PRResource.prType)=0) AND ((dbo_PRProject.prID)=155 Or (dbo_PRProject.prID)=345 Or (dbo_PRProject.prID)=402))";
rSet1 = sqlStmt.executeQuery( strSQL1 );
}
catch ( Exception e ) {
System.out.println( e.toString());
System.out.println( "DATA BASE ACCESS failure!" );
return;
}
Results re = new Results();
try
{
sqlStmt.close();
dbConn.close();
}
catch ( Exception e ) {
System.out.println( "TABLE-TEST failure!" );
return;
}
}
}
</PRE>
***** Hier ist der Programm Code **************************************
<PRE>
import java.sql.*;
class GetNikuInfos
{
public void getInfos()
{
try
{
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ).newInstance();
DriverManager.setLogStream(System.out);
}
catch ( Exception e ) {
System.out.println(e.toString());
System.out.println( "ODBC- JDBC- Bridge failure!" );
return;
}
Connection dbConn;
Statement sqlStmt;
ResultSet rSet1;
ResultSet rSet2;
// Connecting to the database
try
{
String URL = "jdbcdbc:NikuABT";
dbConn = DriverManager.getConnection( URL, "ABTReporter", "ABTReporter" );
sqlStmt = dbConn.createStatement();
String strSQL1 = "SELECT Count([dbo_PRResource.prID].[prID]) AS ResourceCount FROM (dbo_PRTeam INNER JOIN dbo_PRProject ON dbo_PRTeam.prProjectID = dbo_PRProject.prID) INNER JOIN dbo_PRResource ON dbo_PRTeam.prResourceID = dbo_PRResource.prID WHERE (((dbo_PRResource.prType)=0) AND ((dbo_PRProject.prID)=155 Or (dbo_PRProject.prID)=345 Or (dbo_PRProject.prID)=402))";
rSet1 = sqlStmt.executeQuery( strSQL1 );
}
catch ( Exception e ) {
System.out.println( e.toString());
System.out.println( "DATA BASE ACCESS failure!" );
return;
}
Results re = new Results();
try
{
sqlStmt.close();
dbConn.close();
}
catch ( Exception e ) {
System.out.println( "TABLE-TEST failure!" );
return;
}
}
}
</PRE>
Comment