You can use the following url: 
&lt;br/&gt;`&quot;jdbc:h2:mem:sample;INIT=RUNSCRIPT FROM &#39;classpath:scripts/create.sql&#39;&quot;`

With that one it is possible to run script from classpath. So you can just put it src/main/resources/scripts or src/test/resources/scripts in your maven (or something else) project. 

I&#39;d suggest trying to use an absolute path for starters, just to check everything works. Afterwards, check your classpath. For example, `bin/main/resources/scripts/create.sql`, assuming `bin` is where your classes are compiled, and is on your classpath.

Since `src`, where your source lives, usually isn&#39;t on the classpath, this could be the source of your problem.

I&#39;m using a textarea control to allow the user to input text and then place that text into the body of an e-mail. In the code behind, what is the syntax for referencing the users input? I thought I could just use `message.Body = test123.Text;` but this is not recognized.

HTML:

&lt;!-- language: lang-html --&gt;

    &lt;textarea id=&quot;TextArea1&quot; cols=&quot;20&quot; rows=&quot;2&quot; &gt;&lt;/textarea&gt;


CodeBehind: 

&lt;!-- language: lang-c# --&gt;

    foreach (string recipient in recipients)
    {         
      var message = new System.Net.Mail.MailMessage(&quot;sender@example.com&quot;, recipient);
      message.Subject = &quot;Hello World!&quot;;         
      message.Body = test123.Text;                
      client.Send(message); 
    } 


How do I reference the input of an HTML &lt;textarea&gt; control in codebehind?

It looks like you can&#39;t use exec in a function that has a subfunction...

