[jira] [Commented] (OPENJPA-2865) [Oracle] use native java.time JDBC features

2021-05-02 Thread ASF subversion and git services (Jira)


[ 
https://issues.apache.org/jira/browse/OPENJPA-2865?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17338125#comment-17338125
 ] 

ASF subversion and git services commented on OPENJPA-2865:
--

Commit 8e18fdbbbc29f39764f969168dcec58583721f39 in openjpa's branch 
refs/heads/master from Mark Struberg
[ https://gitbox.apache.org/repos/asf?p=openjpa.git;h=8e18fdb ]

OPENJPA-2865 add compat check for WITH_TIMEZONE cols


> [Oracle] use native java.time JDBC features
> ---
>
> Key: OPENJPA-2865
> URL: https://issues.apache.org/jira/browse/OPENJPA-2865
> Project: OpenJPA
>  Issue Type: Bug
>  Components: jdbc
>Affects Versions: 3.1.2
>Reporter: Mark Struberg
>Assignee: Mark Struberg
>Priority: Major
> Fix For: 3.2.0
>
>
> For the supported java.time types like {{LocalDate}}, LocalDateTime, 
> LocalTime, OffsetTime and OffsetDateTime we should make use of native JDBC 
> driver features to avoid internal conversions.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (OPENJPA-2868) update reserved column names list for various of our DBDictionaries

2021-05-02 Thread ASF subversion and git services (Jira)


[ 
https://issues.apache.org/jira/browse/OPENJPA-2868?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17338126#comment-17338126
 ] 

ASF subversion and git services commented on OPENJPA-2868:
--

Commit 31d2d862b74bfdcc6088e3c078dfde0098b42423 in openjpa's branch 
refs/heads/master from Mark Struberg
[ https://gitbox.apache.org/repos/asf?p=openjpa.git;h=31d2d86 ]

OPENJPA-2868 update invalid columNames for Oracle


> update reserved column names list for various of our DBDictionaries
> ---
>
> Key: OPENJPA-2868
> URL: https://issues.apache.org/jira/browse/OPENJPA-2868
> Project: OpenJPA
>  Issue Type: Improvement
>  Components: jdbc
>Affects Versions: 3.1.2
>Reporter: Mark Struberg
>Assignee: Mark Struberg
>Priority: Major
> Fix For: 3.2.0
>
>
> Quite a few of our Dictionaries have the reserved keyword list not up2date. 
> With OPENJPA-2867 we are now able to update those to what really works.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (OPENJPA-2870) update specification-version to 2.2

2021-05-02 Thread ASF subversion and git services (Jira)


[ 
https://issues.apache.org/jira/browse/OPENJPA-2870?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17338121#comment-17338121
 ] 

ASF subversion and git services commented on OPENJPA-2870:
--

Commit c780084ccdec85c1e98a3cf144f9e0e7bdf117fb in openjpa's branch 
refs/heads/master from Mark Struberg
[ https://gitbox.apache.org/repos/asf?p=openjpa.git;h=c780084 ]

OPENJPA-2870 update spec metadata to 2.2


> update specification-version to 2.2
> ---
>
> Key: OPENJPA-2870
> URL: https://issues.apache.org/jira/browse/OPENJPA-2870
> Project: OpenJPA
>  Issue Type: Improvement
>  Components: build / infrastructure
>Affects Versions: 3.1.2
>Reporter: Mark Struberg
>Assignee: Mark Struberg
>Priority: Major
> Fix For: 3.2.0
>
>
> update specification-version to 2.2
> We still use 2.0 till now.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (OPENJPA-2868) update reserved column names list for various of our DBDictionaries

2021-05-02 Thread ASF subversion and git services (Jira)


[ 
https://issues.apache.org/jira/browse/OPENJPA-2868?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17338113#comment-17338113
 ] 

ASF subversion and git services commented on OPENJPA-2868:
--

Commit f8667f564d90a3087bded08c8d2ed600501a176e in openjpa's branch 
refs/heads/master from Mark Struberg
[ https://gitbox.apache.org/repos/asf?p=openjpa.git;h=f8667f5 ]

OPENJPA-2868 reserved column names for HSQLDB


> update reserved column names list for various of our DBDictionaries
> ---
>
> Key: OPENJPA-2868
> URL: https://issues.apache.org/jira/browse/OPENJPA-2868
> Project: OpenJPA
>  Issue Type: Improvement
>  Components: jdbc
>Affects Versions: 3.1.2
>Reporter: Mark Struberg
>Assignee: Mark Struberg
>Priority: Major
> Fix For: 3.2.0
>
>
> Quite a few of our Dictionaries have the reserved keyword list not up2date. 
> With OPENJPA-2867 we are now able to update those to what really works.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Created] (OPENJPA-2870) update specification-version to 2.2

2021-05-02 Thread Mark Struberg (Jira)
Mark Struberg created OPENJPA-2870:
--

 Summary: update specification-version to 2.2
 Key: OPENJPA-2870
 URL: https://issues.apache.org/jira/browse/OPENJPA-2870
 Project: OpenJPA
  Issue Type: Improvement
  Components: build / infrastructure
Affects Versions: 3.1.2
Reporter: Mark Struberg
Assignee: Mark Struberg
 Fix For: 3.2.0


update specification-version to 2.2

We still use 2.0 till now.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Resolved] (OPENJPA-2867) generate list of reserved Words via unit test

2021-05-02 Thread Mark Struberg (Jira)


 [ 
https://issues.apache.org/jira/browse/OPENJPA-2867?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Mark Struberg resolved OPENJPA-2867.

Resolution: Fixed

> generate list of reserved Words via unit test
> -
>
> Key: OPENJPA-2867
> URL: https://issues.apache.org/jira/browse/OPENJPA-2867
> Project: OpenJPA
>  Issue Type: Improvement
>  Components: jdbc
>Affects Versions: 3.1.2
>Reporter: Mark Struberg
>Assignee: Mark Struberg
>Priority: Major
> Fix For: 3.2.0
>
>
> There are about 1000 reserved keywords known in the SQL universe. But not 
> everyone is a reserved word for every database.
> Thus we should create a unit test which tries out creating tables with those 
> keywords.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (OPENJPA-2866) [Oracle] add GenerationType#IDENTITY support for Oracle

2021-05-02 Thread ASF subversion and git services (Jira)


[ 
https://issues.apache.org/jira/browse/OPENJPA-2866?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17338111#comment-17338111
 ] 

ASF subversion and git services commented on OPENJPA-2866:
--

Commit d78bfc47cb505aad70f1d7380df11dfa65440a8e in openjpa's branch 
refs/heads/master from Mark Struberg
[ https://gitbox.apache.org/repos/asf?p=openjpa.git;h=d78bfc4 ]

OPENJPA-2866 fix identifier unit test

Oracle now supports IDENTITY columns since a very long time.
No need to rely on ancient index creation stuff.


> [Oracle] add GenerationType#IDENTITY support for Oracle
> ---
>
> Key: OPENJPA-2866
> URL: https://issues.apache.org/jira/browse/OPENJPA-2866
> Project: OpenJPA
>  Issue Type: Bug
>  Components: jdbc
>Affects Versions: 3.1.2
>Reporter: Mark Struberg
>Assignee: Mark Struberg
>Priority: Major
> Fix For: 3.2.0
>
>
> Our {{OracleDictionary}} did not support 
> {{javax.persistence.GenerationType#IDENTITY}}. This is clearly a bug. We 
> should create a {{"GENERATED ALWAYS AS IDENTITY"}} column.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (OPENJPA-2868) update reserved column names list for various of our DBDictionaries

2021-05-02 Thread ASF subversion and git services (Jira)


[ 
https://issues.apache.org/jira/browse/OPENJPA-2868?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17338055#comment-17338055
 ] 

ASF subversion and git services commented on OPENJPA-2868:
--

Commit 5dc56fa17b54cb9762f536e9ba42411c62baa9ed in openjpa's branch 
refs/heads/master from Mark Struberg
[ https://gitbox.apache.org/repos/asf?p=openjpa.git;h=5dc56fa ]

OPENJPA-2868 update invalidColumnNames for MariaDB


> update reserved column names list for various of our DBDictionaries
> ---
>
> Key: OPENJPA-2868
> URL: https://issues.apache.org/jira/browse/OPENJPA-2868
> Project: OpenJPA
>  Issue Type: Improvement
>  Components: jdbc
>Affects Versions: 3.1.2
>Reporter: Mark Struberg
>Assignee: Mark Struberg
>Priority: Major
> Fix For: 3.2.0
>
>
> Quite a few of our Dictionaries have the reserved keyword list not up2date. 
> With OPENJPA-2867 we are now able to update those to what really works.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (OPENJPA-2868) update reserved column names list for various of our DBDictionaries

2021-05-02 Thread ASF subversion and git services (Jira)


[ 
https://issues.apache.org/jira/browse/OPENJPA-2868?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17338039#comment-17338039
 ] 

ASF subversion and git services commented on OPENJPA-2868:
--

Commit d8b3fd87ff111ab071a95dcc137fc340f7434b07 in openjpa's branch 
refs/heads/master from Mark Struberg
[ https://gitbox.apache.org/repos/asf?p=openjpa.git;h=d8b3fd8 ]

OPENJPA-2868 add tested reserved word list for MS SQLServer

no list has previously been maintained.


> update reserved column names list for various of our DBDictionaries
> ---
>
> Key: OPENJPA-2868
> URL: https://issues.apache.org/jira/browse/OPENJPA-2868
> Project: OpenJPA
>  Issue Type: Improvement
>  Components: jdbc
>Affects Versions: 3.1.2
>Reporter: Mark Struberg
>Assignee: Mark Struberg
>Priority: Major
> Fix For: 3.2.0
>
>
> Quite a few of our Dictionaries have the reserved keyword list not up2date. 
> With OPENJPA-2867 we are now able to update those to what really works.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (OPENJPA-2868) update reserved column names list for various of our DBDictionaries

2021-05-02 Thread ASF subversion and git services (Jira)


[ 
https://issues.apache.org/jira/browse/OPENJPA-2868?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17338023#comment-17338023
 ] 

ASF subversion and git services commented on OPENJPA-2868:
--

Commit b99e2dba29aa41bfe30ede461feb8c6ebd3801a5 in openjpa's branch 
refs/heads/master from Mark Struberg
[ https://gitbox.apache.org/repos/asf?p=openjpa.git;h=b99e2db ]

OPENJPA-2868 fix invalidColumnNames for MySQL


> update reserved column names list for various of our DBDictionaries
> ---
>
> Key: OPENJPA-2868
> URL: https://issues.apache.org/jira/browse/OPENJPA-2868
> Project: OpenJPA
>  Issue Type: Improvement
>  Components: jdbc
>Affects Versions: 3.1.2
>Reporter: Mark Struberg
>Assignee: Mark Struberg
>Priority: Major
> Fix For: 3.2.0
>
>
> Quite a few of our Dictionaries have the reserved keyword list not up2date. 
> With OPENJPA-2867 we are now able to update those to what really works.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (OPENJPA-2868) update reserved column names list for various of our DBDictionaries

2021-05-02 Thread ASF subversion and git services (Jira)


[ 
https://issues.apache.org/jira/browse/OPENJPA-2868?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17338013#comment-17338013
 ] 

ASF subversion and git services commented on OPENJPA-2868:
--

Commit 8f959cc3a543cc414e03d9f25e5a270396f943aa in openjpa's branch 
refs/heads/master from Mark Struberg
[ https://gitbox.apache.org/repos/asf?p=openjpa.git;h=8f959cc ]

OPENJPA-2868 update reserved column names for H2


> update reserved column names list for various of our DBDictionaries
> ---
>
> Key: OPENJPA-2868
> URL: https://issues.apache.org/jira/browse/OPENJPA-2868
> Project: OpenJPA
>  Issue Type: Improvement
>  Components: jdbc
>Affects Versions: 3.1.2
>Reporter: Mark Struberg
>Assignee: Mark Struberg
>Priority: Major
> Fix For: 3.2.0
>
>
> Quite a few of our Dictionaries have the reserved keyword list not up2date. 
> With OPENJPA-2867 we are now able to update those to what really works.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Created] (OPENJPA-2869) Specification-Version still in v2

2021-05-02 Thread Romain Manni-Bucau (Jira)
Romain Manni-Bucau created OPENJPA-2869:
---

 Summary: Specification-Version still in v2
 Key: OPENJPA-2869
 URL: https://issues.apache.org/jira/browse/OPENJPA-2869
 Project: OpenJPA
  Issue Type: Task
Affects Versions: 3.1.2
Reporter: Romain Manni-Bucau


2.0 is still used in our poms



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (OPENJPA-2868) update reserved column names list for various of our DBDictionaries

2021-05-02 Thread ASF subversion and git services (Jira)


[ 
https://issues.apache.org/jira/browse/OPENJPA-2868?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17338002#comment-17338002
 ] 

ASF subversion and git services commented on OPENJPA-2868:
--

Commit d8bb07fe86f61a8d62c8701e425383d0cc3ba545 in openjpa's branch 
refs/heads/master from Mark Struberg
[ https://gitbox.apache.org/repos/asf?p=openjpa.git;h=d8bb07f ]

OPENJPA-2868 update reserved column words for Derby


> update reserved column names list for various of our DBDictionaries
> ---
>
> Key: OPENJPA-2868
> URL: https://issues.apache.org/jira/browse/OPENJPA-2868
> Project: OpenJPA
>  Issue Type: Improvement
>  Components: jdbc
>Affects Versions: 3.1.2
>Reporter: Mark Struberg
>Assignee: Mark Struberg
>Priority: Major
> Fix For: 3.2.0
>
>
> Quite a few of our Dictionaries have the reserved keyword list not up2date. 
> With OPENJPA-2867 we are now able to update those to what really works.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (OPENJPA-2867) generate list of reserved Words via unit test

2021-05-02 Thread ASF subversion and git services (Jira)


[ 
https://issues.apache.org/jira/browse/OPENJPA-2867?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17338001#comment-17338001
 ] 

ASF subversion and git services commented on OPENJPA-2867:
--

Commit 188ed235dc7c1e9db5b5f009d297fb297b4af1cf in openjpa's branch 
refs/heads/master from Mark Struberg
[ https://gitbox.apache.org/repos/asf?p=openjpa.git;h=188ed23 ]

OPENJPA-2867 generated pastable java code

also add more reserved words


> generate list of reserved Words via unit test
> -
>
> Key: OPENJPA-2867
> URL: https://issues.apache.org/jira/browse/OPENJPA-2867
> Project: OpenJPA
>  Issue Type: Improvement
>  Components: jdbc
>Affects Versions: 3.1.2
>Reporter: Mark Struberg
>Assignee: Mark Struberg
>Priority: Major
> Fix For: 3.2.0
>
>
> There are about 1000 reserved keywords known in the SQL universe. But not 
> everyone is a reserved word for every database.
> Thus we should create a unit test which tries out creating tables with those 
> keywords.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Created] (OPENJPA-2868) update reserved column names list for various of our DBDictionaries

2021-05-02 Thread Mark Struberg (Jira)
Mark Struberg created OPENJPA-2868:
--

 Summary: update reserved column names list for various of our 
DBDictionaries
 Key: OPENJPA-2868
 URL: https://issues.apache.org/jira/browse/OPENJPA-2868
 Project: OpenJPA
  Issue Type: Improvement
  Components: jdbc
Affects Versions: 3.1.2
Reporter: Mark Struberg
Assignee: Mark Struberg
 Fix For: 3.2.0


Quite a few of our Dictionaries have the reserved keyword list not up2date. 
With OPENJPA-2867 we are now able to update those to what really works.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (OPENJPA-2867) generate list of reserved Words via unit test

2021-05-02 Thread ASF subversion and git services (Jira)


[ 
https://issues.apache.org/jira/browse/OPENJPA-2867?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17337993#comment-17337993
 ] 

ASF subversion and git services commented on OPENJPA-2867:
--

Commit 7d3c89c5159fe78222f41bc528d789b68462f284 in openjpa's branch 
refs/heads/master from Mark Struberg
[ https://gitbox.apache.org/repos/asf?p=openjpa.git;h=7d3c89c ]

OPENJPA-2867 add a way to test reserved words


> generate list of reserved Words via unit test
> -
>
> Key: OPENJPA-2867
> URL: https://issues.apache.org/jira/browse/OPENJPA-2867
> Project: OpenJPA
>  Issue Type: Improvement
>  Components: jdbc
>Affects Versions: 3.1.2
>Reporter: Mark Struberg
>Assignee: Mark Struberg
>Priority: Major
> Fix For: 3.2.0
>
>
> There are about 1000 reserved keywords known in the SQL universe. But not 
> everyone is a reserved word for every database.
> Thus we should create a unit test which tries out creating tables with those 
> keywords.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Created] (OPENJPA-2867) generate list of reserved Words via unit test

2021-05-02 Thread Mark Struberg (Jira)
Mark Struberg created OPENJPA-2867:
--

 Summary: generate list of reserved Words via unit test
 Key: OPENJPA-2867
 URL: https://issues.apache.org/jira/browse/OPENJPA-2867
 Project: OpenJPA
  Issue Type: Improvement
  Components: jdbc
Affects Versions: 3.1.2
Reporter: Mark Struberg
Assignee: Mark Struberg
 Fix For: 3.2.0


There are about 1000 reserved keywords known in the SQL universe. But not 
everyone is a reserved word for every database.

Thus we should create a unit test which tries out creating tables with those 
keywords.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)