Hello,
my app using JBoss325 + MS Sql,
now i want it support oracle9i too,
i ready my oracle DB, and make this changes in jboss:
1. add oracle jdbc classes (classes12.zip)
2. change mssql-service.xml inside deploy to connect to oracle db
3. in conf folder, standardjbosscmp-jdbc.xml file, change the <defaults><datasource-mapping> to Oracle9i
than i start my jboss and tomcat, the application works normally, until the system try to insert a record, i hit this:
11:49:58,625 ERROR [LoginHistoryBean] Could not create entity java.sql.SQLException: ORA-00911: invalid character at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1094)
....
i checked the data type, it have several String -> nvarchar2 and 1 timestamp -> date, and the data is just some normal chars.
Did i miss anything ?
Pls help
Lester