Hi i am getting following error in JDBC driver ...

[11/09/10 11:47:05.551]:JDBC ST:Applying schema mapping policies to
input.
[11/09/10 11:47:05.551]:JDBC ST:Applying policy:
%+C%14CSchema+Mapping+Rule%-C.
[11/09/10 11:47:05.552]:JDBC ST:Resolving association references.
[11/09/10 11:47:05.552]:JDBC ST:Processing returned document.
[11/09/10 11:47:05.552]:JDBC ST:Processing operation <status> for .
[11/09/10 11:47:05.552]:JDBC ST:
DirXML Log Event -------------------
Driver: \HAVIGS-DEV\havigs\Havigs-DriverSet\JDBC
Channel: Subscriber
Object: \HAVIGS-DEV\havigs\Services\Applications\Websphere\E1
Status: Error
Message: <description>Unable to add object. Unable to insert row
into table/view 'indirect.grp'.</description>
<object-dn>O=havigs\OU=Services\OU=Applications\OU=Websphe re\CN=E1</object-dn>
<jdbc:exception jdbc:class="org.postgresql.util.PSQLException"
jdbc:error-code="0" jdbc:sql-state="42804" xmlns:jdbc="urn:dirxml:jdbc"
xmlns:jdbc-1="urn:dirxml:jdbc" xmlns:jdbc-2="urn:dirxml:jdbc"
xmlns:jdbc-3="urn:dirxml:jdbc">
<jdbc:message>ERROR: column "for_insert" is of type bit but
expression is of type boolean
Hint: You will need to rewrite or cast the expression.
Position: 46</jdbc:message>
</jdbc:exception>


Details :

I am developing provisioning workflow were my workflow will provision
an user to differnt application

Step 1 : Using User Application workflow i am taking inputs of user
details as well as applications details.

Step 2 : After taking all inputs in Entity activity i am adding user to
particular container (Ex> ou=internal,ou=users,o=xyz).

Step 3 : now in the same Entity Actvity in data mapping > target
attribute > group , i am inserting
(xyz\Services\Applications\Websphere\E1) value.
(xyz\Services\Applications\Websphere\E1) this is the
application name. So that added user will be member of this particular
gruop.

Well this is going very fine i can see user is getting created
and placed into proper group membership.

Step 4: In JDBC driver there are pre-define table structure for
indirect communication.

I just added default structure to my Postgres database and i have
chosen indirect mode for communication.

On Subscriber Channel i am receiving Add evnt and JDBC driver
able to add USER in indirect.usr table.

now along with add event i am getting below error in schema mapping
policy.

[11/09/10 11:47:05.551]:JDBC ST:Applying schema mapping policies to
input.
[11/09/10 11:47:05.551]:JDBC ST:Applying policy:
%+C%14CSchema+Mapping+Rule%-C.
[11/09/10 11:47:05.552]:JDBC ST:Resolving association
references.
[11/09/10 11:47:05.552]:JDBC ST:Processing returned document.
[11/09/10 11:47:05.552]:JDBC ST:Processing operation <status>
for .
[11/09/10 11:47:05.552]:JDBC ST:
DirXML Log Event -------------------
Driver: \HAVIGS-DEV\havigs\Havigs-DriverSet\JDBC
Channel: Subscriber
Object:
\HAVIGS-DEV\havigs\Services\Applications\Websphere\E1
Status: Error
Message: <description>Unable to add object. Unable to insert
row into table/view 'indirect.grp'.</description>

<object-dn>O=havigs\OU=Services\OU=Applications\OU=Websphe re\CN=E1</object-dn>
<jdbc:exception jdbc:class="org.postgresql.util.PSQLException"
jdbc:error-code="0" jdbc:sql-state="42804" xmlns:jdbc="urn:dirxml:jdbc"
xmlns:jdbc-1="urn:dirxml:jdbc" xmlns:jdbc-2="urn:dirxml:jdbc"
xmlns:jdbc-3="urn:dirxml:jdbc">
<jdbc:message>ERROR: column "for_insert" is of type bit but
expression is of type boolean
Hint: You will need to rewrite or cast the expression.
Position: 46</jdbc:message>
</jdbc:exception>


My understanding ::---

The error saying Object:
\HAVIGS-DEV\havigs\Services\Applications\Websphere\E1 can not be
inserted into ,
table/view 'indirect.grp' in for_insert column which is right
because this object is complete string and table wants type bit(1).
which is 0/1 value.

My Confusion ::----

Do i need to add new table lats say indirect.grp_name and add
the above object into that.
or what i should do to avoid this error ...

please help!!!!


--
agupte
------------------------------------------------------------------------
agupte's Profile: http://forums.novell.com/member.php?userid=97998
View this thread: http://forums.novell.com/showthread.php?t=425547