JDataStore Server
| Код |
package jdserver;
import com.borland.datastore.jdbc.DataStoreServer;
public class JDServer {
DataStoreServer jdsServer = new DataStoreServer();
......
private void ServerStart() throws Exception {
jdsServer.setPort(2508);
jdsServer.setReportConnectError(true);
jdsServer.setReportConnect(true);
jdsServer.start();
}
}
|
Code StoredProcedures
| Код |
package jdserver;
import java.sql.*;
public class StoredProcedures {
public static void Test(java.sql.Connection con) throws Exception {
java.sql.Statement stmt = con.createStatement();
stmt.executeQuery("INSERT INTO DEFAULT_SCHEMA.TEST1(S1,S2,S3) VALUES(1,'TEST',TRUE)");
}
}
|
CREATE METHOD
| Код |
CREATE JAVA_METHOD TEST AS 'jdserver.StoredProcedures.Test';
|
и вызов процедуру
| Код |
Class.forName("com.borland.datastore.jdbc.DataStoreDriver");
Connection c = DriverManager.getConnection("jdbc:borland:dsremote://192.168.0.6/C:/Java/java.jds", "sysdba", "masterkey");
Statement s = c.createStatement();
s.executeQuery("CALL TEST()");
|
Ошыбка
| Код |
com.borland.platform.datastore.driver.DriverException: Runtime Error: [line 1, col 6] Query didn't produce a resultset
|
|