赤道 ftp:No Dialect mapping for JDBC type: 7
来源:百度文库 编辑:九乡新闻网 时间:2024/10/02 17:55:01
http://topic.csdn.net/u/20090304/20/d466a78e-2b2c-4623-8973-c998dda5612a.html没想到用SQLQUERY的时候可以有个简单的东西,就是我看了错误信息有很多关于list的,网上帮你搜了一下,希望对你有所帮助。
createQuery与createSQLQuery两者区别是:
前者用的hql语句进行查询,后者可以用sql语句查询
前者以hibernate生成的Bean为对象装入list返回
后者则是以对象数组进行存储
所以使用createSQLQuery有时候也想以hibernate生成的Bean为对象装入list返回,就不是很方便
突然发现createSQLQuery有这样一个方法可以直接转换对象
Query query = session.createSQLQuery(sql).addEntity(XXX.class);
XXX 代表以hibernate生成的Bean的对象,也就是数据表映射出的Bean。
太牛了啊.我郁闷啊.
http://starrystarry-night.iteye.com/blog/566391No Dialect mapping for JDBC type: 7
I got this error while I was working with hibernate and SQL Server. Following are the findings I came across. Hope this helps you too rectify this error.
Following questions are relevant to understand this clearly.
What is jdbc type 7?
java.sql.Type.REAL : It is a constant in the java programming language, that identifies SQL type REAL.
Value of this constant is 7. This is the above mentioned jdbc type 7.
What is dialect?
Dialect is the type of the database that hibernate is going to use. Following are the commonly used dialects. These are the subclasses of the org.hibernate.dialect.Dialect for specific databases.
org.hibernate.dialect.HSQLDialect
org.hibernate.dialect.Oracle9Dialect
org.hibernate.dialect.MySQLDialect
org.hibernate.dialect.SQLServerDialect
org.hibernate.dialect.FirebirdDialect
What cause this error to occur?
The database may contain a table with field of datatype real. Hibernate dialect SQLServerDialect doesnot understand this type. So we need to explicitly convert this real type to one that dialect can understand. One way to achieve this is to write a subclass of org.hibernate.dialect.SQLServerDialect.
package co.nr.javaalert.hibernate.dialect;
import java.sql.Types;
public class SubSQLServerDialect extends org.hibernate.dialect.SQLServerDialect{
public SQLServerDialectForBilling() {
super();
registerColumnType(Types.REAL,"number($p,$s)");
registerHibernateType(Types.REAL,"double");
}
}
registerColumnType() method register a type name for a given type code. This step register sql column data type NUMBER(precision,scale) to Types.REAL. Then register this Types.REAL with a data type that can understand hibernate. The recommended Java mapping for the sql REAL type is as a Java float.
Use this subclass instead of org.hibernate.dialect.SQLServerDialect in hibernate.cfg.xml.
Reference
SQL dialects reference/Data structure definition/Data types/Numeric types
原文:http://www.fengfly.com/plus/view-168177-1.htmlRDBMS 方言 DB2org.hibernate.dialect.DB2DialectDB2 AS/400org.hibernate.dialect.DB2400DialectDB2 OS390org.hibernate.dialect.DB2390DialectPostgreSQLorg.hibernate.dialect.PostgreSQLDialectMySQLorg.hibernate.dialect.MySQLDialectMySQL with InnoDBorg.hibernate.dialect.MySQLInnoDBDialectMySQL with MyISAMorg.hibernate.dialect.MySQLMyISAMDialectOracle (any version)org.hibernate.dialect.OracleDialectOracle 9i/10gorg.hibernate.dialect.Oracle9DialectSybaseorg.hibernate.dialect.SybaseDialectSybase Anywhereorg.hibernate.dialect.SybaseAnywhereDialectMicrosoft SQL Serverorg.hibernate.dialect.SQLServerDialectSAP DBorg.hibernate.dialect.SAPDBDialectInformixorg.hibernate.dialect.InformixDialectHypersonicSQLorg.hibernate.dialect.HSQLDialectIngresorg.hibernate.dialect.IngresDialectProgressorg.hibernate.dialect.ProgressDialectMckoi SQLorg.hibernate.dialect.MckoiDialectInterbaseorg.hibernate.dialect.InterbaseDialectPointbaseorg.hibernate.dialect.PointbaseDialectFrontBaseorg.hibernate.dialect.FrontbaseDialectFirebirdorg.hibernate.dialect.FirebirdDialect以上是转载来的///////////////////////////////////////////////////////////////////////////////////////////有时候,hibernate用原生SQL 查询,native SQL 的时候,会出现org.hibernate.MappingException: No Dialect mapping for JDBC type: -1 ,-16,等等的错误type 类型代码 可以看 java.sql.Types 中的定义,看源码就可以了
那是因为 Dialect 未定义,重写类,把未定义的Dialect 注册一下即可,并且在 hibernate.cfg.xml中加入Xml代码
Java代码
createQuery与createSQLQuery两者区别是:
前者用的hql语句进行查询,后者可以用sql语句查询
前者以hibernate生成的Bean为对象装入list返回
后者则是以对象数组进行存储
所以使用createSQLQuery有时候也想以hibernate生成的Bean为对象装入list返回,就不是很方便
突然发现createSQLQuery有这样一个方法可以直接转换对象
Query query = session.createSQLQuery(sql).addEntity(XXX.class);
XXX 代表以hibernate生成的Bean的对象,也就是数据表映射出的Bean。
太牛了啊.我郁闷啊.
http://starrystarry-night.iteye.com/blog/566391No Dialect mapping for JDBC type: 7
I got this error while I was working with hibernate and SQL Server. Following are the findings I came across. Hope this helps you too rectify this error.
Following questions are relevant to understand this clearly.
What is jdbc type 7?
java.sql.Type.REAL : It is a constant in the java programming language, that identifies SQL type REAL.
Value of this constant is 7. This is the above mentioned jdbc type 7.
What is dialect?
Dialect is the type of the database that hibernate is going to use. Following are the commonly used dialects. These are the subclasses of the org.hibernate.dialect.Dialect for specific databases.
org.hibernate.dialect.HSQLDialect
org.hibernate.dialect.Oracle9Dialect
org.hibernate.dialect.MySQLDialect
org.hibernate.dialect.SQLServerDialect
org.hibernate.dialect.FirebirdDialect
What cause this error to occur?
The database may contain a table with field of datatype real. Hibernate dialect SQLServerDialect doesnot understand this type. So we need to explicitly convert this real type to one that dialect can understand. One way to achieve this is to write a subclass of org.hibernate.dialect.SQLServerDialect.
package co.nr.javaalert.hibernate.dialect;
import java.sql.Types;
public class SubSQLServerDialect extends org.hibernate.dialect.SQLServerDialect{
public SQLServerDialectForBilling() {
super();
registerColumnType(Types.REAL,"number($p,$s)");
registerHibernateType(Types.REAL,"double");
}
}
registerColumnType() method register a type name for a given type code. This step register sql column data type NUMBER(precision,scale) to Types.REAL. Then register this Types.REAL with a data type that can understand hibernate. The recommended Java mapping for the sql REAL type is as a Java float.
Use this subclass instead of org.hibernate.dialect.SQLServerDialect in hibernate.cfg.xml.
Reference
SQL dialects reference/Data structure definition/Data types/Numeric types
原文:http://www.fengfly.com/plus/view-168177-1.html
Hibernate 数据库连接及SQLDialect 错误: No Dialect mapping for JDBC type
时间:2010-01-22 14:19 点击:1235次 字体:[大 中 小]Hibernate 不同数据库的连接及SQL方言
如果出现如下错误,则可能是Hibernate SQL方言 (hibernate.dialect)设置不正确。
Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]'last_insert_id' 不是可以识别的 函数名。
那是因为 Dialect 未定义,重写类,把未定义的Dialect 注册一下即可,并且在 hibernate.cfg.xml中加入Xml代码
name="hibernate.dialect"> - org.hibernate.dialect.OracleCustomDialect
Java代码
- import java.sql.Types;
- import org.hibernate.Hibernate;
- public class OracleCustomDialect extends org.hibernate.dialect.Oracle10gDialect {
- public OracleCustomDialect() {
- super();
- registerHibernateType(Types.FLOAT, Hibernate.FLOAT.getName());
- }
- }
- public class Oracle9Dialect extends Dialect {
- private static final Logger log = LoggerFactory.getLogger( Oracle9Dialect.class );
- public Oracle9Dialect() {
- super();
- log.warn( "The Oracle9Dialect dialect has been deprecated; use either Oracle9iDialect or Oracle10gDialect instead" );
- registerColumnType( Types.BIT, "number(1,0)" );
- registerColumnType( Types.BIGINT, "number(19,0)" );
- registerColumnType( Types.SMALLINT, "number(5,0)" );
- registerColumnType( Types.TINYINT, "number(3,0)" );
- registerColumnType( Types.INTEGER, "number(10,0)" );
- registerColumnType( Types.CHAR, "char(1 char)" );
- registerColumnType( Types.VARCHAR, 4000, "varchar2($l char)" );
- registerColumnType( Types.VARCHAR, "long" );
- registerColumnType( Types.FLOAT, "float" );
- registerColumnType( Types.DOUBLE, "double precision" );
- registerColumnType( Types.DATE, "date" );
- registerColumnType( Types.TIME, "date" );
- registerColumnType( Types.TIMESTAMP, "timestamp" );
- registerColumnType( Types.VARBINARY, 2000, "raw($l)" );
- registerColumnType( Types.VARBINARY, "long raw" );
- registerColumnType( Types.NUMERIC, "number($p,$s)" );
- registerColumnType( Types.DECIMAL, "number($p,$s)" );
- registerColumnType( Types.BLOB, "blob" );
- registerColumnType( Types.CLOB, "clob" );
- ……
- ……
- public class Oracle10gDialect extends Oracle9iDialect {
- public Oracle10gDialect() {
- super();
- }
- public JoinFragment createOuterJoinFragment() {
- return new ANSIJoinFragment();
- }
- }
- protected Dialect() {
- log.info( "Using dialect: " + this );
- sqlFunctions.putAll( STANDARD_AGGREGATE_FUNCTIONS );
- // standard sql92 functions (can be overridden by subclasses)
- registerFunction( "substring", new SQLFunctionTemplate( Hibernate.STRING, "substring(?1, ?2, ?3)" ) );
- registerFunction( "locate", new SQLFunctionTemplate( Hibernate.INTEGER, "locate(?1, ?2, ?3)" ) );
- registerFunction( "trim", new SQLFunctionTemplate( Hibernate.STRING, "trim(?1 ?2 ?3 ?4)" ) );
- registerFunction( "length", new StandardSQLFunction( "length", Hibernate.INTEGER ) );
- registerFunction( "bit_length", new StandardSQLFunction( "bit_length", Hibernate.INTEGER ) );
- registerFunction( "coalesce", new StandardSQLFunction( "coalesce" ) );
- registerFunction( "nullif", new StandardSQLFunction( "nullif" ) );
- registerFunction( "abs", new StandardSQLFunction( "abs" ) );
- registerFunction( "mod", new StandardSQLFunction( "mod", Hibernate.INTEGER) );
- registerFunction( "sqrt", new StandardSQLFunction( "sqrt", Hibernate.DOUBLE) );
- registerFunction( "upper", new StandardSQLFunction("upper") );
- registerFunction( "lower", new StandardSQLFunction("lower") );
- registerFunction( "cast", new CastFunction() );
- registerFunction( "extract", new SQLFunctionTemplate(Hibernate.INTEGER, "extract(?1 ?2 ?3)") );
- //map second/minute/hour/day/month/year to ANSI extract(), override on subclasses
- registerFunction( "second", new SQLFunctionTemplate(Hibernate.INTEGER, "extract(second from ?1)") );
- registerFunction( "minute", new SQLFunctionTemplate(Hibernate.INTEGER, "extract(minute from ?1)") );
- registerFunction( "hour", new SQLFunctionTemplate(Hibernate.INTEGER, "extract(hour from ?1)") );
- registerFunction( "day", new SQLFunctionTemplate(Hibernate.INTEGER, "extract(day from ?1)") );
- registerFunction( "month", new SQLFunctionTemplate(Hibernate.INTEGER, "extract(month from ?1)") );
- registerFunction( "year", new SQLFunctionTemplate(Hibernate.INTEGER, "extract(year from ?1)") );
- registerFunction( "str", new SQLFunctionTemplate(Hibernate.STRING, "cast(?1 as char)") );
- // register hibernate types for default use in scalar sqlquery type auto detection
- registerHibernateType( Types.BIGINT, Hibernate.BIG_INTEGER.getName() );
- registerHibernateType( Types.BINARY, Hibernate.BINARY.getName() );
- registerHibernateType( Types.BIT, Hibernate.BOOLEAN.getName() );
- registerHibernateType( Types.CHAR, Hibernate.CHARACTER.getName() );
- registerHibernateType( Types.DATE, Hibernate.DATE.getName() );
- registerHibernateType( Types.DOUBLE, Hibernate.DOUBLE.getName() );
- registerHibernateType( Types.FLOAT, Hibernate.FLOAT.getName() );
- registerHibernateType( Types.INTEGER, Hibernate.INTEGER.getName() );
- registerHibernateType( Types.SMALLINT, Hibernate.SHORT.getName() );
- registerHibernateType( Types.TINYINT, Hibernate.BYTE.getName() );
- registerHibernateType( Types.TIME, Hibernate.TIME.getName() );
- registerHibernateType( Types.TIMESTAMP, Hibernate.TIMESTAMP.getName() );
- registerHibernateType( Types.VARCHAR, Hibernate.STRING.getName() );
- registerHibernateType( Types.VARBINARY, Hibernate.BINARY.getName() );
- registerHibernateType( Types.NUMERIC, Hibernate.BIG_DECIMAL.getName() );
- registerHibernateType( Types.DECIMAL, Hibernate.BIG_DECIMAL.getName() );
- registerHibernateType( Types.BLOB, Hibernate.BLOB.getName() );
- registerHibernateType( Types.CLOB, Hibernate.CLOB.getName() );
- registerHibernateType( Types.REAL, Hibernate.FLOAT.getName() );
No Dialect mapping for JDBC type: 7
hibernate.dialect' must be set when no Connection available错误
No One Speaks for Me
Wildcard script mapping and IIS 7 integrated ...
Chinese vice premier calls for better use of surveying, mapping data
'No new US jets for Taiwan'
No date for fully convertible yuan
No Ring For Wills 威廉王子不戴婚戒
Libya war: No carrots, only sticks for Gadhaf...
[]Libya war: No carrots, only sticks for Gadhaf...]
The prefix "tx" for element "tx:advice" is no...
No cover to be allowed for dirty deals
MIME TYPE
Hibernate的dialect大全
Give up your life for Country? Today’s Japanese say No
mule的jdbc transport
Type 1 personalities
NO.7北宋.米芾《蜀素帖》
因为Dialect设置而引发的故障
JDBC连接各种数据库方法
使用JDBC进行数据访问
JDBC 解释:
选择合适的JDBC驱动程序
15.3 Oracle JDBC驱动程序 - AJava