WM 6 and MySQL as database

[hobru]

Hi,

has anybody tried (know if it might work) to use the wM Server / TN with mySQL as a database? I know that MS SQL and Oracle are supported, but I think it should be possible to use mySQL instead.

I gave it a try by "rewriting" the Oracle-SQL script files but it failed to work...

Thanks for any opinion,

Holger.

[gperezpr]

We are using the mySQL Database for developing purposes with the JDBC Adapter and the WM Integration server 6.0.1 and WM Developer 6.0.1. We have create a JDBC Adapter Connection with the following parameters:

Your_Package:Your_Connection_Name Details
Connection_Type:JDBC Adapter Connection (This is given by the system)
Package Name: Your_Connection_Name

Connection Details:
Transaction Type:NO_TRANSACTION
DataSource Class: com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource
ServerName: localhost (Your_mysql_server_name)
user: root (Your_mysql_user_name)
password: whatever
database name: your_mysql_database_name
port_number: 3306 (mysql default)
networkProtocol: <leave>
Other Properties: <leave>

Connection Management Properties:
Enable Connection Pooling: true
Minimum Pool Size: 1
Maximum Pool Size: 10
Block TimeOut: 1000
Expire TimeOut: 1000

I hope this will solve any problem you have for creating you connection.

Regards
Gonzalo Pérez-Prim López

[jplesmid]

I've been curious about using MySQL also, although I have not tried to use it at all. I'm curious about two items. 1. What JDBC driver does one use for accessing MySQL? I have not tried to find one yet. 2. What is the nature of the errors you are getting. Are they simply from not having the correct JDBC driver? or are they happen when you attempt to define the database/tables in MySQL. Are you able to define the DB/tables, but TN complains?

Gonzalo - you seem to have been able to connect to MySQL via the JDBC adapter. Can you provide any additional detail w/regard to the JDBC driver you are using?

Thanks.

[hobru]

Hi,

the most important problem for me, was getting the database-creation scripts to run with MySQL. I had to change several "varchar(1040)" to "text" (and other things), but then I was able to create all the required tables in MySQL.
Then I downloaded the official MySQL JDBC driver from mysql.com (http://www.mysql.com/downloads/api-jdbc-stable.html) and included this file in my classpath.
Then I created a new Driver Alias Definitions with com.mysql.jdbc.Driver as the Class name (I originally wanted to use the class com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource like Gonzalo suggested, but that didn't work due to some missing references.
Now I was able to edit all JDBC Connection Pool Alias to use the MySQL JDBC driver with jdbc:mysql://localhost:3306/wm6 as the Database URL.
That was it.

After working all day on this problem yesterday, I would be happy to help you if you have any more problems.

Holger.

[gperezpr]

Good Morning:
I also used the last stable official MySQL JDBC driver from mysql.com, version 3.0.8. In addition, I download the MySQL Control Center (also known as MySQLCC) for creating the tables and testing the queries.It was very hepful.

Regards

Gonzalo Pérez-Prim López

[kalyan]

Hello,

Check for the support of views in MySQL, as far as i know MySQL database does not support. When searched for the support of View in MYSQL site its been mentioned that views will be supported in the next version. So I suggest for those who wants to work on MYSQL should check for the support of View other wise it would be waste of configuring it.

[hobru]

Hi,

Gonzales: thanks for the hint to the MySQL Control Center. I hadn't used that one. Now it is much more simple to manage MySQL.

Sri Kalyana Ram G: what do you mean by "support of views". So far everything is working just fine. I know that I will not use MySQL in a productive enviroment, but for testing on my local computer it is just great!

Holger.

[gperezpr]

Hello:

Sri, if you want to use an enterprise transaction opensource database, I would suggest mysql MaxDB http://www.mysql.com/sapdb/, which is the result of the partnership of SAP with mysql (http://www.mysql.com/press/release_2003_24.html ). I presume it is on development state, but I believe it is good reason for starting using mysql at least as a development database.

Regards
Gonzalo

[zygmunt]

Hi

Can someone help me to create tables in mysql??? In example I don't know what field type is equivalent to the NVARCHAR or IMAGE type used by the MS SQL DB scripts.

Many thanks
Zygmunt

[andrejan]

Try VARCHAR or TEXT for NVARCHAR ( depends on the length) and BLOB for IMAGE.

[ditsayawat (Unregistered Guest)]

hi guy

i try to configure IS6.0.1 and JDBC Adapter 6.0.2 with MySQL Connector/J 3.0.11-statble,I had done everything like Gonzalo mentioned above but i got error like this
"[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource SMSTopup.adapters.connections:pptrn.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
null
"
Which JDBC Adapter version you use? Did 6.0.2 Support mySQL?

IS error log stacktrace
"
java.lang.NullPointerException
at com.wm.adapter.wmjdbc.connection.ConnectionInfo.(ConnectionInfo.java:78)
at com.wm.adapter.wmjdbc.connection.JDBCConnection.initializeConnection(JDBCConnection.java:191)
at com.wm.adk.connection.WmManagedConnectionFactory.createManagedConnection(WmManagedConnectionFactory.java:111)
at com.wm.app.b2b.server.jca.WmConnectionPool$ConnectionEntry.(WmConnectionPool.java:898)
at com.wm.app.b2b.server.jca.WmConnectionPool.init(WmConnectionPool.java:252)
at com.wm.app.b2b.server.jca.WmConnectionPool.(WmConnectionPool.java:167)
at com.wm.app.b2b.server.jca.WmConnectionManager.setConfiguration(WmConnectionManager.java:197)
at com.wm.pkg.art.j2eecaBridge.WmConnectionManagerPropertiesBridge.setManagerProperties(WmConnectionManagerPropertiesBridge.java:121)
at com.wm.pkg.art.ns.ConnectionDataNodeManager.createConnectionManager(ConnectionDataNodeManager.java:771)
at com.wm.pkg.art.ns.ConnectionDataNode.enable(ConnectionDataNode.java:543)
at com.wm.pkg.art.ns.ConnectionDataNodeManager.setConnectionState(ConnectionDataNodeManager.java:1045)
at java.lang.reflect.Method.invoke(Native Method)
at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:287)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:339)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:119)
at com.wm.app.b2b.server.ns.Namespace.invoke(Namespace.java:522)
at com.wm.util.template.Reporter.invoke(Reporter.java:963)
at com.wm.util.template.InvokeToken.eval(InvokeToken.java:75)
at com.wm.util.template.TemplateToken.evalChild(TemplateToken.java:214)
at com.wm.util.template.SwitchToken.evalChild(SwitchToken.java:90)
at com.wm.util.template.TemplateToken.eval(TemplateToken.java:180)
at com.wm.util.template.SwitchToken.eval(SwitchToken.java:58)
at com.wm.util.template.TemplateToken.evalChild(TemplateToken.java:214)
at com.wm.util.template.IfVarToken.evalChild(IfVarToken.java:239)
at com.wm.util.template.Te

