Connecting to MySql through JDBC

[Wesley Hilebrand]

Hi everybody,

First off, I am newbie to jPOS and Q2.

I would like to connect to database mysql using JDBC. I have found a way to connect mysql using Hibernate, as documented here on page 15. But I don't want use it.

After several searches, I only found out the following posted by Alejandro Revilla, but how can I use it on my class below? Can you give me an example?

I appreciate your help.

public class IncomingMessageListener implements ISORequestListener {
    @Override
    public boolean process(ISOSource source, ISOMsg m) {
        ISOMsg response = new ISOMsg();
       
        /*
            store m in database
        */
       
        try {
            response.setMTI("0810");
            response.set(7, m.getString(7));
            response.set(11, m.getString(11));
            response.set(12, m.getString(12));
            response.set(13, m.getString(13));
            response.set(39, "00");
            response.set(42, m.getString(42));
            response.set(70, m.getString(70));
            response.set(123, m.getString(123));
            response.set(124, "00822222222");
            response.set(127, "009000000005");
            source.send(response);
        } catch (ISOException ex) {
        } catch (IOException ex) {
        }
        return false;
    }
}

[Victor Salaman]

Hi:

Try a MySQL/jdbc tutorial then:

http://www.vogella.com/tutorials/MySQLJava/article.html

--
--
jPOS is licensed under AGPL - free for community usage for your open-source project. Licenses are also available for commercial usage. Please support jPOS, contact: sa...@jpos.org
 
Join us in IRC at http://webchat.freenode.net/?channels=jpos
 
You received this message because you are subscribed to the "jPOS Users" group.
Please see http://jpos.org/wiki/JPOS_Mailing_List_Readme_first
To post to this group, send email to jpos-...@googlegroups.com
To unsubscribe, send email to jpos-users+...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jpos-users
---
You received this message because you are subscribed to the Google Groups "jPOS Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jpos-users+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jpos-users/6b1b16b8-1610-4780-98f9-26d4b8d91f5b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Wesley Hilebrand]

Thanks Victor,

I've seen the class PersistentEngine.java, which basically creates the JDBC connection, such as shown in the link posted by you. 

Also, ConnectionPool.java seems more interesting since it manages all connections.

Best regards,

[chhil]

At a very basic level....

You could implement a qbean that implements your db access using jdbc.

Something along the lines of https://github.com/jpos/jPOS-EE/blob/master/modules/dbsupport/src/main/java/org/jpos/ee/DB.java

But as a qbean and has a connection getter method.

If you need pooling you would need to implement it.

Register this qbean in the NameRegistrar.

Wherever you need to do some DB work, get the DB object from the nameregistrar, get the connection and do what you need to do.

-chhil

To view this discussion on the web visit https://groups.google.com/d/msgid/jpos-users/2bead207-8cb6-4271-b98e-d80a9ba4d833%40googlegroups.com.

[Victor Salaman]

chhil, I think you lost him :)

To view this discussion on the web visit https://groups.google.com/d/msgid/jpos-users/CAPazefB2oH4NMDi6KuavsJG2UPwmvHfBp9We30S-imjfc1Dffw%40mail.gmail.com.

[chhil]

From the initial code that was posted, some beans are already in play, so I added one more.

If Wesley wants to take the tougher jdbc route, jpos wont stop him. Just want to make sure he is aware that it can be done.

You are always here to answer questions :)

-chhil

To view this discussion on the web visit https://groups.google.com/d/msgid/jpos-users/CALK1SyyiTWX9nUvsi4iKba8F_yLqB%3DavAQErgwWRyfK-UWPBGQ%40mail.gmail.com.

[Victor Salaman]

Chhil:

Chill, my point was in the lines of "jPOS-EE provides battle-tested components/patterns which provide excellent performance at very little cost to the developer", but Wesley for some reason wants to re-invent the wheel and I have very little energy left to stop someone from shooting themselves. :)

/V

To view this discussion on the web visit https://groups.google.com/d/msgid/jpos-users/CAPazefDVCsHq2-oj-M0VZ4P2DaBXAHhF_6qqFUs0bh2GpqwFPg%40mail.gmail.com.

[Alejandro Revilla]

Wesley, 

The PersistentEngine is kind of old and deprecated stuff, it's there just for backward compatibility. I don't recommend to use it for new code.

If you don't want to use Hibernate (I love/hate it myself) you could try http://www.jooq.org/

You can also use bare bones JDBC and create your own SQL, or better yet, use a connection pool such as c3p0.

Bharavi (a long time jPOS developer from the early days) recently recommended me https://github.com/brettwooldridge/HikariCP - I didn't have time to test it yet, but he says it's working very well for him in production.

Hope this helps.

--

@apr

To view this discussion on the web visit https://groups.google.com/d/msgid/jpos-users/CALK1SywfmuFWO5pmkYbZ43z61FeSb12fATeF2%3Dt0AdxOyqSJYA%40mail.gmail.com.

[Wesley Hilebrand]

Thanks Chhil, Victor and Alejandro,

I feel very satisfied to your suggestions. It would be great to implement Chhil's suggestion, but I must learn much more of jPOS and I don't have too much time in my project.

Victor, I will re-think to use hibernate, since it is ready-to-use.

Alejandro, thanks for your help. I will check those alternatives. 

Best regards,