No suitable driver found for jdbc:oracle:thin:@192.168.7.146:1521:oracleThe reasons for this error are mainly the following:1. URL configuration error (similar to the following)2. JDK version, JDBC version, and error caused by inconsistent database version.The first thing to ensure that your database supports the corresponding JDBC version, and then according to the JDBC version supported by the database, determine the JDK version to use, only three a
The driver packages from Oracle8 to ORACLE10,JDBC directories are different. Look at Oracle's documentation, understand their use, I believe you are sometimes very confused, write to share.
These are the names of the driver packages under oracle10g and their role, and other versions of Oracle are basically similar.
Classes12.jar (1,417,089 bytes)-Use under JDK 1.
Label:Maven adds dependency issues for Oracle JDBC driversOracle's JDBC Driver jar package cannot be downloaded in the MAVEN project and requires Oracle's official authorization to To find a ojdbc14 10.2.0.1.0 or 10.2.0.2.0 package, let maven re-hit the jar package and place it in the local repository by following the command below:MVN install:install-file-dgroupid=com.oracle-dartifactid=ojdbc14-dversion=10
Document reprinted by Fire Site Building InstituteTo install the oracle driver using gem in ruby on rails, see the original article:
Reference content is as follows:[1] viewing locally installed plug-insGem list orGem list -- local[2] viewing remote available plug-insGem list -- romote[3] viewing oracle driversGem list -- remote | grep oracleThe resu
The following error is reported in the Oracle warning log:
ReferenceORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [], [], [], []Current SQL statement for this session:Select value from NLS_INSTANCE_PARAMETERS where parameter = 'nls _ DATE_FORMAT'
After analysis, this is a bug in connecting JDBC (Thin JDBC driver) to Oracle. When the
1. Find the available oracle jdbs driver jar package and place it in the specified directory (which can be customized as needed) D: \ jdbc \ ojdbc14.jar
2. Install maven. Configure the environment variable MAVEN_HOME = 'point to the maven installation directory'
3. Open the cmd window, jump to the D: \ jdbc directory, and execute the command
Mvn install: install-file-DgroupId = com.
Problem Status:Several OJDBC package dependencies found on Maven Repository are not automatically downloaded to the. M2 directory through Maven, resulting in a OJDBC prompt error in the project.Workaround:1. Open the JDBC Jar file directory under the locally installed Oracle installation directory, my computer is D:\app\Lenovo\product\11.2.0\dbhome_1\jdbc\lib, open2, enter CMD in the path bar, and then enter to open the CMD windowOpen the directory pa
due to Oracle licensing issues, MAVEN3 does not provide Oracle JDBC driver, In order to apply the Oracle JDBC driver in a MAVEN project, you must manually add it to the local warehouse. first , to get the Oracle JDBC
Tags: CTI aging 1.0 end Jar Div Pen Oracle LenovoMVN Install:install-file-dgroupid=com.oracle-dartifactid=ojdbc6-dversion=11.2.0.1.0-dpackaging=jar-dfile=d:\app \lenovo\product\11.1.0\db_1\jdbc\lib\ojdbc6.jar (Driver package in Oracle installation directory)Pom file after installation is completeNote: The groupid,artifactid,version in the Pom.xml file must be the
Pom.xml loading jar pack times wrong: Missing artifact com.oracle:ojdbc14:jar:10.2.0.4.0.Because of Oracle's OJDBC charges, there is no Ojdbc14-10.2.0.4.0.jar package when the MAVEN project is imported.Workaround:Configure the local library. Download the jar package, place the jar package in the repository's corresponding folder Ojdbc14\10.2.0.4.0\, install to the local warehouse (need to match MAVEN environment variables beforehand), write the following command in the command line tool, note th
Tags: group HTTP technology share local repository maven add res COM successOracle does not support the download of Maven repositoriesWorkaround:1: Go to Oracle Download the required drive jar packageHttp://www.oracle.com/technetwork/database/features/jdbc/default-2280470.html2: Local command packs the jar package into a jar package under MavenMVN install:install-file-dgroupid=com.oracle-dartifactid=ojdbC7-dversion=12.1.0.2-dpackaging=jar-dfile=ojdbc7
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.