1 Reply Latest reply on Sep 5, 2002 2:00 AM by Anthony Ikeda

    How to setup PointBase as a DataSource

    Mikkel Heisterberg Newbie

      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.