Issue #56 has been updated by Jonathan Clarke.

Applied in changeset r273.
----------------------------------------
Bug #56: Quickstart tutorial is broken
http://tools.lsc-project.org/issues/show/56

Author: Jonathan Clarke
Status: Feedback
Priority: High
Assigned to: 
Category: Sample
Target version: 1.1.0


On latest code, the quickstart tutorial 
(http://lsc-project.org/wiki/documentation/quickstart) fails with:

<pre>
$ ant -Dsynchronize.parameters="-s all" lsc::synchronize
Buildfile: build.xml

lsc::init:

lsc::prepare-env:
     [echo] Copying xml and properties files
     [copy] Copying 1 file to 
/Users/jclarke/Downloads/lsc-sample-1.1-SNAPSHOT/target/classes

lsc::compile-resources:
     [echo] Compiling resources

lsc::compile-app:
    [javac] Compiling 1 source file to 
/Users/jclarke/Downloads/lsc-sample-1.1-SNAPSHOT/target/classes

lsc::synchronize:
     [java] 0    [main] WARN   
org.lsc.SimpleSynchronize.launchTask(SimpleSynchronize.java:230)   - Starting 
sync for MySyncTask
     [java] 677  [main] WARN   
org.lsc.service.AbstractJdbcService.getListPivots(AbstractJdbcService.java:125) 
  - Error while looking for the entries list: 
com.ibatis.common.jdbc.exception.NestedSQLException:   
     [java] --- The error occurred in 
org/lsc/persistence/xml/InetOrgPerson.xml.  
     [java] --- The error occurred while executing query.  
     [java] --- Check the               SELECT pers.id          FROM 
INETORGPERSON pers   .  
     [java] --- Check the SQL Statement (preparation failed).  
     [java] --- Cause: java.sql.SQLException: Table not found in statement [    
        SELECT pers.id          FROM INETORGPERSON pers   ]
     [java] Caused by: java.sql.SQLException: Table not found in statement [    
        SELECT pers.id          FROM INETORGPERSON pers   ]
     [java] com.ibatis.common.jdbc.exception.NestedSQLException:   
     [java] --- The error occurred in 
org/lsc/persistence/xml/InetOrgPerson.xml.  
     [java] --- The error occurred while executing query.  
     [java] --- Check the               SELECT pers.id          FROM 
INETORGPERSON pers   .  
     [java] --- Check the SQL Statement (preparation failed).  
     [java] --- Cause: java.sql.SQLException: Table not found in statement [    
        SELECT pers.id          FROM INETORGPERSON pers   ]
     [java] Caused by: java.sql.SQLException: Table not found in statement [    
        SELECT pers.id          FROM INETORGPERSON pers   ]
     [java]     at 
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
     [java]     at 
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
     [java]     at 
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:610)
     [java]     at 
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:584)
     [java]     at 
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:101)
     [java]     at 
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:78)
     [java]     at 
org.lsc.service.AbstractJdbcService.getListPivots(AbstractJdbcService.java:117)
     [java]     at 
org.lsc.AbstractSynchronize.synchronize2Ldap(AbstractSynchronize.java:297)
     [java]     at 
org.lsc.SimpleSynchronize.launchTask(SimpleSynchronize.java:280)
     [java]     at org.lsc.SimpleSynchronize.launch(SimpleSynchronize.java:172)
     [java]     at org.lsc.Launcher.run(Launcher.java:128)
     [java]     at org.lsc.Launcher.main(Launcher.java:111)
     [java] Caused by: java.sql.SQLException: Table not found in statement [    
        SELECT pers.id          FROM INETORGPERSON pers   ]
     [java]     at org.hsqldb.jdbc.Util.throwError(Unknown Source)
     [java]     at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
     [java]     at org.hsqldb.jdbc.jdbcConnection.prepareStatement(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 
com.ibatis.common.jdbc.SimpleDataSource$SimplePooledConnection.invoke(SimpleDataSource.java:945)
     [java]     at $Proxy0.prepareStatement(Unknown Source)
     [java]     at 
com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:167)
     [java]     at 
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
     [java]     at 
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
     [java]     ... 11 more
     [java] 
     [java] Caused by: 
     [java] java.sql.SQLException: Table not found in statement [               
SELECT pers.id          FROM INETORGPERSON pers   ]
     [java]     at org.hsqldb.jdbc.Util.throwError(Unknown Source)
     [java]     at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
     [java]     at org.hsqldb.jdbc.jdbcConnection.prepareStatement(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 
com.ibatis.common.jdbc.SimpleDataSource$SimplePooledConnection.invoke(SimpleDataSource.java:945)
     [java]     at $Proxy0.prepareStatement(Unknown Source)
     [java]     at 
com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:167)
     [java]     at 
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
     [java]     at 
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
     [java]     at 
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
     [java]     at 
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:610)
     [java]     at 
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:584)
     [java]     at 
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:101)
     [java]     at 
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:78)
     [java]     at 
org.lsc.service.AbstractJdbcService.getListPivots(AbstractJdbcService.java:117)
     [java]     at 
org.lsc.AbstractSynchronize.synchronize2Ldap(AbstractSynchronize.java:297)
     [java]     at 
org.lsc.SimpleSynchronize.launchTask(SimpleSynchronize.java:280)
     [java]     at org.lsc.SimpleSynchronize.launch(SimpleSynchronize.java:172)
     [java]     at org.lsc.Launcher.run(Launcher.java:128)
     [java]     at org.lsc.Launcher.main(Launcher.java:111)
     [java] 689  [main] ERROR  
org.lsc.AbstractSynchronize.synchronize2Ldap(AbstractSynchronize.java:306)   - 
Empty or non existant source (no IDs found)
</pre>


-- 
You have received this notification because you have either subscribed to it, 
or are involved in it.
To change your notification preferences, please click here: 
http://tools.lsc-project.org/my/account
-------------- next part --------------
An HTML attachment was scrubbed...
URL: 
<http://lists.lsc-project.org/pipermail/lsc-dev/attachments/20090625/6d367ac8/attachment-0001.htm>

Reply via email to