Hi, cross models flattened many-to-many relationships with differents users are buggy in my experience. You should use the same user in all your connection dictionnaries, easely done with Wonder in your Properties :
dbConnectURLGLOBAL = jdbc:oracle:thin:@db.test:1521:oracletest dbConnectUserGLOBAL = Oracle dbConnectPasswordGLOBAL = 1234 At the db level you should make sure the "Oracle" user has the needed rights on "OracleConnect" user. Good luck Alex 2012/3/12 Fabian Peters <[email protected]> > Hello Troy, > > Am 12.03.2012 um 10:58 schrieb Troy Lumasag: > > > Hello everyone, > > I'm new to Webobjects and Wonder and I enjoy it a lot. I'm having a simple > insert problem. > > > Welcome! > > My DB is Oracle and I have 2 Models(different User) . > My EOModel would look like this: > Model1 > URL: jdbc:oracle:thin:@db.test:1521:oracletest > user:OracleConnect > Model2 > URL: jdbc:oracle:thin:@db.test:1521:oracletest > user:Oracle > > Now I have a Many-To-Many Relationship Teacher(Model1) <-> Student(Model2). > My Code would look like this: > > public void save() { > EOEditingContext ec = (ERXEC) ERXEC.newEditingContext(); > > Teacher teacher = new Teacher(); > ec.insertObject(teacher); > > teacher.setName(teacherName); > > Student student1 = new Student(); > Student student2 = new Student(); > ec.insertObject(student1); > ec.insertObject(student2); > > student1.setName(studentName1); > student2.setName(studentName2); > > teacher.addToStudentsRelationship(student1); > teacher.addToStudentsRelationship(student2); > > ec.saveChanges(); > } > > I got this NPE everytime: > > NullPointerException > > at > com.webobjects.eoaccess.EODatabaseContext.primaryKeyForIntermediateRowFromSourceObject(EODatabaseContext.java:4845) > > at > com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingContext(EOObjectStoreCoordinator.java:373) > > at > com.webobjects.eocontrol.EOEditingContext.saveChanges(EOEditingContext.java:3192) > at er.extensions.eof.ERXEC._saveChanges(ERXEC.java:1094) > at er.extensions.eof.ERXEC.saveChanges(ERXEC.java:1016) > at your.app.components.Main.save(Main.java:67) > > > I've never used Oracle but the problem seems to be related to PK > generation. I guess the first thing to check would be whether you set the > "OraclePlugIn". You can set it in entity modeler (just put "OraclePlugIn" > where I have "PostgresqlPlugIn"): > > > > cheers, Fabian > > > Looks pretty simple but I'm stuck. Thank you in advance! > > Regards, > Troy > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > > https://lists.apple.com/mailman/options/webobjects-dev/lists.fabian%40e-lumo.com > > This email sent to [email protected] > > > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > > https://lists.apple.com/mailman/options/webobjects-dev/alexis.tual%40gmail.com > > This email sent to [email protected] > >
<<attachment: PastedGraphic-3.png>>
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
