| JDev Jsp jdbc: ORA-00600 when select varchar2 [message #91369] |
Tue, 30 July 2002 00:09  |
guigui
Messages: 1
Registered: July 2002
|
Junior Member |
|
|
I do JSP with JDevelopper 3.2.3 and I've a Oracle9i database.
When I want to select a VARCHAR2 from my database with a JDBC connexion.I receive this error message. But only for Varchar2. If I select a number (ID in my example), there's no problem. But "select *" or "select COl" give the same error message?
I understand nothing....Tank you for your futur help.
--------oracle object definition----------
CREATE TABLE "ARCHIVES"."TEST" ("ID" NUMBER(10), "COL"
VARCHAR2(30 byte))
TABLESPACE "ARCHIVES" ;
-----------JSP script ---------
Connection cx=null;
Statement stmt=null;
ResultSet rs=null;
String req="select * from "ARCHIVES"."TEST"";
String url = "jdbc:oracle:thin:@...:1521:....";
try{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
out.println("
--> Chargement du pilote Oracle réussi.
");
cx=DriverManager.getConnection(url,"archives","...");
out.println("
--> Connection à la base de données réussie.
");
stmt=cx.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE ,ResultSet.CONCUR_UPDATABLE);
out.println("
--> CreateStatement réussi.
");
out.println("
-- Requête SQL :"+req+"
");
stmt.execute(req);
rs=stmt.getResultSet();
out.println("
--> ResultSet réussi.
");
int id=0;
String col=null;
while(rs.next()){
id=rs.getInt("ID");
col=rs.getString("COL");
}
}
catch(Exception e){
out.println("
** "+e+"**
");
}
finally{
cx.close();
out.println("
Connexion fermée.
");
}
-----result page-----------
TEST DE LA CONNEXION A LA BASE DE DONNEES "ARCHIVES"
--> Chargement du pilote Oracle réussi.
--> Connection à la base de données réussie.
--> CreateStatement réussi.
-- Requête SQL :select * from "ARCHIVES"."TEST_01"
** java.sql.SQLException: ORA-00600: code erreur interne, arguments : [[ttcgcshnd-1]], [[0]], [[]], [[]], [[]], [[]], [[]], [[]] **
--> Connexion fermée.
|
|
|
|
|
|
| Re: JDev Jsp jdbc: ORA-00600 when select varchar2 [message #92522 is a reply to message #91369] |
Mon, 30 August 2004 09:32  |
David Robertus
Messages: 1
Registered: August 2004
|
Junior Member |
|
|
|
Check your classpth- most likely you only have the classesXX.jar (or zip) in your classpath. Oracle has several datatypes that go beyond the Java SQL Types. You can access these by including the addition Oracle type packages in your classpath, which may include ocrd.jar and nls_charsetXX.jar. Include these and you should be good to go.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
