Postgres column does not exist in a call from a facade
up vote
0
down vote
favorite
I am really puzzled. I am trying to run a simple select all query on a postgres table. But, it says "column X does not exist". I copied and pasted the query into the console of my postgres and it worked.
ApplicationConfig threw exception
org.postgresql.util.PSQLException: ERROR: column "requestid" does not exist
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: column "requestid"
does not exist
Error Code: 0
Call: SELECT id, val, requestid FROM mysch.m_table1
The same code and settings work on my local machine. I only get the error on the server machine. I made sure that the names are all lowercase. I also made sure to mention my private schema (myschema) while creating the entity classes. I made sure the postgres driver version on my local machine and server machine are the same. I recreated the databases both on local and server from scratch based on the same script file. I cleared the cache on my glassfish sever. I restarted the server itself, the glassfish on it and also the postgres.
I am just now out of ideas. There is also a similar table in my database for that I don't have a problem. It works just fine.
java postgresql ejb eclipselink glassfish-4
asked Nov 10 at 20:34
Hamed
6101924
add a comment |
up vote
0
down vote
favorite
I am really puzzled. I am trying to run a simple select all query on a postgres table. But, it says "column X does not exist". I copied and pasted the query into the console of my postgres and it worked.
ApplicationConfig threw exception
org.postgresql.util.PSQLException: ERROR: column "requestid" does not exist
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: column "requestid"
does not exist
Error Code: 0
Call: SELECT id, val, requestid FROM mysch.m_table1
The same code and settings work on my local machine. I only get the error on the server machine. I made sure that the names are all lowercase. I also made sure to mention my private schema (myschema) while creating the entity classes. I made sure the postgres driver version on my local machine and server machine are the same. I recreated the databases both on local and server from scratch based on the same script file. I cleared the cache on my glassfish sever. I restarted the server itself, the glassfish on it and also the postgres.
I am just now out of ideas. There is also a similar table in my database for that I don't have a problem. It works just fine.
java postgresql ejb eclipselink glassfish-4
asked Nov 10 at 20:34
Hamed
6101924
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I am really puzzled. I am trying to run a simple select all query on a postgres table. But, it says "column X does not exist". I copied and pasted the query into the console of my postgres and it worked.
ApplicationConfig threw exception
org.postgresql.util.PSQLException: ERROR: column "requestid" does not exist
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: column "requestid"
does not exist
Error Code: 0
Call: SELECT id, val, requestid FROM mysch.m_table1
The same code and settings work on my local machine. I only get the error on the server machine. I made sure that the names are all lowercase. I also made sure to mention my private schema (myschema) while creating the entity classes. I made sure the postgres driver version on my local machine and server machine are the same. I recreated the databases both on local and server from scratch based on the same script file. I cleared the cache on my glassfish sever. I restarted the server itself, the glassfish on it and also the postgres.
I am just now out of ideas. There is also a similar table in my database for that I don't have a problem. It works just fine.
java postgresql ejb eclipselink glassfish-4
asked Nov 10 at 20:34
Hamed
6101924
I am really puzzled. I am trying to run a simple select all query on a postgres table. But, it says "column X does not exist". I copied and pasted the query into the console of my postgres and it worked.
ApplicationConfig threw exception
org.postgresql.util.PSQLException: ERROR: column "requestid" does not exist
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: column "requestid"
does not exist
Error Code: 0
Call: SELECT id, val, requestid FROM mysch.m_table1
The same code and settings work on my local machine. I only get the error on the server machine. I made sure that the names are all lowercase. I also made sure to mention my private schema (myschema) while creating the entity classes. I made sure the postgres driver version on my local machine and server machine are the same. I recreated the databases both on local and server from scratch based on the same script file. I cleared the cache on my glassfish sever. I restarted the server itself, the glassfish on it and also the postgres.
I am just now out of ideas. There is also a similar table in my database for that I don't have a problem. It works just fine.
java postgresql ejb eclipselink glassfish-4
java postgresql ejb eclipselink glassfish-4
asked Nov 10 at 20:34
Hamed
6101924
asked Nov 10 at 20:34
Hamed
6101924
asked Nov 10 at 20:34
Hamed
6101924
asked Nov 10 at 20:34
Hamed
6101924
asked Nov 10 at 20:34
Hamed
6101924
6101924
add a comment |
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53243164%2fpostgres-column-does-not-exist-in-a-call-from-a-facade%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
