Showing us the statement that failed to execute would have been helpful.

I think you are trying to name something "type" which is perhaps a reserved
word. You could try quoting all the identifiers.

david jencks

On 2002.09.24 07:30:49 -0400 mattcolgan wrote:
> Hello- I am not sure if this is a Firebird problem or a JBoss
> problem, so please let me know.
>
> I have things hooked up so I can access my database with raw JDBC in
> a servlet under JBoss, but when I run my program that generates
> tables using CMP, I am getting:
>
> 04:28:35,609 INFO [FBPreparedStatement] GDSException in
> PreparedStatement const
> ructor
> org.firebirdsql.gds.GDSException: Dynamic SQL Error
> SQL error code = -104
> Token unknown - line 1, char 59
> type
> at org.firebirdsql.jgds.GDS_Impl.readStatusVector
> (GDS_Impl.java:1455)
> at org.firebirdsql.jgds.GDS_Impl.receiveResponse
> (GDS_Impl.java:1374)
> at org.firebirdsql.jgds.GDS_Impl.isc_dsql_prepare
> (GDS_Impl.java:976)
> at org.firebirdsql.jca.FBManagedConnection.prepareSQL
> (FBManagedConnectio
> n.java:573)
> at org.firebirdsql.jdbc.FBConnection.prepareSQL
> (FBConnection.java:954)
> at org.firebirdsql.jdbc.FBStatement.prepareFixedStatement
> (FBStatement.ja
> va:913)
> at
> org.firebirdsql.jdbc.FBPreparedStatement.prepareFixedStatement(FBPrep
> aredStatement.java:736)
> at org.firebirdsql.jdbc.FBPreparedStatement.<init>
> (FBPreparedStatement.j
> ava:70)
> at org.firebirdsql.jdbc.FBConnection.prepareStatement
> (FBConnection.java:
> 151)
> at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute
> (JDBCCommand.j
> ava:173)
> at org.jboss.ejb.plugins.jaws.jdbc.JDBCInitCommand.execute
> (JDBCInitComma
> nd.java:149)
> at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.create
> (JAWSPersiste
> nceManager.java:131)
> at org.jboss.ejb.plugins.CMPPersistenceManager.create
> (CMPPersistenceMana
> ger.java:155)
> at org.jboss.ejb.EntityContainer.create
> (EntityContainer.java:337)
> at org.jboss.ejb.Container.invoke(Container.java:789)
> at org.jboss.ejb.EntityContainer.invoke
> (EntityContainer.java:1055)
> at org.jboss.mx.server.MBeanServerImpl.invoke
> (MBeanServerImpl.java:491)
> at org.jboss.system.ServiceController$ServiceProxy.invoke
> (ServiceControl
> ler.java:894)
> at $Proxy6.create(Unknown Source)
> at org.jboss.system.ServiceController.create
> (ServiceController.java:272)
>
>
>
>
> 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/
>
>
>
>
>