Re: [Dev] [ESB] JdbcSQLException: File not found
Thank you Danushka for the information. On Fri, Mar 6, 2015 at 4:49 PM, Danushka Fernando wrote: > Although we are shipping the product with H2 database we are not > recommending to use it. We always recommend to use mysql or oracle. So you > can point to a mysql db and start the server. So you want get in to this > issue again. > > Thanks & Regards > Danushka Fernando > Software Engineer > WSO2 inc. http://wso2.com/ > Mobile : +94716332729 > > On Fri, Mar 6, 2015 at 3:55 PM, Chathura Priyankara > wrote: > >> This error happened after remote debugging a Failover Endpoint with ESB >> sample 53 [1] configuration. >> >> [1] >> https://docs.wso2.com/display/ESB481/Sample+53%3A+Using+Failover+Endpoints+to+Handle+Peak+Loads >> >> Thanks! >> >> On Fri, Mar 6, 2015 at 3:50 PM, Manoj Kumara wrote: >> >>> Could be the database got corrupted somehow not sure why. Deleting the >>> database files will not be a solution but we can do that when testing :) >>> >>> What was the operations you were doing ? >>> >>> >>> *Manoj Kumara* >>> Software Engineer >>> WSO2 Inc. http://wso2.com/ >>> *lean.enterprise.middleware* >>> Mobile: +94713448188 >>> >>> On Fri, Mar 6, 2015 at 3:36 PM, Chathura Priyankara >>> wrote: >>> Hi Manoj, Thank you for the quick response. After deleting the content of database directory, using the -Dsetup parameter I can start the server. What is the issue here ? Regards, On Fri, Mar 6, 2015 at 3:20 PM, Manoj Kumara wrote: > Can you try deleting content on wso2esb-4.8.1/repository/database and > start the server with -Dsetup parameter. > > Regards, > Manoj > > > *Manoj Kumara* > Software Engineer > WSO2 Inc. http://wso2.com/ > *lean.enterprise.middleware* > Mobile: +94713448188 > > On Fri, Mar 6, 2015 at 3:12 PM, Chathura Priyankara < > chathu...@wso2.com> wrote: > >> Hi, >> >> When restarting ESB after remote debugging I'm getting following >> exception. The ESB version is 4.8.1. How can I fix this issue ? >> >> [2015-03-06 15:02:26,371] ERROR - JDBCResourceDAO A SQLException >> error has occurred when trying to close result set or prepared statement >> org.h2.jdbc.JdbcSQLException: File not found: >> "/home/chathura/office/training/training_project/ESB/wso2esb-4.8.1/repository/database/WSO2CARBON_DB.lobs.db/23.t22.lob.db" >> [90124-140] >> at >> org.h2.message.DbException.getJdbcSQLException(DbException.java:327) >> at org.h2.message.DbException.get(DbException.java:167) >> at org.h2.message.DbException.get(DbException.java:144) >> at org.h2.engine.Database.openFile(Database.java:443) >> at org.h2.value.ValueLob.getInputStream(ValueLob.java:610) >> at org.h2.jdbc.JdbcResultSet.getBinaryStream(JdbcResultSet.java:1020) >> at >> org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.getContentStream(JDBCResourceDAO.java:553) >> at >> org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillResourceContentWithNoUpdate(JDBCResourceDAO.java:1239) >> at >> org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillResource(JDBCResourceDAO.java:271) >> at >> org.wso2.carbon.registry.core.jdbc.Repository.get(Repository.java:195) >> at >> org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.put(EmbeddedRegistry.java:689) >> at >> org.wso2.carbon.registry.core.caching.CacheBackedRegistry.put(CacheBackedRegistry.java:465) >> at >> org.wso2.carbon.registry.core.session.UserRegistry.put(UserRegistry.java:657) >> at >> org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:139) >> at >> org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:125) >> at >> org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:125) >> at >> org.wso2.carbon.theme.mgt.util.ThemeUtil.loadResourceThemes(ThemeUtil.java:175) >> at >> org.wso2.carbon.theme.mgt.internal.TenantThemeMgtServiceComponent.activate(TenantThemeMgtServiceComponent.java:53) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >> at java.lang.reflect.Method.invoke(Method.java:597) >> at >> org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:260) >> at >> org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146) >> at >> org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:347) >> at >> org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:620) >> at >> org.eclipse.equinox.internal.ds.InstanceProcess.buil
Re: [Dev] [ESB] JdbcSQLException: File not found
Although we are shipping the product with H2 database we are not recommending to use it. We always recommend to use mysql or oracle. So you can point to a mysql db and start the server. So you want get in to this issue again. Thanks & Regards Danushka Fernando Software Engineer WSO2 inc. http://wso2.com/ Mobile : +94716332729 On Fri, Mar 6, 2015 at 3:55 PM, Chathura Priyankara wrote: > This error happened after remote debugging a Failover Endpoint with ESB > sample 53 [1] configuration. > > [1] > https://docs.wso2.com/display/ESB481/Sample+53%3A+Using+Failover+Endpoints+to+Handle+Peak+Loads > > Thanks! > > On Fri, Mar 6, 2015 at 3:50 PM, Manoj Kumara wrote: > >> Could be the database got corrupted somehow not sure why. Deleting the >> database files will not be a solution but we can do that when testing :) >> >> What was the operations you were doing ? >> >> >> *Manoj Kumara* >> Software Engineer >> WSO2 Inc. http://wso2.com/ >> *lean.enterprise.middleware* >> Mobile: +94713448188 >> >> On Fri, Mar 6, 2015 at 3:36 PM, Chathura Priyankara >> wrote: >> >>> Hi Manoj, >>> >>> Thank you for the quick response. >>> After deleting the content of database directory, using the -Dsetup >>> parameter I can start the server. >>> What is the issue here ? >>> >>> Regards, >>> >>> On Fri, Mar 6, 2015 at 3:20 PM, Manoj Kumara wrote: >>> Can you try deleting content on wso2esb-4.8.1/repository/database and start the server with -Dsetup parameter. Regards, Manoj *Manoj Kumara* Software Engineer WSO2 Inc. http://wso2.com/ *lean.enterprise.middleware* Mobile: +94713448188 On Fri, Mar 6, 2015 at 3:12 PM, Chathura Priyankara >>> > wrote: > Hi, > > When restarting ESB after remote debugging I'm getting following > exception. The ESB version is 4.8.1. How can I fix this issue ? > > [2015-03-06 15:02:26,371] ERROR - JDBCResourceDAO A SQLException error > has occurred when trying to close result set or prepared statement > org.h2.jdbc.JdbcSQLException: File not found: > "/home/chathura/office/training/training_project/ESB/wso2esb-4.8.1/repository/database/WSO2CARBON_DB.lobs.db/23.t22.lob.db" > [90124-140] > at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) > at org.h2.message.DbException.get(DbException.java:167) > at org.h2.message.DbException.get(DbException.java:144) > at org.h2.engine.Database.openFile(Database.java:443) > at org.h2.value.ValueLob.getInputStream(ValueLob.java:610) > at org.h2.jdbc.JdbcResultSet.getBinaryStream(JdbcResultSet.java:1020) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.getContentStream(JDBCResourceDAO.java:553) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillResourceContentWithNoUpdate(JDBCResourceDAO.java:1239) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillResource(JDBCResourceDAO.java:271) > at > org.wso2.carbon.registry.core.jdbc.Repository.get(Repository.java:195) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.put(EmbeddedRegistry.java:689) > at > org.wso2.carbon.registry.core.caching.CacheBackedRegistry.put(CacheBackedRegistry.java:465) > at > org.wso2.carbon.registry.core.session.UserRegistry.put(UserRegistry.java:657) > at > org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:139) > at > org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:125) > at > org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:125) > at > org.wso2.carbon.theme.mgt.util.ThemeUtil.loadResourceThemes(ThemeUtil.java:175) > at > org.wso2.carbon.theme.mgt.internal.TenantThemeMgtServiceComponent.activate(TenantThemeMgtServiceComponent.java:53) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at > org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:260) > at > org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146) > at > org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:347) > at > org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:620) > at > org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:197) > at > org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:343) > at > org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:222) > at > org.eclipse.osgi.internal.s
Re: [Dev] [ESB] JdbcSQLException: File not found
This error happened after remote debugging a Failover Endpoint with ESB sample 53 [1] configuration. [1] https://docs.wso2.com/display/ESB481/Sample+53%3A+Using+Failover+Endpoints+to+Handle+Peak+Loads Thanks! On Fri, Mar 6, 2015 at 3:50 PM, Manoj Kumara wrote: > Could be the database got corrupted somehow not sure why. Deleting the > database files will not be a solution but we can do that when testing :) > > What was the operations you were doing ? > > > *Manoj Kumara* > Software Engineer > WSO2 Inc. http://wso2.com/ > *lean.enterprise.middleware* > Mobile: +94713448188 > > On Fri, Mar 6, 2015 at 3:36 PM, Chathura Priyankara > wrote: > >> Hi Manoj, >> >> Thank you for the quick response. >> After deleting the content of database directory, using the -Dsetup >> parameter I can start the server. >> What is the issue here ? >> >> Regards, >> >> On Fri, Mar 6, 2015 at 3:20 PM, Manoj Kumara wrote: >> >>> Can you try deleting content on wso2esb-4.8.1/repository/database and >>> start the server with -Dsetup parameter. >>> >>> Regards, >>> Manoj >>> >>> >>> *Manoj Kumara* >>> Software Engineer >>> WSO2 Inc. http://wso2.com/ >>> *lean.enterprise.middleware* >>> Mobile: +94713448188 >>> >>> On Fri, Mar 6, 2015 at 3:12 PM, Chathura Priyankara >>> wrote: >>> Hi, When restarting ESB after remote debugging I'm getting following exception. The ESB version is 4.8.1. How can I fix this issue ? [2015-03-06 15:02:26,371] ERROR - JDBCResourceDAO A SQLException error has occurred when trying to close result set or prepared statement org.h2.jdbc.JdbcSQLException: File not found: "/home/chathura/office/training/training_project/ESB/wso2esb-4.8.1/repository/database/WSO2CARBON_DB.lobs.db/23.t22.lob.db" [90124-140] at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) at org.h2.message.DbException.get(DbException.java:167) at org.h2.message.DbException.get(DbException.java:144) at org.h2.engine.Database.openFile(Database.java:443) at org.h2.value.ValueLob.getInputStream(ValueLob.java:610) at org.h2.jdbc.JdbcResultSet.getBinaryStream(JdbcResultSet.java:1020) at org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.getContentStream(JDBCResourceDAO.java:553) at org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillResourceContentWithNoUpdate(JDBCResourceDAO.java:1239) at org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillResource(JDBCResourceDAO.java:271) at org.wso2.carbon.registry.core.jdbc.Repository.get(Repository.java:195) at org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.put(EmbeddedRegistry.java:689) at org.wso2.carbon.registry.core.caching.CacheBackedRegistry.put(CacheBackedRegistry.java:465) at org.wso2.carbon.registry.core.session.UserRegistry.put(UserRegistry.java:657) at org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:139) at org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:125) at org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:125) at org.wso2.carbon.theme.mgt.util.ThemeUtil.loadResourceThemes(ThemeUtil.java:175) at org.wso2.carbon.theme.mgt.internal.TenantThemeMgtServiceComponent.activate(TenantThemeMgtServiceComponent.java:53) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:260) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:347) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:620) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:197) at org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:343) at org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:222) at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:107) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(BundleContextImpl.java:861) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileg
Re: [Dev] [ESB] JdbcSQLException: File not found
Could be the database got corrupted somehow not sure why. Deleting the database files will not be a solution but we can do that when testing :) What was the operations you were doing ? *Manoj Kumara* Software Engineer WSO2 Inc. http://wso2.com/ *lean.enterprise.middleware* Mobile: +94713448188 On Fri, Mar 6, 2015 at 3:36 PM, Chathura Priyankara wrote: > Hi Manoj, > > Thank you for the quick response. > After deleting the content of database directory, using the -Dsetup > parameter I can start the server. > What is the issue here ? > > Regards, > > On Fri, Mar 6, 2015 at 3:20 PM, Manoj Kumara wrote: > >> Can you try deleting content on wso2esb-4.8.1/repository/database and >> start the server with -Dsetup parameter. >> >> Regards, >> Manoj >> >> >> *Manoj Kumara* >> Software Engineer >> WSO2 Inc. http://wso2.com/ >> *lean.enterprise.middleware* >> Mobile: +94713448188 >> >> On Fri, Mar 6, 2015 at 3:12 PM, Chathura Priyankara >> wrote: >> >>> Hi, >>> >>> When restarting ESB after remote debugging I'm getting following >>> exception. The ESB version is 4.8.1. How can I fix this issue ? >>> >>> [2015-03-06 15:02:26,371] ERROR - JDBCResourceDAO A SQLException error >>> has occurred when trying to close result set or prepared statement >>> org.h2.jdbc.JdbcSQLException: File not found: >>> "/home/chathura/office/training/training_project/ESB/wso2esb-4.8.1/repository/database/WSO2CARBON_DB.lobs.db/23.t22.lob.db" >>> [90124-140] >>> at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) >>> at org.h2.message.DbException.get(DbException.java:167) >>> at org.h2.message.DbException.get(DbException.java:144) >>> at org.h2.engine.Database.openFile(Database.java:443) >>> at org.h2.value.ValueLob.getInputStream(ValueLob.java:610) >>> at org.h2.jdbc.JdbcResultSet.getBinaryStream(JdbcResultSet.java:1020) >>> at >>> org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.getContentStream(JDBCResourceDAO.java:553) >>> at >>> org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillResourceContentWithNoUpdate(JDBCResourceDAO.java:1239) >>> at >>> org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillResource(JDBCResourceDAO.java:271) >>> at org.wso2.carbon.registry.core.jdbc.Repository.get(Repository.java:195) >>> at >>> org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.put(EmbeddedRegistry.java:689) >>> at >>> org.wso2.carbon.registry.core.caching.CacheBackedRegistry.put(CacheBackedRegistry.java:465) >>> at >>> org.wso2.carbon.registry.core.session.UserRegistry.put(UserRegistry.java:657) >>> at >>> org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:139) >>> at >>> org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:125) >>> at >>> org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:125) >>> at >>> org.wso2.carbon.theme.mgt.util.ThemeUtil.loadResourceThemes(ThemeUtil.java:175) >>> at >>> org.wso2.carbon.theme.mgt.internal.TenantThemeMgtServiceComponent.activate(TenantThemeMgtServiceComponent.java:53) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >>> at java.lang.reflect.Method.invoke(Method.java:597) >>> at >>> org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:260) >>> at >>> org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146) >>> at >>> org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:347) >>> at >>> org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:620) >>> at >>> org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:197) >>> at >>> org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:343) >>> at >>> org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:222) >>> at >>> org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:107) >>> at >>> org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(BundleContextImpl.java:861) >>> at >>> org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) >>> at >>> org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148) >>> at >>> org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:819) >>> at >>> org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:771) >>> at >>> org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:130) >>> at >>> org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:214) >>> at >>> org.ec
Re: [Dev] [ESB] JdbcSQLException: File not found
Hi Manoj, Thank you for the quick response. After deleting the content of database directory, using the -Dsetup parameter I can start the server. What is the issue here ? Regards, On Fri, Mar 6, 2015 at 3:20 PM, Manoj Kumara wrote: > Can you try deleting content on wso2esb-4.8.1/repository/database and > start the server with -Dsetup parameter. > > Regards, > Manoj > > > *Manoj Kumara* > Software Engineer > WSO2 Inc. http://wso2.com/ > *lean.enterprise.middleware* > Mobile: +94713448188 > > On Fri, Mar 6, 2015 at 3:12 PM, Chathura Priyankara > wrote: > >> Hi, >> >> When restarting ESB after remote debugging I'm getting following >> exception. The ESB version is 4.8.1. How can I fix this issue ? >> >> [2015-03-06 15:02:26,371] ERROR - JDBCResourceDAO A SQLException error >> has occurred when trying to close result set or prepared statement >> org.h2.jdbc.JdbcSQLException: File not found: >> "/home/chathura/office/training/training_project/ESB/wso2esb-4.8.1/repository/database/WSO2CARBON_DB.lobs.db/23.t22.lob.db" >> [90124-140] >> at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) >> at org.h2.message.DbException.get(DbException.java:167) >> at org.h2.message.DbException.get(DbException.java:144) >> at org.h2.engine.Database.openFile(Database.java:443) >> at org.h2.value.ValueLob.getInputStream(ValueLob.java:610) >> at org.h2.jdbc.JdbcResultSet.getBinaryStream(JdbcResultSet.java:1020) >> at >> org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.getContentStream(JDBCResourceDAO.java:553) >> at >> org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillResourceContentWithNoUpdate(JDBCResourceDAO.java:1239) >> at >> org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillResource(JDBCResourceDAO.java:271) >> at org.wso2.carbon.registry.core.jdbc.Repository.get(Repository.java:195) >> at >> org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.put(EmbeddedRegistry.java:689) >> at >> org.wso2.carbon.registry.core.caching.CacheBackedRegistry.put(CacheBackedRegistry.java:465) >> at >> org.wso2.carbon.registry.core.session.UserRegistry.put(UserRegistry.java:657) >> at >> org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:139) >> at >> org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:125) >> at >> org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:125) >> at >> org.wso2.carbon.theme.mgt.util.ThemeUtil.loadResourceThemes(ThemeUtil.java:175) >> at >> org.wso2.carbon.theme.mgt.internal.TenantThemeMgtServiceComponent.activate(TenantThemeMgtServiceComponent.java:53) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >> at java.lang.reflect.Method.invoke(Method.java:597) >> at >> org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:260) >> at >> org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146) >> at >> org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:347) >> at >> org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:620) >> at >> org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:197) >> at org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:343) >> at >> org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:222) >> at >> org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:107) >> at >> org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(BundleContextImpl.java:861) >> at >> org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) >> at >> org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148) >> at >> org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:819) >> at >> org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:771) >> at >> org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:130) >> at >> org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:214) >> at >> org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(BundleContextImpl.java:433) >> at >> org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(BundleContextImpl.java:451) >> at >> org.wso2.carbon.core.init.CarbonServerManager.initializeCarbon(CarbonServerManager.java:517) >> at >> org.wso2.carbon.core.init.CarbonServerManager.start(CarbonServerManager.java:219) >> at >> org.wso2.carbon.core.internal.CarbonCoreServiceComponent.activa
Re: [Dev] [ESB] JdbcSQLException: File not found
Can you try deleting content on wso2esb-4.8.1/repository/database and start the server with -Dsetup parameter. Regards, Manoj *Manoj Kumara* Software Engineer WSO2 Inc. http://wso2.com/ *lean.enterprise.middleware* Mobile: +94713448188 On Fri, Mar 6, 2015 at 3:12 PM, Chathura Priyankara wrote: > Hi, > > When restarting ESB after remote debugging I'm getting following > exception. The ESB version is 4.8.1. How can I fix this issue ? > > [2015-03-06 15:02:26,371] ERROR - JDBCResourceDAO A SQLException error has > occurred when trying to close result set or prepared statement > org.h2.jdbc.JdbcSQLException: File not found: > "/home/chathura/office/training/training_project/ESB/wso2esb-4.8.1/repository/database/WSO2CARBON_DB.lobs.db/23.t22.lob.db" > [90124-140] > at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) > at org.h2.message.DbException.get(DbException.java:167) > at org.h2.message.DbException.get(DbException.java:144) > at org.h2.engine.Database.openFile(Database.java:443) > at org.h2.value.ValueLob.getInputStream(ValueLob.java:610) > at org.h2.jdbc.JdbcResultSet.getBinaryStream(JdbcResultSet.java:1020) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.getContentStream(JDBCResourceDAO.java:553) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillResourceContentWithNoUpdate(JDBCResourceDAO.java:1239) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillResource(JDBCResourceDAO.java:271) > at org.wso2.carbon.registry.core.jdbc.Repository.get(Repository.java:195) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.put(EmbeddedRegistry.java:689) > at > org.wso2.carbon.registry.core.caching.CacheBackedRegistry.put(CacheBackedRegistry.java:465) > at > org.wso2.carbon.registry.core.session.UserRegistry.put(UserRegistry.java:657) > at > org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:139) > at > org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:125) > at > org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:125) > at > org.wso2.carbon.theme.mgt.util.ThemeUtil.loadResourceThemes(ThemeUtil.java:175) > at > org.wso2.carbon.theme.mgt.internal.TenantThemeMgtServiceComponent.activate(TenantThemeMgtServiceComponent.java:53) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at > org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:260) > at > org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146) > at > org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:347) > at > org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:620) > at > org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:197) > at org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:343) > at > org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:222) > at > org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:107) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(BundleContextImpl.java:861) > at > org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) > at > org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148) > at > org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:819) > at > org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:771) > at > org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:130) > at > org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:214) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(BundleContextImpl.java:433) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(BundleContextImpl.java:451) > at > org.wso2.carbon.core.init.CarbonServerManager.initializeCarbon(CarbonServerManager.java:517) > at > org.wso2.carbon.core.init.CarbonServerManager.start(CarbonServerManager.java:219) > at > org.wso2.carbon.core.internal.CarbonCoreServiceComponent.activate(CarbonCoreServiceComponent.java:77) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at > org.e
[Dev] [ESB] JdbcSQLException: File not found
Hi, When restarting ESB after remote debugging I'm getting following exception. The ESB version is 4.8.1. How can I fix this issue ? [2015-03-06 15:02:26,371] ERROR - JDBCResourceDAO A SQLException error has occurred when trying to close result set or prepared statement org.h2.jdbc.JdbcSQLException: File not found: "/home/chathura/office/training/training_project/ESB/wso2esb-4.8.1/repository/database/WSO2CARBON_DB.lobs.db/23.t22.lob.db" [90124-140] at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) at org.h2.message.DbException.get(DbException.java:167) at org.h2.message.DbException.get(DbException.java:144) at org.h2.engine.Database.openFile(Database.java:443) at org.h2.value.ValueLob.getInputStream(ValueLob.java:610) at org.h2.jdbc.JdbcResultSet.getBinaryStream(JdbcResultSet.java:1020) at org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.getContentStream(JDBCResourceDAO.java:553) at org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillResourceContentWithNoUpdate(JDBCResourceDAO.java:1239) at org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillResource(JDBCResourceDAO.java:271) at org.wso2.carbon.registry.core.jdbc.Repository.get(Repository.java:195) at org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.put(EmbeddedRegistry.java:689) at org.wso2.carbon.registry.core.caching.CacheBackedRegistry.put(CacheBackedRegistry.java:465) at org.wso2.carbon.registry.core.session.UserRegistry.put(UserRegistry.java:657) at org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:139) at org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:125) at org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:125) at org.wso2.carbon.theme.mgt.util.ThemeUtil.loadResourceThemes(ThemeUtil.java:175) at org.wso2.carbon.theme.mgt.internal.TenantThemeMgtServiceComponent.activate(TenantThemeMgtServiceComponent.java:53) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:260) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:347) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:620) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:197) at org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:343) at org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:222) at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:107) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(BundleContextImpl.java:861) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:819) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:771) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:130) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:214) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(BundleContextImpl.java:433) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(BundleContextImpl.java:451) at org.wso2.carbon.core.init.CarbonServerManager.initializeCarbon(CarbonServerManager.java:517) at org.wso2.carbon.core.init.CarbonServerManager.start(CarbonServerManager.java:219) at org.wso2.carbon.core.internal.CarbonCoreServiceComponent.activate(CarbonCoreServiceComponent.java:77) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:260) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:347) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:620) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:197) at org.ecli
