You said &quot;I checked the mysql schema and it remains varchar(255)&quot; - did you expect Hibernate to automatically alter your database? It won&#39;t. Even if you have `hibernate.hbm2ddl.auto` set, I don&#39;t believe Hibernate would alter the existing column definition.

If you were to generate new database creation script, `@Lob` should generate &quot;TEXT&quot; type column if you don&#39;t specify length explicitly (or if you do and it&#39;s less that 65536). You can always force that by explicitly declaring type in `@Column` annotation, though keep in mind that&#39;s not portable between databases:

    @Column(name=&quot;DESC&quot;, columnDefinition=&quot;TEXT&quot;)

There is a way to set the default mapping for &quot;String&quot; type to be set to &quot;text&quot; type in the database.

Save the following file in the package where you have your entities. Please change the package name as well.

This will set all &quot;String&quot; type fields to &quot;text&quot; type in the db for the package specified.

package-info.java

    @TypeDefs({
    	  @TypeDef(name=&quot;string&quot;,defaultForType=java.lang.String.class,typeClass=org.hibernate.type.TextType.class)
    })
    
    package com.package.app;
    
    import org.hibernate.annotations.TypeDef;
    import org.hibernate.annotations.TypeDefs;


I installed PostgreSQL on my local server (Ubuntu) with IP 192.168.1.10.  Now, I&#39;m trying to access the database from my client machine (Ubuntu) with IP 192.168.1.11 with pgAdmin.

I know I have to make changes in postgresql.conf and pg_hba.conf to allow the client to connect.  Could you please guide me?

Unable to connect PostgreSQL to remote database using pgAdmin

This should be very simple (when you know the answer). From [this question][1]

I want to give the posted solution a try. My question is:

How to get the parameter value of a given URL using JavaScript regular expressions?


I have:

&lt;!-- language: lang-none --&gt;

    http://www.youtube.com/watch?v=Ahg6qcgoay4

I need: 

&lt;!-- language: lang-none --&gt;

    Ahg6qcgoay4

I tried:

&lt;!-- language: lang-none --&gt;

    http://www.youtube.com/watch\\?v=(w{11})

But: I suck... 


  [1]: https://stackoverflow.com/questions/412467/how-to-embed-youtube-videos-in-php

Extract parameter value from url using regular expressions

I am having trouble setting the type of a String, it goes like

	public void setTextDesc(String textDesc) {
		this.textDesc = textDesc;
	}

	@Column(name=&quot;DESC&quot;)
	@Lob
	public String getTextDesc() {
		return textDesc;
	}

and it didn&#39;t work, I checked the mysql schema and it remains varchar(255), I also tried, 

	@Column(name=&quot;DESC&quot;, length=&quot;9000&quot;)
	
or

	@Column(name=&quot;DESC&quot;)
	@Type(type=&quot;text&quot;)
	
I am trying to make the type to be TEXT, any idea would be well appreciated!

Text Field using Hibernate Annotation

I am having trouble setting the type of a String, it goes like
<pre><code class="hljs language-typescript">public void setTextDesc(String textDesc) {
	this.textDesc = textDesc;
}

@Column(name="DESC")
@Lob
public String getTextDesc() {
	return textDesc;
}
</code></pre>
and it didn't work, I checked the mysql schema and it remains varchar(255), I also tried,
<pre><code class="hljs language-ini">@Column(name="DESC", length="9000")
</code></pre>
or
<pre><code class="hljs language-less">@Column(name="DESC")
@Type(type="text")
</code></pre>
I am trying to make the type to be TEXT, any idea would be well appreciated!

I&#39;m essentially looking for a &quot;@Ignore&quot; type annotation with which I can stop a particular field from being persisted. How can this be achieved?

What is the easiest way to ignore a JPA field during persistence?

This (should) be a rather simple thing to do, however I am struggling.

I want a table to be generated like this:
&lt;pre&gt;
id 
organizationNumber 
name
&lt;/pre&gt;

However, when I look in the database, I see that the ordering is wrong. Does anybody know how I can force hibernate/jpa to generate the table with correct ordering? 

&lt;pre&gt;
desc Organization;
+--------------------+--------------+------+-----+---------+----------------+
| Field              | Type         | Null | Key | Default | Extra          |
+--------------------+--------------+------+-----+---------+----------------+
| id                 | bigint(20)   | NO   | PRI | NULL    | auto_increment | 
| name               | varchar(255) | NO   |     | NULL    |                | 
| organizationNumber | varchar(255) | NO   | UNI | NULL    |                | 
+--------------------+--------------+------+-----+---------+----------------+
&lt;/pre&gt;

