Message

I am an instructor who tries out = Derby with ejb=20 (and jsf).

A little example:

package = be.timvw.model;
import javax.ejb.*;

@Entity
public class Person {
   private int=20 personId;
   = private=20 String lastname;
  =20 private String surname;
public Person() {lastname =3D = surname =3D=20 "";}

@Id(generate =3D=20 GeneratorType.AUTO)// GeneratorType.AUTO gives problems = with=20 Derby
public int getPersonId() {return personId;}
public = void=20 setPersonId(int personId) {this.personId =3D = personId;}

public String getLastname() {return = lastname;}
public void setLastname(String lastname) = {this.lastname =3D=20 lastname;}

public String getSurname() {return=20 surname;}
public void setSurname(String surname) {this.surname = =3D=20 surname; }}

I get the following error: =

org.apache.derby.client.am.SqlException: Syntax = error:=20 Encountered ")" at line 2, column = 1.

If I delete "(generate =3D=20 GeneratorType.AUTO)", I don't get this error. I tried other=20 GeneratorType.IDENTITY : not supported by Derby. Derby has a sort of = 'auto_increment' like mysql : = CREATE TABLE foo = (ID INT NOT=20 NULL PRIMARY KEY GENERATED ALWAYS AS IDENTITY, .....)

I'm working with Resin = 3.0.14, latest version of = derby.

web.xml:

<web-app>

<database>
  =20 = <jndi-name>jdbc/pgsql</jndi-name>
  =20 <driver>
      =20 = <type>org.apache.derby.jdbc.ClientDriver</type>
       <url>jdbc:derby://localhost:1527/pag8;create=3Dtrue;user=3DAPP;p= assword=3DAPP;</url>
       <user>APP</user>
      =20 <password>APP</password>
   =20 </driver>
</database>

<ejb-server = data-source=3D"jdbc/pgsql"=20 create-database-schema=3D"true">
       &nbs= p;      =20 <bean type=3D"be.timvw.model.Person"/> =
</ejb-server>=20 ....

Who can give a hint? = Thanks

Luc

Subject: Re: FW: ejb and=20 derby

If you = can run=20 with Derby property, = derby.language.logStatementText=3Dtrue, it would=20 show the SQL statement that is getting generated. I suspect that = may have=20 a syntax error. You just need to have that one line (added) to = your=20 derby.properties file.

Satheesh

Thank you, I did = that: but I=20 got internal call's from Derby (only useful for the derby = developpers I=20 suppose):

Server is ready to accept connections = on port=20 1527.

Connection number: 1.

----------------------------------------------------------------=

2005-12-03 11:40:33.750 = GMT:

Booting Derby version The Apache = Software=20 Foundation - Apache Derby - 10.1.2.1 - (330608): instance=20 c013800d-0107-f06c-5045-fffff52e9fdf

on database directory=20 X:\internetprogrammatie\data\derby\pag8

Database Class Loader started -=20 derby.database.classpath=3D''

2005-12-03 11:40:34.359 GMT=20 Thread[DRDAConnThread_2,5,main] (XID =3D 1785), (SESSIONID =3D 0), = (DATABASE =3D=20 pag8), (DRDAID =3D {1}), Committing

2005-12-03 11:40:34.359 GMT=20 Thread[DRDAConnThread_2,5,main] (XID =3D 1785), (SESSIONID =3D 0), = (DATABASE =3D=20 pag8), (DRDAID =3D {1}), Committing

2005-12-03 11:40:36.609 GMT=20 Thread[DRDAConnThread_2,5,main] (XID =3D 1786), (SESSIONID =3D 0), = (DATABASE =3D=20 pag8), (DRDAID =3D NF000001.G56A-666250136264089174{1}), Begin = compiling=20 prepared statement: SELECT 1 FROM Person o WHERE 1=3D0 :End = prepared=20 statement

2005-12-03 11:40:37.406 GMT=20 Thread[DRDAConnThread_2,5,main] (XID =3D 1786), (SESSIONID =3D 0), = (DATABASE =3D=20 pag8), (DRDAID =3D NF000001.G56A-666250136264089174{1}), End = compiling=20 prepared statement: SELECT 1 FROM Person o WHERE 1=3D0 :End = prepared=20 statement

2005-12-03 11:40:37.625 GMT=20 Thread[DRDAConnThread_2,5,main] (XID =3D 1786), (SESSIONID =3D 0), = (DATABASE =3D=20 pag8), (DRDAID =3D NF000001.G56A-666250136264089174{1}), Executing = prepared=20 statement: SELECT 1 FROM Person o WHERE 1=3D0 :End prepared=20 statement

