java - node to traverse cannot be null SQL SELECT -

i have problem query in hql sql base has databases , need put query take table @ bottom, sql base starts in database 'database' , must refer database webproduction wrote query :

@entity @table(name="file") @namedqueries(          {             @namedquery(name="file.alllist",                     query = "use webproduction select * file")         } ) 

my config:

<hibernate-configuration>     <session-factory>         <property name="hibernate.dialect">org.hibernate.dialect.sqlserverdialect</property>         <property name="hibernate.connection.driver_class">com.microsoft.sqlserver.jdbc.sqlserverdriver</property>         <property name="hibernate.connection.url">jdbc:sqlserver://10.11.1.05</property>         <property name="hibernate.connection.username">sa</property>         <property name="hibernate.connection.password"></property>          <property name="hibernate.show_sql">true</property>         <property name="hibernate.format_sql">true</property>          <!-- <mapping class="entity.sell" /> -->         <mapping class="entity.file" />      </session-factory> </hibernate-configuration> 

my class hibernate:

public class hibernateutil {     private static final sessionfactory sessionfactory;      static {         try {              sessionfactory = new annotationconfiguration().configure(                     "config/sql_hibernate.cfg.xml").buildsessionfactory();         } catch (throwable ex) {              system.err.println("initial sessionfactory creation failed." + ex);             throw new exceptionininitializererror(ex);         }     }      public static sessionfactory getsessionfactory() {         return sessionfactory;     } } 

my method:

public list<file> getfile() throws exception{         session = hibernateutil.getsessionfactory().opensession();         query = session.getnamedquery("file.alllist");         list<file> list1 = query.list();          session.close();          return list1;     } 

for sql server remove 'use webproduction' named query , use:

jdbc:sqlserver://10.11.1.05;databasename=webproduction

as hibernate.connection.url

see http://www.java2s.com/tutorial/java/0340__database/alistofjdbcdriversconnectionstringdrivername.htm