Re: [rules-users] Persistence issue using Oracle

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.