Scribd
Upload
20 views2 pages

Azure Scripts Dataload

DbSchema is a Pervasive client that connects to Pervasive databases using JDBC drivers. It includes the Pervasive JDBC driver so no additional download is needed. The JDBC URL contains information about the database host, port, and name. DbSchema makes it easy to set up a connection by generating the correct JDBC URL. Users can download DbSchema, select Pervasive as the database, and enter connection details to test connectivity to a Pervasive database.

Uploaded by

cloudtraining2023
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
20 views2 pages

Azure Scripts Dataload

DbSchema is a Pervasive client that connects to Pervasive databases using JDBC drivers. It includes the Pervasive JDBC driver so no additional download is needed. The JDBC URL contains information about the database host, port, and name. DbSchema makes it easy to set up a connection by generating the correct JDBC URL. Users can download DbSchema, select Pervasive as the database, and enter connection details to test connectivity to a Pervasive database.

Uploaded by

cloudtraining2023
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 2

DbSchema

FEATURES
DATABASES
EDITIONS
DOCS
BLOG
SUPPORT
PERVASIVE JDBC DRIVER & HOW TO CONNECT
DbSchema is connecting to Pervasive using JDBC Drivers.

What are JDBC Drivers


What is the JDBC URL
Download the Pervasive JDBC Driver
How to Connect using the DbSchema Pervasive
What are JDBC Drivers?
JDBC drivers are Java library files with the extension '.jar', used by Java
applications to connect to the database. Usually they are provided by the same
company which developed the database software. DbSchema is an Pervasive Client
which already includes the Pervasive JDBC driver. DbSchema can configure the
Pervasive JDBC URL and test the connectivity.

What is the JDBC URL?


The URL is a string (text) with a specific format containing information about the
host where the database is running, the port, username, database name, etc. The URL
format is specific to each driver. Any wrong character in the URL may make the
database connectivity fail. Therefore we recommend installing DbSchema and try to
get connected, and you will find the JDBC URL in the connection dialog.

Driver Information
Required File(s): pvjdbc2.jar
Java Driver Class: com.pervasive.jdbc.v2.Driver
URL: jdbc:pervasive://HOST:PORT/DB
Website: Pervasive

The driver files are compressed in a zip file.

for any issues with the driver, you can write to us.

Connect to Pervasive using DbSchema


DbSchema is using JDBC Drivers to connect to the database. Installing the
application you can easy set up a connection. DbSchema will build the JDBC URL for
you.
1Download DbSchema. DbSchema has a free community edition. No email or registration
is required.
2Choose to connect to the database, and choose Pervasive.Connect to database
3Connection-dialog
At this point, DbSchema already downloads the JDBC driver into this folders:

C:\Users\YourUser\.DbSchema\drivers\Pervasive (Windows) or
/Users/YourUser/.DbSchema/drivers/Pervasive (Linux and MacOS).
In the Connection Dialog, select the driver and the JDBC URL template. For
databases using multiple possibilities to connect, may exists multiple templates.
Choose if the database is running on the current machine or a different port. If is
running on a different machine (remote), you need to find the host name. Hover the
Host info label using the mouse to get instructions.

4Press the Ping button to test the connectivity.


5Edit JDBC URLIn the URL combo there is an option to 'Manually Edit the URL'.
Select this option to see the generated JDBC URL.
6DbSchema LayoutsAfter connecting, DbSchema will create the first diagrams
(layouts). Double-click any table header or column to edit.
7SQL EditorActivate the SQL Editor from the menu to edit and execute queries. For a
detailed list of features, please read the DbSchema Quick Tour.
Get our latest news by subscribing to our newsletter
Email Address

You might also like