[ https://issues.apache.org/jira/browse/EAGLE-628?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
wujinhu updated EAGLE-628: -------------------------- Description: 1. when Site Id/Display Name/Description is missing, it will fail to create site(some flelds of sql are missing). 2. configuration should be saved in applicationentity 3. enable update application entity 4. fix application descriptor of applicationEntity: fetch from ApplicationProviderService 5. delete site throw exception Caused by: java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1). at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870) at com.mysql.jdbc.PreparedStatement.checkBounds(PreparedStatement.java:3391) at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3376) at com.mysql.jdbc.PreparedStatement.setString(PreparedStatement.java:4102) at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:135) at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:135) at org.apache.eagle.metadata.store.jdbc.service.orm.SiteEntityToRelation.accept(SiteEntityToRelation.java:56) at org.apache.eagle.metadata.store.jdbc.service.orm.SiteEntityToRelation.accept(SiteEntityToRelation.java:29) at org.apache.eagle.metadata.store.jdbc.JDBCMetadataMetadataStoreServiceImpl.update(JDBCMetadataMetadataStoreServiceImpl.java:216) at org.apache.eagle.metadata.store.jdbc.service.SiteEnt was: 1. when Site Id/Display Name/Description is missing, it will fail to create site(some flelds of sql are missing). 2. configuration should be saved in applicationentity 3. enable update application entity 4. throw IllegalArgumentException("Duplicated appId), but table is empty 5. delete site throw exception Caused by: java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1). at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870) at com.mysql.jdbc.PreparedStatement.checkBounds(PreparedStatement.java:3391) at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3376) at com.mysql.jdbc.PreparedStatement.setString(PreparedStatement.java:4102) at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:135) at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:135) at org.apache.eagle.metadata.store.jdbc.service.orm.SiteEntityToRelation.accept(SiteEntityToRelation.java:56) at org.apache.eagle.metadata.store.jdbc.service.orm.SiteEntityToRelation.accept(SiteEntityToRelation.java:29) at org.apache.eagle.metadata.store.jdbc.JDBCMetadataMetadataStoreServiceImpl.update(JDBCMetadataMetadataStoreServiceImpl.java:216) at org.apache.eagle.metadata.store.jdbc.service.SiteEnt > Fix jdbc metadata bugs > ---------------------- > > Key: EAGLE-628 > URL: https://issues.apache.org/jira/browse/EAGLE-628 > Project: Eagle > Issue Type: Bug > Affects Versions: v0.5.0 > Reporter: wujinhu > Assignee: wujinhu > Fix For: v0.5.0 > > > 1. when Site Id/Display Name/Description is missing, it will fail to create > site(some flelds of sql are missing). > 2. configuration should be saved in applicationentity > 3. enable update application entity > 4. fix application descriptor of applicationEntity: fetch from > ApplicationProviderService > 5. delete site throw exception > Caused by: java.sql.SQLException: Parameter index out of range (2 > number of > parameters, which is 1). > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870) > at > com.mysql.jdbc.PreparedStatement.checkBounds(PreparedStatement.java:3391) > at > com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3376) > at > com.mysql.jdbc.PreparedStatement.setString(PreparedStatement.java:4102) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:135) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:135) > at > org.apache.eagle.metadata.store.jdbc.service.orm.SiteEntityToRelation.accept(SiteEntityToRelation.java:56) > at > org.apache.eagle.metadata.store.jdbc.service.orm.SiteEntityToRelation.accept(SiteEntityToRelation.java:29) > at > org.apache.eagle.metadata.store.jdbc.JDBCMetadataMetadataStoreServiceImpl.update(JDBCMetadataMetadataStoreServiceImpl.java:216) > at org.apache.eagle.metadata.store.jdbc.service.SiteEnt -- This message was sent by Atlassian JIRA (v6.3.4#6332)