3 Replies Latest reply on Jul 27, 2014 12:22 PM by Deepak-Jain

    java.sql.exception:SQLite.Exception:no such table

    Sheng

      Hi All,

      I create an Android application using SQLite. However, when I open the app on device or emulator, it show SQLiteException:no such table.(There is select query in my code.)What's wrong with it? Can anyone help me? Thank you in advance. Following is the log.

       

      07-24 02:43:48.917: D/dalvikvm(2240): Not late-enabling CheckJNI (already on)

      07-24 02:43:48.977: I/dalvikvm(2240): CheckJNI enabled: not enabling JNI app bug workarounds.

      07-24 02:43:49.027: W/System.err(2240): No properties file. Taking properties from ClassLoader resources

      07-24 02:43:49.027: W/System.err(2240): Opening "logging.properties" also failed

      07-24 02:43:49.027: W/System.err(2240): java.io.IOException: BufferedInputStream is closed

      07-24 02:43:49.077: D/dalvikvm(2240): GC_FOR_ALLOC freed 221K, 11% free 2818K/3132K, paused 2ms, total 3ms

      07-24 02:43:49.077: I/dalvikvm-heap(2240): Grow heap (frag case) to 6.745MB for 4096012-byte allocation

      07-24 02:43:49.087: D/dalvikvm(2240): GC_FOR_ALLOC freed <1K, 5% free 6817K/7136K, paused 11ms, total 11ms

      07-24 02:43:49.107: D/dalvikvm(2240): GC_CONCURRENT freed <1K, 5% free 6817K/7136K, paused 0ms+0ms, total 2ms

      07-24 02:43:49.247: V/WebViewChromium(2240): Binding Chromium to the main looper Looper (main, tid 1) {b2fcf240}

      07-24 02:43:49.247: I/chromium(2240): [INFO:library_loader_hooks.cc(112)] Chromium logging enabled: level = 0, default verbosity = 0

      07-24 02:43:49.247: I/BrowserProcessMain(2240): Initializing chromium process, renderers=0

      07-24 02:43:49.337: E/chromium(2240): [ERROR:gl_surface_egl.cc(153)] No suitable EGL configs found.

      07-24 02:43:49.337: E/chromium(2240): [ERROR:gl_surface_egl.cc(620)] GLSurfaceEGL::InitializeOneOff failed.

      07-24 02:43:49.337: E/chromium(2240): [ERROR:gl_surface_egl.cc(153)] No suitable EGL configs found.

      07-24 02:43:49.337: E/chromium(2240): [ERROR:gl_surface_egl.cc(620)] GLSurfaceEGL::InitializeOneOff failed.

      07-24 02:43:49.337: E/chromium(2240): [ERROR:gpu_info_collector.cc(86)] gfx::GLSurface::InitializeOneOff() failed

      07-24 02:43:49.337: W/chromium(2240): [WARNING:proxy_service.cc(888)] PAC support disabled because there is no system implementation

      07-24 02:43:49.667: D/gralloc_goldfish(2240): Emulator without GPU emulation detected.

      07-24 02:43:49.687: W/IInputConnectionWrapper(2240): showStatusIcon on inactive InputConnection

      07-24 02:43:49.727: D/dalvikvm(2240): GC_CONCURRENT freed 194K, 4% free 7863K/8152K, paused 5ms+1ms, total 7ms

      07-24 02:43:50.637: D/dalvikvm(2240): GC_CONCURRENT freed 1486K, 17% free 7967K/9548K, paused 6ms+0ms, total 9ms

      07-24 02:43:50.807: D/dalvikvm(2240): GC_CONCURRENT freed 1611K, 18% free 7979K/9684K, paused 8ms+1ms, total 12ms

      07-24 02:43:50.987: D/dalvikvm(2240): GC_CONCURRENT freed 1629K, 18% free 7976K/9712K, paused 12ms+0ms, total 16ms

      07-24 02:43:51.077: D/dalvikvm(2240): GC_CONCURRENT freed 1625K, 18% free 7976K/9712K, paused 9ms+0ms, total 12ms

      07-24 02:43:51.297: D/dalvikvm(2240): GC_CONCURRENT freed 1625K, 18% free 7977K/9712K, paused 9ms+0ms, total 13ms

      07-24 02:43:51.617: D/dalvikvm(2240): Trying to load lib /data/app-lib/com.company.OFHSqlite-1/libcvm.so 0xb2fd7220

      07-24 02:43:51.617: W/linker(2240): libcvm.so has text relocations. This is wasting memory and is a security risk. Please fix.

      07-24 02:43:51.617: D/dalvikvm(2240): Added shared lib /data/app-lib/com.company.OFHSqlite-1/libcvm.so 0xb2fd7220

      07-24 02:43:51.617: D/dalvikvm(2240): No JNI_OnLoad found in /data/app-lib/com.company.OFHSqlite-1/libcvm.so 0xb2fd7220, skipping init

      07-24 02:43:51.617: D/dalvikvm(2240): Trying to load lib /data/app-lib/com.company.OFHSqlite-1/libvmchannel.so 0xb2fd7220

      07-24 02:43:51.617: D/dalvikvm(2240): Added shared lib /data/app-lib/com.company.OFHSqlite-1/libvmchannel.so 0xb2fd7220

      07-24 02:43:51.617: D/dalvikvm(2240): No JNI_OnLoad found in /data/app-lib/com.company.OFHSqlite-1/libvmchannel.so 0xb2fd7220, skipping init

      07-24 02:43:51.617: D/dalvikvm(2240): Trying to load lib /data/app-lib/com.company.OFHSqlite-1/libvmchannel_dalvik.so 0xb2fd7220

      07-24 02:43:51.617: D/dalvikvm(2240): Added shared lib /data/app-lib/com.company.OFHSqlite-1/libvmchannel_dalvik.so 0xb2fd7220

      07-24 02:43:51.617: D/dalvikvm(2240): No JNI_OnLoad found in /data/app-lib/com.company.OFHSqlite-1/libvmchannel_dalvik.so 0xb2fd7220, skipping init

      07-24 02:43:51.967: I/CordovaLog(2240): Changing log level to DEBUG(3)

      07-24 02:43:51.967: I/CordovaLog(2240): Found preference for useBrowserHistory=true

      07-24 02:43:51.967: D/CordovaLog(2240): Found preference for useBrowserHistory=true

      07-24 02:43:51.967: I/CordovaLog(2240): Found preference for exit-on-suspend=false

      07-24 02:43:51.967: D/CordovaLog(2240): Found preference for exit-on-suspend=false

      07-24 02:43:51.977: D/JsMessageQueue(2240): Set native->JS mode to 2

      07-24 02:43:51.977: D/DroidGap(2240): DroidGap.init()

      07-24 02:43:51.997: D/dalvikvm(2240): GC_CONCURRENT freed 1427K, 17% free 8184K/9804K, paused 15ms+0ms, total 18ms

      07-24 02:43:51.997: D/CordovaWebView(2240): >>> loadUrl(file:///data/data/com.company.OFHSqlite/storage/assets/FARs/OracleStandardADFmfUiComponents/public_html/adf.backchannel.html)

      07-24 02:43:51.997: D/PluginManager(2240): init()

      07-24 02:43:52.007: D/CordovaWebView(2240): >>> loadUrlNow()

      07-24 02:43:52.017: D/DroidGap(2240): Resuming the App

      07-24 02:43:52.097: D/DroidGap(2240): onMessage(onPageStarted,file:///data/data/com.company.OFHSqlite/storage/assets/FARs/OracleStandardADFmfUiComponents/public_html/adf.backchannel.html)

      07-24 02:43:52.537: D/CVM(2240): [SEVERE - oracle.adfmf.application - LifeCycleListenerImpl - start] At the start() method

      07-24 02:43:52.537: D/CVM(2240): [SEVERE - oracle.adfmf.application - LifeCycleListenerImpl - initializeDatabaseFromScript] Initilizing DB ...

      07-24 02:43:52.537: D/CVM(2240): [SEVERE - oracle.adfmf.application - LifeCycleListenerImpl - initializeDatabaseFromScript] DB_NAME:/data/data/com.company.OFHSqlite/files/st.db

      07-24 02:43:52.537: D/CVM(2240): [SEVERE - oracle.adfmf.application - LifeCycleListenerImpl - initializeDatabaseFromScript] DBFile doesn't Exist.

      07-24 02:43:52.817: D/CVM(2240): [SEVERE - oracle.adfmf.application - LifeCycleListenerImpl - initializeDatabaseFromScript] Reading script

      07-24 02:43:52.817: D/CVM(2240): [SEVERE - oracle.adfmf.application - LifeCycleListenerImpl - start] End start() method.

      07-24 02:43:52.897: D/Cordova(2240): onPageFinished(file:///data/data/com.company.OFHSqlite/storage/assets/FARs/OracleStandardADFmfUiComponents/public_html/adf.backchannel.html)

      07-24 02:43:52.897: D/DroidGap(2240): onMessage(onNativeReady,null)

      07-24 02:43:52.897: D/DroidGap(2240): onMessage(onPageFinished,file:///data/data/com.company.OFHSqlite/storage/assets/FARs/OracleStandardADFmfUiComponents/public_html/adf.backchannel.html)

      07-24 02:43:52.947: I/System.out(2240): Error initializing Network Connection: Class not found

      07-24 02:43:52.977: D/DroidGap(2240): onMessage(spinner,stop)

      07-24 02:43:52.997: I/System.out(2240): Back Channel Hidden Feature: Received Event: deviceready

      07-24 02:43:53.037: I/System.out(2240): Back Channel Hidden Feature - Startup is complete.

      07-24 02:43:53.057: D/DroidGap(2240): Paused the application!

      07-24 02:43:53.057: D/CordovaWebView(2240): Handle the pause

      07-24 02:43:53.057: D/DroidGap(2240): DroidGap.onCreate()

      07-24 02:43:53.067: D/CordovaWebView(2240): Origin to allow: http://127.0.0.1*

      07-24 02:43:53.067: D/CordovaWebView(2240): Origin to allow with subdomains: googleapis.com

      07-24 02:43:53.067: D/CordovaWebView(2240): Origin to allow with subdomains: gstatic.com

      07-24 02:43:53.067: D/CordovaWebView(2240): Origin to allow: elocation.oracle.com

      07-24 02:43:53.067: I/CordovaLog(2240): Found log level DEBUG

      07-24 02:43:53.067: I/CordovaLog(2240): Changing log level to DEBUG(3)

      07-24 02:43:53.067: I/CordovaLog(2240): Found preference for useBrowserHistory=true

      07-24 02:43:53.067: D/CordovaLog(2240): Found preference for useBrowserHistory=true

      07-24 02:43:53.067: I/CordovaLog(2240): Found preference for exit-on-suspend=false

      07-24 02:43:53.067: D/CordovaLog(2240): Found preference for exit-on-suspend=false

      07-24 02:43:53.087: D/JsMessageQueue(2240): Set native->JS mode to 2

      07-24 02:43:53.087: D/DroidGap(2240): DroidGap.init()

      07-24 02:43:53.087: D/CordovaWebView(2240): >>> loadUrl(file:///data/data/com.company.OFHSqlite/storage/assets/www/bootstrap.html?file=com.oraclefusionhub.sqlite.UIPage%2FUIPage.amx&featureRoot=..%2FFARs%2FViewController&profile_json_folder_override=/data/data/com.company.OFHSqlite/files//baseProfiles&appStartTime=1406184229075&webviewStartTime=WEBVIEW_TEMPLATE_TIME_LOCATION&lang=en-us)

      07-24 02:43:53.087: D/PluginManager(2240): init()

      07-24 02:43:53.097: D/CordovaWebView(2240): >>> loadUrlNow()

      07-24 02:43:53.097: D/DroidGap(2240): Resuming the App

      07-24 02:43:53.097: D/SoftKeyboardDetect(2240): Ignore this event

      07-24 02:43:53.127: D/dalvikvm(2240): GC_FOR_ALLOC freed 439K, 17% free 8428K/10092K, paused 26ms, total 26ms

      07-24 02:43:53.127: I/dalvikvm-heap(2240): Grow heap (frag case) to 9.636MB for 1382412-byte allocation

      07-24 02:43:53.127: D/dalvikvm(2240): GC_FOR_ALLOC freed 0K, 15% free 9778K/11444K, paused 2ms, total 2ms

      07-24 02:43:53.127: W/AwContents(2240): nativeOnDraw failed; clearing to background color.

      07-24 02:43:53.207: D/dalvikvm(2240): GC_FOR_ALLOC freed 1371K, 27% free 8416K/11444K, paused 4ms, total 4ms

      07-24 02:43:53.207: W/AwContents(2240): nativeOnDraw failed; clearing to background color.

      07-24 02:43:53.337: D/DroidGap(2240): onMessage(onPageStarted,file:///data/data/com.company.OFHSqlite/storage/assets/www/bootstrap.html?file=com.oraclefusionhub.sqlite.UIPage%2FUIPage.amx&featureRoot=..%2FFARs%2FViewController&profile_json_folder_override=/data/data/com.company.OFHSqlite/files//baseProfiles&appStartTime=1406184229075&webviewStartTime=WEBVIEW_TEMPLATE_TIME_LOCATION&lang=en-us)

      07-24 02:43:54.317: W/AwContents(2240): nativeOnDraw failed; clearing to background color.

      07-24 02:43:54.327: W/AwContents(2240): nativeOnDraw failed; clearing to background color.

      07-24 02:43:54.357: W/AwContents(2240): nativeOnDraw failed; clearing to background color.

      07-24 02:43:54.367: W/AwContents(2240): nativeOnDraw failed; clearing to background color.

      07-24 02:43:54.397: W/AwContents(2240): nativeOnDraw failed; clearing to background color.

      07-24 02:43:54.437: W/AwContents(2240): nativeOnDraw failed; clearing to background color.

      07-24 02:43:54.477: W/AwContents(2240): nativeOnDraw failed; clearing to background color.

      07-24 02:43:54.497: W/AwContents(2240): nativeOnDraw failed; clearing to background color.

      07-24 02:43:54.537: W/AwContents(2240): nativeOnDraw failed; clearing to background color.

      07-24 02:43:54.557: W/AwContents(2240): nativeOnDraw failed; clearing to background color.

      07-24 02:43:54.707: D/Cordova(2240): onPageFinished(file:///data/data/com.company.OFHSqlite/storage/assets/www/bootstrap.html?file=com.oraclefusionhub.sqlite.UIPage%2FUIPage.amx&featureRoot=..%2FFARs%2FViewController&profile_json_folder_override=/data/data/com.company.OFHSqlite/files//baseProfiles&appStartTime=1406184229075&webviewStartTime=WEBVIEW_TEMPLATE_TIME_LOCATION&lang=en-us)

      07-24 02:43:54.707: D/DroidGap(2240): onMessage(onNativeReady,null)

      07-24 02:43:54.707: D/DroidGap(2240): onMessage(onPageFinished,file:///data/data/com.company.OFHSqlite/storage/assets/www/bootstrap.html?file=com.oraclefusionhub.sqlite.UIPage%2FUIPage.amx&featureRoot=..%2FFARs%2FViewController&profile_json_folder_override=/data/data/com.company.OFHSqlite/files//baseProfiles&appStartTime=1406184229075&webviewStartTime=WEBVIEW_TEMPLATE_TIME_LOCATION&lang=en-us)

      07-24 02:43:54.987: I/System.out(2240): Error initializing Network Connection: Class not found

      07-24 02:43:55.107: D/DroidGap(2240): onMessage(spinner,stop)

      07-24 02:43:56.917: D/CVM(2240): [SEVERE - oracle.adfmf.application - EmployeeDC - getEmployeesFromDB] OFA:Entered getEmployeesFromDB

      07-24 02:43:56.917: D/CVM(2240): [SEVERE - oracle.adfmf.application - ConnectionFactory - getConnection] At the ConnectionFactory Package getConnection Method.

      07-24 02:43:56.947: D/CVM(2240): [SEVERE - oracle.adfmf.application - EmployeeDC - getEmployeesFromDB] test1

      07-24 02:43:56.947: D/CVM(2240): [SEVERE - oracle.adfmf.application - EmployeeDC - getEmployeesFromDB] SQLite.Exception: no such table: employees

      07-24 02:43:56.947: D/CVM(2240): java.sql.SQLException: SQLite.Exception: no such table: employees

      07-24 02:43:56.947: D/CVM(2240):     at SQLite.JDBC0.JDBCStatement.executeQuery(Unknown Source)

      07-24 02:43:56.947: D/CVM(2240):     at SQLite.JDBC0.JDBCStatement.executeQuery(Unknown Source)

      07-24 02:43:56.947: D/CVM(2240):     at com.oraclefusionhub.sqlite.application.EmployeeDC.getEmployeesFromDB(EmployeeDC.java:32)

      07-24 02:43:56.947: D/CVM(2240):     at com.oraclefusionhub.sqlite.application.EmployeeDC.getEmployees(EmployeeDC.java:20)

      07-24 02:43:56.947: D/CVM(2240):     at oracle.adfmf.dc.bean.ConcreteJavaBeanObject.getAccessorValue(Unknown Source)

      07-24 02:43:56.947: D/CVM(2240):     at oracle.adfmf.dc.bean.ConcreteJavaBeanObject.getAttribute(Unknown Source)

      07-24 02:43:56.947: D/CVM(2240):     at oracle.adfmf.util.GenericTypeIteratorAdapter.getWrappedDataProvider(Unknown Source)

      07-24 02:43:56.947: D/CVM(2240):     at oracle.adfmf.util.GenericTypeIteratorAdapter.getDataProvider(Unknown Source)

      07-24 02:43:56.947: D/CVM(2240):     at oracle.adfmf.dc.GenericJavaBeanDataControlAdapter.getAccessorDataProvider(Unknown Source)

      07-24 02:43:56.947: D/CVM(2240):     at oracle.adfmf.dc.GenericJavaBeanDataControlAdapter.getDataProvider(Unknown Source)

      07-24 02:43:56.947: D/CVM(2240):     at oracle.adfmf.bindings.dbf.AmxIteratorBinding.loadBasicIterator(Unknown Source)

      07-24 02:43:56.947: D/CVM(2240):     at oracle.adfmf.bindings.dbf.AmxIteratorBinding.getIterator(Unknown Source)

      07-24 02:43:56.947: D/CVM(2240):     at oracle.adfmf.bindings.dbf.AmxIteratorBinding.getIterator(Unknown Source)

      07-24 02:43:56.947: D/CVM(2240):     at oracle.adfmf.bindings.dbf.AmxTreeBinding.getIterator(Unknown Source)

      07-24 02:43:56.947: D/CVM(2240):     at oracle.adfmf.bindings.dbf.AmxTreeBinding.getCollectionModel(Unknown Source)

      07-24 02:43:56.947: D/CVM(2240):     at oracle.adfmf.bindings.dbf.AmxTreeBinding.getCollectionModel(Unknown Source)

      07-24 02:43:56.947: D/CVM(2240):     at javax.el.BeanELResolver.getValue(Unknown Source)

      07-24 02:43:56.947: D/CVM(2240):     at javax.el.CompositeELResolver.getValue(Unknown Source)

      07-24 02:43:56.947: D/CVM(2240):     at oracle.adfmf.framework.model.DiagnosticCompositeELResolver.getValue(Unknown Source)

      07-24 02:43:56.947: D/CVM(2240):     at javax.el.CompositeELResolver.getValue(Unknown Source)

      07-24 02:43:56.947: D/CVM(2240):     at de.odysseus.el.util.SimpleResolver.getValue(Unknown Source)

      07-24 02:43:56.947: D/CVM(2240):     at de.odysseus.el.tree.impl.ast.AstProperty.eval(Unknown Source)

      07-24 02:43:56.947: D/CVM(2240):     at de.odysseus.el.tree.impl.ast.AstProperty.eval(Unknown Source)

      07-24 02:43:56.947: D/CVM(2240):     at de.odysseus.el.tree.impl.ast.AstEval.eval(Unknown Source)

      07-24 02:43:56.947: D/CVM(2240):     at de.odysseus.el.tree.impl.ast.AstNode.getValue(Unknown Source)

      07-24 02:43:56.947: D/CVM(2240):     at de.odysseus.el.TreeValueExpression.getValue(Unknown Source)

      07-24 02:43:57.037: D/CVM(2240):     at oracle.adfmf.framework.api.Model.getValue(Unknown Source)

      07-24 02:43:57.037: D/CVM(2240):     at oracle.adfmf.framework.contract.adf.application.GenericInvokeRequestHandler.invoke(Unknown Source)

      07-24 02:43:57.037: D/CVM(2240):     at oracle.adfmf.framework.contract.adf.application.GenericInvokeRequestHandler.invoke(Unknown Source)

      07-24 02:43:57.037: D/CVM(2240):     at oracle.adfmf.framework.contract.adf.application.GenericInvokeRequestHandler.process(Unknown Source)

      07-24 02:43:57.037: D/CVM(2240):     at oracle.adfmf.framework.FeatureContext.handle(Unknown Source)

      07-24 02:43:57.037: D/CVM(2240):     at oracle.adfmf.framework.AdfChannel.handle(Unknown Source)

      07-24 02:43:57.037: D/CVM(2240):     at com.oracle.cvm.channel.impl.VMChannelImpl.run(VMChannelImpl.java:451)

      07-24 02:43:57.037: D/CVM(2240):     at java.lang.Thread.run(Unknown Source)

      07-24 02:43:57.037: D/CVM(2240):     at java.lang.Thread.startup(Unknown Source)

      07-24 02:43:57.457: I/System.out(2240): [SEVERE - oracle.adfmf.framework - adf.mf.internal - logError] Request: "#{bindings.employees.collectionModel.selectedRow}" exception: {"message":"java.sql.SQLException: SQLite.Exception: no such table: employees","errorCode":-1,".type":"oracle.adfmf.framework.exception.AdfInvocationRuntimeException",".exception":true,"severity":"ERROR","errorCategory":"BEAN"}

       

       

      Thank you,

      Sheng