[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
Re: [eclipselink-users] No inserts happen on table
|
Hi Christopher,
First thank you for the quick replay.
Actually the persist() happen in the class named service witch being
called on service.addUser(user);
After adding:
@OneToMany(cascade=CascadeType.ALL)
@JoinColumn(name="userName",nullable=false)
private List<Address> address;
the log is as follow:
[EL Info]: 2010-06-09
16:51:56.599--ServerSession(28365365)--Thread(Thread[Thread-18,5,main])--mb-bh
login successful
[EL Fine]: 2010-06-09
16:51:56.617--ServerSession(28365365)--Connection(752339)--Thread(Thread[Thread-18,5,main])--ALTER
TABLE ADD
RESS DROP CONSTRAINT FK_ADDRESS_userName
[EL Fine]: 2010-06-09
16:51:56.681--ServerSession(28365365)--Connection(752339)--Thread(Thread[Thread-18,5,main])--DROP
TABLE ADDR
ESS
[EL Fine]: 2010-06-09
16:51:56.702--ServerSession(28365365)--Connection(752339)--Thread(Thread[Thread-18,5,main])--CREATE
TABLE AD
DRESS (ADDRESSID SERIAL NOT NULL, ZIPCODE INTEGER, TOWN VARCHAR(255),
ADDRESSLINE2 VARCHAR(255), ADDRESSLINE1 VARCHAR(255), COUNT
RY VARCHAR(255), userName VARCHAR(255) NOT NULL, PRIMARY KEY (ADDRESSID))
[EL Fine]: 2010-06-09
16:51:56.746--ServerSession(28365365)--Connection(752339)--Thread(Thread[Thread-18,5,main])--DROP
TABLE APPU
SER
[EL Fine]: 2010-06-09
16:51:56.755--ServerSession(28365365)--Connection(752339)--Thread(Thread[Thread-18,5,main])--CREATE
TABLE AP
PUSER (USERNAME VARCHAR(255) NOT NULL, PASSWORD VARCHAR(255), FAX
VARCHAR(255), PHONENUMBER VARCHAR(255), USERFIRSTNAME VARCHAR(25
5), USERLASTNAME VARCHAR(255), USERMIDDLENAME VARCHAR(255), MOBILENUMBER
VARCHAR(255), PRIMARY KEY (USERNAME))
[EL Fine]: 2010-06-09
16:51:56.77--ServerSession(28365365)--Connection(752339)--Thread(Thread[Thread-18,5,main])--ALTER
TABLE ADDR
ESS ADD CONSTRAINT FK_ADDRESS_userName FOREIGN KEY (userName) REFERENCES
APPUSER (USERNAME)
[EL Fine]: 2010-06-09
16:51:56.848--ClientSession(16737882)--Connection(752339)--Thread(Thread[Thread-18,5,main])--INSERT
INTO ADD
RESS (ZIPCODE, TOWN, ADDRESSLINE2, ADDRESSLINE1, COUNTRY) VALUES (?, ?,
?, ?, ?)
bind => [1001, Tunis, null, some place, Tunisia]
[EL Fine]: 2010-06-09
16:51:56.854--ClientSession(16737882)--Thread(Thread[Thread-18,5,main])--SELECT
1
[EL Warning]: 2010-06-09
16:51:56.856--UnitOfWork(24645424)--Thread(Thread[Thread-18,5,main])--Exception
[EclipseLink-4002] (Eclip
se Persistence Services - 2.0.2.v20100323-r6872):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: null value
in column "username" violates not-null constraint
Error Code: 0
Call: INSERT INTO ADDRESS (ZIPCODE, TOWN, ADDRESSLINE2, ADDRESSLINE1,
COUNTRY) VALUES (?, ?, ?, ?, ?)
bind => [1001, Tunis, null, some place, Tunisia]
Query: InsertObjectQuery(Address{addressId=0addressLine1=some
placeaddressLine2=nulltown=TuniszipCode=1001country=Tunisia})
[EL Config]: 2010-06-09
16:51:56.862--ServerSession(28365365)--Connection(752339)--Thread(Thread[Thread-18,5,main])--disconnect
Exception in thread "Thread-18" javax.persistence.RollbackException:
Exception [EclipseLink-4002] (Eclipse Persistence Services -
2.0.2.v20100323-r6872):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: null value
in column "username" violates not-null constraint
Error Code: 0
Call: INSERT INTO ADDRESS (ZIPCODE, TOWN, ADDRESSLINE2, ADDRESSLINE1,
COUNTRY) VALUES (?, ?, ?, ?, ?)
bind => [1001, Tunis, null, some place, Tunisia]
Query: InsertObjectQuery(Address{addressId=0addressLine1=some
placeaddressLine2=nulltown=TuniszipCode=1001country=Tunisia})
at
org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commitInternal(EntityTransactionImpl.java:102)
at
org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:63)
at
tn.com.bitaka.usermanager.usermanager.impl.UserManagerServiceImpl.__addUser(UserManagerServiceImpl.java:41)
at
tn.com.bitaka.usermanager.usermanager.impl.UserManagerServiceImpl.addUser(UserManagerServiceImpl.java)
at
tn.com.bitaka.usersmanager.api.UserManagerService$$Proxy.addUser(Unknown
Source)
at
tn.com.bitaka.usersmanager.test.UsersManagerServiceClient.__run(UsersManagerServiceClient.java:50)
at
tn.com.bitaka.usersmanager.test.UsersManagerServiceClient.run(UsersManagerServiceClient.java)
at java.lang.Thread.run(Thread.java:619)
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services -
2.0.2.v20100323-r6872): org.eclipse.persistence.exceptions
.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: null value
in column "username" violates not-null constraint
Error Code: 0
Call: INSERT INTO ADDRESS (ZIPCODE, TOWN, ADDRESSLINE2, ADDRESSLINE1,
COUNTRY) VALUES (?, ?, ?, ?, ?)
bind => [1001, Tunis, null, some place, Tunisia]
Query: InsertObjectQuery(Address{addressId=0addressLine1=some
placeaddressLine2=nulltown=TuniszipCode=1001country=Tunisia})
at
org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333)
at
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processExceptionForCommError(DatabaseAccessor.java:142
2)
at
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:799)
at
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:867)
at
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:587)
at
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:530)
at
org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(AbstractSession.java:914)
at
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:206
)
at
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:192
)
at
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:33
5)
at
org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:162)
at
org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:177)
at
org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:462)
at
org.eclipse.persistence.queries.InsertObjectQuery.executeCommit(InsertObjectQuery.java:80)
at
org.eclipse.persistence.queries.InsertObjectQuery.executeCommitWithChangeSet(InsertObjectQuery.java:90)
at
org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:2
87)
at
org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:58)
at
org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:675)
at
org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:589)
at
org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery
.java:109)
at
org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:86)
at
org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2898)
at
org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1225)
at
org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1207)
at
org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1167)
at
org.eclipse.persistence.internal.sessions.CommitManager.commitNewObjectsForClassWithChangeSet(CommitManager.java:197)
at
org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsForClassWithChangeSet(CommitManager.java:164)
at
org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:116)
at
org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:3260)
at
org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1413)
at
org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:547
)
at
org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1518)
at
org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitRootUnitOfWork(RepeatableWriteUnitOfWork.java
:200)
at
org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitAndResume(UnitOfWorkImpl.java:1139)
at
org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commitInternal(EntityTransactionImpl.java:84)
... 7 more
Caused by: org.postgresql.util.PSQLException: ERROR: null value in
column "username" violates not-null constraint
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)
at
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:792)
... 39 more
Christopher Delahunt a écrit :
> Hello,
>
> I dont see that you have called persist on the address, and the
> AppUserProfile -> Address OneToMany does not have any cascade options
> set, so there is no reason why Address would get persisted/managed in
> the example shown. Try either calling persist on Address directly, or
> adding the cascade persist option to the OneToMany mapping.
>
> Best Regards,
> Chris
>
> On 09/06/2010 11:34 AM, Daoud AbdelMonem Faleh wrote:
>> Hi,
>>
>> Sorry to bother you guys with this somehow stupid question but I fail to
>> see the reason behind not seeing INSERTs happen into ADDRESS table.
>> After commit ADDRESS table is still empty and no exception happen no
>> error either in EclipseLink log.
>>
>> Environment:
>> Java version: 1.6.0_20
>> EclipseLink OSGi bundle version: 2.0.2
>> Postgres: 8.4
>> Postgres JDBC: 8.4-701.jdbc4
>> Dunno if it matters that am running this into Apache Felix Karaf OSGi
>> container but I guess not as am getting log from persistence provider.
>>
>> I have the following object model:
>>
>>
>> @Entity
>> public class AppUser implements Serializable {
>>
>> @Id
>> private String userName;
>> @Column
>> private String password;
>> @Embedded
>> private AppUserProfile profile;
>> ...
>> }
>>
>> @Embeddable
>> public class AppUserProfile {
>>
>> @Column
>> private String userFirstName;
>> @Column
>> private String userMiddleName;
>> @Column
>> private String userLastName;
>> @Column
>> private String phoneNumber;
>> @Column
>> private String mobileNumber;
>> @Column
>> private String fax;
>> @OneToMany
>> @JoinColumn(name="userName",nullable=false)
>> private List<Address> address;
>> ...
>> }
>>
>> @Entity
>> public class Address {
>>
>> @Id
>> @GeneratedValue(strategy=GenerationType.IDENTITY)
>> private long addressId;
>> @Column
>> private String addressLine1;
>> @Column
>> private String addressLine2;
>> @Column
>> private String town;
>> @Column
>> private int zipCode;
>> @Column
>> private String country;
>> ...
>> }
>>
>> The peace of code that insert into the tables:
>> AppUser user = new AppUser();
>> user.setUserName("daoud");
>> user.setPassword("secret");
>> AppUserProfile profile = new AppUserProfile();
>> profile.setUserFirstName("Daoud");
>> profile.setUserMiddleName("AbdelMonem");
>> profile.setUserLastName("Faleh");
>> Address address = new Address();
>> address.setAddressLine1("some place");
>> address.setTown("Tunis");
>> address.setZipCode(1001);
>> address.setCountry("Tunisia");
>> List<Address> userAddresses = new ArrayList<Address>();
>> userAddresses.add(address);
>> profile.setAddress(userAddresses);
>> user.setProfile(profile);
>> service.addUser(user);
>>
>>
>> service just do em.persist(user).
>>
>>
>> The Log is as follow (am using drop-and-create and logging.level FINE)
>> [EL Config]: 2010-06-09
>> 15:59:36.994--ServerSession(22672368)--Thread(Thread[Thread-17,5,main])--The
>>
>> access type for the persisten
>> t class [class tn.com.bitaka.usersmanager.model.Address] is set to
>> [FIELD].
>> [EL Config]: 2010-06-09
>> 15:59:37.025--ServerSession(22672368)--Thread(Thread[Thread-17,5,main])--The
>>
>> access type for the persisten
>> t class [class tn.com.bitaka.usersmanager.model.AppUser] is set to
>> [FIELD].
>> [EL Config]: 2010-06-09
>> 15:59:37.028--ServerSession(22672368)--Thread(Thread[Thread-17,5,main])--The
>>
>> access type for the persisten
>> t class [class tn.com.bitaka.usersmanager.model.AppUserProfile] is set
>> to [FIELD].
>> [EL Config]: 2010-06-09
>> 15:59:37.042--ServerSession(22672368)--Thread(Thread[Thread-17,5,main])--The
>>
>> target entity (reference) cla
>> ss for the one to many mapping element [field address] is being
>> defaulted to: class tn.com.bitaka.usersmanager.model.Address.
>> [EL Config]: 2010-06-09
>> 15:59:37.044--ServerSession(22672368)--Thread(Thread[Thread-17,5,main])--The
>>
>> alias name for the entity cla
>> ss [class tn.com.bitaka.usersmanager.model.Address] is being defaulted
>> to: Address.
>> [EL Config]: 2010-06-09
>> 15:59:37.047--ServerSession(22672368)--Thread(Thread[Thread-17,5,main])--The
>>
>> table name for entity [class
>> tn.com.bitaka.usersmanager.model.Address] is being defaulted to:
>> ADDRESS.
>> [EL Config]: 2010-06-09
>> 15:59:37.062--ServerSession(22672368)--Thread(Thread[Thread-17,5,main])--The
>>
>> column name for element [fiel
>> d zipCode] is being defaulted to: ZIPCODE.
>> [EL Config]: 2010-06-09
>> 15:59:37.064--ServerSession(22672368)--Thread(Thread[Thread-17,5,main])--The
>>
>> column name for element [fiel
>> d town] is being defaulted to: TOWN.
>> [EL Config]: 2010-06-09
>> 15:59:37.064--ServerSession(22672368)--Thread(Thread[Thread-17,5,main])--The
>>
>> column name for element [fiel
>> d addressLine2] is being defaulted to: ADDRESSLINE2.
>> [EL Config]: 2010-06-09
>> 15:59:37.066--ServerSession(22672368)--Thread(Thread[Thread-17,5,main])--The
>>
>> column name for element [fiel
>> d addressId] is being defaulted to: ADDRESSID.
>> [EL Config]: 2010-06-09
>> 15:59:37.069--ServerSession(22672368)--Thread(Thread[Thread-17,5,main])--The
>>
>> column name for element [fiel
>> d addressLine1] is being defaulted to: ADDRESSLINE1.
>> [EL Config]: 2010-06-09
>> 15:59:37.073--ServerSession(22672368)--Thread(Thread[Thread-17,5,main])--The
>>
>> column name for element [fiel
>> d country] is being defaulted to: COUNTRY.
>> [EL Config]: 2010-06-09
>> 15:59:37.076--ServerSession(22672368)--Thread(Thread[Thread-17,5,main])--The
>>
>> alias name for the entity cla
>> ss [class tn.com.bitaka.usersmanager.model.AppUser] is being defaulted
>> to: AppUser.
>> [EL Config]: 2010-06-09
>> 15:59:37.078--ServerSession(22672368)--Thread(Thread[Thread-17,5,main])--The
>>
>> table name for entity [class
>> tn.com.bitaka.usersmanager.model.AppUser] is being defaulted to:
>> APPUSER.
>> [EL Config]: 2010-06-09
>> 15:59:37.082--ServerSession(22672368)--Thread(Thread[Thread-17,5,main])--The
>>
>> column name for element [fiel
>> d userName] is being defaulted to: USERNAME.
>> [EL Config]: 2010-06-09
>> 15:59:37.084--ServerSession(22672368)--Thread(Thread[Thread-17,5,main])--The
>>
>> column name for element [fiel
>> d password] is being defaulted to: PASSWORD.
>> [EL Config]: 2010-06-09
>> 15:59:37.086--ServerSession(22672368)--Thread(Thread[Thread-17,5,main])--The
>>
>> column name for element [fiel
>> d fax] is being defaulted to: FAX.
>> [EL Config]: 2010-06-09
>> 15:59:37.09--ServerSession(22672368)--Thread(Thread[Thread-17,5,main])--The
>>
>> column name for element [field
>> phoneNumber] is being defaulted to: PHONENUMBER.
>> [EL Config]: 2010-06-09
>> 15:59:37.092--ServerSession(22672368)--Thread(Thread[Thread-17,5,main])--The
>>
>> column name for element [fiel
>> d userFirstName] is being defaulted to: USERFIRSTNAME.
>> [EL Config]: 2010-06-09
>> 15:59:37.095--ServerSession(22672368)--Thread(Thread[Thread-17,5,main])--The
>>
>> column name for element [fiel
>> d userLastName] is being defaulted to: USERLASTNAME.
>> [EL Config]: 2010-06-09
>> 15:59:37.097--ServerSession(22672368)--Thread(Thread[Thread-17,5,main])--The
>>
>> column name for element [fiel
>> d userMiddleName] is being defaulted to: USERMIDDLENAME.
>> [EL Config]: 2010-06-09
>> 15:59:37.1--ServerSession(22672368)--Thread(Thread[Thread-17,5,main])--The
>>
>> column name for element [field
>> mobileNumber] is being defaulted to: MOBILENUMBER.
>> [EL Config]: 2010-06-09
>> 15:59:37.139--ServerSession(22672368)--Thread(Thread[Thread-17,5,main])--The
>>
>> primary key column name for t
>> he mapping element [field address] is being defaulted to: USERNAME.
>> [EL Info]: 2010-06-09
>> 15:59:37.164--ServerSession(22672368)--Thread(Thread[Thread-17,5,main])--EclipseLink,
>>
>> version: Eclipse Persi
>> stence Services - 2.0.2.v20100323-r6872
>> [EL Fine]: 2010-06-09
>> 15:59:37.253--Thread(Thread[Thread-17,5,main])--Detected Vendor
>> platform: org.eclipse.persistence.platform.d
>> atabase.PostgreSQLPlatform
>> [EL Config]: 2010-06-09
>> 15:59:37.269--ServerSession(22672368)--Connection(25015904)--Thread(Thread[Thread-17,5,main])--connecting(
>>
>>
>> DatabaseLogin(
>> platform=>PostgreSQLPlatform
>> user name=> "mb-bh"
>> datasource URL=> "jdbc:postgresql://localhost:5432/mb-bh"
>> ))
>> [EL Config]: 2010-06-09
>> 15:59:37.314--ServerSession(22672368)--Connection(5268389)--Thread(Thread[Thread-17,5,main])--Connected:
>>
>> j
>> dbc:postgresql://localhost:5432/mb-bh
>> User: mb-bh
>> Database: PostgreSQL Version: 8.4.4
>> Driver: PostgreSQL Native Driver Version: PostgreSQL 8.4 JDBC4
>> (build 701)
>> [EL Config]: 2010-06-09
>> 15:59:37.315--ServerSession(22672368)--Connection(29237054)--Thread(Thread[Thread-17,5,main])--connecting(
>>
>>
>> DatabaseLogin(
>> platform=>PostgreSQLPlatform
>> user name=> "mb-bh"
>> datasource URL=> "jdbc:postgresql://localhost:5432/mb-bh"
>> ))
>> [EL Config]: 2010-06-09
>> 15:59:37.358--ServerSession(22672368)--Connection(16070376)--Thread(Thread[Thread-17,5,main])--Connected:
>>
>>
>> jdbc:postgresql://localhost:5432/mb-bh
>> User: mb-bh
>> Database: PostgreSQL Version: 8.4.4
>> Driver: PostgreSQL Native Driver Version: PostgreSQL 8.4 JDBC4
>> (build 701)
>> [EL Info]: 2010-06-09
>> 15:59:37.415--ServerSession(22672368)--Thread(Thread[Thread-17,5,main])--mb-bh
>>
>> login successful
>> [EL Fine]: 2010-06-09
>> 15:59:37.435--ServerSession(22672368)--Connection(16070376)--Thread(Thread[Thread-17,5,main])--ALTER
>>
>> TABLE A
>> DDRESS DROP CONSTRAINT FK_ADDRESS_userName
>> [EL Fine]: 2010-06-09
>> 15:59:37.503--ServerSession(22672368)--Connection(16070376)--Thread(Thread[Thread-17,5,main])--DROP
>>
>> TABLE AD
>> DRESS
>> [EL Fine]: 2010-06-09
>> 15:59:37.537--ServerSession(22672368)--Connection(16070376)--Thread(Thread[Thread-17,5,main])--CREATE
>>
>> TABLE
>> ADDRESS (ADDRESSID SERIAL NOT NULL, ZIPCODE INTEGER, TOWN VARCHAR(255),
>> ADDRESSLINE2 VARCHAR(255), ADDRESSLINE1 VARCHAR(255), COU
>> NTRY VARCHAR(255), userName VARCHAR(255), PRIMARY KEY (ADDRESSID))
>> [EL Fine]: 2010-06-09
>> 15:59:37.573--ServerSession(22672368)--Connection(16070376)--Thread(Thread[Thread-17,5,main])--DROP
>>
>> TABLE AP
>> PUSER
>> [EL Fine]: 2010-06-09
>> 15:59:37.583--ServerSession(22672368)--Connection(16070376)--Thread(Thread[Thread-17,5,main])--CREATE
>>
>> TABLE
>> APPUSER (USERNAME VARCHAR(255) NOT NULL, PASSWORD VARCHAR(255), FAX
>> VARCHAR(255), PHONENUMBER VARCHAR(255), USERFIRSTNAME VARCHAR(
>> 255), USERLASTNAME VARCHAR(255), USERMIDDLENAME VARCHAR(255),
>> MOBILENUMBER VARCHAR(255), PRIMARY KEY (USERNAME))
>> [EL Fine]: 2010-06-09
>> 15:59:37.637--ServerSession(22672368)--Connection(16070376)--Thread(Thread[Thread-17,5,main])--ALTER
>>
>> TABLE A
>> DDRESS ADD CONSTRAINT FK_ADDRESS_userName FOREIGN KEY (userName)
>> REFERENCES APPUSER (USERNAME)
>> [EL Fine]: 2010-06-09
>> 15:59:37.731--ClientSession(17739482)--Connection(16070376)--Thread(Thread[Thread-17,5,main])--INSERT
>>
>> INTO A
>> PPUSER (USERNAME, PASSWORD, FAX, PHONENUMBER, USERFIRSTNAME,
>> USERLASTNAME, USERMIDDLENAME, MOBILENUMBER) VALUES (?, ?, ?, ?, ?, ?,
>> ?, ?)
>> bind => [daoud, secret, null, null, Daoud, Faleh, AbdelMonem,
>> null]
>> [EL Fine]: 2010-06-09
>> 15:59:37.739--ClientSession(17739482)--Connection(16070376)--Thread(Thread[Thread-17,5,main])--UPDATE
>>
>> ADDRES
>> S SET userName = ? WHERE (ADDRESSID = ?)
>> bind => [daoud, 0]
>> [EL Config]: 2010-06-09
>> 15:59:37.779--ServerSession(22672368)--Connection(5268389)--Thread(Thread[Thread-17,5,main])--disconnect
>>
>>
>> [EL Info]: 2010-06-09
>> 15:59:37.78--ServerSession(22672368)--Thread(Thread[Thread-17,5,main])--mb-bh
>>
>> logout successful
>> [EL Config]: 2010-06-09
>> 15:59:37.782--ServerSession(22672368)--Connection(25015904)--Thread(Thread[Thread-17,5,main])--disconnect
>>
>>
>> [EL Config]: 2010-06-09
>> 15:59:37.785--ServerSession(22672368)--Connection(16070376)--Thread(Thread[Thread-17,5,main])--disconnect
>>
>>
>>
>> karaf@root>
>>
>>
>> With best regards,
>> Daoud AbdelMonem Faleh.
>> _______________________________________________
>> eclipselink-users mailing list
>> eclipselink-users@xxxxxxxxxxx
>> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>>
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users