[rules-users] Persistence issue using Oracle

[ramram]

Hi Gerret,

  I did as u have stated to creating a mapping file for the tables name and
all the tables was succeffuly created except for the SessionInfo table. The
error was because the create table script contains a value of bit which is
not recognaized by oracle. How can I fix this issue? Below is what I have in
the hb.xml and the exception I encountered on the console. 

my hb.xml contains.
       <class name="org.drools.persistence.session.SessionInfo"
table="DROOL_SESSION_INFO">
		<id name="id" access="field" type="integer" column="session_id"/>
	</class>

  the following exeption appeared:
16:31:57,471 ERROR [SchemaExport] Unsuccessful: create table
DROOL_SESSION_INFO (session_id integer not null, session_dirty bit, primary
key (session_id))
16:31:57,472 ERROR [SchemaExport] ORA-00902: invalid datatype

Regards,
Ram
-- 
View this message in context: http://n3.nabble.com/Persistence-issue-using-Oracle-tp417257p442157.html
Sent from the Drools - User mailing list archive at Nabble.com.