안드로이드 Oracle 연동 질문입니다.

Question

현재 사내앱 개발중에있는데, 안드로이드스튜디오와 oracle dbms를 연결해야하는 상황입니다.oracle 버전확인결과 12.2.0.1 로확인되어,오라클홈페이지에서 노란색으로 체크된 파일 받아서 아래사진과같이 libs 폴더안에 넣었습니다. 또jdk8과 호환된다고 하여 아래사진과 같이 jdk 8버전으로 맞춰놧습니다 ㅠ그리고 buil.gradle(:app)에서 dependencies 부분에 implementation files('D:\Android Tutorial\mes\app\libs\ojdbc8.jar') 를 추가하였습니다.A problem occurred configuring root project 'mes'. > Could not resolve all files for configuration ':classpath'. > Could not resolve com.android.tools.build:gradle:7.4.2. Required by: project : > com.android.application:com.android.application.gradle.plugin:7.4.2 project : > com.android.library:com.android.library.gradle.plugin:7.4.2 > No matching variant of com.android.tools.build:gradle:7.4.2 was found. The consumer was configured to find a library for use during runtime, compatible with Java 8, packaged as a jar, and its dependencies declared externally, as well as attribute 'org.gradle.plugin.api-version' with value '8.3' but: - Variant 'apiElements' capability com.android.tools.build:gradle:7.4.2 declares a library, packaged as a jar, and its dependencies declared externally: - Incompatible because this component declares a component for use during compile-time, compatible with Java 11 and the consumer needed a component for use during runtime, compatible with Java 8 - Other compatible attribute: - Doesn't say anything about org.gradle.plugin.api-version (required '8.3') - Variant 'javadocElements' capability com.android.tools.build:gradle:7.4.2 declares a component for use during runtime, and its dependencies declared externally: - Incompatible because this component declares documentation and the consumer needed a library - Other compatible attributes: - Doesn't say anything about its target Java version (required compatibility with Java 8) - Doesn't say anything about its elements (required them packaged as a jar) - Doesn't say anything about org.gradle.plugin.api-version (required '8.3') - Variant 'runtimeElements' capability com.android.tools.build:gradle:7.4.2 declares a library for use during runtime, packaged as a jar, and its dependencies declared externally: - Incompatible because this component declares a component, compatible with Java 11 and the consumer needed a component, compatible with Java 8 - Other compatible attribute: - Doesn't say anything about org.gradle.plugin.api-version (required '8.3') - Variant 'sourcesElements' capability com.android.tools.build:gradle:7.4.2 declares a component for use during runtime, and its dependencies declared externally: - Incompatible because this component declares documentation and the consumer needed a library - Other compatible attributes: - Doesn't say anything about its target Java version (required compatibility with Java 8) - Doesn't say anything about its elements (required them packaged as a jar) - Doesn't say anything about org.gradle.plugin.api-version (required '8.3') * Try: > Run with --info or --debug option to get more log output. > Run with --scan to get full insights. > Get more help at https://help.gradle.org. 그러면 위 오류가 나게되고.. gradle 버전이나 jdk버전(11)을 바꾸면 java.lang.NoClassDefFoundError: Failed resolution of: Ljava/sql/DriverAction; at java.lang.Class.classForName(Native Method) at java.lang.Class.forName(Class.java:536) at java.lang.Class.forName(Class.java:467) 위 오류가 발생하게됩니다..... Class.forName(&#34;oracle.jdbc.driver.OracleDriver&#34;);이 부분에서 오류가나는건데.. 도대체 어떻게 해결해야할지모르겠습니다 ㅠㅠ

abccbama · Answer

꼭 Oracle을 써야하는건가요? SQLite같은거 쓰시면 안되는지...?요새는 임베디드용 DB도 나오고 해서 찾아봤는데이게 아닐지 ... 슥 봤는데 링크 공유드려요https://docs.oracle.com/en-us/iaas/digital-assistant/doc/oracle-android-native-sdk.html여기 비슷한 질문도 있네요 안드로이드용 Oracle DB답변달려있네요https://www.phpschool.com/gnuboard4/bbs/board.php?bo_table&#61;qna_db&wr_id&#61;214941

거북손 · Answer

슥봤는데 ㅎㅎ.. 뭐 위에서 말씀하시는거는 다 맞는 이야기이고 쓴이 분께서 무조건 해야한다하면 ... 해결하셨는지요..? 1%의 앱을 원하는 사람이 있어서 ㅋㅋㅋㅋ 저도 알아보고있는데 정보 공유좀? 부탁드려요 ㅎㅎ ..

안드로이드 Oracle 연동 질문입니다.

2개의 답변

Q&A 목록