                        課程
                    
                        /后端開(kāi)發(fā)
                        
                            /Java
                        
                        /Hibernate初探之單表映射

關(guān)于IO的問(wèn)題，為什么結(jié)束了將持久化對(duì)象保存到數(shù)據(jù)庫(kù)最后關(guān)掉了inputstream會(huì)導(dǎo)致錯(cuò)誤。

public?void?testSavePicture()?{
		SimpleDateFormat?sdf?=?new?SimpleDateFormat("yyyy-MM-dd");
		Date?date;
		try?{
			date?=?sdf.parse("1987-04-01");
			Student?s?=?new?Student(0,?"kula",?date);
			File?file?=?new?File("/Users/kk/Desktop/photo/3.pic.jpg");			
			InputStream?in?=?new?FileInputStream(file);
			Blob?image?=?Hibernate.getLobCreator(session).createBlob(in,?in.available());
			s.setPicture(image);
			session.save(s);
			
			//in.close();?如果關(guān)掉輸入流會(huì)報(bào)錯(cuò)。
		}?catch?(ParseException?e)?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace();
		}?catch?(FileNotFoundException?e)?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace();
		}?catch?(IOException?e)?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace();
		}

	}

如果關(guān)閉了輸入流執(zhí)行不成功會(huì)報(bào)以下錯(cuò)誤。

avax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute statement

? ? at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:147)

? ? at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:155)

? ? at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:162)

? ? at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1402)

? ? at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:472)

? ? at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3132)

? ? at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2369)

? ? at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:467)

? ? at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:147)

? ? at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$100(JdbcResourceLocalTransactionCoordinatorImpl.java:38)

? ? at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:221)

? ? at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:68)

? ? at junit.StudentTest.destroy(StudentTest.java:120)

? ? at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

? ? at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

? ? at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

? ? at java.lang.reflect.Method.invoke(Method.java:498)

? ? at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47)

? ? at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)

? ? at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44)

? ? at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:33)

? ? at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:271)

? ? at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:70)

? ? at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50)

? ? at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)

? ? at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)

? ? at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)

? ? at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)

? ? at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)

? ? at org.junit.runners.ParentRunner.run(ParentRunner.java:309)

? ? at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)

? ? at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)

? ? at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)

? ? at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)

? ? at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)

? ? at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)

Caused by: org.hibernate.exception.GenericJDBCException: could not execute statement

? ? at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)

? ? at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)

? ? at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)

? ? at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:207)

? ? at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:45)

? ? at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2934)

? ? at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3434)

? ? at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:89)

? ? at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:560)

? ? at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:434)

? ? at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)

? ? at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)

? ? at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1396)

? ? ... 32 more

Caused by: java.sql.SQLException: Error reading from InputStream java.io.IOException

? ? at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)

? ? at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:896)

? ? at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:885)

? ? at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)

? ? at com.mysql.jdbc.PreparedStatement.readblock(PreparedStatement.java:2664)

? ? at com.mysql.jdbc.PreparedStatement.streamToBytes(PreparedStatement.java:4456)

? ? at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:2190)

? ? at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2052)

? ? at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2009)

? ? at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5094)

? ? at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1994)

? ? at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204)

? ? ... 41 more

Caused by: java.io.IOException: Stream Closed

? ? at java.io.FileInputStream.readBytes(Native Method)

? ? at java.io.FileInputStream.read(FileInputStream.java:255)

? ? at com.mysql.jdbc.PreparedStatement.readblock(PreparedStatement.java:2662)

? ? ... 48 more

可是io不是應(yīng)該在用完后就關(guān)掉嗎。

萌萌噠貓頭鷹

2016-07-03

源自：Hibernate初探之單表映射 3-5

關(guān)注問(wèn)題我要回答

1628

操作

收起

2 回答

萌萌噠貓頭鷹提問(wèn)者
2016-07-04

這個(gè)沒(méi)法解釋取出照片關(guān)閉了io，能正常通過(guò)。

public?void?testGetPicture()?{
		Student?s?=?(Student)?session.get(Student.class,?1);
		Blob?image?=?s.getPicture();
		try?{
			FileOutputStream?out?=?new?FileOutputStream("image/c1py.jpg");
			InputStream?in?=?image.getBinaryStream();
			byte[]?barray?=?new?byte[1024];
			int?bytes;
			while?((bytes?=?in.read(barray,?0,?barray.length))?>?0)?{
				out.write(barray,?0,?bytes);
			}
			out.close();
			in.close();
		}?catch?(FileNotFoundException?e)?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace();
		}?catch?(SQLException?e)?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace();
		}?catch?(IOException?e)?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace();
		}
	}

