dbms_java 包不存在_数据库查询直接在DBMS上工作但不在Java中

我在尝试使用“Staging Processor”处理Ingest到

KIT DataManager(

Code on GitHub,它在tomcat7上运行)之前做的事情……

添加自定义临时处理器

package edu.kit.dama.mdm.content.mets;

…

public class TryQuota extends AbstractStagingProcessor {

…

@Override

public final void performPreTransferProcessing(TransferTaskContainer pContainer) throws StagingProcessorException {

…

试图获取用户数据

……这很有效

UserData userResult = null;

try {

userResult = mdm.findSingleResult(

"Select u FROM UserData u WHERE u.email=?1",

new Object[]{"dama@kit.edu"},

具有用户ID 1的管理员用户的标准电子邮件

UserData.class

);

} catch (UnauthorizedAccessAttemptException e2) {

System.out.println("exception on extracting userid");

e2.printStackTrace();

}

try {

System.out.println("KIT DM ID: " + userResult.getUserId());

}catch(Exception e4) {

System.out.println("exception on output for userid");

e4.printStackTrace();

}

试图从UserQuota获得配额

而另一方面,相应的实现不在这里工作(我想要工作)

Number UserQuota = null;

try {

UserQuota = mdm.findSingleResult(

//SQL would be: "SELECT quota FROM userquota WHERE uid=?;"

//JPQL is …

"Select q.quota FROM UserQuota q WHERE q.uid=?1",

new Object[]{1},

Number.class

);

} catch (UnauthorizedAccessAttemptException e2) {

System.out.println("exception on userquota");

e2.printStackTrace();

}

System.out.println("quota is: " + UserQuota );

UserQuota在此处仍为null

DB是PostgreSQL,表是：

CREATE SEQUENCE userquota_seq

START WITH 1

INCREMENT BY 1

NO MAXVALUE

NO MINVALUE;

CREATE TABLE userquota

(

id INTEGER NOT NULL DEFAULT nextval('userquota_seq'),

uid INTEGER NOT NULL DEFAULT 0,

quota DECIMAL NOT NULL DEFAULT 0,

CONSTRAINT uid_key UNIQUE (uid),

CONSTRAINT fk_uid FOREIGN KEY (uid) REFERENCES users(id)

);

我希望从处理器中的db获取此配额

INSERT INTO userquota (id, uid,quota) VALUES ( 0, 1, 1048576 );

所以主要是我想从db：1048576作为Long获取摄取用户(这里是1)的条目.

任何提示欢迎如何继续这些事情.