Hallo,
Hi, I've got a problem with a selection of a datarow from a MySql Table, and I really dont know whats going wrong here
Hibernate version:
Mapping documents:
<hibernate-mapping package="model">
<class name="Adwords" table="adwords" dynamic-update="true">
<id name="id" type="int">
<generator class="native" />
</id>
<property name="Datum" type="string"/>
<property name="Kampagne" type="string"/>
<property name="Anzeigengruppe" type="string"/>
<property name="Keyword" type="string"/>
<property name="Uebereinstimmung" type="string"/>
<property name="Status" type="string"/>
<property name="MaxCPC" type="long"/>
<property name="Url" type="string"/>
<property name="Impressionen" type="int"/>
<property name="Klicks" type="int"/>
<property name="CTR" type="float"/>
<property name="Kosten" type="long"/>
<property name="AdGroupID" type="long"/>
<property name="CriterionID" type="long"/>
<property name="Position" type="float"/>
</class>
</hibernate-mapping>
Code between sessionFactory.openSession() and session.close():
session = sessionFactory.openSession();
Query query = session.createSQLQuery("select * from adwords");
List result = query.list();
Adwords adword = (Adwords) result.get(0);
System.out.println(adword.getId());
Full stack trace of any exception that occurs:
Exception in
thread "main" org.hibernate.MappingException: No Dialect mapping for
JDBC type: 7
at org.hibernate.dialect.TypeNames.get(TypeNames.java:56)
at org.hibernate.dialect.TypeNames.get(TypeNames.java:81)
at org.hibernate.dialect.Dialect.getHibernateTypeName(Dialect.java:192)
at org.hibernate.loader.custom.CustomLoader.getHibernateType(CustomLoader.java:161)
at org.hibernate.loader.custom.CustomLoader.autoDiscoverTypes(CustomLoader.java:131)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1678)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:111)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1655)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:164)
at model.AWEDBVerbindung.getAlleAdwords(AWEDBVerbindung.java:33)
at model.RunTest.main(RunTest.java:28)
Name and version of the database you are using:
MySQL
The generated SQL (show_sql=true):
select * from adwords;
The "Dialect" Property is set to "org.hibernate.dialect.MySQLDialect".
Anyone have an idea?
[ September 14, 2006: Message edited by: Sascha Rrrrrr ]
[ September 14, 2006: Message edited by: Sascha Rrrrrr ]