Hello,

This looks as if JBoss is generating SQL with reserved words in it. I would
suggest that there is a Entity Bean with the attribute TYPE on it. Try
changing it to TTYPE and see if the error goes away.

Regards,

Stephen.


-----Original Message-----
From: mattcolgan [mailto:mattcolgan@...]
Sent: 24 September 2002 12:31
To: Firebird-Java@yahoogroups.com
Subject: [Firebird-Java] problems with JBoss CMP and Firebird JCA driver


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/



-------------------------------------------------------------------------------------------

Copyright material and/or confidential and/or privileged information may be contained in this e-mail and any attached documents. The material and information is intended for the use of the intended addressee only. If you are not the intended addressee, or the person responsible for delivering it to the intended addressee, you may not copy, disclose, distribute, disseminate or deliver it to anyone else or use it in any unauthorised manner or take or omit to take any action in reliance on it. To do so is prohibited and may be unlawful. The views expressed in this e-mail may not be official policy but the personal views of the originator. If you receive this e-mail in error, please advise the sender immediately by using the reply facility in your e-mail software, or contact postmaster@.... Please also delete this e-mail and all documents attached immediately.
Many thanks for your co-operation.

BMW Financial Services (GB) Limited is registered in England and Wales under company number 01288537.
Registered Offices : Europa House, Bartley Way, Hook, Hants, RG27 9UF
------------------------------------------------------------------------------------------