Table 'XXX' doesn't exist

[Fabio A Miranda, modificado 13 Anos atrás.]

Hello,

I want to configure service builder for netbeans on Liferay 6.x in such a way that each time the portlet is deployed if creates the table each time if deploy, if the table do not exist.

what file can I edit and configure for this behavior ?

Looks like the first time I deploy it, it creates the table used by hibernate, but if I shutdown the appserver and drop the tables, the next deployment of the same portlet will throw a:

[#|2010-10-22T00:30:56.551+0000|INFO|oracle-glassfish3.0.1|javax.enterprise.system.std.com.sun.enterprise.v3.services.impl|_ThreadID=28;_ThreadName=Thread-1;|00:30:56,548 ERROR [JDBCExceptionReporter:101] Table 'lportal.WGCountry' doesn't exist
|#]


How can I set up this portlet to always create tables if they do not exist ?

regards,

fabio.

[Sandeep Nair, modificado 13 Anos atrás.]

Yeah its weird thing happening with Liferay 6. I have encountered it many times and found that if i drop tables its happening. Try not to drop table just clear all the data in the table. Stop the server. Remove the war from Server(in case of tomcat from webapps). Delete temp and work. Start the server. Once the server is started deploy again.

Regards,
Sandeep

[Deb Troxel, modificado 13 Anos atrás.]

Have a look at the servicecomponent table. I don't know if this is the "right" way, but dropping my tables and also deleting the record that refers to my buildnamespace from the servicecomponent table works for me. On the next deploy the tables get recreated.

[Soori Babu Meesala, modificado 8 Anos atrás.]

Modify the "build.number=" value in service.properties file. The new value should be greater than the highest " buildNumber" in servicecomponet table. Build the services and deploy the portlet again.

~ Regards,
Soori Babu Meesala

[Vishal Kumar, modificado 8 Anos atrás.]

Thanks.