JList Remove Selected and SQL Query Results

[Josip Skako]

Hey all,

Today I have not one, but two questions.

First I would love You to show my software on picture so You can easier get point.



In JList I have paths to my MS-SQL scripts. With double click on it text has been readed to JTextArea1 (Some SQL code).

The execution is done without any problems.

JTextArea should show any results or errors and this is my first problem.  (Like "Query executed successfully", "Table XXXXX Altered", "Table XXXXX Created","Table XXXX doesn't exist".
I know there is a way to show specific results for specificied query in code but my querys are always loaded by user and are always random so it can't be fixed in code.
I show errors with try\catch block but there are too much that I don't need.

Second problem - Like You see in JTextArea1 I have path to script (planty of them actually). You can notice my "Remove Selected" button too.

Lets say that script 1 do "Select * from coderanch" and script 2 do "Select * from mysqleditor".

When I remove selected it sucessfully remove it from the selected script (lets say script 1) from the list.
But now script2 has "Select * from coderanch" when I load it. I think I messed index for deleting or reading scripts somewhere?
My code for delete script is:

model.remove(index);

[Prasad Saya]

Issue 1: You could use the exception class's getMessage() method to retrieve the short message.

Issue 2:
Are you using a ListSelectionListener ?
Did you try using list.updateUI() method?

The solution depends on how you are selecting list items. When you delete an item (or element) in the list, the item gets removed and the next item gets selected. The remove action can have the logic to select the next item and then display the script text (or description).

For example, the list has:
script_1 - SELECT * FROM EMPLOYEES;
script_2 - TRUNCATE TABLE EMPLOYEES;

When script_1 is selected "SELECT..." is displayed in text area 1. When script_1 is deleted, the Remove Selected button's actionlistener gets executed. This action listener can have logic to:
- delete the script_1 item from the list
- clear the text area 1
- select the next list element - the script_2
- display the script_2's description ("TRUNCATE...").

Hope this helps.

[Josip Skako]

Thank You.

Yeah, for errors that may be solution, but what if I want to show results and other SQL messages?

Well I am missing last three steps than I guess:

- clear the text area 1
- select the next list element - the script_2
- display the script_2's description ("TRUNCATE...").

I am not using ListSelectionListener as I find out that this suit me better:

    private void SQLScriptListMouseClicked(java.awt.event.MouseEvent evt) {                                           
        JList list = (JList) evt.getSource();
        if (evt.getClickCount() == 2) {
            index = list.locationToIndex(evt.getPoint()); //GET INDEX 0,1,2,3
            //  int index = list.locationToIndex(evt.getPoint()); //GET INDEX 0,1,2,3

            try {
                FileReader reader = new FileReader(files[index]);
                SQLEditor.read(reader, files[index]); //Object of JTextArea
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }  

Now I have to add "Enter" action that can be able to select item in JList as double click that is working now.

[Prasad Saya]

For the ENTER action you can use the KeyListener.

And, you can look at this example I had written sometime back about using a JList and a JTextArea and the interaction between the two components (like adding to the list and removing an element from the list, updating the text area, etc..): http://www.javaquizplayer.com/examples/notesapp-using-swing-h2database-JPA-example.html

[Rob Camick]

Did you try using list.updateUI() method?

No you should NOT be using the updateUI() method. That method is invoked internally by Swing on a LAF change. You are not changing the LAF so there is no need to use that method.

Changes should be made to the ListModel and the list will automatically repaint itself.

See the ListDemo example from the Swing tutorial on How to Use Lists, for a working example of this approach.

For the ENTER action you can use the KeyListener.

Don't use a KeyListener. Swing was designed to be used with Key Bindings. This is how all the default Actions of Swing Components are implemented.

Check out List Action. Its shows a simple implementation that will invoke an Action when the Enter key is pressed or the mouse is double clicked.

Today I have not one, but two questions.

In the future, one question per thread. It gets too confusing trying to have a conversation with two topics at the same time.

[Josip Skako]

I am working with the JList model, I am not working directly with the list.

Yeah I am sorry about 2 questions in 1 post, just didn't want to open too much threads.

Anyway, back to problem:

I go to SSMS and enter command

delete from fp105p where f105pipz = '2'

As only one record exist in that table with F105PIPZ = '3' result is: "(0 rows affected)"

I do same command within my software and I am catching exception with:

catch (SQLException e) {
            //  handle sql exception
            System.out.println("\n");
            System.out.println("Connection FAILED");
            System.out.println("------------------------------");
            e.printStackTrace();

        } catch (Exception e) {
            // TODO: handle exception for class.forName
            e.printStackTrace();

Now it prints error (I tried with GetMessage and SQL but it doesn't return nothing):

com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set.
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:191)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:893)

Ok, now I try to  do command:

delete from fp105p where f105pipz = '3'

Yeah, that line does exist in the record.

Now when I execute that command with my software results are:

com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set.
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:191)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:893)

I checked in my database and SQL command went successfully but I get that error anyway.

It's strange that I am not able to get results of SQL Query in NetBeans also.

[Josip Skako]

I Guess I am getting this message when SQL QUERY is done successfully, so solution would be to find:

com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:191)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:893)

