Home » Developer & Programmer » Data Integration » Problem running the Oracle9i Data Mining samples
Problem running the Oracle9i Data Mining samples [message #92920] Mon, 18 March 2002 00:53 Go to next message
Vincent Dervaux
Messages: 3
Registered: February 2002
Junior Member

I'm trying to use data mining that is embedded in Oracle9i. Oracle9i provides Java API that allow users to develop data mining software.

When i tried to run the Java AssociationRules sample i've got the following error:

Completed MiningServer login
Formed bin boundary objects: census_2d_build
Created discretization tables for: census_2d_build
Received an exception in main: ORA-00905: missing keyword
ORA-06512: at line 1

java.sql.SQLException: ORA-00905: missing keyword
ORA-06512: at line 1

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:862)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1839)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1764)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2354)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:421)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:486)
at oracle.dmt.odm.transformation.Transformation.discretize(Transformation.java:607)
at Sample_Discretization.performCensusBinningFor2D(Sample_Discretization.java:182)
at Sample_AssociationRules.performDiscretization(Sample_AssociationRules.java:202)
at Sample_AssociationRules.main(Sample_AssociationRules.java:128)
Logging out of MiningServer.

Using Java debugger i can see that the problem in function odm_mining_transformation.discretize_2d(...)

Thanks to Oracle wrapped packages i can't handle with this problem.
Is there any unwrapper or something to fix bad package?
Any ideas?

Vincent Dervaux
Re: Problem running the Oracle9i Data Mining samples [message #93007 is a reply to message #92920] Sat, 24 August 2002 06:03 Go to previous message
sajit roshan
Messages: 3
Registered: August 2002
Junior Member
Why are you using the table named census_2d_build? Please try with the tables having the Market Basket data.
Previous Topic: Oracle Express
Next Topic: Help Oracle9i Data Mining
Goto Forum:

Current Time: Thu May 23 11:13:39 CDT 2024