Marina:
Is getting a JDBC driver for MS SQL Server not an option for you? I've used
the FastForward driver with pretty good success, and that sounds less
painful than parsing the output of ISQL (done that long time ago, no fun at
all - although there are options to change the seperator characters to give
a StringTokenizer something to work on).
Mike N.
-----Original Message-----
From: Popova, Marina [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 06, 1999 2:47 PM
To: [EMAIL PROTECTED]
Subject: connecting to MS SQL Server through 'isql'?
Hi everybody!
I hope you can advise me how to accomplish the following task better:
In my servlet I communicate with Sybase DB through JConnect driver. But
once in a while I need to talk to
MS SQL Server DB, not often though.
My first question is: what is more efficient - to use JDBC-ODBC
bridge or to execute a query through 'isql' application (as a Unix
command , using Runtime ) ?
I thought that JDBC-ODBC would be too heavy-weight when you need to
execute couple of queries only, so for now I try to execute them
through the Unix command. And here I've got the second question:
I am able to execute the commands just fine, but the format of the
returned data is very difficult to deal with . I'll explain what I mean:
Here is how I execute a query (I modified the Jason Hunter's example
...):
public class ExecQuery {
private String query;
public ExecQuery(String theQuery) { query = theQuery; }
public String toString(){
StringBuffer out = new StringBuffer();
String substr = "echo '" + query + "' > query.tmp; echo 'go' >>
query.tmp;" +
" echo '' >> query.tmp";
String [] command1 = { "/bin/csh", "-c", substr };
String [] command2 = { "/bin/csh", "-c", "isql -Uuser -Ppassword
-Sserver < query.tmp"};
Runtime runtime = Runtime.getRuntime();
Process process = null;
try {
process = runtime.exec(command1);
try {
process.waitFor();
} catch (InterruptedException e) { ... }
process = runtime.exec(command2);
BufferedReader in = new BufferedReader (new InputStreamReader(
process.getInputStream() ) );
String line = null;
while (( line = in.readLine()) != null){
out.append(line + "<BR>\n");
}
}
catch (Exception e){ ... }
return out.toString();
}
}
If I pass a query like this: "select * from bundle where product_id
= 59"
then I get a result like this:
product_id component h_status h_start_date
h_end_date
---------- --------- -------- --------------------------
--------------------------
53 63 PREV Jan 1 1986 12:00AM
Jul 24 1993 4:03PM
53 60 PREV Jan 1 1986 12:00AM
Jul 24 1993 4:03PM
(2 rows affected)
which is pretty difficult to interpret - e.g. to assign to some
variables, etc.
Is there any way to get rid of those header lines and to format the data
nicely?
The only way I can see, is to use some sed/awk script , but since there
can be any query, it's difficult to predict
the resulting data...
Did anybody try to do something like that?
thanks a lot,
Marina
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
