I'm using ibm streams 4.2 in centos 6 . I'm trying to use the operator odbcappend to insert the tuples from the file source to a table in my sql db. So I'm trying to connect ibm streams to my sql db. However, I'm using xampp php my admin for my sql. I tried so many ways for the connection but it doesn't work.
Ibm streams connection with mysql database
204 Views Asked by Ahmed Sherif At
1
There are 1 best solutions below
Related Questions in DATABASE
- How to add the dynamic new rows from my registration form in my database?
- How to store a date/time in sqlite (or something similar to a date)
- Problem with add new attribute in table with BOTO3 on python
- When an E-R attribute should be perceived as a relationship attribute or as an entity set attribute?
- SQLAlchemy: efficient relationship loading in 3-way many-to-many relationship
- Cannot connect to Postgres Database when running Quarkus Tests with Gitlab ci
- Local or remote database with react-native?
- I want to edit a specific row in database
- How to enter data in mongodb array at specific position such that if there is only 2 data in array and I want to insert at 5, then rest data is null
- Open Web Library
- database login.py and register.py error showing 404 file not found and doesn't work
- SQL71561: SqlComputedColumn: When column selected
- Liquibase as SaaS To Configure Multiple Database as Dynamic
- Updated max input vars but table still shows error
- Spring does not map set of roles
Related Questions in CONNECTION
- MongoDb not connecting C#
- Frontend fetching data from unexpected localhost address despite proxy configuration
- recognize_google fails with WinError 10060
- April fools - PsExec (PsTools)
- Unable to resolve service name to its IP inside kubernetes cluster
- Is there a way to create connection pooling in codeigniter 3 using custom mysqli driver?
- Error in releasing pool connection in node project
- Is there a way in Laravel to use multiple connections simultaneously in a combined manner?
- Not able to inject RedisCache/SyncCache/StatefulRedisConnection beans in micronaut 4.2.1 version
- How to send a big array to a client faster
- Connection Type not visible in Airflow connections
- Cannot connect to an Oracle XE database from C#
- SSMS Update Causes Connection Failure and Exception Error
- Mutual connections in Strapi
- Microsoft SQL Server Express Java Connection
Related Questions in IBM-STREAMS
- how could resolved "CDISP0092E ERROR: Because of previous compilation errors, the compile process cannot continue."?
- Is it possible to write in ORC format using hdfs2FileSink operator into HDFS in IBM infosphere streams or any other way?
- Can we use SPL time functions inside C++ operators?
- In SPL TEDA 4.2 , do we have limitation on number of input file types that can be included?
- How can I get IBM Streams toolkit update?
- Error : fork() failed in code generation
- XML Parse operator throws error when working with large XML file in IBM Streams
- IBM Streams export/import operation within the instance versus between two instances
- JSON to Tuple operation in IBM Streams
- Setting IBM Streams instance properties and bringing that to effect without restarting the instance
- Working on migration of SPL 3.0 to 4.2 (TEDA)
- Working with TEDA 4.2 architecture.How to call LookUpCache operator in a loop?
- Is there a way to capure tuple/sec through an operator in IBM Streams (not through Streams console)
- Automating Build Process of c++ code using RTC and jenkins
- Working with large files with a particular extension using directory scan operator
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
I did a little digging and found this post which leads me to believe that xampp does not use one of the tested ODBC drivers for the toolkit: xampp post: How to enable odbc in XAMPP linux Tested ODBC drivers for mysql:
If your mySQL distribution uses the MySQL ODBC Connector then use that or you can download UnixODBC to use with the toolkit.
Otherwise you should use STREAMS_ADAPTERS_ODBC_UNIX_OTHER and setup the other variables to point to the driver that is already installed. You should be sucessful to the extent that the ODBC implementation matches the syntax of the tested drivers. From the docs:
https://www.ibm.com/support/knowledgecenter/SSCRJU_4.2.0/com.ibm.streams.toolkits.doc/spldoc/dita/tk$com.ibm.streams.db/tk$com.ibm.streams.db$1.html