Hi, Please keep replies on the list, so that everyone can benefit, and jump in.
On 02/11/2009 14:19, eric galant wrote:
Thank, I added lsc.tasks.MySyncTask.object=org.lsc.objects.inetOrgPerson in lsc.properties I use this command : ant -Dsynchronize.parameters="-f $PWD/etc -s all" lsc::synchronize And I have this error : lsc::synchronize: [java] 0 - WARN - Starting sync for MySyncTask (db2ldap) [java] 469 - WARN - 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.mail AS mail FROM INETORGPERSON pers . [java] --- Check the SQL Statement (preparation failed). [java] --- Cause: java.sql.SQLException: Table not found in statement [ SELECT pers.mail AS mail FROM INETORGPERSON pers ] [java] Caused by: java.sql.SQLException: Table not found in statement [ SELECT pers.mail AS mail 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.mail AS mail FROM INETORGPERSON pers . [java] --- Check the SQL Statement (preparation failed). [java] --- Cause: java.sql.SQLException: Table not found in statement [ SELECT pers.mail AS mail FROM INETORGPERSON pers ] [java] Caused by: java.sql.SQLException: Table not found in statement [ SELECT pers.mail AS mail 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:125) [java] at org.lsc.Launcher.main(Launcher.java:113) [java] Caused by: java.sql.SQLException: Table not found in statement [ SELECT pers.mail AS mail 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:597) [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: I don't know why it can't find a table... Ps : In finally, we would like use LSC to sync Oracle database to OpenLDAP.
The request that is causing the error seems to be "SELECT pers.mail AS mail FROM INETORGPERSON pers". A few ideas on this:
- Did you set up the database.* properties in lsc.properties? (see the etc/lsc.properties-sample file for a description)
- Did you change the request in etc/sql-map-config.d/*.xml? - Do you really have a table called "INETORGPERSON" in your database? Hope this helps, Jonathan _______________________________________________ lsc-users mailing list [email protected] http://lists.lsc-project.org/listinfo/lsc-users
