Oracle批量插入老是报错，老说我缺失表达式

Scaarf 2017-04-05 10:07:13

框架整合时，Oracle批量插入老是报错，老说我缺失表达式，用的是ssm框架

这个是Controller

	public String addBicycleList(){

		List<Bicycle> bicycleList=new ArrayList<Bicycle>();

		for(int i=1;i<=5;i++){

			Bicycle bicycle=new Bicycle();

			bicycle.setBicycleCode("bicycle00"+i);

			bicycle.setStatus(1);

			bicycle.setStationId(1001);

			bicycle.setPileId(10);

			bicycle.setUserId(4);

			bicycleList.add(bicycle);

		}

		bicycleServiceImpl.addBicycleList(bicycleList);

		return "";

	}

这是Mybatis的配置文件中的sql语句

		<insert id="addBicycleList" parameterType="java.util.List">

			<selectKey order="BEFORE" keyProperty="bicycleId" resultType="int">

				select seq_bicycle.nextval as bicycleId from dual

			</selectKey>

			insert into

				bicycle (bicycle_id,bicycle_code,status,station_id,pile_id,user_id) values

			<foreach collection="list" item="bicycle" index="index" separator="union all">

				select #{bicycle.bicycleId},#{bicycle.bicycleCode},#{bicycle.status},

					#{bicycle.stationId},#{bicycle.pileId},#{bicycle.userId} 

				 from dual

			</foreach>

		</insert>

这是Oracle数据库的表结构

报错信息

### Error updating database.  Cause: java.sql.SQLException: ORA-00936: 缺失表达式



### The error may exist in com/abc/bicycle/dao/BicycleMapper.xml

### The error may involve com.abc.bicycle.dao.BicycleMapper.addBicycleList-Inline

### The error occurred while setting parameters

### SQL: insert into     bicycle (bicycle_id,bicycle_code,status,station_id,pile_id,user_id) values           select ?,?,?,      ?,?,?       from dual     union all      select ?,?,?,      ?,?,?       from dual     union all      select ?,?,?,      ?,?,?       from dual     union all      select ?,?,?,      ?,?,?       from dual

### Cause: java.sql.SQLException: ORA-00936: 缺失表达式

...全文