Eclipse Community Forums: Dali » Error: Schema "MARCOS" cannot be resolved for table "GE

Help

Home

Home » Eclipse Projects » Dali » 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 #434451]

Fri, 08 June 2007 14:23

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

Breadcrumbs

Sign up to our Newsletter