以上代碼可以執(zhí)行。

0 回復(fù) 有任何疑惑可以回復(fù)我~

收起回答

#1

最終也沒(méi)有

正如一樓的朋友說(shuō)的。 session.save后，還要運(yùn)行transaction.commit(); // 提交事務(wù)，才能把數(shù)據(jù)寫(xiě)入數(shù)據(jù)庫(kù)中你試試把：transaction.commit(); 寫(xiě)在session.save的下一行然后再在下一行寫(xiě)入in.close();就不會(huì)報(bào)錯(cuò)了。而你展示的代碼，是讀取的時(shí)候的操作。沒(méi)有寫(xiě)入操作，所以不需要向數(shù)據(jù)庫(kù)提交事務(wù)。不提交事務(wù)，所以沒(méi)有用到transaction.commit();這個(gè)代碼所以可以直接使用in.close()

2016-08-02 回復(fù) 有任何疑惑可以回復(fù)我~

dinghai
2016-07-04

session保存對(duì)象并不是調(diào)用session.save之后立即寫(xiě)入到數(shù)據(jù)庫(kù)中，而是等待提交事務(wù)的時(shí)候才會(huì)寫(xiě)入到數(shù)據(jù)庫(kù)中

0 回復(fù) 有任何疑惑可以回復(fù)我~

收起回答

舉報(bào)

0/150

提交

取消

Hibernate初探之單表映射

參與學(xué)習(xí) 74804 人
解答問(wèn)題 826 個(gè)

Java持久化框架Hibernate入門教程，掌握Hibernate基本概念

進(jìn)入課程

本課相似問(wèn)答

1 回答為什么會(huì)保存到hibernate數(shù)據(jù)庫(kù)中

2 回答關(guān)于hibernate API訪問(wèn)數(shù)據(jù)庫(kù)創(chuàng)建服務(wù)注冊(cè)對(duì)象問(wèn)題

3 回答如何保持BLOB對(duì)象

1 回答將student類里面的數(shù)據(jù)保存到數(shù)據(jù)庫(kù)里面的時(shí)候為什么這里的sid在數(shù)據(jù)庫(kù)中直接變成了主鍵有沒(méi)有能設(shè)置誰(shuí)成為主鍵的地方

1 回答關(guān)于Test的new對(duì)象問(wèn)題

搜索更多本課相關(guān)問(wèn)答

關(guān)于IO的問(wèn)題，為什么結(jié)束了將持久化對(duì)象保存到數(shù)據(jù)庫(kù)最后關(guān)掉了inputstream會(huì)導(dǎo)致錯(cuò)誤。

我要回答關(guān)注問(wèn)題

使用 Ctrl+D 可將網(wǎng)站添加到書(shū)簽

微信客服

購(gòu)課補(bǔ)貼
聯(lián)系客服咨詢優(yōu)惠詳情

幫助反饋 APP下載

慕課網(wǎng)APP
您的移動(dòng)學(xué)習(xí)伙伴

公眾號(hào)

掃描二維碼
關(guān)注慕課網(wǎng)微信公眾號(hào)

第七色在线视频,2021少妇久久久久久久久久,亚洲欧洲精品成人久久av18,亚洲国产精品特色大片观看完整版,孙宇晨将参加特朗普的晚宴

熱搜

最近搜索清空

關(guān)于IO的問(wèn)題，為什么結(jié)束了將持久化對(duì)象保存到數(shù)據(jù)庫(kù)最后關(guān)掉了inputstream會(huì)導(dǎo)致錯(cuò)誤。

2 回答

本課相似問(wèn)答

關(guān)于IO的問(wèn)題，為什么結(jié)束了將持久化對(duì)象保存到數(shù)據(jù)庫(kù)最后關(guān)掉了inputstream會(huì)導(dǎo)致錯(cuò)誤。

關(guān)于IO的問(wèn)題，為什么結(jié)束了將持久化對(duì)象保存到數(shù)據(jù)庫(kù)最后關(guān)掉了inputstream會(huì)導(dǎo)致錯(cuò)誤。

關(guān)于IO的問(wèn)題，為什么結(jié)束了將持久化對(duì)象保存到數(shù)據(jù)庫(kù)最后關(guān)掉了inputstream會(huì)導(dǎo)致錯(cuò)誤。