Win a copy of Testing JavaScript Applications this week in the HTML Pages with CSS and JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
  • Piet Souris
  • Frits Walraven
  • Carey Brown

SQLException: Callable statments not supported.

Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
// Call from java
//Success - Created Connection
//Error - SQLException: Callable statments not supported.

/* java version JDK 1.5
MYSQL version 5.0.22

procedure already created inmy sql. But when i have call in java that time give me error "SQLException: Callable statments not supported."

java program

import java.sql.*;
import java.sql.CallableStatement;
import exception.Excephandling;

public class Createpro {

* @param args
* @throws Exception
* @throws ClassNotFoundException
* @throws SQLException
CallableStatement cs = null;

public static void main(String[] args) throws Exception {

Createpro obj = new Createpro();

public void get() throws Excephandling {
Connection con = null;
Statement stmt = null;
CallableStatement cs = null;

String driverName = "com.mysql.jdbc.Driver";
try {
} catch (ClassNotFoundException e) {
throw new Excephandling("SYS_1", "Driver class not found", e);
String url = "jdbc:mysql://localhost/yatra1";
String user = "root";
String pwd = "local";
try {
con = DriverManager.getConnection(url, user, pwd);
System.out.print("connection created");

stmt = con.createStatement();
stmt.execute("insert into test3 values(7,7,'2007-08-08')");

cs = con.prepareCall("{call p2()}");

} catch (SQLException e) {
System.err.println(" SQLException: " + e.getMessage());

// e.printStackTrace();


pls replay me what problems
Posts: 2658
Netbeans IDE C++ Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Might be related to the version of your MySQL driver (is it a 3.* version, or the mm driver?).
Please try the latest one (5.0 at the time of writing) at MySQL� Connector/J.

Regards, Jan
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
    Bookmark Topic Watch Topic
  • New Topic