[dtp-connect-dev] Eclipse jee ganymede 3.4 RC4 >> generic jdbc firebird

["Delmar Wichnieski" <delmar.delmar@xxxxxxxxx>]

Hi friends

 

My name is Delmar, I'm from Brazil and my english is not perfect

 

I'm testing Eclipse jee ganymede 3.4 RC4

 

I created one project Java EE - Enterprise Application Project and configured:

   application.xml

   Data Source Explorer JDBC with Firebird connection using Jaybird-2.1.3JDK_1.3

 

   Connection open but don't show no schema

 

I created one second projetc JPA - JPA Project and configured:

   Persistence.xml

   one class denominated BAIRRO

 

I get 3 erros

Schema "null" cannot be resolved for table "BAIRRO"

Column "CODIGO" cannot be resolved

Schema "null" cannot be resolved for table "BAIRRO"

 

Because  I'm using Firebird and there are no default schema and no tables are displayed by DSE how I could may contorn the problem?

 

Delmar Wichnieski

 

 

---------------------------- Source Code Application.xml ---------------------------------------

 

<?xml version="1.0" encoding="UTF-8"?>
<application xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:application="http://java.sun.com/xml/ns/javaee/application_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/application_5.xsd" id="Application_ID" version="5">
  <display-name>SushiBoss</display-name>
  <module>
    <ejb>SushiJPA.jar</ejb>
  </module>
  <module>
    <web>
      <web-uri>SushiWAR.war</web-uri>
      <context-root>SushiWAR</context-root>
    </web>
  </module>
</application>

 

 

 

---------------------------- Source Code Persistence.xml ---------------------------------------

 

<?xml version="1.0" encoding="UTF-8"?>
<persistence xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1.0" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
    <persistence-unit name="pu">
        <provider>oracle.toplink.essentials.PersistenceProvider</provider>
        <class>entity.BAIRRO</class>
        <properties>
            <property name="toplink.jdbc.driver" value="org.firebirdsql.jdbc.FBDriver"/>
            <property name="toplink.jdbc.url" value="jdbc:firebirdsql:localhost:C:\Arquivos de programas\webapps\SushiBoss\tabela\SUSHIBAR.FDB"/>
            <property name="toplink.jdbc.user" value="SYSDBA"/>
            <property name="toplink.jdbc.password" value="A"/>
            <property name="toplink.logging.level" value="INFO"/>
        </properties>
    </persistence-unit>
</persistence>

 

 

 

---------------------------- Source Code BAIRRO ---------------------------------------

 

package entity;

 

import java.io.Serializable;

 

import javax.persistence.Entity;
import javax.persistence.Id;

 

@Entity
public class BAIRRO implements Serializable {

 

 private static final long serialVersionUID = 1L;

 

 @Id
 private long CODIGO;
 private String NOME;

 

 public long getCODIGO() {
  return CODIGO;
 }

 

 public void setCODIGO(int codigo) {
  CODIGO = codigo;
 }

 

 public String getNOME() {
  return NOME;
 }

 

 public void setNOME(String nome) {
  NOME = nome;
 }

 

}