db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Dudziak <tom...@gmail.com>
Subject Re: Help needed
Date Fri, 09 Dec 2005 03:47:38 GMT
On 12/8/05, ravi <ravi_kumar@persistent.co.in> 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/tiger@ps2116: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

Mime
View raw message