> Nico Klasens <[EMAIL PROTECTED]> wrote:
> > >
> > > Interesting. Will the application-writer order the nodes
> > > containing NODE-fields in the right way?
> >
> > Not at the moment. I was looking at it, but I haven't
> figured out the
> > algorithm.
>
>
> It was of course I who simply decided that it would be a
> whole lot easier if we require Node fields to be nullable,
> which grantedly is a tad unfortunate, because logically they
> often should not be..
Hmm. Looks like mysql doesn't like the NODE-fields to be nullable.
Changed the cvs-committed-change in xloudcontext/mmbaseusers.xml back to
false to see what would happen.
I use a datasource which screws up the lookup mechanisme, but it still
chooses for the relational.xml.
Maybe, the table creation went wrong? I didn't look into the storage
stuff yet and have no idea how they do their trick.
Nico
ERROR mmbase.storage.database.DatabaseTransaction -
java.sql.SQLException: General error: Warning: Some non-transactional
changed tables couldn't be rolled back
ERROR mmbase.storage.database.AbstractDatabaseStorage - Trouble
inserting node: admin
java.sql.SQLException: General error: Column 'defaultcontext' cannot be
null
at com.mysql.jdbc.MysqlIO.sendCommand(Unknown Source)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(Unknown Source)
at com.mysql.jdbc.Connection.execSQL(Unknown Source)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Unknown
Source)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Unknown
Source)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
tingPreparedStatement.java:207)
at
org.mmbase.storage.database.DatabaseTransaction.executeUpdate(DatabaseTr
ansaction.java:288)
at
org.mmbase.storage.database.SQL92DatabaseStorage.insertIntoTable(SQL92Da
tabaseStorage.java:469)
at
org.mmbase.storage.database.RelationalDatabaseStorage.insertIntoTable(Re
lationalDatabaseStorage.java:188)
at
org.mmbase.storage.database.SQL92DatabaseStorage.insert(SQL92DatabaseSto
rage.java:414)
at
org.mmbase.storage.database.AbstractDatabaseStorage.insert(AbstractDatab
aseStorage.java:1003)
at
org.mmbase.storage.database.Support2Storage.insert(Support2Storage.java:
192)
at
org.mmbase.module.core.MMObjectBuilder.insert(MMObjectBuilder.java:446)
at
org.mmbase.security.implementation.cloudcontext.builders.Users.insert(Un
known Source)
at
org.mmbase.module.core.MMObjectNode.insert(MMObjectNode.java:211)
at
org.mmbase.module.tools.MMAdmin.doKeyMergeNode(MMAdmin.java:860)
at
org.mmbase.module.tools.MMAdmin.installDataSources(MMAdmin.java:737)
at
org.mmbase.module.tools.MMAdmin.installApplication(MMAdmin.java:672)
at org.mmbase.module.tools.MMAdmin.probeCall(MMAdmin.java:1298)
at
org.mmbase.module.tools.MMAdminProbe.run(MMAdminProbe.java:74)
at java.lang.Thread.run(Thread.java:536)
ERROR mmbase.storage.database.AbstractDatabaseStorage -
org.mmbase.storage.StorageException: java.sql.SQLException: General
error: Column 'defaultcontext' cannot be null
at com.mysql.jdbc.MysqlIO.sendCommand(Unknown Source)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(Unknown Source)
at com.mysql.jdbc.Connection.execSQL(Unknown Source)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Unknown
Source)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Unknown
Source)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
tingPreparedStatement.java:207)
at
org.mmbase.storage.database.DatabaseTransaction.executeUpdate(DatabaseTr
ansaction.java:288)
at
org.mmbase.storage.database.SQL92DatabaseStorage.insertIntoTable(SQL92Da
tabaseStorage.java:469)
at
org.mmbase.storage.database.RelationalDatabaseStorage.insertIntoTable(Re
lationalDatabaseStorage.java:188)
at
org.mmbase.storage.database.SQL92DatabaseStorage.insert(SQL92DatabaseSto
rage.java:414)
at
org.mmbase.storage.database.AbstractDatabaseStorage.insert(AbstractDatab
aseStorage.java:1003)
at
org.mmbase.storage.database.Support2Storage.insert(Support2Storage.java:
192)
at
org.mmbase.module.core.MMObjectBuilder.insert(MMObjectBuilder.java:446)
at
org.mmbase.security.implementation.cloudcontext.builders.Users.insert(Un
known Source)
at
org.mmbase.module.core.MMObjectNode.insert(MMObjectNode.java:211)
at
org.mmbase.module.tools.MMAdmin.doKeyMergeNode(MMAdmin.java:860)
at
org.mmbase.module.tools.MMAdmin.installDataSources(MMAdmin.java:737)
at
org.mmbase.module.tools.MMAdmin.installApplication(MMAdmin.java:672)
at org.mmbase.module.tools.MMAdmin.probeCall(MMAdmin.java:1298)
at
org.mmbase.module.tools.MMAdminProbe.run(MMAdminProbe.java:74)
at java.lang.Thread.run(Thread.java:536)
at
org.mmbase.storage.database.DatabaseTransaction.executeUpdate(DatabaseTr
ansaction.java:292)
at
org.mmbase.storage.database.SQL92DatabaseStorage.insertIntoTable(SQL92Da
tabaseStorage.java:469)
at
org.mmbase.storage.database.RelationalDatabaseStorage.insertIntoTable(Re
lationalDatabaseStorage.java:188)
at
org.mmbase.storage.database.SQL92DatabaseStorage.insert(SQL92DatabaseSto
rage.java:414)
at
org.mmbase.storage.database.AbstractDatabaseStorage.insert(AbstractDatab
aseStorage.java:1003)
at
org.mmbase.storage.database.Support2Storage.insert(Support2Storage.java:
192)
at
org.mmbase.module.core.MMObjectBuilder.insert(MMObjectBuilder.java:446)
at
org.mmbase.security.implementation.cloudcontext.builders.Users.insert(Un
known Source)
at
org.mmbase.module.core.MMObjectNode.insert(MMObjectNode.java:211)
at
org.mmbase.module.tools.MMAdmin.doKeyMergeNode(MMAdmin.java:860)
at
org.mmbase.module.tools.MMAdmin.installDataSources(MMAdmin.java:737)
at
org.mmbase.module.tools.MMAdmin.installApplication(MMAdmin.java:672)
at org.mmbase.module.tools.MMAdmin.probeCall(MMAdmin.java:1298)
at
org.mmbase.module.tools.MMAdminProbe.run(MMAdminProbe.java:74)
at java.lang.Thread.run(Thread.java:536)