And replace it with: "Query has been completed successfully!"?

[Dave Tolls]

Can you show us the code that executes the entered queries?
Because whatever code it is it seems to be thinking that has a ResultSet expected, which isn't the case iwth a DELETE operation.

[Josip Skako]

Dave Tolls wrote:Can you show us the code that executes the entered queries?
Because whatever code it is it seems to be thinking that has a ResultSet expected, which isn't the case iwth a DELETE operation.

This is part of code that execute SQL query:

private void ExecuteActionPerformed(java.awt.event.ActionEvent evt) {                                        
        if (SQLEditor.getText().trim().equals("")) {

            // create a jframe
            JFrame frame = new JFrame("Script can't be empty!");

            // show a joptionpane dialog using showMessageDialog
            JOptionPane.showMessageDialog(frame,
                    "Script can't be empty!",
                    "Error!!",
                    JOptionPane.INFORMATION_MESSAGE);
        } else {

            try {
                // registering the driver__STEP 2
                Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
                // returns a Class object of com.mysql.jdbc.Driver
                // (forName(""); initializes the class passed to it as String) i.e initializing the
                // "suitable" driver
                //System.out.println("Connecting to the database");
                //System.out.println("\n");
                // opening a connection__STEP 3
                conn = DriverManager.getConnection(DB_URL);
                // executing a query__STEP 4 
                System.out.println("Creating a statement..");
                System.out.println("\n");
                stmt = conn.createStatement();
                // creating an object to create statements in SQL
                String sql;
                sql = SQLEditor.getText();
                ResultSet rs = stmt.executeQuery(sql);
                if (RemoveAfterExecute.isSelected()) {
                    model.remove(index);
                }
                // cleaning up__STEP 6
                rs.close();
                stmt.close();
                conn.close();
            } catch (SQLException e) {
                //  handle sql exception
                 e.printStackTrace();
            } catch (Exception e) {
                // TODO: handle exception for class.forName
                //THIS PRINT SQL ERROR
                e.printStackTrace();
            } finally {
                //closing the resources..STEP 7
                try {
                    if (stmt != null) {
                        stmt.close();
                    }
                } catch (SQLException e2) {
                     e2.printStackTrace();
                }
                try {
                    if (conn != null) {
                        conn.close();
                    }
                } catch (SQLException e2) {
                     e2.printStackTrace();
                }
            }
            System.out.println("Good Bye");

        }
    }    

                                 

[Knute Snortum]

ResultSet rs = stmt.executeQuery(sql);
That's going to cause an error with an SQL command that doesn't return a ResultSet, like DELETE.

[Prasad Saya]

ResultSet rs = stmt.executeQuery(sql);

