[JBoss-user] [EJB/JBoss] - Re: EJB deployment problem. Help me please...
Sorry about my last question, it was a silly one, but I was so tired that I didn`t saw the bug... The specified error mentioned that afther the table "u." it was a space (0x20) and then the rest of the querry (though I copied it right here because I modified, actualiy deleted, the CR/LF from the debug screen, from the command prompt) Sorry again But now I am facing another stupid error : Afther I have mentioned that the words : user, group and key; as reserved by msql and Jboss generated the table names with an X in front of them, at a table that relates the tables user and group, the Jboss throws as colum names the reserved words (with no x in front). The error is : anonymous wrote : ERROR [EntityContainer] Starting failed org.jboss.deployment.DeploymentException: Error while creating table User_groups_Group_users; - nested throwable: (java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Group INTEGER NOT NULL, User INTEGER NOT NULL, CONSTRAINT pk_Us") | at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:232) Is there any posibility to prevent Jboss from using the reserved words from the colum names? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3830538#3830538 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3830538 --- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [EJB/JBoss] - Re: EJB deployment problem. Help me please...
Thanks! It creates the table... but now it appears to be another problem... it chrashes at the following EJB-QL string : anonymous wrote : ERROR [EntityContainer] Starting failed org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'SELECT DISTINCT Object (u) FROM User AS u WHERE u.name = ?1 AND u.password = ?2'; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.TokenMgrError: Lexical error at line 1, column 53. Encountered: " " (32), after : "") (note: I have included the word user in the "reserved words") Can you give me an advice? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3830364#3830364 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3830364 --- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [EJB/JBoss] - Re: EJB deployment problem. Help me please...
In the conf/standardjbosscmp-jdbc.xml file, at the bottom, there is a list of "reserved-words", add the extra reserved words to this list. Joachim View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3830360#3830360 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3830360 --- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user