Date: Thu, 25 Oct 2012 16:37:42 -0700 (PDT) From: cha <chaf...@gmail.com> To: mybatis-user@googlegroups.com Message-Id: <892d4721-8081-495c-9ad7-590d9bf335dc@googlegroups.com> In-Reply-To: <CAKpaNj6AMwEu+sxCL3QGEGHbppdq0Oo0YruBqs99mkft1p0cfA@mail.gmail.com> References: <0afa865a-4d6e-45e0-9c9b-426b18b2bc97@googlegroups.com> <CAKpaNj5twucpyFV=EnAhgajcxAO2DyiAo-o28k6VwT9RghSd8g@mail.gmail.com> <9e508b39-9111-491e-acbc-e26b1bde8ad4@googlegroups.com> <CAKpaNj7PtsyP_Np6R6t+Rq=KsDJFkbuTA7LA564ZJRaxUPyvwQ@mail.gmail.com> <509606e5-3931-4c04-9a49-f1eac2791124@googlegroups.com> <CAKpaNj6AMwEu+sxCL3QGEGHbppdq0Oo0YruBqs99mkft1p0cfA@mail.gmail.com> Subject: Re: MyBatis generator with sqlite gives "did not resolve to any tables" MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_Part_163_22543977.1351208262455" ------=_Part_163_22543977.1351208262455 Content-Type: multipart/alternative; boundary="----=_Part_164_33545134.1351208262455" ------=_Part_164_33545134.1351208262455 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Hmmm, if it uses getMetaData it should be fine. The ResultSet comes back with the expected null, null, tableName, col1Name, 12, TEXT, 2000000000 ... for each column. Oddly enough it still gives the same answer if wrong catalog and schema is given like dbmd.getColumns(wrongCatalog, wrongSchema, tableName, null). You mentioned that I try dbmd.getColumns(null, null, null, null) to get a list of all the columns in the database. Using four nulls this way returns an empty ResultSet. This might be the problem if the generator calls getColumns(null, null, null, null) at some point (say, to get a feel for the entire database). On Thursday, October 25, 2012 1:12:31 PM UTC-7, Jeff Butler wrote: > My best guess is that there is a problem with the SQLite JDBC driver - > either a bug or they have not implemented the > DatabaseMetaData.getColumns() method. > > You can check it yourself with a small Java program. This is > virtually what the generator does: > > Connection c = getConnection(); // you must write the getConnection > method > DatabaseMetaData dbmd = c.getMetaData(); > ResultSet rs = dbmd.getColumns(catalog, schema, table, null); > > If the ResultSet comes back empty, then you'll see the message your > are seeing. The driver is not throwing an error, it's just returning > nothing. So there is no better error information to display. > > You'll have to experiment with values for catalog, schema, and table > to see if you can get something to come back, You can set all four > parameters to null which should return information about every column > in the database (a long list). That would give you a clue as to what > needs to be entered. > > Another issue could be case sensitivity. If SQLite is case sensitive > in the metadata then you will need to specify the proper case and set > the table configuration to use delimited parameters. > > As for your other question about passing in a create table statement, > there is no support for that in the generator. > > Jeff Butler > > > On Thu, Oct 25, 2012 at 3:44 PM, cha <cha...@gmail.com <javascript:>> > wrote: > > Thanks, but I'm still having problems here. Do you know of anyone who > has > > gotten this to work with sqlite? > > > > What would help is more failure information. Is there a way to get more > > about why the table isn't resolved from the generator? For example the > same > > error is given if the database file testDB_DNE.sqlite doesn't exist as a > > table, schema, or catalog that doesn't exist. > > > > Another way to fix this might be to just hand feed the tables' "create > table > > ..." or something like that to the generator instead of having it > > instrospect. Is this possible? > > > > > > On Friday, October 19, 2012 11:20:45 AM UTC-7, Jeff Butler wrote: > >> > >> I'm not an SQLite user, so I don't know for sure. You might try > >> setting schema to "testDB.sqlite". You might also try setting catalog > >> to "testDB" and schema to "sqlite". It's really dependent on how they > >> implemented the JDBC driver. > >> > >> Jeff Butler > >> > >> On Fri, Oct 19, 2012 at 1:55 PM, cha <cha...@gmail.com> wrote: > >> > Thanks for the reply. Originally, I left catalog and schema off and > got > >> > > >> > "Generation Warnings Occured > >> > Table configuration with catalog null, schema null, and table > >> > testTable > >> > did not resolve to any tables" > >> > > >> > Which made me think I needed schema/catalog settings. The entire > >> > generatorConfig.xml is > >> > > >> > <?xml version="1.0" encoding="UTF-8" ?> > >> > <!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis > >> > Generator Configuration 1.0//EN" > >> > "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd" > > >> > <generatorConfiguration > > >> > <context id="context"> > >> > <jdbcConnection driverClass="org.sqlite.JDBC" > >> > connectionURL="jdbc:sqlite:testDB.sqlite" userId="" password="" > >> >></jdbcConnection> > >> > <javaModelGenerator targetPackage="model" > targetProject="test/src" > >> >></javaModelGenerator> > >> > <sqlMapGenerator targetPackage="model" targetProject="test/src" > >> >></sqlMapGenerator> > >> > <javaClientGenerator targetPackage="model" targetProject="test" > >> > type="XMLMAPPER" ></javaClientGenerator> > >> > <table tableName="afloatplantest" > > >> > > >> > <property name="useActualColumnNames" value="true"/> > >> > </table> > >> > </context> > >> > > >> > > >> > On Friday, October 19, 2012 10:05:37 AM UTC-7, Jeff Butler wrote: > >> >> > >> >> sqlite does not have catalogs - leave that off. > >> >> > >> >> Only use the schema if you create tables like schema.table_name. > Else > >> >> leave that off too. > >> >> > >> >> You probably only need to specify the tableName. > >> >> > >> >> Jeff Butler > >> >> > >> >> > >> >> On Fri, Oct 19, 2012 at 12:10 PM, cha <cha...@gmail.com> wrote: > >> >> > Hello, I am having a problem with MyBatis generator on sqlite. > >> >> > When I try to generate, I get > >> >> > > >> >> > "Generation Warnings Occured > >> >> > Table configuration with catalog main, schema sqlite_master, and > >> >> > table > >> >> > testTable did not resolve to any tables" > >> >> > > >> >> > The table config that I am using is > >> >> > > >> >> > <table catalog="main" schema="sqlite_master" tableName="testTable" > > > >> >> > <property name="useActualColumnNames" value="true"/> > >> >> > </table> > >> >> > > >> >> > I have also tried variations like > >> >> > > >> >> > <table catalog="main" schema="sqlite" tableName="testTable" > > >> >> > <property name="useActualColumnNames" value="true"/> > >> >> > </table> > >> >> > > >> >> > <table schema="sqlite" tableName="testTable" > > >> >> > <property name="useActualColumnNames" value="true"/> > >> >> > </table> > >> >> > > >> >> > Has anyone used succesfully used MyBatis generator with sqlite and > >> >> > know > >> >> > the > >> >> > schema settings? > ------=_Part_164_33545134.1351208262455 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable <DIV>Hmmm, if it uses getMetaData it should be fine. The ResultSet comes ba= ck with the expected</DIV> <DIV> </DIV> <DIV><FONT size=3D2> <P>null, null, tableName, col1Name, 12, TEXT, 2000000000 ...</P> <P>for each column. Oddly enough it still gives the same answer if wrong ca= talog and schema is given like dbmd.getColumns(wrongCatalog, wrongSchema, t= ableName, null).</P> <P>You mentioned that I try dbmd.getColumns(null, null, null, null) to get = a list of all the columns in the database. Using four nulls this way return= s an empty ResultSet. This might be the problem if the generator calls getC= olumns(null, null, null, null) at some point (say, to get a feel for t= he entire database).</P></FONT><BR><BR>On Thursday, October 25, 2012 1:12:3= 1 PM UTC-7, Jeff Butler wrote:</DIV> <BLOCKQUOTE style=3D"BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex= ; PADDING-LEFT: 1ex" class=3Dgmail_quote>My best guess is that there is a p= roblem with the SQLite JDBC driver - <BR>either a bug or they have not impl= emented the <BR>DatabaseMetaData.getColumns() method. <BR><BR>You can check= it yourself with a small Java program. This is <BR>virtually what th= e generator does: <BR><BR>Connection c =3D getConnection(); // you mu= st write the getConnection method <BR>DatabaseMetaData dbmd =3D c.getMetaDa= ta(); <BR>ResultSet rs =3D dbmd.getColumns(catalog, schema, table, null); <= BR><BR>If the ResultSet comes back empty, then you'll see the message your = <BR>are seeing. The driver is not throwing an error, it's just return= ing <BR>nothing. So there is no better error information to display. = <BR><BR>You'll have to experiment with values for catalog, schema, and tabl= e <BR>to see if you can get something to come back, You can set all f= our <BR>parameters to null which should return information about every colu= mn <BR>in the database (a long list). That would give you a clue as t= o what <BR>needs to be entered. <BR><BR>Another issue could be case sensiti= vity. If SQLite is case sensitive <BR>in the metadata then you will n= eed to specify the proper case and set <BR>the table configuration to use d= elimited parameters. <BR><BR>As for your other question about passing in a = create table statement, <BR>there is no support for that in the generator. = <BR><BR>Jeff Butler <BR><BR><BR>On Thu, Oct 25, 2012 at 3:44 PM, cha <<A= href=3D"javascript:" target=3D_blank gdf-obfuscated-mailto=3D"2XCOTZrbLUkJ= ">cha...@gmail.com</A>> wrote: <BR>> Thanks, but I'm still having pro= blems here. Do you know of anyone who has <BR>> gotten this to work with= sqlite? <BR>> <BR>> What would help is more failure information. &nb= sp;Is there a way to get more <BR>> about why the table isn't resolved f= rom the generator? For example the same <BR>> error is given if the data= base file testDB_DNE.sqlite doesn't exist as a <BR>> table, schema, or c= atalog that doesn't exist. <BR>> <BR>> Another way to fix this might = be to just hand feed the tables' "create table <BR>> ..." or something l= ike that to the generator instead of having it <BR>> instrospect. Is thi= s possible? <BR>> <BR>> <BR>> On Friday, October 19, 2012 11:20:45= AM UTC-7, Jeff Butler wrote: <BR>>> <BR>>> I'm not an SQLite u= ser, so I don't know for sure. You might try <BR>>> setting sch= ema to "testDB.sqlite". You might also try setting catalog <BR>>&g= t; to "testDB" and schema to "sqlite". It's really dependent on how they <B= R>>> implemented the JDBC driver. <BR>>> <BR>>> Jeff Butl= er <BR>>> <BR>>> On Fri, Oct 19, 2012 at 1:55 PM, cha <<A>ch= a...@gmail.com</A>> wrote: <BR>>> > Thanks for the reply. Origi= nally, I left catalog and schema off and got <BR>>> > <BR>>>= > "Generation Warnings Occured <BR>>> > Table configura= tion with catalog null, schema null, and table <BR>>> > testTable = <BR>>> > did not resolve to any tables" <BR>>> > <BR>>= > > Which made me think I needed schema/catalog settings. The entire = <BR>>> > generatorConfig.xml is <BR>>> > <BR>>> >= ; <?xml version=3D"1.0" encoding=3D"UTF-8" ?> <BR>>> > <!= DOCTYPE generatorConfiguration PUBLIC "-//<A href=3D"http://mybatis.org//DT= D" target=3D_blank>mybatis.org//DTD</A> MyBatis <BR>>> > Generator= Configuration 1.0//EN" <BR>>> > "<A href=3D"http://mybatis.org/dt= d/mybatis-generator-config_1_0.dtd" target=3D_blank>http://mybatis.org/dtd/= <WBR>mybatis-generator-config_1_0.<WBR>dtd</A>" > <BR>>> > <= generatorConfiguration > <BR>>> > <context id=3D"cont= ext"> <BR>>> > <jdbcConnection driverClass=3D"= org.sqlite.JDBC" <BR>>> > connectionURL=3D"jdbc:sqlite:<WBR>testDB= .sqlite" userId=3D"" password=3D"" <BR>>> >></jdbcConnection= > <BR>>> > <javaModelGenerator targetPackage= =3D"model" targetProject=3D"test/src" <BR>>> >></javaModelGe= nerator> <BR>>> > <sqlMapGenerator targetPacka= ge=3D"model" targetProject=3D"test/src" <BR>>> >></sqlMapGen= erator> <BR>>> > <javaClientGenerator targetPa= ckage=3D"model" targetProject=3D"test" <BR>>> > type=3D"XMLMAPPER"= ></javaClientGenerator> <BR>>> > <table= tableName=3D"afloatplantest" > <BR>>> > <BR>>> > &nbs= p; <property name=3D"useActualColumnNames" value=3D"true"/= > <BR>>> > </table> <BR>>> >  = ; </context> <BR>>> > <BR>>> > <BR>>> > On= Friday, October 19, 2012 10:05:37 AM UTC-7, Jeff Butler wrote: <BR>>>= ; >> <BR>>> >> sqlite does not have catalogs - leave that= off. <BR>>> >> <BR>>> >> Only use the schema if yo= u create tables like schema.table_name. Else <BR>>> >> le= ave that off too. <BR>>> >> <BR>>> >> You probably = only need to specify the tableName. <BR>>> >> <BR>>> >= > Jeff Butler <BR>>> >> <BR>>> >> <BR>>> &= gt;> On Fri, Oct 19, 2012 at 12:10 PM, cha <<A>cha...@gmail.com</A>&g= t; wrote: <BR>>> >> > Hello, I am having a problem with MyBa= tis generator on sqlite. <BR>>> >> > When I try to generate,= I get <BR>>> >> > <BR>>> >> > "Generation Wa= rnings Occured <BR>>> >> > Table configuration with c= atalog main, schema sqlite_master, and <BR>>> >> > table <BR= >>> >> > testTable did not resolve to any tables" <BR>>&g= t; >> > <BR>>> >> > The table config that I am usin= g is <BR>>> >> > <BR>>> >> > <table catalo= g=3D"main" schema=3D"sqlite_master" tableName=3D"testTable" > <BR>>&g= t; >> > <property name=3D"useActualColumnN= ames" value=3D"true"/> <BR>>> >> > </tab= le> <BR>>> >> > <BR>>> >> > I have also tr= ied variations like <BR>>> >> > <BR>>> >> > &= lt;table catalog=3D"main" schema=3D"sqlite" tableName=3D"testTable" > <B= R>>> >> > <property name=3D"useActua= lColumnNames" value=3D"true"/> <BR>>> >> > = </table> <BR>>> >> > <BR>>> >> > <ta= ble schema=3D"sqlite" tableName=3D"testTable" > <BR>>> >> &g= t; <property name=3D"useActualColumnNames" value=3D= "true"/> <BR>>> >> > </table> <BR>>= ;> >> > <BR>>> >> > Has anyone used succesfully = used MyBatis generator with sqlite and <BR>>> >> > know <BR>= >> >> > the <BR>>> >> > schema settings? <BR>= </BLOCKQUOTE> ------=_Part_164_33545134.1351208262455-- ------=_Part_163_22543977.1351208262455--
Message from discussion MyBatis generator with sqlite gives "did not resolve to any tables"
| Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy |
| ©2013 Google |