java - actian JCL 示例

Question

有人有使用 Actian 的 JCL 将数据检索到 Java 中松散耦合的普适数据库的示例吗？我连接的数据库只有 DAT 文件。我的目标是在 Pervasive 和 MS SQL 之间建立联系。

我不是在寻找免费赠品，而是在寻找能为我指明正确方向的人，以便我能够学习和成长。

提前谢谢您!

Answer 1

在我的文件中找到了这个。不知道什么时候写的，是否有效，是否还支持这个接口(interface)。你没有说你正在使用什么版本的 PSQL，所以我什至不知道这是否适用于你的版本。

import pervasive.database.*;

public class VersionTest implements Consts
{
public VersionTest()
{
try
{
Session session = Driver.establishSession(); 
Database db = session.connectToDatabase("PMKE:"); 
XCursor xcursor = db.createXCursor(57000); 
//Using local TABL.DAT (length 255 assures no leftovers!)
xcursor.setKZString(0,255,"plsetup\\tabl.dat");
//Open the file to load local MKDE
int status = xcursor.BTRV(BTR_OPEN);
System.out.println("Local Open status: " + status);
//Using remote TABL.DAT (length 255 assures no leftovers!)

xcursor.setKZString(0,255,"h:\\basic2c\\develop\\tabl.dat");
//set the buffer size
xcursor.setDataSize(15);
//get version 
status = xcursor.BTRV(BTR_VERSION);
System.out.println("Version status: " + status);
// should be 15, always prints 5
System.out.println("Version length: " + xcursor.getRecLength());
System.out.println("Version: " + xcursor.getDString(0,15));

// try with an open file on a server
XCursor xcursor2 = db.createXCursor(57000); 
//Using remote TABL.DAT (length 255 assures no leftovers!)

xcursor2.setKZString(0,255,"h:\\basic2c\\develop\\tabl.dat");
//Open the file
status = xcursor2.BTRV(BTR_OPEN);
System.out.println("Remote Open status: " + status);
//set the buffer size
xcursor2.setDataSize(15);
//get version 
status = xcursor2.BTRV(BTR_VERSION);
System.out.println("Version status: " + status);
// should be 15, always prints 5
System.out.println("Version length: " + xcursor2.getRecLength());
System.out.println("Version: " + xcursor2.getDString(0,15));

// clean up resources 
Driver.killAllSessions();
}catch(Exception exp)
{
exp.printStackTrace();
}
}
public static void main(String[] args) 
{
new VersionTest();
}
}