This is how my entity bean looks like: 

    @Entity
    @NamedQuery(name = &quot;allOrganizations&quot;, query = &quot;SELECT org FROM Organization org order by name&quot;)
    public class Organization {
    
    	private Long id;
    	private String organizationNumber;
    	private String name;
    
    	public Organization() {
    	}
    
    	public Organization(String name) {
    		this.name = name;
    	}
    
    	@Id
    	@GeneratedValue
    	public Long getId() {
    		return id;
    	}
    
    	@SuppressWarnings(&quot;unused&quot;)
    	private void setId(Long id) {
    		this.id = id;
    	}
    
    	@NotEmpty
    	@Column(unique=true, nullable=false)
    	public String getOrganizationNumber() {
    		return organizationNumber;
    	}
           public void setOrganizationNumber(String organizationNumber) {
    		this.organizationNumber = organizationNumber;
    	}
    
    	
    	@NotEmpty
    	@Column(nullable=false)
    	public String getName() {
    		return name;
    	}
    
    	public void setName(String name) {
    		this.name = name;
    	}
    	
    	@Override
    	public String toString() {
    		return this.name + &quot; &quot; + this.organizationNumber;
    	}
    }



Wrong ordering in generated table in jpa

I have a thick client, java swing application with a schema of 25 tables and ~15 JInternalFrames (data entry forms for the tables).  I need to make a design choice of straight JDBC or ORM (hibernate with spring framework in this case) for DBMS interaction.  Build out of the application will occur in the future.

Would hibernate be overkill for a project of this size?  An explanation of either yes or no answer would be much appreciated (or even a different approach if warranted).

TIA.

Hibernate or JDBC

For example, if we have a table Books, how would we count total number of book records with hibernate?

How do we count rows using older versions of Hibernate (~2009)?

In this application we are developing, we noticed that a view was particularly slow. I profiled the view and noticed that there was one query executed by hibernate which took 10 seconds even if there only were two object in the database to fetch. All `OneToMany` and `ManyToMany` relations were lazy so that wasn&#39;t the problem. When inspecting the actual SQL being executed, I noticed that there were over 80 joins in the query. 

Further inspecting the issue, I noticed that the problem was caused by the deep hierarchy of `OneToOne` and `ManyToOne` relations between entity classes. So, I thought, I&#39;ll just make them fetched lazy, that should solve the problem. But annotating either `@OneToOne(fetch=FetchType.LAZY)` or `@ManyToOne(fetch=FetchType.LAZY)` doesn&#39;t seem to work. Either I get an exception or then they are not actually replaced with a proxy object and thus being lazy.

Any ideas how I&#39;ll get this to work? Note that I do not use the `persistence.xml` to define relations or configuration details, everything is done in java code.

How can I make a JPA OneToOne relation lazy

I defined my own custom annotation

    @Target(value={ElementType.METHOD, ElementType.FIELD})
    @Retention(RetentionPolicy.RUNTIME)
    public @interface MyCustomAnnotation  {
	    Class&lt;?&gt; myType();
    }

how, if at all, can I make the attribute optional


java custom annotation: make an attribute optional

What are the major areas that we can use Annotations? Is the feature a replacement for XML based configuration?

How and where are Annotations used in Java?

I would like to use constants for annotation values.

    interface Client {
    
    	@Retention(RUNTIME)
    	@Target(METHOD)
    	@interface SomeAnnotation { String[] values(); }
    
    	interface Info {
    		String A = &quot;a&quot;;
    		String B = &quot;b&quot;;
    		String[] AB = new String[] { A, B };
    	}
    
    	@SomeAnnotation(values = { Info.A, Info.B })
    	void works();
    
    	@SomeAnnotation(values = Info.AB)
    	void doesNotWork();
    }

The constants `Info.A` and `Info.B` can be used in the annotation but not the array `Info.AB` as it has to be an array initializer in this place. Annotation values are restricted to values that could be inlined into the byte code of a class. This is not possible for the array constant as it has to be constructed when `Info` is loaded. Is there a workaround for this problem?

How to use an array constant in an annotation

Today I wanted to create my first annotation interface following [this documentation][1] and I got this compiler error 
&gt;     Invalid type for annotation member&quot;:
    public @interface MyAnnotation {
        Object myParameter;
        ^^^^^^
    }

Obviously `Object` cannot be used as type of an annotation member. Unfortunately I could not find any information on which types can be used in general.

This I found out using trial-and-error:

 - `String` → Valid
 - `int` → Valid
 - `Integer` → Invalid (Surprisingly)
 - `String[]` → Valid (Surprisingly)
 - `Object` → Invalid

Perhaps someone can shed some light on which types are actually allowed and why.

  [1]: http://java.sun.com/docs/books/tutorial/java/javaOO/annotations.html


Which types can be used for Java annotation members?

I&#39;m attempting to slap two or more annotations of the same type on a single element, in this case, a method. Here&#39;s the approximate code that I&#39;m working with:

    public class Dupe {
        public @interface Foo {
          String bar();
        }

        @Foo(bar=&quot;one&quot;)
        @Foo(bar=&quot;two&quot;)
        public void haha() {}
    }

When compiling the above, javac complains about a duplicate annotation:

&lt;pre&gt;
max@upsight:~/work/daybreak$ javac Dupe.java 
Dupe.java:5: duplicate annotation
&lt;/pre&gt;

