Hello Alex

I've included the bean (PhoneBean) with xdoclet tags. The problem seen
to be with using
byte/Byte for NUMB_TYPE It went away when I switched to int/Integer.

Richard

Alex Loubyansky wrote:
> 
> Richard,
> 
> could you provide more info about the entity? How can I reproduce it?
> 
> Thanks,
> alex
> 
> Monday, March 17, 2003, 10:14:47 PM, you wrote:
> 
> RS> Jboss is creating a malformed SQL statement in creating a table. It
> RS> sticks an extra invalid parenthesis in "NUMB_TYPE NUMBER(3)) NOT NULL"
> 
> RS> How do I go about logging this bug?
> 
> RS> Windows NT 4.0
> RS> JBoss3.2.0RC3_tomcat-4.1.18
> RS> Xdoclet 1.2beta2
> RS> Oracle8i
> 
> RS> 2003-03-17 14:24:36,283 DEBUG
> RS> [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.Phone] Executing SQL:
> RS> CREATE TABLE PHONE (PHONE_ID NUMBER(10) NOT NULL, PHONE_NUMB
> RS> varchar(255), NUMB_TYPE NUMBER(3)) NOT NULL, CUSTOMER_ID_FK NUMBER(10),
> RS> CONSTRAINT PK_PHONE PRIMARY KEY (PHONE_ID))
> RS> 2003-03-17 14:24:36,394 DEBUG
> RS> [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.Phone] Could not create
> RS> table PHONE
> RS> 2003-03-17 14:24:36,404 DEBUG [org.jboss.util.NestedThrowable]
> RS> org.jboss.util.NestedThrowable.parentTraceEnabled=true
> RS> 2003-03-17 14:24:36,414 DEBUG [org.jboss.util.NestedThrowable]
> RS> org.jboss.util.NestedThrowable.nestedTraceEnabled=false
> RS> 2003-03-17 14:24:36,414 DEBUG [org.jboss.util.NestedThrowable]
> RS> org.jboss.util.NestedThrowable.detectDuplicateNesting=true
> RS> 2003-03-17 14:24:36,414 ERROR [org.jboss.ejb.EntityContainer] Starting
> RS> failed
> RS> org.jboss.deployment.DeploymentException: Error while creating table; -
> RS> nested throwable: (java.sql.SQLException: ORA-00922: missing or invalid
> RS> option
> 
> RS> Richard
> 
> -------------------------------------------------------
> This SF.net email is sponsored by:Crypto Challenge is now open!
> Get cracking and register here for some mind boggling fun and
> the chance of winning an Apple iPod:
> http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user

Attachment: PhoneBean.java
Description: application/unknown-content-type-java_auto_file

Reply via email to