/Users/sdedmands/Development/workspace_MySQL/LabManager/war/dsdmi/sc/system/reference/inlineExamples/serverExamples/hibernate/queuing, checking project-wide area === 2010-08-18 19:29:49,663 [l0-2] WARN BuiltinRPC - Couldn't load config-defined datasource: queuing_order === 2010-08-18 19:29:49,663 [l0-2] DEBUG BuiltinRPC - Loading DS: cartItem === 2010-08-18 19:29:49,663 [l0-2] WARN DataStructCache - File cartItem.ds not found at explicitly specified location /Users/sdedmands/Development/workspace_MySQL/LabManager/war/dsdmi/sc/system/reference/inlineExamples/serverExamples/sql/userSpecificData, checking project-wide area === 2010-08-18 19:29:49,663 [l0-2] WARN BuiltinRPC - Couldn't load config-defined datasource: cartItem === 2010-08-18 19:29:49,663 [l0-2] DEBUG BuiltinRPC - Loading DS: dynamicReporting_orderItem === 2010-08-18 19:29:49,664 [l0-2] WARN DataStructCache - File dynamicReporting_orderItem.ds not found at explicitly specified location /Users/sdedmands/Development/workspace_MySQL/LabManager/war/dsdmi/sc/system/reference/inlineExamples/serverExamples/sql/dynamicReporting, checking project-wide area === 2010-08-18 19:29:49,664 [l0-2] WARN BuiltinRPC - Couldn't load config-defined datasource: dynamicReporting_orderItem === 2010-08-18 19:29:49,664 [l0-2] DEBUG BuiltinRPC - Loading DS: ormDataSource_country === 2010-08-18 19:29:49,664 [l0-2] WARN DataStructCache - File ormDataSource_country.ds not found at explicitly specified location /Users/sdedmands/Development/workspace_MySQL/LabManager/war/dsdmi/sc/system/reference/inlineExamples/serverExamples/other/ormDataSource, checking project-wide area === 2010-08-18 19:29:49,664 [l0-2] WARN BuiltinRPC - Couldn't load config-defined datasource: ormDataSource_country === 2010-08-18 19:29:49,664 [l0-2] DEBUG BuiltinRPC - Loading DS: masterDetail_orderItemHB === 2010-08-18 19:29:49,664 [l0-2] WARN DataStructCache - File masterDetail_orderItemHB.ds not found at explicitly specified location /Users/sdedmands/Development/workspace_MySQL/LabManager/war/dsdmi/sc/system/reference/inlineExamples/serverExamples/hibernate/masterDetail, checking project-wide area === 2010-08-18 19:29:49,664 [l0-2] WARN BuiltinRPC - Couldn't load config-defined datasource: masterDetail_orderItemHB === 2010-08-18 19:29:49,664 [l0-2] DEBUG RPCDMI - rpc returned RPCResponse === 2010-08-18 19:29:49,664 [l0-2] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8 === 2010-08-18 19:29:49,665 [l0-2] INFO Compression - /dsdmi/tools/adminConsoleOperations.jsp: 4768 -> 1044 bytes === 2010-08-18 19:29:57,219 [l0-2] INFO RequestContext - URL: '/dsdmi/tools/adminConsoleOperations.jsp', User-Agent: 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_6_4; en-us) AppleWebKit/533.17.8 (KHTML, like Gecko) Version/5.0.1 Safari/533.17.8': Safari with Accept-Encoding header === 2010-08-18 19:29:57,225 [l0-2] DEBUG XML - Parsed XML from (in memory stream): 1ms === 2010-08-18 19:29:57,226 [l0-2] DEBUG RPCManager - Processing 1 requests. === 2010-08-18 19:29:57,233 [l0-2] DEBUG RPCManager - Request #1 (DSRequest) payload: { appID:"builtinApplication", operation:"cat2_loadSchema", values:{ }, criteria:{ } } === 2010-08-18 19:29:57,237 [l0-2] DEBUG AppBase - [builtinApplication.cat2_loadSchema] No userTypes defined, allowing anyone access to all operations for this application === 2010-08-18 19:29:57,238 [l0-2] DEBUG AppBase - [builtinApplication.cat2_loadSchema] No public zero-argument method named '_cat2_loadSchema' found, performing generic datasource operation === 2010-08-18 19:29:57,239 [l0-2] INFO DSResponse - [builtinApplication.cat2_loadSchema] DSResponse: List with 1 items === 2010-08-18 19:29:57,239 [l0-2] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8 === 2010-08-18 19:29:57,239 [l0-2] DEBUG RPCManager - non-DMI response, dropExtraFields: false === 2010-08-18 19:29:57,241 [l0-2] INFO Compression - /dsdmi/tools/adminConsoleOperations.jsp: 881 -> 354 bytes === 2010-08-18 19:29:57,343 [l0-2] INFO RequestContext - URL: '/dsdmi/tools/adminConsoleOperations.jsp', User-Agent: 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_6_4; en-us) AppleWebKit/533.17.8 (KHTML, like Gecko) Version/5.0.1 Safari/533.17.8': Safari with Accept-Encoding header === 2010-08-18 19:29:57,348 [l0-2] DEBUG XML - Parsed XML from (in memory stream): 1ms === 2010-08-18 19:29:57,350 [l0-2] DEBUG RPCManager - Processing 1 requests. === 2010-08-18 19:29:57,350 [l0-2] DEBUG RPCManager - Request #1 (DSRequest) payload: { criteria:{ }, operationConfig:{ dataSource:"cat2", operationType:"fetch", textMatchStyle:"exact" }, startRow:0, endRow:75, componentId:"isc_DBConsole_0_dsImporter_dsContents", appID:"builtinApplication", operation:"cat2_fetch", oldValues:{ } } === 2010-08-18 19:29:57,351 [l0-2] DEBUG AppBase - [builtinApplication.cat2_fetch] No userTypes defined, allowing anyone access to all operations for this application === 2010-08-18 19:29:57,351 [l0-2] DEBUG AppBase - [builtinApplication.cat2_fetch] No public zero-argument method named '_cat2_fetch' found, performing generic datasource operation === 2010-08-18 19:29:57,352 [l0-2] INFO SQLDataSource - [builtinApplication.cat2_fetch] Performing fetch operation with criteria: {} values: {} === 2010-08-18 19:29:57,358 [l0-2] INFO SQLWhereClause - [builtinApplication.cat2_fetch] empty condition === 2010-08-18 19:29:57,360 [l0-2] INFO SQLDataSource - [builtinApplication.cat2_fetch] derived query: SELECT $defaultSelectClause FROM $defaultTableClause WHERE $defaultWhereClause === 2010-08-18 19:29:57,439 [l0-2] DEBUG SQLDataSource - [builtinApplication.cat2_fetch] Executing row count query: SELECT COUNT(*) FROM $defaultTableClause WHERE $defaultWhereClause === 2010-08-18 19:29:57,439 [l0-2] DEBUG SQLDataSource - [builtinApplication.cat2_fetch] Eval'd row count query: SELECT COUNT(*) FROM catalogs2 WHERE ('1'='1') === 2010-08-18 19:29:57,440 [l0-2] DEBUG PoolableSQLConnectionFactory - [builtinApplication.cat2_fetch] DriverManager fetching connection for Mysql via jdbc url jdbc:MySQL://localhost:3306/LabManager?user=Manager&password=22metallo22 === 2010-08-18 19:29:57,440 [l0-2] DEBUG PoolableSQLConnectionFactory - [builtinApplication.cat2_fetch] Passing JDBC URL only to getConnection === 2010-08-18 19:29:57,451 [l0-2] DEBUG PoolableSQLConnectionFactory - [builtinApplication.cat2_fetch] Returning pooled Connection === 2010-08-18 19:29:57,452 [l0-2] INFO SQLDriver - [builtinApplication.cat2_fetch] Executing SQL query on 'Mysql': SELECT COUNT(*) FROM catalogs2 WHERE ('1'='1') === 2010-08-18 19:29:57,459 [l0-2] INFO SQLDriver - [builtinApplication.cat2_fetch] Execute of select: SELECT COUNT(*) FROM catalogs2 WHERE ('1'='1') on db: Mysql threw exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'labmanager.catalogs2' doesn't exist - assuming stale connection and retrying query. === 2010-08-18 19:29:57,459 [l0-2] DEBUG PoolableSQLConnectionFactory - [builtinApplication.cat2_fetch] DriverManager fetching connection for Mysql via jdbc url jdbc:MySQL://localhost:3306/LabManager?user=Manager&password=22metallo22 === 2010-08-18 19:29:57,459 [l0-2] DEBUG PoolableSQLConnectionFactory - [builtinApplication.cat2_fetch] Passing JDBC URL only to getConnection === 2010-08-18 19:29:57,493 [l0-2] DEBUG PoolableSQLConnectionFactory - [builtinApplication.cat2_fetch] Returning pooled Connection === 2010-08-18 19:29:58,709 [l0-2] INFO RequestContext - URL: '/dsdmi/tools/adminConsoleOperations.jsp', User-Agent: 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_6_4; en-us) AppleWebKit/533.17.8 (KHTML, like Gecko) Version/5.0.1 Safari/533.17.8': Safari with Accept-Encoding header === 2010-08-18 19:29:58,712 [l0-2] DEBUG XML - Parsed XML from (in memory stream): 1ms === 2010-08-18 19:29:58,713 [l0-2] DEBUG RPCManager - Processing 1 requests. === 2010-08-18 19:29:58,713 [l0-2] DEBUG RPCManager - Request #1 (RPCRequest) data: { appID:"isc_builtin", className:"com.isomorphic.tools.AdminConsole", methodName:"importDataSources", arguments:[ [ "cat2" ], true, true ], is_ISC_RPC_DMI:true } === 2010-08-18 19:29:58,714 [l0-2] DEBUG RPCDMI - appConfig: isc.Application.create({ rpcBindings:[ { ID:"builtin", className:"com.isomorphic.rpc.BuiltinRPC", visibleMethods:[ { name:"downloadWSDL" }, { name:"downloadClientContent" }, { name:"downloadClientExport" }, { name:"xmlToJS" }, { name:"uploadProgressCheck" }, { name:"saveFile" }, { name:"appendToFile" }, { name:"loadFile" }, { name:"deleteFile" }, { name:"loadSharedXML" }, { name:"saveSharedXML" }, { name:"getAvailableScriptEngines" }, { name:"devConsoleEvalServerScript" }, { name:"evalJava" }, { name:"getLogNames" }, { name:"getLogEntries" }, { name:"getLogThresholds" }, { name:"setLogThreshold" } ] }, { ID:"builtin_tools", className:"com.isomorphic.tools.BuiltinRPC", visibleMethods:[ { name:"getDataSourceFromTable" }, { name:"getDataSourceJSONFromTable" }, { name:"getDataSourceFromHibernateMapping" }, { name:"getDataSourceJSONFromHibernateMapping" }, { name:"getTables" }, { name:"getFieldsFromTable" }, { name:"getBeanFields" }, { name:"getHibernateBeans" }, { name:"getDatabaseProductNameAndVersion" }, { name:"getDatabaseTableTypes" }, { name:"setAttributes" }, { name:"clearAttributes" }, { name:"getAttributes" }, { name:"getAttribute" }, { name:"getDataSourceConfigFromJavaClass" }, { args:"cName", language:"groovy", name:"getJavaSource", script:"\n if (!com.isomorphic.auth.DevModeAuthFilter.devModeAuthorized(request)) throw new Exception(\"Not Authorized\"); \n //import org.apache.bcel.Repository;\n\n try {\n return org.apache.bcel.Repository.lookupClass(cName).toString();\n } catch (Throwable e) {\n return \"Unable to reverse engineer class \"+cName+\": \"+e.getMessage();\n }\n " }, { name:"loadDataSource" }, { name:"dsFromXML" }, { name:"dsConfigFromXML" }, { name:"getDefinedDataSources" } ] }, { ID:"builtin_adminconsole", className:"com.isomorphic.tools.AdminConsole", visibleMethods:[ { name:"getDefinedDatabases" }, { name:"testDB" }, { name:"saveDBConfig" }, { name:"setDefaultDB" }, { name:"importDataSources" } ] } ] }) === 2010-08-18 19:29:58,715 [l0-2] DEBUG PoolableSQLConnectionFactory - deleted password === 2010-08-18 19:29:58,715 [l0-2] DEBUG PoolableSQLConnectionFactory - Passing JDBC URL only to getConnection === 2010-08-18 19:29:58,729 [l0-2] DEBUG PoolableSQLConnectionFactory - Returning pooled Connection === 2010-08-18 19:29:58,730 [l0-2] DEBUG SQLImport - Creating constraint of type PRIMARY KEY on fields [cat2ID] === 2010-08-18 19:29:58,730 [l0-2] DEBUG PoolableSQLConnectionFactory - DriverManager fetching connection for Mysql via jdbc url jdbc:MySQL://localhost:3306/LabManager?user=Manager&password=22metallo22 === 2010-08-18 19:29:58,730 [l0-2] DEBUG PoolableSQLConnectionFactory - Passing JDBC URL only to getConnection === 2010-08-18 19:29:58,738 [l0-2] DEBUG PoolableSQLConnectionFactory - Returning pooled Connection === 2010-08-18 19:29:58,738 [l0-2] INFO SQLDriver - Executing SQL update on 'Mysql': DROP TABLE catalogs2 === 2010-08-18 19:29:58,750 [l0-2] INFO SQLDriver - Execute of update: DROP TABLE catalogs2 on db: Mysql threw exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'catalogs2' - assuming stale connection and retrying update. === 2010-08-18 19:29:58,750 [l0-2] DEBUG PoolableSQLConnectionFactory - DriverManager fetching connection for Mysql via jdbc url jdbc:MySQL://localhost:3306/LabManager?user=Manager&password=22metallo22 === 2010-08-18 19:29:58,750 [l0-2] DEBUG PoolableSQLConnectionFactory - Passing JDBC URL only to getConnection === 2010-08-18 19:29:58,755 [l0-2] DEBUG PoolableSQLConnectionFactory - Returning pooled Connection === 2010-08-18 19:29:58,756 [l0-2] ERROR BuiltinRPC - There was a problem importing datasource 'cat2'. The error report below may indicate what the problem was. java.lang.NullPointerException at com.isomorphic.sql.SQLDriver.doUpdate(SQLDriver.java:442) at com.isomorphic.sql.SQLDriver.doUpdate(SQLDriver.java:435) at com.isomorphic.sql.SQLDriver.update(SQLDriver.java:423) at com.isomorphic.sql.SQLDriver.executeUpdate(SQLDriver.java:522) at com.isomorphic.sql.SQLDataSource.executeNativeUpdate(SQLDataSource.java:360) at com.isomorphic.tools.SQLImport.processSQLDataSource(SQLImport.java:452) at com.isomorphic.tools.SQLImport.processDataSource(SQLImport.java:235) at com.isomorphic.tools.AdminConsole.importDataSources(AdminConsole.java:293) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.isomorphic.base.Reflection.adaptArgsAndInvoke(Reflection.java:879) at com.isomorphic.base.Reflection.adaptArgsAndInvoke(Reflection.java:734) at com.isomorphic.rpc.RPCDMI.execute(RPCDMI.java:305) at com.isomorphic.rpc.RPCDMI.execute(RPCDMI.java:66) at org.apache.jsp.dsdmi.tools.adminConsoleOperations_jsp._jspService(adminConsoleOperations_jsp.java:93) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1097) at com.isomorphic.servlet.CompressionFilter.doFilter(CompressionFilter.java:259) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1088) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:729) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.handler.RequestLogHandler.handle(RequestLogHandler.java:49) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:324) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:843) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:647) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:488) === 2010-08-18 19:29:58,756 [l0-2] DEBUG RPCDMI - rpc returned RPCResponse === 2010-08-18 19:29:58,756 [l0-2] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8 === 2010-08-18 19:29:58,756 [l0-2] INFO Compression - /dsdmi/tools/adminConsoleOperations.jsp: 3462 -> 947 bytes === 2010-08-18 19:30:19,379 [l0-2] INFO Download - Returning 304: Not modified on conditional get of: /Users/sdedmands/Development/workspace_MySQL/LabManager/war/dsdmi/sc/system/development/ISC_ServerLogViewer.js === 2010-08-18 19:30:19,420 [l0-2] INFO RequestContext - URL: '/dsdmi/sc/IDACall', User-Agent: 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_6_4; en-us) AppleWebKit/533.17.8 (KHTML, like Gecko) Version/5.0.1 Safari/533.17.8': Safari with Accept-Encoding header === 2010-08-18 19:30:19,426 [l0-2] INFO Compression - /dsdmi/sc/IDACall: 81 -> 86 bytes === 2010-08-18 19:30:19,480 [l0-2] INFO RequestContext - URL: '/dsdmi/sc/IDACall', User-Agent: 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_6_4; en-us) AppleWebKit/533.17.8 (KHTML, like Gecko) Version/5.0.1 Safari/533.17.8': Safari with Accept-Encoding header