Annoying syntax error in Eclipse!!

[mistajokka]

Hey everyone, I am trying to code an Android app that uses JDBC to Sybase and everything has went smooth with the code until the very last closing right bracket that says "Syntax error on token "}", delete this token".

Here is my code:

package com.jconnecttest;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import android.app.Activity;
import android.os.Bundle;

public class JConnectTestActivity extends Activity {
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
try {
Class.forName("com.sybase.jdbc.SybDriver");
}catch(ClassNotFoundException e){
System.err.println("Error loading driver: " + e);}
String host = "my.sybase.serverurl";
String dbName = "mydatabasename";
int port = 2638;
String sybaseURL = "jdbc:sybase:Tds:" + host +
":" + port + ":" + "?SERVICENAME=" + dbName;
String username = "dba";
String password = "mydbapassword";
Connection connection =
DriverManager.getConnection(sybaseURL, username, password);
Statement statement = connection.createStatement();
String query = "SELECT name, address, phone FROM company";
ResultSet resultSet = statement.executeQuery(query);
while(resultSet.next()){
System.out.println(resultSet.getString(1) + " " +
resultSet.getString(2) + " " +
resultSet.getString(3));
connection.close();
}
}
}
} <--------- THIS is the one it is giving the error on...I even tried creating a new project and re typing all the code clean but it keeps giving me this!!

Please help :(

[JosAH]

Do as Eclipse told you to do, you have one right curly bracket too many.

kind regards,

Jos

[mistajokka]

If I do that, my code above it starts to have errors:



A bunch of "Unhandled exception type SQLException"...it goes away if I add that extra bracket...weird

[vivekanand30]

That's the very basic thing which you can't see as the error itself says that "Unhandled exception type SQLException" it means you need to surround it with try catch block. You should know there are some exception which you have to handle in your code this is what happening in your case. For your reference look at the below code

package com.example.android.notepad;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import android.app.Activity;
import android.os.Bundle;

public class test extends Activity {
	/** Called when the activity is first created. */
	@Override
	public void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		///setContentView(R.layout.main);
		try {
			Class.forName("com.sybase.jdbc.SybDriver");
		}catch(ClassNotFoundException e){
			System.err.println("Error loading driver: " + e);}
		String host = "my.sybase.serverurl";
		String dbName = "mydatabasename";
		int port = 2638;
		String sybaseURL = "jdbc:sybase:Tds:" + host +
				":" + port + ":" + "?SERVICENAME=" + dbName;
		String username = "dba";
		String password = "mydbapassword";
		Connection connection;
		try {
			connection = DriverManager.getConnection(sybaseURL, username, password);
		
		Statement statement = connection.createStatement();
		String query = "SELECT name, address, phone FROM company";
		ResultSet resultSet = statement.executeQuery(query);
		while(resultSet.next()){
			System.out.println(resultSet.getString(1) + " " +
					resultSet.getString(2) + " " +
					resultSet.getString(3));
			connection.close();
		}
		
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}
}

Please read the throw, throws and try catch block. URL