I am defining a 1 to 1 mapping using annotation. I am getting an 'Invalid column name 'bestPractices_id' error and am unable to see why.
Code:
package com.nimsoft.ca.search;
import java.sql.Date;
import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.OneToOne;
import javax.persistence.Table;
import org.hibernate.search.annotations.Analyze;
import org.hibernate.search.annotations.Field;
import org.hibernate.search.annotations.Index;
import org.hibernate.search.annotations.Indexed;
import org.hibernate.search.annotations.Store;
/**
* The persistent class for the contact database table.
*
*/
@Entity
@Indexed
@Table(name = "KnowledgeArticle")
public class KnowledgeArticles {
private String id;
private String articlenumber;
private String caseassociationcount;
private String createdbyid;
private Date createddate;
private Date firstpublisheddate;
private Date lastmodifieddate;
private Date lastpublisheddate;
private BestPractices bestpractices;
public KnowledgeArticles() {
}
public KnowledgeArticles(String id, String articlenumber, String caseassociationcount, String createdbyid, Date createddate,Date firstpublisheddate, Date lastmodifieddate, Date lastpublisheddate, BestPractices bestPractices) {
this.id = id;
this.articlenumber = articlenumber;
this.caseassociationcount = caseassociationcount;
this.createdbyid = createdbyid;
this.createddate = createddate;
this.firstpublisheddate = firstpublisheddate;
this.lastmodifieddate = lastmodifieddate;
this.lastpublisheddate = lastpublisheddate;
this.bestpractices = bestPractices;
}
@Id
public String getId() {
return this.id;
}
public void setId(String id) {
this.id = id;
}
@Field(index = Index.YES, analyze = Analyze.YES, store = Store.NO)
public String getArticleNumber() {
return this.articlenumber;
}
public void setArticleNumber(String articlenumber) {
this.articlenumber = articlenumber;
}
public Date getFirstPublishedDate() {
return firstpublisheddate;
}
public void setFirstPublishedDate(Date firstpublisheddate) {
this.firstpublisheddate = firstpublisheddate;
}
public Date getLastModifiedDate() {
return lastmodifieddate;
}
public void setLastModifiedDate(Date lastmodifieddate) {
this.lastmodifieddate = lastmodifieddate;
}
public Date getLastPublishedDate() {
return lastpublisheddate;
}
public void setLastPublishedDate(Date lastpublisheddate) {
this.lastpublisheddate = lastpublisheddate;
}
@OneToOne
public BestPractices getBestPractices() {
bestpractices.setKnowledgeArticleId(getId());
return bestpractices;
}
public void setBestPractices(BestPractices bestpractices) {
this.bestpractices = bestpractices;
}
}
Code:
package com.nimsoft.ca.search;
import java.sql.Date;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;
import org.hibernate.search.annotations.Analyze;
import org.hibernate.search.annotations.Field;
import org.hibernate.search.annotations.Index;
import org.hibernate.search.annotations.Indexed;
import org.hibernate.search.annotations.Store;
/**
* The persistent class for the contact database table.
*
*/
@Entity
@Indexed
@Table(name = "best_practices__kav")
public class BestPractices {
private String id;
private String articletype;
private Date firstpublisheddate;
private Date lastpublisheddate;
private Date lastmodifieddate;
private String articlenumber;
private String title;
private String summary;
private String best_practices__c;
private String publishstatus;
private String originating_case__c;
private String knowledgearticleid;
public BestPractices() {
}
public BestPractices(String id, String articletype, Date firstpublisheddate, Date lastpublisheddate, Date lastmodifieddate, String articlenumber, String title, String summary, String best_practices__c, String publishstatus, String originating_case__c, String knowledgearticleid) {
this.id = id;
this.articletype = articletype;
this.firstpublisheddate = firstpublisheddate;
this.lastpublisheddate = lastpublisheddate;
this.lastmodifieddate = lastmodifieddate;
this.articlenumber = articlenumber;
this.title = title;
this.summary = summary;
this.best_practices__c = best_practices__c;
this.publishstatus = publishstatus;
this.originating_case__c = originating_case__c;
this.knowledgearticleid = knowledgearticleid;
}
@Id
public String getId() {
return this.id;
}
public void setId(String id) {
this.id = id;
}
public String getKnowledgeArticleId() {
return knowledgearticleid;
}
public void setKnowledgeArticleId(String knowledgearticleid) {
this.knowledgearticleid = knowledgearticleid;
}
@Field(index = Index.YES, analyze = Analyze.YES, store = Store.NO)
public String getArticleType() {
return this.articletype;
}
public void setArticleType(String articletype) {
this.articletype = articletype;
}
@Field(index = Index.YES, analyze = Analyze.YES, store = Store.NO)
public String getArticleNumber() {
return this.articlenumber;
}
public void setArticleNumber(String articlenumber) {
this.articlenumber = articlenumber;
}
public Date getFirstPublishedDate() {
return firstpublisheddate;
}
public void setFirstPublishedDate(Date firstpublisheddate) {
this.firstpublisheddate = firstpublisheddate;
}
public Date getLastPublishedDate() {
return lastpublisheddate;
}
public void setLastPublishedDate(Date lastpublisheddate) {
this.lastpublisheddate = lastpublisheddate;
}
public Date getLastModifiedDate() {
return lastmodifieddate;
}
public void setLastModifiedDate(Date lastmodifieddate) {
this.lastmodifieddate = lastmodifieddate;
}
@Field(index = Index.YES, analyze = Analyze.YES, store = Store.NO)
public String getTitle() {
return this.title;
}
public void setTitle(String title) {
this.title = title;
}
@Field(index = Index.YES, analyze = Analyze.YES, store = Store.NO)
public String getSummary() {
return this.summary;
}
public void setSummary(String summary) {
this.summary = summary;
}
@Field(index = Index.YES, analyze = Analyze.YES, store = Store.NO)
public String getBest_Practices__c() {
return this.best_practices__c;
}
public void setBest_Practices__c(String best_practices__c) {
this.best_practices__c = best_practices__c;
}
@Field(index = Index.YES, analyze = Analyze.YES, store = Store.NO)
public String getPublishStatus() {
return this.publishstatus;
}
public void setPublishStatus(String publishstatus) {
this.publishstatus = publishstatus;
}
@Field(index = Index.YES, analyze = Analyze.YES, store = Store.NO)
public String getOriginating_Case__c() {
return this.originating_case__c;
}
public void setOriginating_Case__c(String originating_case__c) {
this.originating_case__c = originating_case__c;
}
}
Code:
package com.nimsoft.ca.search;
import java.sql.Date;
import java.util.List;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
public class TestOneToOne {
@SuppressWarnings("unchecked")
public static void main(String[] args) {
System.out.println("Hibernate One-To-One example (Annotation)");
Session session = HibernateUtil.getSession();
List<KnowledgeArticles> knowledgearticles = session.createQuery("from KnowledgeArticles").list();
for (KnowledgeArticles knowledgearticle : knowledgearticles) {
System.out.println(knowledgearticle.getArticleNumber() + " , " +
knowledgearticle.getFirstPublishedDate() +
knowledgearticle.getBestPractices().getOriginating_Case__c() +
knowledgearticle.getBestPractices().getArticleType());
}
session.getTransaction().commit(); session.close(); }}
Code:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<!-- Database connection settings -->
<property name="connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
<property name="connection.url">jdbc:sqlserver://138.42.135.63;databaseName=Salesforce Backups;</property>
<property name="connection.username">sa</property>
<property name="connection.password">passworrd</property>
<property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
<property name="show_sql">false</property>
<property name="format_sql">false</property>
<property name="hibernate.search.default.directory_provider">filesystem</property>
<property name="hibernate.search.default.indexBase">C:\lucene\indexes</property>
<mapping class="com.nimsoft.ca.search.KnowledgeArticles"/>
<mapping class="com.nimsoft.ca.search.BestPractices"/>
<mapping class="com.nimsoft.ca.search.CaseSummaries"/>
</session-factory>
</hibernate-configuration>
Code:
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.nimsoft.ca.search</groupId>
<artifactId>HibernateSearch</artifactId>
<packaging>jar</packaging>
<version>1.0-SNAPSHOT</version>
<name>HibernateSearch</name>
<url>http://maven.apache.org</url>
<dependencies>
<!-- hibernate -->
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-core</artifactId>
<version>4.2.0.Final</version>
</dependency>
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-search</artifactId>
<version>4.2.0.Final</version>
</dependency>
<!-- SQLite JDBC library -->
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>sqljdbc4</artifactId>
<version>4.0</version>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>3.8.1</version>
<scope>test</scope>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<configuration>
<source>1.5</source>
<target>1.5</target>
</configuration>
</plugin>
</plugins>
</build>
</project>
Login
FAQ
Search