-
1. Re: Configuring an Oracle datasource
dkato Jan 3, 2003 2:37 PM (in response to amagno)Hello Alphonsus,
I can't believe none of them helped you..... :)
I'm not using 3.0.4 as we homologated the version 3.0.0 only, though I think it doesn't changed much(about datasources).
If so, I can help you:
1st:you can't use java:/comp/env/jdbc/MyOraclePool because /comp/env/ is most likely the java's root environment, instead you will use java:jdbc/MyOraclePool.
2nd:To use a Pool you have to create a datasource first. Then you have a connection pool embedded to it.
How? In the folder "JBOSS_HOME\docs\examples\jca" you'll find some .xml files as examples to datasources, get "mysql-service.xml" as your example, copy it to your deploy dir and rename to ex.: oracle-service.xml. Edit it configuring the specific settings such as connection URL, DriverClass, UserName and Password. Also replace all entries named "MySqlDS"(about 3) to "jdbc/MyOraclePool"(or any other name that you'll use to access) and you're done.
Review the entire XML to see if there's any other change left to be made and, of course, understand it. ;)
Hope it helps you.
Regards
Diogo -
2. Re: Configuring an Oracle datasource
baillieul Jan 6, 2003 10:24 AM (in response to amagno)Making the datasource work is pretty straight forward. The real issue is that id you are using BLOB, etc, you will not have a very positive experience using the Oracle JDBC drivers. We had good luck with third party drivers, but this was an issue.