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.
_______________________________________________
rules-users mailing list
rules-users@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users

Reply via email to