Issue #56 has been updated by Jonathan Clarke. Status changed from Feedback to Closed
This seems to be fixed OK now. As for the cleaning up, it will probably never happen, since version 1.2 plans to remove lsc-sample completely. The demo code should be kept, though. ---------------------------------------- Bug #56: Quickstart tutorial is broken http://tools.lsc-project.org/issues/show/56 Author: Jonathan Clarke Status: Closed Priority: High Assigned to: Jonathan Clarke 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/20090702/b4ac5b92/attachment-0001.htm>
