java file that will expose two methods

you're missing imports

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

public class Stringtoarray

{
	public static String[] toarray(String s) {
		String[] array = s.split(";");
		return array;
	}

	public static void main(String[] args) {

		// Create a variable for the connection string.
		String connectionUrl = "jdbc:sqlserver://sqlserver:1433;"
				+ "databaseName=abm;user=janitorial;password=janitorial";

		// Declare the JDBC objects.
		Connection con = null;
		Statement stmt = null;
		ResultSet rs = null;

		try {
			// Establish the connection.
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			con = DriverManager.getConnection(connectionUrl);

			// Create and execute an SQL statement that returns some data.
			String SQL = "SELECT TOP 10 * FROM Person.Contact";
			stmt = con.createStatement();
			rs = stmt.executeQuery(SQL);

			// Iterate through the data in the result set and display it.
			while (rs.next()) {
				System.out.println(rs.getString(4) + " " + rs.getString(6));
			}
		}

		// Handle any errors that may have occurred.
		catch (Exception e) {
			e.printStackTrace();
		} finally {
			if (rs != null)
				try {
					rs.close();
				} catch (Exception e) {
				}
			if (stmt != null)
				try {
					stmt.close();
				} catch (Exception e) {
				}
			if (con != null)
				try {
					con.close();
				} catch (Exception e) {
				}
		}
	}

}

Select allOpen in new window

you need to import

import java.sql.Statement
import java.sql.Connection

or how can i call a stored procedure from .java and have the output as a return value

> or how can i call a stored procedure from .java and have the output as a return value


basically the same as what you are doing
just use the code I posted above with the correct imports

http://www.exampledepot.com/egs/java.sql/CallProcedure.html

thank you objects and for_yan. After adding the import statement the java compiled successfully. how can iI call a stored procedure from java and the output of sp as a return value

see my previous comment

http://docsrv.sco.com/JDK_guide/jdbc/getstart/callablestatement.doc.html

this is how to use CallableStatment with stored procedures, e.g.

  CallableStatement cstmt = con.prepareCall(
                          "{call getTestData(?, ?)}");
    cstmt.registerOutParameter(1, java.sql.Types.TINYINT);
    cstmt.registerOutParameter(2, java.sql.Types.DECIMAL, 3);
    cstmt.executeQuery();
    byte x = cstmt.getByte(1);
    java.math.BigDecimal n = cstmt.getBigDecimal(2, 3);

Thank you for the prompt reply
I was able to successfullly compile the java but when i run the java

D:\WebSphere\java\bin>java Stringtoarray
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
        at java.lang.Class.forName(Class.java:136)
        at Stringtoarray.main(Stringtoarray.java:29)

you need to include the jdbc drivers jars in your classpath

I guess, they should be downloaded from here, unless you already have the jar which you
need to include in yourr classpath
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=a737000d-68d0-4531-b65d-da0f2a735707&displaylang=en

You helped me with this issue couple of months ago. I want to add one more method on the below class. Technically when other application calls stringtoarray there should be two methods available one for converting string to stringtoarray and the other calling the sql statement.

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


public class Stringtoarray

