Oracle9i DataSource Configuration

[fr92_furtif]

Hi,

I have read some threads about DataSource Configuration but still could not solve my probleme ( I hope a classic one ).

My oracle-service.xml file :


OracleDbRealm
java:/TransactionManager
<depends optional-attribute-name="ManagedConnectionFactoryName">

OracleDS


<config-property name="ConnectionURL" type="java.lang.String">jdbc:oracle:thin:@localhost:1521:dbtest</config-property>
<config-property name="DriverClass" type="java.lang.String">oracle.jdbc.driver.OracleDriver</config-property>
<config-property name="UserName" type="java.lang.String">test</config-property>
<config-property name="Password" type="java.lang.String">test</config-property>


<depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper


<depends optional-attribute-name="ManagedConnectionPool">

0
5
5000
15
ByContainer


<depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager
<depends optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager
jboss.jca:service=RARDeployer



My addition in the login-config.xml file :
<application-policy name = "OracleDbRealm">

<login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule" flag = "required">
<module-option name = "principal">dev</module-option>
<module-option name = "userName">dev</module-option>
<module-option name = "password">dev</module-option>
<module-option name = "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=OracleDS</module-option>
</login-module>

</application-policy>

I copy the classes12.jar in server/lib and add the jar to the server classpath.

In the JBoss Management I have :
service=LocalTxPool,name=OracleDS ( status = STARTED )
service=LocalTxDS,name=OracleDS
service=LocalTxCM,name=OracleDS ( status = FAILED )
and nothing in Jndi View.

Finally my error :
At startup :
The MBeans waiting for MBeans thing.
When I try to start the LocalTxCM from console :
javax.naming.NameNotFoundException: TransactionManager not bound

Last detail, I have my own Server Environnement.

If someone could help, thanks in advance.

[chgrimm]

i have never used the oracle realm stuff, but my config to access oracle 9i looks like this:





<depends optional-attribute-name="ManagedConnectionFactoryName">
<!--embedded mbean-->


WORK_DS



<config-property name="ConnectionURL" type="java.lang.String">jdbc:oracle:thin:@myserver:myport:myservice</config-property>
<config-property name="DriverClass" type="java.lang.String">oracle.jdbc.driver.OracleDriver</config-property>
<config-property name="UserName" type="java.lang.String">...myuser...</config-property>
<config-property name="Password" type="java.lang.String">...mypassword...</config-property>




<!--Below here are advanced properties -->
<!--hack-->
<depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper



<depends optional-attribute-name="ManagedConnectionPool">
<!--embedded mbean-->


0
50
5000
15
ByContainer



<depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager

<depends optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager

java:/TransactionManager

<!--make the rar deploy! hack till better deployment-->
jboss.jca:service=RARDeployer




ps:

be aware to use the newest oracle classes12.zip and put it in the server/lib dir

elder versions of classes12.zip that worked well with 8.x do not work anymore with 9.x

[fr92_furtif]

Hi,

Thank you very much for your answer but same bad result for
me.

How can I be sure that it's not the fault of my Database Server ? My listener is running and registered my database instance, my login is ok in oracle-service.xml; but now I would like to be sure that it's just a configuration problem in JBoss and not a database setup problem.

[fr92_furtif]

Hi,

Thank you very much for your answer but same bad result for
me.

How can I be sure that it's not the fault of my Database Server ? My listener is running and registered my database instance, my login is ok in oracle-service.xml; but now I would like to be sure that it's just a configuration problem in JBoss and not a database setup problem.

[fr92_furtif]

Hi,

Thank you very much for your answer but same bad result for
me.

How can I be sure that it's not the fault of my Database Server ? My listener is running and registered my database instance, my login is ok in oracle-service.xml; but now I would like to be sure that it's just a configuration problem in JBoss and not a database setup problem.

[fr92_furtif]

Hi,

Thank you very much for your answer but same bad result for
me.

How can I be sure that it's not the fault of my Database Server ? My listener is running and registered my database instance, my login is ok in oracle-service.xml; but now I would like to be sure that it's just a configuration problem in JBoss and not a database setup problem.

[fr92_furtif]

Sorry for all this, I didn't see my reply just after its addition so I keep trying until feed up.

[chgrimm]

to find out if it's the fault of your sserver, you may
create a little test program accessing your database directly via jdbc
with the same DriverClass, ConnectionURL, UserName and Password.

run the testprogram in the same enviroment as the jboss server