[GitHub] [shardingsphere] liruhui opened a new issue, #24876: spring-namespace-error

["liruhui (via GitHub)" <gi...@apache.org>]

liruhui opened a new issue, #24876:
URL: https://github.com/apache/shardingsphere/issues/24876

   ## 1. java Code  is correctly
   ```java
   
      public static void main(String[] args) throws SQLException, InterruptedException {
           Map<String, DataSource> mapSource = new HashMap<>();
           DruidDataSource bookSource  = new DruidDataSource();
           bookSource.setDriverClassName(Driver.class.getName());
           bookSource.setUrl("jdbc:mysql://192.168.191.148:3306/db_book?serverTimezone=UTC");
           bookSource.setUsername("root");
           bookSource.setPassword("rootroot");
           DruidDataSource typeSource  = new DruidDataSource();
           typeSource.setDriverClassName(Driver.class.getName());
           typeSource.setUrl("jdbc:mysql://192.168.191.148:3307/db_type?serverTimezone=UTC");
           typeSource.setUsername("root");
           typeSource.setPassword("rootroot");
           mapSource.put("xxxx",bookSource);
           mapSource.put("yyyy",typeSource);
           //  vertical sharding database no need to configure regular automatic routing.
           //  vertical sharding database no need to configure regular automatic routing.
           DataSource abc = ShardingSphereDataSourceFactory.createDataSource(mapSource, null, new Properties());
           Connection connection = abc.getConnection();
           String sql = String.format("insert into book values(%d,'%s')",System.nanoTime(), UUID.randomUUID().toString());
           String sql1 = String.format("insert into type values(%d,'%s')",System.nanoTime(), UUID.randomUUID().toString());
           connection.prepareStatement(sql).execute();
           Thread.sleep(1200);
           connection.prepareStatement(sql1).execute();
           connection.close();
       }
   
   ```
   ## 2. ssm+sharding-jdbc+spring-namespace  error
   ```xml
   <beans xmlns="http://www.springframework.org/schema/beans"
          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
          xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"
          xmlns:shardingsphere="http://shardingsphere.apache.org/schema/shardingsphere/datasource"
          xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd http://shardingsphere.apache.org/schema/shardingsphere/datasource http://shardingsphere.apache.org/schema/shardingsphere/datasource/datasource.xsd">
   
       <bean id="book" class="com.alibaba.druid.pool.DruidDataSource">
           <property name="driverClassName" value="com.mysql.cj.jdbc.Driver"/>
           <property name="url" value="jdbc:mysql://192.168.191.148:3306/db_book?serverTimezone=UTC"/>
           <property name="username" value="root"/>
           <property name="password" value="rootroot"/>
       </bean>
   
       <bean id="type" class="com.alibaba.druid.pool.DruidDataSource">
           <property name="driverClassName" value="com.mysql.cj.jdbc.Driver"/>
           <property name="url" value="jdbc:mysql://192.168.191.148:3307/db_type?serverTimezone=UTC"/>
           <property name="username" value="root"/>
           <property name="password" value="rootroot"/>
       </bean>
   
   <!--   vertical sharding database no need to configure regular automatic routing.-->
      <shardingsphere:data-source id="dataSource" data-source-names="book, type" />
   
       <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
           <property name="dataSource" ref="dataSource"/>
       </bean>
   
       <bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
           <property name="basePackage" value="com.shangma.cn.mapper"/>
       </bean>
   
       <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
           <property name="dataSource" ref="dataSource"/>
       </bean>
   
       <tx:annotation-driven/>
   ```
   
   ## 3. error Info 
   ```java
   
   org.springframework.beans.factory.BeanDefinitionStoreException: Unexpected exception parsing XML document from class path resource [spring.xml]; nested exception is java.lang.IllegalArgumentException: 'beanName' must not be empty
   		at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:419)
   		at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:336)
   		at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:304)
   		at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:188)
   		at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:224)
   		at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:195)
   		at org.springframework.web.context.support.XmlWebApplicationContext.loadBeanDefinitions(XmlWebApplicationContext.java:125)
   		at org.springframework.web.context.support.XmlWebApplicationContext.loadBeanDefinitions(XmlWebApplicationContext.java:94)
   		at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:133)
   		at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:636)
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org