As Dave Tolls mentioned delete doesn't return a result set. You should use executeUpdate instead.

From Java API: executeUpdate executes the given SQL statement, which may be an INSERT, UPDATE, or DELETE statement or an SQL statement that returns nothing, such as an SQL DDL statement.

[Dave Tolls]

If this system needs to handle any SQL entered in the front end then I suspect some parsing is going to be needed.

[Josip Skako]

Well we work alot with SQL Queries to maintain our database and do some software updates (If we need new table, data, or something).
Sometimes we have around 300 .sql files and You have to click on every single one to open it and execute it.
You can't imagine how time we are losing (Or you can).
We usually execute .sql on the test database (exact copy of main database) then we execute .sql on main database. ~600 .sql to execute
Now that is for MSSQL, we have ORACLE database too...

Anyway this software should load all queries that has to be executed and execute one by one (remove one that executed successfully) and if find any error stops there and let you fix it.

So, for now everything seems to work but this, this seems to be biggest problem to solve for now.

Ofcourse, if somebody has same problem I'll be happy to share source with him.

[Josip Skako]

Prasad Saya wrote:ResultSet rs = stmt.executeQuery(sql);

As Dave Tolls mentioned delete doesn't return a result set. You should use executeUpdate instead.

From Java API: executeUpdate executes the given SQL statement, which may be an INSERT, UPDATE, or DELETE statement or an SQL statement that returns nothing, such as an SQL DDL statement.

This work as a charm. Thank You.

Last thing is cutting error to not show everything.

Example:

DELTE FROM TT_PK151R WHERE K01IME = 'CRAZY'

SQL Error:

Msg 156, Level 15, State 1, Line 8
Incorrect syntax near the keyword 'FROM'.

JAVA Code:

catch (Exception e) {
                e.printStackTrace();

JAVA Error:

com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'FROM'.
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1655)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:885)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:778)
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505)
....
...
..

[Dave Tolls]

Try getMessage.
I think that should hold just the "Incorrect syntax near the keyword 'FROM'" part.

[Josip Skako]

Dave Tolls wrote:Try getMessage.
I think that should hold just the "Incorrect syntax near the keyword 'FROM'" part.

Keep getting same error:

com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '*'.
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1655)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:885)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:778)
        ...
        ...
        ...

[Paul Clapham]

Well, normally when the database server tells you there's an error in your SQL, you would look at the SQL, right? So is your software not designed to show you the SQL with the error? I'd work on fixing that if it doesn't.

[Prasad Saya]

What is he SQL script you are trying to run?

[Dave Tolls]

Well, that output is from a printStackTrace, so presumably you are still using that method (as in the code above)?

[Josip Skako]

Prasad Saya wrote:What is he SQL script you are trying to run?

This is Script:

DELETE FROM FS005 WHERE S05PGM='PK151RR'
GO
DELETE FROM FS002 WHERE S02PGM='PK151RR'
GO

		INSERT INTO [FS002] ([S02PGM], [S02FOP], [S02NBR], [S02OPI], [S02MOD], [S02INA], [S02USA], [S02DAA], [S02VRA], [S02USR], [S02DAT], [S02VRI])
		VALUES ('PK151RR', N'*', N'00','Prilozi zahtjeva', NULL, N'', 'INFOMARE', 
		CONVERT(char,GETDATE(),112), REPLACE(CONVERT(char,GETDATE(),108),':',''), 'INFOMARE', CONVERT(char,GETDATE(),112), REPLACE(CONVERT(char,GETDATE(),108),':',''))
GO
 

		INSERT INTO [FS005] ([S05GRP], [S05PGM], [S05FOP], [S05NBR], [S05USA], [S05DAT], [S05VRI])
		VALUES ('MAGIC', 'PK151RR', N'*', N'00', 'INFOMARE',CONVERT(char,GETDATE(),112), REPLACE(CONVERT(char,GETDATE(),108),':',''))
	
