Get started
Loading...
Important Notice - Forums is archived

To simplify things and help our users to be more productive, we have archived the current forum and focus our efforts on helping developers on Stack Overflow. You can post new questions on Stack Overflow or join our Discord channel.

Product icon
TUTORIAL

Vaadin lets you build secure, UX-first PWAs entirely in Java.
Free ebook & tutorial.

CssImport when using Component Exporter by Mikhail Shabarov, 1 month ago
Recent Posts
Vaadin Forum3. Vaadin 6, 7, 8Framework Data Binding

I can not connect to mssql server

Dir3aux dir3aux
10 years ago Apr 17, 2012 9:58am

I was looking at different forums but I found that I was interested

1) I creeted a project TestdbProject
2) I add in A) TestdbProject /WebContent/WEB-INF/lib/sqljdbc4.jar
B ) TestdbProject /WebContent/WEB-INF/lib/vaadin-sqlcontainer-1.1.0
3)Compile Vaadin WidgetSEt

4) Here is source code 

package com.db.testdbproject;

import java.sql.SQLException;
import java.util.Locale;

import com.vaadin.Application;
import com.vaadin.addon.sqlcontainer.SQLContainer;
import com.vaadin.addon.sqlcontainer.connection.SimpleJDBCConnectionPool;
import com.vaadin.ui.*;


public class TestdbprojectApplication extends Application {
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	private SQLContainer container;

	@Override
	public void init() {
	   initLayout();
	}
	
	private void initLayout(){
		
		System.out.println("GO GO GO");
		Window mainWindow = new Window("Test db connection");
		setMainWindow(mainWindow);
		SimpleJDBCConnectionPool connectionPool;
		
		try {
				System.out.println("Start DB CONNECTION");
				Locale.setDefault(Locale.ENGLISH);
				connectionPool = new SimpleJDBCConnectionPool("com.microsoft.jdbc.sqlserver.SQLServerDriver", "YOKO:1433", "testbill", "testbillp",2,5);
		} catch (SQLException e){
			
			System.out.println("Not ok");
		}
		
		
		
	}

}

5) I get a exception see in the screen below.
how i must do correct create the connection pool for mssql ????

Last updated on Apr, 17th 2012
Dir3aux dir3aux
10 years ago Apr 17, 2012 10:37am

i found my error in connecton string

connectionPool = new SimpleJDBCConnectionPool("com.microsoft.sqlserver.jdbc.SQLServerDriver", "jdbc:sqlserver://YOKO:1433;databaseName=BillAccount;", "testbill", "testbillp",2,5);

+1
Dir3aux dir3aux
10 years ago Apr 17, 2012 11:16am

The full script for mssql connection in show in a table

package com.db.testdbproject;

import java.sql.SQLException;
import java.util.Locale;

import com.vaadin.Application;
import com.vaadin.addon.sqlcontainer.SQLContainer;
import com.vaadin.addon.sqlcontainer.connection.SimpleJDBCConnectionPool;
import com.vaadin.addon.sqlcontainer.filters.Like;
import com.vaadin.addon.sqlcontainer.query.FreeformQuery;
import com.vaadin.event.FieldEvents.TextChangeEvent;
import com.vaadin.event.FieldEvents.TextChangeListener;
import com.vaadin.ui.*;
import com.vaadin.ui.AbstractTextField.TextChangeEventMode;


public class TestdbprojectApplication extends Application {
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	private SQLContainer container;

	@Override
	public void init() {
	   initLayout();
	}
	
	private void initLayout(){
		
		System.out.println("GO GO GO");
		Window mainWindow = new Window("Test db connection");
		setMainWindow(mainWindow);
		SimpleJDBCConnectionPool connectionPool;
		
		try {
				System.out.println("Start DB CONNECTION");
				Locale.setDefault(Locale.ENGLISH);
				connectionPool = new SimpleJDBCConnectionPool("com.microsoft.sqlserver.jdbc.SQLServerDriver",
						                                      "jdbc:sqlserver://YOKO:1433;databaseName=BillAccount;",
						                                      "testbill", "testbillp");
				 container = new SQLContainer(new FreeformQuery("SELECT TOP 1000 [ID] ,[ORDERID], [IN_CODE] ,[IN_PHONE], [IN_FNAME] ,[IN_LNAME] ,[IN_MNAME] ,[PAYDATE] ,[INFOQTY] ,[INFOCOST] FROM [BillAccount].[dbo].[bill]" ,connectionPool));
				 System.out.println("Connect db suscesuful");
			
				
		} catch (SQLException e){
			
			System.out.println("Not ok");
		}
		
		
		
		TextField filterField =new TextField("Filter");
		filterField.setTextChangeEventMode(TextChangeEventMode.LAZY);
		filterField.setTextChangeTimeout(200);
		filterField.addListener(new filterFieldListener(container)); /// clasa filterFieldListener va fi creata mai jos 
		
		Table table =  new Table(null, container);
		table.setContainerDataSource(container);
		mainWindow.addComponent(filterField);
		mainWindow.addComponent(table);
		
		
		
		
	}
	
	
	 class filterFieldListener implements TextChangeListener{

		/**
		 * 
		 */
		private static final long serialVersionUID = 1L;
		private SQLContainer container;
		
		public filterFieldListener(SQLContainer container) {
			this.container = container;
		}
		
		
		
		public void textChange(TextChangeEvent event) {
			
			Like like = new Like("title", event.getText()+"%");
			container.removeAllContainerFilters();
			container.addContainerFilter(like);
			
		}
		
		
		
	      }
	
	
	
	
	

}
Dir3aux dir3aux
10 years ago Apr 17, 2012 11:39am

I sometimes appear so an error

com.vaadin.Application terminalError
SEVERE: Terminal error:
java.lang.RuntimeException: Failed to update item set size.

where this error may occur ,,, ????

In the webpage show
Internal error

Please notify the administrator.
Take note of any unsaved data, and click here to continue.

Last updated on Apr, 17th 2012