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


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

      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

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


      I hope this can help others in the same position.