Hitachi Vantara Pentaho Community Forums
Results 1 to 8 of 8

Thread: Error ORA-01424 on connect

  1. #1
    Join Date
    Oct 2008

    Default Error ORA-01424 on connect

    Hi, im using workbench version I try to connect with an Oracle database using this parameters:

    Driver: oracle.jdbc.OracleDriver
    Connection :jdbcracle:thin:sys as sysdba/password@ip:1521rcl

    I have the latest oracle driver in the corrtect directory, but i can't connect, an exception occurs in JDBCTreeModel, ORA-01424.

    Can anyone help me please?

  2. #2


    put the Oracle driver in ur workbench\drivers folder to make coonection with Oracle database bcoz by default drivers are not available in ur workbench
    Mr. Manasa Ranjan Panda
    M.No-+91 9392923252

  3. #3


    Quote Originally Posted by Manasa_InfoAxon View Post
    put the Oracle driver in ur workbench\drivers folder to make coonection with Oracle database bcoz by default drivers are not available in ur workbench
    If the Oracle driver were not in the right place, I'd think they'd be getting a ClassNotFound exception, not an Oracle error message.

    mbike -- Are you able to connect using that URL from another tool like DBVisualizer or SquirrelSQL? Looks like Oracle is complaining about a bad escape character based on that error message.

  4. #4
    Join Date
    Oct 2008


    The Oracle driver is in the rigth place, the error is not "ClassNotFound Exception", is ORA-01424.

    I can connect to this database with anothers programs, so the url is well.

    I have no problems using Schema Workbench with MySQL, but I still not able to connect with my Oracle database.

  5. #5
    Join Date
    Aug 2007


    The error description for ORA-01424 is missing or illegal character following the escape.

    mbike could you please provide the exception's stack trace plus the exact steps you follow to reproduce this issue?

  6. #6
    Join Date
    Oct 2008


    This is the complete trace of exception:

    09:16:09,010 ERROR [JDBCTreeModel] JDBCTreeModel
    java.sql.SQLException: ORA-01424: falta o no es vßlido el carßcter que sigue al
    carßcter de escape
    at oracle.jdbc.driver.DatabaseError.throwSqlException(
    at oracle.jdbc.driver.T4CTTIoer.processError(
    at oracle.jdbc.driver.T4CTTIoer.processError(
    at oracle.jdbc.driver.T4C8Oall.receive(
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.
    at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedSta
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStateme
    at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPrepa
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePrepare
    at oracle.jdbc.driver.OracleDatabaseMetaData.getColumns(OracleDatabaseMe
    at mondrian.gui.JDBCTreeModel.<init>(
    at mondrian.gui.JDBCExplorer.setConnection(
    at mondrian.gui.JDBCExplorer.<init>(
    at mondrian.gui.Workbench.newJDBCExplorerMenuItemActionPerformed(Workben
    at mondrian.gui.Workbench.access$300(
    at mondrian.gui.Workbench$4.actionPerformed(
    at javax.swing.AbstractButton.fireActionPerformed(
    at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.jav
    at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel
    at javax.swing.DefaultButtonModel.setPressed(
    at javax.swing.AbstractButton.doClick(
    at javax.swing.plaf.basic.BasicMenuItemUI.doClick(
    at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMen
    at java.awt.Component.processMouseEvent(
    at javax.swing.JComponent.processMouseEvent(
    at java.awt.Component.processEvent(
    at java.awt.Container.processEvent(
    at java.awt.Component.dispatchEventImpl(
    at java.awt.Container.dispatchEventImpl(
    at java.awt.Component.dispatchEvent(
    at java.awt.LightweightDispatcher.retargetMouseEvent(
    at java.awt.LightweightDispatcher.processMouseEvent(

    at java.awt.LightweightDispatcher.dispatchEvent(
    at java.awt.Container.dispatchEventImpl(
    at java.awt.Window.dispatchEventImpl(
    at java.awt.Component.dispatchEvent(
    at java.awt.EventQueue.dispatchEvent(
    at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchTh
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
    at java.awt.EventDispatchThread.pumpEvents(

    at java.awt.EventDispatchThread.pumpEvents(


  7. #7

    Default [solved]

    I create a Java Eclipse Project and change the method setColumns(DbTable dbt) in to avoid table names with special chars like |, $, = and that starts with BIN.

    /* get all columns for a given table name */

    private void setColumns(DbTable dbt){
    ResultSet rs = null;

    if ("/") ||"$") ||"=") ||"BIN") ) {
    LOGGER.debug("discarding schemaName: "+dbt.schemaName+", name ";
    } else {
    rs = md.getColumns(null, dbt.schemaName,, null);
    while( {
    dbt.addColsDataType(rs.getString("COLUMN_NAME"), rs.getString("DATA_TYPE"));
    if ( rs != null ) rs.close();
    } catch (Exception e) {
    LOGGER.error("setColumns", e);

    And recomplie e generate a new lib/ (attached) to be run!

    I work's fine!
    Attached Files Attached Files

  8. #8
    Join Date
    Mar 2009


    hi oziel.nieto, i have tried your solution, and connection to database work but when i click on JDBCExplorer the same error appear, so in my honest opinion the problems are hier
    at mondrian.gui.JDBCTreeModel.<init>(JDBCTreeModel.ja va:52)
    at mondrian.gui.JDBCExplorer.setConnection(JDBCExplor
    at mondrian.gui.JDBCExplorer.<init>( :35) generate an error

    and/or hier

    at oracle.jdbc.driver.OracleDatabaseMetaData.getColum ns(OracleDatabaseMe

    Oracle driver generate error

    Thank you!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.