JDBC Driver for Sage 50 UK

Build 23.0.8839


You can use the DatabaseMetaData interface to retrieve stored procedure information. The getProcedures method returns descriptions of the available stored procedures.

The following code retrieves the names of the available stored procedures:

String connectionString = "jdbc:sage50uk:URL=http://localhost:5493/sdata/accounts50/GCRM/{C4C863BE-B098-4A7D-A78B-D7A92B8ADB59};User=Manager;Password=xxxxxx;";

Connection conn = DriverManager.getConnection(connectionString);
DatabaseMetaData meta = conn.getMetaData();
ResultSet rs = meta.getProcedures(null, null, "%");
The getProcedures method returns the following columns:

Column NameData TypeDescription
PROCEDURE_CATStringThe catalog the procedure belongs to.
PROCEDURE_SCHEMStringThe schema the procedure belongs to.
PROCEDURE_NAMEStringThe stored procedure name.
REMARKSStringThe description of the stored procedure.
PROCEDURE_TYPEshortReturns 2 if the procedure returns a result. Returns 1 if the procedure does not return a result. Returns 0 if unknown.
SPECIFIC_NAMEStringThe name that uniquely identifies the stored procedure within its schema.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839