File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Java in General
Error while calling sqlcmd (sql server 2008 R2) from Java 7
Joined: Jan 24, 2012
Jul 05, 2013 09:05:02
I am facing some error wile executing sqlcmd form
. take a look...
Process process = Runtime.getRuntime().exec("sqlcmd -m-1 -S localhost,1433 -d my_server -U sa -P abc -Q \"select * from Assests where AssetID
'G123204E4-1234-4A31-B37B-0092D68DA429'\" -k2 -W -h-1 -s\",\" -o \"D://Assests.csv\"");
while running sqlcmd from sqlclient its working fine but form java it giving expression error
4145, Level 15, State 1, Server SANDIPB-PC, Line 1
An expression of non-boolean type specified in a context where a condition is expected, near 'AssetID'.
and when I change ">" to "=" its working fine.
can any one know why this is happening. Please let me know
It is sorta covered in the
JavaRanch Style Guide
subject: Error while calling sqlcmd (sql server 2008 R2) from Java 7
Passed 700,701 and 340 last Thursday
Where to find ans for mock test by Valentinn Cretazz
Webspere 345 exam questions
J2EE Recommended Reading
Calling command prompt from java
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014