Anyone know why this Python code doesn&#39;t work?  I get an error at the exec in test2.  Also, I know exec&#39;s aren&#39;t good style, but trust me, I&#39;m using exec for an appropriate reason. I wouldn&#39;t use it otherwise.

    #!/usr/bin/env python
    #
    
    def test1():
        exec(&#39;print &quot;hi from test1&quot;&#39;)
    
    test1()
    
    def test2():
        &quot;&quot;&quot;Test with a subfunction.&quot;&quot;&quot;
        exec(&#39;print &quot;hi from test2&quot;&#39;)
        def subfunction():
            return True
    
    test2()

EDIT: I narrowed down the bug to having a function in a subfunction. It has nothing to do with the raise keyword.

Why doesn&#39;t exec work in a function with a subfunction?

I use maven conventions for source paths (src/main src/test) and i have my sql scripts in src/main/resources/scripts.

I want to run my app with H2 memory and i&#39;d like to use the jdbc url to initialize my db :

    database.url=jdbc:h2:mem:;INIT=RUNSCRIPT FROM &#39;src/main/resources/scripts/create.sql&#39;;

My problem is that this relative path (src/main/... ) does not work, and that H2 won&#39;t crash if the init=runscript command targets nothing.

Does someone know what is the path i should use to make this work ?

Thanks

problem with INIT=RUNSCRIPT and relative paths

I use maven conventions for source paths (src/main src/test) and i have my sql scripts in src/main/resources/scripts.
I want to run my app with H2 memory and i'd like to use the jdbc url to initialize my db :
<pre><code class="hljs language-css">database.url=jdbc:h2:mem:;INIT=RUNSCRIPT FROM 'src/main/resources/scripts/create.sql';
</code></pre>
My problem is that this relative path (src/main/... ) does not work, and that H2 won't crash if the init=runscript command targets nothing.
Does someone know what is the path i should use to make this work ?
Thanks

&gt; **Possible Duplicate:**  
&gt; [Is there a way to take a screenshot using Java and save it to some sort of image?](https://stackoverflow.com/questions/58305/is-there-a-way-to-take-a-screenshot-using-java-and-save-it-to-some-sort-of-image)  

&lt;!-- End of automatically inserted text --&gt;

How to take a screenshot in Java?

How to take a screenshot in Java?

I have heard lots of raving about [Akka][1] framework (Java/Scala service platform), but so far have not seen many actual examples of use cases it would be good for. So I would be interested in hearing about things developers have used it succesfully.

Only one limitation: please do not include case of writing a chat server. 
(why? since this has been overused as an example for lots of similar things)

  [1]: http://akka.io/

What are the best use cases for Akka framework

I am trying to figure out one thing in IntelliJ IDEA 10:

![alt text][1]


  [1]: http://i.stack.imgur.com/PMRHr.png

1. current caret position
2. where caret moves after pressing DOWN arrow
3. where I want caret to be

Is such setting possible?

IntelliJ IDEA - caret behavior

How do I parse the date string below into a `Date` object?

    String target = &quot;Thu Sep 28 20:29:30 JST 2000&quot;;
    DateFormat df = new SimpleDateFormat(&quot;E MM dd kk:mm:ss z yyyy&quot;);
    Date result =  df.parse(target);  

Throws exception...

    java.text.ParseException: Unparseable date: &quot;Thu Sep 28 20:29:30 JST 2000&quot;
            at java.text.DateFormat.parse(DateFormat.java:337)

How to parse date string to Date?

In Java I am told that when doing a null check one should use == instead of .equals(). What are the reasons for this?

Java null check why use == instead of .equals()

What is the difference between persist() and merge() in Hibernate?

`persist()` can create a UPDATE &amp; INSERT query, eg:

    SessionFactory sef = cfg.buildSessionFactory();
    Session session = sef.openSession();
    A a=new A();
    session.persist(a);
    a.setName(&quot;Mario&quot;);
    session.flush();

in this case **query** will be generated like this:

    Hibernate: insert into A (NAME, ID) values (?, ?)
    Hibernate: update A set NAME=? where ID=?

so `persist()` method can **generate** an Insert and an Update.

Now with `merge()`:

    SessionFactory sef = cfg.buildSessionFactory();
    Session session = sef.openSession();
    Singer singer = new Singer();
    singer.setName(&quot;Luciano Pavarotti&quot;);
    session.merge(singer);
    session.flush();

This is what I see in the database:

    SINGER_ID	SINGER_NAME
    1	        Ricky Martin
    2	        Madonna
    3	        Elvis Presley
    4	        Luciano Pavarotti

Now update a record using `merge()`
        
    SessionFactory sef = cfg.buildSessionFactory();
    Session session = sef.openSession();
    Singer singer = new Singer();
    singer.setId(2);
    singer.setName(&quot;Luciano Pavarotti&quot;);
    session.merge(singer);
    session.flush();

This is what I see in the database:

    SINGER_ID	SINGER_NAME
    1	        Ricky Martin
    2	        Luciano Pavarotti
    3	        Elvis Presley


What is the difference between persist() and merge() in JPA and Hibernate?

I am using Hibernate 3.5.6 with Oracle 10g. I am seeing the below exception during initialization but the application itself is working fine. What is the cause for this exception? and how it can be corrected?

**Exception**  
Disabling contextual LOB creation as `createClob()` method threw error : `java.lang.reflect.InvocationTargetException`

**Info**  
Oracle version: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 
JDBC driver: Oracle JDBC driver, version: 11.1.0.7.0

Disabling contextual LOB creation as createClob() method threw error

I thought hibernate takes into consideration only class variables that are annotated with `@Column`.  But strangely today when I added a variable (that is not mapped to any column, just a variable i need in the class), it is trying to include that variable in the select statement as a column name and throws the error - 

&gt;Unknown column &#39;team1_.agencyName&#39; in &#39;field list&#39;

My class - 

    @Entity
    @Table(name=&quot;team&quot;)
    public class Team extends BaseObject implements Serializable {

    @Id  @GeneratedValue(strategy=GenerationType.AUTO)
    private Long id;
    
    @Column(length=50)
    private String name;
    
    @Column(length=10)
    private String code;
    
    @Column(name = &quot;agency_id&quot;)
    private Long agencyId;
    
    private String agencyName; //note: not annotated.

    }

FYI...I use the above class in another class with many to many mapping

    @ManyToMany(fetch = FetchType.EAGER) 
    @JoinTable(
            name=&quot;user_team&quot;,
            joinColumns = { @JoinColumn( name=&quot;user_id&quot;) },
            inverseJoinColumns = @JoinColumn( name=&quot;team_id&quot;)
    )    
    public Set&lt;Team&gt; getTeams() {
        return teams;
    }

Why is this happening?!


Make hibernate ignore class variables that are not mapped

I need to combine 2 tables using hql, both are having common column, but `table1` common column is `integer` and `table2` common column is `String`

For example,
    
    select a.id as id,a.name as name,b.address as address 
    from Personal as a,Home as b 
    where a.id=b.studid


Here `a.id` is an `integer` while `b.stduid` is a `string`, but Data of both columns is the same.

How can I get the result of the query using hql query?

How do I write hql query with cast?

I have the following parametrised JPA, or Hibernate, query:

    SELECT entity FROM Entity entity WHERE name IN (?)

I want to pass the parameter as an ArrayList&amp;lt;String&gt;, is this possible? Hibernate current tells me, that

    java.lang.ClassCastException: java.util.ArrayList cannot be cast to java.lang.String

Is this possible at all?

**ANSWER**: Collections as parameters only work with named parameters like &quot;`:name`&quot;, not with JDBC style parameters like &quot;`?`&quot;.

IN-clause in HQL or Java Persistence Query Language

Maven `dependency:analyze` complains about the dependencies in my project. How does it determine which are unused and which are undeclared? What should I do about them?

Example:

    $ mvn dependency:analyze 
    ...
    [WARNING] Used undeclared dependencies found:
    [WARNING]    org.slf4j:slf4j-api:jar:1.5.0:provided
    [WARNING]    commons-logging:commons-logging:jar:1.1.1:compile
    [WARNING]    commons-dbutils:commons-dbutils:jar:1.1-osgi:provided
    [WARNING]    org.codehaus.jackson:jackson-core-asl:jar:1.6.1:compile

    ...
    [WARNING] Unused declared dependencies found:
    [WARNING]    commons-cli:commons-cli:jar:1.0:compile
    [WARNING]    org.mortbay.jetty:servlet-api:jar:2.5-20081211:test
    [WARNING]    org.apache.httpcomponents:httpclient:jar:4.0-alpha4:compile
    [WARNING]    commons-collections:commons-collections:jar:3.2:provided
    [WARNING]    javax.mail:mail:jar:1.4:provided


Note:
A lot of these dependencies are used in my runtime container and I declared them as provided to avoid having the same library on the classpath twice with different versions. 


What are unused/undeclared dependencies in Maven? What to do with them?

I’m trying to find a “generic” way of excluding a transitive dependency from being included without having to exclude it from all the dependencies that depend on it.  For example, if I want to exclude slf4j, I do the following:


      &lt;dependency&gt;
        &lt;groupId&gt;org.hibernate&lt;/groupId&gt;
        &lt;artifactId&gt;hibernate-jmx&lt;/artifactId&gt;
        &lt;version&gt;3.3.2.GA&lt;/version&gt;
        &lt;exclusions&gt;
          &lt;exclusion&gt;
            &lt;groupId&gt;org.slf4j&lt;/groupId&gt;
            &lt;artifactId&gt;slf4j-api&lt;/artifactId&gt;
          &lt;/exclusion&gt;
        &lt;/exclusions&gt;
      &lt;/dependency&gt;
      &lt;dependency&gt;
        &lt;groupId&gt;org.hibernate&lt;/groupId&gt;
        &lt;artifactId&gt;hibernate-entitymanager&lt;/artifactId&gt;
        &lt;version&gt;3.4.0.GA&lt;/version&gt;
        &lt;type&gt;jar&lt;/type&gt;
        &lt;exclusions&gt;
          &lt;exclusion&gt;
            &lt;groupId&gt;org.slf4j&lt;/groupId&gt;
            &lt;artifactId&gt;slf4j-api&lt;/artifactId&gt;
          &lt;/exclusion&gt;
        &lt;/exclusions&gt;
      &lt;/dependency&gt;

This is partly to clean up the pom file, partly to avoid issues in the future with people adding dependencies that depend on that excluded dependency — and forgetting to exclude it.

Is there a way?


Is there a way to exclude a Maven dependency globally?

I want to deploy sources and javadocs with my snapshots. This means that I want to automize the following command:

    mvn clean source:jar javadoc:jar deploy

Just to execute:

    mvn clean deploy

I don&#39;t want to have javadoc/sources generation executed during the `install` phase (i.e. local builds).

I know that source/javadoc plugins can be synchronized with the execution of the `release` plugin but I can&#39;t figure out how to wire it to the snapshots releases.

How to deploy SNAPSHOT with sources and JavaDoc?

How can I specify the outputDirectory only for packaging a jar?

http://maven.apache.org/plugins/maven-jar-plugin/jar-mojo.html this shows all parameters, but how can I set them in the commandline or pom.xml?

Maven: specify the outputDirectory only for packaging a jar?

I want to prevent maven from displaying INFO messages, I want to see only WARNINGS and ERRORS (if any). 

How can I achieve this, preferably by changing the command line that calls maven?

How to change maven logging level to display only warning and errors?

After enabling `set mouse=a`, text copied inside of Vim will not paste outside of Vim. Does anybody know of a way to fix this?

Here, selecting text with the mouse turns on visual mode and disables the `Copy` option in the popup menu:

![enter image description here][1]

  [1]: http://i.stack.imgur.com/qrJlJ.png

Copying text outside of Vim with set mouse=a enabled

I want to use my app config to store the settings for 2 companys, and i&#39;d prefer if it was possible to use a section to seperate the data for one from the other rather then giving them diffrent key names.

I have been checking online but i seem to get a bit overwhelmed when people use sections or find outdated easy ways to use them. could anyone pass me a beginner guide on them?

Below is an example of what my app.config would look like:

      &lt;configSections&gt;
        &lt;section name=&quot;FBI&quot; type=&quot;&quot; /&gt;
        &lt;section name=&quot;FSCS&quot; type=&quot;&quot; /&gt;
      &lt;/configSections&gt;
    
      &lt;FSCS&gt;
        &lt;add key=&quot;processingDirectory&quot; value=&quot;C:\testfiles\ProccesFolder&quot;/&gt;
      &lt;/FSCS&gt;
      &lt;FBI&gt;
        &lt;add key=&quot;processingDirectory&quot; value=&quot;C:\testfiles\ProccesFolder&quot;/&gt;
      &lt;/FBI&gt;

Update:

Advanced solution based on the anwer. in case anyone wanted to know.

App.config:

    &lt;configuration&gt;
        &lt;configSections&gt;
            &lt;sectionGroup name=&quot;FileCheckerConfigGroup&quot;&gt;
              &lt;section name=&quot;FBI&quot; type=&quot;System.Configuration.NameValueSectionHandler&quot; /&gt;
              &lt;section name=&quot;FSCS&quot; type=&quot;System.Configuration.NameValueSectionHandler&quot; /&gt;
            &lt;/sectionGroup&gt;
        &lt;/configSections&gt;
        &lt;FileCheckerConfigGroup&gt;
            &lt;FSCS&gt;
                &lt;add key=&quot;processingDirectory&quot; value=&quot;C:\testfiles\ProccesFolder&quot;/&gt;
            &lt;/FSCS&gt;
            &lt;FBI&gt;
                &lt;add key=&quot;processingDirectory&quot; value=&quot;C:\testfiles\ProccesFolder&quot;/&gt;
            &lt;/FBI&gt;
        &lt;/FileCheckerConfigGroup&gt;
    &lt;/configuration&gt;

Code:

    // Get the application configuration file. 
    System.Configuration.Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);

    // Get the collection of the section groups. 
    ConfigurationSectionGroupCollection sectionGroups = config.SectionGroups;

    foreach (ConfigurationSectionGroup sectionGroup in sectionGroups)
    {
        if (sectionGroup.Name == &quot;FileCheckerConfigGroup&quot;)
        {
            foreach (ConfigurationSection configurationSection in sectionGroup.Sections)
            {
              var section = ConfigurationManager.GetSection(configurationSection.SectionInformation.SectionName) as NameValueCollection;
              inputDirectory = section[&quot;inputDirectory&quot;]; //&quot;C:\\testfiles&quot;;
            }
        }
    }

How do you use sections in c# 4.0 app.config?

I have added a setting to my config.yml file as such:

    app.config:
        contact_email: somebody@gmail.com
        ...

For the life of me, I can&#39;t figure out how to read it into a variable. I tried something like this in one of my controllers:

    $recipient =
    $this-&gt;container-&gt;getParameter(&#39;contact_email&#39;);

But I get an error saying:

&gt; The parameter &quot;contact_email&quot; must be
&gt; defined.

I&#39;ve cleared my cache, I also looked everywhere on the Symfony2 reloaded site documentation, but I can&#39;t find out how to do this.

Probably just too tired to figure this out now. Can anyone help with this?


How do I read configuration settings from Symfony2 config.yml?

My company&#39;s policy frowns upon artifacts downloaded automatically (they have to be approved), so in order to use Maven I need to disable access to Maven&#39;s central repository. 

In other words, I don&#39;t want Maven to attempt **any** downloads from central.

I know how to configure a local repository (networked or not), my idea is using a &quot;blessed&quot; machine to update the local repository.

PS: I could block requests at the proxy/network level, but I&#39;m asking about how to do it with Maven&#39;s configuration.

**UPDATE**
I finally figured out how to do it. In maven&#39;s home, in the `conf` directory is a global `settings.xml`.
You can either set a mirror to `central` that points to some internal server or just override it&#39;s definition.

Disable Maven central repository

I&#39;ve been using log4j for quite a while now and I usually use this at the top of the log4j.xml (probably just like many others and according to Google this is *the* way to do it):

    &lt;!DOCTYPE log4j:configuration SYSTEM &quot;log4j.dtd&quot;&gt;

Obviously this is working, however Eclipse doesn&#39;t provide its context-sensitive help for writing the XML and all. Furthermore, it always shows a warning that it doesn&#39;t find the `log4j.dtd`. Now I&#39;m curious how to fix this.

I tried a few things and these work:

    &lt;!DOCTYPE log4j:configuration SYSTEM &quot;jar:file:/path/.m2/repository/log4j/log4j/1.2.14/log4j-1.2.14.jar!/org/apache/log4j/xml/log4j.dtd&quot;&gt;
    &lt;!DOCTYPE log4j:configuration SYSTEM &quot;http://logging.apache.org/log4j/1.2/apidocs/org/apache/log4j/xml/doc-files/log4j.dtd&quot;&gt;

As you can see from above we&#39;re using Maven. Therefore, I tried this, but it fails:

    &lt;!DOCTYPE log4j:configuration SYSTEM &quot;jar:file:${M2_REPO}/log4j/log4j/1.2.14/log4j-1.2.14.jar!/org/apache/log4j/xml/log4j.dtd&quot;&gt;

Eclipse usually knows how to deal with the classpath variables, but why doesn&#39;t this work? I know that the reference won&#39;t work during runtime, but neither does a simple `log4j.dtd` (if I&#39;m not wrong), so that shouldn&#39;t be a problem.

Can anyone please shed a light on this?

Eclipse: Referencing log4j.dtd in log4j.xml

(I&#39;ve already seen the [H2 database In memory - Init schema via Spring/Hibernate][1] question; it is not applicable here.)

I&#39;d like to know if there&#39;s a setting in H2 that will allow me to auto-create a schema upon connecting to it.  If it helps, I&#39;m only interested in the in-memory case.

H2 supports various semicolon-separated modifiers at the end of the URL, but I didn&#39;t find one for automatically creating a schema.  Is there such a feature?

  [1]: https://stackoverflow.com/questions/1945175/h2-database-in-memory-init-schema-via-spring-hibernate

Can I have H2 autocreate a schema in an in-memory database?

I&#39;ve got a H2 database with URL `&quot;jdbc:h2:test&quot;`. I create a table using `CREATE TABLE PERSON (ID INT PRIMARY KEY, FIRSTNAME VARCHAR(64), LASTNAME VARCHAR(64));`. I then select everything from this (empty) table using `SELECT * FROM PERSON`. So far, so good.

However, if I change the URL to `&quot;jdbc:h2:mem:test&quot;`, the only difference being the database is now in memory only, this gives me an `org.h2.jdbc.JdbcSQLException: Table &quot;PERSON&quot; not found; SQL statement: SELECT * FROM PERSON [42102-154]`. I&#39;m probably missing something simple here, but any help would be appreciated.

H2 in-memory database. Table not found

Is there a way to browse the content of an H2 or an HSQLDB in-memory database for viewing? For example, during a debugging session with Hibernate in order to check when the flush is executed; or to make sure the script that instantiates the DB gives the expected result.

Does it exist an addon or a library that you can embed with your code in order to allow this?

Please, mention which one you&#39;re talking about (H2 or HSQLDB) in case you have an answer specific to one of them.

View content of H2 or HSQLDB in-memory database

I am trying to use the H2 database from a Java application. 

I created the database and its tables through the H2 Console and then I try to connect from Java using 

    Connection con = DriverManager.getConnection(&quot;jdbc:h2:~/dbname&quot;, &quot;username&quot;, &quot;password&quot;);

However I receive the following error:

&gt; Exception in thread &quot;main&quot; org.h2.jdbc.JdbcSQLException: Database may be already in use: &quot;Locked by another process&quot;. Possible solutions: close all other connection(s); use the server mode [90020-161]

I  tried to delete the `dbname.lock.db` file but it is automatically re-created.

How can I unlock the database to use it from my Java program?

H2 database error: Database may be already in use: &quot;Locked by another process&quot;

I&#39;m setting up a new version of my application in a demo server and would love to find a way of resetting the database daily. I guess I can always have a cron job executing drop and create queries but I&#39;m looking for a cleaner approach. I tried using a special persistence unit with drop-create approach but it doesn&#39;t work as the system connects and disconnects from the server frequently (on demand).

Is there a better approach?

Content Type	Original Author	Original Content on Stackoverflow
Question	Maxime ARNSTAMM	View Question on Stackoverflow
Solution 1 - Java	viktortnk	View Answer on Stackoverflow
Solution 2 - Java	darioo	View Answer on Stackoverflow

problem with INIT=RUNSCRIPT and relative paths

Java Problem Overview

Java Solutions

Solution 1 - Java

Solution 2 - Java

Why doesn't exec work in a function with a subfunction?

How do I reference the input of an HTML <textarea> control in codebehind?

Attributions