2005-12-03 11:40:37.671 GMT=20 Thread[DRDAConnThread_2,5,main] (XID =3D 1786), (SESSIONID =3D 0), = (DATABASE =3D=20 pag8), (DRDAID =3D NF000001.G56A-666250136264089174{1}),=20 Committing

2005-12-03 11:40:37.671 GMT=20 Thread[DRDAConnThread_2,5,main] (XID =3D 1786), (SESSIONID =3D 0), = (DATABASE =3D=20 pag8), (DRDAID =3D NF000001.G56A-666250136264089174{1}), Executing = prepared=20 statement: SELECT 1 FROM Person o WHERE 1=3D0 :End prepared=20 statement

2005-12-03 11:40:37.671 GMT=20 Thread[DRDAConnThread_2,5,main] (XID =3D 1786), (SESSIONID =3D 0), = (DATABASE =3D=20 pag8), (DRDAID =3D NF000001.G56A-666250136264089174{1}),=20 Committing

2005-12-03 11:40:37.687 GMT=20 Thread[DRDAConnThread_2,5,main] (XID =3D 1786), (SESSIONID =3D 0), = (DATABASE =3D=20 pag8), (DRDAID =3D NF000001.G56A-666250136264089174{1}), Begin = compiling=20 prepared statement: SELECT ID FROM Person WHERE 1=3D0 :End = prepared=20 statement

2005-12-03 11:40:37.687 GMT=20 Thread[DRDAConnThread_2,5,main] (XID =3D 1786), (SESSIONID =3D 0), = (DATABASE =3D=20 pag8), (DRDAID =3D NF000001.G56A-666250136264089174{1}), End = compiling=20 prepared statement: SELECT ID FROM Person WHERE 1=3D0 :End = prepared=20 statement

2005-12-03 11:40:37.703 GMT=20 Thread[DRDAConnThread_2,5,main] (XID =3D 1786), (SESSIONID =3D 0), = (DATABASE =3D=20 pag8), (DRDAID =3D NF000001.G56A-666250136264089174{1}), Executing = prepared=20 statement: SELECT ID FROM Person WHERE 1=3D0 :End prepared=20 statement

2005-12-03 11:40:37.703 GMT=20 Thread[DRDAConnThread_2,5,main] (XID =3D 1786), (SESSIONID =3D 0), = (DATABASE =3D=20 pag8), (DRDAID =3D NF000001.G56A-666250136264089174{1}),=20 Committing

2005-12-03 11:40:37.703 GMT=20 Thread[DRDAConnThread_2,5,main] (XID =3D 1786), (SESSIONID =3D 0), = (DATABASE =3D=20 pag8), (DRDAID =3D NF000001.G56A-666250136264089174{1}), Begin = compiling=20 prepared statement: SELECT lastname FROM Person WHERE 1=3D0 :End = prepared=20 statement

2005-12-03 11:40:37.718 GMT=20 Thread[DRDAConnThread_2,5,main] (XID =3D 1786), (SESSIONID =3D 0), = (DATABASE =3D=20 pag8), (DRDAID =3D NF000001.G56A-666250136264089174{1}), End = compiling=20 prepared statement: SELECT lastname FROM Person WHERE 1=3D0 :End = prepared=20 statement

2005-12-03 11:40:37.734 GMT=20 Thread[DRDAConnThread_2,5,main] (XID =3D 1786), (SESSIONID =3D 0), = (DATABASE =3D=20 pag8), (DRDAID =3D NF000001.G56A-666250136264089174{1}), Executing = prepared=20 statement: SELECT lastname FROM Person WHERE 1=3D0 :End prepared=20 statement

2005-12-03 11:40:37.734 GMT=20 Thread[DRDAConnThread_2,5,main] (XID =3D 1786), (SESSIONID =3D 0), = (DATABASE =3D=20 pag8), (DRDAID =3D NF000001.G56A-666250136264089174{1}),=20 Committing

2005-12-03 11:40:37.734 GMT=20 Thread[DRDAConnThread_2,5,main] (XID =3D 1786), (SESSIONID =3D 0), = (DATABASE =3D=20 pag8), (DRDAID =3D NF000001.G56A-666250136264089174{1}), Begin = compiling=20 prepared statement: SELECT surname FROM Person WHERE 1=3D0 :End = prepared=20 statement

2005-12-03 11:40:37.734 GMT=20 Thread[DRDAConnThread_2,5,main] (XID =3D 1786), (SESSIONID =3D 0), = (DATABASE =3D=20 pag8), (DRDAID =3D NF000001.G56A-666250136264089174{1}), End = compiling=20 prepared statement: SELECT surname FROM Person WHERE 1=3D0 :End = prepared=20 statement

