DB2 Support for Community edition

Message Boards

Naveen Kumar, modified 10 Years ago.

DB2 Support for Community edition

New Member Post: 1 Join Date: 8/21/13 Recent Posts

Hi All,

I am trying to integrate liferay6.0.6 with DB2 in community edition. Is this possible in community or not. I am getting errors like
DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=COMPANYIMP0_.VIRTUALHOST, DRIVER=3.62.56
DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-206;42703;COMPANYIMP0_.VIRTUALHOST, DRIVER=3.62.56

Did any one face the same problem. Please help me.

Regards,
Naveen

David H Nebinger, modified 10 Years ago.

RE: DB2 Support for Community edition

Liferay Legend Posts: 14916 Join Date: 9/2/06 Recent Posts

DB2 is supported. Make sure you're using the latest db2 jdbc driver (put jar into global lib dir, lib/ext in tomcat).

Also note that Liferay does not support catalogs or schemas. All SQL generated under Liferay does not include any catalog/schema qualifiers.

So the db credentials that you use must be able to create objects but also refer to those objects w/o catalog/schema qualifiers.

James Falkner, modified 10 Years ago.

RE: DB2 Support for Community edition

Liferay Legend Posts: 1399 Join Date: 9/17/10 Recent Posts

Locking thread.. to continue, see the (duplicate) thread over here.