使用JSP存储/检索BLOB [英] Storing/retrieving BLOBs with JSPs

问题描述

我非常迫切需要（明天）存储文件的方式和

使用TopLink作为中介从Oracle数据库中检索文件。我有
有它的JSP，它适用于小文件，但更大的文件如

Word文档和Excel电子表格给出一个错误，说明数据是

太大了。有人能帮忙吗？我们的文件对象有一个

fileData字段，这是一个字节数组，它在TopLink中映射到数据库的

BLOB字段。正如我所说，它适用于非常小的文件，如

小GIF图像，但对于较大的文件，我相信错误编号是17002，

数据库错误。对不起，我没有更多的细节，但我现在没有

访问该项目。非常感谢任何解决方案/帮助/推动方向

方向


-

Ryan Stewart，A1C USAF

805 CSPTS / SCBE

I am in extremely urgent need (by tomorrow) of a way to store files in and
retrieve files from an Oracle database using TopLink as an intermediary. I
have the JSPs for it, and it works for small files, but larger ones like
Word documents and Excel Spreadsheets give an error saying that the data is
too large for the field. Can anyone help with this? Our file object has a
fileData field which is an array of bytes which is mapped in TopLink to the
BLOB field of the database. As I said, it works for very small files like a
small GIF image, but with larger ones, I believe the error number is 17002,
a database error. I''m sorry I don''t have any more details, but I don''t have
access to the project at the moment. Any solutions/help/nudges in the right
direction are greatly appreciated

--
Ryan Stewart, A1C USAF
805 CSPTS/SCBE

推荐答案

你好，


看起来好吗？喜欢错误，因为文件大小。使用jdbc有一个

max-size来使用jdbc（原始oracle-jdbc驱动程序）。如果你插入了
，如果失败则文件更大并产生错误。我现在还没有？b $ b，但我认为尺寸大约是4M或4K左右。


查看更多信息metalink！


最好的问候

thorsten h？¤s

On Thu，2003年12月11日11:54:29 -0600，Ryan Stewart

< za **** @ no.texas.spam.net>写道：

Hello,

it seem?′s like an error because the file-size. with jdbc there is a
max-size to instert with jdbc (original oracle-jdbc driver). if you
inserted a file was greater if fails and generate an error. i didn?′t now
at the moment, but i think the size is like 4M or 4K or so.

see for more information metalink!

best regards
thorsten h?¤s
On Thu, 11 Dec 2003 11:54:29 -0600, Ryan Stewart
<za****@no.texas.spam.net> wrote:

我非常迫切需要（明天）将文件存储在
中并使用TopLink作为数据从Oracle数据库中检索文件中介。
我有它的JSP，它适用于小文件，但较大的文件，如Word文档和Excel电子表格给出一个错误，说数据
是<对于该领域来说太大了。有人能帮忙吗？我们的文件对象有一个
fileData字段，它是一个字节数组，在TopLink中映射到数据库的BLOB字段。正如我所说，它适用于非常小的文件
像一个小的GIF图像，但是对于较大的文件，我相信错误号是17002，数据库错误。对不起，我没有更多的细节，但我现在还没有访问该项目。非常感谢

方向的任何解决方案/帮助/推动

I am in extremely urgent need (by tomorrow) of a way to store files in
and
retrieve files from an Oracle database using TopLink as an intermediary.
I
have the JSPs for it, and it works for small files, but larger ones like
Word documents and Excel Spreadsheets give an error saying that the data
is
too large for the field. Can anyone help with this? Our file object has a
fileData field which is an array of bytes which is mapped in TopLink to
the
BLOB field of the database. As I said, it works for very small files
like a
small GIF image, but with larger ones, I believe the error number is
17002,
a database error. I''m sorry I don''t have any more details, but I don''t
have
access to the project at the moment. Any solutions/help/nudges in the
right
direction are greatly appreciated

-

使用M2， Opera的革命性电子邮件客户端： http://www.opera.com/m2 /

" Ryan Stewart" < ZA **** @ no.texas.spam.net>在消息中写道

news：TI ******************** @ texas.net ...

"Ryan Stewart" <za****@no.texas.spam.net> wrote in message
news:TI********************@texas.net...

