OraFAQ Forum: Data Integration » Problem running the Oracle9i Data Mining samples

Home » Developer & Programmer » Data Integration » Problem running the Oracle9i Data Mining samples

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem running the Oracle9i Data Mining samples [message #92920]

Mon, 18 March 2002 00:53

Vincent Dervaux
Messages: 3
Registered: February 2002

Junior Member

Hello,

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 "ODM.ODM_MINING_TRANSFORMATION", line 1613
ORA-06512: at line 1

java.sql.SQLException: ORA-00905: missing keyword
ORA-06512: at "ODM.ODM_MINING_TRANSFORMATION", line 1613
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

Report message to a moderator

Re: Problem running the Oracle9i Data Mining samples [message #93007 is a reply to message #92920]

Sat, 24 August 2002 06:03

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.

Report message to a moderator

Previous Topic:	Oracle Express
Next Topic:	Help Oracle9i Data Mining

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 19:55:51 CST 2024