Hi,

what datasource and datasource mapping did you specify in the
<jboss> subtask of the <ejbdoclet> task?

> -----Original Message-----
> From: Richard Stack [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 18, 2003 2:36 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [JBoss-user] Table creation error
> 
> 
> 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
> 


-------------------------------------------------------
This SF.net email is sponsored by: Does your code think in ink? 
You could win a Tablet PC. Get a free Tablet PC hat just for playing. 
What are you waiting for?
http://ads.sourceforge.net/cgi-bin/redirect.pl?micr5043en
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to