I got this error message: Unable to find implementer for database: Pervasive

[puikei.kwan]

I tried to access a Pervasive table, I got a message: "Unable to find implementer for database: Pervasive ..."

Can someone tell me what it means? Does it mean that I've use a
right driver, or Smart Client does not support Pervasive, or something
else?




in server.properties
==============
sql.defaultDatabase: Pervasive
sql.Pervasive.interface.type: DriverManager
sql.Pervasive.driver: com.pervasive.jdbc.v2.Driver
sql.Pervasive.driver.url: jdbc:pervasive://10.100.1.5:1583/MMV8


I have setup CLASSPATH that includes pvjdbc2.jar, pvjdbc2x.jar, jpscs.jar
and put them in C:\SmartClient\smartclientSDK\WEB-INF\lib\ directory.

==========================
=== 2010-06-25 14:50:27,375 [sor3] INFO RequestContext - URL: '/Test.jsp', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.4) Gecko/20100611 Firefox/3.6.4 GTB6 ( .NET CLR 3.5.30729)': Moz (Gecko) with Accept-Encoding header
=== 2010-06-25 14:50:27,421 [sor3] DEBUG LoadISCTag - isomorphicURI not specified in tag, defaulting to: isomorphic/
=== 2010-06-25 14:50:27,437 [sor3] DEBUG XML - Parsed XML from C:\SmartClient\smartclientSDK\examples\shared\ds\mtgrp.ds.xml: 0ms
=== 2010-06-25 14:50:27,578 [sor3] DEBUG PoolableSQLConnectionFactory - Initializing SQL config for 'Pervasive' from system config - using DriverManager: com.pervasive.jdbc.v2.Driver
=== 2010-06-25 14:50:27,578 [sor3] DEBUG PoolableSQLConnectionFactory - com.pervasive.jdbc.v2.Driver lookup successful
=== 2010-06-25 14:50:27,578 [sor3] DEBUG PoolableSQLConnectionFactory - DriverManager fetching connection for Pervasive via jdbc url jdbc:pervasive://10.100.1.5:1583/MMV8
=== 2010-06-25 14:50:27,828 [sor3] DEBUG PoolableSQLConnectionFactory - Returning pooled Connection
=== 2010-06-25 14:50:27,859 [sor3] ERROR LoadDSTag - Exception while attempting to process a loadDS tag.
java.lang.Exception: Unable to find implementer for database: Pervasive - declared to be type: null
at com.isomorphic.sql.SQLDriver.implementerClassForDB(SQLDriver.java:204)
at com.isomorphic.sql.SQLDriver.instance(SQLDriver.java:160)
at com.isomorphic.sql.SQLDataSource.init(SQLDataSource.java:106)
at com.isomorphic.datasource.BasicDataSource.fromConfig(BasicDataSource.java:126)

[Isomorphic]

Look at the other server.properties samples (or use the Admin Console - see the FAQ). You need to specify database.type:

sql.HSQLDB.database.type: hsqldb

As we mentioned in your other thread, Pervasive is not directly supported, so try a few different database settings to see if the SQL statements work with Pervasive.

[puikei.kwan]

Thanks for your reply.

1. Do you know the database type of Pervasive?

sql.Pervasive.database.type: ??

2. If Pervasive is not directly supported, do you
mean that many simple database ODBC operations
like select, delete from, insert into, update
will not be done?

Are you suggesting that I should not continue
working with Pervasive until it is later officially
supported in the future, because I will face
a lot of problems?

Thanks.

[Isomorphic]

We already answered this.

Note that you'll have to pick a database type that is not Pervasive and hope for SQL compatibility - MySQL and SQLServer and DB2 are good ones to try. If you want official Pervasive support, consider Feature Sponsorship.