Access JDBC LONGVARCHAR

Thread view:

Ian deSouza - 01 Jul 2003 23:16 GMT

I'm getting the following error:

create table Categories (CategoryID INTEGER, CategoryName VARCHAR,
Description LONGVARCHAR, Picture LONGVARBINARY)

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]
Syntax error in field definition.
    at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6879)
    at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7036)
    at sun.jdbc.odbc.JdbcOdbc.SQLPrepare(JdbcOdbc.java:4784)
    at sun.jdbc.odbc.JdbcOdbcConnection.prepareStatement(JdbcOdbcConnection.java:475)
    at sun.jdbc.odbc.JdbcOdbcConnection.prepareStatement(JdbcOdbcConnection.java:443)

Any ideas? I imagine that Access does like LONGVARBINARY, even though
the driver tells me that this column is that SQL type when viewing the
database.metadata getColumns()..

Thanks in advance, Ian

Reply to this Message

Andy Flowers - 02 Jul 2003 08:06 GMT

Your SQL syntax is wrong for MS Access. The LONGVARCHAR is not recognised by
Access, and neither is LONGVARBINARY.

Remember all that, basically, JDBC does with SQL statements is pass them
straight through to the database engine where it is validated and
interpreted.

I'd suggest that you MEMO instead of LONGVARCHAR and IMAGE instead of
LONGVARBINARY.

Test the query out in Access to ensure that it works OK before porting it to
the Java/JDBC-ODBC environment.

> I'm getting the following error:
>
[quoted text clipped - 7 lines]
> at sun.jdbc.odbc.JdbcOdbc.SQLPrepare(JdbcOdbc.java:4784)
> at

sun.jdbc.odbc.JdbcOdbcConnection.prepareStatement(JdbcOdbcConnection.java:47
5)

> at

sun.jdbc.odbc.JdbcOdbcConnection.prepareStatement(JdbcOdbcConnection.java:44
3)

> Any ideas? I imagine that Access does like LONGVARBINARY, even though
> the driver tells me that this column is that SQL type when viewing the
> database.metadata getColumns()..
>
> Thanks in advance, Ian

Reply to this Message

Access JDBC LONGVARCHAR

Free Magazines