On 12/8/05, ravi <[EMAIL PROTECTED]> wrote:
> I am getting some error .The code that I am using is as follows,
> Connection connection = null;
> String jdbcDriver="oracle.jdbc.driver.OracleDriver";
> String
> jdbcConnectionUrl="jdbc:oracle:thin:scott/[EMAIL PROTECTED]:1521:orcl";
>
> Class.forName(jdbcDriver);
> System.out.println("Driver initialized...");
> Connection connection =
> DriverManager.getConnection(jdbcConnectionUrl);
> System.out.println("Connected to database...");
>
> Platform platform =
> PlatformFactory.createNewPlatformInstance(jdbcDriver,jdbcConnectionUrl);
> System.out.println("Platform object created....");
>
> System.out.println("Reading from database....");
>
> Database db=platform.readModelFromDatabase(connection);
> //error at this line
> System.out.println("Read database successfully ....");
> DatabaseIO dbio = new DatabaseIO();
> dbio.write(db,"D:/techforum/files/db3.xml");
> System.out.println("written to xml file....");
> I am getting the following errors,
> Exception in thread "main" org.apache.ddlutils.DynaSqlException:
> java.sql.SQLExc
> eption: ORA-01424: missing or illegal character following the escape
> character
>
> at
> org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(Platform
> ImplBase.java:1075)
> at ora_dump.main(ora_dump.java:47)
> Caused by: java.sql.SQLException: ORA-01424: missing or illegal character
> following the escape character
>
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
> at
> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:21
> 3)
> at
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.
> java:952)
> at
> oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java
> :1054)
> at
> oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPrepa
>
>
> Can any one tell me what may be the reason of this error ?
> I am using Oracle 10.2 and JDK 1.5
Could you try this with P6Spy (http://www.p6spy.com/) so that we can
see the SQL that is in error ? It might also help if you post the XML
file, judging from the error message there might be some problem with
a name.
Tom