2005-12-03 11:40:37.750 GMT=20 Thread[DRDAConnThread_2,5,main] (XID =3D 1786), (SESSIONID =3D 0), = (DATABASE =3D=20 pag8), (DRDAID =3D NF000001.G56A-666250136264089174{1}), Executing = prepared=20 statement: SELECT surname FROM Person WHERE 1=3D0 :End prepared=20 statement

2005-12-03 11:40:37.750 GMT=20 Thread[DRDAConnThread_2,5,main] (XID =3D 1786), (SESSIONID =3D 0), = (DATABASE =3D=20 pag8), (DRDAID =3D NF000001.G56A-666250136264089174{1}),=20 Committing

2005-12-03 11:40:37.750 GMT=20 Thread[DRDAConnThread_2,5,main] (XID =3D 1786), (SESSIONID =3D 0), = (DATABASE =3D=20 pag8), (DRDAID =3D NF000001.G56A-666250136264089174{1}), Begin = compiling=20 prepared statement: SELECT 1 FROM GEN_TABLE o WHERE 1=3D0 :End = prepared=20 statement

2005-12-03 11:40:37.875 GMT=20 Thread[DRDAConnThread_2,5,main] (XID =3D 1786), (SESSIONID =3D 0), = (DATABASE =3D=20 pag8), (DRDAID =3D NF000001.G56A-666250136264089174{1}), Error = compiling=20 prepared statement: SELECT 1 FROM GEN_TABLE o WHERE 1=3D0 :End = prepared=20 statement

2005-12-03 11:40:37.890 GMT=20 Thread[DRDAConnThread_2,5,main] (XID =3D 1786), (SESSIONID =3D 0), = (DATABASE =3D=20 pag8), (DRDAID =3D NF000001.G56A-666250136264089174{1}), Begin = compiling=20 prepared statement: CREATE TABLE GEN_TABLE(

) :End prepared = statement

2005-12-03 11:40:37.984 GMT=20 Thread[DRDAConnThread_2,5,main] (XID =3D 1786), (SESSIONID =3D 0), = (DATABASE =3D=20 pag8), (DRDAID =3D NF000001.G56A-666250136264089174{1}),=20 Committing

2005-12-03 11:40:38.031 GMT=20 Thread[DRDAConnThread_2,5,main] (XID =3D 1786), (SESSIONID =3D 0), = (DATABASE =3D=20 pag8), (DRDAID =3D NF000001.G56A-666250136264089174{1}), Begin = compiling=20 prepared statement: call=20 SYSIBM.SQLCAMESSAGE(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) :End prepared = statement

2005-12-03 11:40:38.109 GMT=20 Thread[DRDAConnThread_2,5,main] (XID =3D 1786), (SESSIONID =3D 0), = (DATABASE =3D=20 pag8), (DRDAID =3D NF000001.G56A-666250136264089174{1}), End = compiling=20 prepared statement: call=20 SYSIBM.SQLCAMESSAGE(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) :End prepared = statement

2005-12-03 11:40:38.140 GMT=20 Thread[DRDAConnThread_2,5,main] (XID =3D 1786), (SESSIONID =3D 0), = (DATABASE =3D=20 pag8), (DRDAID =3D NF000001.G56A-666250136264089174{1}), Executing prepared = statement:=20 call = SYSIBM.SQLCAMESSAGE(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)=20 :End prepared statement with 16 parameters begin parameter #1: -1 = :end=20 parameter begin parameter #2: 41 :end parameter begin parameter = #3:=20 Encountered ")" at line 2, column 1=1442X01 = :end=20 parameter begin parameter #4: CSS10011 :end parameter begin = parameter #5: 0=20 :end parameter begin parameter #6: 0 :end parameter begin parameter = #7: 0=20 :end parameter begin parameter #8: 0 :end parameter begin parameter = #9: 0=20 :end parameter begin parameter #10: 0 :end parameter begin parameter = #11:=20 :end parameter begin parameter #12: 42X01 :end parameter begin = parameter=20 #13: null :end parameter begin parameter #14: nl_BE :end parameter = begin=20 parameter #15: null :end parameter begin parameter #16: null :end = parameter=20

2005-12-03 11:40:38.140 GMT=20 Thread[DRDAConnThread_2,5,main] (XID =3D 1786), (SESSIONID =3D 0), = (DATABASE =3D=20 pag8), (DRDAID =3D NF000001.G56A-666250136264089174{1}),=20 Committing