Is it simply not possible to repeat annotations like this? Pedantically speaking, aren&#39;t the two instances of @Foo above different due to their contents being different?

If the above isn&#39;t possible, what are some potential workarounds?

UPDATE: I&#39;ve been asked to describe my use case. Here goes.

I&#39;m building a syntax sugarish mechanism to &quot;map&quot; POJOs to document stores such as MongoDB. I want to allow indexes to be specified as annotations on the getters or setters. Here&#39;s a contrived example:

    public class Employee {
        private List&lt;Project&gt; projects;

        @Index(expr = &quot;project.client_id&quot;)
        @Index(expr = &quot;project.start_date&quot;)
        public List&lt;Project&gt; getProjects() { return projects; }
    }

Obviously, I want to be able to quickly find instances of Employee by various properties of Project. I can either specify @Index twice with different expr() values, or take the approach specified in the accepted answer. Even though Hibernate does this and it&#39;s not considered a hack, I think it still makes sense to at least allow having multiple annotations of the same type on a single element.

Multiple annotations of the same type on one element?

How can I insert an image in MySQL and then retrieve it using PHP?

I have limited experience in either area, and I could use a little code to get me started in figuring this out.

How can I store and retrieve images from a MySQL database using PHP?

How can I easily insert a blob into a `varbinary(MAX)` field?

As an example:

thing I want to insert is: c:\picture.png&lt;br&gt;
the table is mytable&lt;br&gt;
the column is mypictureblob&lt;br&gt;
the place is recid=1

How to insert a blob into a database using sql server management studio

I&#39;m getting the same results from 

    select length(column_name) from table

as

`select dbms_lob.getlength(column_name) from table` 

However, the answers to
&lt;a href=&quot;https://stackoverflow.com/questions/840966/what-is-an-elegant-way-to-return-a-readable-file-size-of-a-file-stored-in-an-or&quot;&gt;this question&lt;/a&gt; seem to favor using `dbms_lob.getlength()`.  
  
Is there any benefit to using `dbms_lob.getlength()`? 

If it changes the answer, I know all of the blobs are .bmp images (never worked with blobs before).

dbms_lob.getlength() vs. length() to find blob size in oracle

I&#39;m looking for a command line wrapper for the DEFLATE algorithm.

I have a file (git blob) that is compressed using DEFLATE, and I want to uncompress it. The gzip command does not seem to have an option to directly use the DEFLATE algorithm, rather than the gzip format.

Ideally I&#39;m looking for a standard Unix/Linux tool that can do this.

edit: This is the output I get when trying to use gzip for my problem:

    $ cat .git/objects/c0/fb67ab3fda7909000da003f4b2ce50a53f43e7 | gunzip
    
    gzip: stdin: not in gzip format



How to DEFLATE with a command line tool to extract a git object?

I&#39;ve got some `byte[]` fields in my entities, e.g.:

    @Entity
    public class ServicePicture implements Serializable {
    	private static final long serialVersionUID = 2877629751219730559L;
    	// seam-gen attributes (you should probably edit these)
    	@Id
    	@GeneratedValue
    	private Long id;
    	private String description;
    
    	@Lob
    	@Basic(fetch = FetchType.LAZY)
    	private byte[] picture;

On my database schema the field is set to `BLOB` so this should be fine. Anyway: Everytime when I try to insert a picture or pdf - nothing bigger than `1mb`, I only recieve this

    16:52:27,327 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: 22001
    16:52:27,327 ERROR [JDBCExceptionReporter] Data truncation: Data too long for column &#39;picture&#39; at row 1
    16:52:27,328 ERROR [STDERR] javax.persistence.PersistenceException: org.hibernate.exception.DataException: could not insert: [de.ac.dmg.productfinder.entity.ServicePicture]
    16:52:27,328 ERROR [STDERR] 	at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:629)
    16:52:27,328 ERROR [STDERR] 	at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:218)
    16:52:27,328 ERROR [STDERR] 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    16:52:27,328 ERROR [STDERR] 	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    16:52:27,328 ERROR [STDERR] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    16:52:27,328 ERROR [STDERR] 	at java.lang.reflect.Method.invoke(Unknown Source)
    16:52:27,328 ERROR [STDERR] 	at org.jboss.seam.persistence.EntityManagerInvocationHandler.invoke(EntityManagerInvocationHandler.java:46)
    16:52:27,328 ERROR [STDERR] 	at $Proxy142.persist(Unknown Source)

I&#39;ve checked my MySQL cnf and the `max_allowed`param is set to `16M` - am I missing something?

Content Type	Original Author	Original Content on Stackoverflow
Question	bernardw	View Question on Stackoverflow
Solution 1 - Hibernate	ChssPly76	View Answer on Stackoverflow
Solution 2 - Hibernate	nissim_dev	View Answer on Stackoverflow

Text Field using Hibernate Annotation

Hibernate Problem Overview

Hibernate Solutions

Solution 1 - Hibernate

Solution 2 - Hibernate

Extract parameter value from url using regular expressions

Unable to connect PostgreSQL to remote database using pgAdmin

Attributions