Hi, Thanks for your reply. We use the third way to connect to the SAS share server. The select query works fine. But it will throw error when I do the insert query. Do you know why the method is not supported? Thanks. package com.demo.dao;
import java.util.List;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Service;
import com.demo.model.User;
@Service
@Mapper
public interface UserDAO {
String TABLE_NAME = " sc.test ";
String INSERT_FIELDS = " age, name, gender ";
@Select({ "select * ", " from ", TABLE_NAME })
List<User> getAllUsers();
@Insert({ "insert into ", TABLE_NAME, "(", INSERT_FIELDS,
") values (#{age},#{name},#{gender})" })
void addUser(User user);
} ### Error updating database. Cause: com.sas.rio.MVASQLExceptionUnsupported: Method not supported.
### SQL: insert into sc.test ( age, name, gender ) values (?,?,?)
### Cause: com.sas.rio.MVASQLExceptionUnsupported: Method not supported.
; ]; Method not supported.; nested exception is com.sas.rio.MVASQLExceptionUnsupported: Method not supported.] with root cause
com.sas.rio.MVASQLExceptionUnsupported: Method not supported.
at com.sas.rio.MVAConnection.prepareStatement(MVAConnection.java:1025) ~[connection-1.jar:904300.0.0.20150204190000_v940m3]
at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:325) ~[HikariCP-2.7.9.jar:na]
at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java) ~[HikariCP-2.7.9.jar:na]
... View more