I guess I've made progress.  I no longer get any errors with the following code, but nothing is written to the DB either.

              

               
void manipulateDB(){ //query write start size( 300, 300 ); // assumes that you are running the // postgresql server locally (on "localhost"). // // replace with your own postgresql-account. // String user = "user name"; String pass = "password"; // name of the database to use // String database = "db name"; // connect to database on "localhost" // pgsql = new PostgreSQL( this, "db location", database, user, pass ); // connected? if ( pgsql.connect() ) { // query the number of entries in table "weather" pgsql.query( "SELECT COUNT(*) FROM adaptive_weather_longterm" ); // results found? if ( pgsql.next() ) { pgsql.getInt(1); } // anything found? while( pgsql.next() ) { pgsql.execute( "INSERT INTO adaptive_weather_longterm (station_location, observation_time, temp_f, temp_c, relative_humidity, wind_dir, wind_mph, wind_gust_mph, dewpoint_f, dewpoint_c) VALUES (station_location_xml, observation_time_xml, temp_f_xml, temp_c_xml, relative_humidity_xml, wind_dir_xml, wind_mph_xml, wind_gust_mph_xml, dewpoint_f_xml, dewpoint_c_xml"); } } else { //connection failed ! } }
              

I think you must put single quotes around the strings you write to the DB (ie. in the SQL command).

Thanks again PhiLho!  This seems to get me a little closer.

Do you mean that in the SQL line INSERT INTO adaptive_weather_longterm (station_location, observation_time, temp_f, temp_c, relative_humidity, wind_dir, wind_mph, wind_gust_mph, dewpoint_f, dewpoint_c) VALUES (station_location_xml, observation_time_xml, temp_f_xml, temp_c_xml, relative_humidity_xml, wind_dir_xml, wind_mph_xml, wind_gust_mph_xml, dewpoint_f_xml, dewpoint_c_xml, something like wind_dir_xml is supposed to be a variable, not a string?
AFAIK, it won't work! SQLibrary is low level, it won't do introspection to get the values of the variables and won't even manage auto-quoting either. It expects a final statement, where you put explicitly the values in the right places, with string concatenation. Of course, with numbers, no need for quotes, then.