Weird SQL error.

[macko Crater]

Hi there,

I'm trying to use Java to create a View in SQL. I've been using Java before with no problems to insert data and tables, but right now I keep getting this error:

java.sql.SQLException: ORA-00911: invalid character

I've simplified my code down to it's bare bones, even the SQL statement, but it's still giving the error and I can't work out why. If I copy and paste the SQL statement into an SQL app, it works fine, but I need this to be automated through Java. Maybe you guys can help?

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

public final class InvoiceTableViewTest
{
	private static Connection conn;
	
	public static void main(String[] args) {
		try {
			// Variables
			Connection conn;
			String url = "jdbc:oracle:thin:@//172.16.134.31:4100/CABRM";
			String username = "ca_billing";
			String password = "ca_billing";
			
			// Set up Connection.
			Class.forName("oracle.jdbc.driver.OracleDriver");
			conn = DriverManager.getConnection(url,username,password);
			
			Statement insertViewsStatement = conn.createStatement();

			String tmpString = "CREATE VIEW TestMatchingAccounts AS SELECT acct_no FROM ca1_05_70_account;";

			System.out.println(tmpString);
			insertViewsStatement.executeUpdate(tmpString);
			
			conn.close();
		}
		catch(Exception e) {
			e.printStackTrace();
		}
	}
}

[macko Crater]

Nvm, I fixed this. I can't have a ; at the end of the SQL statement, even though it's fine in an SQL app, it doesn't work with JDBC.