Try using Statement.execute() rather than Statement.executeUpdate()
I faced a similar problem setting options in MySQL through servlets, which the
above solved.
- simon
Matt Pacha wrote:
> I tried many SQL statements near from :
>
> String sql = "alter table table_name add (new_column_name text null)";
> insertStatement = connexion.prepareStatement(sql);
> insertStatement.executeUpdate();
>
> in order to insert a new column whereever in my table under MS-Access, but I
> always get an SQL Error:
>
> "ModifSE -- Ln 189 -- Wrong request on the table:" java.sql.SQLException:
> [Microsoft][ODBC Microsoft Access Driver] Syntax error in field definition.
>
> I checked some tutorials, and archives, without success...
> Thanks for your time,
>
> /Matt
>
> __
___________________________________________________________________________
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
