Subject Re: [Firebird-Java] Re: JDBC driver which implements XADataSource?
Author Luca Lafranchi
Hi :)
I think that your column with name "type" is conflicting with Firebird's
reserved word ...

Try changing the column's name.

Ciao
Luca

Will Sargent wrote:

> --- In Firebird-Java@yahoogroups.com, Will Sargent <will_sargent@y...>
> wrote:
>
>>Okay, it works now. Sort of.
>>
>>Ironically, I had some trouble getting the checkout of jboss-j2ee to
>
> work
>
>>in the ant script, but I downloaded the source tarball for that and
>
> it
>
>>seemed to work.
>>
>>I've patched the files and they work okay, but I'm getting some
>
> strange GDS
>
>>exceptions with Dynamo when I try to run it, as well as some
>
> autocommit
>
>>issues.
>
>
> Here are the errors I'm getting:
>
> Connection-6: Connection.prepareStatement(" INSERT INTO
> das_account(account_name,type,description)
> VALUES(?,?,?)")
>
> results in
>
> org.firebirdsql.jdbc.FBSQLException: GDS Exception 335544569. Dynamic
> SQL Error
> SQL error code = -104
> Token unknown - line 1, char 39
> type
> at
> org.firebirdsql.jdbc.FBPreparedStatement.<init>(FB
> PreparedStatement.java:71)
> at
> org.firebirdsql.jdbc.FBConnection.prepareStatement
> (FBConnection.java:796)
>
> This doesn't make any sense at all, as it seems to be saying that
> Firebird doesn't parse commas. This must be a new standard of SQL-92
> I haven't seen before.
>
> Will.
>
>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>