FirstSQL/J Enterprise Server is a general purpose Object/Relational DBMS, implemented in 100% Java, portable to a wide range of systems from embedded/mobile devices to mainframes. It is a complete J2EE RDBMS including support for Datasources, Connection Pooling and XA. It also provides both JCA 1.0 and 1.5 capabilities. FirstSQL/J Server is compliant with standards, supporting SQL 92, JDBC 3, ODBC 3, JTA/XA and JCA. Its extensions include:
|This page assumes you are using the Atomikos distribution of FirstSQL 2.75, located in the folder /included of the Atomikos download.|
java -jar firstsqljentx_xx.jar
Executing the jar runs the FirstSQL/J Enterprise Setup Utility. The utility is a Java AWT application and is compatible with JDK 1.1. For additional information on running the FirstSQL/J Enterprise Setup, see the readme.txt file in jar file. Use the Java jar utility to extract readme.txt, or any zip file utility (jars are zip-compatible.)
|You need to run the jar command twice, once to install the server and a second time to install the client (with JDBC drivers).|
> ./StartupJ2EE.sh FirstSQL/J Enterprise Server 2.75 Copyright 2002-2004 FirstSQL, Inc. <8000> Started Server Startup complete
Note: use the corresponding .bat file on Windows systems.
> ./Shutdown.sh FirstSQL/J Enterprise Shutdown 2.75 Copyright 2002-2004 FirstSQL, Inc. Shutting down server at dbcp://localhost:8001 Shutdown accepted.
> ./StartupJ2EE.sh FirstSQL/J Enterprise Server 2.75 Copyright 2002-2004 FirstSQL, Inc. Start <8000> fails : Recovery Required Unable to start any ports Shutdown failure : Unable to performIn that case, just add -r, i.e. invoke StartupJ2EE -r to enforce recovery:
> ./StartupJ2EE.sh -r FirstSQL/J Enterprise Server 2.75 Copyright 2002-2004 FirstSQL, Inc. <8000> Started Server Startup complete
AtomikosDataSourceBean ds = new AtomikosDataSourceBean(); ds.setXaDataSourceClassName ( "COM.FirstSQL.Dbcp.DbcpXADataSource" ); ds.getXaProperties().setProperty("user", "demo"); ds.getXaProperties().setProperty("portNumber", "8000"); ds.setUniqueResourceName ( "FirstSqlDemo" );email@example.com. The web home for FirstSQL is http://www.firstsql.com. For sales, contact firstname.lastname@example.org.