I have exactly the same problem as Rafal, but with the following JBoss-generated query:
"CREATE TABLE user (user_id INTEGER NOT NULL,login VARCHAR(250) BINARY,
password_ VARCHAR(250) BINARY, first_name VARCHAR(250) BINARY, last_name VARCHAR(250) BINARY, gender VARCHAR(250) BINARY, email VARCHAR(250) BINARY, school_id INTEGER, CONSTRAINT pk_user PRIMARY KEY (user_id))"
I downloaded the latest JBoss 3.2.3RC1, released today but unfortunately with the same result.. Were your modification taken in account in this release or is it a different problem? Thanks,
Paul
Branch_3_2
Rafal Kedziorski wrote:
> At 20:24 28.10.2003 +0200, Alexey Loubyansky wrote:
> >> It is fixed now.
> > > In main cvs branch?
> > > Regards,
> Rafal
> > >> alex
>>
>> Rafal Kedziorski wrote:
>>
>>> hi,
>>> I'm using MySQL 4.0.13 and 4.0.14 (4.0.16 I will test tomorrow) and >>> JBoss 3.2.2. And I have problems with this query (generated by JBoss):
>>> insert into user(class_id, retail_id, mandant_id, language_id, >>> user_data_id, nickname, login_name, password, status, creation_date, >>> last_login_date) values ('35F7A660096411D89BC0D1907F000001', '1234', >>> 2, 1, null, null, '[EMAIL PROTECTED]', 'demo', 8, '2003-10-28 >>> 17:31:36', null)
>>> but the same query with space after user
>>> insert into user (class_id, retail_id, mandant_id, language_id, >>> user_data_id, nickname, login_name, password, status, creation_date, >>> last_login_date) values ('35F7A660096411D89BC0D1907F000001', '1234', >>> 2, 1, null, null, '[EMAIL PROTECTED]', 'demo', 8, '2003-10-28 >>> 17:31:36', null)
>>> works.
>>> This exception is shown:
>>> 17:31:36,406 ERROR [UserEntityBean] Could not create entity >>> 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 'user(class_id, retail_id, mandant_id, language_id, >>> user_data_id" at >>> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1651) at >>> com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:889) at >>> com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:956) at >>> com.mysql.jdbc.Connection.execSQL(Connection.java:1874) at >>> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1700 >>> ) at >>> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1569 >>> ) at >>>
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:321)
>>> at >>>
org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCMySQLCreateCommand.executeInsert(JDBCMySQLCreateCommand.java:66)
>>> at >>>
org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.performInsert(JDBCAbstractCreateCommand.java:295)
>>> at >>>
org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.execute(JDBCAbstractCreateCommand.java:144)
>>> at >>> org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:518)
>>> at >>>
org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:208) >>> at >>>
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:269)
>>> at >>> org.jboss.ejb.EntityContainer.createLocalHome(EntityContainer.java:580) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >>> Method) at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >>> at java.lang.reflect.Method.invoke(Method.java:324) at >>>
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1042) >>> at >>> org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88) >>> at >>>
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:197)
>>> at >>>
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:214)
>>>
>>> ...
>>>
>>> Regards,
>>> Rafal
>>>
>>> -------------------------------------------------------
>>> This SF.net email is sponsored by: SF.net Giveback Program.
>>> Does SourceForge.net help you be more productive? Does it
>>> help you create better code? SHARE THE LOVE, and help us help
>>> YOU! Click Here: http://sourceforge.net/donate/
>>> _______________________________________________
>>> JBoss-user mailing list
>>> [EMAIL PROTECTED]
>>> https://lists.sourceforge.net/lists/listinfo/jboss-user
>>
>>
>>
>>
>>
>> -------------------------------------------------------
>> This SF.net email is sponsored by: SF.net Giveback Program.
>> Does SourceForge.net help you be more productive? Does it
>> help you create better code? SHARE THE LOVE, and help us help
>> YOU! Click Here: http://sourceforge.net/donate/
>> _______________________________________________
>> JBoss-user mailing list
>> [EMAIL PROTECTED]
>> https://lists.sourceforge.net/lists/listinfo/jboss-user
> > > > > -------------------------------------------------------
> This SF.net email is sponsored by: SF.net Giveback Program.
> Does SourceForge.net help you be more productive? Does it
> help you create better code? SHARE THE LOVE, and help us help
> YOU! Click Here: http://sourceforge.net/donate/
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
>
------------------------------------------------------- This SF.Net email sponsored by: ApacheCon 2003, 16-19 November in Las Vegas. Learn firsthand the latest developments in Apache, PHP, Perl, XML, Java, MySQL, WebDAV, and more! http://www.apachecon.com/ _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
