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: insta
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.
1. Overview
The DriverManager class is a JDBC management layer that acts between users and drivers. It tracks the available drivers and establishes a connection between the database and the corresponding drivers. In addition, the DriverManager class handles transactions such as driver logon time limits and the display of logon and trace messages.
For simple applications, the only way that the average prog
-->
-->
Microsoft will not be happy to see this headline. But to be honest, in business applications, there are few companies that really use Microsoft's com.microsoft.jdbc.sqlserver.sqlserverDriver.
In fact, it is also a chance to find out the lack of Microsoft drive. In a single porting application, the system reported errors such as [microsoft][sqlserver JDBC Driver]resultset can not re-read row data
Cannot load driver class:com.mysql.jdbc.DriverHow to add a JDBC driver in the pom file
To-start with, the jar that I need to connect to MySQL 5.5 should have been Mysql-connector-java-5.1.15-bin.jar but Sql-connector-java-5.1.15.jar. Secondly, this jar isn't available in Maven repository so I needed to manually add it to M Y local maven repository and then added
Label:It is necessary to connect to the database when using JDBC programming, import the jar package is necessary, import the other Jar package method is same, the import method isOpen Eclipse1. Right-click the project to import the jar package, click Properties2. Choose Java build path on the left and select libraries on the right.3. Select Add External jars4. Select the jar package according to the pathOK, it's okay.Java connection to MySQL's latest
I have not used Mysql for a long time. Yesterday, my friend had no problem with running a small project on my machine, but reported an internal server error (500) on his machine ), using QQ for Remote Assistance (too slow), it took me half a day to finally find the reason because Mysql5 was used on a friend's machine and the Connector/J 3.0 was used as the driver, finally, switch to the Connector/J 3.1 Driver
In the last two days, I have compiled a summary document about Flume and did not launch Tomcat. The deployment started last night, found the title error, the full text is as follows:Critical: The Web application [/oa-deploy] registered the JBDC driver [Com.microsoft.sqlserver.jdbc.SQLServerDriver] but failedTo unregister it when the Web application was stopped. To prevent a memory leak, the JDBC
Before, also encountered such a problem, let me tangled up long time. Finally the solution was finally tried out.We downloaded sub-folders under the Sqljdbc4.0 folder in JDBC 4.0 CHS with two jar files, Sqljdbc.jar and Sqljdbc4.jar. We follow the online blog, when the configuration to establish the data connection, add is Sqljdbc.jar this jar file, so there will be such a problem. Instead, you should add Sqljdbc4.jar. That would not have been the case
Oracle's JDBC driver three main categories:
1. JDBC OCI:OCI is an abbreviation for Oracle call interface, which is similar to the traditional ODBC driver. Because it requires Oracle call Interface and NET8, it needs to install the client software on a machine that is running the Java program using this
Cannot create JDBC driver of class ''for connect URL 'null'
In Tomcat 5.5.xx, this problem occurs when the previous configuration method is used.
Solution:
Insert the resource description in the following format into
To replace the previous configuration method:
Mysql exception:
Com. mysql. jdbc. communicationsException: The driver was unable to create a connection due to an inability to establish the client portion of a socket. this is usually caused by a limit on the number of sockets imposed by the operating system. this limit is usually retriable. for Unix-based platforms, see the manual page for the 'ulimit 'command. kernel or system reconfiguration may als
Label:The main steps are as follows:1. Local download Sqljdbc4.jar2. Unzip to the local folder and locate the Sqljdbc4.jar path3. Open the Command window, open to the project directory, execute the following statement (provided that the MAVEN environment variable is configured first)MVN install:install-file-dfile=e:\sqljdbc4.jar-dgroupid=com.microsoft.sqlserver-dartifactid=sqljdbc4-dversion= 4.0-dpackaging=jar4. "BUILD SUCCESS" is added successfullyThe pom file is set as follows:Add Microsoft SQ
Original address: http://blog.csdn.net/xiazdong/article/details/6884218In writing JDBC is the problem of discovery.Error wording:Originally wanted to indicate that the name contains "Xia" names, but how to run the wrong.String sql = "SELECT name from emp WHERE name is like%?%";Preparedstatment stat = con.preparestatement (SQL);Stat.setstring (1, "Xia");Correct wording:In the SQL variable like only write a q
Brief Introduction
LED lamp cost is very low, easy to operate, in the embedded product is indispensable, can be used as debugging logo, status indicator, etc., advanced usage can also as a breathing lamp to further enhance its aesthetic nature. This chapter describes only control LED lights, tiny4412 Development Board has four LED lights on the core board for user operation, led light out of the CPU IO output level, specific control to see the actual circuit. circuit diagram
On the tiny4412 Dev
Tags: style http io color ar os using SP javaHow to get a database connection: 1. Driver Interface: ? The Java.sql.Driver interface is the interface that all JDBC drivers need to implement. This interface is provided to the database vendors, different database vendors to provide different implementations ? The program does not need to go directly to the implementation of the
Environment: tomcat6, jdk1.6, Oracle10g, and myeclipse8.6
When a JNDI project is run, an exception occurs: org. Apache. tomcat. DBCP. DBCP. sqlnestedexception: cannot create JDBC driver of class ''for connect URL 'null '.
Solution:
1. Add Oracle driver package ojdbc14_g-10.2.0.1.0.jar under Tomcat 6.0 \ Lib
2. Add the following content to the context. xml
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.