Error: Schema "MARCOS" cannot be resolved for table "GE_FUNCIONARIOS" [message #194193] |
Fri, 08 June 2007 16:43  |
Eclipse User |
|
|
|
- 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>
<!-- other classes -->
<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"?>
<!-- $Id: mssql-ds.xml 61002 2007-02-28 16:13:00Z weston.price@jboss.com $
-->
<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><!-- there's a valid password here --></password>
<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml
(optional) -->
<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
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.03399 seconds