nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Write to db

superbeda

Hi at all,is there any way to write some information to db?I want store the execution query with its parameters.

Find more posts tagged with

Comments

kclark

There are a couple of different ways to do this depending on what db you're connecting to. Since you can use Java a BIRT Report inside of the script tag, the easiest way might be to include your db jars and handle the db write as you would if you were writing a class. Another way would be to write your own custom class that takes just your data as the input parameter and allow that class to do all the writing. Then you'd just need to call SomeClass.writeToDB("some data") from your script.

SailRCG

I've done this using script tag at footer of a report. The script tag contained spaces for free text input; nothing fancy. You might also search the forum for "write back" report designs.

superbeda

Hi Kristopher,I didn't understand. Can I have one example how configure the report to perform this?

kclark

I've attached an example for you to take a look at. Basiclly, I created a class that handles the SQL write back that looks like this.<pre class="_prettyXprint _lang-">package com.actuate.developer;import java.sql.Connection;import java.sql.DriverManager;import java.sql.Statement;public class WriteBackSQL { // User properties private String username; private String password; private String database; private String hostname; private int port; public WriteBackSQL(String username, String password, String database, String hostname, int port) { this.username = username; this.password = password; this.database = database; this.hostname = hostname; this.port = port; } public void executeQuery(String query) { try { Class.forName("com.mysql.jdbc.Driver"); // Create the URL, connection, and statement String url = "jdbc:mysql://" + hostname + ":" + port + "/" + database; Connection conn = DriverManager.getConnection(url, username, password); Statement stmt = conn.createStatement(); // Execute the query stmt.executeUpdate(query); // Close the connection conn.close(); }catch(Exception ex) { ex.printStackTrace(); } } public void setUsername(String username) { this.username = username; } public void setPassword(String password) { this.password = password; } public void setDatabase(String database) { this.database = database; } public void setHostname(String hostname) { this.hostname = hostname; } public void setPort(int port) { this.port = port; } public String getUsername() { return username; } public String getDatabase() { return database; } public String getHostname() { return hostname; } public int getPort() { return port; }}</pre>The constructor takes parameters username, password, database, hostname, and port. You'd need to take this and your SQL driver and place them both in the resources tab from the property editor > properties > resources > jar files. Then to write to the db you'd use some script like this in yoru report. <div><pre class="_prettyXprint">importPackage(Packages.com.actuate.developer);//username, password, database, hostname, porttest = new WriteBackSQL("root", "root", "test", "localhost", 3306);test.executeQuery("INSERT INTO test values('Name', 5);");</pre></div>

superbeda

Hi Kristopher,thank you for the solution. It is very usefull.

kclark

You're welcome! I'm sure my Java could use some optimization for your project, I just threw it together as an example. Let us know if you have anymore questions!

superbeda

My problem was how use my java class in the report. now I can do it

superbeda

Hi Kristopher,I have another question: I created and I tested my report with successfull, but when I publish into iHub2 it works only if I publish it under "Resources" folder. If I put it under another folder, with the .jar file, it doesn't work. Do you know why?

superbeda

I resolved. I had to restart the iHub server and now it works

Max Bo

Could someone please guide me through the process on how to create the JAR file from this class? I can offer either Netbeans or Eclipse as IDE.

superbeda

If you create a java project with NetBeans and then you click the "clean and build" button, in the dist folder of your project there is the .jar file

Max Bo

Got it working - nice!

Thanks for the help!

superbeda

I'm happy to have helped you

BIRT_REPORT1

Thank you Kristopher. It works like a charm on my MySQL database. Would I be able to use this with other type of database connections?