Problem with JBuilder2005 and Oracle 9i on Windows 2000 workstation
From: nemrod2100 (nemrod2100_at_yahoo.com)
Date: 11/28/04
- Previous message: Atul: "Syntax of setting Ref Cursor in procedure from JDBC"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Sun, 28 Nov 2004 14:42:04 +0100
Problem with JBuilder2005 and Oracle 9i on Windows 2000 workstation
Hello I tried to test a basic classe connecting to Oracle 9i
However I obtained this strange error message
java.sql.SQLException: ORA-00600: internal code error, arguments :
[ttcgcshnd-1], [0], [], [], [], [], [], []
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:542)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311)
at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:797)
at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1608)
at oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1758)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:1807)
at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:411)
at
monbabarpremier.MaTroisiemeClasseOracle.main(MaTroisiemeClasseOracle.java:26
)
Exception in thread "main"
The classe is very basic and database is also
My classe is
package monbabarpremier;
import java.sql.*;
import oracle.jdbc.driver.*;
import java.util.*;
public class MaTroisiemeClasseOracle
{
public static void main(String[] args)
throws SQLException, ClassNotFoundException, java.io.IOException
{
String uneUrl = "jdbc:oracle:thin:@piv3ghz:1521:BDSOUTOU";
String uneUrl02 = "jdbc:oracle:thin:@169.254.164.254:1521:BDSOUTOU";
String loginUser02 ="moustac";
String passwordLoginUser02 = "0123456789";
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection uneConnexion = DriverManager.getConnection(
"jdbc:oracle:thin:@169.254.164.254:1521:bdsoutou","moustac","0123456789");
Statement unEnonceSQL = uneConnexion.createStatement();
String uneRequete02 ="select nomsegment from segments";
String uneRequete01= "select sysdate from dual";
//select nomsegment from segments
//"SELECT NOMSEGMENT FROM SEGMENTS "
//select * from dept;
ResultSet unCurseur = unEnonceSQL.executeQuery("select nomsegment from
segments");
while(unCurseur.next())
{
//NOMSEGMENT
String unNomDeSegment = unCurseur.getString("nomsegment");
System.out.println(" "+ unNomDeSegment);
}
//unEnonceSQL.close();
uneConnexion.close();
}
//catch(SQLException)
{
}
}
}
This is strange because when I apply this request
"select sysdate from dual" it gave me the good result.
It seems that JBuilder can connect to Oracle but not abble to reach
my BDSOUTOU database .
I actived all Oracle services on Windows.
Untill now without results.
Jbuilder shows me that the problem came from
this line
at
monbabarpremier.MaTroisiemeClasseOracle.main(MaTroisiemeClasseOracle.java:26
)
matches with this line
ResultSet unCurseur = unEnonceSQL.executeQuery("select nomsegment from
segments");
I tried other request on other tables, spelling several times
("nomsegment") or the name of this colunn without results.
getString("nomsegment");I know this is a common mistakes
What's happened???
I don't know if problems comes from JBuilder or Oracle 9i or Windows2000
workstation, or bad services which parasytes the connection.
Of course I loaded the true ojdbc14.jar or classe12.jar.
I added as new librarie, with tools/configuration etc...
Can somebody help me.I worked on Windows 2000 workstation.
Best regards.
- Previous message: Atul: "Syntax of setting Ref Cursor in procedure from JDBC"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
|
