[안드로이드 오라클DB 연동] 에뮬레이터만 연동되고 디바이스는 연동되지 않는 문제

Question

1. 일단, 가상 에뮬레이터에서는 정상적으로 로그인과 게시물 작성이 됩니다. (Run 메시지) 2. 하지만 스마트폰에 연결한 경우 (디바이스 연결) 로그인도 안되고, 게시판만 띄워봤는데 게시판도 안됐습니다. 로그인 버튼을 누르면 그냥 화면이 멎어버리고 게시판은 아무것도 없는 흰 화면이 나옵니다.그리고 스마트폰에 연결했을 때에는 Logcat이 전혀 안나옵니다. (하지만 가상 에뮬레이터의 경우 Logcat이 잘 나옵니다) 안드로이드에서 문제가 발생하고 있는 코드입니다. Task.java1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677package com.example.ggavi.startdb; import android.os.AsyncTask;import android.util.Log;import android.webkit.CookieManager; import java.io.BufferedReader;import java.io.IOException;import java.io.InputStreamReader;import java.io.OutputStreamWriter;import java.net.HttpURLConnection;import java.net.MalformedURLException;import java.net.URL; public class Task extends AsyncTask<String, Void, String> { public static String ip &#61;&#34;111.11.111.11:80&#34;; //자신의 IP번호(your IP) //public static String ip &#61;&#34;111.11.111.11:8088&#34;; //자신의 IP번호(your IP) String sendMsg, receiveMsg; String serverip &#61; &#34;http://&#34;&#43;ip&#43;&#34;/seventeen/list.jsp&#34;; // 연결할 jsp주소 public Task(String sendmsg){ this.sendMsg &#61; sendmsg; } &#64;Override protected String doInBackground(String... strings) { try { String str; URL url &#61; new URL(serverip); final HttpURLConnection conn &#61; (HttpURLConnection) url.openConnection(); String cookieString &#61; CookieManager.getInstance().getCookie(&#34;http://&#34;&#43;ip&#43;&#34;/seventeen/list.jsp&#34;); if (cookieString !&#61; null) { conn.setRequestProperty(&#34;Cookie&#34;, cookieString); } conn.setRequestProperty(&#34;Content-Type&#34;, &#34;application/x-www-form-urlencoded&#34;); conn.setRequestMethod(&#34;POST&#34;); OutputStreamWriter osw &#61; new OutputStreamWriter(conn.getOutputStream()); if(sendMsg.equals(&#34;login_check&#34;)){ sendMsg&#61;&#34;id&#61;&#34;&#43;strings[0]&#43;&#34;&password&#61;&#34;&#43;strings[1]&#43;&#34;&type&#61;&#34;&#43;strings[2]; }else if(sendMsg.equals(&#34;logout&#34;)){ sendMsg&#61;&#34;type&#61;&#34;&#43;strings[0]&#43;&#34;&id&#61;&#34;&#43;strings[1]; } osw.write(sendMsg); osw.flush(); if(conn.getResponseCode() &#61;&#61; conn.HTTP_OK) { InputStreamReader tmp &#61; new InputStreamReader(conn.getInputStream(), &#34;UTF-8&#34;); BufferedReader reader &#61; new BufferedReader(tmp); StringBuffer buffer &#61; new StringBuffer(); while ((str &#61; reader.readLine()) !&#61; null) { buffer.append(str); } receiveMsg &#61; buffer.toString(); } else { Log.i(&#34;통신 결과&#34;, conn.getResponseCode()&#43;&#34;에러&#34;); } } catch (MalformedURLException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } return receiveMsg; } &#64;Override protected void onPostExecute(String s) { //서블릿으로부터 값을 받을 함수 Login login &#61; new Login(); login.setResult(s); }}Colored by Color Scriptercs 문제가 되는 Run 메시지는 아래로 추정됩니다.어떤 문제인지 한참 찾았지만 결국 못 찾아서 질문드립니다.123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354I/System.out: try안D/NetworkSecurityConfig: No Network Security Config specified, using platform defaultI/WebViewFactory: Loading com.android.chrome version 59.0.3071.125 (code 307112552)I/cr_LibraryLoader: Time to load native libraries: 5 ms (timestamps 7132-7137)I/chromium: [INFO:library_loader_hooks.cc(144)] Chromium logging enabled: level &#61; 0, default verbosity &#61; 0I/cr_LibraryLoader: Expected native library version number &#34;59.0.3071.125&#34;, actual native library version number &#34;59.0.3071.125&#34;I/System.out: (HTTPLog)-Static: isSBSettingEnabled falseI/System.out: (HTTPLog)-Static: isSBSettingEnabled falseI/art: Thread[3,tid&#61;426,WaitingInMainSignalCatcherLoop,Thread*&#61;0x7e4248b000,peer&#61;0x12c71ee0,&#34;Signal Catcher&#34;]: reacting to signal 3I/art: Wrote stack traces to '/data/anr/traces.txt'W/System.err: java.net.ConnectException: Connection timed outW/System.err: at java.net.PlainSocketImpl.socketConnect(Native Method)W/System.err: at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:334)W/System.err: at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:196)W/System.err: at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:178)W/System.err: at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:356)W/System.err: at java.net.Socket.connect(Socket.java:586)W/System.err: at com.android.okhttp.internal.Platform.connectSocket(Platform.java:113)W/System.err: at com.android.okhttp.Connection.connectSocket(Connection.java:1432)W/System.err: at com.android.okhttp.Connection.connect(Connection.java:1390)W/System.err: at com.android.okhttp.Connection.connectAndSetOwner(Connection.java:1667)W/System.err: at com.android.okhttp.OkHttpClient$1.connectAndSetOwner(OkHttpClient.java:133)W/System.err: at com.android.okhttp.internal.http.HttpEngine.connect(HttpEngine.java:466)W/System.err: at com.android.okhttp.internal.http.HttpEngine.sendRequest(HttpEngine.java:371)W/System.err: at com.android.okhttp.internal.huc.HttpURLConnectionImpl.execute(HttpURLConnectionImpl.java:503)W/System.err: at com.android.okhttp.internal.huc.HttpURLConnectionImpl.connect(HttpURLConnectionImpl.java:130)W/System.err: at com.android.okhttp.internal.huc.HttpURLConnectionImpl.getOutputStream(HttpURLConnectionImpl.java:261)W/System.err: at com.example.ggavi.startdb.Task.doInBackground(Task.java:41)W/System.err: at com.example.ggavi.startdb.Task.doInBackground(Task.java:19)W/System.err: at android.os.AsyncTask$2.call(AsyncTask.java:304)W/System.err: at java.util.concurrent.FutureTask.run(FutureTask.java:237)W/System.err: at android.os.AsyncTask$SerialExecutor$1.run(AsyncTask.java:243)W/System.err: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1133)W/System.err: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:607)W/System.err: at java.lang.Thread.run(Thread.java:762)I/System.out: task불러진 후I/System.out: 에에nullI/System.out: debug rs>>>>>>>>>nullD/AndroidRuntime: Shutting down VME/AndroidRuntime: FATAL EXCEPTION: main Process: com.example.ggavi.startdb, PID: 420 java.lang.NullPointerException: Attempt to invoke virtual method 'java.lang.String java.lang.String.trim()' on a null object reference at com.example.ggavi.startdb.MainActivity$1.onClick(MainActivity.java:35) at android.view.View.performClick(View.java:6213) at android.widget.TextView.performClick(TextView.java:11074) at android.view.View$PerformClick.run(View.java:23645) at android.os.Handler.handleCallback(Handler.java:751) at android.os.Handler.dispatchMessage(Handler.java:95) at android.os.Looper.loop(Looper.java:154) at android.app.ActivityThread.main(ActivityThread.java:6646) at java.lang.reflect.Method.invoke(Native Method) at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1468) at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1358)Application terminated.Colored by Color Scriptercs

ComPuTa · Accepted Answer

DB서버와 핸드폰간의 Network 문제인듯 합니다. 우선 PC에서 테스트 할땐 되었던건 PC의 네트웍과 DB서버 상의 네트웍망에 ( 방화벽안에 ) 묶여 있기 때문일겁니다. 그리고 핸드폰에서 안되는 이유 ( DB접속이겠죠? )는 핸드폰 과 DB서버상의 네트웍 문제일 가능성이 가장 큽니다. 만약 LTE로 테스트를 했다면 거의 확정적일 것입니다. DB서버가 있는 네트웍의 같은 와이파이 망에 붙어서 테스트를 해보시기 바랍니다.

lllllllllllllll · Answer

노트북과 스마트폰을 같은 와이파이에 연결해서 테스트하니 잘되네요. 감사합니다.

[안드로이드 오라클DB 연동] 에뮬레이터만 연동되고 디바이스는 연동되지 않는 문제

2개의 답변

Q&A 목록