Hello Lee,
PostgreSQL will convert everything that is not delimited to lower case -
which is probably why it says "tvdacad001" can't be found when your
entity defines it as "TVDACAD001". You mention that it is defined in
the db as "TVDACAD001", did you delimit the table name when you created
it? If so, it must also be delimited when used. Try changing the
annotation to @Table(name = "\"TVDACAD001\"")
If that doesn't help, I'd recommend turning setting the logging level to
fine or finest to see the statements that is causing the error, and see
if you can access the table using the same user account the connection
pool is.
Best Regards,
Chris
Alea Management & Technology Solutions wrote:
> Hey,
>
> I am new to EJB3.0 and I am creating a simple EJB example
> using GlassFish and PostgreSQL.
>
> I am getting the org.postgre.util.PSQLException:ERROR: relation
> "tvdacad001" does not exist
>
> The database name "tvdacad001" is not written in lowercase anywhere.
> Inside Postgre database the database table
> is TVDACAD001 so in the entity class Company.java too.
>
> Please, find attached:
> . A SessionBean called (CompanyBean)
> . An Entity called (Company)
>
> Any help would be great.
>
> Thanks much,
>
> --
> Lee