GO
 
 
DELETE FROM FS005 WHERE S05PGM='B.PK151RR'
GO
DELETE FROM FS002 WHERE S02PGM='B.PK151RR'
GO
 

				INSERT INTO [FS002] ([S02PGM], [S02FOP], [S02NBR], [S02OPI], [S02MOD], [S02INA], [S02USA], [S02DAA], [S02VRA], [S02USR], [S02DAT], [S02VRI])
				VALUES ('B.PK151RR', N'*', N'00', 'Azuriranje priloga zapisa PN', NULL, N'','INFOMARE', 
				CONVERT(char,GETDATE(),112), REPLACE(CONVERT(char,GETDATE(),108),':',''), 'INFOMARE', CONVERT(char,GETDATE(),112), REPLACE(CONVERT(char,GETDATE(),108),':',''))
			
GO

				INSERT INTO [FS002] ([S02PGM], [S02FOP], [S02NBR], [S02OPI], [S02MOD], [S02INA], [S02USA], [S02DAA], [S02VRA], [S02USR], [S02DAT], [S02VRI])
				VALUES ('B.PK151RR', N'O', N'01', 'Upis', NULL, N'', 'INFOMARE', 
				CONVERT(char,GETDATE(),112), REPLACE(CONVERT(char,GETDATE(),108),':',''), 'INFOMARE', CONVERT(char,GETDATE(),112), REPLACE(CONVERT(char,GETDATE(),108),':',''))
			
GO

				INSERT INTO [FS002] ([S02PGM], [S02FOP], [S02NBR], [S02OPI], [S02MOD], [S02INA], [S02USA], [S02DAA], [S02VRA], [S02USR], [S02DAT], [S02VRI])
				VALUES ('B.PK151RR', N'O', N'02', 'Izmjena', NULL, N'', 'INFOMARE', 
				CONVERT(char,GETDATE(),112), REPLACE(CONVERT(char,GETDATE(),108),':',''), 'INFOMARE', CONVERT(char,GETDATE(),112), REPLACE(CONVERT(char,GETDATE(),108),':',''))
			
GO

				INSERT INTO [FS002] ([S02PGM], [S02FOP], [S02NBR], [S02OPI], [S02MOD], [S02INA], [S02USA], [S02DAA], [S02VRA], [S02USR], [S02DAT], [S02VRI])
				VALUES ('B.PK151RR', N'O', N'04', 'Brisanje', NULL, N'', 'INFOMARE', 
				CONVERT(char,GETDATE(),112), REPLACE(CONVERT(char,GETDATE(),108),':',''), 'INFOMARE', CONVERT(char,GETDATE(),112), REPLACE(CONVERT(char,GETDATE(),108),':',''))
			
GO

				INSERT INTO [FS002] ([S02PGM], [S02FOP], [S02NBR], [S02OPI], [S02MOD], [S02INA], [S02USA], [S02DAA], [S02VRA], [S02USR], [S02DAT], [S02VRI])
				VALUES ('B.PK151RR', N'O', N'09', '(De)Aktivacija', NULL, N'', 'INFOMARE', 
				CONVERT(char,GETDATE(),112), REPLACE(CONVERT(char,GETDATE(),108),':',''), 'INFOMARE', CONVERT(char,GETDATE(),112), REPLACE(CONVERT(char,GETDATE(),108),':',''))
			
GO
 

					INSERT INTO [FS005] ([S05GRP], [S05PGM], [S05FOP], [S05NBR], [S05USA], [S05DAT], [S05VRI])
					VALUES ('MAGIC', 'B.PK151RR', N'*', N'00', 'INFOMARE',CONVERT(char,GETDATE(),112), REPLACE(CONVERT(char,GETDATE(),108),':',''))
					
