Ребят, мое положение заставляет обратиться к вам за помощью в отдельной теме (после поиска решения в интернете и на sql.ru в частности).
Затея: вызвать MS SQL 2008 процедуру с помощью Hibernate 4 и вывести (обработать) два возвращаемых ей значения на экран.
Процедура:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
CREATE PROCEDURE [dbo].[PRODUCT_CREATE](
@ReturnValue INT output,
@ProductID INT output,
@PassID numeric(18,0),
@Amount numeric(18,2))
as
BEGIN
print 'PassID = ' + convert(varchar, @PassID);
print 'Amount = ' + convert(varchar, @Amount);
select @ReturnValue = 999999,
@ProductID = 777777;
END;
Mapping:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<sql-query name="PRODUCT_CREATE" callable="true">
<return-scalar column = "ReturnValue" type="int"/>
<return-scalar column = "ProductID" type="int"/>
<![CDATA[{CALL PRODUCT_CREATE (:ReturnValue,
:ProductID,
:PassID,
:Amount
)}]]>
</sql-query>
</hibernate-mapping>
Main class:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
package app;
import java.math.BigInteger;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.transform.Transformers;
public class App {
public static void main(String[] args) {
App.createProduct();
}
public static BigInteger createProduct()
{
/**
* Open session and begin database transaction for database operation.
*/
SessionFactory sf = HibernateUtil.createSessionFactory();
Session session = sf.openSession();
Query qr = session.getNamedQuery("PRODUCT_CREATE");
qr.setParameter("ReturnValue", 0);
qr.setParameter("ProductID", 0);
qr.setParameter("PassID", new BigInteger("1000999"));
qr.setParameter("Amount", new BigInteger("1000001"));
@SuppressWarnings("unchecked")
/*Вот тут возникает ошибка*/
List<ProductModel> list = qr.setResultTransformer(Transformers.aliasToBean(ProductModel.class)).list();
for(int i=0; i<list.size(); i++){
ProductModel prd = (ProductModel)list.get(i);
System.out.println(String.valueOf(prd.getCardId()));
}
session.getTransaction().commit();
session.close();
return null;
}
}
Установка соединения:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
package app;
import org.hibernate.SessionFactory;
import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;
public class HibernateUtil {
private static SessionFactory sessionFactory;
private static ServiceRegistry serviceRegistry;
/**
* Create hibernate configuration.
*/
Configuration c = new Configuration().configure("/resources/hibernate.cfg.xml");
public static SessionFactory createSessionFactory() {
try
{
Configuration configuration = new Configuration();
configuration.configure();
serviceRegistry = new StandardServiceRegistryBuilder().applySettings(
configuration.getProperties()).build();
sessionFactory = configuration.buildSessionFactory(serviceRegistry);
return sessionFactory;
} catch (Throwable ex) {
// Make sure you log the exception, as it might be swallowed
System.out.print("Initial SessionFactory creation failed." + ex);
throw new ExceptionInInitializerError(ex);
}
}
}
Модель возвращаемого объекта:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
package app;
public class ProductModel {
private int ReturnValue;
private int ProductID;
public ProductModel(int returnValue, int productID) {
super();
ReturnValue = returnValue;
ProductID = productID;
}
public int getReturnValue() {
return ReturnValue;
}
public void setReturnValue(int returnValue) {
ReturnValue = returnValue;
}
public int getProductID() {
return ProductID;
}
public void setProductID(int productID) {
ProductID = productID;
}
}
Hibernate конфиг:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
<property name="connection.url">jdbc:sqlserver://.......</property>
<property name="connection.username">user</property>
<property name="connection.password">pass</property>
<property name="connection.pool_size">10</property>
<property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
<property name="show_sql">true</property>
<property name="hibernate.connection.autocommit">true</property>
<!--<property name="current_session_context_class">thread</property> -->
<mapping resource="app/PRODUCT_CREATE.hbm.xml"></mapping>
</session-factory>
</hibernate-configuration>
POM:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
<properties>
<java.version>1.8</java.version>
<jdk.version>1.8</jdk.version>
<hibernate.version>4.3.8.Final</hibernate.version>
<hibernate.jpa.version>1.0.0.Final</hibernate.jpa.version>
</properties>
<dependencies>
<!--Hibernate-->
<dependency>
<groupId>org.hibernate.javax.persistence</groupId>
<artifactId>hibernate-jpa-2.1-api</artifactId>
<version>${hibernate.jpa.version}</version>
</dependency>
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-entitymanager</artifactId>
<version>${hibernate.version}</version>
</dependency>
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>sqljdbc4</artifactId>
<version>4.0</version>
</dependency>
</dependencies>
При выполнении программы возникает ошибка:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
Exception in thread "main" java.lang.NullPointerException
at org.hibernate.loader.Loader.processResultSet(Loader.java:950)
at org.hibernate.loader.Loader.doQuery(Loader.java:921)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)
at org.hibernate.loader.Loader.doList(Loader.java:2554)
at org.hibernate.loader.Loader.doList(Loader.java:2540)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)
at org.hibernate.loader.Loader.list(Loader.java:2365)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:353)
at org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:1873)
at org.hibernate.internal.AbstractSessionImpl.list(AbstractSessionImpl.java:311)
at org.hibernate.internal.SQLQueryImpl.list(SQLQueryImpl.java:141)
at app.App.createProduct(App.java:46)
at app.App.main(App.java:16)
Помогите ее исправить и вывести в консоль два возвращаемых процедурой параметра?
