when i am executing sql script file from ant script.its throwing

[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Line 1: Incorrect syntax near 'go'.

the syntax is"







"

To avoid your password being in clear text, one handy solution is to use properties for the username/password like this:



and just make sure to set the properties before that statement. One way to do this is by having ant include a properties file (presumably that ISN'T checked into your source control system) like this:

# Lines beginning with # are comments
some.username=yourusernamehere
some.password=yourpasswordhere

If this file was called "sqllogin.properties", you include it like this:



This way, the ant build file gets checked into your source control system, but the file with username/password doesn't.

Finally, if it makes you uncomfortable to store your password in a .properties file on your machine, you always have the option of using ant's "input" task to set a property by prompting the user.

Whoops...the comment maker stripped out my ant examples. Replace the [] with less-than/greater-than to get the two missing examples in my previous comment:

(1) [sql driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/database?useUnicode=true&characterEncoding=UTF-8"
userid="${some.username}" password="${some.password}" ]

(2) {property file="sqllogin.properties"]

mk

Hi, thought this might of use to this blog's readership.

There's a new Eclipse Magazine (www.eclipsemag.net) out there. The inaugural issue of the magazine is available for FREE. You can download it from here. Once you register, you also have FREE access to the magazine for the months of September, October, and November 2006.

Carol,

If you are seeking for a writer for your magazine, you can contact me.

FYI, I will speak at Java User Group conference (Thursday September 28th, 2006 in Strasbourg) about Eclipse RCP.

Serge Baccou

Hi Serge

The page you refered too in the post above isn't available to everyone. Is it normal ?

Furthermore, are the slides downloadable somewhere ?

Thanks in advance

Joseph

Hi Joseph,

I do not understand what page you are talking about. Can you be more precise?

About the slides, are you talking about the Java User Group conference held in Strabourg?

I'm speaking about this link :
http://www.baccoubonneville.com/index.php?option=com_content&task=view&id=48&Itemid=35

When trying to open it I get :
"You are not authorized to view this resource.
You need to login."

Regarding the slides, I'm indeed refering the JUG conference held in Strasbourg.

Best regards,
Joseph

NB :

le formulaire de prise de contact là :
http://www.baccoubonneville.com/index.php?option=com_contact&task=view&contact_id=1&Itemid=44
me renvoit (avec Firefox) à la page d'erreur ayant l'url http://www.baccoubonneville.com/index.php?option=com_contact&Itemid=44 et avec comme texte :
Precondition Failed

The precondition on the request for the URL /index.php evaluated to false.

C'est dommage !

The page http://www.baccoubonneville.com/index.php?option=com_content&task=view&id=48&Itemid=35 was to make some promotion about the JUG conference. It has been unpublished as soon as the conference has been done.

The slides are now on our web site http://www.baccoubonneville.com.

For the problem you have about the contact form, I will investigate what is going wrong with this.

Serge

to avoid 'go' syntax error use delimiter.

Ex ;


<sql driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/database?useUnicode=true&amp;characterEncoding=UTF-8"
userid="username" password="password" delimiter='GO' >
.....