You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ddlutils-dev@db.apache.org by ravi <ra...@persistent.co.in> on 2005/12/08 10:05:51 UTC

Help needed

Hi all 

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

Thanks,
Ravi

Re: Help needed

Posted by Thomas Dudziak <to...@gmail.com>.
On 12/8/05, ravi <ra...@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