2 Replies Latest reply on Jan 6, 2004 2:00 AM by mtechsrinivas

    what is the difference between oracle-ds.xml and oracle-xa-d

    mtechsrinivas Newbie

       

      "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.