How to setup PointBase as a DataSource

[lekkim]

After spending quite some time trying to configure PointBase server database under JBoss 2.4.2 I want to share my findings...

PointBase has a configuration file called PointBase.ini that tells the PointBase JDBC driver where it can find the database files. This path may be supplied as an attribute to the JVM at runtime (-Dpointbase.ini=<path to pointbase.ini>/pointbase.ini).

The problem is that the attributes tag in the DataSource configuration in jboss.jcml doesn't seems to work. To corerctly supply this parameter I supplied the parameter to the JVM in the run.bat / run.sh file (I added the %POINTBASE% variable to the mix):

@echo off
@if not "%ECHO%" == "" echo %ECHO%
@if "%OS%" == "Windows_NT" setlocal

set JBOSS_CLASSPATH=%JBOSS_CLASSPATH%;run.jar

REM Add all login modules for JAAS-based security
REM and all libraries that are used by them here
set JBOSS_CLASSPATH=%JBOSS_CLASSPATH%

REM Add the XML parser jars and set the JAXP factory names
REM Crimson parser JAXP setup(default)
set JBOSS_CLASSPATH=%JBOSS_CLASSPATH%;../lib/crimson.jar
set JAXP=-Djavax.xml.parsers.DocumentBuilderFactory=org.apache.crimson.jaxp.DocumentBuilderFactoryImpl
set JAXP=%JAXP% -Djavax.xml.parsers.SAXParserFactory=org.apache.crimson.jaxp.SAXParserFactoryImpl
set POINTBASE=-Dpointbase.ini=d:\Programming\Pointbase42\bin\pointbase.ini

echo JBOSS_CLASSPATH=%JBOSS_CLASSPATH%
java %JAXP% %POINTBASE% -classpath "%JBOSS_CLASSPATH%" org.jboss.Main %1 %2 %3 %4 %5 %6 %7 %8 %9

pause

I hope this can help others in the same position.

[[tone]]

Hi Lekkim,
Could you tell me how to set up the jboss config files for pointbase in JBoss 3?

I can't seem to work out precisley how this is done.

Cheers,
Anthony