多源数据库如何各自使用pojo?

1楼•2087天前

http://www.nutzam.com/core/dao/multiple_datasource.html

wx_chrohf6r75suj7q2r8fh 2楼•2087天前

@IocBean(args={"refer:dataSourceorcl"})
@Table("scott.zzh_obd")
public class zzh_obd {
@Column
private String EQP_NAME;
@Column
private String DIRE_NO;
@Column

Caused by: java.lang.RuntimeException: class=sjk.zzh_obd
at org.nutz.dao.util.Daos.createTables(Daos.java:547)
at org.nutz.dao.util.Daos.createTablesInPackage(Daos.java:463)
at main.MainSetup.init(MainSetup.java:25)
at org.nutz.mvc.impl.NutLoading.evalSetup(NutLoading.java:278)
at org.nutz.mvc.impl.NutLoading.load(NutLoading.java:121)
... 54 more
Caused by: org.nutz.dao.DaoException: !Nutz SQL Error: 'CREATE TABLE scott.zzh_obd(
EQP_NAME VARCHAR(128),
DIRE_NO VARCHAR(128),
OLT_IP VARCHAR(128),
PON_XH VARCHAR(128))'
PreparedStatement:
'CREATE TABLE scott.zzh_obd(
EQP_NAME VARCHAR(128),
DIRE_NO VARCHAR(128),
OLT_IP VARCHAR(128),
PON_XH VARCHAR(128))'
CaseMessage=指定的架构名称 "scott" 不存在，或者您没有使用该名称的权限。
at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:104)
at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66)
at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22)
at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64)
at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139)
at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:159)
at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:126)
at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:93)
at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:82)
at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:240)
at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:252)
at org.nutz.dao.impl.DaoSupport.execute(DaoSupport.java:236)
at org.nutz.dao.impl.NutDao.execute(NutDao.java:1013)
at org.nutz.dao.impl.jdbc.sqlserver2005.Sqlserver2005JdbcExpert.createEntity(Sqlserver2005JdbcExpert.java:85)
at org.nutz.dao.impl.NutDao.create(NutDao.java:817)
at org.nutz.dao.util.Daos.createTables(Daos.java:544)
... 58 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 指定的架构名称 "scott" 不存在，或者您没有使用该名称的权限。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:775)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:676)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:649)
at com.alibaba.druid.pool.DruidPooledStatement.execute(DruidPooledStatement.java:416)
at org.nutz.dao.impl.sql.run.NutDaoExecutor._runStatement(NutDaoExecutor.java:357)
at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:60)
... 73 more