I我非常迫切需要（明天）


碰巧，我不在乎 - 你不是在给我足够的钱给我b $ b。 >

将来，请不要交叉发布

如此广泛。你不是那么重要，

相信我。

..一种存储文件的方法，并使用TopLink作为中介从Oracle数据库中检索文件。我有它的JSP，


对你有好处。您如何期望其他人为您调试它们？心灵感应？

..它适用于小文件，但较大的文件如Word文档和Excel电子表格会出错，表示数据
对于该字段来说太大了。


什么字段？

..任何人都可以帮忙吗？


唯一这个绝对的服务器端菜鸟

可以建议那些不提供

代码的人，免费，是...


也许你正在获取数据而不是发布它的
。 ..但是..

..我们的文件对象有一个
fileData字段，它是一个字节数组，在TopLink中映射到
数据库的BLOB字段。正如我所说，它适用于非常小的文件，比如
一个小的GIF图像，但是对于较大的文件，我相信错误编号是
17002，这是一个数据库错误。


这个数字听起来太大了，我觉得''得到'的价格只有很小的尺寸。

..对不起，我没有更多细节，但我现在还没有进入该项目。


请参阅第一条评论。

..非常感谢任何解决方案/帮助/推动方向

I am in extremely urgent need (by tomorrow)
As it happens, I don''t care - you are not
paying me enough.

And in future, please do not cross-post
so widely. You are not that important,
trust me.
..of a way to store files in and
retrieve files from an Oracle database using TopLink as an intermediary. I
have the JSPs for it,
Good for you. Just how do you expect
others to debug them for you? Telepathy?
..and it works for small files, but larger ones like
Word documents and Excel Spreadsheets give an error saying that the data is too large for the field.
What field?
..Can anyone help with this?
The only thing this absolute server-side noob
can suggest to somebody that does not supply
code, for free, is..

Maybe you are ''getting'' the data rather than
posting it. ..but..
..Our file object has a
fileData field which is an array of bytes which is mapped in TopLink to the BLOB field of the database. As I said, it works for very small files like a small GIF image, but with larger ones, I believe the error number is 17002, a database error.
That number sounds too large, I thought ''get''s were
limited to much smaller sizes than that.
..I''m sorry I don''t have any more details, but I don''t have
access to the project at the moment.
See first comment.
..Any solutions/help/nudges in the right
direction are greatly appreciated

我必须付出的，你有... ..


-

Andrew Thompson
* http://www.PhySci.org/ PhySci软件套件

* http://www.1point1C.org/ 1.1C - Superluminal！

* http：//www.AThompson .info / andrew / 个人网站

The ones I have to give, you''ve got..

--
Andrew Thompson
* http://www.PhySci.org/ PhySci software suite
* http://www.1point1C.org/ 1.1C - Superluminal!
* http://www.AThompson.info/andrew/ personal site

" Andrew Thompson" <一个****** @ bigNOSPAMpond.com>在留言新闻中写道：< wN ****************** @ news-server.bigpond.net.au> ...


[snip]

"Andrew Thompson" <an******@bigNOSPAMpond.com> wrote in message news:<wN******************@news-server.bigpond.net.au>...

[snip]

碰巧，我不在乎 - 你不是在给我足够的钱。

以后，请不要交叉发布如此广泛。你不是那么重要，相信我。


[snip]

对你有好处。您如何期望其他人为您调试它们？心灵感应？

As it happens, I don''t care - you are not
paying me enough.

And in future, please do not cross-post
so widely. You are not that important,
trust me.

[snip]

Good for you. Just how do you expect
others to debug them for you? Telepathy?

Geez，你能成为一名傻瓜吗？

[snip]

Geez, could you be any more of a jackass?
[snip]

..非常感谢任何解决方案/帮助/推动方向

..Any solutions/help/nudges in the right
direction are greatly appreciated

我必须给予的，你'已经......

The ones I have to give, you''ve got..

毕竟你甚至无法提供帮助。

以后请不要发帖

你不能帮忙。你不是那么重要，

相信我。

After all that you can''t even help.
And in future, please do not post if
you can''t help. You are not that important,
trust me.

这篇关于使用JSP存储/检索BLOB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！