Phil Owens

Greenhorn
+ Follow
since Sep 15, 2000
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Phil Owens

Get an instance of a Database, then with that get a Connection instance, then with that get a Statment instance. Then put some SQL in the statement, use column names or numbers. ExecuteQuery on that baby and shove the output into a ResultSet. Get the info from the result set by column number, similar to the way Staement works. Simple eh?
-Phil
The method that creates the database connection must THROW a SQLException, and maybe an IOException from the sounds of your error message. Be sure to catch it somewhere as well!
Try something like this:
public Database() throws SQLException, IOException {
//do work
}
// end method

-Phil
MS Access supports calls to stored procedurea, but the stored procedure itself must be kept in a true SQL Database such as MS SQL Server. Basically you need SQL Server to use stored procedures with your Access database. So you gotta have both. The question then becomes why Access at all?
Phil
When does the problem occur? DUring what operation? Have you isolated that? Is the column reference refering to a ResultSet or ResultSetMetaData? Or is it a Statment, Prepared Statement, or Callable Statement? Where in your code does the error happen?
Phil