I'm using the Europa release of Eclipse with Derby 10.3. I installed the SUN J2EE which uses the toplink essentials.
I get a "Schema does not exist" exception when trying to execute a SQL query (which is generated by the EJB3 tooling):
select .... from myschema.tableA where ....
myschema is the name of the schema.
Well the query runs fine in Derby. But when running through EJB3 I get the message "myschema does not exist".
I have the following in my persitence.xml file:
<property name="toplink.logging.level" value="FINEST"/>
<property name="toplink.jdbc.driver" value="org.apache.derby.jdbc.ClientDriver"/>
<property name="toplink.jdbc.url" value="jdbc:derby://localhost:1527/banktpz;create=true"/>
I've also tried adding a user which has the same name of the schema but get the same error:
<property name="toplink.logging.level" value="FINEST"/>
<property name="toplink.jdbc.driver" value="org.apache.derby.jdbc.ClientDriver"/>
<property name="toplink.jdbc.url" value="jdbc:derby://localhost:1527/banktpz;create=true"/>
<property name="toplink.jdbc.user" value="myschema"/>
<property name="toplink.jdbc.password" value="password"/>
[Message sent by forum member 'sergiohm' (sergiohm)]
http://forums.java.net/jive/thread.jspa?messageID=248487