java.sql.SQLException: Exceding key size
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:420)
at oracle.jdbc.ttc7.O3log.<init>(O3log.java:255)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:166)
at
oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:93)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:147)
at java.sql.DriverManager.getConnection(DriverManager.java:91)
at java.sql.DriverManager.getConnection(DriverManager.java:134)
at JdbcTest.main(JdbcTest.java:23)
my source code is:
import java.sql.*;
import java.util.*;
import java.io.*;
import java.lang.*;
import java.net.*;
import oracle.jdbc.driver.*;
class JdbcTest {
public static final String DRIVER_NAME = "oracle.jdbc.driver.OracleDriver";
public static final String DATABASE_URL =
"jdbc:oracle:thin:@host_name:1521:SID";
public static void main (String args []) throws ClassNotFoundException,
SQLException {
Class.forName (DRIVER_NAME);
System.out.println("Connection...");
Connection conn =DriverManager.getConnection (DATABASE_URL, "user_name",
"password");
System.out.println("Connection make!");
Statement stmt = conn.createStatement ();
ResultSet rset = stmt.executeQuery ("SELECT gsm FROM korisnik");
while (rset.next ())
System.out.println (rset.getString (1));
rset.close();
stmt.close();
conn.close();
}
}
where i make mistake??
--
Pozdrav,
ilica
_________
"Computers are useless. They can only give you answers."
Examples.
"jdbc:oracle:thin:@server1:1521:MyDB";
getConnection (DATABASE_URL, "scott","tiger")
where my database is called MyDB which resides on server1 and I have a
user scott with password tiger.
"REM" <ilica....@zg.hinet.hr> wrote in message news:<9n8g3f$89f1$1...@as201.hinet.hr>...
"Greg Sill" <greg...@ingenix.com> wrote in message
news:175a1a24.01090...@posting.google.com...