2 Replies Latest reply on Oct 28, 2002 8:31 AM by andrea

    Jboss 2.4.4 + Oracle 9.2

    andrea Newbie

      Hi Guys,

      I am using Jboss 2.4.4 on Sun Solaris 8 and Sun JDK 1.3.1_02.

      I Need to connect to a Oracle 9.2 database.

      I have modified the default/jboss.jcml in the following way:


      oracle.jdbc.driver.OracleDriver,org.hsqldb.jdbcDriver

      <!-- Connection factory for the Minerva JDBC resource adapter. This
      points at Sindom2OracleDB database. -->

      Sindom2OracleDB
      JCA:service=RARDeployer

      Minerva JDBC LocalTransaction ResourceAdapter


      ConnectionURL=jdbc:oracle:thin:@cingl0ex:1521:sindom



      MinervaSharedLocalCMFactory

      <!-- See the documentation for the specific connection manager
      implementation you are using for the properties you can set -->

      # Pool type - uncomment to force, otherwise it is the default
      #PoolConfiguration=per-factory

      # Connection pooling properties - see
      # org.jboss.pool.PoolParameters
      MinSize=0
      MaxSize=10
      Blocking=true
      GCEnabled=false
      IdleTimeoutEnabled=false
      InvalidateOnError=false
      TrackLastUsed=false
      GCIntervalMillis=120000
      GCMinIdleMillis=1200000
      IdleTimeoutMillis=1800000
      MaxIdleTimeoutPercent=1.0


      <!-- Principal mapping configuration -->

      org.jboss.resource.security.ManyToOnePrincipalMapping


      userName=sindom1
      password=sindom1



      I am able to connect to Oracle but I catched the following Exception:
      javax.ejb.CreateException: Exception class javax.ejb.EJBException: ORA-00911: invalid character

      at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteCall.java:247)
      at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:223)
      at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:133)
      at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker_Stub.invokeHome(Unknown Source)
      at org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invokeHome(HomeProxy.java:258)
      at org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomeProxy.java:182)
      at $Proxy0.create(Unknown Source)
      at provagui.provagui.initiateBean(provagui.java:224)
      at provagui.provagui.init(provagui.java:52)
      at provagui.provagui.(provagui.java:41)
      at provagui.TestDB1.main(TestDB1.java:23)

      I don't know how to solve this problem.

      Does anyone help me?

      Best Regards,

      Andrea