Search:

Yeah, sorry about that. The compiler doesn't tell me what the line numbers are, but a few well-placed test print statements indicate that the exception is thrown when the ResultSet is created,...

Here is what I have now:

String combQ = "SELECT AMINO_NAME, ONE_LTR, THREE_LTR FROM AMINO_ABBREV JOIN AMINO_PROP ON AMINO_ABBREV.AMINO_NAME=AMINO_PROP.AMINO_NAME";

...

Which version of combQ did you use?

I'm just using a standard Microsoft Access DB with a JDBC:ODBC connection. I was under the impression that SQL work under those condition. However, I only know enough SQL to create tables and query...

Is there a better bioard on which to post JDBC question where the problem is mostly with the SQL?



How would you do this?



This throws the following exception:

import java.net.*;
import java.sql.*;
import java.io.*;
import java.util.*;

class MakeDB
{

public static void main (String args[])
{