Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException: 7
791261Aug 30 2011 — edited Oct 15 2014Hi friends i am using Oracle Express 10g 2
in the XE database i am having a table USERS +(USER_ID USER_NAME USER_LEVEL_CODE USER_BRANCH_CODE USER_DEPT_CODE USER_PASSWORD USER_ENTD_BY USER_AUTH_BY)+ when i try to Connect with Java or Jasper Report i am getting Errors.
In Java
With Classes12, ojdbc6 and ojdbc12 Jar's
package jdbcEX1;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import oracle.jdbc.*;
public class Ex1 {
public static void main(String args[]) throws ClassNotFoundException,
SQLException {
Class.forName("oracle.jdbc.driver.OracleDriver");
// DriverManager.registerDriver(
// new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection(
*"jdbc:oracle:thin:@localhost:1521:XE", "uthaya", "password");*
Statement stmt = conn.createStatement();
ResultSet rset = stmt.executeQuery("select * from users");
while (rset.next())
{
System.out.println(rset.getInt(1));
System.out.println(rset.getString(2));
System.out.println(rset.getString(3));
System.out.println(rset.getInt(4));
System.out.println(rset.getString(5));
System.out.println(rset.getString(6));
System.out.println(rset.getString(7));
System.out.println(rset.getString(8));
}
rset.close();
stmt.close();
conn.close();
}
}
The Error is
Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException: 7
at oracle.security.o3logon.C0.r(C0)
at oracle.security.o3logon.C0.l(C0)
at oracle.security.o3logon.C1.c(C1)
at oracle.security.o3logon.O3LoginClientHelper.getEPasswd(O3LoginClientHelper)
at oracle.jdbc.ttc7.O3log.<init>(O3log.java:289)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:251)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:246)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at jdbcEX1.Ex1.main(Ex1.java:18)
I tried with
Connection conn = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:8080:XE", "uthaya", "password");
too ..
Please help me to fix it ...
Thanks in Advance .
Uthaya
Edited by: Uthaya on Aug 30, 2011 5:50 AM