Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

    Help connecting SmartGWT EE to postgres sql

    I am new to smartGWT and evaluating the enterprise version. I am trying to connect to a postgres database but after two days not its clear I need help. i'm hoping someone can help me see what im missing and get it up and running. I'm creating the project with eclipse and and Google windowbuilder plug-in

    when I open the admin console and the visual builder I get a java sql Exception as can be seen in the images below.

    Whenever I try to load a datasource it returns null therefore i am unable to populate grids and so on.

    here is the stack trace http://rapidshare.com/files/436609686/stack.txt (had to post it as a link because of the size limit)

    If anyone has a sample project with a connection to postgres that they would want to give me as an example please contact me you can email it to Macky_Bwoy22@hotmail.com Thanks in advance
    Attached Files

    #2
    This suggests that you've added dbName="infogroup" to a .ds.xml file, but you have not created a database config called "infogroup" in the Admin Console. Possibly you have different capitalization in the config created in the Admin Console vs what you typed in the .ds.xml file.

    If this doesn't solve the problem, what we need are the settings you entered in the Admin Console, whether the connection works with the Admin Console "Test" function, and the .ds.xml file.

    For server logs, use the log4j.config.xml file provided with the SDK. Right now you've got all logs set to DEBUG, which is not recommended and is what's creating such a large log.

    Comment


      #3
      Make sure that you have set up the appropriate connection info in server.properties... Make the necessary changes for your own environment...

      Code:
      sql.PostgreSQL.driver.serverName: localhost
      sql.PostgreSQL.driver.portNumber: 5432
      sql.PostgreSQL.driver.databaseName: infogroup
      sql.PostgreSQL.driver.user: postgres
      sql.PostgreSQL.driver.password:
      Finally make sure that you have postgres jdbc jar in your classpath

      Comment

      Working...
      X