Well, this looks like a very different problem;-)

As Roman says, you need to limit the key size. For cmp 2, this would be in
jbosscmp-jdbc.xml rather than jaws.xml.

You may well also have problems that firebird requires you to explicitly
say "not null" for pk columns. Apparently with cmp2 the only way to do
that is fudging your column types as in "varchar(128) not null". With
cmp1/jaws.xml there is a <nullable>false</nullable> tag you can use.


btw, have you tried xdoclet?

david jencks

On 2002.02.08 03:08:22 -0500 Stephen J. Thompson wrote:
> Good morning David,
>
> I have tried the updates to the driver and to jboss with no success. I
> updated from CVS for both jboss and the firebird driver at 0745 GMT. The
> errors are included. Could this be an issue on the primary key size under
>
> Firebird? If so, how can you limit the size of a string for the primary
> key?
>
> 08:04:43,676 INFO [MainDeployer] Deploying:
> file:/opt/jboss-3.0.0DR1/deploy/CaSS-Security.jar
> 08:04:43,862 INFO [EJBDeployer] Verifying
> file:/opt/jboss-3.0.0DR1/deploy/CaSS-Security.jar
> 08:04:43,870 INFO [EJBDeployer] Deploying UserBean
> 08:04:44,860 INFO [EJBDeployer] Deploying GroupBean
> 08:04:44,863 INFO [EJBDeployer] Deploying SecurityManagerBean
> 08:04:46,705 INFO [EnterpriseContextCachePolicy] Cache policy scheduler
> started
> 08:04:46,839 INFO [XAConnectionManager] Got a subject: Subject:
> Principal: SYSDBA
> Private Credential:
> javax.resource.spi.security.PasswordCredential@e8000000
>
> 08:04:47,889 INFO [XAConnectionManager] Got a subject: Subject:
> Principal: SYSDBA
> Private Credential:
> javax.resource.spi.security.PasswordCredential@e8000000
>
> 08:04:48,101 ERROR [EJBDeployer] Could not deploy
> file:/opt/jboss-3.0.0DR1/deploy/CaSS-Security.jar
> org.jboss.deployment.DeploymentException: Error while creating table,
> Cause:
> java.sql.SQLException: GDSException: unsuccessful metadata updat
> e
> key size too big for index RDB$PRIMARY13
> at
> org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:176)
> at
> org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:80)
> at
> org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:329)
> at
> org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:175)
> at org.jboss.ejb.EntityContainer.start(EntityContainer.java:371)
> at org.jboss.ejb.Application.start(Application.java:219)
> at org.jboss.ejb.EJBDeployer.deploy(EJBDeployer.java:429)
> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:392)
> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:359)
> at org.jboss.deployment.MainDeployer.scan(MainDeployer.java:243)
> at org.jboss.deployment.MainDeployer.run(MainDeployer.java:229)
> at java.lang.Thread.run(Thread.java:484)
> 08:04:48,110 INFO [XAConnectionManager] Got a subject: Subject:
> Principal: SYSDBA
> Private Credential:
> javax.resource.spi.security.PasswordCredential@e8000000
>
> 08:04:48,171 INFO [XAConnectionManager] Got a subject: Subject:
> Principal: SYSDBA
> Private Credential:
> javax.resource.spi.security.PasswordCredential@e8000000
>
> 08:04:48,220 ERROR [MainDeployer] Couldn't deploy URL
> file:/opt/jboss-3.0.0DR1/deploy/CaSS-Security.jar
> org.jboss.deployment.DeploymentException: Could not deploy
> file:/opt/jboss-3.0.0DR1/deploy/CaSS-Security.jar, Cause:
> org.jboss.deployment.Dep
> loymentException: Error while creating table, Cause:
> java.sql.SQLException:
> GDSException: unsuccessful metadata update
> key size too big for index RDB$PRIMARY13
> at org.jboss.ejb.EJBDeployer.deploy(EJBDeployer.java:445)
> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:392)
> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:359)
> at org.jboss.deployment.MainDeployer.scan(MainDeployer.java:243)
> at org.jboss.deployment.MainDeployer.run(MainDeployer.java:229)
> at java.lang.Thread.run(Thread.java:484)
>
>
>
>
> Regards,
>
> Stephen.
>
>
>
>
> On Friday 08 Feb 2002 3:55 am, David Jencks wrote:
> > Thanks for finding this. There was a small error in the firebird
> driver,
> > but I think the direct cause was in the cmp create/drop table code.
> Could
> > you try it with jboss from cvs and see if it is fixed?
> >
> > thanks
> > davidjencks
> >
> > On 2002.02.07 13:29:09 -0500 Stephen J. Thompson wrote:
> > > On Thursday 07 Feb 2002 4:34 pm, David Jencks wrote:
> > > David,
> > >
> > > If you need some help, test code etc, let me know.
> > >
> > > Regards,
> > >
> > > Stephen.
> > >
> > > > Thanks. This is I think a problem (*at least mostly) in the
> > >
> > > firebirdsql
> > >
> > > > driver. I will look into it.
> > > >
> > > > david jencks
> > > >
> > > > On 2002.02.07 09:51:58 -0500 Stephen J. Thompson wrote:
> > > > > Hello All,
> > > > >
> > > > > I am not sure if this error should be placed with the JBoss team
> or
> > >
> > > here.
> > >
> > > > > Everytime I try to deploy a CMP 2.0 bean with the create table
> option
> > >
> > > set
> > >
> > > > > to
> > > > > true I get the following errors.
> >
> >
> > To unsubscribe from this group, send an email to:
> > IB-Java-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
> To unsubscribe from this group, send an email to:
> IB-Java-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>