Jboss 2.4.4 + Oracle 9.2
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