Announcement

**Isomorphic** · 6 Feb 2016, 02:30

Your log suggests the hsqlserver.properties file included in the sample project is missing from the CLASSPATH.

Aside from this, the HSQL server we include with sample projects is a simple embedded database that only works with one JVM and writes to files. It's used purely so that you do not have to set up a separate database server in order to try out samples that demonstrate SQL database operations. Glassfish or not, HSQL is not a typical production deployment option.

**carlossierra** · 6 Feb 2016, 05:53

Thanks for your help.

I agree that this would seem to be the case, but the hsqlserver.properties file is correctly placed under WEB-INF\classes (in the Eclipse project I have it right under src, as it is originally in the sample file, and when compiled, it gets properly written to the classes folder). Any ideas why the app would seem to not being able to use that file?

Regarding your other comment, I do agree that for a big production app it would be better to look for other choices, but I've read a lot of comments across the web that do recommend HSQL for small projects like mine because performance is good and it certainly seems to be easier to maintain. Anyway, you make a valid point to keep in mind if the app starts to grow. Still, this setup should work correctly, right?

**Isomorphic** · 6 Feb 2016, 08:58

That sounds like the right place for the file, nevertheless it is obviously not being loaded, so you should troubleshoot whether the WEB-INF/classes folder you've placed the file in is actually in the CLASSPATH, readable by the server process, etc.

As far as HSQL vs other DBs, outside of the embedded use case, we don't really know of an advantage that HSQL has over other free, stable databases such as MariaDB. In particular, Isomorphic does not use HSQL outside of the embedded use case of our SDK, despite our familiarity with it.

Even if you choose to use HSQL, there doesn't seem to be a good reason to run it inside the same JVM as your application (it can also run standalone), especially since you seem to be having trouble correctly deploying it in that scenario.

**carlossierra** · 19 Feb 2016, 22:48