GO

					INSERT INTO [FS005] ([S05GRP], [S05PGM], [S05FOP], [S05NBR], [S05USA], [S05DAT], [S05VRI])
					VALUES ('MAGIC','B.PK151RR', N'O', N'01', 'INFOMARE',CONVERT(char,GETDATE(),112), REPLACE(CONVERT(char,GETDATE(),108),':',''))
					
GO

					INSERT INTO [FS005] ([S05GRP], [S05PGM], [S05FOP], [S05NBR], [S05USA], [S05DAT], [S05VRI])
					VALUES ('MAGIC', 'B.PK151RR', N'O', N'02','INFOMARE',CONVERT(char,GETDATE(),112), REPLACE(CONVERT(char,GETDATE(),108),':',''))
					
GO

					INSERT INTO [FS005] ([S05GRP], [S05PGM], [S05FOP], [S05NBR], [S05USA], [S05DAT], [S05VRI])
					VALUES ('MAGIC','B.PK151RR', N'O', N'04', 'INFOMARE',CONVERT(char,GETDATE(),112), REPLACE(CONVERT(char,GETDATE(),108),':',''))
					
GO

					INSERT INTO [FS005] ([S05GRP], [S05PGM], [S05FOP], [S05NBR], [S05USA], [S05DAT], [S05VRI])
					VALUES ('MAGIC', 'B.PK151RR', N'O', N'09','INFOMARE',CONVERT(char,GETDATE(),112), REPLACE(CONVERT(char,GETDATE(),108),':',''))
			
GO

Now I'm getting:

com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'GO'.
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1655)
...
...

I tought I am not storing my query well in my String variable than I try to remove storing at all and I do:

stmt.executeUpdate(SQLEditor.getText());  //SQLEditor is JTextArea with SQL Query

Now I do:

System.out.println(SQLEditor.getText());

Everything printed fine and I tried to run query in SSMS.
So in SSMS everything works, and in JAVA I am getting errors.

[Prasad Saya]

I am not familiar with SQL Server; but it looks like you have to execute sql statements as a batch. Look for something like JDBC execute batch on Google search.

[Josip Skako]

As I posted same question both here (coderanch.com) and on stackoverflow.com somebody mention to me that I can't do that and I would love to apologize all members that I offend with that.
Anyway, I deleted my post on stackoverflow.com as I find this forum much better and more usefull to me.

My problem is still not solved and this is not last message from me here I just want to thank You all for Your time and help.

[Dave Tolls]

I'm a bit lost now.
Are you trying to run those SQL statements one at a time, or are you trying to run them all at once?

What is the query being run by this line?

stmt.executeUpdate(SQLEditor.getText());

If it's all the stuff in that block of statements then that will not work in JDBC.

What exactly is it you are trying to do?
What are your requirements?

Earlier you asked about getting the response back for individual statements, but the above looks like you are trying to run dozens of statements at once.

[Josip Skako]

Well sometimes SQL Query will have 1 line of code and sometimes more.
I am not sure how this connection between SQL and JDBC works, I was thinking that JDBC send SQL query (In my case array of strings) and than SSMS is executing line by line.
I see now that I have to send line by line to SSMS and I have to find the way to read line by line from JPane and send it to SSMS with:

                stmt.addBatch(SQLEditor.getText());
                stmt.executeBatch();

[Prasad Saya]

The GO command of sql server and its usage: http://www.sqlines.com/sql-server/sql_batch_go

You need to figure how to create batches of queries and how the GO affects the way the batched sql statements will be executed.

[Josip Skako]

Well this is waht I do, I saved JPane to .txt file.
After that I am reading line by line and sending it to SQL, if it finds "GO" just skip it.

                PrintWriter writer = new PrintWriter("MyQuery.txt", "UTF-8");
                writer.println(SQLEditor.getText());
                writer.close();

                try (BufferedReader br = new BufferedReader(new FileReader("MyQuery.txt"))) {
                    for (String line; (line = br.readLine()) != null;) {
                        if (line.equals("GO")) {
                        } else {
                            stmt.addBatch(line.trim());
                            stmt.executeBatch();
                        }

                    }
                    // line is not visible here.
                }

