mich2187

Hi, I have developed an Alpha version of a plugin that implements a new DataAdapter that supports DTP Datasources. It's a new plugin that consumes the "dataAdapters" extension point you have developped( you have really made a great job :) ). You can see the snapshots that I've made, it details everythink, for now, it supports all "java.sql.Connection" types that can be provided by IManagedConnection provide by DTP Connectivity framework and the preview mode woks with these type of connections. The Test fundtion works with any ODA DataSource. I hope getting some feedbacks so I can continue working on this plugin: Project Home Page: http://sourceforge.net/p/jssdtpadapter/home/ Source code: http://sourceforge.net/p/jssdtpadapter/code/2/tree/ I will write a post on my blog ( https://hanichalouati.wordpress.com/ ) about how to create this plugin. Best regards, Hani

Hi, Here my new wordpress blog where I've written my first post about JasperSoft Studio: https://hanichalouati.wordpress.com/2011/05/10/a-quick-tour-around-japsersoft-studio/ Hope to get some comments to enhance the post Best regards, Hani

Hi, I was working with DTP QueryBuilder for testing purposes so I didn't spend much time on it after I succeded to open the QueryBuilder from the button on JDBCDatasourcePage class(the code is attached). The class I used form the DTP QueryDialog is attached( I've used the DTP QueryBuilder exemples). I was not able at that time to get programatically the datasource that I've created manually with DTP so I've used an XMLMemento string to provide the input of the QueryBuilder and it works fine, nexte step is getting form the Dialog the queryString and add it to the designer. I think since you are going to use DTP with JS Studio and with the last updates of the JS Studio project, I can retry to work on this and try to make it more flexible and usable. I was also working on a QueryBuilder for JPQL queries and JPA 2, but it is not finished yet. Best regards, Hani Code:Button builderButton = new Button(c, SWT.PUSH); builderButton.setText("Query Builder"); builderButton.addSelectionListener(new SelectionListener() { public void widgetSelected(SelectionEvent e) { String sMemento = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>" + "<SQLQueryBuilder editorInputType=\"SQLBuilderStorageEditorInput\"" + " name=\"test.sql\" version=\"1.0\">" + "<SQLStatement></SQLStatement>" + "<connInfo>MySQL_5.1.0:" + "New MySQL" + ":database:</connInfo>" + "<omitSchemaInfo>false:true:</omitSchemaInfo>" + "</SQLQueryBuilder>"; SQLBuilderStorageEditorInput storageEditorInput = SQLBuilderEditorInputUtil .createSQLBuilderStorageEditorInput(sMemento); BuilderDialog sqlBuilderDialog = new BuilderDialog(Display.getCurrent().getActiveShell()); if (!sqlBuilderDialog.setInput(storageEditorInput)) { return; } else { sqlBuilderDialog.create(); sqlBuilderDialog.setBlockOnOpen(true); sqlBuilderDialog.open(); } } public void widgetDefaultSelected(SelectionEvent e) { } });

Hi, After some research and tests, I've been able to integrate the Data Tools Platform Query Builder. Yet it's just for testing purpose and many work need to be done. I'm just asking if it's interessant to take advantage of the DTP QueryBuilder and integrate it completly on JasperSoft Studio, if so, I will continue my work on it :). Thanks

Hi, Actualy I'm a student and I'm studying JasperSoft Studio. Plugin Development under Eclipse is new for me, but It will be a good idea if it's possible with some practice to contribute to such a project ! Thank you ! Best regards, Hani Chalouati

Hi, Is there a Query Designer Wizard at this level in Jaspersoft Studio like the one in iReport ? Or it's not yet implemented. Best regards, Hani Chalouati

When in the preview mode, you have to create before a datasource to be able to select it in the preview mode. To do this select Window > Show View > Other... at the top of Eclipse. In Jaspersoft Studio folder, select Repository and do OK. This will show the repository view. In the repository view, you can create a JDBC connexion for exemple. You can find an illustration in attachment .