I'm trying to completely change the datasource from hsqldb
to Oracle.
I have a problem with timer persistence. I've changed the name
of the datasource in ejb-deployer.xml and modified the CREATE
TABLE statement to:
CREATE TABLE TIMERS (
| TIMERID VARCHAR2(50) NOT NULL,
| TARGETID VARCHAR2(50) NOT NULL,
| INITIALDATE TIMESTAMP NOT NULL,
| INTERVAL NUMBER(19),
| INSTANCEPK BLOB,
| INFO BLOB,
| CONSTRAINT TIMERS_PK PRIMARY KEY (TIMERID)
| )
But it don't works... the table have been created succesfully but Jboss can't create
timers...
I get the following exception:
2004-10-28 15:46:36,812 ERROR [org.jboss.ejb.txtimer.TimerServiceImpl] Cannot create
txtimer
| java.lang.IllegalStateException: Unable to persist timer
| at
org.jboss.ejb.txtimer.DatabasePersistencePolicy.insertTimer(DatabasePersistencePolicy.java:137)
| at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
| at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
|
| ....
|
| Caused by: java.sql.SQLException: Invalid column type
| at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
| at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
| at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
| at
oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:7508)
What's the problem with the scheme above?
Thx
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3853090#3853090
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3853090
-------------------------------------------------------
This SF.Net email is sponsored by:
Sybase ASE Linux Express Edition - download now for FREE
LinuxWorld Reader's Choice Award Winner for best database on Linux.
http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
