Informix wmDB -- Can not insert a NULL into column

, ,
1

Hi , EveryOne,

I am using 9.10 webMethods version. and config the URL in wmDB page with
The URL :jdbc:informix-sqli:ServerIP:9279/DBName:informixserver=ServerName;CLIENT_LOCALE=zh_tw.big5;DB_LOCALE=zh_TW.57352.
I have debugged the flow service,Data type has string (java.lang.string) and object(java.math.bigdecimal),and all data has value.
But when I tried to insert these data to a table using pub.db.insert , It failed , and indicate that I Can not insert a NULL into column. There seems to be a problem with data type object ,because data type string can be inserted successfully.

In addition, I was using 8.0 webMethods version,and config the URL in wmDB page .
The URL is: jdbc - dbc:datasource,then I have debugged the same flow service, It will be OK,all data can be inserted successfully.But if I config the URL in wmDB with the URL :jdbc:informix-sqli:ServerIP:9279/DBName:informixserver=ServerName;CLIENT_LOCALE=zh_tw.big5;DB_LOCALE=zh_TW.57352 and have debugged the same flow service, It failed,too. and indicate that NO DB URL Specified.

Who knows how to solve it?Anybody can help me?

2

Hi Jenny,

which version of Informix are you using?
Which version of the Informix driver?

Informix driver supports DataSources you can try to use WmJDBCAdapter instead.

Regards,
Holger

3

Hi Holger

Thanks for your reply.

Informix DB belongs to other departments, so I don’t know it’s version.

I don’t know what do you mean which version of the Informix driver.
When I use jdbc-odbc bridge,the ODBC driver is INFORMIX 3.32 (32BITS),
and the WmDB’s DB driver is sun.jdbc.odbc.JdbcOdbcDriver.
When I don’t use jdbc-odbc bridge, the WmDB’s DB driver is com.informix.jdbc.IfxDriver.

Our flow services is using WmDB, It will be a big project if I want to change WmDB to JDBCAdapter , so I have to solve the problem.

Do you have any other ideas?

Regards,
Jenny

4

Hi Jenny,

I am not familiar with Informix Databases and the WmDB package.

In my previous post one word got lost.
The last line should be:
If Infomix driver supports DataSources you can try to use WmJDBCAdapter instead.

We are using Oracle and JDBC Adapter.

Regards,
Holger