[Weenergies]

This is the error I get from my server:

SEVERE: find failed
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials – 2.0 (Build b40-rc (03/21/2007))): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: com.sybase.jdbc3.jdbc.SybSQLException: dbo.css_uct_pss.t_user not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).

Error Code: 208
Call: SELECT UserName, UserDesc, PasswdChangeDate FROM dbo.css_uct_pss.t_user WHERE (UserName = ?)
bind => [w39833]

This is the query that JPA created from:

getEntityManager().createQuery(“select model from TUser model where model.id.userName=’w39833′”).getSingleResult();

This is wrong, the query should be looking at:

SELECT UserName, UserDesc, PasswdChangeDate FROM css_uct_pss.dbo.t_user WHERE (UserName = ?)

Is this a know issue?

My persistence.xml file is ok.

<?xml version="1.0" encoding="UTF-8"?>
<persistence xmlns="http://java.sun.com/xml/ns/persistence"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1.0"
    xsi:schemaLocation="http://java.sun.com/xml/ns/persistence     http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">

    <persistence-unit name="TUserAppPU"
        transaction-type="RESOURCE_LOCAL">
        <provider>
            oracle.toplink.essentials.PersistenceProvider
        </provider>
        <class>com.we.uct.model.TUser</class>
        <class>com.we.uct.model.TUserId</class>
        <properties>
            <property name="toplink.jdbc.driver"
                value="com.sybase.jdbc3.jdbc.SybConnectionPoolDataSource" />
            <property name="toplink.jdbc.url"
                value="jdbc:sybase:Tds:csssd1:7000/css_uct_pss" />
            <property name="toplink.jdbc.user" value="XXXXXXXxX" />
            <property name="toplink.jdbc.password" value="xxxxxxxxx" />
        </properties>
    </persistence-unit>

</persistence>

[Brian Fernandes]

This message has not been recovered.

[Weenergies]

This message has not been recovered.

[Brian Fernandes]

This message has not been recovered.

[Author]

Posts