Eclipse Community Forums: ServerTools (WTP) » Error: Schema "MARCOS" cannot be resolved for table "GE

Help

Home

Home » Language IDEs » ServerTools (WTP) » Error: Schema "MARCOS" cannot be resolved for table "GE_FUNCIONARIOS"

Show: Today's Messages :: Show Polls :: Message Navigator

Error: Schema "MARCOS" cannot be resolved for table "GE_FUNCIONARIOS" [message #194193]

Fri, 08 June 2007 16:43

Marcos

Messages: 68
Registered: July 2009

Member

- Eclipse 3.3RC2 (Build id: I20070525-1350)
- WTP 2.0RC2 (complete)
- Java 5 Update 11
- JBoss 4.2.0GA

Hello, everybody!
I'm getting the following error at design time in an EJB 3.0 project:

Schema "MARCOS" cannot be resolved for table "GE_FUNCIONARIOS"

===========================================================

This table, GE_FUNCIONARIOS, exists in my database. This is the content of
my
persistence.xml file:

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="1.0" xmlns="http://java.sun.com/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
<persistence-unit name="laboratorio-informatica">
<provider>org.hibernate.ejb.HibernatePersistence</provider >
<jta-data-source>java:/LaboratorioInformaticaDS</jta-data-source >
<class>br.urca.www.laboratorioinformatica.entidade.Funcionario </class>

<properties>
<property name="hibernate.dialect"
value="org.hibernate.dialect.HSQLDialect" />
<property name="hibernate.hbm2ddl.auto" value="create-drop" />
</properties>
</persistence-unit>
</persistence>

===========================================================

And this is the configuration of the datasource referenced in the element
<jta-data-source> in the file
C:\jboss-4.2.0.GA\server\default\deploy\laboratorio-informat ica-ds.xml:

<?xml version="1.0" encoding="UTF-8"?>



<datasources>
<local-tx-datasource>
<jndi-name>LaboratorioInformaticaDS</jndi-name>

<connection-url>jdbc:sqlserver://SERVDEG;databaseName=DBTESEUS</connection-url>

<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class >
<user-name>MARCOS</user-name>
<password></password>


<metadata>
<type-mapping>MS SQLSERVER2000</type-mapping>
</metadata>
</local-tx-datasource>

</datasources>

This datasource configuration is valid as the server doesn't report any
problem
about it when it is started.

===========================================================

This is my mapped class:

package br.urca.www.laboratorioinformatica.entidade;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name = "GE_FUNCIONARIOS") // Error message is here
public class Funcionario
{
private String fMatricula;

@Id
@Column(name = "MATRICULA")
public String getMatricula()
{
return fMatricula;
}

public void setMatricula(String matricula)
{
fMatricula = matricula;
}
}

===========================================================

So, I would like to know what I'm doing wrong to get this error and how
I solve it.

Thank you.

Marcos

Report message to a moderator

Re: Error: Schema "MARCOS" cannot be resolved for table "GE_FUNCIONARIOS" [message #194209 is a reply to message #194193]

Sat, 09 June 2007 12:12

Eclipse User

Originally posted by: chrisjames64.hotmail.co.uk

I was recently playing with a JPA project and found I had to add the
following into the META-INF\orm.xml...

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

<persistence-unit-metadata>
<persistence-unit-defaults>
<schema>CUSTSCH</schema>
</persistence-unit-defaults>
</persistence-unit-metadata>

</entity-mappings>

An alternative would be to use the schema attribute of the @Table
annotation in the persistent class, but this would be inflexible for
deployments to different environments. e.g

@Entity
@Table(name="", schema="")
public class Customer implements Serializable {
...etc...
}

Hope this helps
Chris

Report message to a moderator

Re: Error: Schema "MARCOS" cannot be resolved for table "GE_FUNCIONARIOS" [message #194264 is a reply to message #194209]

Mon, 11 June 2007 13:39

Marcos

Messages: 68
Registered: July 2009

Member

Hello, Chris.

I did what you said, but unfortunately it didn't work to me. I don't know
if it is because my project is an EJB Project, not a JPA Project. But I
think that this shouldn't matter. At least that's what I think.

Marcos

Chris wrote:
> I was recently playing with a JPA project and found I had to add the
> following into the META-INForm.xml...

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

> <persistence-unit-metadata>
> <persistence-unit-defaults>
> <schema>CUSTSCH</schema>
> </persistence-unit-defaults>
> </persistence-unit-metadata>

> </entity-mappings>

> An alternative would be to use the schema attribute of the @Table
> annotation in the persistent class, but this would be inflexible for
> deployments to different environments. e.g

> @Entity
> @Table(name="", schema="")
> public class Customer implements Serializable {
> ...etc...
> }

> Hope this helps
> Chris

Report message to a moderator

Previous Topic:	Database default schema handling
Next Topic:	Unable to Export as .aar

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 20:52:23 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter