0 Replies Latest reply on May 14, 2003 2:21 AM by glynj

    Sybase table not found error

    glynj Newbie

      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']