Hello! What prevents you from reading rows from DB and feeding them to JDBC prepared statement?
Regards, -- Ilya Kasnacheev чт, 7 мар. 2019 г. в 15:51, Mike Needham <needb...@gmail.com>: > And what if the data is already in a database table? I do not want to > read from the table to write to a file to load a cache. > > On Tue, Mar 5, 2019 at 4:06 AM Ilya Kasnacheev <ilya.kasnach...@gmail.com> > wrote: > >> Hello! >> >> The preferred approach is to use Thin JDBC client: >> https://apacheignite-sql.readme.io/docs/jdbc-driver >> >> Regards, >> -- >> Ilya Kasnacheev >> >> >> пн, 4 мар. 2019 г. в 19:39, Mike Needham <needb...@gmail.com>: >> >>> Thanks for the links, If SET STREAMING ON is the preferred method, how >>> would you do this in code rather than from a file with all the insert >>> statements. >>> >>> On Mon, Mar 4, 2019 at 1:44 AM Ilya Kasnacheev < >>> ilya.kasnach...@gmail.com> wrote: >>> >>>> Hello! >>>> >>>> You can see at this page: >>>> https://apacheignite-sql.readme.io/docs/sql-and-key-value-usage >>>> >>>> And then substitite cache.put() with addData() and cache name will be >>>> SQL_PUBLIC_{table name in caps} >>>> >>>> There are not many examples since this is being discouraged in favor of >>>> SET STREAMING ON, actually: >>>> https://apacheignite-sql.readme.io/docs/set >>>> >>>> Regards, >>>> -- >>>> Ilya Kasnacheev >>>> >>>> >>>> пт, 1 мар. 2019 г. в 22:48, Mike Needham <needb...@gmail.com>: >>>> >>>>> I have looked at the documentation and the code samples and nothing is >>>>> doing what I am trying to do. I want to be able to use the datastreamer >>>>> to >>>>> load 3 or 4 TABLES in a cache for an application that we use. If I create >>>>> the tables using a create table syntax how do attach a datastreamer to the >>>>> different caches if the cache name is PUBLIC for all of them? >>>>> >>>>> On Thu, Feb 28, 2019 at 8:13 AM Ilya Kasnacheev < >>>>> ilya.kasnach...@gmail.com> wrote: >>>>> >>>>>> Hello! >>>>>> >>>>>> I have linked the documentation page, there are also some code >>>>>> examples in distribution. >>>>>> >>>>>> Regards, >>>>>> -- >>>>>> Ilya Kasnacheev >>>>>> >>>>>> >>>>>> чт, 28 февр. 2019 г. в 17:10, Mike Needham <needb...@gmail.com>: >>>>>> >>>>>>> Is there any examples that show the steps to do this correctly? I >>>>>>> stumbled upon this but have no idea if it is the best way to do this >>>>>>> >>>>>>> On Thu, Feb 28, 2019 at 6:27 AM Ilya Kasnacheev < >>>>>>> ilya.kasnach...@gmail.com> wrote: >>>>>>> >>>>>>>> Hello! >>>>>>>> >>>>>>>> There's no restriction on cache name but setting it up for the >>>>>>>> first time may be tricky indeed. >>>>>>>> >>>>>>>> Regards, >>>>>>>> -- >>>>>>>> Ilya Kasnacheev >>>>>>>> >>>>>>>> >>>>>>>> ср, 27 февр. 2019 г. в 19:48, needbrew99 <needb...@gmail.com>: >>>>>>>> >>>>>>>>> OK, was able to get it working. Apparently the cache name has to >>>>>>>>> be PUBLIC >>>>>>>>> and it will create a table based on the object definition that I >>>>>>>>> have. >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >>>>>>>>> >>>>>>>> >>>>>>> >>>>>>> -- >>>>>>> *Some days it just not worth chewing through the restraints* >>>>>>> >>>>>> >>>>> >>>>> -- >>>>> *Some days it just not worth chewing through the restraints* >>>>> >>>> >>> >>> -- >>> *Some days it just not worth chewing through the restraints* >>> >> > > -- > *Some days it just not worth chewing through the restraints* >
