Subject Re: [Firebird-Java] Firebird JPA Generator
Author Csaba Ragasits
Thank the answer.

I've following toplink settings (persistence.xml):

<?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="PinFaxModelPU" transaction-type="RESOURCE_LOCAL">
<provider>oracle.toplink.essentials.PersistenceProvider</provider>
<class>com.sbb.pinfaxmodel.Ugyfel</class>
<class>com.sbb.pinfaxmodel.Naplo</class>
<properties>
<property name="toplink.jdbc.user" value="sysdba"/>
<property name="toplink.jdbc.password" value="masterkey"/>
<property name="toplink.jdbc.url"
value="jdbc:firebirdsql://192.168.0.11:3050/home/Firebird/PINFAX.FDB"/>
<property name="toplink.jdbc.driver"
value="org.firebirdsql.jdbc.FBDriver"/>
</properties>
</persistence-unit>
</persistence>

How can I set the dialect?

Thaks,
Csaba







2007/11/27, Wolfgang Schindler <schindler@...>:
> Hi there,
>
> you got a problem with the Firebird database dialect setting. This can be 1 or
> 3. Depending on this value you can use different kinds of names for
> tables,columns and other objects in the firebird database.
> Suppose you should look for a matching setting in the toplink connection
> components and this will help you with your problem.
>
> Bye
> Wolf
>
> Am Dienstag, 27. November 2007 14:34:29 schrieb Csaba Ragasits:
> > Hello,
> >
> > I would like to manage a table with JPA (NB6RC2,
> > GlassFishV2,Firebird1.5x, Jaybird-2.1.1):
> >
> > public class Ugyfel implements Serializable {
> > private static final long serialVersionUID = 1L;
> > @Id
> > @SequenceGenerator( name = "GEN_UGYFEL", sequenceName = "GEN_UGYFEL" )
> > @GeneratedValue( strategy = GenerationType.AUTO, generator =
> > "GEN_UGYFEL" ) @Column(name = "ID", nullable = false)
> > private Short id;
> > @Column(name = "BOSSKOD")
> > …
> >
> > When I want add a new record I've a following error message:
> >
> > [TopLink Info]: 2007.11.27 10:54:46.557--Not able to detect platform
> > for vendor name [Firebird 1.5-LI-V1.5.4.4910 Firebird 1.5/tcp
> > (fscmnet)/P10]. Defaulting to
> > [oracle.toplink.essentials.platform.database.DatabasePlatform]. The
> > database dialect used may not match with the database you are using.
> > Please explicitly provide a platform using property
> > toplink.platform.class.name.
> > PWC2775: Session attribute event listener threw exception
> > javax.persistence.PersistenceException: Exception [TOPLINK-7144]
> > (Oracle TopLink Essentials - 2.0 (Build b58g-fcs (09/07/2007))):
> > oracle.toplink.essentials.exceptions.ValidationException
> > Exception Description: GEN_UGYFEL: platform DatabasePlatform doesn't
> > support NativeSequence.
> > at
> > oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.deploy(E
> >ntityManagerSetupImpl.java:239) at
> > oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.g
> >etServerSession(EntityManagerFactoryImpl.java:93) at
> > oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.c
> >reateEntityManagerImpl(EntityManagerFactoryImpl.java:126)
> >
> > Have You got any ideas, how can I solve this problem?
> >
> > Thanks,
> > Csaba
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
>
>
> --
> Wolfgang Schindler
> Schmalfelden 1b
> 74575 Schrozberg
>
>
> Tel..: +49 7935 7265176
> Mobil: +49 177 3607966
> Fax..: +49 7935 7265177
> Mail.: schindler@...
>
>
>
> Yahoo! Groups Links
>
>
>
>