openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sudheer Ghanathe (JIRA)" <j...@apache.org>
Subject [jira] Created: (OPENJPA-178) Handle case-sensitive databases - inappropriate change of field case to uppercase
Date Thu, 22 Mar 2007 05:30:32 GMT
Handle case-sensitive databases - inappropriate change of field case to uppercase
---------------------------------------------------------------------------------

                 Key: OPENJPA-178
                 URL: https://issues.apache.org/jira/browse/OPENJPA-178
             Project: OpenJPA
          Issue Type: Bug
          Components: jdbc
    Affects Versions: 0.9.6
         Environment: Windows, Microsoft SQL Server 2000 and any other case-sensitive database
            Reporter: Sudheer Ghanathe


@Id()
@GeneratedValue(strategy=GenerationType.TABLE, generator="ReferenceGen")
@TableGenerator(name="ReferenceGen", table="sequencer", pkColumnName="SequencerID",
        valueColumnName="keyid",pkColumnValue="reference",schema="dbo",allocationSize=1)
	@Column(name="referenceID", unique=true, nullable=false, precision=10)
	public Integer getReferenceId() {
		return this.referenceId;
	}
	public void setReferenceId(Integer referenceId) {
		this.referenceId = referenceId;
	}

The select statement generated in the above primary key generation has inappropriate uppercase
for SEQUENCERID, it should have been left as SequencerID. This causes the select to fail which
in turn causes the generatedvalue to fail.

Resolution:
Change the following method in the class org.apache.openjpa.jdbc.sql.DBDictionary.java  as
follows

protected String makeNameValid(String name, NameSet set, int maxLen,
        int nameType) {
.....
.....
		return name;
        //return name.toUpperCase();
    }



-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message