Problem....queries are automatically generated via hibernate. There are no actual queries within the code for the portal to correct. Try to research this problem in relation to hibernate, it may be a known issue.
I am also noting that the query is related to the ACL stuff, which is not using hibernate...so maybe this is "fixable" after all. Unfortunately I'm not in a position to spend much time on this this morning, but will try to do some looking at it this afternoon. Laurel On Oct 3, 4:49 pm, "Rokham Sadeghnezhadfard" <[EMAIL PROTECTED]> wrote: > Hi all, > > I believe MySQL is swapped in successfully but we're having the following > problem. > > When I run 'ant db.init' I get the error pasted below. Before looking at the > error though, it is important to know the following: > > 1. The connection to the database is successfully done. > 2. Tables are created with their columns (I believe the columns are correct) > 3. Column 'id' referred in the error below does exist under table > 'acl_object_identity'. > > After some investigation the solution seems to be the following: > > According to MySQL's manual any form of 'JOIN' has precedence over ',' which > in return means the following statement > select * from ACL_OBJECT_IDENTITY, ACL_SID ACLI_SID, ACL_CLASS LEFT > JOIN ACL_ENTRY > ON ACL_OBJECT_IDENTITY.ID = ACL_ENTRY.ACL_OBJECT_IDENTITY LEFT JOIN ACL_SID > ON ACL_ENTRY.SID = ACL_SID.ID > > will give an error complaining that it doesn't know > ACL_OBJECT_IDENTITY.ID. This > might look awkward at first but because > JOIN has precedence over ',' MySQL engine tries to join ACL_CLASS and > ACL_ENTRY first and therefore doesn't know where > ACL_IDENTITY.ID comes from. > > The solution though is to put all the comma separated tables in a '(...)' > since brackets have precedence over JOIN. As a result the > cross product of all the comma separated tables becomes the result to be > 'LEFT JOIN'ed by ACL_ENTRY in the example above. > > Given the above 3 successes (connection to DB as well as creation of tables) > I believe if we can fix all the queries to the system according > to the above rule, we should be either finished with swapping MySQL in or > very very close to finishing (unless something else comes up) > > I know the above process can be time consuming and will need meticulous > focus but it looks like we need to do that in order to > use MySQL. If anyone has any further suggestions or you think I might be > wrong about something, please feel free to let the team know. > And if you agree with me and would like to divide the work among ourselves > please let me know and I will get started on my part. > > --------------------------------------------------------------------------------------- > Error copied from console: > > [java] Oct 3, 2007 2:59:19 PM > net.sf.sail.webapp.domain.webservice.http.impl.HttpRestTransportImpllogRequest > [java] INFO: POST:http://rails.dev.concord.org/sds/4/jnlp > [java] Oct 3, 2007 2:59:19 PM > net.sf.sail.webapp.domain.webservice.http.impl.HttpRestTransportImpllogRequest > [java] INFO: POST: <jnlp><name>PLR Everything JDIC snapshot > 20070125-0811</name><url>http://www.encorewiki.org/download/attachments/2114/plr-everything-jd... > </url></jnlp> > [java] Hibernate: > [java] insert > [java] into > [java] sds_jnlps > [java] (OPTLOCK, jnlp_id, name, url) > [java] values > [java] (?, ?, ?, ?) > [java] Hibernate: > [java] insert > [java] into > [java] jnlps > [java] (OPTLOCK, sds_jnlp_fk) > [java] values > [java] (?, ?) > [java] Hibernate: > [java] select > [java] curnitimpl0_.id as id11_1_, > [java] curnitimpl0_.OPTLOCK as OPTLOCK11_1_, > [java] curnitimpl0_.sds_curnit_fk as sds3_11_1_, > [java] sdscurnit1_.id as id6_0_, > [java] sdscurnit1_.OPTLOCK as OPTLOCK6_0_, > [java] sdscurnit1_.curnit_id as curnit3_6_0_, > [java] sdscurnit1_.name as name6_0_, > [java] sdscurnit1_.url as url6_0_ > [java] from > [java] curnits curnitimpl0_ > [java] inner join > [java] sds_curnits sdscurnit1_ > [java] on curnitimpl0_.sds_curnit_fk=sdscurnit1_.id > [java] where > [java] curnitimpl0_.id=? > [java] Hibernate: > [java] select > [java] jnlpimpl0_.id as id12_, > [java] jnlpimpl0_.OPTLOCK as OPTLOCK12_, > [java] jnlpimpl0_.sds_jnlp_fk as sds3_12_ > [java] from > [java] jnlps jnlpimpl0_ > [java] Hibernate: > [java] select > [java] sdsjnlp0_.id as id7_0_, > [java] sdsjnlp0_.OPTLOCK as OPTLOCK7_0_, > [java] sdsjnlp0_.jnlp_id as jnlp3_7_0_, > [java] sdsjnlp0_.name as name7_0_, > [java] sdsjnlp0_.url as url7_0_ > [java] from > [java] sds_jnlps sdsjnlp0_ > [java] where > [java] sdsjnlp0_.id=? > [java] Oct 3, 2007 2:59:20 PM > net.sf.sail.webapp.domain.webservice.http.impl.HttpRestTransportImpllogRequest > [java] INFO: POST:http://rails.dev.concord.org/sds/4/offering > [java] Oct 3, 2007 2:59:20 PM > net.sf.sail.webapp.domain.webservice.http.impl.HttpRestTransportImpllogRequest > [java] INFO: POST: <offering><name>Direct and Emergent Processes for > Engineering > Science</name><curnit-id>14529</curnit-id><jnlp-id>14126</jnlp-id></offering> > [java] Hibernate: > [java] insert > [java] into > [java] sds_offerings > [java] (OPTLOCK, name, sds_curnit_fk, sds_jnlp_fk, offering_id, > sds_curnitmap) > [java] values > [java] (?, ?, ?, ?, ?, ?) > [java] Hibernate: > [java] insert > [java] into > [java] offerings > [java] (OPTLOCK, sds_offering_fk) > [java] values > [java] (?, ?) > [java] Oct 3, 2007 2:59:20 PM > org.springframework.beans.factory.xml.XmlBeanDefinitionReaderloadBeanDefinitions > [java] INFO: Loading XML bean definitions from class path resource > [org/springframework/jdbc/support/sql-error-codes.xml] > [java] Oct 3, 2007 2:59:20 PM > org.springframework.jdbc.support.SQLErrorCodesFactory <init> > [java] INFO: SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, > MS-SQL, MySQL, Oracle, PostgreSQL, Sybase] > [java] PreparedStatementCallback; bad SQL grammar [select > ACL_OBJECT_IDENTITY.OBJECT_ID_IDENTITY, ACL_ENTRY.ACE_ORDER, > ACL_OBJECT_IDENTITY.ID as ACL_ID, ACL_OBJECT_IDENTITY.PARENT_OBJECT, > ACL_OBJECT_IDENTITY,ENTRIES_INHERITING, ACL_ENTRY.ID as ACE_ID, > ACL_ENTRY.MASK, ACL_ENTRY.GRANTING, ACL_ENTRY.AUDIT_SUCCESS, > ACL_ENTRY.AUDIT_FAILURE, ACL_SID.PRINCIPAL as ACE_PRINCIPAL, ACL_SID.SID as > ACE_SID, ACLI_SID.PRINCIPAL as ACL_PRINCIPAL, ACLI_SID.SID as ACL_SID, > ACL_CLASS.CLASS from ACL_OBJECT_IDENTITY, ACL_SID ACLI_SID, ACL_CLASS LEFT > JOIN ACL_ENTRY ON ACL_OBJECT_IDENTITY.ID = ACL_ENTRY.ACL_OBJECT_IDENTITY > LEFT JOIN ACL_SID ON ACL_ENTRY.SID = ACL_SID.ID where ACLI_SID.ID = > ACL_OBJECT_IDENTITY.OWNER_SID and ACL_CLASS.ID = > ACL_OBJECT_IDENTITY.OBJECT_ID_CLASS and ( > (ACL_OBJECT_IDENTITY.OBJECT_ID_IDENTITY = ? and ACL_CLASS.CLASS = ?)) order > by ACL_OBJECT_IDENTITY.OBJECT_ID_IDENTITY asc, ACL_ENTRY.ACE_ORDER asc]; > nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: > Unknown column 'ACL_OBJECT_IDENTITY.ID' in 'on clause' > [java] org.springframework.jdbc.BadSqlGrammarException: > PreparedStatementCallback; bad SQL grammar [select > ACL_OBJECT_IDENTITY.OBJECT_ID_IDENTITY, ACL_ENTRY.ACE_ORDER, > ACL_OBJECT_IDENTITY.ID as ACL_ID, ACL_OBJECT_IDENTITY.PARENT_OBJECT, > ACL_OBJECT_IDENTITY,ENTRIES_INHERITING, ACL_ENTRY.ID as ACE_ID, > ACL_ENTRY.MASK, ACL_ENTRY.GRANTING, ACL_ENTRY.AUDIT_SUCCESS, > ACL_ENTRY.AUDIT_FAILURE, ACL_SID.PRINCIPAL as ACE_PRINCIPAL, ACL_SID.SID as > ACE_SID, ACLI_SID.PRINCIPAL as ACL_PRINCIPAL, ACLI_SID.SID as ACL_SID, > ACL_CLASS.CLASS from ACL_OBJECT_IDENTITY, ACL_SID ACLI_SID, ACL_CLASS LEFT > JOIN ACL_ENTRY ON ACL_OBJECT_IDENTITY.ID = ACL_ENTRY.ACL_OBJECT_IDENTITY > LEFT JOIN ACL_SID ON ACL_ENTRY.SID = ACL_SID.ID where ACLI_SID.ID = > ACL_OBJECT_IDENTITY.OWNER_SID and ACL_CLASS.ID = > ACL_OBJECT_IDENTITY.OBJECT_ID_CLASS and ( > (ACL_OBJECT_IDENTITY.OBJECT_ID_IDENTITY = ? and ACL_CLASS.CLASS = ?)) order > by ACL_OBJECT_IDENTITY.OBJECT_ID_IDENTITY asc, ACL_ENTRY.ACE_ORDER asc]; > nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: > Unknown column 'ACL_OBJECT_IDENTITY.ID' in 'on clause' > [java] Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: > Unknown column 'ACL_OBJECT_IDENTITY.ID' in 'on clause' > [java] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java > :936) > [java] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java > :2941) > [java] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623) > [java] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715) > [java] at com.mysql.jdbc.Connection.execSQL(Connection.java:3249) > [java] at com.mysql.jdbc.PreparedStatement.executeInternal( > PreparedStatement.java:1268) > [java] at com.mysql.jdbc.PreparedStatement.executeQuery( > PreparedStatement.java:1403) > [java] at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery( > DelegatingPreparedStatement.java:92) > [java] at > org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement( > JdbcTemplate.java:594) > [java] at org.springframework.jdbc.core.JdbcTemplate.execute( > JdbcTemplate.java:537) > [java] at org.springframework.jdbc.core.JdbcTemplate.query( > JdbcTemplate.java:587) > [java] at org.springframework.jdbc.core.JdbcTemplate.query( > JdbcTemplate.java:616) > [java] at > org.acegisecurity.acls.jdbc.BasicLookupStrategy.lookupObjectIdentities( > BasicLookupStrategy.java:284) > [java] at > org.acegisecurity.acls.jdbc.BasicLookupStrategy.readAclsById( > BasicLookupStrategy.java:402) > [java] at org.acegisecurity.acls.jdbc.JdbcAclService.readAclsById( > JdbcAclService.java:112) > [java] at org.acegisecurity.acls.jdbc.JdbcAclService.readAclById( > JdbcAclService.java:93) > [java] at org.acegisecurity.acls.jdbc.JdbcAclService.readAclById( > JdbcAclService.java:103) > [java] at > net.sf.sail.webapp.service.impl.AclServiceImpl.addPermission( > AclServiceImpl.java:64) > [java] at > net.sf.sail.webapp.service.impl.AclServiceImpl.addPermission( > AclServiceImpl.java:41) > [java] at > net.sf.sail.webapp.service.offering.impl.OfferingServiceImpl.createOffering( > OfferingServiceImpl.java:131) > [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native > Method) > [java] at sun.reflect.NativeMethodAccessorImpl.invoke( > NativeMethodAccessorImpl.java:39) > [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:25) > [java] at java.lang.reflect.Method.invoke(Method.java:585) > [java] at > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection( > AopUtils.java:304) > [java] at > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint > (ReflectiveMethodInvocation.java:172) > [java] at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed( > ReflectiveMethodInvocation.java:139) > [java] at > org.springframework.transaction.interceptor.TransactionInterceptor.invoke( > TransactionInterceptor.java:107) > [java] at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed( > ReflectiveMethodInvocation.java:161) > [java] at > org.springframework.aop.framework.JdkDynamicAopProxy.invoke( > JdkDynamicAopProxy.java:204) > [java] at $Proxy24.createOffering(Unknown Source) > [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native > Method) > [java] at sun.reflect.NativeMethodAccessorImpl.invoke( > NativeMethodAccessorImpl.java:39) > [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:25) > [java] at java.lang.reflect.Method.invoke(Method.java:585) > [java] at > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection( > AopUtils.java:304) > [java] at > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint > (ReflectiveMethodInvocation.java:172) > [java] at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed( > ReflectiveMethodInvocation.java:139) > [java] at > org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke > (MethodSecurityInterceptor.java:66) > [java] at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed( > ReflectiveMethodInvocation.java:161) > [java] at > org.springframework.aop.framework.JdkDynamicAopProxy.invoke( > JdkDynamicAopProxy.java:204) > [java] at $Proxy24.createOffering(Unknown Source) > [java] at > net.sf.sail.webapp.CreateDefaultOfferings.createDefaultOfferings( > CreateDefaultOfferings.java:93) > [java] at net.sf.sail.webapp.Initializer.main(Initializer.java:86) > > -- > Regards, > > Rokham Sadeghnezhadfard > University of Toronto > Software Engineering Specialist --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SAIL-Dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/SAIL-Dev?hl=en -~----------~----~----~----~------~----~------~--~---
