excuse me!alpha5 can't use artifact generation from oracle9i

shszhlrh · **Joined:** Wed Aug 24, 2005 1:45 am **Posts:** 6

Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:3.0

The type java.lang.Object spans multiple columns. Only single column types allowed for single columns.

org.hibernate.cfg.JDBCBinderException: The type java.lang.Object spans multiple columns. Only single column types allowed for single columns.

what can i do?

thanks

max · **Posted:** Wed Aug 24, 2005 6:40 am

double posting doesnt help.

go read the docs on configuring reveng.xml files.

shszhlrh · **Joined:** Wed Aug 24, 2005 1:45 am **Posts:** 6

yesterday i use the follow xml : success

Quote:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-reverse-engineering PUBLIC "-//Hibernate/Hibernate Reverse Engineering DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-reverse-engineering-3.0.dtd" >

<hibernate-reverse-engineering>
<table-filter match-schema="YUANRIWLCA" match-name="BUSINESSTYPE"/>
<table-filter match-schema="YUANRIWLCA" match-name="BUSINESS"/>
<table-filter match-schema="YUANRIWLCA" match-name="ACTIVITY"/>
<table-filter match-schema="YUANRIWLCA" match-name="ACTIVITYTELCODE"/>
</hibernate-reverse-engineering>

today use the same file, why get a exception?

[/quote]

max · **Posted:** Wed Aug 24, 2005 8:18 am

you havent even shown what is going wrong and you havent configured any type mapping and this is a new version where thing changes - so if there is an error that you cannot fix with a type mapping (read the docs) then submit a jira issue with a reproducable case

snpesnpe · **Joined:** Sat Jun 12, 2004 4:49 pm **Posts:** 915

add last filter like

Code:

<table-filter match-schema=".*" match-name=".*" exclude="true" />

shszhlrh · **Joined:** Wed Aug 24, 2005 1:45 am **Posts:** 6

get this exception, when i try to reverse engineer from jdbc connection

use hibernate-tools-3.1.0.alpha5

and i have read the doc about this tool, yet not know the reason.

in my database 10 tables, i have reversed 4 tables into map files and java files. and can get the data form table.

when i reverse another table , get the exception.

please help me, thanks. [/img]

cody · **Joined:** Fri Aug 26, 2005 3:49 am **Posts:** 11

Same problem here.

Works fine with hibernate-tools-3.1.0.alpha4

max · **Posted:** Fri Aug 26, 2005 4:27 am

have you even tried to map the boolean to boolean instead of Object ? use <type-mapping> as described in the docs.

cody · **Joined:** Fri Aug 26, 2005 3:49 am **Posts:** 11

I use this type-mapping:

<type-mapping>
<sql-type jdbc-type="NUMERIC" precision="1" hibernate-type="boolean" />
</type-mapping>

and it works in alpha4

max · **Posted:** Fri Aug 26, 2005 4:42 am

see now you guys are finally being concrete ;)

does that not work in alpha5 ? then submit that concrete issue to jira

shszhlrh · **Joined:** Wed Aug 24, 2005 1:45 am **Posts:** 6

have solved the problem use alpha4

not use "type-mapping".

I think it will be ok with "type-mapping".

thanks very much

max · **Posted:** Mon Aug 29, 2005 1:18 am

that did not make sense to me ?

first, *not* use "type-mapping" and then you say "will be ok with type-mapping" ?

/max

shszhlrh · **Joined:** Wed Aug 24, 2005 1:45 am **Posts:** 6

there are two ways to solve this problem:

1>use alpha4 reverse from datebase ,then modify the mapping files.

change "type='java.lang.object'" to your required type.

2> use alpha5 reverse from datebase ,first modify the reveng.xml use

type-mapping.

here,I have learn a lot about hibernate. It's a good tools :)

thanks for your hard work.

max · **Posted:** Mon Aug 29, 2005 2:35 am

type-mapping also exists in alpha4...but who cares, alpha5 is the present ;)

good to hear you made it work.

cody · **Joined:** Fri Aug 26, 2005 3:49 am **Posts:** 11

@shszhlrh

Can you post your revenge file you used with alpha5