|

»

»

»

[jira] Created: (CAY-1063) Derby adapter is not able to remove NOT NULL relationship

View: New views

12 Messages — Rating Filter: Alert me

	[jira] Created: (CAY-1063) Derby adapter is not able to remove NOT NULL relationship by Cayenne - Dev mailing list :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Derby adapter is not able to remove NOT NULL relationship --------------------------------------------------------- Key: CAY-1063 URL: https://issues.apache.org/cayenne/browse/CAY-1063 Project: Cayenne Issue Type: Bug Components: Cayenne Core Library Affects Versions: 3.0 Environment: Does Derby even support this operation? Reporter: Øyvind Harboe Assignee: Andrus Adamchik Priority: Minor 31000 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - Detected and installed adapter: org.apache.cayenne.dba.derby.DerbyAdapter 45641 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - ALTER TABLE log_email ALTER COLUMN sender DROP NOT NULL 45704 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - *** error. java.sql.SQLException: Syntax error: Encountered "DROP" at line 1, column 43. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) at org.apache.cayenne.merge.ExecutingMergerContext.executeSql(ExecutingMergerContext.java:60) at org.apache.cayenne.merge.AbstractToDbToken.execute(AbstractToDbToken.java:41) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
	[jira] Commented: (CAY-1063) Derby adapter is not able to remove NOT NULL relationship by Cayenne - Dev mailing list :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message [ https://issues.apache.org/cayenne/browse/CAY-1063?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12898#action_12898 ] Ari Maniatis commented on CAY-1063: ----------------------------------- I think the SQL should be: ALTER TABLE log_email ALTER COLUMN sender NOT NULL Derby does support this (well, the current versions do). > Derby adapter is not able to remove NOT NULL relationship > --------------------------------------------------------- > > Key: CAY-1063 > URL: https://issues.apache.org/cayenne/browse/CAY-1063 > Project: Cayenne > Issue Type: Bug > Components: Cayenne Core Library > Affects Versions: 3.0 > Environment: Does Derby even support this operation? > Reporter: Øyvind Harboe > Assignee: Andrus Adamchik > Priority: Minor > > 31000 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - Detected and installed adapter: org.apache.cayenne.dba.derby.DerbyAdapter > 45641 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - ALTER TABLE log_email ALTER COLUMN sender DROP NOT NULL > 45704 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - *** error. > java.sql.SQLException: Syntax error: Encountered "DROP" at line 1, column 43. > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at org.apache.cayenne.merge.ExecutingMergerContext.executeSql(ExecutingMergerContext.java:60) > at org.apache.cayenne.merge.AbstractToDbToken.execute(AbstractToDbToken.java:41) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
	[jira] Commented: (CAY-1063) Derby adapter is not able to remove NOT NULL relationship by Cayenne - Dev mailing list :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message [ https://issues.apache.org/cayenne/browse/CAY-1063?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12899#action_12899 ] Tore Halset commented on CAY-1063: ---------------------------------- Ari: the case here is to drop a not null constraint, not to add it. > Derby adapter is not able to remove NOT NULL relationship > --------------------------------------------------------- > > Key: CAY-1063 > URL: https://issues.apache.org/cayenne/browse/CAY-1063 > Project: Cayenne > Issue Type: Bug > Components: Cayenne Core Library > Affects Versions: 3.0 > Environment: Does Derby even support this operation? > Reporter: Øyvind Harboe > Assignee: Andrus Adamchik > Priority: Minor > > 31000 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - Detected and installed adapter: org.apache.cayenne.dba.derby.DerbyAdapter > 45641 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - ALTER TABLE log_email ALTER COLUMN sender DROP NOT NULL > 45704 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - *** error. > java.sql.SQLException: Syntax error: Encountered "DROP" at line 1, column 43. > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at org.apache.cayenne.merge.ExecutingMergerContext.executeSql(ExecutingMergerContext.java:60) > at org.apache.cayenne.merge.AbstractToDbToken.execute(AbstractToDbToken.java:41) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
	[jira] Commented: (CAY-1063) Derby adapter is not able to remove NOT NULL relationship by Cayenne - Dev mailing list :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message [ https://issues.apache.org/cayenne/browse/CAY-1063?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12900#action_12900 ] Ari Maniatis commented on CAY-1063: ----------------------------------- Argh... sorry about that. What my brain was thinking and I meant to type was ALTER TABLE log_email ALTER COLUMN sender NULL This was implemented in Derby 10.2.1.6. I went and looked up the Jira issue for it just to make sure. [https://issues.apache.org/jira/browse/DERBY-119] > Derby adapter is not able to remove NOT NULL relationship > --------------------------------------------------------- > > Key: CAY-1063 > URL: https://issues.apache.org/cayenne/browse/CAY-1063 > Project: Cayenne > Issue Type: Bug > Components: Cayenne Core Library > Affects Versions: 3.0 > Environment: Does Derby even support this operation? > Reporter: Øyvind Harboe > Assignee: Andrus Adamchik > Priority: Minor > > 31000 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - Detected and installed adapter: org.apache.cayenne.dba.derby.DerbyAdapter > 45641 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - ALTER TABLE log_email ALTER COLUMN sender DROP NOT NULL > 45704 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - *** error. > java.sql.SQLException: Syntax error: Encountered "DROP" at line 1, column 43. > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at org.apache.cayenne.merge.ExecutingMergerContext.executeSql(ExecutingMergerContext.java:60) > at org.apache.cayenne.merge.AbstractToDbToken.execute(AbstractToDbToken.java:41) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
	[jira] Commented: (CAY-1063) Derby adapter is not able to remove NOT NULL relationship by Cayenne - Dev mailing list :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message [ https://issues.apache.org/cayenne/browse/CAY-1063?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12901#action_12901 ] Øyvind Harboe commented on CAY-1063: ------------------------------------ Does a JUnit case exist for this feature across all providers? (Derby I guess is easier than other databases to test in the testsuite supporting embedded operation) > Derby adapter is not able to remove NOT NULL relationship > --------------------------------------------------------- > > Key: CAY-1063 > URL: https://issues.apache.org/cayenne/browse/CAY-1063 > Project: Cayenne > Issue Type: Bug > Components: Cayenne Core Library > Affects Versions: 3.0 > Environment: Does Derby even support this operation? > Reporter: Øyvind Harboe > Assignee: Andrus Adamchik > Priority: Minor > > 31000 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - Detected and installed adapter: org.apache.cayenne.dba.derby.DerbyAdapter > 45641 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - ALTER TABLE log_email ALTER COLUMN sender DROP NOT NULL > 45704 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - *** error. > java.sql.SQLException: Syntax error: Encountered "DROP" at line 1, column 43. > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at org.apache.cayenne.merge.ExecutingMergerContext.executeSql(ExecutingMergerContext.java:60) > at org.apache.cayenne.merge.AbstractToDbToken.execute(AbstractToDbToken.java:41) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
	[jira] Assigned: (CAY-1063) Derby adapter is not able to remove NOT NULL relationship by Cayenne - Dev mailing list :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message [ https://issues.apache.org/cayenne/browse/CAY-1063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tore Halset reassigned CAY-1063: -------------------------------- Assignee: Tore Halset (was: Andrus Adamchik) > Derby adapter is not able to remove NOT NULL relationship > --------------------------------------------------------- > > Key: CAY-1063 > URL: https://issues.apache.org/cayenne/browse/CAY-1063 > Project: Cayenne > Issue Type: Bug > Components: Cayenne Core Library > Affects Versions: 3.0 > Environment: Does Derby even support this operation? > Reporter: Øyvind Harboe > Assignee: Tore Halset > Priority: Minor > > 31000 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - Detected and installed adapter: org.apache.cayenne.dba.derby.DerbyAdapter > 45641 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - ALTER TABLE log_email ALTER COLUMN sender DROP NOT NULL > 45704 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - *** error. > java.sql.SQLException: Syntax error: Encountered "DROP" at line 1, column 43. > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at org.apache.cayenne.merge.ExecutingMergerContext.executeSql(ExecutingMergerContext.java:60) > at org.apache.cayenne.merge.AbstractToDbToken.execute(AbstractToDbToken.java:41) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
	[jira] Closed: (CAY-1063) Derby adapter is not able to remove NOT NULL relationship by Cayenne - Dev mailing list :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message [ https://issues.apache.org/cayenne/browse/CAY-1063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tore Halset closed CAY-1063. ---------------------------- fixed and note added to RELEASE-NOTES.txt > Derby adapter is not able to remove NOT NULL relationship > --------------------------------------------------------- > > Key: CAY-1063 > URL: https://issues.apache.org/cayenne/browse/CAY-1063 > Project: Cayenne > Issue Type: Bug > Components: Cayenne Core Library > Affects Versions: 3.0 > Environment: Does Derby even support this operation? > Reporter: Øyvind Harboe > Assignee: Tore Halset > Priority: Minor > Fix For: 3.0 > > > 31000 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - Detected and installed adapter: org.apache.cayenne.dba.derby.DerbyAdapter > 45641 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - ALTER TABLE log_email ALTER COLUMN sender DROP NOT NULL > 45704 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - *** error. > java.sql.SQLException: Syntax error: Encountered "DROP" at line 1, column 43. > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at org.apache.cayenne.merge.ExecutingMergerContext.executeSql(ExecutingMergerContext.java:60) > at org.apache.cayenne.merge.AbstractToDbToken.execute(AbstractToDbToken.java:41) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
	[jira] Resolved: (CAY-1063) Derby adapter is not able to remove NOT NULL relationship by Cayenne - Dev mailing list :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message [ https://issues.apache.org/cayenne/browse/CAY-1063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tore Halset resolved CAY-1063. ------------------------------ Resolution: Fixed Fix Version/s: 3.0 Added test cases for add/drop not null. Tested/working on derby, postgres and hsqldb > Derby adapter is not able to remove NOT NULL relationship > --------------------------------------------------------- > > Key: CAY-1063 > URL: https://issues.apache.org/cayenne/browse/CAY-1063 > Project: Cayenne > Issue Type: Bug > Components: Cayenne Core Library > Affects Versions: 3.0 > Environment: Does Derby even support this operation? > Reporter: Øyvind Harboe > Assignee: Tore Halset > Priority: Minor > Fix For: 3.0 > > > 31000 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - Detected and installed adapter: org.apache.cayenne.dba.derby.DerbyAdapter > 45641 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - ALTER TABLE log_email ALTER COLUMN sender DROP NOT NULL > 45704 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - *** error. > java.sql.SQLException: Syntax error: Encountered "DROP" at line 1, column 43. > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at org.apache.cayenne.merge.ExecutingMergerContext.executeSql(ExecutingMergerContext.java:60) > at org.apache.cayenne.merge.AbstractToDbToken.execute(AbstractToDbToken.java:41) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
	[jira] Commented: (CAY-1063) Derby adapter is not able to remove NOT NULL relationship by Cayenne - Dev mailing list :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message [ https://issues.apache.org/cayenne/browse/CAY-1063?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12925#action_12925 ] Øyvind Harboe commented on CAY-1063: ------------------------------------ I can't use this feature unless it also works with MS SQL. How can I know short of trying? > Derby adapter is not able to remove NOT NULL relationship > --------------------------------------------------------- > > Key: CAY-1063 > URL: https://issues.apache.org/cayenne/browse/CAY-1063 > Project: Cayenne > Issue Type: Bug > Components: Cayenne Core Library > Affects Versions: 3.0 > Environment: Does Derby even support this operation? > Reporter: Øyvind Harboe > Assignee: Tore Halset > Priority: Minor > Fix For: 3.0 > > > 31000 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - Detected and installed adapter: org.apache.cayenne.dba.derby.DerbyAdapter > 45641 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - ALTER TABLE log_email ALTER COLUMN sender DROP NOT NULL > 45704 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - *** error. > java.sql.SQLException: Syntax error: Encountered "DROP" at line 1, column 43. > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at org.apache.cayenne.merge.ExecutingMergerContext.executeSql(ExecutingMergerContext.java:60) > at org.apache.cayenne.merge.AbstractToDbToken.execute(AbstractToDbToken.java:41) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
	[jira] Commented: (CAY-1063) Derby adapter is not able to remove NOT NULL relationship by Cayenne - Dev mailing list :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message [ https://issues.apache.org/cayenne/browse/CAY-1063?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12926#action_12926 ] Tore Halset commented on CAY-1063: ---------------------------------- I do not have access (easily) to MS SQL Server these days, but will look at it later. If you are in a hurry, please run the junit tests and patch SQLServerMergerFactory if needed. http://cayenne.apache.org/running-unit-tests.html > Derby adapter is not able to remove NOT NULL relationship > --------------------------------------------------------- > > Key: CAY-1063 > URL: https://issues.apache.org/cayenne/browse/CAY-1063 > Project: Cayenne > Issue Type: Bug > Components: Cayenne Core Library > Affects Versions: 3.0 > Environment: Does Derby even support this operation? > Reporter: Øyvind Harboe > Assignee: Tore Halset > Priority: Minor > Fix For: 3.0 > > > 31000 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - Detected and installed adapter: org.apache.cayenne.dba.derby.DerbyAdapter > 45641 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - ALTER TABLE log_email ALTER COLUMN sender DROP NOT NULL > 45704 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - *** error. > java.sql.SQLException: Syntax error: Encountered "DROP" at line 1, column 43. > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at org.apache.cayenne.merge.ExecutingMergerContext.executeSql(ExecutingMergerContext.java:60) > at org.apache.cayenne.merge.AbstractToDbToken.execute(AbstractToDbToken.java:41) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
	[jira] Commented: (CAY-1063) Derby adapter is not able to remove NOT NULL relationship by Cayenne - Dev mailing list :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message [ https://issues.apache.org/cayenne/browse/CAY-1063?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12927#action_12927 ] Øyvind Harboe commented on CAY-1063: ------------------------------------ Will do. I have opened another JIRA on the subject that there is no way to find this out short of trying. > Derby adapter is not able to remove NOT NULL relationship > --------------------------------------------------------- > > Key: CAY-1063 > URL: https://issues.apache.org/cayenne/browse/CAY-1063 > Project: Cayenne > Issue Type: Bug > Components: Cayenne Core Library > Affects Versions: 3.0 > Environment: Does Derby even support this operation? > Reporter: Øyvind Harboe > Assignee: Tore Halset > Priority: Minor > Fix For: 3.0 > > > 31000 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - Detected and installed adapter: org.apache.cayenne.dba.derby.DerbyAdapter > 45641 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - ALTER TABLE log_email ALTER COLUMN sender DROP NOT NULL > 45704 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - *** error. > java.sql.SQLException: Syntax error: Encountered "DROP" at line 1, column 43. > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at org.apache.cayenne.merge.ExecutingMergerContext.executeSql(ExecutingMergerContext.java:60) > at org.apache.cayenne.merge.AbstractToDbToken.execute(AbstractToDbToken.java:41) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
	[jira] Commented: (CAY-1063) Derby adapter is not able to remove NOT NULL relationship by Cayenne - Dev mailing list :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message [ https://issues.apache.org/cayenne/browse/CAY-1063?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13003#action_13003 ] Tore Halset commented on CAY-1063: ---------------------------------- fixed for sqlserver and openbase > Derby adapter is not able to remove NOT NULL relationship > --------------------------------------------------------- > > Key: CAY-1063 > URL: https://issues.apache.org/cayenne/browse/CAY-1063 > Project: Cayenne > Issue Type: Bug > Components: Cayenne Core Library > Affects Versions: 3.0 > Environment: Does Derby even support this operation? > Reporter: Øyvind Harboe > Assignee: Tore Halset > Priority: Minor > Fix For: 3.0 > > > 31000 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - Detected and installed adapter: org.apache.cayenne.dba.derby.DerbyAdapter > 45641 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - ALTER TABLE log_email ALTER COLUMN sender DROP NOT NULL > 45704 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - *** error. > java.sql.SQLException: Syntax error: Encountered "DROP" at line 1, column 43. > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at org.apache.cayenne.merge.ExecutingMergerContext.executeSql(ExecutingMergerContext.java:60) > at org.apache.cayenne.merge.AbstractToDbToken.execute(AbstractToDbToken.java:41) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.

LightInTheBox - Buy quality products at wholesale price