Top "Jdbc" questions

JDBC (Java DataBase Connectivity) is the base API which enables interacting with SQL database servers by executing SQL statements using the Java programming language.

ORA-01882: timezone region not found

I'm accessing an Oracle Database from a java application, when I run my application I get the following error: java.…

Read More
oracle jdbc timezone
Multiple queries executed in java in single statement

Hi I was wondering if it is possible to execute something like this using JDBC as it currently provides an …

Read More
java mysql sql jdbc
org.postgresql.util.PSQLException: FATAL: sorry, too many clients already

I am trying to connect to a Postgresql database, I am getting the following Error: Error:org.postgresql.util.PSQLException: …

Read More
java sql postgresql jdbc
Using "like" wildcard in prepared statement

I am using prepared statements to execute mysql database queries. And I want to implement a search functionality based on …

Read More
java mysql jdbc prepared-statement
Oracle DB : java.sql.SQLException: Closed Connection

Reasons for java.sql.SQLException: Closed Connection from Oracle?? java.sql.SQLException: Closed Connection at oracle.jdbc.driver.DatabaseError.throwSqlException(…

Read More
java sql jdbc oracle10g
java.sql.SQLException: Missing IN or OUT parameter at index:: 1

I made some Java 1.6-Oracle11g-JDBC (using OJDBC 6) code (below). I am getting an exception - java.sql.SQLException: Missing …

Read More
java jdbc oracle11g
MySQL & Java - Get id of the last inserted value (JDBC)

Possible Duplicate: How to get the insert ID in JDBC? Hi, I'm using JDBC to connect on database through out …

Read More
java mysql jdbc
MySQL 'create schema' and 'create database' - Is there any difference

Taking a peak into the information_schema database and peaking at the metadata for one of my pet projects, I'm …

Read More
sql mysql oracle jdbc database
SQLException: No suitable Driver Found for jdbc:oracle:thin:@//localhost:1521/orcl

I am trying to develop a Java EE application that connect to an Oracle database from eb service class but …

Read More
java oracle jdbc jboss ojdbc
Java: Insert multiple rows into MySQL with PreparedStatement

I want to insert multiple rows into a MySQL table at once using Java. The number of rows is dynamic. …

Read More
java mysql jdbc prepared-statement batch-insert