aspose file tools*
The moose likes JDBC and the fly likes unable to run the code. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "unable to run the code." Watch "unable to run the code." New topic
Author

unable to run the code.

Jigeshs Shahs
Greenhorn

Joined: May 28, 2009
Posts: 26
unable to run this code and cant figure out why???
please help.new to JDBC

code compiles correctly but doesnt run properly

databsase structure
id ->number
name--> varchar
pwd -->varchar


try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c = DriverManager.getConnection("jdbcdbc:stud");
s = c.createStatement();

int b;





ResultSet rs=s.executeQuery("select * from abc");

ResultSetMetaData rsm=rs.getMetaData();

int col=rsm.getColumnCount();

while(rs.next())
{

for(b=1;b<=col;b++);
{
ta.append(rs.getString(b).trim()+ "\t\t");

}
ta.append("\n");
}






}
catch(Exception d)
{
d.printStackTrace();
}


}
Sagar Rohankar
Ranch Hand

Joined: Feb 19, 2008
Posts: 2902
    
    1

Jigeshs Shahs wrote:unable to run this code and cant figure out why???
code compiles correctly but doesnt run properly

I didn't look at your code, because its not properly quoted using CODE tag.
And telling "it doesn't run properly" convey nothing, have a look at this for what I want to say.
ItDoesntWorkIsUseless


[LEARNING bLOG] | [Freelance Web Designer] | [and "Rohan" is part of my surname]
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 36486
    
  16
Read this. Tell us what happens, otherwise we can't help you.
Jigeshs Shahs
Greenhorn

Joined: May 28, 2009
Posts: 26
the code compiles fine but throws a runtime exception.
it connects to the database properly...
the only problem I see here is when its extracts the data from ResultSetMetaData.
i ve marked that code "red" where its showing error...
so if anybody has any idea........please help
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 39547
    
  27
Unfortunately we can't see your desktop remotely, so you'll have to tell us the error message you're getting, complete with stack trace.


Ping & DNS - updated with new look and Ping home screen widget
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: unable to run the code.
 
Similar Threads
All the overriden equals!
Please help with JTextArea problem...
illegal start of type & identifier expected
multi threads
JTable GridLines - removing lines from certain cells