Hi Laurel, I'll try to put something together tonight. Is there a specific place I should put the info? or should I just start a new page and call it something like "Installing different DBs" ?
Rokham S. On 10/9/07, Laurel Williams <[EMAIL PROTECTED]> wrote: > > > Can you start a wiki page detailing how to get mysql in place. I'll need > that in order to reproduce your problem. > > Laurel > > Rokham Sadeghnezhadfard 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.HttpRestTransportImpl > > logRequest > > [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.HttpRestTransportImpl > > logRequest > > [java] INFO: POST: <jnlp><name>PLR Everything JDIC snapshot > > 20070125-0811</name><url> > > > http://www.encorewiki.org/download/attachments/2114/plr-everything-jdic-snapshot-20070125-0811.jnlp > </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.HttpRestTransportImpl > > logRequest > > [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.HttpRestTransportImpl > > logRequest > > [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.XmlBeanDefinitionReader > > loadBeanDefinitions > > [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 > > > > > > > -- 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 -~----------~----~----~----~------~----~------~--~---
