Hello jflute さん。 I tried in java environment also.i am gettting same exception when i run the sql2entity command 2010-06-10 16:33:00,968 [main] INFO (DfAntTaskUtil#getBuildProperties():79) - ...Using contextProperties: build.properties 2010-06-10 16:33:01,015 [main] INFO (DfAntTaskUtil#getBuildProperties():122) - [Build-Properties]: size=7 2010-06-10 16:33:01,015 [main] INFO (DfAntTaskUtil#getBuildProperties():124) - torque.packageBase = testsqlserver.dbflute 2010-06-10 16:33:01,015 [main] INFO (DfAntTaskUtil#getBuildProperties():124) - torque.database = mssql 2010-06-10 16:33:01,015 [main] INFO (DfAntTaskUtil#getBuildProperties():124) - torque.s2daoVersion = 1.0.51 2010-06-10 16:33:01,015 [main] INFO (DfAntTaskUtil#getBuildProperties():124) - torque.targetLanguage = java 2010-06-10 16:33:01,031 [main] INFO (DfAntTaskUtil#getBuildProperties():124) - torque.project = tetsqlserver 2010-06-10 16:33:01,031 [main] INFO (DfAntTaskUtil#getBuildProperties():124) - torque.jdbcToJavaNativeMap = map:{TINYINT=java.lang.Integer;SMALLINT=java.lang.Integer;INTEGER=java.lang.Integer;BIGINT=java.lang.Long} 2010-06-10 16:33:01,031 [main] INFO (DfAntTaskUtil#getBuildProperties():124) - torque.targetContainer = seasar 2010-06-10 16:33:01,031 [main] INFO (DfAntTaskUtil#getBuildProperties():126) - 2010-06-10 16:33:01,234 [main] INFO (DfSimpleDataSourceCreator#create():73) - ...Creating data source: 2010-06-10 16:33:01,234 [main] INFO (DfSimpleDataSourceCreator#create():74) - driver = com.microsoft.sqlserver.jdbc.SQLServerDriver 2010-06-10 16:33:01,234 [main] INFO (DfSimpleDataSourceCreator#create():75) - url = jdbc:sqlserver://AGTNB15;DatabaseName=PMSDBPHASE2 2010-06-10 16:33:01,234 [main] INFO (DfSimpleDataSourceCreator#create():76) - user = sa 2010-06-10 16:33:06,062 [main] INFO (DfSql2EntityTask#setupControlTemplate():175) - 2010-06-10 16:33:06,062 [main] INFO (DfSql2EntityTask#setupControlTemplate():176) - * * * * * * * * * 2010-06-10 16:33:06,062 [main] INFO (DfSql2EntityTask#setupControlTemplate():177) - * Process Java * 2010-06-10 16:33:06,062 [main] INFO (DfSql2EntityTask#setupControlTemplate():178) - * * * * * * * * * 2010-06-10 16:33:06,062 [main] INFO (DfSql2EntityTask#setupControlTemplate():180) - ...Using Java control: om/ControlSql2EntityJava.vm 2010-06-10 16:33:06,187 [main] INFO (DTDResolver#resolveEntity():124) - Resolver: used database.dtd from 'org.apache.torque.engine.database.transform' package 2010-06-10 16:33:07,703 [main] INFO (DfSqlFileFireMan#execute():64) - {SQL File}: ..\src\main\resources\data\demo.sql 2010-06-10 16:33:07,765 [main] INFO (DfSql2EntityTask$1#traceResult():490) - --> SQL for sql2entity was Not Found in the SQL file! 2010-06-10 16:33:07,765 [main] INFO (DfSqlFileFireMan#execute():80) - {Fired SQL}: success=0 failure=0 (in 1 files) 2010-06-10 16:33:08,328 [main] INFO (DfAbstractTexenTask#fireVelocityProcess():359) - generator.parse("om/ControlSql2EntityJava.vm", c); 2010-06-10 16:33:08,656 [main] INFO (Database#enableSql2EntityOutputDirectory():640) - ...Setting up sql2EntityOutputDirectory: ../src/main/java 2010-06-10 16:33:08,687 [main] INFO (DfOldClassHandler#info():557) - 2010-06-10 16:33:08,687 [main] INFO (DfOldClassHandler#info():557) - // /- - - - - - - - - - - - - - - 2010-06-10 16:33:08,703 [main] INFO (DfOldClassHandler#info():557) - // Delete old customize classes! 2010-06-10 16:33:08,703 [main] INFO (DfOldClassHandler#info():557) - // - - - - - - - - - -/ 2010-06-10 16:33:08,734 [main] INFO (DfOldClassHandler#info():557) - 2010-06-10 16:33:08,734 [main] DEBUG (Database#debug():1885) - public void parseCustomizeEntity() { 2010-06-10 16:33:08,734 [main] DEBUG (Database#debug():1885) - final List<String> tableNameList = getTableList(); 2010-06-10 16:33:08,750 [main] DEBUG (Database#debug():1885) - for (String tableName : tableNameList) { 2010-06-10 16:33:08,750 [main] DEBUG (Database#debug():1885) - } 2010-06-10 16:33:08,750 [main] DEBUG (Database#debug():1885) - } 2010-06-10 16:33:09,062 [main] INFO (DfAbstractTexenTask#showTargetSqlFileInformation():687) - /- - - - - - - - - - - - - - - - - - - - - - - - 2010-06-10 16:33:09,062 [main] INFO (DfAbstractTexenTask#showTargetSqlFileInformation():688) - Target SQL files: 1 2010-06-10 16:33:09,062 [main] INFO (DfAbstractTexenTask#showTargetSqlFileInformation():689) - 2010-06-10 16:33:09,062 [main] INFO (DfAbstractTexenTask#showTargetSqlFileInformation():691) - demo.sql 2010-06-10 16:33:09,062 [main] INFO (DfAbstractTexenTask#showTargetSqlFileInformation():693) - - - - - - - - - - -/ 2010-06-10 16:33:09,062 [main] INFO (DfAbstractTexenTask#showTargetSqlFileInformation():694) - 2010-06-10 16:33:09,062 [main] INFO (DfAbstractTexenTask#showSkippedFileInformation():720) - /- - - - - - - - - - - - - - - - - - - - - - - - 2010-06-10 16:33:09,062 [main] INFO (DfAbstractTexenTask#showSkippedFileInformation():721) - No class file has been parsed. 2010-06-10 16:33:09,062 [main] INFO (DfAbstractTexenTask#showSkippedFileInformation():722) - - - - - - - - - - -/ 2010-06-10 16:33:09,078 [main] INFO (DfAbstractTexenTask#showSkippedFileInformation():723) - 2010-06-10 16:33:09,078 [main] WARN (DfSql2EntityTask#handleNotFoundResult():535) - /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 2010-06-10 16:33:09,078 [main] WARN (DfSql2EntityTask#handleNotFoundResult():536) - SQL for sql2entity was not found! 2010-06-10 16:33:09,078 [main] WARN (DfSql2EntityTask#handleNotFoundResult():537) - 2010-06-10 16:33:09,078 [main] WARN (DfSql2EntityTask#handleNotFoundResult():538) - SQL Files: 1 2010-06-10 16:33:09,078 [main] WARN (DfSql2EntityTask#handleNotFoundResult():542) - 1 -- ..\src\main\resources\data\demo.sql 2010-06-10 16:33:09,078 [main] WARN (DfSql2EntityTask#handleNotFoundResult():544) - * * * * * * * * * */ 2010-06-10 16:33:09,078 [main] WARN (DfSql2EntityTask#handleNotFoundResult():545) - 2010-06-10 16:33:09,078 [main] INFO (DfSimpleDataSourceCreator#commit():88) - ...commit() 2010-06-10 16:33:09,093 [main] INFO (DfSimpleDataSourceCreator#destroy():112) - ...rollback() 2010-06-10 16:33:09,093 [main] INFO (DfSimpleDataSourceCreator#destroy():116) - ...closeReally() 2010-06-10 16:33:09,093 [main] INFO (DfAbstractTexenTask#showFinalMessage():215) - _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ [Task End]: 00m08s031ms DBFLUTE_CLIENT: {tetsqlserver} database = mssql language = java container = seasar package = testsqlserver.dbflute DBFLUTE_ENVIRONMENT_TYPE: {df:default} driver = com.microsoft.sqlserver.jdbc.SQLServerDriver url = jdbc:sqlserver://AGTNB15;DatabaseName=PMSDBPHASE2 schema = {PMSDBPHASE2.dbo as main} user = sa props = {} additionalSchema = dataLoadingType = ut refreshProject = _/_/_/_/_/_/_/_/_/_/ {Sql2Entity} 2010-06-10 16:34:20,625 [main] INFO (DfAntTaskUtil#getBuildProperties():79) - ...Using contextProperties: build.properties 2010-06-10 16:34:20,640 [main] INFO (DfAntTaskUtil#getBuildProperties():122) - [Build-Properties]: size=7 2010-06-10 16:34:20,640 [main] INFO (DfAntTaskUtil#getBuildProperties():124) - torque.packageBase = testsqlserver.dbflute 2010-06-10 16:34:20,640 [main] INFO (DfAntTaskUtil#getBuildProperties():124) - torque.database = mssql 2010-06-10 16:34:20,640 [main] INFO (DfAntTaskUtil#getBuildProperties():124) - torque.s2daoVersion = 1.0.51 2010-06-10 16:34:20,640 [main] INFO (DfAntTaskUtil#getBuildProperties():124) - torque.targetLanguage = java 2010-06-10 16:34:20,640 [main] INFO (DfAntTaskUtil#getBuildProperties():124) - torque.project = tetsqlserver 2010-06-10 16:34:20,640 [main] INFO (DfAntTaskUtil#getBuildProperties():124) - torque.jdbcToJavaNativeMap = map:{TINYINT=java.lang.Integer;SMALLINT=java.lang.Integer;INTEGER=java.lang.Integer;BIGINT=java.lang.Long} 2010-06-10 16:34:20,671 [main] INFO (DfAntTaskUtil#getBuildProperties():124) - torque.targetContainer = seasar 2010-06-10 16:34:20,671 [main] INFO (DfAntTaskUtil#getBuildProperties():126) - 2010-06-10 16:34:20,750 [main] INFO (DfSimpleDataSourceCreator#create():73) - ...Creating data source: 2010-06-10 16:34:20,750 [main] INFO (DfSimpleDataSourceCreator#create():74) - driver = com.microsoft.sqlserver.jdbc.SQLServerDriver 2010-06-10 16:34:20,750 [main] INFO (DfSimpleDataSourceCreator#create():75) - url = jdbc:sqlserver://AGTNB15;DatabaseName=PMSDBPHASE2 2010-06-10 16:34:20,750 [main] INFO (DfSimpleDataSourceCreator#create():76) - user = sa 2010-06-10 16:34:21,375 [main] INFO (DfSql2EntityTask#setupControlTemplate():175) - 2010-06-10 16:34:21,375 [main] INFO (DfSql2EntityTask#setupControlTemplate():176) - * * * * * * * * * 2010-06-10 16:34:21,375 [main] INFO (DfSql2EntityTask#setupControlTemplate():177) - * Process Java * 2010-06-10 16:34:21,375 [main] INFO (DfSql2EntityTask#setupControlTemplate():178) - * * * * * * * * * 2010-06-10 16:34:21,375 [main] INFO (DfSql2EntityTask#setupControlTemplate():180) - ...Using Java control: om/ControlSql2EntityJava.vm 2010-06-10 16:34:21,406 [main] INFO (DTDResolver#resolveEntity():124) - Resolver: used database.dtd from 'org.apache.torque.engine.database.transform' package 2010-06-10 16:34:22,109 [main] INFO (DfSqlFileFireMan#execute():64) - {SQL File}: ..\src\main\resources\data\demo.sql 2010-06-10 16:34:22,125 [main] INFO (DfSql2EntityTask$1#traceResult():490) - --> SQL for sql2entity was Not Found in the SQL file! 2010-06-10 16:34:22,125 [main] INFO (DfSqlFileFireMan#execute():80) - {Fired SQL}: success=0 failure=0 (in 1 files) 2010-06-10 16:34:22,125 [main] INFO (DfSql2EntityTask#doSetupProcedure():639) - 2010-06-10 16:34:22,125 [main] INFO (DfSql2EntityTask#doSetupProcedure():640) - ...Setting up procedures for generating parameter-beans 2010-06-10 16:34:24,390 [main] ERROR (DfAntTaskUtil#logException():155) - Look! Read the message below. /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * Failed to execute DBFlute Task 'Sql2Entity'! [Exception] exception class = class java.lang.NumberFormatException * * * * * * * * * */ java.lang.NumberFormatException: null at java.lang.Integer.parseInt(Integer.java:415) at java.lang.Integer.parseInt(Integer.java:497) at com.microsoft.sqlserver.jdbc.IntColumnFilter.apply(SQLServerDatabaseMetaData.java:2016) at com.microsoft.sqlserver.jdbc.Column.getValue(Column.java:114) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:1820) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:1805) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getString(SQLServerResultSet.java:2123) at org.seasar.dbflute.logic.jdbc.handler.DfProcedureHandler.setupProcedureColumnMetaInfo(DfProcedureHandler.java:456) at org.seasar.dbflute.logic.jdbc.handler.DfProcedureHandler.getPlainProcedureList(DfProcedureHandler.java:335) at org.seasar.dbflute.logic.jdbc.handler.DfProcedureHandler.getAvailableProcedureMap(DfProcedureHandler.java:97) at org.seasar.dbflute.logic.jdbc.handler.DfProcedureHandler.getAvailableProcedureList(DfProcedureHandler.java:77) at org.seasar.dbflute.task.DfSql2EntityTask.getAvailableProcedureList(DfSql2EntityTask.java:723) at org.seasar.dbflute.task.DfSql2EntityTask.doSetupProcedure(DfSql2EntityTask.java:641) at org.seasar.dbflute.task.DfSql2EntityTask.setupProcedure(DfSql2EntityTask.java:618) at org.seasar.dbflute.task.DfSql2EntityTask.doExecute(DfSql2EntityTask.java:134) at org.seasar.dbflute.task.bs.DfAbstractTexenTask.execute(DfAbstractTexenTask.java:114) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329) at org.apache.tools.ant.Project.executeTarget(Project.java:1298) at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41) at org.apache.tools.ant.Project.executeTargets(Project.java:1181) at org.apache.tools.ant.Main.runBuild(Main.java:698) at org.apache.tools.ant.Main.startAnt(Main.java:199) at org.apache.tools.ant.launch.Launcher.run(Launcher.java:257) at org.apache.tools.ant.launch.Launcher.main(Launcher.java:104) 2010-06-10 16:34:24,468 [main] INFO (DfSimpleDataSourceCreator#commit():88) - ...commit() 2010-06-10 16:34:24,468 [main] INFO (DfSimpleDataSourceCreator#destroy():112) - ...rollback() 2010-06-10 16:34:24,468 [main] INFO (DfSimpleDataSourceCreator#destroy():116) - ...closeReally() 2010-06-10 16:34:24,484 [main] INFO (DfAbstractTexenTask#showFinalMessage():215) - _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ [Task End]: 00m03s781ms *Abort DBFLUTE_CLIENT: {tetsqlserver} database = mssql language = java container = seasar package = testsqlserver.dbflute DBFLUTE_ENVIRONMENT_TYPE: {df:default} driver = com.microsoft.sqlserver.jdbc.SQLServerDriver url = jdbc:sqlserver://AGTNB15;DatabaseName=PMSDBPHASE2 schema = {PMSDBPHASE2.dbo as main} user = sa props = {} additionalSchema = dataLoadingType = ut refreshProject = _/_/_/_/_/_/_/_/_/_/ {Sql2Entity} >>Tell me what kind of JDBC driver you use i am using sqljdbc4.jar driver Thanks, Thomas. <div class="gmail_quote">2010/6/10 kubo <<a href="mailto:dbflute@gmail.com">dbflute@gmail.com</a>> <blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"> Hello, You cannot call your procedure that returns result set through DBFlute.NET. // the handler of procedure on DBFlute.NET // (if data reader, throws NotImplementedException) <a href="https://www.seasar.org/svn/sandbox/dbflute.net/trunk/dfnet-basic-example/source/DfExample/DBFlute/AllCommon/S2Dao/internal/SqlHandler/InternalProcedureHandler.cs" target="_blank">https://www.seasar.org/svn/sandbox/dbflute.net/trunk/dfnet-basic-example/source/DfExample/DBFlute/AllCommon/S2Dao/internal/SqlHandler/InternalProcedureHandler.cs</a> Sorry it's the very one of difference from DBFlute for Java. <div class="im"> > Is there any other way to call my stored procedures? </div>You can call it through <a href="http://ADO.NET" target="_blank">ADO.NET</a>. Get an instance of IDataSource from Quill container that is same as the data source DBFlute.NET uses, and you can use <a href="http://ADO.NET" target="_blank">ADO.NET</a> directly. Thanks jflute <div><div></div><div class="h5">_______________________________________________ seasar-dotnet mailing list <a href="mailto:seasar-dotnet@ml.seasar.org">seasar-dotnet@ml.seasar.org</a> <a href="https://ml.seasar.org/mailman/listinfo/seasar-dotnet" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-dotnet</a> </div></div></blockquote></div>