Problem is if I have:

		INSERT INTO [FS002] ([S02PGM], [S02FOP], [S02NBR], [S02OPI], [S02MOD], [S02INA], [S02USA], [S02DAA], [S02VRA], [S02USR], [S02DAT], [S02VRI])
		VALUES ('PK151RR', N'*', N'00','Prilozi zahtjeva', NULL, N'', 'INFOMARE', 
		CONVERT(char,GETDATE(),112), REPLACE(CONVERT(char,GETDATE(),108),':',''), 'INFOMARE', CONVERT(char,GETDATE(),112), REPLACE(CONVERT(char,GETDATE(),108),':',''))

Code will now read line by line and will try with:

INSERT INTO [FS002] ([S02PGM], [S02FOP], [S02NBR], [S02OPI], [S02MOD], [S02INA], [S02USA], [S02DAA], [S02VRA], [S02USR], [S02DAT], [S02VRI])

But that just won't work without whole code.

Does anybody have some idea to fix this?

Maybe to write in SQL Queries "GO" between break points, and read from "GO" to "GO" but that is not great solution.

[Dave Tolls]

Why is spliiting that text on GO incorrect?
That does seem to be the delimiter.

[Josip Skako]

Dave Tolls wrote:Why is spliiting that text on GO incorrect?
That does seem to be the delimiter.

Well it is not wrong to wirte GO as delimiter.

But I am not the one who is writing the SQL scripts so the worst problem is teach 40 people to use GO as delimiter.

And if somebody forget to write GO as delimiter script is breaking down and writing errors.

That is why it is not greatest solution.

[Dave Tolls]

OK, so this goes back to exactly what your requirements are.

In detail.

As this is starting to look like something that was defined on the back of a beer mat and not analysed properly.

[Josip Skako]

You are not far from the truth.

I still need to find way to send SQL query properly from JAVA to SSMS.

Maybe I should consider to switch this software from JAVA to C# as C# should be more native with MS-SQL but that will take too much time and work?

[Josip Skako]

I also tried with:

PreparedStatement stmt = null;

                stmt = conn.prepareStatement(SQLEditor.getText());
                //stmt.setNull(1, 1); // To pass in Null
                stmt.setInt(1,1); // To pass in a non null value

                // run it and parse results
                rs = stmt.executeQuery();
                while (rs.next()) {
                    System.out.println(rs.getString(1) + ":" + rs.getString(2));
                }

Error:

com.microsoft.sqlserver.jdbc.SQLServerException: The index 1 is out of range.
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:191)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setterGetParam(SQLServerPreparedStatement.java:933)
...
...

[Prasad Saya]

I think the GO command need to be studied and list out the use cases. Then, work how these cases can be handled within this application.

[Josip Skako]

Well I append all lines to one row and that does indeed work with SQL SSMS.

  try (BufferedReader br = new BufferedReader(new FileReader("MyQuery.txt"))) {
                    for (String line; (line = br.readLine()) != null;) {
                        if (line.startsWith("GO") || line.startsWith("End")) {
                        } else {
                            //conn.createStatement(line = br.readLine()).executeUpdate();
                            buf.append(line).append(" ");
                            // stmt.addBatch(line.trim());
                // System.out.println(buf.toString()+"\n \n");
                        }
                        //stmt.executeBatch();
                    }
                    // line is not visible here.

                }
                 System.out.println(buf.toString()+"\n \n");
                 stmt.addBatch(buf.toString());

Now I'm getting java.lang.NullPointerException and have to find out where.

[Dave Tolls]

I still think the requirements need to be defined.
Because if this is supposed to take in any old stuff from the user then there's likely to be more work involved.

Are they expecting to run actual SELECT queries for example?

As for the exception, the stack trace will tell you exactly where it occurred, from which you should be able to determine what is null.

[Josip Skako]

