-
1. Re: oracle-service.xml in 3.2.x
jonlee Jul 1, 2003 5:52 AM (in response to kstogian)The naming nomenclature for datasources has changed from 3.2.x. The configuration is also simpler. A datasource must end with -ds.xml so that JBoss realizes it is a datasource configuration rather than an MBean type configuration. Use the oracle-ds.xml from the examples as your new template. It goes in your deploy directory as you would normally expect.
Hope it helps. -
2. Re: oracle-service.xml in 3.2.x
kstogian Jul 2, 2003 4:37 AM (in response to kstogian)Thanks jonlee,
the oracle-ds.xml works fine. -
3. Re: oracle-service.xml in 3.2.x
arupsarkar Jul 21, 2003 1:24 PM (in response to kstogian)Hi,
I have a similar problem as you have, if you have resolved it could you please help me. I have configured oracle-ds.xml, and put it is the jboss_installation_dir/server/default/deploy, when I am trying to connect via ejb I am getting the following error.
"15:14:05,566 INFO [STDOUT] javax.ejb.EJBException: Unable to connect to database. Table not found", I have the following code for look up.
try {
InitialContext ic = new InitialContext();
DataSource ds = (DataSource) ic.lookup("java:comp/env/jdbc/OracleDS");
con = ds.getConnection();
String selectStatement =
"select row_id, last_name, fst_name" +
" from siebel.s_contact where last_name = ? ";
PreparedStatement prepStmt = con.prepareStatement(selectStatement);
prepStmt.setString(1, "Rubinetti");
ResultSet rs = prepStmt.executeQuery();
if (rs.next()) {
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
System.out.println(rs.getString(3));
}
regards
arup
arupsarkar@yahoo.com -
4. Re: oracle-service.xml in 3.2.x
frito Jul 23, 2003 3:21 AM (in response to kstogian)Looks like the table "siebel.s_contact" was not found.
Greetings,
Frito -
5. Re: oracle-service.xml in 3.2.x
arupsarkar Jul 24, 2003 3:02 PM (in response to kstogian)Frito:
The table is there I checked it, actually I am not being able to connect to the database.
""15:14:05,566 INFO [STDOUT] javax.ejb.EJBException: Unable to connect to database. Table not found",
Regards
Arup -
6. Re: oracle-service.xml in 3.2.x
frito Jul 25, 2003 3:53 AM (in response to kstogian)But still looks like a database/network problem, since you can lookup the datasource and get the connection.
Greetings,
Frito -
7. Re: oracle-service.xml in 3.2.x
nusa Jul 25, 2003 2:04 PM (in response to kstogian)Try to change from this :
DataSource ds = (DataSource) ic.lookup("java:comp/env/jdbc/OracleDS");
into this :
DataSource ds = (DataSource) ic.lookup("java:/OracleDS");
Have a look as well in the testsuite directory,where you have a lot of examples.
nusa