An error on search table.

[TurboDisk]

Hello,I am a fresh man to study the DB2.An error occured when I try to
Run a Java class.

Details of the Error:

Code:
--------------------

com.ibm.db2.jcc .b.SqlException :DB2 SQL error:SQLCODE:-204,SQLSTATE:42 704, SQLERRMC :DB2ADMIN.TEST

--------------------
Following is the source:

Code:
--------------------

/*
* JDB2.java
*
* Created on 2006
*
* To change this template, choose Tools | Template Manager
* and open the template in the editor.
*/

/**
*
* @author Administrator
*/
import java.sql.*;
public class JDB2{
//Create the main method
public static void main(String args[]){
//Load JDBC Driver
String Driver="com.ibm .db2.jcc.DB2Dri ver";
//Create the URL
String Url="jdbc:db2://localhost:50000/BD";
//Use the Class.forName
try{
Class.forName(D river).newInsta nce();
}catch (Exception e){
System.out.prin tln(e);
}
//Create Connection
System.out.prin tln("Conneting. ..");
try{
Connection conn=DriverMana ger.getConnecti on(Url,"db2admi n","830401") ;

Statement stmt=conn.creat eStatement();
ResultSet rs=stmt.execute Query("select * from test");
while(rs.next() ) {
int ID=rs.getInt("i d");
String NAME=rs.getStri ng("name");
System.out.prin tln("ID"+"\t\t" +"NAME");
System.out.prin tln(ID+"\t\t"+N AME);
}
}catch(SQLExcep tion sqle){
System.err.prin tln(sqle);
}

}
}
--------------------
--
TurboDisk
------------------------------------------------------------------------
TurboDisk's Profile: http://www.dbtalk.net/m197
View this thread: http://www.dbtalk.net/t300860

[situ]

may be you are refering to the object which does not exist,
check out the table and column name you are useing

[Gert van der Kooij]

In article <11************ *********@u72g2 000cwu.googlegr oups.com>,
SR********@REDI FFMAIL.COM says...

may be you are refering to the object which does not exist,
check out the table and column name you are useing

And also the table prefix. It defaults to the name of the user used in
the connect statement.

[TurboDisk]

Thanks to everybody.But I don't know how to modify it.
--
TurboDisk
------------------------------------------------------------------------
TurboDisk's Profile: http://www.dbtalk.net/m197
View this thread: http://www.dbtalk.net/t300860

[Phil Sherman]

Change your SQL statement in the program to:
select count(*) from syscat.tables
or
values(current timestamp)

The second will always return a row while the first verifies that your
connection has read access to the database catalog tables.

Your connect statement includes the userid and password. The full table
name you are accessing is "db2admin.test" . If you created the table from
a connection using your own userid, then you need to use your userid and
password in the connect statement or use:
select * from userid.test

I'd suggest reading a good primer book on db2 to learn about the basics.

Phil Sherman

TurboDisk wrote:

Hello,I am a fresh man to study the DB2.An error occured when I try to
Run a Java class.

Details of the Error:

Code:
--------------------

com.ibm.db2.jcc .b.SqlException :DB2 SQL error:SQLCODE:-204,SQLSTATE:42 704, SQLERRMC :DB2ADMIN.TEST

--------------------
Following is the source:

Code:
--------------------

/*
* JDB2.java
*
* Created on 2006
*
* To change this template, choose Tools | Template Manager
* and open the template in the editor.
*/

/**
*
* @author Administrator
*/
import java.sql.*;
public class JDB2{
//Create the main method
public static void main(String args[]){
//Load JDBC Driver
String Driver="com.ibm .db2.jcc.DB2Dri ver";
//Create the URL
String Url="jdbc:db2://localhost:50000/BD";
//Use the Class.forName
try{
Class.forName(D river).newInsta nce();
}catch (Exception e){
System.out.prin tln(e);
}
//Create Connection
System.out.prin tln("Conneting. ..");
try{
Connection conn=DriverMana ger.getConnecti on(Url,"db2admi n","830401") ;

Statement stmt=conn.creat eStatement();
ResultSet rs=stmt.execute Query("select * from test");
while(rs.next() ) {
int ID=rs.getInt("i d");
String NAME=rs.getStri ng("name");
System.out.prin tln("ID"+"\t\t" +"NAME");
System.out.prin tln(ID+"\t\t"+N AME);
}
}catch(SQLExcep tion sqle){
System.err.prin tln(sqle);
}

}
}
--------------------

[TurboDisk]

Thanks very much Phil.Thanks very much everybody.
--
TurboDisk
------------------------------------------------------------------------
TurboDisk's Profile: http://www.dbtalk.net/m197
View this thread: http://www.dbtalk.net/t300860