Dave Tolls wrote:I still think the requirements need to be defined.
Because if this is supposed to take in any old stuff from the user then there's likely to be more work involved.

Are they expecting to run actual SELECT queries for example?

As for the exception, the stack trace will tell you exactly where it occurred, from which you should be able to determine what is null.

Well I strongly agree for requirements that need to be defined.

I was thinking to allow (Well not allow but to be able) run actual SELECT also but as I can't get results back from random queries who are not fixed in code and as we are usually not working only with SELECT as SELECT is for management purpose (to see and discover something) I will "throw it out".

[Josip Skako]

Well here is the code that finally works. Now I will find out the way to display errors correctly. Thank You all!

        try {
                // registering the driver__STEP 2
                Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        // opening a connection__STEP 3
        conn = DriverManager.getConnection(DB_URL);
        // executing a query__STEP 4 
        System.out.println("Creating a statement..");
        System.out.println("\n");
        // creating an object to create statements in SQL
        String[] sql;

        //SAVE QUERY TO TEXT
        PrintWriter writer = new PrintWriter("MyQuery.txt", "UTF-8");
        writer.println(SQLEditor.getText());
        writer.close();
        StringBuilder buf = new StringBuilder();
        try (BufferedReader br = new BufferedReader(new FileReader("MyQuery.txt"))) {
            for (String line; (line = br.readLine()) != null;) {
                if (line.startsWith("GO") || line.startsWith("End")) {
                } else {
                    //conn.createStatement(line = br.readLine()).executeUpdate();
                    buf.append(line).append(" ");

                }
            }

        }
        System.out.println("STAGE 5");
        System.out.println(buf.toString());

        stmt = conn.createStatement();
        stmt.executeUpdate(buf.toString());

        if (RemoveAfterExecute.isSelected()) {
            model.remove(index);
            arraybeta.remove(index);
        }
        System.out.println("STAGE 7");
        // cleaning up__STEP 6

        System.out.println("STAGE 8");
    }
    catch (SQLException e

    
        ) {
                //  handle sql exception
                e.printStackTrace();
    }
    catch (Exception e

    
        ) {

                e.printStackTrace();
    }

    
        finally {
                //closing the resources..STEP 7
                try {
            if (stmt != null) {
                stmt.close();
            }
        } catch (SQLException e2) {
            e2.printStackTrace();
        }

    }

}
} 

[Josip Skako]

I just wanted to post solution for catching errors in SQL, with this code everything is working:

    //CATCHING SQL EXCEPTION - ERROR
    public static void printSQLException(SQLException ex) {

        for (Throwable e : ex) {
            if (e instanceof SQLException) {
                if (ignoreSQLException(
                        ((SQLException) e).
                                getSQLState()) == false) {

                    //e.printStackTrace(System.err);
                    System.err.println("SQLState: "
                            + ((SQLException) e).getSQLState());

                    System.err.println("Error Code: "
                            + ((SQLException) e).getErrorCode());

                    System.err.println("Message: " + e.getMessage());

                    Throwable t = ex.getCause();
                    while (t != null) {
                        System.out.println("Cause: " + t);
                        t = t.getCause();
                    }
                }
            }
        }
    }

    public static boolean ignoreSQLException(String sqlState) {
        if (sqlState == null) {
            System.out.println("The SQL state is not defined!");
            return false;
        }
        // X0Y32: Jar file already exists in schema
        if (sqlState.equalsIgnoreCase("X0Y32")) {
            return true;
        }
        // 42Y55: Table already exists in schema
        if (sqlState.equalsIgnoreCase("42Y55")) {
            return true;
        }
        return false;
    }

Don't forget to call it in catch block:

            } catch (SQLException ex) {
                printSQLException(ex);
            } 

[Prasad Saya]

Good to know you are finishing your code without any issues   . While posting the code make sure its properly indented (and do remove the commented code). Also, if code comments (saying what it does) are placed strategically helps others to read the code and respond with a comment or a suggestion.