Please discuss the pros and cons of storing a file and its meta data in the
database vs file in the filesystem and the metadata in the database.
File + Metadata in DB
1. Can participate in transaction.
2. Does not get out of sync.
3. Overhead of fetching the file.
File in Filesystem and Metadata
[LogicEngineBean] java.sql.SQLException: General error: Got error -30996
from table handler
[LogicEngineBean] at
org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:498)
[LogicEngineBean] at
org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:551)
[LogicEngineBean] at
org.gjt.mm.m
Subject: BDB Table / JDBC Problems
> OS: Windows 2000 Professional
> MySQL: 3.23.38-max
> Tables: BDB.
> Driver: mm 2.0.4
> AppServer: JBOSS 2.2.2 with Tomcat 3.2.2
>
> Has anyone seen this problem? It happens after running my stuff for about
3
> minutes - 3 minutes of select and update statem