Hi Isomorphic. So, after a lot of rework (being a newbie to all this), I followed your advice and changed my persistence strategy to use SQL Server. I configured my Glassfish environment with the proper JDBC resource (which has a JDBC connection pool properly configured and passing Glassfish's ping test), I put the proper driver in my Glassfish domain lib folder, and I put the following settings in my server.properties file:

Code:

sql.defaultDatabase: SQLServer

sql.SQLServer.database.type: sqlserver
sql.SQLServer.driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
sql.SQLServer.driver.databaseName: BMSim
sql.SQLServer.interface.type: jndi
sql.SQLServer.driver.name: jdbc/BMSim

I thought I was on the right track, because after launching the app, I could go into the Admin Console and in the DataBase configuration tab I could get this (default) SQLServer database to pass the test, I was able to browse the related DB contents in the SQL Browser, and when I went to the Import DataSources tab, I could see my users.ds.xml file being properly read and showing all my users table records in the bottom pane. Here is my users.ds.xml file:

Code:

<DataSource 
    ID="users" 
    serverType="sql" 
    tableName="users" 
>
    <fields>
    
        <field name="username" primaryKey="true" canSave="false"></field>
        
        <field name="password">
            <validators>
                <validator type="lengthRange" min="6"></validator>
                <validator type="lengthRange" max="20"></validator>
            </validators>
        </field>        
        
        <field name="language">
            <valueMap>
                <value id="en">English</value>
                <value id="es">Spanish</value>
            </valueMap>
        </field>
        
    </fields>
</DataSource>

But when I tried to add the following simple ListGrid to my entry point class in order to use that data source to show some data:

Code:

DataSource ds = DataSource.get("users");
ListGrid grid = new ListGrid();
grid.setDataSource(ds);
grid.draw();

...all I got was a white screen. In the developer console, in the Watch tab, the ListGrid control says that it is drawn and visible, but all I see is white space in the place it's supposed to be.

Can you please help me pinpoint what can be happening here? I think I must be missing something really simple here, but I just can't get to figure it out.

Thanks in advance for any help!!

**Isomorphic** · 19 Feb 2016, 23:07

The set of symptoms you describe is basically not possible without a JavaScript error, so use the tools built into your browser (generally on Windows, press F12) to see what the error was.

One possibility - did you load the DataSource into the page? If you don't understand what this means, please see the QuickStart Guide.

**carlossierra** · 20 Feb 2016, 09:38

Turns out I was adding an additional "/" at the beginning of my <script> tag: <script src="/bmsim/sc/DataSourceLoader?dataSource=users"></script>. As mentioned by Isomorphic, the error was clearly shown in Chrome's Developer Tools' console. Fixed it to be <script src="bmsim/sc/DataSourceLoader?dataSource=users"></script>.

And then I just added grid.fetchData() before my grid.draw() in the code above, so that the ListGrid would show the actual data. I don't know if this is required, because in the QuickStart Guide the sample on page 23 doesn't includes it, but without it, my ListGrid would show no records.

Anyhow, at last I seem to have it working. So thanks guys for all your help.

In case any other newbie comes here looking for help, I was able to get my app working in Glassfish 4 (GF) and SQL Server 2012 following these steps:

Create your new GF domain. Or you can use the one that comes by default with GF.
Add sqljdbc42.jar to the GF domain lib folder (you can get this directly/freely from here).
Add a JDBC Connection Pool to GF:
- Pool Name: connectionPoolName(can be whatever you like for easy identification).
- Resource Type: javax.sql.DataSource
- Database Driver Vendor: MicrosoftSqlServer
Configure previous JDBC Connection Pool with these additional properties (you can delete all previous properties, if there are any in the list):
- user: the one you will use to access the DB from your app. Make sure it has enough privileges to perform all required actions.
- password: whatever password was assigned to the user specified above for SQL Server authentication.
- databaseName: YourDBName (needs to match the DB name assigned to the DB that will be used by your app).
- serverName: PCNAME\SQLEXPRESS (or whatever name the SQL Server instance used to host the DB has.. look it up in the MSSQL Management Studio connection dialogue).
Add JDBC Resource:
- JNDI Name: jdbc/YourAppName (this is the same value you will use in your server.properties file for the property sql.SQLServer.driver.name).
- Pool Name: the name of the JDBC Connection Pool created above.
Add server.properties to your project (initially you can put it under src so that it will get in the app's classpath). I will put one sample below, but very stripped down. You can merge it with one of the server.properties in the sample projects, so that you can understand and comment correctly what each line does.
Create all required data source descriptors. You can see one example of this in my previous post in this thread for a simple users table.
Finally, add some code that uses the DS to bind your UI controls to the DB data. An very simple example is shown below for completeness.

server.properties

Code:

webRoot: __AUTODETECT__

gwtModuleName: yourappname
isomorphicPathRootRelative: $gwtModuleName/sc

sql.defaultDatabase: SQLServer

sql.SQLServer.database.type: sqlserver
sql.SQLServer.driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
sql.SQLServer.driver.databaseName: YourDBName
sql.SQLServer.interface.type: jndi
sql.SQLServer.driver.name: jdbc/YourAppName

project.datasources: $webRoot/ds
project.ui: $webRoot/shared/ui
project.apps: $webRoot/shared/app

modulesDir: modules/

Sample entry point class code:

Code:

import com.smartgwt.client.data.DataSource;
import com.smartgwt.client.widgets.grid.ListGrid;
import com.google.gwt.core.client.EntryPoint;  
  
public class BMSim implements EntryPoint {  
  
    public void onModuleLoad() {  

        DataSource ds = DataSource.get("users");
        ListGrid grid = new ListGrid();
        grid.setDataSource(ds);
        grid.fetchData();
        grid.setCanEdit(true);
        grid.draw();
        
    }  
}

Announcement

Deploy War File in Glassfish Fails

Comment

Comment

Comment

Comment

Comment

Comment