"

[cnlonelywolf]

hi,when i used the DataSource Class: com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource

Display the below error:
Cannot connect to the database with DataSource class "com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource".
Cannot load connection class because of underlying exception: 'java.lang.SecurityException: Prohibited package name: java.sql'

[marlykkong (Unregistered Guest)]

webmethods connect MySQL!
no problem!use com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource
but
there are some question in webmethods developer by Adapter service
in tables page,
question are "<current>" !!!!
if sql it is database.dbo.table ,no problem
if mysql it is database.<current>.table
make for:select * from database.pcname@ip.table ?????????
now to solve?
please tell me,ths a lot

[iandrosov]

Sorry I did try to use Msql JDBC driver version 3.0.11 with this Data source class name: com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource and I could not get connection enabled for JDBC adapter.
I placed the JDBC driver jar file mysql-connector-java-3.0.11-stable-bin.jar into IS lib/jars dir and also added this to system CLASSPATH so it can be found. I opened the jar to verify the class name and it did actually have this class: com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource but still I get this error:
Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource PKG.db:mysql.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
javax/sql/DataSource

My settings for Mysql is ok and DB I started in asni mode and tested with some SQL commands view tables etc. I did not created any users for MYSQL just use default came with it - root adn NO password.

Does anyone else see this problem adn know how to resolve it?

[iandrosov]

I just found a problem in my JDBC adapter setup. I fixed it nad now I can connect to MySQL no problem. disregrad my earlier post!
My problemwas a fact that I used JDBC adapter 6.0.3, adapter has a file: javaxsql.zip it was located in WmJDBCAdapter/code/jars/ directory from default installation. With that I was conptinue to get connetion errors from javax.sql classes that are located in that zip file.
Fortunately I had an old install of WM adn JDBC adapter loking at it I saw that it had same file but in static directory. SO I craeted subdir and copied my file there WmJDBCAdapter/code/jars/static/javaxsql.zip
Resyarted IS and connected to mysql no problems.

[Pritam R Wadhwani (Unregistered Guest)]

Hi All
I am using jdbc driver for MySql but am unable to create an notification adapter service. The developer 6.1 gives an error Notification not supported for mySQL. Any suggestions?

Thanks in Advance

[andrejan]

For a polling notification you'll need a trigger in the database. MySQL doesn't support triggers. That's why the notification is not supported.

The newest version 5 of MySQL supports triggers, but I don't know if webMethods supports the newest version of MySQL.

[h2o@iafrica.com (Unregistered Guest)]

Hallo all.

I need some help to configure coldfusion using maxdb and the jdbc driver.

Thanks,
Marco

[mcarlson]

Marco,

This is a webMethods discussion forum. You'll undoubtedly find lots of great places to ask ColdFusion questions, but WMUsers is not one of them.

Mark

[sorin_ctin]

does anyone have experience using IS 4.6 to access a mysql database?