cosbor11

public static void main(String[] args) throws Exception
{
    WebDatabaseServer server1 = new WebDatabaseServer();
    server1.setWebServicePort(8080);
    server1.setPort(8081);
    String pathToOnyxDB = System.getProperty("user.home") 
                        + File.separatorChar + ".onyxdb" 
                        + File.separatorChar + "sandbox" 
                        + File.separatorChar +"remote-db.oxd";
    

cosbor11

<groupId>com.onyxdevtools.samples</groupId>
<artifactId>onyx-database-server</artifactId>
<packaging>jar</packaging>

<dependencies>
    
    <dependency>
        <groupId>com.onyxdevtools</groupId>
        <artifactId>onyx-remote-database</artifactId>
        <version>${onyx-database.version}</version>

cosbor11

<!-- Maven Shade Plugin -->
<plugin>
  <groupId>org.apache.maven.plugins</groupId>
  <artifactId>maven-shade-plugin</artifactId>
  <version>2.3</version>
  <executions>
    <execution>
        <phase>package</phase>
        <goals>
            <goal>shade</goal>

cosbor11

for (int i = 0; i < allPlayers.size(); i++)
{
    final Player player = allPlayers.get(i); // retreives the Player when invoked
    System.out.println(player.getFirstName() + " " + player.getLastName());
}

cosbor11

final List<Player> allPlayers = manager.executeLazyQuery(query); //returns LazyQueryCollection

cosbor11

final Query query = new Query(Player.class);

cosbor11

System.out.println("\nPage 2:");

for (final Player player : page2)
{
    System.out.println(player.getLastName() + ", " + player.getFirstName());
}

cosbor11

final List<Player> page2 = manager.executeQuery(query);

cosbor11

query.setFirstRow(query.getFirstRow() + query.getMaxResults());

cosbor11

System.out.println("\nPage 1:");

for (final Player player : page1)
{
    System.out.println(player.getLastName() + ", " + player.getFirstName());
}