Hi,
On 8/12/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Hi John/Everyone,
>
> I am trying to use OpenWfe java version with oracle DB. I am using
> openwfe-1.7.3pre0 version. I setup the table and tried to run
> TestDBEngine sample and I am getting the below error.
> Pl help.
>
> To setup in oracle I used vatchar2(4000) for xldoc (this is declared
> as text data type in mysql/postgres which is not supported in oracle)
>
> 8< - - -
>
> Caused by: java.sql.SQLException: ORA-01400: cannot insert NULL into
> ("MYDB"."XLDOCUMENT"."WFINSTANCEID")
>
> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:
> 134)
I haven't touched Oracle SQL for a long time. Maybe you could simply
state that NULL values are OK for the column WFINSTANCEID in the
XLDOCUMENT table.
I hope this will fix this issue.
Best regards,
--
John Mettraux -///- http://jmettraux.openwfe.org
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"OpenWFE users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/openwfe-users?hl=en
-~----------~----~----~----~------~----~------~--~---
