what is the difference between oracle-ds.xml and oracle-xa-d
"mtechsrinivas" wrote:
Hello
Xperts,
Please can you tell me what is the difference between oracle-ds.xml and
oracle-xa-ds.xml.
When should we first one and when should we use second one?
I am facing problem while inserting CLOB fields from my BMP entity bean into database.
The error is
16:11:21,250 ERROR [STDERR] java.sql.SQLException: ORA-22922: nonexistent LOB va
lue
16:11:21,281 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlExceptio
n(DBError.java:134)
16:11:21,312 ERROR [STDERR] at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.j
ava:289)
16:11:21,312 ERROR [STDERR] at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579
)
16:11:21,312 ERROR [STDERR] at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Pro
tocol.java:1894)
16:11:21,312 ERROR [STDERR] at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFet
ch(TTC7Protocol.java:1094)
16:11:21,312 ERROR [STDERR] at oracle.jdbc.driver.OracleStatement.executeNon
Query(OracleStatement.java:2132)
16:11:21,328 ERROR [STDERR] at oracle.jdbc.driver.OracleStatement.doExecuteO
ther(OracleStatement.java:2015)
16:11:21,328 ERROR [STDERR] at oracle.jdbc.driver.OracleStatement.doExecuteW
ithTimeout(OracleStatement.java:2877)
16:11:21,328 ERROR [STDERR] at oracle.jdbc.driver.OraclePreparedStatement.ex
ecuteUpdate(OraclePreparedStatement.java:608)
16:11:21,343 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedPrepar
edStatement.executeUpdate(WrappedPreparedStatement.java:308)
16:11:21,343 ERROR [STDERR] at scs.database.eform.EformDBBean.ejbCreate(Efor
mDBBean.java:261)
16:11:21,343 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(
Native Method)
16:11:21,343 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(N
ativeMethodAccessorImpl.java:39)
16:11:21,343 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invo
ke(DelegatingMethodAccessorImpl.java:25)
16:11:21,343 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:3
24)
16:11:21,343 ERROR [STDERR] at org.jboss.ejb.plugins.BMPPersistenceManager.c
reateEntity(BMPPersistenceManager.java:196)
16:11:21,343 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedCo
nnectionInterceptor.createEntity(CachedConnectionInterceptor.java:270)
16:11:21,359 ERROR [STDERR] at org.jboss.ejb.EntityContainer.createHome(Enti
tyContainer.java:726)
16:11:21,359 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(
Native Method)
16:11:21,359 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(N
ativeMethodAccessorImpl.java:39)
16:11:21,359 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invo
ke(DelegatingMethodAccessorImpl.java:25)
16:11:21,359 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:3
24)
16:11:21,359 ERROR [STDERR] at org.jboss.ejb.EntityContainer$ContainerInterc
eptor.invokeHome(EntityContainer.java:1006)
16:11:21,375 ERROR [STDERR] at org.jboss.ejb.plugins.EntitySynchronizationIn
terceptor.invokeHome(EntitySynchronizationInterceptor.java:188)
16:11:21,375 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedCo
nnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:215)
16:11:21,375 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractInterceptor.inv
okeHome(AbstractInterceptor.java:88)
16:11:21,375 ERROR [STDERR] at org.jboss.ejb.plugins.EntityInstanceIntercept
or.invokeHome(EntityInstanceInterceptor.java:91)
16:11:21,375 ERROR [STDERR] at org.jboss.ejb.plugins.EntityLockInterceptor.i
nvokeHome(EntityLockInterceptor.java:61)
16:11:21,390 ERROR [STDERR] at org.jboss.ejb.plugins.EntityCreationIntercept
or.invokeHome(EntityCreationInterceptor.java:28)
16:11:21,390 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractTxInterceptor.i
nvokeNext(AbstractTxInterceptor.java:88)
16:11:21,390 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.runWit
hTransactions(TxInterceptorCMT.java:243)
16:11:21,390 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke
Home(TxInterceptorCMT.java:74)
16:11:21,390 ERROR [STDERR] at org.jboss.ejb.plugins.SecurityInterceptor.inv
okeHome(SecurityInterceptor.java:92)
16:11:21,390 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.invokeHo
me(LogInterceptor.java:120)
16:11:21,406 ERROR [STDERR] at org.jboss.ejb.plugins.ProxyFactoryFinderInter
ceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93)
16:11:21,406 ERROR [STDERR] at org.jboss.ejb.EntityContainer.internalInvokeH
ome(EntityContainer.java:478)
16:11:21,406 ERROR [STDERR] at org.jboss.ejb.Container.invoke(Container.java
:720)
16:11:21,406 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(
Native Method)
16:11:21,406 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(N
ativeMethodAccessorImpl.java:39)
16:11:21,421 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invo
ke(DelegatingMethodAccessorImpl.java:25)
16:11:21,421 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:3
24)
16:11:21,421 ERROR [STDERR] at org.jboss.mx.capability.ReflectedMBeanDispatc
her.invoke(ReflectedMBeanDispatcher.java:284)
16:11:21,421 ERROR [STDERR] at org.jboss.mx.server.MBeanServerImpl.invoke(MB
eanServerImpl.java:550)
16:11:21,421 ERROR [STDERR] at org.jboss.invocation.jrmp.server.JRMPInvoker.
invoke(JRMPInvoker.java:362)
16:11:21,421 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor121.invoke
(Unknown Source)
16:11:21,437 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invo
ke(DelegatingMethodAccessorImpl.java:25)
16:11:21,437 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:3
24)
16:11:21,437 ERROR [STDERR] at sun.rmi.server.UnicastServerRef.dispatch(Unic
astServerRef.java:261)
16:11:21,437 ERROR [STDERR] at sun.rmi.transport.Transport$1.run(Transport.j
ava:148)
16:11:21,437 ERROR [STDERR] at java.security.AccessController.doPrivileged(N
ative Method)
16:11:21,453 ERROR [STDERR] at sun.rmi.transport.Transport.serviceCall(Trans
port.java:144)
16:11:21,453 ERROR [STDERR] at sun.rmi.transport.tcp.TCPTransport.handleMess
ages(TCPTransport.java:460)
16:11:21,453 ERROR [STDERR] at sun.rmi.transport.tcp.TCPTransport$Connection
Handler.run(TCPTransport.java:701)
16:11:21,453 ERROR [STDERR] at java.lang.Thread.run(Thread.java:536)
I am using java:\OracleDS to get connection from the database.
But if is use normal connection
ie by using these statements
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
dbConn =
DriverManager.getConnection ("jdbc:oracle:thin:@localhost:1521:my", "scott", "tiger");
The clob is getting inserted.
Can any one tell me how to configure Oracle-ds.xml so that the CLOB fields are inserted.