{
      public static String[] toarray(String s)
      {
      String[] array =s.split(";");
      return array;
      }


public static void main (String [] args) {
String [] s0 = toArray(args[0]);
for(int j=0; j<s0.length; j++){System.out.println(s0[j]);
}

public static void main(String[] args) {

      // Create a variable for the connection string.
      String connectionUrl = "jdbc:sqlserver://abm-sql1\\abm-jan-sql1:1433;" +
         "databaseName=jani;user=sa;password=testing;

      // Declare the JDBC objects.
      Connection con = null;
      Statement stmt = null;
      ResultSet rs = null;

      try {
         // Establish the connection.
         Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
         con = DriverManager.getConnection(connectionUrl);

         // Create and execute an SQL statement that returns some data.
         String SQL = "SELECT TOP 10 *  FROM billing.tbl_Expenses";
         stmt = con.createStatement();
         rs = stmt.executeQuery(SQL);

         // Iterate through the data in the result set and display it.
         while (rs.next()) {
            System.out.println(rs.getString(4) + " " + rs.getString(6));
         }
      }

      // Handle any errors that may have occurred.
      catch (Exception e) {
         e.printStackTrace();
      }
      finally {
         if (rs != null) try { rs.close(); } catch(Exception e) {}
         if (stmt != null) try { stmt.close(); } catch(Exception e) {}
         if (con != null) try { con.close(); } catch(Exception e) {}
      }
   }


 

      }
when i compile the above program i get the below message
D:\WebSphere\java\bin>javac Stringtoarray.java
Stringtoarray.java:22: illegal start of expression
public static void main(String[] args) {
^
Stringtoarray.java:22: illegal start of expression
public static void main(String[] args) {
       ^
Stringtoarray.java:22: ';' expected
public static void main(String[] args) {
             ^
Stringtoarray.java:22: '.class' expected
public static void main(String[] args) {
                                 ^
Stringtoarray.java:22: ';' expected
public static void main(String[] args) {
                                     ^
Stringtoarray.java:63: reached end of file while parsing
        }¿
         ^
6 errors

thank you

is that okay if i remove void main from both methods

No, it is not.

Your class should have one method
with this signature:

public static void main(String [] args)

This would be the method where execution will
start. So it should have one such method, if you will
start execution with this class.
But there should not be two of them

I corrected a couple of misplaced braces and lost closing quote

Still uyou have two main() methods and
there is no such method toArray()

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


public class Stringtoarray

{
      public static String[] toarray(String s)
      {
      String[] array =s.split(";");
      return array;
      }


public static void main (String [] args) {
String [] s0 = toArray(args[0]);         // No method toArray
for(int j=0; j<s0.length; j++){System.out.println(s0[j]);
}
}

public static void main(String[] args) {                     //second time main

      // Create a variable for the connection string.
      String connectionUrl = "jdbc:sqlserver://abm-sql1\\abm-jan-sql1:1433;" +
         "databaseName=jani;user=sa;password=testing";

      // Declare the JDBC objects.
      Connection con = null;
      Statement stmt = null;
      ResultSet rs = null;

      try {
         // Establish the connection.
         Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
         con = DriverManager.getConnection(connectionUrl);

         // Create and execute an SQL statement that returns some data.
         String SQL = "SELECT TOP 10 *  FROM billing.tbl_Expenses";
         stmt = con.createStatement();
         rs = stmt.executeQuery(SQL);

         // Iterate through the data in the result set and display it.
         while (rs.next()) {
            System.out.println(rs.getString(4) + " " + rs.getString(6));
         }
      }

      // Handle any errors that may have occurred.
      catch (Exception e) {
         e.printStackTrace();
      }
      finally {
         if (rs != null) try { rs.close(); } catch(Exception e) {}
         if (stmt != null) try { stmt.close(); } catch(Exception e) {}
         if (con != null) try { con.close(); } catch(Exception e) {}
      }
   }

}

Select allOpen in new window

the below program compiled successfully. how can i test it  from command propmt
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;


public class Stringtoarray

{
      public  String[] toarray(String s)
      {
      String[] array =s.split(";");
      return array;
      }


public String calldb() {

   // Create a variable for the connection string.
      String connectionUrl = "jdbc:sqlserver://abm-sql1\\abm-jan-sql1:1433;" +
         "databaseName=jani;user=sa;password=testing;

      // Declare the JDBC objects.
      Connection con = null;
      Statement stmt = null;
      ResultSet rs = null;

      try {
         // Establish the connection.
         Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
         con = DriverManager.getConnection(connectionUrl);

         // Create and execute an SQL statement that returns some data.
         String SQL = "SELECT TOP 10 *  FROM billing.tbl_Expenses";
         stmt = con.createStatement();
         rs = stmt.executeQuery(SQL);

         // Iterate through the data in the result set and display it.
         while (rs.next()) {
            System.out.println(rs.getString(4) + " " + rs.getString(6));
         }
      }

      // Handle any errors that may have occurred.
      catch (Exception e) {
         e.printStackTrace();
      }
      finally {
         if (rs != null) try { rs.close(); } catch(Exception e) {}
         if (stmt != null) try { stmt.close(); } catch(Exception e) {}
         if (con != null) try { con.close(); } catch(Exception e) {}
      }
  return "test";
 
   }


      }