In fact, none of these trics worked...
I've got to apologize but it appeared that I was using
a 2nd CMP bean with an 'index' parameter with getIndex
and setIndex methods...
When jboss tried to create the SQL table, the SQL
statement was something like:
create table sequenceentity
(
index ...
)
and index is a keyword (at least for mysql)...
I just changed the name from index to tableIndex and
it worked :D
thank you to all who tried to help me ;)
Wonder Sonic
--- [EMAIL PROTECTED] a écrit : > wonder sonic,
>
> Your first problem, I think, is that you have not
> flushed the tables to make
> the new user permissions take effect. Check out the
> docs for the mysqladmin
> tool.
>
> As for the second, try the SQL statement from the
> command line to see where
> it is malformed. This might help you debug the
> problem.
> From the partial SQL statement, it looks as if a
> comma is needed between the
> CONSTRAINT clause and the PRIMARY KEY clause.
>
> Good luck,
> - Mike Hewitt
> [EMAIL PROTECTED]
>
> -----Original Message-----
> From: wonder sonic [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 07, 2002 5:27 AM
> To: [EMAIL PROTECTED]
> Subject: [JBoss-user] MySQL strange behaviour
>
>
> Hi,
> I've done it (mysql and jboss 3.0 communication)
> but...
> -1- I can't connect with the user/password I want
> though I've added the user/password in mysql.user
> and
> granted all on my db for this user. The only user
> who
> have access is 'root' (without password).
>
> -2- After JBoss created the first SQL table (for the
> 1st CMP entity bean deployment), I get the following
> error:
>
> <snip>
>
>
>
_______________________________________________________________
>
> Don't miss the 2002 Sprint PCS Application
> Developer's Conference
> August 25-28 in Las Vegas --
> http://devcon.sprintpcs.com/adp/index.cfm
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
>
https://lists.sourceforge.net/lists/listinfo/jboss-user
___________________________________________________________
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com
-------------------------------------------------------
Sponsored by:
ThinkGeek at http://www.ThinkGeek.com/
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
