SQLException « Map « JPA Q&A

  1. JPA Q&A
  2. Map
  3. SQLException




1. Hibernate Throws a SQLException When Distinctly Selecting only Two of Three Mapped Columns    stackoverflow.com

I have a table, CityComplete, with columns "USPSCITY", "STATE" and "ZIPCODE" I have an existing SQLQuery that distinctly selects USPSCITY and STATE based on a fuzzy search. However, when I call ...

2. SQLException when saving hibernate Map field on mysql DB    stackoverflow.com

I have some class hierarchy mapped in hibernate (described below) when I try to change the values in thresholds map I get an exception (also described below). when I debugged hibernate I saw ...

3. java.sql.SQLException: Cannot insert the value NULL into column    stackoverflow.com

i am making a sample program by using this tutorial. http://www.vaannila.com/hibernate/hibernate-example/hibernate-mapping-many-to-one-1.html i am facing error: 

Caused by: java.sql.SQLException: 
Cannot insert the value NULL into column 'ADDRESS_ID', 
      ...

4. JPA/Hibernate: java.sql.SQLException: Invalid argument in JDBC call: parameter index out of range    stackoverflow.com

I'm using Hibernate 4 with a simple "join table" between two other tables. Here are the JPA 1.0 compatible entities: 

@Entity
@Table(name = "Companies")
public class Company
{
    @Id
    ...

5. java.sql.SQLException: Cannot add or update a child row    forum.hibernate.org

Newbie Joined: Tue Aug 24, 2010 7:24 am Posts: 8 Hi Could someone help me understand that why am I getting the following error when I am trying to persist ServiceProvider entity? Code: java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails (`springmvc/businesslocation`, CONSTRAINT `FK5CB747B5A26ED80E` FOREIGN KEY (`state_id`) REFERENCES `state` (`id`)) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975) ...

6. SqlException when using mapped class in HQL where clause    forum.hibernate.org

Caused by: java.sql.SQLException: No value specified for parameter 1 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910) at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:1718) at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:1666) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1377) at com.caucho.sql.UserPreparedStatement.executeQuery(UserPreparedStatement.java:89) at com.caucho.sql.UserPreparedStatement.executeQuery(UserPreparedStatement.java:89) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186) at org.hibernate.loader.Loader.getResultSet(Loader.java:1787) at org.hibernate.loader.Loader.doQuery(Loader.java:674) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) ...