双11狂欢大促

盲盒赢 定制羽绒服

开启惊喜盲盒，抽取你的专属好礼

— 惊喜奖品抢先看 —

超级年卡50元券

周边70元券

手机支架

一拖三数据线

雨伞

运动毛巾

电动牙刷

VIP月卡

机械键盘

定制羽绒服

超级年卡50元券

周边70元券

手机支架

一拖三数据线

雨伞

运动毛巾

电动牙刷

VIP月卡

机械键盘

定制羽绒服

hibernate中用oracle nvarchar2数据类型

2013-03-08 09:02:14 504 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

it老鸟的呐喊墨衍会员 · AI 创作全网分发关注 + 加入社区

技术前沿：半导体前道检测和量测设备修复技术半导体前道检测设备是目前除光刻机外，国产渗透率较低的环节之一，近年来我国初步实现国产突破。前道检测相对后道检测环节壁垒更高，国内多家涉及后道测试，涉及前道检测和中道检测相对较少。阅读详情

在hibernate中写原生sql,不支持oracle的nvarchar2数据类型，不知道有人有解决方案不？

...全文

Proteus仿真实战：用AT89C51+L298N搭建直流电机PID调速系统（附完整工程文件）本文详细介绍了使用Proteus仿真平台结合AT89C51单片机和L298N驱动模块搭建直流电机PID闭环调速系统的全过程。从硬件选型、电路连接到PID算法实现与参数整定，提供了完整的开发指南和工程文件，帮助读者快速掌握闭环调速系统的设计与调试技巧。阅读详情

it老鸟的呐喊

Web 开发 81,108 成员 341,721 内容

+ 关注 + 加入社区

切换为时间正序

it老鸟的呐喊 2013-03-08

打赏
举报

oracle

花谢尊前不敢香 2013-03-08

打赏
举报

http://hi.baidu.com/deng1259070/item/cb63704396e73aaf61d7b9d8 可以参考上面的？你用的什么数据库？mysql，oracle？

it老鸟的呐喊 2013-03-08

打赏
举报

