Java - Oracle connection
1 отговора
100 прегледа
Java - Oracle connection
Kogato se svarzvam s bazata (Oracle) danni poluchavam tova saobshtenie:
D:\oracle\ora90\Apache\jdk\bin>java JDBCVersion
waw: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshn
d-1], [0], [], [], [], [], [], []
ako sql-a mi ne sadarja VARCHAR2 pole (pri men to e "name") niamam problemi. Da rechem taka: "select id from names1". Problema e samo ako izvikvam i pole ot tip varchar2. Kak da resha tozi problem?
A eto i koda mi:
import java.sql.*;
import oracle.jdbc.driver.*;
class JDBCVersion
{
public static void main (String args[])
throws SQLException
{
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@localhost:1521:CORETREK","scott","tiger");
Statement statement = conn.createStatement();
ResultSet rs = statement.executeQuery("select * from names1");
while(rs.next()){
System.out.print(rs.getInt(1)+"+\n");
System.out.print(rs.getInt(2)+"v\n");
System.out.print(rs.getInt(3)+"r\n");
System.out.print(rs.getString(1)+"++\n\n");
}
} catch (SQLException sqle) {
System.err.println("waw: " + sqle);
} catch (ClassNotFoundException cnfe) {
System.err.println("qqq: " + cnfe);
}
}
}
D:\oracle\ora90\Apache\jdk\bin>java JDBCVersion
waw: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshn
d-1], [0], [], [], [], [], [], []
ako sql-a mi ne sadarja VARCHAR2 pole (pri men to e "name") niamam problemi. Da rechem taka: "select id from names1". Problema e samo ako izvikvam i pole ot tip varchar2. Kak da resha tozi problem?
A eto i koda mi:
import java.sql.*;
import oracle.jdbc.driver.*;
class JDBCVersion
{
public static void main (String args[])
throws SQLException
{
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@localhost:1521:CORETREK","scott","tiger");
Statement statement = conn.createStatement();
ResultSet rs = statement.executeQuery("select * from names1");
while(rs.next()){
System.out.print(rs.getInt(1)+"+\n");
System.out.print(rs.getInt(2)+"v\n");
System.out.print(rs.getInt(3)+"r\n");
System.out.print(rs.getString(1)+"++\n\n");
}
} catch (SQLException sqle) {
System.err.println("waw: " + sqle);
} catch (ClassNotFoundException cnfe) {
System.err.println("qqq: " + cnfe);
}
}
}
Re: Java - Oracle connection
Hi,
Daj si celia stack-trace na exception-a ta da ti kazha kyde e greshkata.
Zasega moga da ti kazha da si poglednesh alert.log i trace.log na oracle (pri verison 8 i 9 v dir udump/). Tam triabva da ima poveche info.
Probval li si "select name from names1"?
Burn baby!
Daj si celia stack-trace na exception-a ta da ti kazha kyde e greshkata.
Zasega moga da ti kazha da si poglednesh alert.log i trace.log na oracle (pri verison 8 i 9 v dir udump/). Tam triabva da ima poveche info.
Probval li si "select name from names1"?
Burn baby!