I'm trying to access a datasource in an EJB deployed on JBoss 3.2, Tomcat 4.1.24. The Java environment is 1.3.1_04. The database is Sybase ASE 12.5 and I am using jConnect 5.5 as the JDBC driver.
When I make a call to execute statement I get the following response. Any ideas what is wrong. The code works happily on a number of other app servers. Somewhere along the line the table name is being converted to uppercase and the database name changed from RMPC to DBO.
java.sql.SQLException: Table not found: DBO.DBO.UPRF_IDENTIFIERS in statement [select ENCR_SYBASE from RMPC.dbo.UPRF_IDENTIFIERS where UPRF='johnsong']