这是这个表的结构：


  CREATE TABLE "ISM_ACCOUNT"."REPORT_TABLE_COL_CHECK" 
   (	"ID" NUMBER(10,0) NOT NULL ENABLE, 
	"TABLE_TYPE" NVARCHAR2(10) NOT NULL ENABLE, 
	"NULLABLE" NUMBER(1,0), 
	"MAX_LENGTH" NUMBER(10,0), 
	"WORD_BOOK" NVARCHAR2(20), 
	"COLUMN_NUMBER" NUMBER(5,0), 
	"COLUMN_NAME" NVARCHAR2(60), 
	"CREATE_TIME" DATE DEFAULT sysdate, 
	"LAST_TIME" TIMESTAMP (6), 
	"META_COLUMN_ID" NUMBER(10,0), 
	"NULLABLE_MESSAGE" CLOB, 
	"MAX_LEN_MESSAGE" NVARCHAR2(1000), 
	"WORD_BOOK_MESSAGE" CLOB, 
	"CHECKER_ID" NVARCHAR2(255)
）

实体：




/**
 * ReportTableColCheck entity. @author MyEclipse Persistence Tools
 */
@Entity
@Table(name = "REPORT_TABLE_COL_CHECK", schema = "ISM_ACCOUNT")
public class ReportTableColCheck implements java.io.Serializable {

	// Fields
	private static final long serialVersionUID = 4932172468128075092L;
	private Long id;
	private String tableType;
	private Byte nullable;
	private Long maxLength;
	private String wordBook;
	private Byte columnNumber;
	private String columnName;
	private Timestamp createTime;
	private Timestamp lastTime;
	private Long metaColumnId;
	private String nullableMessage;
	private String maxLenMessage;
	private String wordBookMessage;
	private String checkerId;

	// Constructors

	/** default constructor */
	public ReportTableColCheck() {
	}

	/** minimal constructor */
	public ReportTableColCheck(String tableType) {
		this.tableType = tableType;
	}

	// Property accessors
	@SequenceGenerator(name = "generator",sequenceName="S_REPORT_TABLE_COL_CHECK")
	@Id
	@GeneratedValue(strategy = SEQUENCE, generator = "generator")
	@Column(name = "ID", unique = true, nullable = false, precision = 10, scale = 0)
	public Long getId() {
		return this.id;
	}

	public void setId(Long id) {
		this.id = id;
	}

	@Column(name = "TABLE_TYPE", nullable = false, length = 10)
	public String getTableType() {
		return this.tableType;
	}

	public void setTableType(String tableType) {
		this.tableType = tableType;
	}

	@Column(name = "NULLABLE", precision = 1, scale = 0)
	public Byte getNullable() {
		return this.nullable;
	}

	public void setNullable(Byte nullable) {
		this.nullable = nullable;
	}

	@Column(name = "MAX_LENGTH", precision = 10, scale = 0)
	public Long getMaxLength() {
		return this.maxLength;
	}

	public void setMaxLength(Long maxLength) {
		this.maxLength = maxLength;
	}

	@Column(name = "WORD_BOOK", length = 20)
	public String getWordBook() {
		return this.wordBook;
	}

	public void setWordBook(String wordBook) {
		this.wordBook = wordBook;
	}

	@Column(name = "COLUMN_NUMBER", precision = 5, scale = 0)
	public Byte getColumnNumber() {
		return this.columnNumber;
	}

	public void setColumnNumber(Byte columnNumber) {
		this.columnNumber = columnNumber;
	}

	@Column(name = "COLUMN_NAME", length = 60)
	public String getColumnName() {
		return this.columnName;
	}

	public void setColumnName(String columnName) {
		this.columnName = columnName;
	}

	@Column(name = "CREATE_TIME", length = 7)
	public Timestamp getCreateTime() {
		return this.createTime;
	}

	public void setCreateTime(Timestamp createTime) {
		this.createTime = createTime;
	}

	@Column(name = "LAST_TIME", length = 7)
	public Timestamp getLastTime() {
		return this.lastTime;
	}

	public void setLastTime(Timestamp lastTime) {
		this.lastTime = lastTime;
	}

	@Column(name = "META_COLUMN_ID", precision = 10, scale = 0)
	public Long getMetaColumnId() {
		return this.metaColumnId;
	}

	public void setMetaColumnId(Long metaColumnId) {
		this.metaColumnId = metaColumnId;
	}

	@Column(name = "NULLABLE_MESSAGE")
	public String getNullableMessage() {
		return this.nullableMessage;
	}

	public void setNullableMessage(String nullableMessage) {
		this.nullableMessage = nullableMessage;
	}

	@Column(name = "MAX_LEN_MESSAGE", length = 20)
	public String getMaxLenMessage() {
		return this.maxLenMessage;
	}

	public void setMaxLenMessage(String maxLenMessage) {
		this.maxLenMessage = maxLenMessage;
	}

	@Column(name = "WORD_BOOK_MESSAGE")
	public String getWordBookMessage() {
		return this.wordBookMessage;
	}

	public void setWordBookMessage(String wordBookMessage) {
		this.wordBookMessage = wordBookMessage;
	}

	@Column(name = "CHECKER_ID")
	public String getCheckerId() {
		return this.checkerId;
	}

	public void setCheckerId(String checkerId) {
		this.checkerId = checkerId;
	}

}

这是查询的java方法：


public List<ReportTableColumnNumber> findReportTableNumber() {
		List<ReportTableColumnNumber> resList = new ArrayList<ReportTableColumnNumber>();
		String reportTableHqlByType = "select table_type, count(table_type) nums from report_table_col_check group by table_type order by table_type ";
		Query query = getSession().createSQLQuery(reportTableHqlByType);
//		String reportTableHqlByType = "select tableType, count(tableType) from ReportTableColCheck group by tableType order by tableType ";
//		Query query = getSession().createQuery(reportTableHqlByType);
		List<?> list = query.list();
		for (int i = 0; i < list.size(); i++) {
			ReportTableColumnNumber rn = new ReportTableColumnNumber();
			Object[] ovalue = (Object[])list.get(i);
			String type = (String) ovalue[0];
			BigDecimal  nums = (BigDecimal) ovalue[1];
//			Long  nums = (Long) ovalue[1];
			rn.setTableCode(type);
			rn.setColumnNumber(String.valueOf(nums.longValue()));
			resList.add(rn);
		}
		return resList;
	}

这是报错： No Dialect mapping for JDBC type :-9

小菜鸟的博客 2013-03-08

打赏
举报

sql 发出来啊亲还有错误信息啥的

licip 2013-03-08

打赏
举报

不知你dialect没有配置。

IMBA__小八 2013-03-08

打赏
举报

http://blog.csdn.net/xd195666916/article/details/5419316 参考

✦双11狂欢大促✦

hibernate中用oracle nvarchar2数据类型

相关推荐

双11狂欢大促